[postgis-users] Proposal for a new function ST_GeogFromLatLon
Hi all, We are having lot of new web developers coming to use PostGIS and thats great! One of the first barries I know some people have is how complicate is to create a point on PostGIS. Basically you need to know: 1) In PostGIS first comes Longitude, then Latitude 2) You have to specify an srid, which most people havent heard of So what I would consider a trivial query looks like this: SELECT * FROM mytable WHERE the_geom ST_SetSRID(ST_MakePoint(-123.0,34),4326) I propose to have a wrapper function called ST_GeogFromLatLon or something similar so that we can do: SELECT * FROM mytable WHERE the_geom ST_GeogFromLatLon(34,-123.0) The ST_GeogFromLatLon will imply 4326 SRID. And the return could be geography, as it cast well to geometry, so it will work in most cases. I know is not such a big difference, but I think it will help a lot new people and will also make our queries look much better in some scenarios. In my experiences when teaching postgis this is kind of annoying having to go through it. Does this break the entire GIS world? :D Just kidding. Javier de la Torre @jatorre Vizzuality 148 Lafayette St. PH, New York, 10013,USA +1 347 320 7715 www.vizzuality.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2.0.0 Released
Congrats to everybody, Today is a beautiful day. Sent from my iPad On Apr 3, 2012, at 5:04 PM, Paul Ramsey pram...@opengeo.org wrote: The PostGIS development team is super excited, can hardly believe that they are actually doing this, aren't maybe even sure that they are ready to make this kind of commitment, not so young, and not when we have so much more living to do, but: PostGIS 2.0.0 is complete and available for download. http://postgis.org/download/postgis-2.0.0.tar.gz The development process for 2.0 has been very long, but has resulted in a release with a number of exciting new features. * Raster data and raster/vector analysis in the database * Topological models to handle objects with shared boundaries * PostgreSQL typmod integration, for an automagical geometry_columns table * 3D and 4D indexing * Index-based high performance nearest-neighbour searching * Many more vector functions including * ST_Split * ST_Node * ST_MakeValid * ST_OffsetCurve * ST_ConcaveHull * ST_AsX3D * ST_GeomFromGeoJSON * ST_3DDistance * Integration with the PostgreSQL 9.1 extension system * Improved commandline shapefile loader/dumper * Multi-file import support in the shapefile GUI * Multi-table export support in the shapefile GUI * A geo-coder optimized for free US Census TIGER (2010) data We are greatly indebted to our large community of beta testers who valiantly tested PostGIS 2.0.0 and reported bugs so we could squash them before release time. And also we want to thank our parents for making PostGIS possible. Yours, The PostGIS development team ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Server Question
Hi all, You can take a look at our cloud service www.cartodb.com. It runs on top of postgis 2.0 already. Dedicated instances can provide direct access to the database. Dedicated instances have around 16GB of RAM and very fast disks. On top of what data you would like to do the geocoding? Best, On 12/03/2012, at 11:36, Greg Militello j...@thinkof.net wrote: Eric, I have not seen much support for PostgreSQL in the cloud. For some reason the cloud offerings tend to say things like it may be offered soon and then only offer MySQL. If the cloud offering allows you to build your own software you should be okay. As for performance, it depends on your needs. Serious geocoding is a bit vague. Its something you will likely have to play with a bit before you can come to any conclusions. I have been playing around with Pagodabox a bit, they seem like they can scale as much as I could need, but lack PostgreSQL support of any kind (So postgis is also out). On Mar 12, 2012, at 11:27 AM, Eric Aspengren wrote: I have a couple of questions about getting some server space on the cloud. 1) anybody have any luck with this? 2) are the servers fast enough to do serious geocoding and such? 3) any recommendations? 4) what about PostGIS 2.0? anybody planning to support that/already supporting the Beta? -- Eric Aspengren (402) 478-VOTE ericas...@gmail.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] ST_Extent of table
Hi all, I need to calculate the extent of a full table. My understanding is that this function will do a full scan of the table to calculate it. Is it possible to get the extent of the table from the index somehow so that is not needed to scan the full table? I also dont need it very precise if that helps in any way. Thanks! Javier de la Torre @jatorre Vizzuality 148 Lafayette St. PH, New York, 10013,USA Hortaleza 48 1, 28004,Madrid,Spain +1 347 320 7715 +34 689 41 4420 www.vizzuality.com @vizzuality ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ST_Extent of table
Thanks Paul! Really sorry I did not find it myself, shame on me. :( Javier de la Torre @jatorre Vizzuality 148 Lafayette St. PH, New York, 10013,USA Hortaleza 48 1, 28004,Madrid,Spain +1 347 320 7715 +34 689 41 4420 www.vizzuality.com @vizzuality On Sep 19, 2011, at 1:06 PM, Paul Ramsey wrote: Javier, You can get a fast, imprecise extent from st_estimated_extent. We should update/change it to use the index top page, but for now it uses the index stats, which means it is sometimes slightly underdetermined, so you might need to grow it by 10-25% depending on your use case. Paul On Mon, Sep 19, 2011 at 9:29 AM, Javier de la Torre jato...@vizzuality.com wrote: Hi all, I need to calculate the extent of a full table. My understanding is that this function will do a full scan of the table to calculate it. Is it possible to get the extent of the table from the index somehow so that is not needed to scan the full table? I also dont need it very precise if that helps in any way. Thanks! Javier de la Torre @jatorre Vizzuality 148 Lafayette St. PH, New York, 10013,USA Hortaleza 48 1, 28004,Madrid,Spain +1 347 320 7715 +34 689 41 4420 www.vizzuality.com @vizzuality ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Importing a shape file with NAD83 / Conus Albers
Hi all, I got a shapefile with a .prj file on it. I pasted the contents to http://prj2epsg.org and got that this http://prj2epsg.org/epsg/5070 This srs does not seem to be in PostGIS so I am trying to add it. Now, the first thing I tried was sending it to spatialreference and I got this http://spatialreference.org/ref/sr-org/7178/ But it does not seem to include the proj4text data needed for postgis to do transformations. I then tried loading it in OGR with Python doing this: srs = osr.SpatialReference() wkt = 'PROJCS[NAD83 / Conus Albers, GEOGCS[NAD83, DATUM[North American Datum 1983, SPHEROID[GRS 1980, 6378137.0, 298.257222101, AUTHORITY[EPSG,7019]], TOWGS84[1.0, 1.0, -1.0, 0.0, 0.0, 0.0, 0.0], AUTHORITY[EPSG,6269]], PRIMEM[Greenwich, 0.0, AUTHORITY[EPSG,8901]], UNIT[degree, 0.017453292519943295], AXIS[Geodetic longitude, EAST], AXIS[Geodetic latitude, NORTH], AUTHORITY[EPSG,4269]], PROJECTION[Albers Equal Area, AUTHORITY[EPSG,9822]], PARAMETER[central_meridian, -96.0], PARAMETER[latitude_of_origin, 23.0], PARAMETER[standard_parallel_1, 29.5], PARAMETER[false_easting, 0.0], PARAMETER[false_northing, 0.0], PARAMETER[standard_parallel_2, 45.5], UNIT[m, 1.0], AXIS[Easting, EAST], AXIS[Northing, NORTH], AUTHORITY[EPSG,5070]]' srs.ImportFromWkt([wkt]) srs.ExportToProj4() But I get ERROR 6: No translation for Albers Equal Area to PROJ.4 format is known. Anybody knows how can I get the PROJ4TEXT from this? Ideally what I would like is to inspect automatially a shapefile coming with a .prj file, try to find if it is in PostGIS and if not register the proj and import the data using shp2psql. Thanks for any advice, Javier. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Importing a shape file with NAD83 / Conus Albers
You mean: srs.MorphFromESRI() srs.ExportToProj4() That still produce srs.ExportToProj4() ERROR 6: No translation for Albers Equal Area to PROJ.4 format is known. On Aug 15, 2011, at 5:28 PM, Paul Ramsey wrote: Try running MorphFromESRI on the srs before generating the proj4? P On Mon, Aug 15, 2011 at 2:25 PM, Javier de la Torre jato...@vizzuality.com wrote: Hi all, I got a shapefile with a .prj file on it. I pasted the contents to http://prj2epsg.org and got that this http://prj2epsg.org/epsg/5070 This srs does not seem to be in PostGIS so I am trying to add it. Now, the first thing I tried was sending it to spatialreference and I got this http://spatialreference.org/ref/sr-org/7178/ But it does not seem to include the proj4text data needed for postgis to do transformations. I then tried loading it in OGR with Python doing this: srs = osr.SpatialReference() wkt = 'PROJCS[NAD83 / Conus Albers, GEOGCS[NAD83, DATUM[North American Datum 1983, SPHEROID[GRS 1980, 6378137.0, 298.257222101, AUTHORITY[EPSG,7019]], TOWGS84[1.0, 1.0, -1.0, 0.0, 0.0, 0.0, 0.0], AUTHORITY[EPSG,6269]], PRIMEM[Greenwich, 0.0, AUTHORITY[EPSG,8901]], UNIT[degree, 0.017453292519943295], AXIS[Geodetic longitude, EAST], AXIS[Geodetic latitude, NORTH], AUTHORITY[EPSG,4269]], PROJECTION[Albers Equal Area, AUTHORITY[EPSG,9822]], PARAMETER[central_meridian, -96.0], PARAMETER[latitude_of_origin, 23.0], PARAMETER[standard_parallel_1, 29.5], PARAMETER[false_easting, 0.0], PARAMETER[false_northing, 0.0], PARAMETER[standard_parallel_2, 45.5], UNIT[m, 1.0], AXIS[Easting, EAST], AXIS[Northing, NORTH], AUTHORITY[EPSG,5070]]' srs.ImportFromWkt([wkt]) srs.ExportToProj4() But I get ERROR 6: No translation for Albers Equal Area to PROJ.4 format is known. Anybody knows how can I get the PROJ4TEXT from this? Ideally what I would like is to inspect automatially a shapefile coming with a .prj file, try to find if it is in PostGIS and if not register the proj and import the data using shp2psql. Thanks for any advice, Javier. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Importing a shape file with NAD83 / Conus Albers
Thanks Paul, Now, it is a pity there is no way to automate this to a decent level. Is there nobody working on a generic shapefile importer that can accept any sort of shapefile and try to load it using the .prj file? I will keep trying :) Javier. On Aug 15, 2011, at 5:55 PM, Paul Ramsey wrote: Very odd. Well, the proj4text you want is: +proj=aea +lon_0=-96 +lat_0=23 +lat_1=29.5 +lat_2=45.5 +datum=NAD83 But, why OGR cannot produce that? Don't know. P On Mon, Aug 15, 2011 at 2:38 PM, Javier de la Torre jato...@vizzuality.com wrote: You mean: srs.MorphFromESRI() srs.ExportToProj4() That still produce srs.ExportToProj4() ERROR 6: No translation for Albers Equal Area to PROJ.4 format is known. On Aug 15, 2011, at 5:28 PM, Paul Ramsey wrote: Try running MorphFromESRI on the srs before generating the proj4? P On Mon, Aug 15, 2011 at 2:25 PM, Javier de la Torre jato...@vizzuality.com wrote: Hi all, I got a shapefile with a .prj file on it. I pasted the contents to http://prj2epsg.org and got that this http://prj2epsg.org/epsg/5070 This srs does not seem to be in PostGIS so I am trying to add it. Now, the first thing I tried was sending it to spatialreference and I got this http://spatialreference.org/ref/sr-org/7178/ But it does not seem to include the proj4text data needed for postgis to do transformations. I then tried loading it in OGR with Python doing this: srs = osr.SpatialReference() wkt = 'PROJCS[NAD83 / Conus Albers, GEOGCS[NAD83, DATUM[North American Datum 1983, SPHEROID[GRS 1980, 6378137.0, 298.257222101, AUTHORITY[EPSG,7019]], TOWGS84[1.0, 1.0, -1.0, 0.0, 0.0, 0.0, 0.0], AUTHORITY[EPSG,6269]], PRIMEM[Greenwich, 0.0, AUTHORITY[EPSG,8901]], UNIT[degree, 0.017453292519943295], AXIS[Geodetic longitude, EAST], AXIS[Geodetic latitude, NORTH], AUTHORITY[EPSG,4269]], PROJECTION[Albers Equal Area, AUTHORITY[EPSG,9822]], PARAMETER[central_meridian, -96.0], PARAMETER[latitude_of_origin, 23.0], PARAMETER[standard_parallel_1, 29.5], PARAMETER[false_easting, 0.0], PARAMETER[false_northing, 0.0], PARAMETER[standard_parallel_2, 45.5], UNIT[m, 1.0], AXIS[Easting, EAST], AXIS[Northing, NORTH], AUTHORITY[EPSG,5070]]' srs.ImportFromWkt([wkt]) srs.ExportToProj4() But I get ERROR 6: No translation for Albers Equal Area to PROJ.4 format is known. Anybody knows how can I get the PROJ4TEXT from this? Ideally what I would like is to inspect automatially a shapefile coming with a .prj file, try to find if it is in PostGIS and if not register the proj and import the data using shp2psql. Thanks for any advice, Javier. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How do you use PostGIS Raster?
Hi, We are planning on using it to calculate carbon sequestration on protected areas. This is a project by the Convention on Biological Diversity http://www.cbd.int/lifeweb/carbon/ It basically is an intersection of a raster with bit vectors. Best, Javier. On Jun 8, 2011, at 10:09 PM, Mathieu Basille wrote: Dear Pierre, Here, we are using PostGIS to analyze large datasets combining rasters and vectors. Basically, we are looking at movement and habitat selection in a predator-prey system, using GPS-collar data over large areas. The major use of PostGIS Raster is for the intersection of prey steps (line segments or buffers around these segments) with different raster: Landsat (landcover type), slope, road density, relative probability of occurrence of the predator, etc. Note that we first tried to use ArcGIS for this step, without success, due to many bugs and the need to correct them by hand (which was largely too time-consuming). We also used PostGIS Raster to intersect predator locations with the Landsat map to estimate Resource Selection Functions (RSF) in order to build maps of relative probability of occurrence. In the end, information of the intersections were used in R to characterize movements of the preys on the landscape. Best, Mathieu Basille. Le 03/06/2011 08:28, Pierre Racine a écrit : Hi all, I'm preparing a presentation and I need some use cases for PostGIS Raster. I would be grateful if people already using the raster side of PostGIS would describe what they already do it. Bborie, Jorge, Regina, others? These uses cases are vital for the project. On my side we are using PostGIS raster to do raster/vector analysis over large datasets. Basically determining mean values for temperature (raster), elevation (raster) for fauna observations (point buffers). Converting everything to vector and using desktop solutions proved impracticable for datasets covering the extent of Canada. For those who did not try the raster extension yet, don't be shy to express your planned experiments or your expectations. Thanks all for your contribution to the project, Pierre ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- ~$ whoami Mathieu Basille, Post-Doc ~$ locate Laboratoire d'Écologie Comportementale et de Conservation de la Faune + Centre d'Étude de la Forêt Département de Biologie Université Laval, Québec ~$ info http://ase-research.org/basille ~$ fortune ``If you can't win by reason, go for volume.'' Calvin, by Bill Watterson. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How do you use PostGIS Raster?
Now we are using an open source software called starspan. It actually works pretty well. What we do is have a server with the raster and a web server exposing an API. It accepts a polygon as geojson and in command line calculate the vsum of the carbon value using starspan. In PostGIS we could do many more things like intersections and stuff like this before calculating the sum of the raster value. We could stored polygons and with simple sql statements calculate their values... well lot more flexibility in general. Best, On Jun 9, 2011, at 9:29 AM, Pierre Racine wrote: Thanks Javier, Nice application. What do you use now and why do you plan on using PostGIS? Is it possible to upload a shapefile and get the carbon sequestrated for the area covered by the shapefile? Pierre -Original Message- From: Javier de la Torre [mailto:jato...@vizzuality.com] Sent: Thursday, June 09, 2011 3:42 AM To: PostGIS Users Discussion Cc: marie-...@lists.refractions.net; Pierre Racine; ude Labbé Subject: Re: [postgis-users] How do you use PostGIS Raster? Hi, We are planning on using it to calculate carbon sequestration on protected areas. This is a project by the Convention on Biological Diversity http://www.cbd.int/lifeweb/carbon/ It basically is an intersection of a raster with bit vectors. Best, Javier. On Jun 8, 2011, at 10:09 PM, Mathieu Basille wrote: Dear Pierre, Here, we are using PostGIS to analyze large datasets combining rasters and vectors. Basically, we are looking at movement and habitat selection in a predator-prey system, using GPS-collar data over large areas. The major use of PostGIS Raster is for the intersection of prey steps (line segments or buffers around these segments) with different raster: Landsat (landcover type), slope, road density, relative probability of occurrence of the predator, etc. Note that we first tried to use ArcGIS for this step, without success, due to many bugs and the need to correct them by hand (which was largely too time-consuming). We also used PostGIS Raster to intersect predator locations with the Landsat map to estimate Resource Selection Functions (RSF) in order to build maps of relative probability of occurrence. In the end, information of the intersections were used in R to characterize movements of the preys on the landscape. Best, Mathieu Basille. Le 03/06/2011 08:28, Pierre Racine a écrit : Hi all, I'm preparing a presentation and I need some use cases for PostGIS Raster. I would be grateful if people already using the raster side of PostGIS would describe what they already do it. Bborie, Jorge, Regina, others? These uses cases are vital for the project. On my side we are using PostGIS raster to do raster/vector analysis over large datasets. Basically determining mean values for temperature (raster), elevation (raster) for fauna observations (point buffers). Converting everything to vector and using desktop solutions proved impracticable for datasets covering the extent of Canada. For those who did not try the raster extension yet, don't be shy to express your planned experiments or your expectations. Thanks all for your contribution to the project, Pierre ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- ~$ whoami Mathieu Basille, Post-Doc ~$ locate Laboratoire d'Écologie Comportementale et de Conservation de la Faune + Centre d'Étude de la Forêt Département de Biologie Université Laval, Québec ~$ info http://ase-research.org/basille ~$ fortune ``If you can't win by reason, go for volume.'' Calvin, by Bill Watterson. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Announcement: PostGIS Versioning System pgversion and QGIS Plugin
Hi, Thats great. Congratulations. One question. If I understand correctly you are using the DB users for the versioning. How easy would be to use external users from, for example a web system? We normally do not use the users on PostgreSQL for the data content. Are you planning something on this direction? Thanks. Javier www.vizzuality.com On Nov 8, 2010, at 8:43 AM, Düster Horst wrote: I just finished the first beta version of my newly released pgvs support system. The idea of this system is to enable the editing of a single PostGIS layer concurrently by more than one user at the same time, similar to source code versioning systems like CVS or Subversion. You will find further informations at: http://www.kappasys.org/cms/index.php?id=23L=5 You can download the PostGIS functions from: http://www.kappasys.ch/pgtools/pgversion/createFunctions.sql To get easy access to pgvs I additionally created the QGIS plugin pgversion which you can download from: http://www.kappasys.org/qgis/plugins.xml I know that not all features of a SVN like system are implemented yet. But I would like to get your comments and ideas for further developements. I hope that pgvs can make your life easier. Regards Horst Dr. Horst Düster Stv. Amtschef / kantonaler GIS-Koordinator Kanton Solothurn Bau- und Justizdepartement Amt für Geoinformation SO!GIS Koordination Rötistrasse 4 CH-4501 Solothurn Telefon ++41(0)32 627 25 32 Mobil ++41(0)79 511 54 12 Telefax ++41(0)32 627 22 14 mailto:horst.dues...@bd.so.ch http://www.agi.so.ch ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] WKT raster installation on Mac Snow Leopard
postgis: export MACOSX_DEPLOYMENT_TARGET=10.6 export CFLAGS=-Os -arch i386 -arch x86_64 export PG_CPPFLAGS=-arch i386 -arch x86_64 export SHLIB_LINK=-arch i386 -arch x86_64 export LDFLAGS=-arch i386 -arch x86_64 ./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config \ --with-geosconfig=/Library/Frameworks/GEOS.framework/Programs/geos-config \ --with-projdir=/Library/Frameworks/PROJ.framework/unix wktraster: export MACOSX_DEPLOYMENT_TARGET=10.6 export CFLAGS=-Os -arch i386 -arch x86_64 export PG_CPPFLAGS=-arch i386 -arch x86_64 export SHLIB_LINK=-arch i386 -arch x86_64 export LDFLAGS=-arch i386 -arch x86_64 ./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config \ --with-gdal=/Library/Frameworks/GDAL.framework/Programs/gdal-config \ --with-geos=/Library/Frameworks/GEOS.framework/Programs/geos-config \ --with-postgis-sources=/Users/jatorre/workspace/postgis-1.5.1 By the way, this worked like a charm. Thanks! ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] OS X WKTRaster installer now available
Great! Thanks. Javier www.vizzuality.com On 22/07/2010, at 02:52, William Kyngesburye wokl...@kyngchaos.com wrote: OK, here you go! Ready to use with my Postgres/PostGIS packages. Sorry, I haven't done any testing. http://www.kyngchaos.com/software/postgres - William Kyngesburye kyngchaos*at*kyngchaos*dot*com http://www.kyngchaos.com/ Theory of the Universe There is a theory which states that if ever anyone discovers exactly what the universe is for and why it is here, it will instantly disappear and be replaced by something even more bizarrely inexplicable. There is another theory which states that this has already happened. -Hitchhiker's Guide to the Galaxy 2nd season intro ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] WKT raster installation on Mac Snow Leopard
Hi, I make use of the Kyngchaos builds for Postgis in Mac OS X Snow Leopard (10.6.4). I am trying to install the WKT raster on my existing PostGIS but I havent succeed. I have tried downloading the same version of PostGIS code that I have installed via Kyngchaos and use it to compile WKT raster. I had to copy config.sub and config.guess because it was complaining and then I ran: ./configure --with-postgis-sources=/Users/jatorre/workspace/postgis-1.5.1/ --with-pgconfig=/usr/local/pgsql/bin/pg_config --with-gdal=/Library/Frameworks/GDAL.framework/unix/bin/gdal-config --with-geos=/Library/Frameworks/GEOS.framework/unix/bin/geos-config But the error I get is: ld: symbol(s) not found for architecture i386 collect2: ld returned 1 exit status ld: warning: directory '/Users/Shared/unix/gettext-snow/lib' following -L not found lipo: can't open input file: /var/folders/9N/9NtAH8bAEhe6+LEqwLi43E+++TI/-Tmp-//cc15Lk7k.out (No such file or directory) make[1]: *** [rtpostgis.so] Error 1 make: *** [pglib] Error 2 If I try to compile postgis I get the same error. I took a look at how the sources from kyngchaos were created (http://www.kyngchaos.com/macosx/build/postgis) but they are not up to date with Snow Leopard. Anybody has succeed previously? Thanks. Javier.___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Union a very big Multipolygon table with self intersections
Hi all, I have a table with a MULTIPOLYGON field with around 100k records. Some of these records, 2K have self intersections and other problems that make ST_IsValid return false. The polygons overlap a lot and I wanted to generate another table that will be the union of all polygons. The table looks like id, the_geom What would be the best way to union all of the geometries into a new table where there is only POLYGONS that do not overlap? Thanks in advance. Javier. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users