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
0answers
44 views

Google static map path from MS SQL spatial data

I am trying to generate Google static maps on the fly that include a path based on data I have in a MS SQL Server geometry column. I currently use the encoded path algorithm to reduce the length of my ...
0
votes
1answer
22 views

Standardized format for contributing street closure data to navigation apps

I am wanting to put together an application that will digest georeferenced road closure data. I am wondering if any such format currently exists for notifying google maps or other navigation ...
1
vote
1answer
61 views

Can't import multiple features or rasters into file geodatabase

I am trying to use the import multiple features into geodatabase option in ArcCatalog (ArcGIS 10.1). Or, similarly, I try to use the import raster option, which screen layout is similar to the ...
1
vote
3answers
585 views

How do I find points that are NOT within a list of polygons using MS SQL?

I have a table of points, and and a table of polygons. I have managed to build queries (MS SQL) to get the containing polygon for a given point, as well as listing all the points within a specified ...
0
votes
2answers
172 views

Getting Started Using Leaflet Draw to CrowdSource Shapes on a Map

I want to crowdsource shapes on a map for an organization I'm working with. It seems like Leaflet Draw something along the lines of the Mapping Neighborhoods projects. As someone with some experience ...
0
votes
1answer
326 views

Install Postgresql / Postgis with SFCGAL

I need to access ST_StraightSkeleton() function. At the moment i have a Postgresql instalation PostgreSQL 9.3.4 compiled by Visual C++ build 1600, 64-bit installed via EDB with Postgis 2.1.7 on a ...
0
votes
0answers
16 views

How to convert File Geodatabase to Personal Geodatabase [duplicate]

I have a file geodatabase (gdb) and I want to convert it to personal geodatabase. I am using ArcMap 10.2. Does esri support this conversion? Any easy steps? what I would like to achieve is to access ...
2
votes
2answers
75 views

Any free Tools to display more than 5000 geography objects in SQL Server?

SQL Server 2008 and up allow you to create a spatial index. If you select records that include a geography or geometry object, a spatial data tab appears that can display up to 5000 points or lines or ...
2
votes
1answer
69 views

Can qgis cooperate with phpmyadmin?

Can this two cooperate together? I am asking this, because I have database in myadmin with column for long. and lat. informations. Is there a way to connect qgis with myadmin? Or what type of ...
0
votes
1answer
55 views

Distributed Geodatabase ExportDataChangeMessage

How to perform ExportDataChangeMessage. I am not getting where to get in_replica. My code is: Geoprocessor GP = new Geoprocessor(); GP.SetEnvironmentValue("workspace", outputpath1); GP....
1
vote
0answers
34 views

How to show neighboring polygons and polygon in which point exists

We have a table which has polygon related data stored. For finding if a point (long,lat) is within that polygon I am using following query in mysql SET @vasantKunjSectorC = 'polygon((77.161266 28....
1
vote
0answers
36 views

Partial extents for ArcGIS android geodatabase creation

I know how to create and download a geodatabase copy of a FeatureServer from arcgis rest services. I also know how to pass LayerQuery to the geodatabase task to filter layer objects and features. ...
1
vote
0answers
71 views

Difference between adding spatial layer from MSSQL through “browser” and “add MSSQL table”

So I am trying to pinpoint the difference of adding layers from MSSQL Database that contains spatial layers like geography and geometry. I have noticed that when adding from the browser it retains it ...
1
vote
0answers
114 views

Issues creating ArcSDE sde_logfile for certain users (username begins with a numeral)

I am having issues when editing an sde feature class from certain users. The way my database is set up is that the authentication roles are updating constantly by comparing the current authentication ...
0
votes
0answers
52 views

Importing feature class into feature dataset of different coordinate system

So currently I'm creating a geodata base and I'm arranging alot of the data into feature datasets. I have been using the feature class to geodatabase tool to import the data directly into the feature ...
7
votes
1answer
288 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 ...
0
votes
1answer
121 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 ...
3
votes
1answer
103 views

Showing multiple burials in same grave for Cemetery GIS?

I am an intern creating a Geodatabase for a municipal cemetery. The one lot can hold up to 3 people (2 people, 1 cremation) two people at the most. How would I show that information on the map ...
1
vote
1answer
226 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 ...
3
votes
1answer
58 views

PostGIS - interfacing with CADCORP 7.1 and QGIS - user 'postgres' can import, but no other roles can

I'm new to PostGIS (reasonably) - but I'm plagued with one on-going problem: I'm able to access PostGIS from various GIS systems using the main 'postgres' user. Using a newly created user 'gis_viewer'...
2
votes
1answer
200 views

How to change field length with ArcObject?

I want to change some string field in sdegeodatabse with bellow code. The code are running without any problem. but after running, filed length return to default length. What am i missing? static ...
1
vote
0answers
29 views

Most efficient way to rasterize a planet

I'm working on a Webservice where GIS supports my services as a Crowd Intelligence Aggregator to help civilian (like civilized) aid to support provisioners in a case of emergency, e.g. pestilence, ...
8
votes
3answers
1k views

Poor performance with storing large rasters in PostGIS and visualising in QGIS

my question concerns the use and performance of several software tools in conjunction, namely PostgreSQL, PostGIS, QGIS, and GDAL. I'm a long-time ArcGIS, Python, and R user who is interested in ...
-1
votes
1answer
325 views

Adding a column of WKT format in the table (postgreSQL)

I want to include this column of data that are in WKT format (they are mostly straight lines). What data type should I use? I need to create this database for mapping. There are about 30000 features ...
1
vote
0answers
64 views

Export Joined table an Feature layer based on a query

I have a table and a layer joined fine, I am trying to export the end result into a file geodatabase, the export is fine if I specify specific name, other than that it exports the original layer data. ...
3
votes
2answers
164 views

Need a vector format that is editable in QGIS and supports >10 character column names

For reasons, I need to create a new column in a vector shapefile with a name longer than 10 characters, and export to mapinfo TAB format. I know .shp's don't support >10 character column names, so I'...
0
votes
0answers
156 views

bounding box - generate coordinates

I will be using mongodb database which supports data on an Euclidean plane (not spherical). I will be performing queries which return all points within a box. For the box I need to specify the upper ...
1
vote
0answers
58 views

Is order of selection in Spatial Data important (attribute, location, graphic)?

When dealing with spatial data in a GIS system, does it matter which way you select the information if you're using all 3 - attribute location and graphical selection? In my experience it seems to not ...
1
vote
2answers
58 views

GIS and Geodatabase with Reminder Function

a friend of mine, a landscape gardener, asked me wether it is possible to represent his garden (mainly big trees and a few flower fields) in a GIS so he could administrate these on his computer by ...
0
votes
0answers
33 views

Dealing with multiple georeferenced, but possibly slightly offset datasets

I have elevation data stored at 5 meter resolution in a raster file. I would like to go in and add this data into a database (lat, lon, elevation.) I have another rasterfile with other data, also at ...
1
vote
1answer
49 views

Raster appears like polygon in Arcmap

I copied rasters across into my geodatabase for a client but when they open the raster dataset in ArcMap they appear in tiles as shown in the image below. When I drag and drop individual rasters over ...
1
vote
1answer
187 views

spatialite : spatial index on geometries

I'm currently learning to use spatial access methods for query optimization. I'm going through the examples in spatialite cookbook and got stuck in here http://www.gaia-gis.it/gaia-sins/spatialite-...
2
votes
1answer
115 views

Full Text Search in ArcSDE

We have a quite large ArcSDE (~120 versioned feature classes & tables, 1M-3M records) which has Oracle or SQL underlying DBMS. This SDE is exposed through a MapService and we use ArcGIS JS API to ...
0
votes
1answer
74 views

Creating spatial database with many categories that have same set of values?

I am working on creating a spatial database of county agricultural data where each county has multiple crops (30+) and for every crop there are several production metrics (yield, harvested area, ...
0
votes
0answers
53 views

How do I design a database for storing GPX tracks and supporting spatial queries? [duplicate]

I have a series of GPX files that contain 1...n tracks. Each track contains roughly 5k - 10k points. The GPX files do not contain waypoints or routes. I want to design a database with the following ...
-1
votes
1answer
93 views

How to import data into a table from another similar table?

I am working with PostgreSQL to import a table from a .shp file and my task is to populate another table (same attributes as this .shp table) with the data of the table of the .shp file table that i ...
0
votes
2answers
58 views

Using Arcpy to search geodatabase for feature with smallest number of rows and export as .SHP

I have created a bunch of grids for a city boundary area. I would like to know how to use the Arcpy module to look through a geodatabase and find the grid with the smallest number of rows (assuming ...
1
vote
1answer
83 views

Performance is downgrading with multiple feature datasets design for ArcGIS?

My company develops a spatial planning solution since 2009. Initially it was an ArcMap application to create and maintain spatial plans (competing with AutoCAD folks) but recently we developed "...
1
vote
1answer
202 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
2answers
123 views

How to convert GeomSHP to WKB

I have imported a point shapefile called site_locations.shp into a personal geodatabase. Now I'm trying to retrieve the data from the database using SQL: dbpath = os.path.normpath(r'../geodata/...
1
vote
3answers
44 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
45 views

What is a “value raster”?

I want to understand the concept of a "value raster" and if I can use it in neighbourhood statistics.
0
votes
1answer
87 views

GIS information on worldwide cases of wildfires?

I am developing some case studies on wildfire cases around the globe, some examples include California (2007), Australia (2009), Moscow (2010), Valparaiso in Chile (2014), and so on. I was wondering ...
0
votes
2answers
861 views

How to change different projections of feature classes in geodatabase to one projection in new geodatabase?

I want to create a script that iterates through feature classes with different projections in a geodatabase and exports them into a new geodatabase, all with the same projections. What I want is to ...
0
votes
2answers
118 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
68 views

ArcMap, Editor and Geodatabase API edit session question

Say a feature class from a File GDB is added to ArcMap and an editing session on it is in progress. What happens if an add-in launched from the same ArcMap session tries to start an edit session using ...
0
votes
1answer
59 views

Select and count street pattern features (morphology) using ArcGIS for Desktop?

I'd like to be able to select and count the number of cul-de-sacs, lollipops, dead ends, or other types of street structure in a hillside community.
0
votes
0answers
341 views

Export geodatabase feature class to .dbf or .txt file

I have 40 super large (millions of records) geodatabase feature classes (areal data) and would like to export their attribute tables into .dbf or .txt files using model builder. I tried using "table ...
1
vote
0answers
182 views

Add Rasters to a new GDB/Mosaic Dataset in ArcGIS ModelBuilder

I'm attempting to add rasters to a new mosaic dataset in a new file geodatabase, all in the same model. However, the Add Rasters To Mosaic Dataset tool does not recognize the NewMosaicDataset or the ...
1
vote
1answer
171 views

Where can I find global spatial data for net primary productivity (NPP)?

The title is more or less self-explanatory. I have looked and looked but have met various road blocks. Does anyone know of a reliable source for such data? Thanks!