Tagged Questions
0
votes
1answer
31 views
PostGIS error reads “Geometry has Z dimension but column does not” [duplicate]
I try to store a polygon in GeoJSON format into my PostGIS table. Both are using the CRS EPSG:3857. This is how the polygon is defined. Note that I put in some whitespace to make it more readable.
{
...
4
votes
3answers
66 views
How to insert a GeoJSON polygon into a PostGIS table?
I need to insert a polygon from GeoJSON to my PostGIS table. This is how the SQL query looks like.
INSERT INTO tablename (name, polygon)
VALUES
(
'Name',
ST_GeomFromGeoJSON
(
{
...
1
vote
2answers
69 views
How to add a polygon from GeoJson into Leaflet?
I try to use the following function to add polygons to my Leaflet map.
function polygon(geojson)
{
alert(geojson); // alert for testing
layer = L.geoJson(geojson);
layer.addTo(map);
}
...
1
vote
1answer
41 views
SQL Command to convert pgRouting result to GeoJSON
My goal is to produce a Web UI for pgRouting using this tutorial. I have already imported my data from an OSM pBF to PostGIS using osm2po. Using the pgRoutingLayer plugin for QGIS, I was able to ...
2
votes
1answer
255 views
Spatial Data from Postgis to Java/REST with RestEasy + Jackson
I'm developing an application where I take a route from google maps, save it in postgresql/postgis. I'd like to take this route (LineString geometry) and send it back to Google Maps.
I already can ...
1
vote
2answers
253 views
How to project a geoJSON file in OpenLayers?
I have a json file well formed. I want to read a json file as a base layer from OpenLayers.
<script type="text/javascript">
var styles = new OpenLayers.StyleMap({
...
1
vote
1answer
133 views
Polygon intersection with bounding box with polygon's holes intact
I am trying to serve GeoJSON FeatureCollection tiles with each feature's geometries trimmed to the tile boundary.
I am working on a Leaflet plugin to re-assemble the geometries. It works by building ...
2
votes
1answer
278 views
formatting geojson from postgis data using node.js
I am trying to build a GeoJSON object from a SQL query to some GIS point data in a postgis postgresql database. A snippet of my node.js app.js is below.
As it stands I understand building the type ...
1
vote
0answers
418 views
searching GeoJSON features
After googling for many days and reading the OL documentation, I don't understand well how the filterToParams in OpenLayers.HTTP protocol should work, what I'm trying to do is to find and display the ...
4
votes
2answers
913 views
Beginner needs suggestions on map clicks and geojson
I'm a beginner with programming, and javascript. I went to the FOSS4G-NA conference and was very inspired to learn more. I'm trying to learn PostGIS, and have come across a very useful tutorial for ...
1
vote
0answers
39 views
How to load GeoJSON files directly onto QGIS? [duplicate]
Possible Duplicate:
Plugin or script to get QGIS to display geoJSON in a layer
Is there a way to do this? Or is there a way i can put it onto PostGIS and then load it onto QGIS? I actually ...
2
votes
1answer
334 views
How to create a efficent linestring out of geography points using postgis
I'm trying to create a linestring out of geography points. At the moment I'm doing it like this:
select ST_GeographyFromText(ST_Makeline(a.record_point)) from (
select (record_point::geometry)
from ...
8
votes
4answers
672 views
Alternatives to ogr2ogr for loading large GeoJson file(s) to PostGIS
I have a 7GB GeoJson file that I would like to load into a PostGIS database. I have tried using ogr2ogr but it fails because the file is too big for ogr2ogr to load into memory and then process.
...
6
votes
1answer
1k views
How to Export Feature GeoJSON from PostGIS
I'd like to do a GeoJSON dump of a PostGIS table, but I want to export features (the geometry and the properties) not just the geometry. I've been digging into the ST_AsGeoJSON function but it looks ...
