Reputation
4,295
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
8 37
Impact
~95k people reached

15h
answered Convert coordinates into decimal using SQL Server
17h
comment In what coordinate systems do true circles appear round?
Thanks, Whuber!
18h
comment In what coordinate systems do true circles appear round?
do you know anyone at PSU that could help adjust that document?
18h
comment In what coordinate systems do true circles appear round?
More on this answer found here: pasda.psu.edu/help/projection.asp
18h
comment ST_Area of a buffer differs by coordinate
Would Anita's answer in this thread overcome the warped circles? gis.stackexchange.com/questions/13258/…
19h
comment ST_Area of a buffer differs by coordinate
4326 is not a coordinate system that should be used for area, distance, length, or generally any calculation beyond location. Try using a projected coordinate system - preferably one that maintains area - and test this out.
1d
comment What are good tips/habits for a future graduate student in Geo information Science
@mkennedy Hi Melita!!! I bring that up because a friend has a class at DU in the MS GIS program and they're all hung up on making a summary table shapefile using python - so they have to 'make feature layers', etc. etc. and all this extra Arc-Stuff that makes no sense at the python level. So I sat with him and showed him how to use SQL to do the same thing - python would then be a wrapper to automate the execution of that SQL. The lesson here is when spatial education is more open, open data formats and open data processing tools bring more educational opportunities!
1d
revised ArcGIS Server JavaScript: copy attribute from feature snapped to
edited tags
1d
comment What are good tips/habits for a future graduate student in Geo information Science
Also if you take any classes that are ArcGIS-dominated, ask the professor if you can complete the assignments using open source tools...!!!
1d
comment What are good tips/habits for a future graduate student in Geo information Science
Learn PostGIS...
1d
comment PostgreSQL trouble editing points / lines / polygons in QGIS
I think so! I can test it out at work and report back, but now knowing how you imported the data, that is your workaround. One issue though - why are you editing this data in QGIS locally instead of editing the data directly in an OSM editor and contributing it back?
2d
comment PostgreSQL trouble editing points / lines / polygons in QGIS
That's how you do it!
Aug
24
comment PostgreSQL trouble editing points / lines / polygons in QGIS
ok - just updated my answer, but that is the GUI way of doing it... let me know if that works for you...
Aug
24
revised PostgreSQL trouble editing points / lines / polygons in QGIS
added 679 characters in body
Aug
22
comment PostgreSQL trouble editing points / lines / polygons in QGIS
@Mathieu I would use the DBManager plugin in QGIS and click the 'primary key' option and name the field OBJECTID or something similar. That should allow you to have editable features... if you have an existing unique ID field you want to use as your primary key, you can always re-set that later...
Aug
21
comment How to set the target schema using osm2pgrouting
MANY thanks for adding that feature!!!
Aug
21
revised How to create an if statement for moving data if a cell is blank from another column
edited tags
Aug
21
comment How to set the target schema using osm2pgrouting
that's great - worked like a charm. Barring the feature request now in osm2pgrouting, this is a great workaround...thanks again!
Aug
21
accepted How to set the target schema using osm2pgrouting
Aug
20
answered PostgreSQL trouble editing points / lines / polygons in QGIS