One or more structured sets of persistent data, managed and stored as a unit and generally associated with software to update and query the data.

learn more… | top users | synonyms

0
votes
0answers
164 views

SDE Replication works through ArcMap but not through ArcCatalog [on hold]

I'm running 10.1 on a 10.0 SDE database. We're trying to replicate our database (one-way parent to child) to a file geodatabase. Ideally I'd like to have this automated using python or .bat files but ...
4
votes
2answers
305 views

Building a ol3 web application with dynamic content and user registration

My set-up: Currently I’m using a PostGIS database, with a GeoServer service and displaying the data with OpenLayers 3. I use WFS data to display the features in clusters and I’m able to edit them ...
1
vote
1answer
188 views

Adding non geographic data from MSSQL Database to QGIS?

In QGIS (2.8) I am trying to add non-geometric data / flat data that originates in a MS SQL database. This flat data later should be joined with other layers etc. Connecting to the specific database =...
4
votes
2answers
921 views

Configuring spatialite database access for Python 2.6.6

I'm working on a GIS project, and I would like to implement and test some geo-spatial algorithms in Python. For this purpose, I will not only need sqlite, but also spatialite, in order to store and ...
0
votes
1answer
38 views

Web map linked to database that shows one spatial location at a time

I have a simple database with a record for each research project that occured on a national forest. Each project area is associated with a polygon, and there are around 200 polygons that are piled ...
0
votes
1answer
270 views

WMS layer connected to SQL database

It is possible to connect a WMS layer to a SQL database or other type of database? Example: I have created an application with Geoserver and OpenLayers. Now I can see the data from attribute table. ...
0
votes
1answer
28 views

Database access pattern using PostgreSQL and ArcGIS

I am planning to connect to a PostgreSQL DBs on a server from ArcGIS on my laptop. My server admin is interested to know "The access pattern: How, when, how often, (would ArcGIS access the DBs) during ...
3
votes
2answers
131 views

Delete table rows in non-spatial database using arcpy

Working on a python script that does a bit of spatial analysis on a few layers, a spatial join of those layers, and then pulls data from a couple of other tables and holds them all in an in_memory ...
8
votes
3answers
212 views

Efficient processing of difference between input data and database

I have an input dataset whose records will be appended to an existing database. Prior to being appended, the data will go through heavy, time-intensive processing. I want to filter out records from ...
0
votes
0answers
30 views

Is it correct - according to database theory - to have a primary key in a geodatabase table, other than the OBJECTID?

I am making a data model for my geodatabase. I'm trying to wrap my head around the issue of primary keys in geodatabases, and wether or not my model is correct according to database theory. I would ...
0
votes
0answers
21 views

Database modeling for big data (big set of points X big sets of possible values for each points)?

I'm building a PostgreSQL database with the intent to host modelisation results for different projects. Each project has a set of receptors points (~5000-10000 receptors) and have many results sets (...
1
vote
0answers
32 views

QGIS not loading default layer style from PostgreSQL database on startup

I have saved a vector layer style to my PostgreSQL database source. I then amended the layer_styles table record for the relevant layer by editing the styleqml field (just changed the outline_width ...
0
votes
1answer
18 views

API or Datababse for Atlas like data

Is there any database or API that can provide data present in Atlas books for example, list of countries, population, temperature etc.
1
vote
2answers
49 views

ArcCatalog database connection showing blank tables

I received info to connect to a database (without a spatial component) that has tables I need for a project I'm working on. Problem is once I establish the connection in ArcCatalog I can see all of ...
3
votes
1answer
72 views

How to use a polygon as a reverse cookie cutter on features in a Postgresql database

I want to be able to use a polygon in a database to remove all features and parts of features that falls within the polygon. Not as part of a query transferring the database to another database. I ...
1
vote
0answers
25 views

Missing vector features when import from .sqlite to postgis?

I imported vector data from a .sqlite file to PostGIS but not all of my vector features imported. I haven't been able to determine a reason for most of the loss of features between the databases (...
1
vote
0answers
50 views

Is there any way to connect features (entities) of dxf to database in python?

I'm using gdal, ezdxf, sqlite python packages and sqlite ODBC driver. They work fine, and in AutoCAD I can easily manually connect to my dbase.sqlite (read only) using _DBCONFIGURE and _DBCONNECT ...
-2
votes
1answer
86 views

How to Append data before saving polygon in Openlayers 2

I creat a new polygon but before saving i want to append some data such as polygon name , color etc. How can i do this ? I am using this function var SaveStrategy: new OpenLayers.Strategy.Save(); ...
1
vote
1answer
19 views

Cartodb - clone table from another user

Is there a way to clone a table from another user? The only way I see is exporting the dataset and importing again into your own account. This would be a nice feature for teaching, i.e., a simple ...
1
vote
0answers
7 views

Showing Attribute Tables in GeoExt

We are making a simple webmap with a Postgis database and Geoserver. So now we have the layers working in Geoserver and we can see the cartography and the the features using GeoExt, but we're not able ...
4
votes
1answer
189 views

Insertion of a raster geotiff in PostgreSQL database

I am new in PostgreSQL and psql. What is the method to insert a raster geotiff in a postgreSQL database using command psql? What is the best format? Someone indicates to save a raster image as BLOB ...
5
votes
2answers
365 views

DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset

I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format: id pointid sensor measdatetime measvalue 50345 500 ...
21
votes
9answers
13k views

Choosing database for storing spatial data?

A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...
3
votes
2answers
443 views

Non-spatial database analysis in ArcGIS - need alternative solution

I've recently joined an organisation where we use ArcGIS to do a lot of non-spatial analysis on a spatial dataset. Our main dataset is an environmental polygon survey with lots of attributes (in an ...
0
votes
1answer
35 views

Is there anyway to combine a static geojson and data from database then display it in leaflet?

I do have a web map application that can load geojson then display it on leaflet map, however I encountered unresponsive script whenever I refresh my page due to big size of geojson. Is there anyway ...
4
votes
1answer
908 views

How do I remove username / password from an ArcGIS mxd?

When you create an mxd and use layers from a database connection where you are using "Database authentication" and clicked "Save username and password" and share the mxd with others, why are others ...
1
vote
0answers
77 views

Career after GIS Analyst [closed]

I am 23 years old. BSC.IT Graduate, and currently working as a GIS Analyst in Mumbai for last 1.5 years. I am planning to do SQL Certification followed by Oracle. Would it be helpful? I am interested ...
3
votes
2answers
80 views

Data organization strategies for single user desktop QGIS

I have been teaching myself GIS using QGIS for several weeks and I am looking for advice on how to structure my data in a way that is extensible and won't require me to constantly reorganize things. ...
1
vote
2answers
53 views

Animating polygon style over time in QGIS?

I have a shapefile, consisting of polygons. I can join a layer to a database file, and use an attribute (database value) to "style" (color in) the polygons to give me a visual representation of the ...
0
votes
0answers
64 views

How can I add the PostGIS extension?

I'm experiencing difficulties when trying to add the PostGIS extension to PostgreSQL. I wasn't able to add the extension during the installation because of an error. Now I'm trying to add the ...
1
vote
1answer
2k views

How to use a database in Qgis

What is the primary use of database in Q-Gis? How to connect to a database in Qgis?
0
votes
1answer
116 views

Using Mapbox with GeoServer or similar?

I am doing some research and trying to understand how Mapbox compares to GeoServer (or any GIS server software), and whether or not they are used together or if using one precludes using the other. ...
2
votes
0answers
51 views

Publishing Linked Datasets Format [closed]

This past summer for research I was working on linking the NOAA Rivers Database (http://water.weather.gov/ahps/forecasts.php), The National Atlas Lake Database, and the the USBGN datasets so that ...
0
votes
1answer
29 views

Unable to change default geodatabse with arcpy.env.workspace

Even after I set the path for the default database with arcpy environment variable, ArcMap does not change the default database directory? At first my arcpy.env.workspace looks like below: >>&...
1
vote
2answers
104 views

Advanced forms with QT designer

I have a QGIS project where a SHP-layer contains the IDs of plots besides vector data. I want to create a form with QTDesigner which enables me to enter the contact information of the landowner(s) ...
0
votes
3answers
72 views

Integrating ArcGIS for Desktop with Past Perfect for mapping public art objects?

I am working on a project where I need to map out several assets that are found around the city. The Arts Department utilizes a software called Past Perfect to catalogue and track any art assets. My ...
1
vote
0answers
37 views

Saving styles to database

In QGIS, the option to save the style to a database (postgres) does not appear in the drop down list if the postgis table has been opened using add vector layer and then entering the postgres database ...
0
votes
1answer
67 views

Cannot Convert Polylines to Polygons with Curves to JSON

I am getting this specific error and the following technical article solution does not work, any suggestions? The local edits were not synchronized to the server. Cannot convert polylines or ...
1
vote
2answers
53 views

How do I add my own data to an existing shape file?

I want to add event data to a geographical map. I have district shape files for Zimbabwe that I downloaded from GIS. However I now want to add my own data on to it. How do I do this? I have added ...
4
votes
1answer
132 views

ST_Transform doesn't work in PostgreSQL

When i run the query with ST_Tranform I get this error: Input geometry has unknown (0) SRID SQL state: XX000 How can I resolve this error? I want to convert from UTM into geographic lat/lon. ...
2
votes
2answers
495 views

Why use a database when you can have all of your data in javascript/openlayers?

I have a really simple and basic question. First of all, I have to mention that I am pretty new to web applications and GIS. I am working on a web application using Openlayers, Postgresql/postGIS and ...
1
vote
1answer
94 views

QGIS Shapefile edited by multiple users

I have a Vector layer containing 36000+ line Objects with a large number of attributes that is currently saved as Shapefile on a server (local network). Multiple users access and edit this Layer ...
1
vote
1answer
48 views

CartoDB restricts uploading only up to 250 columns

I had developed an application using cartodb.js which transforms a csv file uploaded in cartodb database to geometries in map. The application works fine when there are 230 columns in csv file and the ...
1
vote
3answers
280 views

Openlayers 3 GeoJson save and load

I am interested in openlayers 3, and I want to build a site. Already I can load features from variable in Geojson environment and I can draw features. But I could not write a code for saving drawn ...
3
votes
1answer
42 views

Finding route by joining next points

I have points data, e.g. p1,p5,p3,p6,p7 are the points of road-A, while p2,p4,p8,p9 are point of road-B. In database (PostgreSQL) points are in p1,p2,p3,p4,p5,p6,p7... How can I make a route, by ...
1
vote
1answer
179 views

Getting netCDF data into PostGIS database using Python?

I can read the netCDF file data with netCDF-python or with gdalinfo, but I am unsure of the easiest way to get it into a PostGIS database. It would be really easy if I could convert the netCDF file ...
0
votes
0answers
29 views

Null output from Transform function of Spatialite

I am using Spatialite, an extension of SQlite and I have some problems running the transform function. According to the Spatialite functions page (http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.2....
0
votes
1answer
67 views

Copying database view into an enterprise geodatabase?

Say I have DatabaseA, which isn't structured in a way that allows me to reference it as a geodatabase in ArcGIS. Fields have to be renamed, geometry added, etc. etc. Now, it seems to me that what I ...
2
votes
0answers
28 views

Attribute table update after v.split on GRASS GIS [duplicate]

So I just used v.split to create shorter segments (with just 2 vertices) of my contour lines. I was left with about 22000 lines but, when I open the attributes table, I find no more than 45 entry ...
0
votes
0answers
29 views

Using Definition Query to pull out monthly ridership data?

I have a database of bus stop ridership for Jan-Nov of 2015. There is an existing data set information pertaining to bus stops. I previously linked individual tabs (for each month) to the bus stop ...