Reputation
5,450
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
8 30
Newest
 Revival
Impact
~197k people reached

Jan
14
revised I converted a KML file into a PostGIS db using ogr2ogr. How do I publish all the tables as seperate layers?
added 128 characters in body
Jan
14
comment I converted a KML file into a PostGIS db using ogr2ogr. How do I publish all the tables as seperate layers?
Also, rather than crafting URLs, use this library for Python: github.com/boundlessgeo/gsconfig
Nov
11
comment How to use interacting PostgreSQL/PostGIS triggers in QGIS?
Ah, ok @LunarSea. I guess triggers are important then. Note that you'll need to do a check of all points each time you change the polygons, since, as someone else above eluded to, your polygon changed and it's new area might not encompass points that were previously in it.
Nov
11
answered How to use interacting PostgreSQL/PostGIS triggers in QGIS?
Nov
11
comment How to use interacting PostgreSQL/PostGIS triggers in QGIS?
What are you actually doing? Storing label points? Did you know you can manage label points using QGIS? If you did do this (manage them with QGIS) you need two columns, X and Y, and you can make a view from these so that you have a virtual table for them too. Might be simpler.
Nov
6
awarded  Revival
Oct
26
answered Cluster Markers with CartoDB
Oct
21
answered How can I draw the results of a PostGIS query?
Oct
15
answered Lat long co-ordinates in geojson format for Alaska(smaller), bigger Guam and Puerto Rico?
Oct
15
answered Leaflet popup options with geoJSON data
Oct
14
comment Is the QGIS connection with ArcGIS “mapserver” still working?
You might be able to add your corporate proxy settings into QGIS to enable it to work.
Oct
7
comment How do I use use custom fonts for labelling in Geoserver?
Did you get this resolved?
Oct
5
awarded  Nice Answer
Oct
2
answered Inserting new data in PostGIS are not displayed automatically in Geoserver layer
Sep
29
comment Configuration with geoserver openlayers
Try to use the 'preview layer' function in GeoServer. If that works, your layer works. From there, I strongly recommend using Leaflet to set up your maps. You'll write much less code. I have heaps of examples here: github.com/gccgisteam/maps-website
Sep
27
comment In hyperbola model of how GPS equations are solved, why do 3 satellites give only 2 hyperboloids and 4 satellites only 3?
Hey @wacgyver, maybe have a read of the references in this Wikipedia article, the are cited in the hyperbola section of the article I posted, which states that 4 hyperbola are required. en.wikipedia.org/wiki/… and en.wikipedia.org/wiki/…
Sep
24
revised In hyperbola model of how GPS equations are solved, why do 3 satellites give only 2 hyperboloids and 4 satellites only 3?
altered answer to include more information
Sep
24
comment In hyperbola model of how GPS equations are solved, why do 3 satellites give only 2 hyperboloids and 4 satellites only 3?
Ok, I see. I didn't realise there were other ways of understanding the solution of the problem. I've had a read here and will alter my response: en.wikipedia.org/wiki/…
Sep
24
comment What is the equivalent of ArcGIS's “Feature Class to Feature Class” in QGIS?
Try with another format. SQLite, for example, should handle long field names. What are you wanting to use the written file with?
Sep
23
comment In hyperbola model of how GPS equations are solved, why do 3 satellites give only 2 hyperboloids and 4 satellites only 3?
Hi @psmears, have you got a source? I was taught that you are measuring a distance from the satellite to you. At least in consumer GPS gear, it's a pseudo random code that's generated on your device and on the satellite at the same TIME, and matching them together you get the TIME delay between generating the code and receiving the code from the satellite, which with the speed of light, gives you a distance. Since it's distance not direction, it's a sphere.