[postgis-users] Sol Katz Award 2010 Nomination Call
The Open Source Geospatial Foundation would like to open nominations for the 2010 Sol Katz Award for Geospatial Free and Open Source Software. The Sol Katz Award for Geospatial Free and Open Source Software (GFOSS) will be given to individuals who have demonstrated leadership in the GFOSS community. Recipients of the award will have contributed significantly through their activities to advance open source ideals in the geospatial realm. Sol Katz was an early pioneer of GFOSS and left behind a large body of work in the form of applications, format specifications, and utilities while at the U.S. Bureau of Land Management. This early GFOSS archive provided both source code and applications freely available to the community. Sol was also a frequent contributor to many geospatial list servers, providing much guidance to the geospatial community at large. Sol unfortunately passed away in 1999 from Non-Hodgkin's Lymphoma, but his legacy lives on in the open source world. Those interested in making a donation to the American Cancer Society, as per Sol's family's request, can do so at https://www.cancer.org/involved/donate/donateonlinenow/index. Nominations for the Sol Katz Award should be sent to solkatzaw...@osgeo.org with a description of the reasons for this nomination. Nominations will be accepted until 23:59 UTC on August 20th (http://www.timeanddate.com/worldclock/fixedtime.html?month=8&day=20&year=2010&hour=23&min=59&sec=59). A recipient will be decided from the nomination list by an OSGeo designated selection committee. The winner of the Sol Katz Award for Geospatial Free and Open Source Software will be announced on September 9th at the FOSS4G 2010 conference (http://2010.foss4g.org/) closing plenary in Barcelona, Spain. The hope is that the award will both acknowledge the work of community members, and pay tribute to one of its founders, for years to come. It should be noted that past awardees and selection committee members are not eligible. Past Awardees: 2009: Daniel Morissette 2008: Paul Ramsey 2007: Steve Lime 2006: Markus Neteler 2005: Frank Warmerdam Selection Committee: Jeff McKenna (chair) Daniel Morissette Frank Warmerdam Markus Neteler Steve Lime Paul Ramsey Sophia Parafina ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Space partitioning index for points
postgis-users-boun...@postgis.refractions.net wrote on 07/02/2010 12:26:43 AM: > GeoHash doesn't cut it? It's space partitioned, just not as balanced > as a kd-tree, but for points... no? I'll look up my info on the GiST > work that was done, but note that it didn't make it into 9.0, but into > 9.1, and as I recall Oleg and co did not seem to think the kd > implementation was going to be very effective. At this point I'm just considering solutions on the conceptual level to identify promising candidates. GeoHash is promising. However, my issue with GeoHash is that it linearizes a 2d problem, much like space-filling curves. (i.e., you never know how far away a "close" geohash-value is; conversely: identifying all the "near" geohashes presents an issue). Besides: GeoHash is global and our study is regional. 2/3 or more of the hash values will be empty, while the others will be chock full of points. Also, our region extends from 20-80 degrees N. GeoHashes aren't a constant-distance metric, they're constant-angle. We're going to have fat cells toward the south and skinny ones in the north. The most conceptually pleasing approach for this proximity-based function would be to operate on the kd tree itself, minimizing the number of searches. At most, a "proximity" search from a known point in the tree may have to pop up a couple of levels (to check the neighbors), and the _same_ proximity search could be re-used for all nodes under the same subtree. Directly navigating a spatial index which retains the spatial identity of the indexed points seems like the most efficient way to do this. I guess in database terms, I'm talking about implementing a new "cursor" which leverages a hierchical structure like the kd-tree (to walk thru the points using the proximity information in the tree). Simultaneously: implementing a caching proximity search on the tree itself which can re-use previous searches from the same subtree. That way, proximity searches from points under the same subtree needn't be repeated. This is perhaps not a topic for the users list. If I flesh the idea out more, I'll use the wiki. We've been granted a reprieve for the moment by selecting a "case study" which needs only 3 million out of 90 million points. However, we're eventually going to have to suck it up and process everything. So we've got a bit of time to mull it over; and/or review the literature for smart ways to use a kd-tree/other scheme. Bryce ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] couldn't manage to update a table containing line geometry
ahmet temiz wrote: hello I couldn't manage to update a table containing line geometry. I want to update id_no of these line with the polygons' id_no that contain these lines. something like: line id will be polygon id, where polygons contain lines involved. update line as a set a.id_no=b.id_no from polygons b where a.the_geom b.the_geom; Replace with the spatial relationship you are interested in. This will likely fail if the where clause returns more than one record. For example you have two overlapping polygons and both of them contain the line you are testing. -Steve ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] shortest distance of a line to boundary
ahmet temiz wrote: hello I have lines within polygons. how can find the shortest distance from the lines that are within the polygons to boundary of these polygons ? You could extract the polygon rings and then compute the distance to each of those from the interior lines. -Steve ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Invalid geometry when using select AsText
> Thanks for the quick response, > > This is a extract of the query AsText from the original column(before > transformation) This srid is suposed to be 4326 and I want to make it > 900913. > > "MULTIPOLYGON(((-203203.329774775 921205.762417328,-201414.754122524 > 920564.899066353,….etc etc etc ……..,-263950.345631436 > 1215368.70793936,-263772.821121782 1216068.78335908,-263784.403196605 > 1216749.98205891,-263958.177279213 1216452.48684392)))" > > btw this is a piece the geometry of norway. > > greetz...Ramses These coordinates do not correspond to WGS84 (long-lat, values between -180, +180 for longitudes, -90, +90 for latitude). Maybe try to find a SRID for Norway (spatialreference.org may help for that) Nicolas ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Invalid geometry when using select AsText
Hey Ben, thanks for the quick reply. This is a piece of the geometry: "MULTIPOLYGON(((-203203.329774775 921205.762417328,-201414.754122524 920564.899066353,….etc etc etc ……..,-263950.345631436 1215368.70793936,-263772.821121782 1216068.78335908,-263784.403196605 1216749.98205891,-263958.177279213 1216452.48684392)))" These are the values when I query AsText from the original data, and it represents a piece of norway. Does this mean anything to you? I will try the 32630 and get back to you. Ben Madin-3 wrote: > > Ramses, > > On 06/07/2010, at 17:37 , rdelisabeth wrote: > >> My problem is the following. I also have some data from my colleagues >> from >> Spain. Their data supposedly is in "WGS1984" epsg "4326". So I >> transformed >> it to 900913 as I did with my other data. So far so good. BUT when I do a >> SELECT AsText from one of the geometries I get the following: >> >> "MULTIPOLYGON(((inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf >> inf,inf >> inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf >> inf, >> ...etc etc ... inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf >> inf,inf inf,inf inf),(inf inf,inf inf,inf inf,inf inf,inf inf)))" >> >> I think this means that the geometry is invalid. When I read it from my >> application using Hibernate spatial I get an error like invalid geometry. > > I wonder if you have data from a UTM Grid - do the values look like > reasonable longitude and latitude values (in degrees) for Spain. I'm on > the wrong side of the planet to be sure what is right, but if you have any > values greater than about 45, I think you probably have WGS84 UTM values, > which would be in the 10's to 100's of thousands. > > instead of 4326 try something like 32630... just a guess. > > cheers > > Ben > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://old.nabble.com/Invalid-geometry-when-using-select-AsText-tp29083589p29085580.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Invalid geometry when using select AsText
Thanks for the quick response, This is a extract of the query AsText from the original column(before transformation) This srid is suposed to be 4326 and I want to make it 900913. "MULTIPOLYGON(((-203203.329774775 921205.762417328,-201414.754122524 920564.899066353,….etc etc etc ……..,-263950.345631436 1215368.70793936,-263772.821121782 1216068.78335908,-263784.403196605 1216749.98205891,-263958.177279213 1216452.48684392)))" btw this is a piece the geometry of norway. greetz...Ramses Nicolas Ribot-2 wrote: > >> >> I am doing a GIS project where I combine shapefiles from different >> sources, >> created with different spatial reference systems. >> >> What I want to achieve is that if someone has a shapefile, no matter what >> the srs is, the data can be combined with other data. All data will be >> tranformed to srid 900913. >> >> I succeeded in combining data from my Dutch and Belgian colleagues by >> using >> the postgis transform function and transforming the geometries from >> "28992"( >> Amersfoort / RD New) and "31370"(Belge 1972 / Belgian Lambert 72) to >> 900913. >> This works perfeclty, the map of the Netherlands and Belgium are >> displayed >> as they should. >> >> My problem is the following. I also have some data from my colleagues >> from >> Spain. Their data supposedly is in "WGS1984" epsg "4326". So I >> transformed >> it to 900913 as I did with my other data. So far so good. BUT when I do a >> SELECT AsText from one of the geometries I get the following: >> >> "MULTIPOLYGON(((inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf >> inf,inf >> inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf >> inf, >> ...etc etc ... inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf >> inf,inf inf,inf inf),(inf inf,inf inf,inf inf,inf inf,inf inf)))" >> >> I think this means that the geometry is invalid. When I read it from my >> application using Hibernate spatial I get an error like invalid geometry. >> >> I tried transforming from 4326 to 900913 and also from 94326 to 900913 >> but >> with no luck. >> >> Has anyone ever got this problem or does anyone knows what is going on >> here? >> >> Thank you, >> >> Ramses > > Hi, > What the spain data look like ? Could you post some extract of it (astext) > ? > It seems the data range is not compatible with WGS84, thus generating > invalid coordinates when transformed. > > Nicolas > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- View this message in context: http://old.nabble.com/Invalid-geometry-when-using-select-AsText-tp29083589p29085540.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Invalid geometry when using select AsText
Ramses, On 06/07/2010, at 17:37 , rdelisabeth wrote: > My problem is the following. I also have some data from my colleagues from > Spain. Their data supposedly is in "WGS1984" epsg "4326". So I transformed > it to 900913 as I did with my other data. So far so good. BUT when I do a > SELECT AsText from one of the geometries I get the following: > > "MULTIPOLYGON(((inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf > inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf, > ...etc etc ... inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf > inf,inf inf,inf inf),(inf inf,inf inf,inf inf,inf inf,inf inf)))" > > I think this means that the geometry is invalid. When I read it from my > application using Hibernate spatial I get an error like invalid geometry. I wonder if you have data from a UTM Grid - do the values look like reasonable longitude and latitude values (in degrees) for Spain. I'm on the wrong side of the planet to be sure what is right, but if you have any values greater than about 45, I think you probably have WGS84 UTM values, which would be in the 10's to 100's of thousands. instead of 4326 try something like 32630... just a guess. cheers Ben ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] error updating multipoint: violates check constraint enforce_geotype
> Hi everyone,
>
> I have a program that updates a table containing multipoints.
> Now, I have several columns with multipoints, but only one breaks with the
> following error:
>
> org.postgresql.util.PSQLException: ERROR: new row for relation "lidarpoints"
> violates check constraint "enforce_geotype_numtarclassidreflect"
>
> The code and setup for the other multipoint geometries is exactly the same,
> which is why I am surprised that it's not working for this one case. I feel
> I am overlooking something simple.
>
> My update sql is:
> "update lidarpoints set numtarclassidreflect =
> ST_UNION(numtarclassidreflect, ST_GeomFromEWKT('SRID=4326;MULTIPOINT(2 0
> -1436)')) where lidarpts_id = currentRowID;"
>
> Does anybody know anything about this?
>
Hi,
What is the geographic type of the ST_UNION returned by your query ?
Can it be null, and no constraint allowing null geometries exists in the table ?
Nicolas
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] error updating multipoint: violates check constraint enforce_geotype
Hi everyone,
I have a program that updates a table containing multipoints.
Now, I have several columns with multipoints, but only one breaks with
the following error:
org.postgresql.util.PSQLException: ERROR: new row for relation
"lidarpoints" violates check constraint
"enforce_geotype_numtarclassidreflect"
The code and setup for the other multipoint geometries is exactly the
same, which is why I am surprised that it's not working for this one
case. I feel I am overlooking something simple.
My update sql is:
"update lidarpoints set numtarclassidreflect =
ST_UNION(numtarclassidreflect, ST_GeomFromEWKT('SRID=4326;MULTIPOINT(2
0 -1436)')) where lidarpts_id = currentRowID;"
Does anybody know anything about this?
Any help is greatly appreciated,
B.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Invalid geometry when using select AsText
> > I am doing a GIS project where I combine shapefiles from different sources, > created with different spatial reference systems. > > What I want to achieve is that if someone has a shapefile, no matter what > the srs is, the data can be combined with other data. All data will be > tranformed to srid 900913. > > I succeeded in combining data from my Dutch and Belgian colleagues by using > the postgis transform function and transforming the geometries from "28992"( > Amersfoort / RD New) and "31370"(Belge 1972 / Belgian Lambert 72) to 900913. > This works perfeclty, the map of the Netherlands and Belgium are displayed > as they should. > > My problem is the following. I also have some data from my colleagues from > Spain. Their data supposedly is in "WGS1984" epsg "4326". So I transformed > it to 900913 as I did with my other data. So far so good. BUT when I do a > SELECT AsText from one of the geometries I get the following: > > "MULTIPOLYGON(((inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf > inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf, > ...etc etc ... inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf > inf,inf inf,inf inf),(inf inf,inf inf,inf inf,inf inf,inf inf)))" > > I think this means that the geometry is invalid. When I read it from my > application using Hibernate spatial I get an error like invalid geometry. > > I tried transforming from 4326 to 900913 and also from 94326 to 900913 but > with no luck. > > Has anyone ever got this problem or does anyone knows what is going on here? > > Thank you, > > Ramses Hi, What the spain data look like ? Could you post some extract of it (astext) ? It seems the data range is not compatible with WGS84, thus generating invalid coordinates when transformed. Nicolas ___ 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
On Mon, Jul 5, 2010 at 6:15 PM, Shaun Langley wrote: > it returns /Library/PostgreSQL/8.4/lib > > what's the option syntax to add the lib directory during configuration? can > I specify something like > > --with-libdir='/Library/PostgreSQL/8.4/lib' > The option should be --libdir='/Library/PostgreSQL/8.4/lib'. Give it a try Best regards, Jorge > Cheers, > Shaun > On Jul 5, 2010, at 11:51 AM, Jorge Arévalo wrote: > >> On Mon, Jul 5, 2010 at 5:19 PM, Shaun Langley wrote: >>> Yes it still complains it can't find libpq. >>> >> >> I didn't try it on mac, but in Windows, I had to add the lib directory to >> PATH. >> >> What happens if you execute pg_config --libdir? >> >>> -- >>> Shaun Langley >>> Graduate Student >>> 208 Manly Miles >>> Michigan State University >>> East Lansing, MI 48824 >>> (517) 974-9346 >>> >>> Sent from my iPad >>> >>> >>> On Jul 5, 2010, at 10:48 AM, Pierre Racine >>> wrote: >>> So now that you had it manually does it still complain that it can not find libpq? Some systems need us to explicit some installation paths (like Windows) in the configure command. Pierre > -Original Message- > From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users- > boun...@postgis.refractions.net] On Behalf Of Shaun Langley > Sent: 2 juillet 2010 19:14 > To: postgis-users > Subject: [postgis-users] WKT raster installation on mac > > I'm trying to install WKT Raster on Mac OS X, using the enterprisedb > installation of postgres, and postgis through the stackbuilder. I've > run into a problem when running the ./configure for WKT Raster as it > returns an error saying that it cannot locate libpq. The installation > of postgres is found at /Library/Postgres/8.4/ and libpq is located > within lib/. I had to manully specify the location of pg_config which > I did successfully. Any suggestions on how to proceed? > > Regards, > Shaun > -- > Shaun Langley > Graduate Student, PhD > Department of Geography > Michigan State University > Home: (517) 974-9346 > ___ > 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 >>> >> >> >> >> -- >> Jorge Arévalo >> DEIMOS Space >> Internet & Mobilty Division >> Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º >> 28760 Tres Cantos (Madrid) >> Tel: +34 91 806 34 50 - ext: 155 >> jorge.arev...@deimos-space.com >> http://gis4free.wordpress.com >> ___ >> postgis-users mailing list >> postgis-users@postgis.refractions.net >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- > Shaun Langley > Graduate Student, PhD > Department of Geography > Michigan State University > Home: (517) 974-9346 > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Jorge Arévalo DEIMOS Space Internet & Mobilty Division Ronda de Poniente 19. Edificio Fiteni VI, portal 2, 2º 28760 Tres Cantos (Madrid) Tel: +34 91 806 34 50 - ext: 155 jorge.arev...@deimos-space.com http://gis4free.wordpress.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Invalid geometry when using select AsText
I am doing a GIS project where I combine shapefiles from different sources, created with different spatial reference systems. What I want to achieve is that if someone has a shapefile, no matter what the srs is, the data can be combined with other data. All data will be tranformed to srid 900913. I succeeded in combining data from my Dutch and Belgian colleagues by using the postgis transform function and transforming the geometries from "28992"( Amersfoort / RD New) and "31370"(Belge 1972 / Belgian Lambert 72) to 900913. This works perfeclty, the map of the Netherlands and Belgium are displayed as they should. My problem is the following. I also have some data from my colleagues from Spain. Their data supposedly is in "WGS1984" epsg "4326". So I transformed it to 900913 as I did with my other data. So far so good. BUT when I do a SELECT AsText from one of the geometries I get the following: "MULTIPOLYGON(((inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf, ...etc etc ... inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf,inf inf),(inf inf,inf inf,inf inf,inf inf,inf inf)))" I think this means that the geometry is invalid. When I read it from my application using Hibernate spatial I get an error like invalid geometry. I tried transforming from 4326 to 900913 and also from 94326 to 900913 but with no luck. Has anyone ever got this problem or does anyone knows what is going on here? Thank you, Ramses -- View this message in context: http://old.nabble.com/Invalid-geometry-when-using-select-AsText-tp29083589p29083589.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] couldn't manage to update a table containing line geometry
Hi, Can you send the error message? Luís On Tue, Jul 6, 2010 at 9:02 AM, ahmet temiz wrote: > hello > > I couldn't manage to update a table containing line geometry. > I want to update id_no of these line with the polygons' id_no that > contain these lines. > > something like: > > line id will be polygon id, where polygons contain lines involved. > > > regards > ___ > 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] couldn't manage to update a table containing line geometry
hello I couldn't manage to update a table containing line geometry. I want to update id_no of these line with the polygons' id_no that contain these lines. something like: line id will be polygon id, where polygons contain lines involved. regards ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
