Spatial database is a database that is optimized to store and query data that is related to objects in space, including points, lines and polygons.

learn more… | top users | synonyms (1)

0
votes
1answer
93 views

Looking for succesful implementaion of PPDM in form of geodatabase

I am have difficulties in implementing spatial version of Professional Petroleum Data Management (PPDM) for our GIS database. Does anyone have a reference to a sucessful case of implementing PPDM in ...
0
votes
0answers
28 views

geodatabase feature class to shapefile attribute table issues

I am using ArcGIS v10.4 and have a geodatabase feature class with ~800,000 objects (polygons) that I need to export to a shapefile with the attribute table in tact. However, no matter how I have tried ...
0
votes
0answers
20 views

Creating 3D Geo-Database System with QGIS

Currently I am working on a project to create a Virtual 3D City Model. I have Digital Aerial Photos, Digital Terrain Models, Geo-referenced Thematic Data, 3D Geodata, Digital Architecture Models, and ...
1
vote
1answer
224 views

Edit xy domain of feature classes during import from boilerplate geodatabase schema (ArcGIS)

Situation: I work for a company that creates geodatabases for a client that are restricted to a specific boilerplate schema (eg domains, subtypes, etc.). During a recent draft review, the client ...
1
vote
1answer
198 views

Creating geodjango model with geometry field that can accept different projections

I am working on web application with GeoDjango and within the model (db table) RoadAxis I have geometry field or more precisely LineStringField where I need to store different polylines (road axis) ...
0
votes
0answers
24 views

Using gridded data (including temperature and rainfall) converted and merged at district level?

I am trying to put together a climate dataset on precipitation and atmospheric temperature for districts in India. On the one hand I have climate data obtained from NOAA website, which has long term ...
1
vote
1answer
97 views

Add and edit Oracle Spatial Layer in QGIS

When I connect oracle layer are not enabled me all editing options. I can create and delete but not update. It is an issue of users? permissions or privileges? metadata? All works OK in ...
0
votes
1answer
59 views

Calculate centroid of a point cluster

Having this function that inserts locations in a database: def insertLocation(cur, label, point): print label cur.execute(""" SELECT label, centroid, point_cluster ...
0
votes
1answer
188 views

how to see a base map created by map builder in database?

I am new in oracle, I tried to create a style, then different themes and then a base map. I saved all my work, but I can't see the base map in the database. Did I miss something? The interesting ...
6
votes
2answers
1k views

How to write all attributes when multiple source files have the same name?

I am using FME to write all the MapInfo TAB files in a directory and it's subdirectories to a File Geodatabase. I'm using dynamic readers and dynamic writers as I don't know the geometry or schema of ...
1
vote
1answer
225 views

ArcCatalog Registering a Feature Class into Geodatabase: Getting an Error

This is a SQL Server GeoDatabase. I have created a couple of tables using SSMS; then imported data to them. Then, inside ArcMAP, I created Layers and pointed their data to these tables via SDE. So now ...
1
vote
0answers
20 views

Slow SDE Feature Class Performance

I've been experiencing slower than usual performance (noticeably slow time to draw as well as query, compared to similar feature classes) with a specific feature class in my organizations enterprise ...
0
votes
1answer
23 views

Carto DB city border polygons issue?

I want to visualize some statistical data about my country and I'm using the CartoDB geocoder. I've city names and I want to see cities as polygons but CartoDB says it has no polygon data, it can only ...
0
votes
1answer
13 views

SDO_GEOM.RELATE DETERMINE says 'EQUAL' but doesn't return TRUE in the where clause

The following query returns 'EQUAL' for the geometry-relation : select a.g3e_fid , b.g3e_fid , SDO_GEOM.RELATE( SDO_CS.MAKE_2D( a.g3e_geometry), 'DETERMINE', SDO_CS.MAKE_2D( b....
0
votes
1answer
21 views

How find Nearest points using STBuffer and STContains in SQLServer using given point from point table?

This is the Query I am using now.. SELECT top 1 coloumname FROM tablename WHERE ROUND ((geometry::Point(74.8427116215336,12.852857058953,4326).STDistance(the_geom))*111.325,2) <2 ORDER BY ...
1
vote
1answer
41 views

ogr2ogr append 1 row to a File GDB feature class's data table

I export a polygon layer from Oracle to a FileGDB using ogr2ogr. I need to append one row to the data table, with '0' for numeric fields and 'No Elements' for the one string field. In ArcGIS, I run a ...
0
votes
0answers
13 views

I'm trying to direct connect a Pictometry (EFS 2.7) install to a ArcGIS 10.3 SQL server geodatabase

I'm trying to point my Pictometry (EFS 2.7) install to a an ArcGIS 10.3 SQL server geodatabase, it previously worked connecting to an older arcsde service. Do I need to upgrade anything?
0
votes
1answer
34 views

VB.net search for address in Geodatabase in ArcObjects

I am try to search for address in Geodatabase in ArcObjects using VB.NET I tray this sample but my database is large so when I use this sample in TextBox1_TextChanged it is slow ! How can I search ...
0
votes
1answer
119 views

Visualizing map from Spatialite DB on Mobile

I am working on an Android application for a school project. I am converting shapefiles (examples) into SQLite databases using SpatiaLite and performing queries on those databases on the mobile with ...
1
vote
0answers
55 views

Getting H2GIS functions to work in Spherical Space?

I've been playing around with H2GIS (http://www.h2gis.org/) for a project at work and am struggling to get the H2 functions to operate in spherical space (lat/ lon), rather than cartesian space. The ...
3
votes
2answers
67 views

How do partition tables improve query performance in PostGIS? [closed]

I have static road, country and state datasets in my PostGIS database. Road networks are partitioned by their containing country. Countries, States and other areas reside in their own table and are ...
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 (...
0
votes
1answer
120 views

Clustering of Spatial Data in R or Python [closed]

I am new to GIS. Problem Domain :- I have a stoppage data of different vehicle i.e. the point where vehicle stopped.There are some specific vehicle which stops at some particular point. So, I am ...
0
votes
1answer
115 views

Parse and load GPX into database? [closed]

Having a PostgreSQL database, with the following tables: CREATE EXTENSION postgis; DROP TABLE IF EXISTS trips CASCADE; DROP TABLE IF EXISTS locations CASCADE; CREATE TABLE IF NOT EXISTS trips ( ...
3
votes
1answer
79 views

How to split ESRI file geodatabase into two or three by region?

I have got a ESRI file geodatabase(10.3) with many feature-classes(Polygon, Polyline & point). I don't have enterprise ESRI license. I have to split the entire data into two unique parts to do ...
7
votes
1answer
286 views

How do I optimise performance on a local QGIS + PostGIS installation?

I'm learning how to manage a local PostGIS (ver 2.1) database, with spatial indexing enabled on the shapefiles that I've imported (using the PostGIS Shapefile Import/Export Manager). I have imported a ...
1
vote
1answer
127 views

Mysql 5.5 spatial to Google Maps API

I've got a mysql table with points and polygons spatial geometries. I can see that MySQL 5.5 doesn't have the ST_AsGeoJSON() function to extract to GeoJSON. I'm looking for the simplest way to ...
1
vote
1answer
23 views

How to determine if all polygons are contiguous by single point in SQL Server

I've been looking for some function that will consider geometries from a table. The selection would look something like this: SELECT geom FROM mytable WHERE geoid IN (1, 10, 15, 30, 2) How can I ...
0
votes
1answer
25 views

3d city database set up problem

I am trying to set up 3d city database and I have some problems. I hope you can help me. I receive an error as you can see attaching file. What is wrong? The error message is: '"\psql"' is not ...
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 ...
10
votes
4answers
3k views

Inserting points into SQL Server using pymssql?

I am collecting X and Y values from a web service (Twitter) via a python script. In the long run, this will run over a period of months and I intend on stopping at around the 6 million point mark. ...
0
votes
1answer
27 views

os module can't find time files were created, because “system can't find file specified”

I have ~200 layers in a Map Document, and I am trying to find the dates that these layers were created on (so I can export to database later). Some of these layers are housed in groups and sub-groups ...
19
votes
3answers
2k views

What are the differences between spatial databases? [closed]

What is the difference between Oracle Spatial, PostGIS, SQLServer2008, SpatiaLite, and MySQL in terms of their spatial support. Are there specific use cases where each shines. What might you want to ...
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 ...
3
votes
2answers
1k views

How to read MapInfo .tab files in ArcPy?

I want to use arcpy (the ESRI install of python 2.65) to analyse MapInfo TAB files...can this be done directly or do I need to convert them to shp files...if so would it be possible to do something ...
5
votes
3answers
6k views

Clipping/exporting multiple selected vector layers in map to extent of another raster/vector layer in ArcGIS Desktop?

Is there a way to clip/export selected vector layers (more than one) in a map to the extent of another raster/vector layer at a time?? in Arcgis or any other software. I am using Arcgis10. I am ...
26
votes
3answers
4k views

Organization and tidiness of multiple copies of layers? [closed]

Back in the days when I was in the university I had a "Organization and tidiness" problem – I was unorganized and kept my layers in different folders without distinct names and hence had multiple ...
0
votes
1answer
90 views

How to find Nearest point on line from a point cordinate in SQL server

I want to find out the nearest point on my road network which is a multiline string from a point with lat lon value. The below code I have tried for finding buffer distance line from a point. ...
25
votes
2answers
55k views

How to insert a point into postgis?

I have created one table in my Postgis. But I can not insert point. I do not know what's wrong with my query? CREATE TABLE app ( p_id INTEGER PRIMARY KEY ); SELECT AddGeometryColumn('app','...
2
votes
1answer
62 views

How to update PostGIS column with distance from features in the same table

I have a table 'mytable' with columns 'Geometry', 'featurecode', 'height' and 'pkey'. There is a spatial index and im using PG9.4 For most of the table the height column is null. Only where ...
10
votes
1answer
3k views

Creating table containing all filenames (and possibly metadata) in File Geodatabase?

I need to create a metadata-table for all files in a File Geodatabase or Spatial Database. Is it possible to automatically be updated with new filenames, and possibly even metadata (as created in ...
4
votes
2answers
2k views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...
1
vote
1answer
102 views

Open source UML modeling software (GIS)

I am wondering is there any opensource UML to Postgresql Mysql tables conversion software which also includes the geospatial datatypes ? Note:I want conversion from UML to database. and NOT ...
2
votes
2answers
237 views

How to get an area Latlong geometry directly from google map?

I am new to field of GIS. I need to know that do we have an option of getting latlong of a building that we see in google earth or any Point of Interest areas. Something like i create & drag ...
1
vote
1answer
41 views

Is it safe to combine data for zipcodes across different demographic sets? [closed]

My team is working with demographics data across different data sources (some paid sources and some free data sources available online). Each of these data sources comes with a shape file and some ...
0
votes
0answers
24 views

Can I used a share drive as a PostgreSQL server?

I am currently using my C drive to practice and I have a shared drive with my co-workers where we store shapefiles. I wanted to start another server in our shared area to have us all connect the files ...
1
vote
0answers
32 views

Creation of 3d terrain from real data [duplicate]

Possible Duplicate: 3d terrain from data in postgres I am pretty new to spatial database and 3D data. I have a project where i have to create a 3d terrain from data being taken by me by a sort ...
0
votes
1answer
40 views

How to create SpatialPixelsDataFrame from Latitude and Longitude data?

I have a data frame that contains latitude and longitude data with density point. I want to do kriging but my main problem is that I can not create SpatialPixelsDataFrame from my data. My data is ...
2
votes
0answers
128 views

Is the postgis layer option in qgis 2.12 Lyon two way? Was the spit plugin built in?

I am trying to install Postgresql with Postgis on a remotely accessed terminal only installation of Ubuntu 14.04 that I want to use to connect to QGIS 2.12 and hopefully have a two way transfer ...
3
votes
1answer
867 views

Possible solution for dangling nodes?

I was just asked in a interview what a dangling nodes was. I had no idea and asked a former co-worker. I was informed that a significant amount of time was spent fixing these. I was confused how ...