Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [udig-devel] ArcSDE - Connection fun ... 
Jody Garnett wrote:


Carl Anderson wrote:


Jody Garnett wrote:


Carl Anderson wrote:


I can send the gml file upon request.
A snipit would be cool - what is *really* important is the XML Schema (aka DescribeFetureType) result that GeoServer kicks out - the uDig parser uses that to figure out what is going on.... 


Is this Ok?


Yes - and better yet it answer the problem!

<?xml version="1.0" ?>
<ServiceExceptionReport
  version="1.2.0"
  xmlns="http://www.opengis.net/ogc";
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://www.opengis.net/ogc http://rivertown.gis.fc:8080/geoserver/data/capabilities//wfs/1.0.0/OGC-exception.xsd";> 
  <ServiceException>
java.util.NoSuchElementException: Could not locate FeatureTypeConfig &apos;fultongis:GIS.DBO.Centerline&apos; </ServiceException> 
</ServiceExceptionReport>
So we got a service exception back - we need a valid XMLSchema document ... I think GeoServer either is set up wrong, or has a bug with respect to ArcSDE support. Let's look at the data ... 

I am not the slickest at this stuff - let me give it a go:
- xmlns:gml defined pointing to www.opengis.net/gml which is mapped to ... nothing? - xmlns:wfs defined pointing to www.opengis.net/gml which is mapped to http://rivertown.gis.fc:8080/geoserver/data/capabilities/wfs/1.0.0/WFS-basic.xsd - xmlns.xs defined pointing to http://www.w3.org/2001/XMLSchema-instance mapped to ... nothing - xmlns:fultongis defined pointing to http://wfs.co.fulton.ga.us/ which maps to our DescribeFeatureType request ...
http://rivertown.gis.fc:8080/geoserver/wfs/DescribeFeatureType?typeName=fultongis:GIS.DBO.CENTERLINE
Now I cannot hit that with a browser - whcih means uDig could not function (or your site is down right now?). Is your GeoServer on an intranet?
yes our SDE is behind several firewalls. We export all data to postgis for public services.
Next up we got a real problem ... your data is using "gml:" as its prefix (ie <gml:CITY_CODE>) but that prefix does not point to your DescribeFeatureType request ...
Did you accidentally set up your GeoServer with a "gml" prefix? And then set up your ArcSDE to use it? 

Here is a sample of the the content ....


Jody, first thanks for the look over..
Based on a couple of tests it seems to be an issue with GeoServer and not UDIG. 

I am using GeoServer 1.3.0-RC6
I created a custom schema type in GeoServer for this layer using the FeatureType editor webpages but GeoServer will not use the new schema. I looked in data/featureTypes/fcsde_GIS.DBO.CENTERLINE/schema.xml and the new schema is correct there.
Suspecting an issue with the dots "." in the name I tried to create a shapefile datastore 
       DS_test.roads
based on DS_tiger_roads pointing to file:data/demo/popup_map/data/tiger_roads.shp and got 


   HTTP ERROR: 500 BeanUtils%2Epopulate

RequestURI=/geoserver/config/data/storeSubmit.do

when submitting

I then checked for issues with featuretypes with dots in them

I copied tiger_roads.shp, and shx,dbf,qix to
   test.roads.shp shx,dbf,qix
in the demo data directory on the GeoServer
and created a DataStore DS_tet_roads pointing to the test shapefile (no problem so far) 
while creating FeatureType
    I did not find
 DS_test_roads:::test.roads
       as I had hoped but found
 DS_test_roads:::test
       instead.

I tried DS_test_roads::test  anyway and got an error

   * File either doesn't exist or is unreadable :
     data/demo/popup_map/data/test.roads.shp
This issue will appear when adding schema support to the PostGIS backend of GeoServer so some planning might be necessary. 

Thinking about
The string representation of a SDE data layer is <DB>.<Schema>.<Table>. As SDE can only represent a single geometric datatype per table there is no need to identify the column name. But you can have the tables 
  GIS.DBO.CENTERLINE
and
  GIS.CARL.CENTERLINE
and
  SDE.WORK.CENTERLINE
all at the same time.

In PostGIS a table can have several geometry columns in the same table.
  mine.centerline(the_geom)
and
  mine.centerline(simpler_geom)
I have had a desire to hack that up for sometime now, but it will be at least January before I can even get started. 

C.



<?xml version="1.0" encoding="UTF-8"?>
 <wfs:FeatureCollection
       xmlns:wfs="http://www.opengis.net/wfs";
       xmlns:gml="http://www.opengis.net/gml";
       xmlns:fultongis="http://wfs.co.fulton.ga.us/";
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://wfs.co.fulton.ga.us/ http://rivertown.gis.fc:8080/geoserver/wfs/DescribeFeatureType?typeName=fultongis:GIS.DBO.CENTERLINE http://www.opengis.net/wfs http://rivertown.gis.fc:8080/geoserver/data/capabilities/wfs/1.0.0/WFS-basic.xsd";> 

<gml:boundedBy>
   <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#2240";>
<gml:coordinates xmlns:gml="http://www.opengis.net/gml"; decimal="." cs="," ts=" ">2117527.25002385,1310039.74993582 2178173.25004526,1335490.7500073</gml:coordinates> 
   </gml:Box>
</gml:boundedBy>
<gml:featureMember>
 <gml:GIS.DBO.CENTERLINE fid="GIS.DBO.CENTERLINE.745">
 <gml:OBJECTID>745</gml:OBJECTID>
 <gml:STR_LBL>TWIN LAKES DR</gml:STR_LBL>
 <gml:FULL_NAME>LAKES TRACE</gml:FULL_NAME>
 <gml:CITY_CODE>55.0</gml:CITY_CODE>
 <gml:PATH_ID>0.0</gml:PATH_ID>
 <gml:SYSTEM_ID>105045.0</gml:SYSTEM_ID>
 <gml:DIRECTION> </gml:DIRECTION>
 <gml:ARC_ID>44250.0</gml:ARC_ID>
 <gml:GEO_OID>44248.0</gml:GEO_OID>
 <gml:FADDR_TYPE>y</gml:FADDR_TYPE>
 <gml:TADDR_TYPE>II</gml:TADDR_TYPE>
 <gml:OWNERSHIP>pn</gml:OWNERSHIP>
<gml:DATA_SRC>8.0</gml:DATA_SRC>
<gml:SUNSET>9.9991231E7</gml:SUNSET>
<gml:SUNRISE>0.0</gml:SUNRISE>
<gml:METHOD> </gml:METHOD>
<gml:A>0.0</gml:A>
<gml:B>0.0</gml:B>
<gml:PATH_TYPE>m</gml:PATH_TYPE>
<gml:ACTION> </gml:ACTION>
<gml:PLAT_ID>0.0</gml:PLAT_ID>
<gml:SRCH_NAME>TWIN LAKES DRIVE</gml:SRCH_NAME>
<gml:FEAT_CODE>r</gml:FEAT_CODE>
<gml:SHAPE>
<gml:MultiLineString srsName="http://www.opengis.net/gml/srs/epsg.xml#2240";><gml:lineStringMember><gml:LineString><gml:coordinates xmlns:gml="http://www.opengis.net/gml"; decimal="." cs="," ts=" ">2149924.74998015,1323330.37495792 2149983.50000524,1323283.375015 2150050.74994477,1323228.1249925 2150077.74998311,1323197.49996984 2150095.24999606,1323171.62502418 2150106.99994964,1323143.37504002 2150114.25004685,1323111.62505327 2150121.25005203,1323057.49999487 2150137.74995402,1322901.12497104 2150155.24996696,1322731.75004781 2150163.50004654,1322657.74993797 2150537.50001092,1322658.87503064</gml:coordinates></gml:LineString></gml:lineStringMember></gml:MultiLineString> 
 </gml:SHAPE>
 </gml:GIS.DBO.CENTERLINE>
</gml:featureMember>
...
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel

Back to the top