4,525 reputation
1821
bio website boringnerdystuff.wordpress.co…
location Indiana, USA
age
visits member for 2 years, 2 months
seen 8 hours ago

Jan
23
reviewed Reject Embedded spatial database for Java
Jan
22
comment Arcgis not seeing my column header to join tables
How is the data table you trying to join to stored? What format is it in?
Jan
21
answered Can I achieve one-to-many relationship in QGIS custom forms?
Jan
21
comment PostGIS ST_SummaryStats
Boston GIS has a nice, short PL/R tutorial and it includes how to build a median function for Postgres. bostongis.com/…
Jan
20
reviewed Approve When to use IDW vs Kriging Interpolation for DEM creation?
Jan
20
answered using PostGIS to calculate distance of a route over a large area
Jan
20
comment How to optimize a ST_Within query to count lightning occurrences inside a country?
What are the specs for your database server? Hardware might be an issue. Also, would you mind posting the full output from EXPLAIN? It may shed some light on the slowest part of your query and give an idea on how the query may be optimized.
Jan
20
reviewed Approve Can I use QGIS 2.0.1 with the National Hydrography Dataset (NHD)?
Jan
20
comment How to optimize a ST_Within query to count lightning occurrences inside a country?
Do you have a spatial index on your lightning strike table? An index on the table with your country's boundary probably wouldn't make much difference since it is just 1 row.
Jan
19
reviewed Approve Is there an alternative for ERDAS IMAGINE AutoSync (eventuelly for QuantumGis)?
Jan
17
reviewed Approve How to paint area below certain elevation, using no coding and Google Maps, Google Earth, Bing
Jan
17
reviewed Approve Create a single line from a resultset of line segments
Jan
17
answered Capturing GPS coordinates on the ground in Boliva?
Jan
17
comment Does QGIS attribute edit form support “relationship” data?
Check out the Data Driven Input Mask plugin. I haven't tried it, but its documentation says it can handle one to many relationships.
Jan
17
comment ST_Intersects incorrectly returning false in PostGIS
Yes, 4326 is the EPSG code for WGS84 lat/long. That's the system that GPS uses, and most of the time when you see coordinates in lat / long they're WGS84 coordinates. Another common one is NAD83 lat/long which I think is EPGS code 4269. You'll see it if you use TIGER data directly from the Census folks. The points you didn't need to use ST_Transform were in the NAD83 lat / long, which is very similar to WGS84. So that's why it worked without re-projecting your points.
Jan
17
revised ST_Intersects incorrectly returning false in PostGIS
added 173 characters in body
Jan
17
revised ST_Intersects incorrectly returning false in PostGIS
added 173 characters in body
Jan
17
answered ST_Intersects incorrectly returning false in PostGIS
Jan
17
comment Esri File GDB multi-user edit through QGIS
Even in the ESRI environment File geodatabases are single editor. For multiuser editing in PostGIS see this question: gis.stackexchange.com/questions/66784/…
Jan
17
answered Esri File GDB multi-user edit through QGIS