meta user
network profile
| bio | website | boringnerdystuff.wordpress.co… |
|---|---|---|
| location | Indiana, USA | |
| age | ||
| visits | member for | 7 months |
| seen | 4 hours ago | |
| stats | profile views | 33 |
|
Feb 14 |
answered | PostGIS: Search lat/Long within Polygon |
|
Feb 13 |
comment |
Does anyone know of an explicit formula that I can plug-n-chug with to convert WGS84 lat lon to kilometers or miles? As ccn said, find out which coordinate system works for your part of the world. Your best bet will probably be which ever UTM zone applies for the part of the world your data covers, that will give you the coordinates in meters. |
|
Feb 13 |
answered | Does anyone know of an explicit formula that I can plug-n-chug with to convert WGS84 lat lon to kilometers or miles? |
|
Feb 13 |
comment |
Why is st_intersects giving bad results? Quick note, to find your exact version you can use SELECT postgis_version(); or to find your version and the versions of all of PostGIS's dependencies you can use SELECT postgis_full_version(); |
|
Feb 7 |
comment |
ESRI State Plane Coordinates as EPSG I had a similar problem: gis.stackexchange.com/questions/43378/… |
|
Feb 4 |
answered | Problem with postgis |
|
Feb 4 |
comment |
Why won't osm2po setup table correctly? If deleting the table and re-running the sql script fixes it, then the sql script probably has a CREATE TABLE IF NOT EXISTS statement, so if the table exists it skips on to the next step. By deleting the table the CREATE TABLE step is run and you get the table with all the new fields defined. |
|
Feb 1 |
comment |
How do I read a File Geodatabase using R? Oh that's true! You can also use the Xtools toolbar to export the attribute table directly to Excel. The free version of the toolbar includes the Excel export ability. xtoolspro.com |
|
Feb 1 |
answered | How do I read a File Geodatabase using R? |
|
Feb 1 |
comment |
St_buffer width issues First step is to determine what projection your data is in. You can find this in PostGIS, in the geometry_columns table there will be a field called srid. This srid is a reference number that tells you what projection you're using. You can look up that code on spatialreference.org to determine what units are being used. Then you can either transfer the data to a new table and reproject it or update the geometry column of the current table to the projection of your choice. Either way you want to use the st_transform function to reproject your data. |
|
Feb 1 |
answered | St_buffer width issues |
|
Jan 25 |
comment |
“Please ensure that the GDAL_DATA environment variable is set and try again” on Kubuntu 12.10 If you want to set the variable for all users add export GDAL_DATA=/usr/share/gdal/1.9 to a new line in your /etc/environment file. This would be a good place for it if you ever decide to switch from KDE to a different desktop. |
|
Jan 24 |
answered | Advice in setting up foundational OSGeo enterprise GIS |
|
Jan 24 |
comment |
How to Intersect a layer with custom CRS with NED data? I had a similar question and the answer came down to a slight difference between ESRI's definition of the state plane I was using and EPSG's definition. Andre Joost provided a great answer and calculated the difference between the two to be 0.009 mm. gis.stackexchange.com/questions/43378/… |
|
Jan 22 |
answered | Quantum GIS returns “Invalid Layer” message when trying to add Postgis view |
|
Jan 17 |
answered | Can I download the current version of QGIS if I am running Mac 10.8.2? |
|
Jan 15 |
answered | How to subset X number of features from Shape file in QGIS |
|
Jan 14 |
awarded | Organizer |
|
Jan 14 |
revised |
Field Type Date invalid when run in Python, but not in Model edited tags |
|
Jan 14 |
revised |
Visualize Spatial Data in Reporting Service corrected spelling |
