| 02:10:42 | CIA-34: | strk * r2468 /trunk/ ( 21 files in 10 dirs ): Found old GeometrySnapper/LineStringSnapper classes in an unexpected directory. Move them where they belong, sync with JTS-1.10. |
| 02:26:41 | CIA-34: | strk * r2469 /trunk/tests/xmltester/XMLTester.cpp: Add compile-time support to skip use of BinaryOp thus engaging SnapIfNeededOverlayOp used by Geometry methods. Shows that BinaryOp ( GEOS-specific original work ) gives better numerical stability. |
| 06:24:30 | CIA-34: | strk * r2470 /trunk/source/ ( 3 files in 2 dirs ): Sync Envelope to JTS-1.10 |
| 06:29:09 | strk: | bbgeos: status |
| 06:29:10 | bbgeos: | telascience-full: idle, last build 8m00s ago: build successful |
| 06:29:10 | bbgeos: | telascience-quick: idle, last build 3h45m53s ago: failed make |
| 06:29:10 | bbgeos: | telascience-stable: idle, last build 333h24m01s ago: build successful |
| 08:16:28 | Pun-ny: | Hi there, I have a question about the licensing of PostGis. I know its a GPL license. I am still an inexperienced programmer and I am not sure about how the GPL license relates to using PostGIS as a backend. I read that a dynamic link to a GPL library or app forces a app to be under the GPL license also. My first instinct is that I may use PostGIS as backend GIS component for PostgresSQL for a commercial application. I would greatly appre |
| 08:16:28 | Pun-ny: | ciate some clarification. I wanted this specific question answered, and struggled to find any specific info on the web. So asking this question here seemed the best place to get answers. Sorry for the large post. |
| 08:24:02 | nhv: | Pun-ny this thread might help http://postgis.refractions.net/pipermail/postgis-users/2008-May/019521.html |
| 08:24:04 | sigq: | Title: [postgis-users] Postgis License Clarification ( at postgis.refractions.net ) |
| 08:37:03 | Pun-ny: | Thanks nhv, I really appreaciate the clear cut answer. I finally have a clear answer, so for safety sake I will make a legal consultation. Luckily this project is part of a final year BSc Computer Science project, so we have a software law consultation firm at our disposal for free :-D, thx again |
| 09:28:46 | sjzzalx: | Hello. Is there a good free zip code database with a corresponding SRID? |
| 09:29:08 | sjzzalx: | I should use? I have a database from zipcodeworld.com but I can't seem to find anything about what SRID it utilizes. |
| 09:34:09 | ubercore: | hello! I have a table with lat lng columns, and I'd like to add a point column from those lat/lngs. I'm trying to use the PointFromText function in an update, but it's telling me the expression is type geometry and the column is type point |
| 09:35:12 | ubercore: | but it won't let me cast to type point. what am I doing wrong here? |
| 09:42:07 | ubercore: | ahh, I think I see. The lat/lng values are a decimal, which weren't concatenating properly to make the WKT I was trying to use to generate the point |
| 09:51:16 | ubercore: | Ok, I take that explanation back. The WKT is properly formatted, still not liking my update statement though. any suggestions? |
| 09:56:23 | tazle: | you haven't shown us your table definition or your update statement yet |
| 09:57:05 | ubercore: | good point. one second |
| 10:01:46 | ubercore: | here's the schema and the update statement: http://dpaste.com/41190/ |
| 10:01:47 | sigq: | Title: dpaste: #41190 ( at dpaste.com ) |
| 10:03:38 | tazle: | shouldn't you be adding the geometry column with AddGeometryColumn? |
| 10:04:50 | tazle: | also, no need for st_PointGromText, you can use ST_MakePoint |
| 10:04:51 | ubercore: | ahh, yes |
| 10:05:07 | ubercore: | Ok, thanks, that looks like what I was missing |
| 10:05:35 | ubercore: | ( first postgis project, if that wasn't obvious ) |
| 10:08:51 | ubercore: | yup, that does the trick, and explains why the data wasn't showing up in udig. thanks again |
| 10:09:16 | : | * tazle thinks there is a section in the documentation about getting started |
| 10:09:29 | tazle: | I think it shows things like AddGeometryColumn |
| 10:10:24 | ubercore: | yup, there is. |
| 10:23:26 | sjzzalx: | Suppose I have a list of longitude and latitudes, but the sources are unknown. How should I assign an SRID value to this? I understand that PostGIS requires one. |
| 10:25:29 | schabi: | Well - nowadays, WGS84 is common, so you can try that one. |
| 10:34:29 | sjzzalx: | ok. And then if it gives relatively accurate results it's fine, or will the anomalies be less obvious? |
| 10:35:18 | schabi: | Well, when your coordinates are longitude/latitude, it should be fine. |
| 10:35:45 | schabi: | But beware: PostGIS uses decimal representation, not degrees/minutes/seconds, you may need to convert. |
| 11:36:35 | CIA-34: | pramsey * r4070 /trunk/spatial_ref_sys.sql: Add 900913 to allow web mappers a smoother ride. |
| 11:56:25 | sjzzalx: | schabi: thanks. : ) |
| 22:02:33 | robe2: | If per chance you need to convert degrees/minutes/seconds to decimal -- this might help http://www.spatialdbadvisor.com/postgis_tips_tricks/115/dms2dd-for-postgis |
| 22:17:39 | cgs_bob: | robe2: hello there. just saw that page. thanks for pointing it out. one thing I would like to see is a way to go from decimal to USGS quad codes. |
| 22:18:50 | robe2: | Which quads are you talking about. I thought the quad codes would depend on whether its 24 k and so forth? |
| 22:19:31 | robe2: | For that you would load up the USGS quads and then do an ST_Intersects to pull the right quad code for each point -- whatever quad it falls in |
| 22:19:38 | cgs_bob: | I'm interested in the 24K quads |
| 22:20:28 | robe2: | Yes then just import them. I forget the spatial ref those are in. But you would just do an update statements something of the form |
| 22:20:39 | cgs_bob: | well that is too easy : ) |
| 22:21:29 | robe2: | UPDATE mypoints SET quad_code = usgs24.quad_code FROM usgs24 WHERE ST_Intersects( mypoints.the_geom,usgs24.the_geom ) |
| 22:22:33 | robe2: | You might need to ST_Transform your point before applying ST_Intersects if its in different spatial_ref. I think quads may be in natial atlas SRID 2163, but would depned where you got it from |
| 22:23:07 | cgs_bob: | got another ohne for you. I have a bunch of coordinates that are in either utm zone 10 or 11 with either nad27 or 83....but there is no metadata to tell which coordinate system it is in. got any ideas on how to sort out my points? |
| 22:39:00 | robe2: | Hmm that's a hard one. Not off hand |
| 22:39:46 | robe2: | I guess I would try to find a point you know exactly where it lies in NAD 83 by overlaying on another well-defined dataset |
| 22:39:59 | robe2: | Then pick which ever one positions in the right spot |
| 22:42:30 | robe2: | Alternatively just bring in as both -- and then overlay the whole thing on against US Quad etc. -- the nad 83 if its right would overlay nicely -- if its not I think you'll see a shift issue and then you know its NAD 27 |
| 22:48:10 | cgs_bob: | robe2: thnks for the tip. I'll try these ideas when I get to work |