|
May 7 |
comment |
How can a 3D model of a building be displayed in a web-browser? I'm using PostGIS, so exporting in KML is fine (I'm interested in general massing, rather than details at the moment). I would prefer that users do not need to download a plugin which is why I have shied away from google earth. I'll take a look at OSM3D, thanks. |
|
May 4 |
comment |
How can a 3D model of a building be displayed in a web-browser? I did think about this method - but I would like an approach that does not require a plugin. I do understand that that streetview is not a 3D building, but I wondered if there was any approach that could enable the panorama of images to be edited such that a building could be inserted. |
|
Apr 21 |
comment |
What is the easiest one click install method for PostGIS and it's entire dependencies? Is CREATE EXTENSION postgis only for PostGis 2.0? |
|
Apr 21 |
comment |
Which function for creating a POINT in PostGIS? Thanks for a great explanation about how to calculate this. I'm curious about the SQL syntax, <POINT CONSTRUCTOR METHOD>. Is that just pseudocode to refer to the four different approaches, or are you making some kind of function? |
|
Apr 17 |
comment |
How to georeference PNG images using QGIS? I agree, my question is a duplicate. Wondering if there is a way to make the other question a little easier to find? I did try many search terms. |
|
Apr 17 |
comment |
How to georeference PNG images using QGIS? thank you, this is exactly what I needed. |
|
Apr 17 |
comment |
How to georeference PNG images using QGIS? no, they are maps but in png format |
|
Mar 24 |
comment |
View PostGIS geometry in QGIS Are you certain that your lat/longs are correct? Latitude is the Y axis, longitude is the X axis (I've got these backwards multiple times). I suspect QGIS is fine, and your data is incorrect. |
|
Feb 24 |
comment |
Advice on choosing ideal software for consultancy Could you add which part of the world you are in? I'm wondering if OpenStreetMap might be of use. |
|
Feb 14 |
comment |
How to zoom to point boundary using OpenLayers? This does make sense, but strangely firstExtent.extend(secondExtent) is undefined (both firstExtent and secondExtent have bounds that exist). |
|
Feb 14 |
comment |
Why ST_Intersects() returns one row more than expected? Why would this happen with ST_SummaryStats() though? Surely that is being calculated on all of the raster data that intersects? |
|
Feb 14 |
comment |
How to zoom to point boundary using OpenLayers? Do you know if there is a way of handling data on two separate layers? I have the two points style differently (I could also try to have them on the same layer but with separate styles I suppose). |
|
Feb 14 |
comment |
Does QGIS support vector Rubbersheeting? For those unaware of what RubberSheeting is: en.wikipedia.org/wiki/Rubbersheeting |
|
Feb 13 |
comment |
Using PostGIS for a large trajectory dataset If appropriate, there is also a package for connecting R to Postgresql (cran.r-project.org/web/packages/RPostgreSQL/index.html) which can be a convenient way of reading/writing from the database for non-spatial analysis (as R does not handle geometries). |
|
Feb 8 |
comment |
How best to fix a non-noded intersection problem in PostGIS? Not entirely clear on how I use st_node here - can I use it before st_intersection? |
|
Feb 8 |
comment |
How best to fix a non-noded intersection problem in PostGIS? That is a great presentation (thanks @PaulRamsey). How should I use ST_Node and ST_Dump? I imagine I would need to use them near this part of the function, but am not certain: st_intersection(''SRID=''||st_srid(%2$s)||'';%4$s''::text,''%5$s'') in |
|
Feb 8 |
comment |
How best to fix a non-noded intersection problem in PostGIS? Yes, I am using WHERE ST_IsValid(p.geom) to filter the points initially. |
|
Feb 2 |
comment |
Get Lat & Lng from GeoDjango OSMGeoAdmin You could pass an argument to this from the browser using an ajax request. |
|
Jan 31 |
comment |
Turn-by-turn direction using PgRouting @lewis I'm not sure on how best to calculate the angle at intersections - do you have any advice on how to do this? |
|
Jan 25 |
comment |
Spatial Data from Postgis to Java/REST with RestEasy + Jackson Are you sure? According to the docs it was introduced in Postgis 1.3.4 postgis.org/docs/ST_AsGeoJSON.html |

