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
1answer
27 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
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 ...
1
vote
2answers
48 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
71 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 ...
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 ...
3
votes
2answers
129 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 ...
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 ...
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 ...
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
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 ...
3
votes
2answers
77 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. ...
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 ...
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. ...
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) ...
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 ...
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
131 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. ...
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
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
275 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 ...
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 ...
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 ...
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 ...
2
votes
1answer
90 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 ...
0
votes
0answers
23 views

Using FEAT_NUM Instead of FID as a Unique Identifier

In GIS data which entity would be the definitive Global Unique Identifier ? The FID which is a system generated unique number that once deleted will never be generated or a FEAT_NUM which is ...
-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(); ...
0
votes
0answers
51 views

Linked Excel file with Coordinates to Shapefile QGIS

There may not be an answer to this as I have yet to find anything from my searches but here goes. I have an excel file which is continually updated my multiple users. Within the excel file each row ...
2
votes
1answer
82 views

OSM update without loosing 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 ...
1
vote
1answer
105 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
34 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 ...
1
vote
1answer
86 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
73 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
0answers
30 views

Export SQL table with images to Qgis

In MySQL Workbench 6.3 CE I created a table with some columns. One of this columns is of data type 'BLOB' to insert an image. Now i am looking for a way to export this table and import this table ...
3
votes
2answers
149 views

PostGIS database design: For polygon data

I am designing a spatial database using PostGIS. My main aim of this spatial database is to organize Administrative (250 polygon layer) and postal layers (154 layers) in a database. These layers ...
2
votes
1answer
130 views

How to fix: update of view in private qgis.db failed error

After a change in permissions, I started to get this error message: Update of view in private qgis.db failed. table vw_srs already exists I know that changing the ownership of the db or deleting ...
1
vote
1answer
124 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 >= ...
1
vote
1answer
186 views

How to convert a complex project of shape files to a spatialite database?

We have a QGIS project made of ~10 shape file layers. The layers are saved on a shared server, and the project is used on different computers. Recently polygons and polylines have been been ...
3
votes
1answer
65 views

Linking file geodatabase and ArcSDE?

My office does a lot of field work where we log points via the Collector app. Those points are then always exported to a geodatabase feature class for further editing and analysis. If edits and ...
3
votes
2answers
71 views

Edits, When Adding to Geodatabase, Revert to Default in ArcMap

ArcMap 10.3.1 I have several shapefiles that I am attempting to edit in the following way. 1) Right click on shapefile -> properties -> add hyperlink capability to a field in the attribute table -> ...
-1
votes
1answer
100 views

mapbasic - how to link my database in my mapbasic coding

I'm creating a tool in MapBasic that identifies the PCI clash in 4G I need help: How do I add database data into MapBasic? How can I calculate mod values and colour the output in MapInfo based on ...
0
votes
1answer
111 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 ...