PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

0
votes
0answers
89 views

Postgis C/C++ API unpacking geometries

I would like to create a postgres extension that works with postgist types Polygon, Multipolyon, Linestring, Multilinestring based on postgres extension building infrastructure: ...
0
votes
1answer
29 views

Migrating Data to Another Database whit FDOToolbox

I want to migrate my data (Shapefile) to a PostgresSQL using a FDOtoolbox , i searched a tutorial for that but i dont found it . can any one explain the steps to do for migarte the data from a ...
1
vote
1answer
121 views

Get a point value with psycopg2 and PPyGIS

I'm trying to setup a basic working postgis setup with python ppygis package. >>> import psycopg2 >>> import ppygis >>> connection = psycopg2.connect(database='spre', ...
0
votes
0answers
26 views

Assinging ID numbers with a spatial query in PostGIS

I am fairly new to PostGIS and I am working on a project where I am trying to write SQL to assign ID numbers in a column to points relative to the ID numbers of the polygons that contain different ...
0
votes
1answer
85 views

How to store Google Maps DrawingManager Circle overlay in PostgreSQL Postgis GEOMETRY(GEOMETRY, 4326)

What is the correct way to store a Google Maps DrawingManager circle overlay? Should I just store the center as a POINT and the radius in a separate column or store a polygon using ST_Buffer()?
0
votes
1answer
368 views

How to store Google Maps DrawingManager Rectangle overlay in PostgreSQL Postgis GEOMETRY(GEOMETRY, 4326)

What is the correct way to store a Google Maps DrawingManager rectangle overlay? The API basically provides me with NE & SW lat/long coordinates. Should I use BOX()? Is it possible to create a ...
0
votes
1answer
117 views

PostgreSQL PostGIS ST_Point_Inside_Circle() radius in meters

I'd like to begin by saying that I have very little knowledge and understanding when it comes to GIS (despite extensive experience with Google Maps API). PostGIS appears to be a whole new ball game on ...
0
votes
0answers
284 views

How to insert Google Maps API Lat/Long into PostgreSQL Postgis GEOMETRY(GEOMETRY, 4326)

I'd like to begin by saying that I have very little knowledge and understanding when it comes to GIS (despite extensive experience with Google Maps API). PostGIS appears to be a whole new ball game on ...
2
votes
1answer
80 views

Finding census block for given address using Tiger geocoder

I have a geocoder based on Tiger/Line data running on PostGIS. I need to find census block for a given address. How can I do it? Like I can do for census tract: SELECT get_tract(ST_Point(-71.101375, ...
0
votes
0answers
104 views

ArcMap 10.1, the identify tool does not show feature attributes on a query layer on a PostgreSQL database. Why?

I'm developing an ArcGIS 10.1 desktop map editing application using ArcEngine and ArcObjects. I'm using a PostgreSQL database. After a direct database connection (using a query layer), I displayed the ...
0
votes
1answer
30 views

PostGIS problem finding FK to PK

I have 2 tables in a postgres db to which I need to establish a 1-m relationship between. One of the tables has geometry, the other table does not have geometry but contain fields that describe the ...
0
votes
0answers
161 views

Hibernate spatial “org.hibernate.integrator.spi.Integrator” error

I use hibernate-spatial library and I encounter with this error: HTTP Status 500 - Handler processing failed; nested exception is java.util.ServiceConfigurationError: ...
2
votes
2answers
224 views

PostgreSQL/PostGIS Geom to JSON with Inner Join to another table

I am currently producing JSON from a database successfully using the following query: SELECT row_to_json(fc) FROM ( SELECT 'FeatureCollection' As type, array_to_json(array_agg(f)) As features FROM ...
3
votes
1answer
132 views

GROUP BY on geography in postgres 9.4.0 returns wrong/different results

table definition: CREATE TABLE search ( id bigserial NOT NULL, location geography(Point,4326) NOT NULL, location_aggregated geography(Point,4326) NOT NULL, created timestamp with time zone ...
0
votes
1answer
65 views

Point inside st_dwithin with wrong results

I want to get all points, that are in the same area. Therefore, I have the following query for my table check: SELECT l.location_id, l.location FROM check l INNER JOIN check l2 ON ST_DWithin ...
1
vote
2answers
106 views

How to get the number of polygons of a geometry in PostgreSQL

How can I get the number of polygons that form a geometry in PostgreSQL? For example U.S map has a lot of islands in addition to its main lands. I want to count these islands plus the main lands.
0
votes
0answers
47 views

display thematic map using openlayers

iam displaying map from mapfile(mapserver) in c# using openlayers mapfile is connected to postgres it is working well but now i want to diaplay thematic map using the postgrs database using ...
1
vote
1answer
85 views

How to create Spatial Reference System in QGIS?

I have some Attribute and the coordinate and the coordinate reference system. I want to create a DBmanagamet form my spatial data. To do that I want to create one table with name Spa_ref_sys, but I ...
2
votes
0answers
140 views

Postgres OSM planet reverse geocoding

i'm building function for reverse geocoding in Postgres using PostGIS function's. For now i was able to clean up all the data that was useless to me(rivers, buildings,etc.). I got 3 ...
4
votes
1answer
66 views

Using more than one ST_function in one query

I have got stuck with a dynamic analysis that I would like to include in a project I am working with. I want to save the query in the project file or make it to a view in my database. I have tried a ...
1
vote
0answers
41 views

Batch load multiple shapefiles to Postgis

According to the shp2pgsql help, the options drop, append, create and prepare are mutually exclusive. So, if I want to create a table from a shape and then append multiple other shapefiles, I do ...
6
votes
1answer
151 views

How to create ArcSDE Geodatabase in PostgreSQL without ArcGIS Desktop?

I am programming a small application using Arcobjects, and I need to create an ArcSDE geodatabase on PostgreSQL. In ArcSDE at 10.2 there is no Post Installation Wizard. How do I create a Geodatabase ...
0
votes
0answers
37 views

Geoserver SLD repeat = PropertyName

i've got Geoserver up and running, rendering spatial data in Openlayers, based on a view from a Postgresql/Postgis database. I'm trying to get most of the values for the SLD file by the object ...
1
vote
2answers
139 views

Load multi CSV files from local disc to Postgres

I want to load a lot of CSV files from a local disc in an already created postgres database. Which is the easiest way to do that? By using SQL or Java? I suppose that I need a loop for doing that, but ...
3
votes
2answers
99 views

How to reproduce FME Change Detector results in PostGIS?

we would like to use the function change detector from FME in PostGIS. We had a try with the following SQL-Statements but the function doesn´t work. There are no results in the end. The single ...
3
votes
1answer
77 views

From hundreds of shapefiles to PostGIS with some kind of directory/file structure

We have more than 700 shapefiles which we will import in a PostgreSQL/PostGIS database. We want to use a single database to make joins on our tables without using foreign database wrapper. Our data ...
0
votes
0answers
45 views

Invoke PostGIS geocode function using Python

I have a PostGIS Geocoder built with using Tiger data. Using SQL, I am able to execute all database functions and queries. I want to use it with my Python program. One of the option would be to write ...
2
votes
1answer
70 views

How can you tell which port number an existing Database Connection is configured for?

I have a database connection to a postgresql database on a non-default port, 5433. I specify TESTDB,5433 as the instance and I can connect with no errors. If I open that connection properties ...
1
vote
1answer
76 views

Connect to postgresql using ARCSDESQLExecute

I'm trying to connect to a postgresql database using ARCSDESQLExecute from ArcPy. When running my script as stand alone (debug from pyscripter) it works fine. When running my script as a tool from ...
4
votes
0answers
134 views

Error installing PGRouting database extensions

Im trying to install pgRouting and I cannot reach the end of the way because of the following error: psql:/home/user/share/postgresql/contrib/pgrouting-2.0/pgrouting.sql:2459: ERROR: could not load ...
1
vote
0answers
54 views

Open source UML modeling software (GIS)

I am wondering is there any opensource UML to Postgresql Mysql tables conversion software which also includes the geospatial datatypes ? Note:I want conversion from UML to database. and NOT ...
1
vote
1answer
272 views

Postgis query to convert UTM to Lat long

I want Postgres/PostGIS queries to convert UTM coordinates from UTM 43N projection to Decimal Degrees 32643 projection. select ST_X(the_geom), ST_X(the_geom) from table
1
vote
1answer
111 views

Import of OSM data into PostgreSQL with osm2pgsql polygon problem

I've mananged to import my great-britain osm file successfully into postgres and I can query everything fine. osm2pgsql -s -j -G -l --number-processes 8 -K -U james -C 10000 -d osm myfile.osm I'm ...
5
votes
1answer
90 views

How to Specify FID column name in shp2pgsql

In ogr2ogr I can specify the name of FID column using the option -lco FID={columnname} when importing a spatial data in PostGIS database. I am using shp2pgsql in case of shapefile and cannot find a ...
0
votes
0answers
128 views

Displaying Google Map using MapServer, C# and PostgreSQL?

I am displaying Google Map (MapServer) by using C#. And also highlighting the districts on the Google Map using PostgreSQL data. Every thing is working well but when I use any options like zoom in, ...
0
votes
1answer
140 views

Polygon intersection with LineString in PostGis

I have a table which contains GPS coordinates at certain times. I created a LINESTRING from them ordered from the oldest to newest. I also have a POLYGON and I would like to determine the subset of ...
0
votes
1answer
76 views

How to load all states of TIGER into PostgreSQL?

I downloaded TIGER2014 from the Census FTP and I was wondering how I would be able to load all the geometries at once. I learned about loader_generate_script and loader_generate_nation_script but I ...
1
vote
1answer
45 views

postgres db in mapserver

I am trying to generate a map in mapserver by connecting a postgres database but it is not displaying any maps. My table name is a19010100001001. mapfile is LAYER.map MAP NAME "MP" SIZE 400 400 ...
1
vote
0answers
94 views

Is there any VRP solver in Pgrouting 2.0?

after looking at older posts and googling for a while i guess there is not vrp solver (multiple trucks). there was DARP in pgr1.x but i can't see it in 2.x. i found a lot of information on ...
2
votes
3answers
102 views

Calculate Color of Object So No Adjacent Objects Repeat

I am attempting to assign one of 16 colors to map objects (e.g. counties, states, ZIP Codes, etc.) so that no two adjacent objects share the same color. I'm seeing tons of articles online about ...
0
votes
0answers
43 views

line features show up as polygons in GeoServer

the layers are located in a postgreSQL Enterprise Geodatabase. I created a new line feature class and added it to the database and then added it to geoserver. But in geoserver it comes in as a polygon ...
1
vote
1answer
29 views

How to find out postgis.backend?

How can I find out which postgis.backend (geos or sfcgal) I have?
2
votes
0answers
120 views

How to get Geography data to GeoJSON in PostgreSQL?

I am using PostgreSQL database and there is a field in a table(area), i.e., public.geography(Points,4326). It contains below type of records "0101000020E6100000BA83D89942334540780B24287ED051C0" I ...
0
votes
1answer
686 views

Loading Multiple CSV Files into PostgreSQL Table

I am having multiple CSV files. Those CSV files are the log files created as a result of running a windows batch file. The location of these CSV files lies on the server and i want all these CSV files ...
0
votes
1answer
60 views

ERROR: attempt to redefine parameter “postgis.backend”

I just install "SFCGAL". When I use "ST_3DIntersection", It get below error: ERROR: attempt to redefine parameter "postgis.backend" SQL state: XX000 How can I fix? I already saw ...
2
votes
2answers
176 views

Finding all ways that are partly within a bounding box

I'm trying to write a query that will return all OSM ways which are contained within a bounding box of min/max gps coordinates. I get these cooridinates from the greater london bounding box on ...
2
votes
1answer
134 views

Does ST_Intersection work in 3D?

I am using "ST_Intersection" between two 3D lines which I believe do not intersect, but the result gives me their intersection. SELECT ST_ASText(ST_Intersection( ST_GeomFromText('LINESTRING( ...
3
votes
2answers
69 views

Can GeoServer Mosaic extension footprints be something other than a shapefile?

According to the GeoServer documentation for the Image Mosaic extension... http://docs.geoserver.org/2.4.x/en/user/tutorials/imagemosaic_footprint/imagemosaic_footprint.html It asks for a shapefile ...
1
vote
0answers
87 views

Issues installing GDAL with PostgreSQL

I'm trying to install gdal-1.11.0 on CentOS 6 machine. Following the instructions, this is my config ./configure --prefix /usr/local --with-fgdb=/usr/local/FileGDB_API ...
1
vote
1answer
59 views

Postgres: plpgsql combine ST_Overlaps and ST_Intersects

I have a question regarding creating a trigger function in postgres with 2 conditions: when creating a linestring in QGIS their must either overlap nor intersect. So i wrote 2 function, each working ...