PostgreSQL is an open source object-relational database system.

learn more… | top users | synonyms (1)

0
votes
1answer
12 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
0answers
6 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
14 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
13 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 ...
0
votes
0answers
7 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
22 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
13 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
12 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
49 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 ...
2
votes
1answer
40 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
29 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
32 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
36 views

How to organize database with objects having GPS coordinates (in radians) [on hold]

I have a huge database of different objects organized in tables. For instance photos in one table and metadata of each photo in other. Most of them have their GPS coordinates in radians stored as a ...
0
votes
0answers
10 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
40 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
42 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
51 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
27 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
85 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
16 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
42 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
63 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
61 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
25 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
0answers
22 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
29 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
42 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
26 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
38 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
46 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 ...
3
votes
1answer
38 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
24 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
65 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
35 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
12 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 ...
-2
votes
0answers
53 views

create connection between arcgis server and postgres

I'm trying to connect to the postgres 9.2.2 from arcgis server 10.2 through create enterprise geodatabase.Actually 'm using Sql Server as my platform,but I need to imigrate to Postgres.while trying to ...
1
vote
0answers
27 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
52 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
31 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
27 views

How to find out postgis.backend?

How can I find out which postgis.backend (geos or sfcgal) I have?
2
votes
0answers
49 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
101 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
32 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
99 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 ...
1
vote
1answer
51 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
29 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
16 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
32 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 ...
7
votes
2answers
255 views

Find headwater polygons

This is a follow up question to this question. I have a river network (multiline) and some drainage polygons (see picture below). My goal is to select only the headwater polygons (green). With ...
1
vote
1answer
87 views

PostGIS ST within does not exist

I'm quite new to postgresql and postgis so this error will probably due to some rookie mistake. I want to run the spatial query ST_within. When I describe the query like this SELECT nw.entity_id AS ...