home
I am using the following command: shp2pgsql -D -a -s 27700 /path/foo.shp myschema.mytable How...
I am attempting to install postgis and trying to integrate it with my django. I am following this...
I know that it might be dumb question, but I'm searching for some time and can't find proper...
I usually work with MySQL, so PostgreSQL is a new thing to me I'm trying to use PostGIS in my...
what I would like to achieve is to execute the st_Intersection(clipper_geom, clipped_geom) on...
I am using PostgreSQL 9.3. I wanted to create a database that supports Postgis functionalities. In...
I found an issue with postgis functions inside laravel(lumen) query builder. Lumen version:...
Sorry about the lack-lustre title, but it's hard to describe... Lets, just say I have two tables...
6 days ago

How compile postgis

I can't compile postgis on redhat, i ran this lines. but when i run the "make" line it show me the...
I got a table with linestrings that I want to divide into chunks that have a list of id not higher...
I'm creating a project that uses some spatial queries. I use Spring boot with spring data...
I followed this documentation to use the spatial data in my project. I have installed the postgis...
I have two coordinates and i want to calculate,what is the user's speed between this points.I am...
I am trying to find intersection between incidents(polygons) and watchzones(circles - points and...
Apparently with Hibernate 5, the geography type is supported. I've searched a lot, but found close...
The following command works well in command line shp2pgsql -s 4326 /Users/abc.shp | psql -U user1...
I have executed this query: SELECT id, user_id, device_id, date(creation_date_time) as day,...
I am using postgis function ST_DWithin(geography gg1, geography gg2, double precision...
I have a postgres database with geospatial data and I want to export certain parts of those as a...
I've got two tables "modulo1_cella" and "modulo2_campionamento". The first, "modulo1_cella"...
Am trying to perform a query on my table(ais): so this is detailed approach: limit the search by...
I have installed osm2pgsql on centos6.8,when I used osm2pgsql to import, the following error comes...
I have a table: create table if not exists places( id bigserial not null constraint places_pkey...
I maintain two postgis tables: "track_points" and "buffers". The "track_point" table contains a...
I have downloaded the openstreetmap data for Germany. I am trying to find a closest point using...
This is my olocation table: create table olocations ( id uuid not null ...
Given a set (lat, long) I am trying to find the maximum speed using "max_speed" and street type...
I'm trying to use the st_clusterdbscan-function of postgis described here on a heroku / AWS...
I'm trying to use ST_Union() function in order to create a raster image containing max values from...
I've an ubuntu server 16.04, and i'm trying to install Postgis on it, but when i try sudo apt-get...