Questions tagged [database]

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.

Filter by
Sorted by
Tagged with
2
votes
2answers
315 views

Geoserver SLD: link to symbol in database instead of file

I have a PostgreSQL table with fields: 'id' with identificators of objects types (e.g. shops, cinemas etc), 'graphic' with SVG codes of correcponding map symbols. I want to create sld style with ...
0
votes
1answer
580 views

Using an ArcSDE Connection through Python

I would like to run a script on a ArcSDE feature class. The script runs perfectly when I hard code a shapefile, but is unable to connect to an ArcSDE database. The purpose of the script is to assign ...
1
vote
0answers
357 views

How to store tile maps into databases and use them for web mapping?

I am making a web map using leaflet and a lot of tile maps from raster files. When using gdal2tile.py to convert these rasters into tile maps, it will automatically create a bunch of directories and ...
1
vote
1answer
75 views

How to select a subset of a PostGIS table when using the QGIS Offline Editing plugin?

When using the Offline Editing plugin to 'Convert to an offline project' is it possible to make a selection of the dataset rather than 'offline' the whole table?
1
vote
0answers
52 views

Why are only some tables shown in QGIS when I connect to database? [closed]

For a project I started to work with pgAdmin and QGIS, so I'm quite new in these things and I have a problem with the connection of the database to the QGIS. I can connect myself to the database and ...
0
votes
1answer
808 views

Locating which geographic polygons intersect a point

I am working on a real estate website, and each property has a latitude and longitude. We also have a database of schools (among other things), and each school has a list of geographic points that ...
3
votes
1answer
650 views

Linking ArcGIS to Access

I am working to link spatial data in ArcGIS 10.3.1 (parcels with many attributes) to an Access database of customers. Initially all I need is to identify which parcels are in my database and append ...
0
votes
1answer
629 views

Seeking solution to using PostgreSQL/PostGIS views in ArcGIS for Desktop?

We are currently trying to 'clean up' our geodatabase. For example: we have 30 datasets of districts, each of a different year (1986-2016). To make it more visible, we want to combine them all into 1 ...
1
vote
1answer
214 views

Merge databases in QGIS

I would like to merge two similarly constructed spatialite databases. I have tried to open a first database (1), add the second database (2) to the project and copy/paste the attribute table from (2) ...
0
votes
1answer
71 views

What SQL query will replace nth character(s) in QGIS DBManager? [closed]

I have a table with a date/time column. The symbols separating the date need to be changed in order for it to work with the TimeManager plugin. Eg. 2016:08:13 08:41:20 to 2016/08/13 08:41:20 The ...
1
vote
1answer
425 views

Designing interactive map of botanical garden in QGIS?

Using QGIS is absolutely new to me but I hope, we can make it as short and easy as possible to put my idea into practice. I hope that QGIS is the appropriate program for this purpose. I have COREL-...
3
votes
2answers
470 views

QGIS Spatialite import fails when data is projected

I'm trying to import a shapefile into a spatialite database via drag & drop. This works fine while the data is in a geographic coordinate system, but I need to do some measurements and therefore ...
1
vote
1answer
413 views

How to fix the definition(SQL) of a view that has errors (in ArcGIS)

Occasionally, schema changes that are made in my tables cause errors in my views. Example: a field is changed in a table that was referenced by a view. When there are errors in a view, ArcGIS Desktop ...
1
vote
1answer
647 views

Loop over GeoTIFF image pixels, extract coordinates and pixel color

I have a very large GeoTIFF image (~650MB) with color-coded landcover data from here. I need to extract the latitude, longitude, and pixel color for each pixel in the image, so I can import it into a ...
0
votes
1answer
59 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 ...
0
votes
0answers
293 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 (...
3
votes
0answers
308 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 ...
1
vote
2answers
431 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
873 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
54 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
354 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 ...
1
vote
1answer
188 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
1answer
87 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 ...
5
votes
2answers
927 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 ...
0
votes
1answer
291 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 ...
0
votes
1answer
51 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.
14
votes
3answers
3k views

How to refresh the attribute table of a layer after editing the table in the DB-Manager?

Is there any way to refresh the attribute table of a layer after editing the table (e.g. add a column) in the DB-Manager?
1
vote
2answers
685 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 ...
4
votes
2answers
841 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
1answer
222 views

Unable to change default geodatabase 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
781 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) ...
1
vote
0answers
418 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 ...
1
vote
2answers
79 views

How do I add my own data to an existing shapefile?

I want to add event data to a geographical map. I have district shapefiles 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 ...
7
votes
2answers
8k 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. ...
1
vote
1answer
679 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 ...
3
votes
2answers
300 views

Is there any geocoding for better international support? [closed]

I need international support database with Chinese and English, do you know any data provide both? (So far, I found only Google Map and MaxMind is okay; Open Street Map just poorly supported data; ...
1
vote
1answer
1k 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 ...
2
votes
1answer
137 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
7k 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 ...
2
votes
1answer
185 views

Foreign Key error, creating new splite db?

Attempting to use a plugin in QGIS (Midvatten) that utilizes splite. I am attempting to create a database in a different Coordinate reference system than the plugin defaults to, I'm getting "foreign ...
1
vote
0answers
303 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
230 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 ...
3
votes
1answer
50 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 ...
2
votes
0answers
39 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 ...
2
votes
1answer
530 views

Visualize PostGIS 3D line geometry [closed]

I have PostGIS table with 2 geometries ( "GEOMETRY(MULTILINESTRINGZ)" and "GEOMETRY(LINESTRINGZ)" ). There are lines made just from 2 points - XY are WGS and both of them have random elevation Z (I ...
1
vote
0answers
88 views

GIS Analysis Services for third party DBMS [closed]

In our database environment (gemstoneDB - smalltalk) we would like use some of the core features of GIS Tools like intersecting shapes, find nearest polygons, create buffer around lines and points etc....
-1
votes
1answer
165 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(); ...
2
votes
1answer
663 views

OSM update without losing own additional data

I have added data (e.g. name keys) to my OSM PostgreSql database. How can I update my database without deleting or overwriting this data? In other words, how can I merge newer OSM data to my existing ...
2
votes
1answer
203 views

Cloud based database solution [closed]

I'm looking for a cloud based database solution where I can store about 1 GB worth of tabular data and both myself and my client can access to perform SQL queries. I'm looking for this database to ...
2
votes
0answers
136 views

Is there any map API that allows you to pull an address range from a polygon?

I've seen a lot of answers saying you can't draw polygons and get the exact addresses of all of the places contained; thankfully, I don't need so much info. I'm looking for a way to get a vague ...