[postgis-users] how to connect ArcGIS 9.3 to Postgis without ArcSDE ?
John Zhang
I was wondering if there is a way to connect to Postgis for ArcGIS 9.3. We are planning to manage spatial data by postgres. However, how can we view/edit the data by ArcGIS?
Any input would be appreciated
Thanks a lot
John
Bruce Rindahl
_______________________________________________ postgis-users mailing list postgi...@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
MarkW
Sufficool, Stanley
PostGIS data in ArcGIS.
The other option is PostGIS + WFS / WMS for viewing through ArcGIS.
You didn't think that they would make this free? :)
Ervin Ramonllari
I would suggest Quantum GIS, open source GIS software, have a look at http://www.qgis.org
Ervin
Date: Tue, 18 Nov 2008 12:11:18 -0800
From: johnz...@gmail.com
To: postgi...@postgis.refractions.net
Subject: [postgis-users] how to connect ArcGIS 9.3 to Postgis without ArcSDE ?
Discover the new Windows Vista Learn more!
Simon Greener
(one amongst many) with all its (hidden) limitations and issues. John wants the freedom to decide how to connect to data sources using his client of choice. A
reasonable thing to ask. But, for those of use who know how the "ESRI Soviet" works, such freedom isn't available to those who own one
of their licenses: he has to pay for an ArcSDE license (and, probably, be told that the new all-singing-all-dancing-ESRI-spatial-type for PostgreSQL is
best. "but we do support PostGIS if you must"). Suggesting free software, like Quantum GIS etc, requires a huge shift in mindset that ESRIlites (or anyone who
has spent money on a commercial GIS) finds hard to do. To those who say Quantum GIS, I would say Manifold GIS. It will do what John wants, but
he is as likely to change to Manifold GIS as he is to Quantum GIS.
Cynically and sadly,
Simon
On Wed, 19 Nov 2008 19:10:41 +1100, Ervin Ramonllari <ervin.ra...@hotmail.com> wrote:
>
> Hi,
>
> I would suggest Quantum GIS, open source GIS software, have a look at http://www.qgis.org
>
> Ervin
>
> Date: Tue, 18 Nov 2008 12:11:18 -0800
> From: johnz...@gmail.com
> To: postgi...@postgis.refractions.net
> Subject: [postgis-users] how to connect ArcGIS 9.3 to Postgis without ArcSDE ?
>
> Hi there,
>
> I was wondering if there is a way to connect to Postgis for ArcGIS 9.3. We are planning to manage spatial data by postgres. However, how can we view/edit the data by ArcGIS?
>
> Any input would be appreciated
>
>
> Thanks a lot
> John
>
> _________________________________________________________________
> Discover the new Windows Vista
> http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
--
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
Email: si...@spatialdbadvisor.com
Voice: +613 9016 3910
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
NAC:W80CK 7SWP3
Paragon Corporation
with as well I believe, though I don't really do much editing with tools so
can't speak for the merits of editing. My personal favorite is OpenJump.
Manifold GIS by the way has a lot of charm. I haven't really dug that
deeply into my copy yet, but there is a lot under the hood there. And if
per chance you are dealing with multiple different spatial databases it
supports
SQL Server 2008, PostGIS, DBII I think, and Oracle Spatial some really nifty
looking RASTER functions without any SDE goo.
I find it harder to get into though than something like OpenJump without
reading a bit.
Granted SDE does afford some things like hmm versioning and RASTER storage?
And you can use PostGIS raw without going thru the SDE service as long as
you pay for the SDE service I think. Though the idea that you have to pay
for something so that you can not use it seems a little strange. Someone
correct me if I am wrong in my impression there. It seems if you have the
service turned off and you can still connect via ArcGIS, doesn't that mean
you didn't need the service, but you have to still pay for the service?
Thanks,
Regina
-----Original Message-----
From: postgis-us...@postgis.refractions.net
[mailto:postgis-us...@postgis.refractions.net] On Behalf Of Simon
Greener
Sent: Friday, November 21, 2008 3:39 AM
To: PostGIS Users Discussion
Randall, Eric
I don't have it yet but am planning on acquiring a couple liceses in order to
use PostGIS data from the ArcGIS Desktop. That might be the lowest cost solution
without changing clients.
-Eric
Simon Greener
> Not sure if anyone mentioned uDig and OpenJump already. Those you can edit
> with as well I believe, though I don't really do much editing with tools so
> can't speak for the merits of editing. My personal favorite is OpenJump.
>
> Manifold GIS by the way has a lot of charm. I haven't really dug that
> deeply into my copy yet, but there is a lot under the hood there. And if
> per chance you are dealing with multiple different spatial databases it
> supports
>
> SQL Server 2008, PostGIS, DBII I think, and Oracle Spatial some really nifty
> looking RASTER functions without any SDE goo.
>
> I find it harder to get into though than something like OpenJump without
> reading a bit.
Each to his/her own, Regina. Manifold has zillions of pages of well written help whereas,
most open source software, tends to be weak in this area.
I think the issue for our ArcGIS friend is how to connect to PostGIS without paying ESRI more
$zillions for middleware he doesn't need. As such, though I haven't tried it, zigGIS should be
the first thing he looks at before trying any of GIS client (with the high associated costs of
relearning - as you have discovered wrt Manifold).
> Granted SDE does afford some things like hmm versioning and RASTER storage?
But versioning and raster storage are only for ESRI clients, no? If you wanted to use uDig or OpenJump to access
version tables or access constraint information held in the ESRI GDB_* table soup can you?
> And you can use PostGIS raw without going thru the SDE service as long as
> you pay for the SDE service I think. Though the idea that you have to pay
> for something so that you can not use it seems a little strange. Someone
> correct me if I am wrong in my impression there. It seems if you have the
> service turned off and you can still connect via ArcGIS, doesn't that mean
> you didn't need the service, but you have to still pay for the service?
The thing about all spatial databases is that they provide a client agnostic, centralised data management tier that
is accessible by all. Putting an ArcSDE middleware layer over the top of a database and then storing corporate
data in a proprietary format not accessible to anyone else via the normal APIs and access protocols is what I argue
against whenever I can.
But, (check this out), I don't actually say that the ArcSDE API should not exist. I have no problem with ESRI creating
a common data access API for all its clients to "harmonise" or "standardise" the access language. Oracle's SDO_* operators
and PostGIS's && etc operators are a case in point.
More than 2c worth!
Simon
Paragon Corporation
> Granted SDE does afford some things like hmm versioning and RASTER
storage?
> But versioning and raster storage are only for ESRI clients, no? If you
wanted to use uDig or OpenJump to access
> version tables or access constraint information held in the ESRI GDB_*
table soup can you?
Udig maybe, OpenJump nope. Other tools FME I assume you can. I think
Mapserver speaks to ArcSDE in some way (I mean you need ArcSDE libraries to
compile the SDE support), but don't know if that means it is accessing the
versioned since its going thru the ArcSDE layer.
> The thing about all spatial databases is that they provide a client
agnostic, centralised data management tier
> that is accessible by all. Putting an ArcSDE middleware layer over the top
of a database and then storing
> corporate data in a proprietary format not accessible to anyone else via
the normal APIs and access protocols is
> what I argue against whenever I can.
> But, (check this out), I don't actually say that the ArcSDE API should not
exist. I have no problem with ESRI
> creating a common data access API for all its clients to "harmonise" or
"standardise" the access language.
> Oracle's SDO_* operators and PostGIS's && etc operators are a case in
point.
Couldn't agree with you more on this. That is the biggest gripe I have with
ESRI. I mean the only tool I can adequately use to get at the data of a
pure ArcSDE install seems to be ArcMap. I mean hell I can run spatial
queries with PostGIS from MS Access/PHP/.NET with one freely available
library but ArcSDE just is an eyesore. That's actually all I use ArcMap for
- pull the data and get quickly out of that tool.
Its not my cup of tea, but I can appreciate what others see in it --e.g 3D
Analyst, their Solar... Something or other algorithms, extensive .NET API
and of course their beautiful cartography.
To a more or less pure database analyst/decision support application
developer like me, these things are thoroughly yawning and just add
unnecessary complexity and bloat to my already complex business process
specific algorithms.
Thanks,
Regina
Malm Paul
I have a geometry (com.vividsolutions.jts.geom.Geometry) which I would like to add as a geometry to the geometry colunm see below.
how can I do this in java (I don´t know so much of databases)?
PreparedStatement pstmt = null;
String query = "insert into submap(submapid, mapid, blob, the_geom) values(?, ?, ?, ?)";
pstmt = postGISdb.dbConnection.prepareStatement(query);
pstmt.setInt(1, submapid);
pstmt.setInt(2, mapId);
pstmt.setBinaryStream(3, blob.getInputStream(), blob.toByteArray().length);
//vividsolution geometry
Geometry geo = submaps.get(submapNo).getSubmapsExtent();
pstmt.set?????(4, ????);
int rowCount = pstmt.executeUpdate();
/kind regards,
Paul
Kevin Neufeld
I do this all the time and find the JTS WKBWriter and WKBReader work well.
Your code could look something like this:
WKBWriter wkbWriter = new WKBWriter(3); // if writing in 3D
pstmt.setBytes(4, wkbWriter.write(geo));
Here is a simple example in reading and writing JTS geometries from PostGIS
Class.forName(“org.postgresql.Driver”);
Connection conn =
DriverManager.getConnection(“jdbc:postgresql://...”);
WKBReader wkbReader = new WKBReader();
WKBWriter wkbWriter = new WKBWriter();
String query =
"SELECT the_geom FROM my_spatial_table " +
"WHERE ST_Intersects(the_geom, ST_GeomFromWKB(?, 3005))");
PreparedStatement pstmt = conn.prepareStatement(query);
pstmt.setBytes(1, wkbWriter.write(myJTSPolygon));
ResultSet rs = pstmt.executeQuery();
while(rs.next) {
Geometry g = wkbReader.read(WKBReader.hexToBytes(
rs.getString(1)));
...
// Do stuff with Geometry from my_spatial_table
}
Cheers,
Kevin