[postgis-users] Turn a Polygon into Lines

the boundary between neighboring polygons with a field indicating the ids of the polygon on either side. Functions like ST_MakeLine require point geometries, and I don't see anything else that seems to be what I'm looking for. Any ideas would be welcome. Thanks, Lee Hachadoorian PhD Student

[postgis-users] Adding view to geometry_columns table

different tables. Are there are any pitfalls I should be aware of? Thanks, Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] Importing shapefiles with srid != -1

Is there any chance spatial_ref_sys is missing srid 4326? Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center On Fri, May 9, 2008 at 12:21 PM, Stephen Lee [EMAIL PROTECTED] wrote: Hi James, Why not try qGIS and use its import wizard to give

Re: [postgis-users] create tables smarter

Kevin, In that case I think Andreas could accomplish this using CREATE TABLE new_table ( LIKE old_table INCLUDING CONSTRAINTS ); followed by probe_geometry_columns( ). I tested this in my database on an arbitrarily selected spatial table and it seems to have worked. Lee Hachadoorian PhD

[postgis-users] Visualizing Attribute Data

with QGIS and uDig, all of which can work with PostGIS layers or shapefiles. Thanks, Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center ___ postgis-users mailing list postgis-users@postgis.refractions.net http

[postgis-users] Collecting Polygons

proj_mortgage.geo_li_basics_by_tract WHERE improve_2001 10 GROUP BY improve_2001 ; Any ideas how I can troubleshoot this? Thanks, Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center ___ postgis-users mailing

Re: [postgis-users] Collecting Polygons

Thank you! Will upgrade next week when I'm back in the office. -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center ___ postgis-users mailing list postgis-users@postgis.refractions.net http

Re: [postgis-users] Collecting Polygons

proj_mortgage.geo_hh_race WHERE pct_hispanic 50; But ST_Collect returns a GEOMETRYCOLLECTION, and I want a polygon or multipolygon. Do I need to do something with the GEOMETRYCOLLECTION returned by ST_Collect, or is ST_Collect the wrong function to use in the first place? Thanks, Lee Hachadoorian PhD Student

Re: [postgis-users] Collecting Polygons

. SELECT ST_Union(geom) FROM ( SELECT geom FROM mytable1 WHERE ... UNION ALL SELECT geom FROM mytable2 WHERE ... ) AS foo; -- Kevin Lee Hachadoorian wrote: Thanks, Kevin, that worked. I saw ST_Union, but I thought it was for joining polygons from different spatial tables. Does it do

Re: [postgis-users] Collecting Polygons

Regina Kevin, I actually do need the dissolved geometries, and the data set is small enough that there was no speed issue with ST_Union. But I'll file away the info about ST_Collect. Thanks both for your help, --Lee ___ postgis-users mailing list

Re: [postgis-users] ESRI Geodatabases, relationship classes and PostGIS

GDB_RelClasses), I suspect that ogr2ogr will not do anything to convert them. Can someone confirm? -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center ___ postgis-users mailing list postgis-users

Re: [postgis-users] ESRI Geodatabases, relationship classes and PostGIS

#DDL-CONSTRAINTS-FK -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis

[postgis-users] Best Practices for Custom SRID/proj4text

any tips for assigning numbers? --Lee -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman

Re: [postgis-users] Best Practices for Custom SRID/proj4text

using the production, submit the documentation to EPSG and it should be officially included in the next release, they're pretty open to receiving new projections. Rob :) Thanks, --Lee -- Lee Hachadoorian PhD Student, Geography Program in Earth Environmental Sciences CUNY Graduate Center

Re: [postgis-users] Removed double quotes from column and table names

This option is not available via SPIT, but ogr2ogr does allow it as a layer creation option: LAUNDER: This may be YES to force new fields created on this layer to have their field names laundered into a form more compatible with PostgreSQL. This converts to lower case and converts some special

Re: [postgis-users] Tools to change the encoding of the SHP/DBF files (from Latin1 to UTF-8)

On Thu, May 10, 2012 at 5:39 PM, Mac Wind macwi...@gmail.com wrote: Hi Sandro. Thank you very much for your answer. With that parameter (-W), am I changing the encoding of the DB or I am merely indicating the encoding of the source? Regards. The latter. I don't think it's possible to change

Re: [postgis-users] Ubuntu Postgis and Shp2pgsql

. shp2pgsql is a one-trick pony, but more straightforward to use. SPIT (mentioned above) is a GUI over ogr2ogr, and its major limitation was keeping case in identifiers like field names. Paolo, I looked in DB Manager and don't see the import functionality. Where is it? --Lee -- Lee Hachadoorian PhD

Re: [postgis-users] Diff. Between 2 tables

_Equals vs. ST_OrderingEquals so that you know which comparison you want. http://postgis.refractions.net/documentation/manual-1.5/ST_Equals.html http://postgis.refractions.net/documentation/manual-1.5/ST_OrderingEquals.html Best, --Lee -- Lee Hachadoorian

[postgis-users] Organizations relying on PostGIS

, or otherwise interesting implementations? Best, --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences (Geography) Research Associate, CUNY Center for Urban Research http://freecity.commons.gc.cuny.edu/ ___ postgis-users mailing list postgis-users

Re: [postgis-users] From Debian to Windows + major upgrading of PostgreSQL and PostGIS

thousands of users hitting it, but Postgres/PostGIS runs quite well on desktop-class hardware. This would also preserve access to your data while you are setting up Windows, in case something goes wrong or it takes longer than you expect. --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences

Re: [postgis-users] From Debian to Windows + major upgrading of PostgreSQL and PostGIS

On Thu, Jun 28, 2012 at 1:41 PM, Mathieu Basille basi...@ase-research.org wrote: I wonder whether the postgis_restore script would not alter the DB, especially since I still use an old PostGIS version where raster_columns was not yet a view... This is why it made sense to me to dump the whole

[postgis-users] Problems Accessing prj2epsg.org

. Google isn't turning up any news related to this. Anyone know anything about this? Best, --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences (Geography) Research Associate, CUNY Center for Urban Research http://freecity.commons.gc.cuny.edu

[postgis-users] Upgrade table to PostGIS 2.0 structure

to the expected PostGIS 2.0 structure, or (b) any reason why this is *not* a good way to upgrade these tables to the new format? Best, --Lee -- Lee Hachadoorian PhD, Earth Environmental Sciences (Geography) Research Associate, CUNY Center for Urban Research http://freecity.commons.gc.cuny.edu

Re: [postgis-users] Pg_wrapper error

installed. How did you install PostGIS 2? What OS? Is shp2pgsql installed and working? If it is, is raster2pgsql available in the same directory? etc. --Lee -- Lee Hachadoorian Asst Professor of Geography, Dartmouth College http://freecity.commons.gc.cuny.edu

Re: [postgis-users] Pg_wrapper error

? That is instead of: shp2pgsql /home/user/Downloads/Africa_Boundaries/africa.shp teste2.africa | psql -d MyDatabase can you shp2pgsql /home/user/Downloads/Africa_Boundaries/africa.shp teste2.africa /home/user/Downloads/import_africa.sql ? --Lee -- Lee Hachadoorian Asst Professor of Geography

Re: [postgis-users] Pg_wrapper error

you created the symlink using the ln command, it would have overwritten the executables. If you backed them up first, delete the symlink and restore the executable from backup. If you didn't back them up, you'll have to reinstall PostGIS. --Lee -- Lee Hachadoorian Asst Professor of Geography