4,223 reputation
719
bio website boringnerdystuff.wordpress.co…
location Indiana, USA
age
visits member for 1 year, 11 months
seen Aug 22 at 13:32

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 suggested edit on 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 suggested edit on Is there an alternative for ERDAS IMAGINE AutoSync (eventuelly for QuantumGis)?
Jan
17
reviewed Approve suggested edit on How to paint area below certain elevation, using no coding and Google Maps, Google Earth, Bing
Jan
17
reviewed Approve suggested edit on 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
Jan
17
answered Adding a GIS feature to existing database entry with QGIS
Jan
16
revised How to use the linear referencing plugin?
Spelling and grammar fixes
Jan
16
comment Access Shapefiles from PostgreSQL/Postgis in R
It can be faster, especially if most of your work is being done on the database side. Another benefit is you can create a function that you can call from queries. You can use that function in QGIS to display your data, or as part of a web application.
Jan
15
comment Access Shapefiles from PostgreSQL/Postgis in R
In addition to Evil Genius' answer below, double check to make sure the PostGIS extension was installed in your database. Unless it has been added to the default template PostGIS won't be in a newly created Postgres database.
Jan
15
comment Access Shapefiles from PostgreSQL/Postgis in R
I agree, going through unixODBC is extra, unnecessary step that adds a middleman between you and your data. Other than that the example that Joschi was working from looks really good. I'd check out PL/R as the example mentions down towards the bottom, it brings R directly into your Postgres database.
Jan
14
comment why must Qgis 2.0.1 Desktop access the internet when I start it?
Does it start up if you're not connected to the internet in general or only if you block it through the firewall? QGIS will check for updates to the main program itself, but I think only if you force the check. The only other place it might be going out looking for stuff is in Settings -> Options -> Network. Clear the WMS search address and see if that helps.