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
1
vote
2answers
390 views

PostgreSQL - only allow points to be added to the table (no polygons or lines)

I want to know if there is a way to only allow certain Geometry types to be added to a table in PostgreSQL. I have a tool that currently allows points, lines and polygons but would like to restrict ...
1
vote
1answer
249 views

What is the max amount of connections a GeoPackage can handle in GeoServer?

I'm currently working on a GeoServer deployment and for simplicity, I want to to transition to using GeoPackages rather than Shapefiles (longer column names, less work integrating the data, etc.). As ...
1
vote
1answer
362 views

Can't insert a value into the table. PyQGIS 3.0. Postgresql [closed]

Can't insert a value into the table. PyQGIS 3.0 import psycopg2 conn = psycopg2.connect(dbname='postgres', user='postgres', password='1', host='localhost') cursor = conn.cursor() cursor.execute(""" ...
1
vote
1answer
270 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
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 ...
1
vote
1answer
1k views

QGIS: multiple values in a single field of the attribute table

This is my first question on this site: it is probably already been exposed many times, but try to forgive me if I could not find it. Secondly, English is not my native language, I will try to be as ...
1
vote
3answers
120 views

How to find which areas/regions a list of lat/lons are in?

The Australian Bureau of Statistics (ABS) issues Esri shapefiles or MapInfo files which have a code # for each geographical area at various 'resolutions' and I have a database with a column of ...
1
vote
1answer
1k views

Attribute table field default value not transfering to new edited features

Using ESRI ArcMap 10.0, in a versioned environment, we are in a geo-database and have a feature class with a default value populated in field properties. When we create a new feature using editing ...
1
vote
1answer
2k views

How to transfer layer data from OpenLayers to PostGIS database or QGIS?

Supposing I have a created some layers in OpenLayers containing only Geometry Points, how do I transfer my data to a postGIS database? Is there a way to turn pure javascript/openlayers to a table in ...
1
vote
3answers
616 views

Disconnect QGIS from database without closing the whole program

I'm making PostGIS queries to a GIS database from python and I'm using QGIS to visually check the results of my queries, but every time I want to run a new query I have to close QGIS because it keeps ...
1
vote
1answer
237 views

Seeking simple GIS for Estate inventory and mapping? [closed]

I think my GIS needs would be considered simple for the 3500 acre estate I manage: create maps of our roads, trails, fields, and buildings, and show distances on the roads and trails; calculate ...
1
vote
2answers
725 views

County-Level Ethnic Shapefile: United States

My professor usually provides the shapefiles that we deal with in our analyses of the United States--population, votes, etc., but I'd like to know how I can get these myself. I'd like, in particular, ...
1
vote
1answer
2k views

Can not make qgis.db private copy

I've just installed QGIS 2.0.1 on Ubuntu and the above error message appears. Does anyone know how to resolve this problem? I think I need to change the permissions of the relevant folder, but I'm ...
1
vote
1answer
7k 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?
1
vote
1answer
72 views

QGIS - Execute SQL Failure

I've written an SQL query which works in the query section of the QGIS DB Manager. SELECT Max(S_order), SegmentID, S_Order, Length, Buff_Segme, Buff_Order, Buff_Lengt, Buff_Uniqu FROM "...
1
vote
1answer
340 views

Understanding NOAA/GFS0P25 dataset of Google Earth Engine

I'm trying to get time-series data from NOAA/GFS0P25 data set on GEE. My code: var m2 = "NOAA/GFS0P25" var band1 = 'total_precipitation_surface' var data_collection = ee.ImageCollection(m2); var ...
1
vote
1answer
125 views

Which provider should I use with `qgis.core.QgsVectorLayer` method at `PostgreSQL database with PostGIS extension` storage?

I use PyQGIS 3.6.1 Noosa to load layer from my database storage PostgreSQL database with PostGIS extension using qgis.core.QgsVectorLayer method. But layer is invalid somehow. Performing same ...
1
vote
3answers
506 views

Connection to SQL Server in ArcMap

I want to add database connection to SQL Server from ArcMap. But, I don't know what to write as 'instance'. I've tried 'NT Service\MSSQLSERVER' but it doesn't work.
1
vote
1answer
251 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) ...
1
vote
1answer
577 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-...
1
vote
2answers
879 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
1answer
2k views

How to insert data into postgis database table?

I am a newbie in spatial database, so I am having lots of issues even in small tasks and now I am having some issue with inserting data to the table. I have followed the postgis documentation but ...
1
vote
3answers
188 views

Importing and exporting KML into and from DashDB for Geospatial Analysis

I am a recent convert to IBM's DashDB, and I considering proposing to use it at my work. My case would greatly be bolstered if I could show good, easy integration for geospatial analytics data, namely ...
1
vote
1answer
439 views

Maintaining CAD drawings and Esri Geodatabase simultaneously?

I'm wondering if there is a best practice for maintaining both CAD and ESRI GDB sytems simultaneously? I work for my local municipality and as it is now the Eng Techs update reference drawings in CAD ...
1
vote
1answer
2k views

Joining MS Access (accdb) table to Feature Layer in ArcGIS for Desktop?

I would like to join a table from a microsoft access database (.accdb) to a featurelayer in ArcGIS 10.1. How do I associate tables from that database with existing layers that have a matching ...
1
vote
1answer
1k views

Flatten / collapse one-to-many table and keep the 'many' attributes separate

I have a data set that contains intersection data. Each intersection node has up to 6 links which is identified by IN_LINK and OUT_LINK attributes. I want to create a new dataset that includes the ...
1
vote
1answer
584 views

Possible to store 3D features such as dome into geospatial database?

Is it possible to store 3D features such as dome into geospatial database such as PostGIS? I know that it can store x,y,z data, can such complex features be stored into database?
1
vote
2answers
2k views

Most optimal way to create a (spatial) database for big amounts of data?

I am using QGIS, and on my way to set up a huge spatial database (geographical), where most of the data is points without geometry), along with other types of data (like lines in DXF and areas in SHP)....
1
vote
1answer
1k views

Calculation to convert db data to Lat/Lng degrees

In a database I have the following Lat/Lng data. I wish to convert it to a readable format. 177514245:34726053 => S 32 7.3947, E 115 51.4245 177513828:34726948 => S 32 7.3052, E 115 51.3828 ...
1
vote
1answer
80 views

How to write unique ID(s) of polygons in layer A intersecting polygons in layer B to field in layer B?

I'm working in ArcGIS 10.1. Suppose that I have two polygon layers, A and B. Polygons in layer B can have one of a few relationships to those in layer A: They may be completely contained by ...
1
vote
3answers
762 views

Load information about a feature

I must mention first of all that I am very new to this area... I am developing a GIS application. I created a simple map using geoserver with openlayers, it is all working through apache tomcat - and ...
1
vote
1answer
856 views

Google maps api, several moving markers using a csv file containing the coordinates

I collected 5 sets of coordinates of moving vehicles and I want to play the scene using googlemaps API showing those 5 vehicles moving. The sets are saved in a postgresql table. is it possible ? if ...
1
vote
2answers
3k views

One Polygon Joining to Database with Many matching records

Using ArcMap 10.1. Is this possible to have one polygon and join to a database/excel with many matching records? I would like to have 1 polygon but match to 100 corresponding records in a table. When ...
1
vote
1answer
934 views

QGIS error when open project when layer via accesses the database

I changed from QGIS 1.7.3 to 1.8.0. Problem is that I can´t open QGIS Projects, QGIS crashes when there are layers involved loaded via access-database connection. I used eVis. What can I do?
1
vote
2answers
848 views

Apply Database based Rules to Openlayers

im trying to apply rules, where the data is fetched from an external database. This is my code: // create a new style and add rules var defStyle = new OpenLayers.Style({ ...
1
vote
2answers
63 views

QGIS style to DB

I want to import the style from a MapInfo.tab file into a postgis db. When I open the properties for the file and click on the botton style I only have the option save as QGIS QML style file or SLD ...
1
vote
1answer
343 views

How to make query of MySQL connection in QGIS?

i have added a connection with a MySQL database in QGIS (Add vector layer - Database - MySQL). Is there an option to make a query over the database in QGIS?
1
vote
1answer
451 views

Transfer data from SQL database to postgre database using GDAL

I am new to GDAL and have been uploading CSV crime data to a postgis database using ogr2ogr. ogr2ogr -f "PostgreSQL" -lco GEOMETRY_NAME=geometry -lco FID=gid PG:"host=server user=user dbname=dbname ...
1
vote
1answer
67 views

Postgis pgAdmin ST_area returning different to other GIS's

I have a shapefile which is returning a different area value in pgAdmin than in FME, Cadcorp SIS and QGIS and I don't know why it is different in pgAdmin. The setting used in pgAdmin are: SELECT ...
1
vote
1answer
29 views

Is it possible from inside QGIS to analyze a number of occurrances (non-points) of a given variable repeating in a database to map it?

I have a database with each and every death in a country, each row in the database has a GEO_REFERENCE tag constructed by the concatenation of a code given to every division and subdivision instead of ...
1
vote
1answer
40 views

How to get data from table and define the geometry on the same query?

My team is using DB2 database and I have to create and publish a map service in ArcGIS using one of the tables. The table has the XYZ column but no SRID defined in the table or database. The DB2 ...
1
vote
1answer
1k views

Shapefile and Database file too large for Google Earth/Accumap

I am completely new to GIS and I had hopefully a simple question regarding how to reduce the file size of my shapefile and associated database file. The files sizes are: Shapefile (.shp file format) ...
1
vote
1answer
3k views

Error using Wildfly10 + Hibernate-Spatial + Postgis

Hey I have set up a Nominatim Server to geocode my adresses. Because this all ready has the data I need in a other place I want to connect my Server again this database. So I tried to set up a ...
1
vote
1answer
171 views

Extract data from the .dbf affilated with a set of shapes

I have a set of shapes that I produced from a spatial merge. It has 1.6 million postcode polygons, however when I save it in QGIS to .csv it only saves two thirds of the data. I'm not sure why this ...
1
vote
1answer
80 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
1answer
198 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
2answers
99 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 ...
1
vote
1answer
381 views

Postgis/SpatiaLite SQL query to connect MySQL, Access or Oracle database

In SpatiaLite or Postgis, how can one create a SQL query to read a table from a MySql or Oracle database? I don't know **the correct SQL syntax to connect to a table in a MySql or Oracle database **....
1
vote
1answer
1k views

How to create template_postgis database?

I wrote the following code to psql (Sql Shell) createdb -T template_postgis nyc; but does not work because syntax error . trying to make an example of the links related aim GeoServer. I have ...
1
vote
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 ...

1
4
5
6 7 8