Tagged Questions

1
vote
1answer
625 views

Convert latitude longitude coordinate to x y coordinate?

I'm using a postgis database and java to develop my application. I need to transform my geographic data currently in latitude/longitude format into a x/y format. I found solutions based on UTM ...
2
votes
0answers
246 views

Hibernate Spatial 4 and Postgis 2.0

I'm having some issues integratings this technologies: Hibernate Spatial 4.0-M1 Postgis 2.0.2 (with compiled jdbc 2.0.2) Hibernate 4.1.1 The specific error is: Caused by: ...
1
vote
0answers
65 views

Renaming Columns in Geotools FeatureType

I am attempting to build a simple java program that loads shapefiles into a Postgis 2.0 database. Everything is working out great except that I would like to be able to modify the FeatureType in the ...
0
votes
1answer
72 views

Column exists in DatabaseMetaData, but does not exist in relation?

I am using JDBC to query a PostgreSQL database. And I want to populate a column called wiki_url based on the value of another column, level which will determine which value of 5 columns to concatenate ...
2
votes
0answers
67 views

MultiPolygon from database

I would like to know how to create an instance of a Multipoint from a PostGIS database.. I do the query , then got the ResultSet named "area" , the column with MultiPolygon attributes is named "geom" ...
0
votes
2answers
107 views

dijkstra_sp runs without error in postgres query terminal, but triggers an error in Java

I am running this simple query select id,gid from dijkstra_sp('roads',22,33) This works perfectly fine and returns results in postgres query terminal. However running exactly the same query in java ...
4
votes
1answer
711 views

How to setup PostGIS JDBC with Hibernate?

I try to setup an Java Application with Hibernate and PostGIS but I always get nasty exceptions like : java.lang.NoSuchMethodError: org.hibernate.type.CustomType.<init> ...
5
votes
1answer
227 views

GIS-based reporting and maintenance tool

Background Conceptually, I am looking for a tool, or suite of software tools that can be readily integrated to help browse data using a GIS-based map (such as Google Maps). The proposed architecture ...
2
votes
2answers
368 views

How to create hibernate layers at runtime?

We need to dynamically create hibernate layers from shapefiles. As far as we understand, the workflow is following: Import shapefile to database(creating new table for each shapefile?) Is it good ...
6
votes
1answer
339 views

Data visualization and maintenance tool

Background Looking to leverage an existing GIS system for exploring organizational data. Architecture The following figure represents a high-level overview of the system's desired features: The ...
4
votes
1answer
371 views

Can PostGIS functions be written in Java?

I am wondering if there is a possibility of programming new functions for PostGIS using Java, so that you can refer them same way as classic PostGIS functions are. Something like this: CREATE OR ...
2
votes
2answers
466 views

How to add a background map to a java project?

I'm new at GIS. I am trying to make a java application that can display a map with certain points. I have achieved this using the geotools library. However, I want to put the map from OpenStreetMap or ...
1
vote
1answer
788 views

How to connect GeoServer with Java to a PostGIS/PostGres database?

I am having trouble using GeoServer to perform a shortest path analysis between two network points. My question is about connecting GeoServer with Java to a PostGIS/PostGres database. I know that in ...
1
vote
1answer
248 views

Building orientation and simplification using Opencarto Java library

I need to find out orientation of buildings and perform simplification of sides of buildings with a tolerance. I came to know from StackExchange that OpenCarto has useful libraries for geometrical ...
1
vote
1answer
415 views

How to extract data from a POINT column in PostGIS using JAVA (jdbc)

How do you get a value from a column which has a point data type. I've just switched over from MySQL to PostGIS. I have a column which is called point and is of type Point. I want to get that value ...
6
votes
1answer
1k views

Find nearest POI of given GPS coordinates

I am new to GIS and need to achieve the following: Find the nearest train station or bus stop of given GPS coordinates in a Java application. Since there are many coordinates to be checked, an ...
3
votes
2answers
344 views

Is there a common interface for ST_Geometry SDO_Geomtry

I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial. Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with ...