When you create your ‘feature class’ / table in the database using ESRI tools, you use the config option PG_GEOMETRY. This uses PostGIS’s geometry type instead of ESRI’s.
With this setup, you can read and edit the data with ESRI products, and you can also access the features with straight PostGIS queries. You can then just create a Mapserver layer with connectiontype of POSTGIS and point it at your database table. http://www.mapserver.org/input/vector/postgis.html From: Oscar ^_^ [mailto:[email protected]] Sent: Friday, November 04, 2016 8:18 AM To: Fawcett, David (MNIT) <[email protected]> Cc: Michael Smith <[email protected]>; Lime, Steve D (MNIT) <[email protected]>; [email protected]; Wingfield, Nathaniel D <[email protected]> Subject: RE: [mapserver-users] arcgis 10.3 enterprise geodatabase How can I Store enterprice data as pg_geometry and manage versión a in Mapserver? El nov 3, 2016 2:10 PM, "Fawcett, David (MNIT)" <[email protected]<mailto:[email protected]>> escribió: We do the same thing, but on PostGIS with pg_geometry. From: mapserver-users [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Michael Smith Sent: Thursday, November 03, 2016 3:08 PM To: Lime, Steve D (MNIT) <[email protected]<mailto:[email protected]>>; Oscar ^_^ <[email protected]<mailto:[email protected]>>; Wingfield, Nathaniel D <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]> Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase The other option, which is what we use, is to store ArcGIS 10.3 enterprise data as SDO_GEOMETRY native. We find no performance penalties in ArcGIS and performance benefits for non-esri software, such as mapserver. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers From: mapserver-users <[email protected]<mailto:[email protected]>> on behalf of "Lime, Steve D (MNIT)" <[email protected]<mailto:[email protected]>> Date: Thursday, November 3, 2016 at 4:02 PM To: Oscar ^_^ <[email protected]<mailto:[email protected]>>, "Wingfield, Nathaniel D" <[email protected]<mailto:[email protected]>> Cc: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase If GDAL/OGR can handle the format then you’re in luck. I’d check there first… From: mapserver-users [mailto:[email protected]] On Behalf Of Oscar ^_^ Sent: Thursday, November 03, 2016 2:51 PM To: Wingfield, Nathaniel D <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]> Subject: Re: [mapserver-users] arcgis 10.3 enterprise geodatabase I've got the same requeriment althought i can use 10.1 or 10.2 but i don't know how to implement these to Mapserver.... Any suggestion o guide ?? 2016-11-01 7:39 GMT-06:00 Wingfield, Nathaniel D <[email protected]<mailto:[email protected]>>: Can MapServer consume spatial data from an ArcGIS 10.3 enterprise geodatabase? We are using the default SDE.ST_GEOMETRY type, on Oracle. The MapServer docs indicate that any support for ESRI enterprise geodatabases is based on ArcSDE, which was abandoned by ESRI at version 10.3, in favor of direct connect (https://blogs.esri.com/esri/supportcenter/2015/02/11/where-is-the-install-for-arcsde-10-3/). We will likely use OpenLayers for a new web-based mapping app, so MapServer seems like a natural choice (otherwise we will have to use ArcGIS Server). _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users -- OSCAR @ ^_^ Y _______________________________________________ mapserver-users mailing list [email protected]<mailto:[email protected]> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
