Questions tagged [spatial-database]
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.
461
questions
1
vote
1
answer
175
views
Coordinates from a SQL Server Inserts don't Show Results
I am trying to parse a JSON output file from an .Mxd file. All work fine and the following SQL Insert in SSMS using sample coordinates:
delete from RoomData
insert into RoomData (Building_ID,Room,...
- 451
1
vote
0
answers
308
views
5-star rating for mobile iOS app [closed]
Looking to create a mobile iOS app to collect consumer feedback on 10 separate locations using a 5-star rating system. There would be a total of 4 questions, each of which would require a separate ...
- 11
0
votes
1
answer
192
views
which spatial server goes better with raster images stored in DB Spatialite?
I would like to serve images from Spatialite as WMS services.
As far as I know:
Geoserver is compatible with vector features only -if you install the extension-, but not with spatialite BLOBs (in ...
- 1,495
0
votes
1
answer
213
views
How to use iterators in ModelBuilder to create new feature?
I am attempting to use ModelBuilder to automate the process of plotting parcels of land that are related to mineral leases.
The existing lease feature class contains information related to reference ...
- 882
3
votes
2
answers
6k
views
Order sql server spatial geometry distance by the nearest
I have a geometry column in a table, I want to get the N nearest neighbours; here is a specific example with the geography type
DECLARE @PTO Geography = Geography::STPointFromText('POINT(-57.432546 -...
- 191
1
vote
1
answer
71
views
Specific Feature Copying
I'm trying to write a script to copy multiple feature classes from two different databases into a single database, but I want to be able to specity what features I actually want. I know I need to use ...
- 11
2
votes
1
answer
116
views
Database to get New York City frontages?
I'm looking for a database that gives the length of frontage of an address or gives the information necessary to calculate this for New York City (NYC) or for another large US city.
So far I haven't ...
- 155
1
vote
0
answers
571
views
Error using ST_Geometry Aggregate Function for Hive
I am using the ESRI framework that extends the Hive syntax to support spatial types and operations.
In particular, I am trying to use an aggregated geometry function, announced in this blog post in ...
- 737
1
vote
0
answers
284
views
Seeking database that identifies adjacent postal addresses and/or zoning of postal address? [closed]
Can someone point to:
a database that identifies adjacent postal addresses (for example, if I provide an address, the database provides address of houses on either side of house address)?
a database ...
- 155
-1
votes
2
answers
357
views
File or personal database in QGIS?
Is there any database in QGIS? I use ArcMap with a file geodatabase. But now, I have to start a project in QGIS and I don't know, how to create a database.
- 9
3
votes
1
answer
2k
views
How to find a point on linestring and in a range of 10 meter
i have a linestring which is show in diagram and i have a point which is some time on the linestring or out of linestring but in range which is red line and some time its is out of range so how can i ...
1
vote
0
answers
1k
views
Route tracking on Google map PHP
I have to make a software that tracks a vehicle on Google maps using GPS. I have almost done this project but am stuck at a point. The client requires a system that tracks the bus in a route. I am ...
1
vote
1
answer
289
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 ...
- 53
4
votes
1
answer
3k
views
Determining date or time Feature Class was created in File Geodatabase?
I had a script running at the office over the last 5 days and tried to remote on unsuccessfully since the 3rd day. I got here and it appears there was a power outage. Is there a way to find out the ...
- 733
1
vote
0
answers
130
views
Migrate MS Access Data into Oracle DB
I was sent some old MS Access files that contained survey data and served as a "file geodatabase".
I want to import these to my Oracle Database with it maintaining "geometric" sense and meaning.
I ...
- 137
0
votes
2
answers
159
views
SQL filter to show one layer only if another layer is missing
I have two oracle tables that represent buildings in my town. The first table represent buildings that are surveyed and measured accurately but doesn't cover all the parts of the town while the second ...
- 407
0
votes
1
answer
67
views
Spatial query to make view
I've got two tables which I want to combine and enrich with each others data. I'm getting stuck on the join part, as this needs to be done via a spatial query.
First the table structure: a table with ...
- 2,259
2
votes
2
answers
393
views
QGIS Forms - How Do I Display a Read-Only Value?
Older versions of QGIS had an "Immutable" option for form fields to make it obvious that data was read-only. How do I display values in the current version and make it obvious that they are read-only?...
- 408
2
votes
1
answer
424
views
Databases supporting intersection of multipolygons and a set of points
Currently we use PostGIS to store thousands of MULTIPOLYGONs and we can then use ST_Intersects to return any that rows contain any point in an input collection of points. Are there any other open ...
- 489
0
votes
0
answers
212
views
When to use DBMS instead of System Files for Spatial Data Storage?
I'm having trouble deciding when it is best to use a DBMS instead of System Files for storage of Spatial Data. Are there any specific guidelines and reasons for when one method is preferred over the ...
- 182
0
votes
2
answers
1k
views
How to update Geodatabase point file table from Excel data using FME
I have excel spreadsheet with data that I want to load into a GeoDatabase point table. The table already exists and I want to update the data not append. There is a unique ID to link the Excel data ...
- 1
6
votes
1
answer
342
views
Spatial+Temporal database request for 4D intersection
Here is the function I need to implement. My application deals with mobile objects with variable position and range (think of radar range). As I can't test each minute if n mobiles detect each other (...
- 259
1
vote
0
answers
42
views
Adding feature to remote geodatabase takes a long time
I have a program that I must add some features to a feature class that is in a sql server remote database. But when I want to open connection and add them, it takes a long time, about one or two ...
- 435
3
votes
1
answer
189
views
Backing up database in PostgreSQL?
I need to create a backup from my database (in PostgreSQL 9.3). I have used the pg_dump tool, gives me an error. I have also used pgAdmin III for backing up which also gives me the following error:
...
- 449
1
vote
1
answer
83
views
Spatial queries to find co-occurrences of POIs
Given a POI database containing different types of points, e.g. hospital and pharmacy, how can I select the locations where a hospital and a pharmacy are closer than a certain threshold (e.g. 1000m)?
...
- 111
8
votes
2
answers
2k
views
How to replicate ArcGIS Intersect in PostGIS
I'm trying to replicate this ArcGIS process in PostGIS: http://blogs.esri.com/esri/arcgis/2012/11/13/spaghetti_and_meatballs/. This describes how to break buffered points down into polygons based on ...
- 414
1
vote
1
answer
129
views
Implementing Wrapper of PostgreSQL?
How can I implement the Wrapper of PostgreSQL?
I found this useful looking wrapper from a FOSS4G routing with pgRouting Workshop but I do not know how to implement it!
- 419
-1
votes
2
answers
2k
views
Adding an excel database to an existing shapefile [duplicate]
I have a spreadsheet with various feature data; I would like to add this data to an existing shapefile. I have a common column in both the shapefile and the excel data. I would like to be able to ...
- 574
2
votes
0
answers
893
views
Import GML data in SQL Server Spatial
I have GML file with Application Schema whose data I need to import into SQL Server Spatial. I have been creted database structure with all thing that I need in database, and now I need to fill it ...
- 233
1
vote
1
answer
907
views
GeographyFromText and ST_SetSRID+ST_MakePoint different results?
Why am I getting different results?
SELECT ST_DISTANCE(
ST_GeographyFromText('SRID=4326;POINT(13.401111 52.383343)'), --berlin
ST_GeographyFromText('SRID=4326;POINT(9.997559 53.533778)') --...
- 113
0
votes
0
answers
472
views
PostGIS Spatial query taking a very long time
I'm trying to return a count of crimes (points) that occur in each police grid (polygons), as well as the geometry data, but the query takes ~22 seconds. This seems oddly high and will be problematic ...
- 414
2
votes
1
answer
906
views
How to create an SQL Persisted Computed Column which values are derived from spatial column
Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
- 704
21
votes
1
answer
7k
views
Advantages of R-trees in comparison to geohashes
Geohashes are being widely used in products like: Lucene, mongodb, etc and have become one of the most important technology of present day.
Have Geohashes replaced the good old R-trees or do R-trees ...
- 333
0
votes
0
answers
575
views
How to improve performance using spatial indexing with STIntersects()
I am working on Spatial database. I need to check intersection of state geometry with geometry inside database. I am presently using the query as:
SELECT
a.ID,
a.OBJECTID,
a.MSID,
...
- 27
0
votes
1
answer
62
views
Commercial Admin Levels
I'm looking to find commercially available admin boundaries (0 through lowest available) for the world that I can place into a user-friendly interface that allows the non-technical user (ie someone ...
1
vote
2
answers
2k
views
Error while creating spatial database connection
I'm using ArcGIS 10.0, and I've already created my database using "ArcSDE for PostgreSQL Post installation" ..
My database is successfully created in PostgreSQL and now that I'm trying to create a ...
- 665
0
votes
3
answers
2k
views
ST_transform postgis
SQL within that zone is a point
SELECT
"public".zona.zts
FROM
"public".zona
WHERE
ST_Within (
ST_Transform (
ST_GeomFromText (
'POINT(-30.033514 -51....
- 979
1
vote
1
answer
3k
views
Problem loading spatialite extension with sqlite3 Python connector
I am trying to load the Spaltialite extension using SQLite3 python module. I am getting the following error when I run my script.
EOFError: [Errno 10054] An existing connection was forcibly closed ...
- 2,696
0
votes
1
answer
82
views
managing postgresql database table using the pgadminIII sql tool
i have created a database using postgresql 9.1 and a table containing parcel information for a town council database on a windows 7 OS. i created the geometry column using the SELECT ...
- 41
0
votes
1
answer
282
views
Integrate static database with spatial database
I have some questions about how to integrate static database with spatial databases.
problematic:
I have several static data bases on different platforms (Oracle, MySQL, SQL Server) I want to turn ...
- 979
0
votes
2
answers
697
views
How to select the cross streets in postgis spatial table?
I've used ST_Intersects and ST_Crosses but between two different tables.
I have a table of streets and intersections want to know them.
For example select all streets that cross the Street A.
Can ...
- 979
0
votes
1
answer
735
views
What is the best way to manage geodata with open source software?
We are a small group of GIS users with different expertises embedded in an administrative infrastructure attempting to switch to a small and low cost open source infrastructure (open source GDI). ...
- 1,472
3
votes
1
answer
4k
views
Problem PostGIS Spatial Query ST_Contains ST_Disjoint ST_Intersects
I'm working on a project with two different tables inside a database. One contains points in a column geometry(Point,4326) type and the second one has a column geometry(MultiPolygon,4326). Now I would ...
- 31
1
vote
2
answers
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)....
- 75
1
vote
1
answer
622
views
Can SpatiaLite Indexes be used from views?
I'm working with a large SpatiaLite database and trying to take advantage of some spatial indexes I have on my tables that I'm attempting to access through views.
Essentially, I have a number of ...
- 163
1
vote
1
answer
104
views
Strategies for managing (and ultimately merging) duplicate business locations in a spatial database
I am working on a project right now that involves using multiple (very large) "location directories" to identify with the highest possible inclusiveness, a diverse set of business locations.
These ...
- 1,814
2
votes
1
answer
884
views
Using polygons with libspatialindex
I am investigating using some C/C++ libraries for point-in-polygon lookups and libspatialindex seems popular. I've written some code that seems to do what I want but I'm not entirely sure if what I ...
- 121
2
votes
0
answers
2k
views
Precision for an FGDB raster dataset? [closed]
I would like to know the precision for an ArcGIS raster stored within a file geodatabase (FGDBR format); I can't seem to find this information anywhere in their documentation (apologies if I have ...
- 73
4
votes
2
answers
278
views
Is transformation of spatial data lossy?
I have a shapefile that contains data of a country from the following Geographic Coordinate System ( GCS_North_American_1927 aka NAD27 )
contents from the shape file .prj:
GEOGCS["...
- 143
2
votes
2
answers
2k
views
Using Qt Designer to Create a Form in QGIS that can search for a specific point in a layer
I would like to ask if you can create a form in Qt Designer to create a form that can search for a point on the map using data that the user will provide such as the Name.
I am currently creating a ...
- 21