Re: [postgis-users] PostGIS supported by which ArcGIS
I finally managed what I wanted, and that is to be able to edit geometries stored in PostgreSQL/PostGIS (non versioned) with both ArcMap and QGIS following this steps : - With pgAdmin create a new database using template_postgis_20 (let's name it database) - From ArcCatalog - System Toolboxes - Data Management Tools - Geodatabase Administration - Create Enterprise Geodatabase esrifi your previously created database (In the Database field write the name of the database previously created with pgAdmin) -From ArcCatalog - Add Database Connection - connect to your esrified geodatabase using sde superuser credentials (previously created). A new connection will be created. -Right click on the newly created connection - Administration - Add user (adrian) -Disconnect as sde and connect back to the database with the new user's credentials. Here is a trick. ArcMap have a latency in disconnecting the previous connection. So, delete the previous sde connection and restart ArcMap or do whatever you now to be sure that you are connecting as the newly created user. -Connected as newly created user - Right click on connection - Import - Feature classes and don't forget here at the bottom of the dialogue box Geodatabase Settings (optional) to choose PG_GEOMETRY -Go back in pgAdmin and in the user's schema (not SDE schema) : 1. Define a primary key on objectid column : ALTER TABLE adrian.database ADD CONSTRAINT objectid_pkey PRIMARY KEY(objectid); 2.Create a sequence : CREATE SEQUENCE adrian.databse_objectid_sequence INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 6324 CACHE 1; ALTER TABLE adrian.database_objectid_sequence OWNER TO adrian; 3.Autoincrement objectid column values according to the corresponding sequence. ALTER TABLE adrian.database ALTER COLUMN objectid SET DEFAULT nextval('adrian.database_objectid_sequence'::regclass); That will be all. Adrian On Fri, Jan 16, 2015 at 10:01 AM, Paolo Importuni imp...@gmail.com wrote: Hi Adrian, as far as I can remember there are two parameters in the table sde 'db_tune' that must be set to the PG_GEOMETRY type. I remember having the same problem some times ago, due to the fact that I had set only one parameter to the right type. Then, of course, you will have to delete your geometry type and re-import it. Let us know if you sort it out. regards paolo 2015-01-15 21:23 GMT+01:00 Adrian Term adrian.t...@gmail.com: I have the following setup : ArcGIS 10.2.2 for Desktop Advanced ArcGIS 10.2.2 for Server QGIS 2.6.1 Brighton PostgreSQL 9.2.9-3 PostGIS 2.1 I managed to make them all hear each other following this instructions : http://resources.arcgis.com/en/help/main/10.2/index.html#//002p00t400 Data is loaded from ArcGIS with the Import feature class (single) with the PG_Geometry configuration keyword in Geodatabase Settings. With ArcGIS I can connect, view, edit and save the data stored in the esrified PostgreSQL/PostGIS database tables. Unfortunately, when I try to do the same thing in QGIS i get an error message : Errors: ERROR: 1 feature(s) not added. Provider errors: PostGIS error while adding features: ERROR: column shape is of type geometry but expression is of type st_geometry On the other hand, I tried to do the same thing with UDIG and everything works perfect. I assume that the issue in QGIS is something about what Birgit mentioned : If ArcGIS writes geometries into the PostgreSQL database it names the geometry column as shape with the datatype geometry Any ideas ? Adrian ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
I finally managed what I wanted, and that is to be able to edit geometries stored in PostgreSQL/PostGIS (non versioned) with both ArcMap and QGIS following this steps : - With pgAdmin create a new database using template_postgis_20 (let's name it database) - From ArcCatalog - System Toolboxes - Data Management Tools - Geodatabase Administration - Create Enterprise Geodatabase esrifi your previously created database (In the Database field write the name of the database previously created with pgAdmin) -From ArcCatalog - Add Database Connection - connect to your esrified geodatabase using sde superuser credentials (previously created). A new connection will be created. -Right click on the newly created connection - Administration - Add user (adrian) -Disconnect as sde and connect back to the database with the new user's credentials. Here is a trick. ArcMap have a latency in disconnecting the previous connection. So, delete the previous sde connection and restart ArcMap or do whatever you now to be sure that you are connecting as the newly created user. -Connected as newly created user - Right click on connection - Import - Feature classes and don't forget here at the bottom of the dialogue box Geodatabase Settings (optional) to choose PG_GEOMETRY -Go back in pgAdmin and in the user's schema (not SDE schema) : 1. Define a primary key on objectid column : ALTER TABLE adrian.database ADD CONSTRAINT objectid_pkey PRIMARY KEY(objectid); 2.Create a sequence : CREATE SEQUENCE adrian.databse_objectid_sequence INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 6324 CACHE 1; ALTER TABLE adrian.database_objectid_sequence OWNER TO adrian; 3.Autoincrement objectid column values according to the corresponding sequence. ALTER TABLE adrian.database ALTER COLUMN objectid SET DEFAULT nextval('adrian.database_objectid_sequence'::regclass); That will be all. Adrian On Fri, Jan 16, 2015 at 10:01 AM, Paolo Importuni imp...@gmail.com wrote: Hi Adrian, as far as I can remember there are two parameters in the table sde 'db_tune' that must be set to the PG_GEOMETRY type. I remember having the same problem some times ago, due to the fact that I had set only one parameter to the right type. Then, of course, you will have to delete your geometry type and re-import it. Let us know if you sort it out. regards paolo 2015-01-15 21:23 GMT+01:00 Adrian Term adrian.t...@gmail.com: I have the following setup : ArcGIS 10.2.2 for Desktop Advanced ArcGIS 10.2.2 for Server QGIS 2.6.1 Brighton PostgreSQL 9.2.9-3 PostGIS 2.1 I managed to make them all hear each other following this instructions : http://resources.arcgis.com/en/help/main/10.2/index.html#//002p00t400 Data is loaded from ArcGIS with the Import feature class (single) with the PG_Geometry configuration keyword in Geodatabase Settings. With ArcGIS I can connect, view, edit and save the data stored in the esrified PostgreSQL/PostGIS database tables. Unfortunately, when I try to do the same thing in QGIS i get an error message : Errors: ERROR: 1 feature(s) not added. Provider errors: PostGIS error while adding features: ERROR: column shape is of type geometry but expression is of type st_geometry On the other hand, I tried to do the same thing with UDIG and everything works perfect. I assume that the issue in QGIS is something about what Birgit mentioned : If ArcGIS writes geometries into the PostgreSQL database it names the geometry column as shape with the datatype geometry Any ideas ? Adrian ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
Hi Adrian, as far as I can remember there are two parameters in the table sde 'db_tune' that must be set to the PG_GEOMETRY type. I remember having the same problem some times ago, due to the fact that I had set only one parameter to the right type. Then, of course, you will have to delete your geometry type and re-import it. Let us know if you sort it out. regards paolo 2015-01-15 21:23 GMT+01:00 Adrian Term adrian.t...@gmail.com: I have the following setup : ArcGIS 10.2.2 for Desktop Advanced ArcGIS 10.2.2 for Server QGIS 2.6.1 Brighton PostgreSQL 9.2.9-3 PostGIS 2.1 I managed to make them all hear each other following this instructions : http://resources.arcgis.com/en/help/main/10.2/index.html#//002p00t400 Data is loaded from ArcGIS with the Import feature class (single) with the PG_Geometry configuration keyword in Geodatabase Settings. With ArcGIS I can connect, view, edit and save the data stored in the esrified PostgreSQL/PostGIS database tables. Unfortunately, when I try to do the same thing in QGIS i get an error message : Errors: ERROR: 1 feature(s) not added. Provider errors: PostGIS error while adding features: ERROR: column shape is of type geometry but expression is of type st_geometry On the other hand, I tried to do the same thing with UDIG and everything works perfect. I assume that the issue in QGIS is something about what Birgit mentioned : If ArcGIS writes geometries into the PostgreSQL database it names the geometry column as shape with the datatype geometry Any ideas ? Adrian ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[postgis-users] PostGIS supported by which ArcGIS
I have the following setup : ArcGIS 10.2.2 for Desktop Advanced ArcGIS 10.2.2 for Server QGIS 2.6.1 Brighton PostgreSQL 9.2.9-3 PostGIS 2.1 I managed to make them all hear each other following this instructions : http://resources.arcgis.com/en/help/main/10.2/index.html#//002p00t400 Data is loaded from ArcGIS with the Import feature class (single) with the PG_Geometry configuration keyword in Geodatabase Settings. With ArcGIS I can connect, view, edit and save the data stored in the esrified PostgreSQL/PostGIS database tables. Unfortunately, when I try to do the same thing in QGIS i get an error message : Errors: ERROR: 1 feature(s) not added. Provider errors: PostGIS error while adding features: ERROR: column shape is of type geometry but expression is of type st_geometry On the other hand, I tried to do the same thing with UDIG and everything works perfect. I assume that the issue in QGIS is something about what Birgit mentioned : If ArcGIS writes geometries into the PostgreSQL database it names the geometry column as shape with the datatype geometry Any ideas ? Adrian ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
It sounds like you loaded data with ESRI ST_Geometry format. I don't think QGIS has direct support for ESRI ST_Geometry, but I think uDig does. Those instructions you point to sound like for configuring ESRI's ST_Geometry data type. PostGIS datatype is just called geometry and a completely different ball of wax. You should probably use these instructions: http://resources.arcgis.com/en/help/main/10.2/index.html#//002p006v0 0 The two sets of types while sounding the same and even having some overlapping functions do not talk to each other and are incompatible with each other. I think the benefit of ESRI type is it's easier to use ESRI's versioning plumbing, but you are limited with what tools you can use with it since I think most commercial and open source tools understand PostGIS, but fewer understand the ESRI ST_Geometry type. This is from a person who only uses ArcGIS passingly when forced to, so take my historical bent as a bit bent :) Hope that helps, Regina _ From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Adrian Term Sent: Thursday, January 15, 2015 3:24 PM To: postgis-users@lists.osgeo.org Subject: [postgis-users] PostGIS supported by which ArcGIS I have the following setup : ArcGIS 10.2.2 for Desktop Advanced ArcGIS 10.2.2 for Server QGIS 2.6.1 Brighton PostgreSQL 9.2.9-3 PostGIS 2.1 I managed to make them all hear each other following this instructions : http://resources.arcgis.com/en/help/main/10.2/index.html#//002p00t40 0 Data is loaded from ArcGIS with the Import feature class (single) with the PG_Geometry configuration keyword in Geodatabase Settings. With ArcGIS I can connect, view, edit and save the data stored in the esrified PostgreSQL/PostGIS database tables. Unfortunately, when I try to do the same thing in QGIS i get an error message : Errors: ERROR: 1 feature(s) not added. Provider errors: PostGIS error while adding features: ERROR: column shape is of type geometry but expression is of type st_geometry On the other hand, I tried to do the same thing with UDIG and everything works perfect. I assume that the issue in QGIS is something about what Birgit mentioned : If ArcGIS writes geometries into the PostgreSQL database it names the geometry column as shape with the datatype geometry Any ideas ? Adrian ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
Adrian, I think that Regina is correct and that the layer that you loaded is using the ESRI st_geometry. I am using PostGIS with ESRI products (10.2) and I am able to create a feature class in the 'esrified' postgres table with ESRI tools and then manipulate it using PostGIS and QGIS (2.4, I don't have 2.6 on this machine.) To load data, I generally use the ESRI Tool ConversionTo GeodatabaseFeature Class to Feature Class, setting PG_Geometry in the Geodatabase settings control. So far, this setup is working quite well and giving us pretty much 'the best of both worlds'. The geometry column does get named 'shape' by ESRI, but that isn't an issue on the PostGIS side. David. On Thu, Jan 15, 2015 at 2:23 PM, Adrian Term adrian.t...@gmail.com wrote: I have the following setup : ArcGIS 10.2.2 for Desktop Advanced ArcGIS 10.2.2 for Server QGIS 2.6.1 Brighton PostgreSQL 9.2.9-3 PostGIS 2.1 I managed to make them all hear each other following this instructions : http://resources.arcgis.com/en/help/main/10.2/index.html#//002p00t400 Data is loaded from ArcGIS with the Import feature class (single) with the PG_Geometry configuration keyword in Geodatabase Settings. With ArcGIS I can connect, view, edit and save the data stored in the esrified PostgreSQL/PostGIS database tables. Unfortunately, when I try to do the same thing in QGIS i get an error message : Errors: ERROR: 1 feature(s) not added. Provider errors: PostGIS error while adding features: ERROR: column shape is of type geometry but expression is of type st_geometry On the other hand, I tried to do the same thing with UDIG and everything works perfect. I assume that the issue in QGIS is something about what Birgit mentioned : If ArcGIS writes geometries into the PostgreSQL database it names the geometry column as shape with the datatype geometry Any ideas ? Adrian ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
Hi David, I have no experiences with ArcSDE, but I can say, that no dba had to esrify our database in order to enable the interoperability between ArcGIS and PostgreSQL/PostGIS. We have a simple PostgreSQL-DB (version 9.1) with an PostGIS extension (version 2.1). All we had to do was download a bunch of files from the ArcGIS Helpdesk, copy them into the appropriate ArcGIS program folder of our locally installed desktop ArcGIS, and then everything worked. We had to define the connection to the PostgreSQL database in ArcGIS and then we were able to access the tables of our PostgreSQL database including the PostGIS geometries (not the raster data!) via read/write access. If ArcGIS writes geometries into the PostgreSQL database it names the geometry column as shape with the datatype geometry - no pg_geometry or st_geometry. Regards, Birgit. Am 08.10.2014 17:28, schrieb David Fawcett: I assume that on the server side, your dba has 'Esrified' the database by using a one of the ArcGIS desktop tools to convert your existing Postgres database into an 'ESRI Enterprise Geodatabase, which creates the sde schema and all of the sde functions, etc. This costs an ArcGIS Server license. We are doing this for our primary production spatial database. One thing that we are doing is using the PG_GEOMETRY option to specify the PostGIS spatial datatype instead of ESRI's ST_GEOMETRY datatype. This allows us to use all of the PostGIS functionality on features created with ESRI tools. All of my backend processes are written in Python/SQL/PgPSQL without any ESRI tools. I would be very surprised if you can edit geometries in PostGIS using the ArcGIS tools without using the SDE functionality and licensing. (I would love it if you can prove me wrong.) Note that the SDE functionality is now built into all of ESRI's products, and the SDE server software will be depricated after 10.2. On Thu, Oct 2, 2014 at 2:30 AM, Birgit Laggner birgit.lagg...@ti.bund.de mailto:birgit.lagg...@ti.bund.de wrote: We use ArcGIS 10.2 for read/write interaction with our PostgreSQL database. We only have ArcGIS Desktop without SDE. There is a driver (database client file) from ArcGIS for PostgreSQL, you have to install. We are more or less content with this concept. Surely, the performance is not as if you would be working directly on the PostgreSQL database, but still, it isn't necessary to always export and import into and from shapefile. That's a huge plus in my opinion. Here is a link to a documentation site of ArcGIS regarding the requirements for the interoperability with PostgreSQL: http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//0151007500 Regards, Birgit. Am 27.09.2014 20 tel:27.09.2014%2020:28, schrieb Stefan Keller: Actually yes, I meant the PostGIS option of storing data in PostgreSQL/PostGIS from ArcGIS. --S. 2014-09-27 20:20 GMT+02:00 Randal Hale rjh...@northrivergeographic.com mailto:rjh...@northrivergeographic.com: as far as I understand it (and I could be wrong on some of this) Desktop will support reading if you load the postgresql library files (that can be downloaded form your ESRI customer care portal). Once those are loaded you can read through a definition query data from postgis into arcgis. I just made a map using arcgis and reading data from postgis. It doesn't support write unless you have SDE for Postgresql - which isn't postgis. That dives into the world of ArcGIS Server ArcGIS supposedly is moving to being able to read/write the geopackage format which to me opens read/write to PostGIS. BUT if they open read write for postgis that starts a slow death of SDEso I don't believe it ever will (for the foreseeable future). Randy On 09/27/2014 02:10 PM, Stefan Keller wrote: I'm asked from time to time for an advice which ArcGIS product supports PostGIS (read/write)? Even after reading the Esri pages I'm not sure if it's only ArcGIS for Server Workgroup (formerly ArcSDE). Does it work also with ArcGIS for Desktop Basic (ArcView)? Yours, S. ___ postgis-users mailing list postgis-users@lists.osgeo.org mailto:postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- - Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com
Re: [postgis-users] PostGIS supported by which ArcGIS
Hi, last year, I had the same kind of experience that david described in a previous post. I esrified my pg database into an esri enterprise geodatabase, turned db_tune parameter into PG_Geometry and was able to read and write on my table. I can't remember all details but editing of non-spatial tables through Arcmap (as per customer requests) was a kind of a mess... The worst part was, migrating the entire db from dev server to production server. This was done exporting the xml workspace through ArcCatalog and recreating all constraints and relationships through a separated sql script. I tried to backup the entire db through Postgres tools and re-import it but ArcMap refused to connect to this newly imported db. I can't really say that Postgres/Esri was a nice marriage Regards paolo 2014-10-09 11:38 GMT+02:00 Birgit Laggner birgit.lagg...@ti.bund.de: Hi David, I have no experiences with ArcSDE, but I can say, that no dba had to esrify our database in order to enable the interoperability between ArcGIS and PostgreSQL/PostGIS. We have a simple PostgreSQL-DB (version 9.1) with an PostGIS extension (version 2.1). All we had to do was download a bunch of files from the ArcGIS Helpdesk, copy them into the appropriate ArcGIS program folder of our locally installed desktop ArcGIS, and then everything worked. We had to define the connection to the PostgreSQL database in ArcGIS and then we were able to access the tables of our PostgreSQL database including the PostGIS geometries (not the raster data!) via read/write access. If ArcGIS writes geometries into the PostgreSQL database it names the geometry column as shape with the datatype geometry - no pg_geometry or st_geometry. Regards, Birgit. Am 08.10.2014 17:28, schrieb David Fawcett: I assume that on the server side, your dba has 'Esrified' the database by using a one of the ArcGIS desktop tools to convert your existing Postgres database into an 'ESRI Enterprise Geodatabase, which creates the sde schema and all of the sde functions, etc. This costs an ArcGIS Server license. We are doing this for our primary production spatial database. One thing that we are doing is using the PG_GEOMETRY option to specify the PostGIS spatial datatype instead of ESRI's ST_GEOMETRY datatype. This allows us to use all of the PostGIS functionality on features created with ESRI tools. All of my backend processes are written in Python/SQL/PgPSQL without any ESRI tools. I would be very surprised if you can edit geometries in PostGIS using the ArcGIS tools without using the SDE functionality and licensing. (I would love it if you can prove me wrong.) Note that the SDE functionality is now built into all of ESRI's products, and the SDE server software will be depricated after 10.2. On Thu, Oct 2, 2014 at 2:30 AM, Birgit Laggner birgit.lagg...@ti.bund.de wrote: We use ArcGIS 10.2 for read/write interaction with our PostgreSQL database. We only have ArcGIS Desktop without SDE. There is a driver (database client file) from ArcGIS for PostgreSQL, you have to install. We are more or less content with this concept. Surely, the performance is not as if you would be working directly on the PostgreSQL database, but still, it isn't necessary to always export and import into and from shapefile. That's a huge plus in my opinion. Here is a link to a documentation site of ArcGIS regarding the requirements for the interoperability with PostgreSQL: http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//0151007500 Regards, Birgit. Am 27.09.2014 20:28, schrieb Stefan Keller: Actually yes, I meant the PostGIS option of storing data in PostgreSQL/PostGIS from ArcGIS. --S. 2014-09-27 20:20 GMT+02:00 Randal Hale rjh...@northrivergeographic.com : as far as I understand it (and I could be wrong on some of this) Desktop will support reading if you load the postgresql library files (that can be downloaded form your ESRI customer care portal). Once those are loaded you can read through a definition query data from postgis into arcgis. I just made a map using arcgis and reading data from postgis. It doesn't support write unless you have SDE for Postgresql - which isn't postgis. That dives into the world of ArcGIS Server ArcGIS supposedly is moving to being able to read/write the geopackage format which to me opens read/write to PostGIS. BUT if they open read write for postgis that starts a slow death of SDEso I don't believe it ever will (for the foreseeable future). Randy On 09/27/2014 02:10 PM, Stefan Keller wrote: I'm asked from time to time for an advice which ArcGIS product supports PostGIS (read/write)? Even after reading the Esri pages I'm not sure if it's only ArcGIS for Server Workgroup (formerly ArcSDE). Does it work also with ArcGIS for Desktop Basic (ArcView)? Yours, S. ___ postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
I assume that on the server side, your dba has 'Esrified' the database by using a one of the ArcGIS desktop tools to convert your existing Postgres database into an 'ESRI Enterprise Geodatabase, which creates the sde schema and all of the sde functions, etc. This costs an ArcGIS Server license. We are doing this for our primary production spatial database. One thing that we are doing is using the PG_GEOMETRY option to specify the PostGIS spatial datatype instead of ESRI's ST_GEOMETRY datatype. This allows us to use all of the PostGIS functionality on features created with ESRI tools. All of my backend processes are written in Python/SQL/PgPSQL without any ESRI tools. I would be very surprised if you can edit geometries in PostGIS using the ArcGIS tools without using the SDE functionality and licensing. (I would love it if you can prove me wrong.) Note that the SDE functionality is now built into all of ESRI's products, and the SDE server software will be depricated after 10.2. On Thu, Oct 2, 2014 at 2:30 AM, Birgit Laggner birgit.lagg...@ti.bund.de wrote: We use ArcGIS 10.2 for read/write interaction with our PostgreSQL database. We only have ArcGIS Desktop without SDE. There is a driver (database client file) from ArcGIS for PostgreSQL, you have to install. We are more or less content with this concept. Surely, the performance is not as if you would be working directly on the PostgreSQL database, but still, it isn't necessary to always export and import into and from shapefile. That's a huge plus in my opinion. Here is a link to a documentation site of ArcGIS regarding the requirements for the interoperability with PostgreSQL: http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#// 0151007500 Regards, Birgit. Am 27.09.2014 20:28, schrieb Stefan Keller: Actually yes, I meant the PostGIS option of storing data in PostgreSQL/PostGIS from ArcGIS. --S. 2014-09-27 20:20 GMT+02:00 Randal Hale rjh...@northrivergeographic.com: as far as I understand it (and I could be wrong on some of this) Desktop will support reading if you load the postgresql library files (that can be downloaded form your ESRI customer care portal). Once those are loaded you can read through a definition query data from postgis into arcgis. I just made a map using arcgis and reading data from postgis. It doesn't support write unless you have SDE for Postgresql - which isn't postgis. That dives into the world of ArcGIS Server ArcGIS supposedly is moving to being able to read/write the geopackage format which to me opens read/write to PostGIS. BUT if they open read write for postgis that starts a slow death of SDEso I don't believe it ever will (for the foreseeable future). Randy On 09/27/2014 02:10 PM, Stefan Keller wrote: I'm asked from time to time for an advice which ArcGIS product supports PostGIS (read/write)? Even after reading the Esri pages I'm not sure if it's only ArcGIS for Server Workgroup (formerly ArcSDE). Does it work also with ArcGIS for Desktop Basic (ArcView)? Yours, S. ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- - Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com 423.653.3611 rjh...@northrivergeographic.com twitter:rjhale http://about.me/rjhale http://www.northrivergeographic.com/spatial-connect ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
We use ArcGIS 10.2 for read/write interaction with our PostgreSQL database. We only have ArcGIS Desktop without SDE. There is a driver (database client file) from ArcGIS for PostgreSQL, you have to install. We are more or less content with this concept. Surely, the performance is not as if you would be working directly on the PostgreSQL database, but still, it isn't necessary to always export and import into and from shapefile. That's a huge plus in my opinion. Here is a link to a documentation site of ArcGIS regarding the requirements for the interoperability with PostgreSQL: http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//0151007500 Regards, Birgit. Am 27.09.2014 20:28, schrieb Stefan Keller: Actually yes, I meant the PostGIS option of storing data in PostgreSQL/PostGIS from ArcGIS. --S. 2014-09-27 20:20 GMT+02:00 Randal Hale rjh...@northrivergeographic.com: as far as I understand it (and I could be wrong on some of this) Desktop will support reading if you load the postgresql library files (that can be downloaded form your ESRI customer care portal). Once those are loaded you can read through a definition query data from postgis into arcgis. I just made a map using arcgis and reading data from postgis. It doesn't support write unless you have SDE for Postgresql - which isn't postgis. That dives into the world of ArcGIS Server ArcGIS supposedly is moving to being able to read/write the geopackage format which to me opens read/write to PostGIS. BUT if they open read write for postgis that starts a slow death of SDEso I don't believe it ever will (for the foreseeable future). Randy On 09/27/2014 02:10 PM, Stefan Keller wrote: I'm asked from time to time for an advice which ArcGIS product supports PostGIS (read/write)? Even after reading the Esri pages I'm not sure if it's only ArcGIS for Server Workgroup (formerly ArcSDE). Does it work also with ArcGIS for Desktop Basic (ArcView)? Yours, S. ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- - Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com 423.653.3611 rjh...@northrivergeographic.com twitter:rjhale http://about.me/rjhale http://www.northrivergeographic.com/spatial-connect ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
I have not been able to use Arc 10.3 for visualizing raster data stored in postgresql On Thu, Oct 2, 2014 at 2:30 AM, Birgit Laggner birgit.lagg...@ti.bund.de wrote: We use ArcGIS 10.2 for read/write interaction with our PostgreSQL database. We only have ArcGIS Desktop without SDE. There is a driver (database client file) from ArcGIS for PostgreSQL, you have to install. We are more or less content with this concept. Surely, the performance is not as if you would be working directly on the PostgreSQL database, but still, it isn't necessary to always export and import into and from shapefile. That's a huge plus in my opinion. Here is a link to a documentation site of ArcGIS regarding the requirements for the interoperability with PostgreSQL: http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#// 0151007500 Regards, Birgit. Am 27.09.2014 20:28, schrieb Stefan Keller: Actually yes, I meant the PostGIS option of storing data in PostgreSQL/PostGIS from ArcGIS. --S. 2014-09-27 20:20 GMT+02:00 Randal Hale rjh...@northrivergeographic.com: as far as I understand it (and I could be wrong on some of this) Desktop will support reading if you load the postgresql library files (that can be downloaded form your ESRI customer care portal). Once those are loaded you can read through a definition query data from postgis into arcgis. I just made a map using arcgis and reading data from postgis. It doesn't support write unless you have SDE for Postgresql - which isn't postgis. That dives into the world of ArcGIS Server ArcGIS supposedly is moving to being able to read/write the geopackage format which to me opens read/write to PostGIS. BUT if they open read write for postgis that starts a slow death of SDEso I don't believe it ever will (for the foreseeable future). Randy On 09/27/2014 02:10 PM, Stefan Keller wrote: I'm asked from time to time for an advice which ArcGIS product supports PostGIS (read/write)? Even after reading the Esri pages I'm not sure if it's only ArcGIS for Server Workgroup (formerly ArcSDE). Does it work also with ArcGIS for Desktop Basic (ArcView)? Yours, S. ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- - Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com 423.653.3611 rjh...@northrivergeographic.com twitter:rjhale http://about.me/rjhale http://www.northrivergeographic.com/spatial-connect ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[postgis-users] PostGIS supported by which ArcGIS
I'm asked from time to time for an advice which ArcGIS product supports PostGIS (read/write)? Even after reading the Esri pages I'm not sure if it's only ArcGIS for Server Workgroup (formerly ArcSDE). Does it work also with ArcGIS for Desktop Basic (ArcView)? Yours, S. ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
as far as I understand it (and I could be wrong on some of this) * Desktop will support reading if you load the postgresql library files (that can be downloaded form your ESRI customer care portal). * Once those are loaded you can read through a definition query data from postgis into arcgis. I just made a map using arcgis and reading data from postgis. * It doesn't support write unless you have SDE for Postgresql - which isn't postgis. That dives into the world of ArcGIS Server ArcGIS supposedly is moving to being able to read/write the geopackage format which to me opens read/write to PostGIS. BUT if they open read write for postgis that starts a slow death of SDEso I don't believe it ever will (for the foreseeable future). Randy On 09/27/2014 02:10 PM, Stefan Keller wrote: I'm asked from time to time for an advice which ArcGIS product supports PostGIS (read/write)? Even after reading the Esri pages I'm not sure if it's only ArcGIS for Server Workgroup (formerly ArcSDE). Does it work also with ArcGIS for Desktop Basic (ArcView)? Yours, S. ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- - Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com 423.653.3611 rjh...@northrivergeographic.com twitter:rjhale http://about.me/rjhale http://www.northrivergeographic.com/spatial-connect ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS supported by which ArcGIS
Actually yes, I meant the PostGIS option of storing data in PostgreSQL/PostGIS from ArcGIS. --S. 2014-09-27 20:20 GMT+02:00 Randal Hale rjh...@northrivergeographic.com: as far as I understand it (and I could be wrong on some of this) Desktop will support reading if you load the postgresql library files (that can be downloaded form your ESRI customer care portal). Once those are loaded you can read through a definition query data from postgis into arcgis. I just made a map using arcgis and reading data from postgis. It doesn't support write unless you have SDE for Postgresql - which isn't postgis. That dives into the world of ArcGIS Server ArcGIS supposedly is moving to being able to read/write the geopackage format which to me opens read/write to PostGIS. BUT if they open read write for postgis that starts a slow death of SDEso I don't believe it ever will (for the foreseeable future). Randy On 09/27/2014 02:10 PM, Stefan Keller wrote: I'm asked from time to time for an advice which ArcGIS product supports PostGIS (read/write)? Even after reading the Esri pages I'm not sure if it's only ArcGIS for Server Workgroup (formerly ArcSDE). Does it work also with ArcGIS for Desktop Basic (ArcView)? Yours, S. ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users -- - Randal Hale North River Geographic Systems, Inc http://www.northrivergeographic.com 423.653.3611 rjh...@northrivergeographic.com twitter:rjhale http://about.me/rjhale http://www.northrivergeographic.com/spatial-connect ___ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users