1
vote
1answer
29 views

Geoserver WFS features query inaccurate using SQL Server Backend with spatial index

I´m using Geoserver to query features through WFS in an Web Application with Openlayers as client. The queried layer is using SQL Server as backend storage. When applying a spatial index to the ...
1
vote
1answer
56 views

How to edit a layer in Geoserver, when we change table schema in a database (SQL Server)?

So, is there a way to change/edit SQL Server layer definition in Geoserver, when a table schema has been changed in a database ? Or you have to delete that layer and then build a new one ? Thanks!
1
vote
0answers
18 views

Error trying to create mssql layer in geoserver

with mssql 2008 and the latest geoserver with the mssql store plugin, I can create a dbo connection with a mssql database and list the tables. When I try to create a layer with one of the tables which ...
0
votes
0answers
102 views

Geoserver SQL View layer not displaying on map

I am trying to create a SQL View in GeoServer from my SQL Server 2008 R2 data store. It is a very basic query: SELECT [Id] ,[Location] FROM [schema_name].[table_name] I set the Id column, ...
0
votes
0answers
77 views

How can I show both Base and Overlay layers in Layer Panel in GeoExt 2?

I have layer panel I load from Postgres using ajax call. This is the Store: Ext.define('GIS.store.Layers', { extend: 'Ext.data.TreeStore', autoLoad: false, model : 'GIS.model.Layers', ...
0
votes
0answers
108 views

How do I set the timezone in GeoServer w/ Jetty on Windows?

GeoServer is set to the local server timezone, but I need to have it use UTC. I believe that to make this happen I need to set the Java's user.timezone variable. My understanding is that if ...
1
vote
0answers
191 views

Not able to edit or draw new feature in databse geometry data [closed]

var DeleteFeature = OpenLayers.Class(OpenLayers.Control, { initialize: function(layer, options) { OpenLayers.Control.prototype.initialize.apply(this, ...
0
votes
0answers
93 views

Create Feature to selected layer from database (MSSQL) in GXP

I want to do online editing,creating new feature for selected layer data from mssql, it is possible to create new feature in shape file, but not able to do in database data.I am using Opengeo ...
2
votes
1answer
247 views

How to Display Pie Chart when clicking on point feature in map?

I want to display pie charts from MS SQL Server database data. When I click on a point in the map, I wish to see a pie chart over the point. Can you please tell me how to implement such pie charts? ...
1
vote
0answers
321 views

How to connect to MSSQL-Server using Geoserver?

I have Geoserver on Ubuntu 13.04. On another machine I have MS SQL-Server 2008 R2. Now I want to connect it together. Google says that its possible to connect to SQL-Server from Ubuntu using ODBC ...
1
vote
1answer
170 views

GeoServer using GeoWebcache and SQL Server whats the process?

I'm using GeoWebCache and GeoServer to tile cache a layer of data from a SQL Server database. If I seed the cache and I send a tiled WMS request what occurs? Does GeoServer make a call to SQL Server ...
0
votes
0answers
90 views

Is there a big (if any) performance difference between Geoserver SQL Layer and OpenLayers geojson Layer?

I have a table with multiline geography items in SQL Server 2008 (Routes). I want to show them on OL Google Map but I'm having trouble creating SQL Data source in geoserver (something related to ...
0
votes
1answer
162 views

geoserver problem to join sql-server table to a layer

i have a layer published on geoserver based on a connection to a postgres/postgis Table and i need to add another table existing on sql server to do a data jointure table to table in order to add ...
3
votes
0answers
220 views

Geoserver WMST Date Format

There is table in SLQ-Server 2008 R2. In this table i have date column with date format like this 2006-09-08 14:39:41.000. Now i make View from this table on Geoserver side but do nothing wiht date ...
3
votes
1answer
310 views

How to use stored procedure in Geoserver?

I have a MS SQL Server 2008 R2 with and have stored procedure in here. I want to create layer in GEoserver using this. I try: EXECUTE [dd_base].[dbo].[Request BaseSration] 'param1', 'param2', ...
3
votes
1answer
819 views

Openlayers: OGC Filter problem

I have a problem with OGC filter. My layer in OpenLayers has this filter: filter: new OpenLayers.Filter.Comparison({ type: OpenLayers.Filter.Comparison.BETWEEN, property: ...
4
votes
0answers
316 views

Geoserver WMS-T backend problems

I've been trying to set up a few timed WMS layers in GeoServer. They're simple enough, of the form ID(PRIMARY KEY) REGION DATE VALUE so for every region and date you have some value, e.g. the ...
5
votes
1answer
322 views

Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?

I have spatial tables in ArcSDE 10.1 (MSSQL 2008 R2) geodatabases and need to update the same spatial tables in PostgreSQL 9.1(PostGIS 2.0.1) geodatabases. Basically I use my ArcSDE environment for ...
6
votes
1answer
488 views

Geoserver with SQL server consuming all my CPU

This question is long please bear me and my problem. SQL Server Query profiler The Sample Query from profiler that geoserver is running that corresponds to SLD I am using and not the SQL SERVER view I ...
3
votes
1answer
4k views

Geoserver SLD using PropertyIsEqualTo And PropertyIsLike

I have two SLD rules one using PropertyIsEqualTo and another using PropertyIsLike Using PropertyIsEqualTo <Rule> <Name>Vendor FirstVendor</Name> ...
2
votes
1answer
658 views

Using MS SQL 2005 as the data store in GeoServer

In my project, I am trying to set up a simple WFS service in GeoServer in order to create a layer consisting of point features. I have succeeded doing so with the points being stored in a shapefile. ...
1
vote
1answer
141 views

What are the areas, relating to database or server, that should be viewed while making map based webapplication?

This question is relating to GIS web application that are based on relational database. I have database that is not indexed with spatial column and I use geoserver to display these data as layers. But ...
2
votes
3answers
2k views

How to convert geometry coordinates into Google lat/lons?

For storing geospatial data, the geometry field is used in SQL Server or Oracle Spatial. I want to know is there any way where we can convert this geometry field into a set of latitudes and ...
1
vote
1answer
250 views

Difference in two datasource in geoserver

We have two datasource in geoserver for Sql server. what is the difference between them? Microsoft SQL Server - Microsoft SQL Server Microsoft SQL Server (JNDI) - Microsoft SQL Server (JNDI)
3
votes
2answers
825 views

SQL server views in geoserver - problem with sql

I try to extract non-spatial data from mssql as spatial data to my Geoserver 2.1.0 installation from a sql statement looking like this: SELECT database.table1.id, ...