I want to create a table from a shape file in Postgres. To do that, I can run this command in cmd:
shp2pgsql -s 4326 -W LATIN1 E:\Any\THA_adm public.test123 | psql -h localhost -d DATA -U postgres -w ...

I am using osm2po for importing pbf file to postgresql but when i find route using built-in algorithms i found that some of the edges are missing so route does not match with road. Did anybody know ...

I'm trying to transition from an old Postgres/Postgis database to a new one.
I'm working in a fresh install of Win 7 64 bit. I installed Postgresql 9.3 32 bit, then installed PostGIS 2.1.3. I created ...

I have a table of polygons (census block groups) in postgres. I want to tag each block group with the town (another polygon table) it mainly resides within. Is this possible? I'm thinking I'd need to ...

I am still bit new to Postgis 2.1. I am trying to rasterize a polygon, meaning that I have a polygon of Syria and I want to create an empty raster that contains the shape and geography reference of ...

I'm trying to load a shapefile in POSTGIS using pgShapeLoader.
It works but I can load table only in the "public" schema and i don't know how to configure, the tool to upload my shapefile in another ...

I Have a massive Dataset from OpenStreetMap and imported it into a Postgres-Database using ogr2ogr. I got several warnings during this process because of multipolygons with too little vertices. Now I ...

I'm trying to build out a geocoder that also returns the correct legislative district information from this data:
http://www.census.gov/geo/maps-data/data/tiger.html
I've got OSM data imported into a ...

Given a "road", represented by a line, that crosses a "state", represented by a polygon:
What is the SQL query I can use to find the segment of the road that is within the state?
A concrete example.
...

I create two function both work fine same solve, but one of them, take to much time (which one use "temporaly"). Is very important because I will run in several times the funcion.
Please any one can ...

I realize that these questions should probably be directed to a DBA but I feel like you might have some experience in managing the same kind of data.
We have an existing system where we are storing ...

I asked the previous question
Using PostGIS functions in ArcGIS Desktop for Layer Definition Query?
And got an excellent answer. However this covered ArcGIS Desktop. In 10.0 it seemed that if I got ...

I am using Postgis 2.0 on Postgresql 9.3 on Ubuntu 14.04 x64. I am trying to find an efficient way to fulfill this routing request. So I am able to get the shortest route using the source and target ...

Using GeoServer I want to deliver some objects/features with WFS and WMS. The objects and their attributes have a date range during which they are valid. Say, we have street lamps and each street lamp ...

I would like to create bus map for my city from OSM data.
I imported data into Postgresql with osm2psql and I can render routes with Mapnik. But the problem is that same route ref is shown multiple ...

so I know there have been some questions asked about how to calculate distance using postgis and how to order results by their distance from a respective point.
I'm not very talented at SQL (at all) ...

I'm facing a quote problem on a pgrouting query.
What I'm thinking is wrong is that my query only works if I use one, then four, then eight quotes on encapsulated queries.
Is there a way to simplify ...

I've tried this a few different ways and keep getting the same error.
I have a shapefile currently in WGS84 UTM Zone 15 which is SRID 32615.
I used the ArcMap multipart to singlepart tool to create a ...

I have 173 point shape files from soil testing and 173 non spatial csv files with lab ressults (one csv for each shape file) that need joining. The files are located in a library with folders named ...

I am connecting ArcGIS Desktop 10.2 to Postgis 2.0.3 with PostgreSQL 9.2.4. No SDE. I can load data with no problems and access the data in ArcMap. However I can't seem to use PostGIS functions within ...

I referred some documents on GIS-stackexchange and over internet regarding installation of pgRouting on Postgres v9.1 and windows 32.
I am not getting the correct version of pgRouting to install.
Can ...

I want to identify all beaches on this planet (or a given subset of it) that are facing westwards (+/- 20-30 degrees).
My idea is to use OSM as the data source. Extracting all polygons that have the ...

I have this huge table with all the addresses of my country in it. Every house is an object, and there is a column for the streetname (or street ID) and a column for the housenumber.
I want to make a ...

How can I get a list of all available tables in my own authenticated CartoDB account with a SQL statement?
This returns null:
SELECT table_name as t FROM information_schema.tables WHERE table_schema ...

I have a PostGIS table with some polygons (stored using the geography data type). They represent regions on a spherical earth.
For each pair of vertices chosen from among all the polygons, I want to ...

I have many geometric objects (in both SRID:4326 - the_geom - and SRID:3857 - the_web_geom - in PostGIS extension tables of PostgreSQL), including country boundaries, for the country of Ghana and I ...

I have downloaded Landsat8 image and use matlab to processing temperature and vegetation. Then I insert data into PostGIS.
I used QGIS to display the results but i want show in web. How to display the ...

I am trying to make some calculations using PostGIS and PostgreSQL. There are 3 important tables : wbn, wgo and wvb. These tables have about 500.000 objects in them (geometries). The problem is that ...