2
votes
1answer
24 views

pass an array of geometry to postgresql function

I am trying to pass an array of geometry to a postgis function using JDBC with JAVA: CallableStatement proc = conn.prepareCall("{ ? = call somefunc(?) }"); ...
0
votes
0answers
159 views

Java + GMaps JSF + PostGis + JasonSanford / geojson-google-maps

Guys want to test how to plot lines and points in google maps using Java + JSF + PostGIS + GMaps JasonSanford / GeoJSON-google-maps. First have a spaceport in postgis with a table of rows and other ...
0
votes
0answers
111 views

Draw postgis geometries in google maps api

Postgis have a base with a table of data lines and other points. I'm doing a java applet to query these tables and space to draw on google maps. My question is: what better way to spend these ...
0
votes
2answers
118 views

Architecture for java ee application

I´m new to GIS development. I have read about Openlayers, maps servers (i choose Geoserver), geodatabase (in my case i choose PostGis) and theory of gis in general. I´m developing a Java EE ...
3
votes
1answer
46 views

Use selected value in postgis function

How can I use the selected value from a SELECT statement in a PostGIS function. e.g. using the geom_way from SELECT geom_way FROM osm_2po_4pgr ORDER BY ST_Distance(ST_GeomFromText('POINT(21.323329 ...
1
vote
1answer
269 views

why I can not run hibernate-spatial (in eclipse)

I have a problem with Hibernate Spatial. I followed the tutorial 4.x, and I created my project using maven. after correcting some minor errors in pom.xml and in persistence.xml, executing the project ...
0
votes
2answers
133 views

Converting WKT to WKB

How can I convert a WKT string to a WKB byte[] in Java using postgis functions? I need to save that WKT string in a postgis database (geometry column. Thanks
3
votes
1answer
171 views

Hibernate Spatial - 'Invalid endian flag value encountered' Exception

I'm trying to run a simple query in Hibernate Spatial 4.0 on PostgreSQL 9.3. I have a number of objects in a table with latitude/longitude values, and I'm trying to query objects that fall within a ...
0
votes
0answers
49 views

import tile into PostGIS through java dll

i have used this command to import tiles from directory to postgis data base but it show error in command line please help me if any one know ?. thank advance to share knowledge C:>java -jar ...
0
votes
1answer
79 views

Can I use GeoTools with Gradle?

I am going to implement shapefile uploading from a webform, and ingestion into PostGIS. One problem I am having is that my project is using Gradle for dependency management. I am unfamiliar with ...
2
votes
1answer
38 views

How to generate features to test different implementations of LinearRing?

I have some code that throws the following exception: Points of LinearRing do not form a closed linestring and I want to check if my code is calling this correctly by supplying some features that ...
1
vote
1answer
825 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 ...
5
votes
1answer
836 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
133 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
118 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
81 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
129 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
2answers
2k 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
328 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
521 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
500 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
430 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
669 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
891 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
274 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 ...
2
votes
1answer
633 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
2k 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
410 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 ...