I spent days looking in all questions here and trying tutorials.
I need to build a graph for a region (It will be my input in simulation)
I downloaded Postgresql and Postgis and osm2pgsql. Now i can ...

I know my question is similar to slow import via osm2pgsql to postgresql database and Optimizing osm2pgsql imports for OSM data but as we currently have quite some problems importing a large set of ...

hye all, im really new in openlayers, i already have a map using openlayer but not have layer. my question is, how i want display layer using postgres and i want to make a search function to search ...

I made a custom PL/pgSQL function in PostgreSQL (this function is using pg_tsp and pg_makeDistanceMatrix functions) and then made an SQL View in GeoServer to extract the information from the db using ...

I wanna be able to update/delete data from a datagridview, and when I do that of course the data in my PostgreSQL database should be edited too.
So I've thought about giving the user the ability to ...

I have a table with point features saved in the my PostgreSQL database, and I can run the following query to get the extent of the point features and I turned the extent back into a geometry:
SELECT ...

Kindly help me to find out a good tutorial for plpgsql syntax. Which language is the best and extensively used by the users for PostgreSQL custom functions - sql, plpgsql, c, pl/python, pl/java etc? ...

I've been looking into this matter for a few days now, but I haven't come up with a working solution.
Basically, what we are trying to do is create an entire world database, preferably in PostgreSQL, ...

I have made this web-app http://160.75.133.173/openWebApp/routing.jsp
Users just have to click two points to figure out the shortest possible route available connecting them. I am using OSM data and ...

I'm working on a geographic information system project, whose products form shapefile. I am using java language, and PostGIS database. Is there a way to generate a shp file from PostGIS or kml using ...

I am developing an web GIS for map data presentation for public.
Is there any readily available implementation of Mapserver (or Geoserver)- Postgres-Openlayers combination or similar?
More Details:
...

I'm using Postgis functions st_dump and st_split to split a polygon based on line. Now, after splitting; output geometry stores in a database table as well. Here is the query:
insert into aoo(geom)
...

I am using QGIS and connecting to Postgresql database. I want to import shapefile data into database table via DBmanager tool.
But Append data to table selection is inactive like following image. I ...

I ST_Dwithin the function returns TRUE if the geometry A is completely inside B. I happen to have many polygons (representing regions) and need to know which streets are within each of these polygons. ...