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
911 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 ...
2
votes
1answer
742 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
215 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
1answer
2k views

Using ArcPy to get all database names within server?

I am trying to populate a folder with ArcSDE database connection files for all the databases within a server instance. I need to be able to do this for several of our servers. Although I know within ...
2
votes
1answer
267 views

How do you get a schema report from SHP, PostGIS, or other file type?

All, We're loading City and County data into our database, but looking to remove several fields we don't use. Those fields we do use I'd like our users to simply highlight on a printout I give them ...
2
votes
1answer
2k views

WFS & Feature Access -> Database connection / Database support (ArcGIS 10.2)

Over the last two days I've tried to set up and to use a postgreSQL database to use WFS and Feature Access. I've also started a thread in the esri forums, but I hope that I can reach a wider audience ...
2
votes
1answer
1k views

psql changing comma to decimal for importing CSV file

I try to import a CSV file into a PostgreSQL database that runs on a remote server. I use psql via SSH. AIS_DB=# CREATE TABLE bet_srk_2008 ( AIS_DB(# Unique_VesselTraject numeric, AIS_DB(# ...
2
votes
2answers
126 views

write z-value from polygon layer to point layer in QGIS

I have two layers: 1 polygon layer where the depth of an area is written in the database (as DRVAL1) and and where the depth is exported as a Z-value to the geometry. 1 point layer that I use to plan ...
2
votes
1answer
1k 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 ...
2
votes
1answer
222 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 ...
2
votes
1answer
223 views

Can't upgrade to PostGIS 2.2

I am running on MAC OSX El Capitan. My version of postgres is 9.4.5.0. My PostGIS version is 2.1.7. I cannot upgrade to PostGIS 2.2, because when I am trying to do, it pops "PostGIS requires SFCGAL >= ...
2
votes
1answer
2k 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 ...
2
votes
1answer
407 views

Topology Editing using ArcView (now called Basic) license level of ArcGIS Desktop?

I am building a geodatabase from data collected on a GPS handheld in the field. The GPS device collects decently accurate information but I need to make sure all the polygons, lines, and points are ...
2
votes
1answer
2k views

Google Maps, HERE maps data in one database

I want to create a database from HERE and Google Maps to combine with my data. Then I create an application that can use this database. Basically I want to host the server with Google and here map ...
2
votes
2answers
681 views

Looking for ArcPy tool for calculating statistics on field with summary field AND boolean fields

What I'm searching for is a tool that will sum a field by a secondary unique field AND booleans... Let's say I have 12 table each with 4mil records and the following fields: Donation_Amount ($ ...
2
votes
1answer
201 views

Database View in Oracle 9i with SDE 9.3.1

If I have a sql statement creating a view against ArcSDE 9.3.1 on Oracle 9i, is the best practice to create the view in ArcCatalog just creating the name (kind of shell of the view) then going in to ...
2
votes
0answers
103 views

How to save each band in a new row with it's name, in PostGIS?

I have used PostGIS's raster2pgsql to import my multi-band raster data into my PostGIS database. Here is the code that can do this operation: raster2pgsql -I -C -e -Y -F /home/jj_user/input.tif ...
2
votes
0answers
17 views

Existing standard country codes explicit in time and space

There are several comprehensive systems for coding countries such as ISO, TLD, M49. I am looking for a system that is explicit about the time period that the code refers to. My application is a ...
2
votes
0answers
60 views

Creating QGIS Symbology Database?

I'm looking to swap from MapInfo to QGIS at my work and im trying to see if its possbile to have a centralised symbology database. eg to be able to pull our symbology from a database rather than from ...
2
votes
1answer
381 views

Exporting data to a text file using a template

I've build a toolbox in my project environment to plan "Aids to Navigation". The vessel (ship) that does the actual work in the field has a navigation computer that can only import waypoint. These ...
2
votes
0answers
749 views

GDAL PostgreSQL shapefile import “Unable to find driver 'PostgreSQL”

I have seen a number of posts similar to this but with no resolution. I am experimenting with GDAL commands and am fairly new to it however when using a PostgreSQL database connection I am getting ...
2
votes
0answers
61 views

Common information shared between Geopackages [closed]

I'm trying to build a map in which I have a few geographical units organized as such. Commune ---1:N---> Contrada Contrada ---1:N---> Vineyards One commune may contain many contradas, which ...
2
votes
0answers
51 views

Creating multiple users for postgis db created with qgiscloud plugin?

I have created a PostGIS database using qgiscloud plugin. I would like to give access to 3 more users (usernames and associated passwords) in order for them to update 3 specific layers only, without ...
2
votes
0answers
31 views

Camera reports database online to look it up?

I received tons of aerial photos that go back to 1930's and I have the information about the camera number and lens number and focal length. They were taken in a picture of the roll that tells us what ...
2
votes
0answers
141 views

Joining an ArcGIS Enterprise Database to another SQL database [closed]

I'm curious if it is possible to join an ArcGIS enterprise database to a separate SQL Server. My intention is to have 1 unique attribute on the ArcGIS layer that can reference the row in the SQL table ...
2
votes
0answers
2k views

How to connect existing postgis tables with Django models

I have some existing tables (shapefiles) and I want to connect each table with a django model. I imported the tables with shp2pgsql tool: shp2pgsql -I -s 2100 -W 'iso-8859-7' world.shp public.world | ...
2
votes
0answers
161 views

How to make a database to be a model parameter in QGIS?

I built a model in QGIS that imports vector into PostGIS database. My only problem is that I can choose which database I would like to import my data into but only if I rightclick on the model and ...
2
votes
0answers
309 views

What exactly is the memory impact on the database when reducing cells size in a Raster GIS?

I understand that the size of the memory of a raster database increases when reducing the cell resolution. I read some about it in the ArcGIS Help. However, I am wondering about the exact relation on ...
2
votes
0answers
3k views

Access database file to QGIS [duplicate]

I'm trying to import an Access file (.mdb) to QuantumGIS. This database comes from a geodatabase from ArcGIS. Can someone explain me how to do it? I tried to import from Add Vector Layer > Database >...
2
votes
0answers
161 views

Importing a shapefile and keep getting error with PostGIS manager [duplicate]

I am new to PostGIS and using pgAdmin. I have tried to import a shapefile into PostGIS manager and it gives me this message: Importing with configuration: ex_hzfi99mczhvqbnkrya6ryz35mveyt_osm_point, ...
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
603 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 ...
2
votes
0answers
142 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 ...
2
votes
0answers
1k views

How do I set up a PostgreSQL database for use with PostGIS and GeoDjango?

The Django docs say to use createdb -T template_postgis geodjango but I already have a database set up. While trying to find out what this actually does and a way to apply it to an existing database, ...
2
votes
0answers
116 views

QGIS: Edits in attribute table are not updated in Postgis database. Why?

As the title say. I edit values in the attribute tables of my QGIS project but there is no update to the database. I refreshed in QGIS as well as the database. What else do I need to do?
2
votes
0answers
151 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 ...
2
votes
0answers
3k views

Coverting annotation into a shapefile

I have created an annotation feature class in Arc10 and when viewed within the database, looks great. However, whenever I go into catalog and export the annotation feature class to a shapefile, it ...
2
votes
0answers
90 views

Bounding Box approximation when calculating in euclidic space?

Although I will illustrate my problem using a database, I think this is a quite general GIS question. I hope I came to the right place to ask. I am working with a system that runs on a normal ...
2
votes
0answers
77 views

Raster layer with unique vector for each raster cell?

I have been looking around several hours, even days, but couldn't find a clear answer to my question. I am working on a WebGIS tool that interprets local geology. From more than 70 asc-files, I would ...
2
votes
0answers
929 views

Connect QGIS to MSSQL view (i.e. not a table)

I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display. ...
2
votes
0answers
211 views

How exactly is an SLD_body object (when extracted from its XML href) structured when using a cElementTree to parse it?

I'm trying to export data from a PostGIS database into a geoserver and I've gotten it to where I can get the PostGIS database to point to the geoserver (I'm doing this as a python script for a GIS ...
1
vote
3answers
8k 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 ...
1
vote
2answers
3k views

How is a database related to a .mxd file?

What exactly is an mxd file, and how is it related to a database? Can a single database have multiple mxd files?
1
vote
3answers
2k views

How Oracle is related with GIS (Professional wise) [closed]

I am GIS B.Tech Graduate. In the aiming of becoming GIS Developer .I temporairly changed my profession from GIS Analyst to Software Engineer. But what I got in this software company is oracle (not ....
1
vote
2answers
2k views

PostgreSQL select value where '100%' using bigint

I am trying to select data from a bigint column in PgAdmin using SQL: SELECT FROM public.addressbaseplus WHERE uprn LIKE '100%' However, I am getting the following error: ERROR: operator does not ...
1
vote
1answer
830 views

PostGIS update column with selected

I am new to database sorry if this is basic. I have selected point geometry from a geometry column in pgAdmin, however, I would like to know how to now copy the selected points to a new column? This ...
1
vote
2answers
176 views

Seeking web service that returns elevation profile between two points and can process 5000 requests per second

I need a web service that provides elevation profile data between two coordinates with request rates at a minimum of 2000 requests per second but preferably at 5000 per second. The distance between ...
1
vote
2answers
1k views

Cannot convert dms to dd in Excel 2007 using VBA code

I am trying to convert the data in an Excel sheet from dms (degree-minute-second) to dd (decimal degree) format using the vba script available here. Here is sample data: 53° 0' 39.31" 6° 44' 50....
1
vote
2answers
1k views

osm2pgrouting connection failed

I'm importing data from my OSM file to a postgresql database using osm2pgrouting. I followed everything in from here and it went smoothly, until I try using osm2pgrouting. This is what happens: root@...
1
vote
5answers
1k views

Store Geometry in a database with the ESRI Silverlight API

Is it possible to store geometry objects in a database using the ESRI Silverlight API? For this particular case, the client may have SQL Server 2005 installed instead of 2008 and therefore I can not ...

1 2 3
4
5
8