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

2
votes
1answer
258 views

Google Maps, HERE maps data in one database

I want to create a database from HERE and Google Maps to combine with my data. Then I create an application that can use this database. Basically I want to host the server with Google and here map ...
2
votes
1answer
534 views

Using ArcPy to get all database names within server?

I am trying to populate a folder with ArcSDE database connection files for all the databases within a server instance. I need to be able to do this for several of our servers. Although I know within ...
1
vote
0answers
24 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 ...
14
votes
6answers
9k views

QGIS, Postgis: Geometry type does not match column type

I'm trying to import some polygon shapefiles to Postgis in QGIS via SPIT. One of them can't be imported and returns this error: ERROR: Geometry type (Polygon) does not match column type ...
2
votes
1answer
97 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 ...
17
votes
6answers
2k views

Spatial databases learning resources for newbies

Would be taking up a course on spatial databases next semester. Would anybody know a newbie friendly introductory resource? A vendor neutral one would be preferable. Thanks.
1
vote
1answer
102 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
102 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 ...
-1
votes
1answer
87 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 ...
3
votes
1answer
60 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
68 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 -> ...
26
votes
12answers
47k views

Where can I obtain an up-to-date list of US ZIP Codes with Latitude and Longitude Geocodes?

NOTE: This began as a question on Stack Overflow, which has subsequently been closed. I also noticed a similar question about Most Up-To-Date Source for US Zip Code Boundaries, but I believe this ...
2
votes
1answer
356 views

Connecting CartoDB to existing MySQL database

I'm trying to create a simple heat map based on longitudinal and latitudinal map coordinates that can be transferred from a database on MySQL that I've created. I read that CartoDB can be connected to ...
0
votes
1answer
76 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
0answers
72 views

Registering database to ArcGIS for Server gives null error?

I'm trying to register a database to ArcGIS for Server 10.2.0 from the web server manager using sde file from ArcMap. The connection works fine in ArcMap. But when registering I'm only getting a ...
1
vote
1answer
106 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 ...
4
votes
3answers
274 views

Hydrology, operational rainfall-runoff models

I am trying to collect information about operational rainfall-runoff models used around the world. I hope to build database with country outline with attached information what organization is covering ...
3
votes
1answer
934 views

BLOB TYPE in Arcmap

I created an excel spreadsheet which converted to blob type when i imported it into ArcMap .I am trying to view the BLOB type field in ArcMap because I want to join this blob field to a common field ...
1
vote
3answers
332 views

Are there alternatives to the Google Places API, for lat/long retrieval?

I am looking for an alternative API to Google places both free and paid to extract location data (lat/long) for business locations i.e all of the "coffee shops in London". I have looked at Factual, ...
0
votes
0answers
178 views

How do I set up a PostgreSQL database for use with PostGIS and GeoDjango?

The Django docs say to use createdb -T template_postgis geodjango but I already have a database set up. While trying to find out what this actually does and a way to apply it to an existing ...
4
votes
1answer
1k views

is there any direct access to Mapbox data? (similar to CartoDB's sql api)

I've been asked to add a form to a map that will write data in the background (e.g., ajax to a magic file that does datawrites and some emailing, notifications etc) and a new marker will be added to ...
0
votes
1answer
287 views

Osm2pgsql failed due to error when I try to import data into PostgreSQL

I am using the following link to install openstreetmap server on my ubuntu 14.04 server. I have followed their tutorial line by line and installed most of the dependencies and everything. When I try ...
0
votes
0answers
16 views

Change dbase table alias

How can I change the alias of a dbase table without completley renaming the file? I've tried right clicking the the file, opening properties, and changing the alias, but it will not allow me to edit ...
0
votes
2answers
501 views

Setting up a GIS server or platform

Sorry for my lack of knowledge. I have been using GIS for a while but just for analysis and don't know much about the data side of the business. Recently my boss asked me to think about setting up a ...
9
votes
2answers
1k views

Future for geospatial on App Engine?

2 years ago, this question was posted here at Gillies's blog, on date of 2009-05-15. Future for geospatial on App Engine? At that time there was no news relating to any apps of GIS web services ...
1
vote
1answer
32 views

Web map linked to database that shows one spatial location at a time

I have a simple database with a record for each research project that occured on a national forest. Each project area is associated with a polygon, and there are around 200 polygons that are piled ...
0
votes
2answers
114 views

How is a database related to a .mxd file?

What exactly is an mxd file, and how is it related to a database? Can a single database have multiple mxd files?
8
votes
3answers
984 views

What are the Pros and Cons of hstore data type in postgis?

PostgreSQL has a module named hstore that implement the use of key/value pairs (it's something like the OpenStreetMap model, but in a single table). What are the Pros and Cons of hstore regarding GIS ...
0
votes
2answers
96 views

Global roads information prefrably with traffic volume

Im looking for a high quality global roads database. The only constraints I have is that it should be completely open (even foe commercial use) I have looked into some publicly available databases ...
-2
votes
1answer
135 views

What are shapefiles, layer files, and databases and what are their relationships? [duplicate]

What exactly is a shapefile in ArcGIS, and how is it related to a database or a layer file. What are the differences between these 3 things?
-1
votes
1answer
73 views

What is a database in ArcGIS? [closed]

I was wondering in general, what exactly is a database and is there a difference between that and a geodatabase? I was also wondering when you would use a database as part of ArcGIS. Do you make one ...
3
votes
2answers
129 views

Switch between test and production database in ArcMap?

I have two Oracle 11g databases, one for testing (tst.world) and one for production (prd.world). Except when I am trying out new things, they have exactly the same table structure. In ArcCatalog I ...
2
votes
1answer
136 views

Tag for calculating way length in osm2pgsql?

There is a special tag 'way_area' in osm2pgsql creating a database column that stores the area of polygon features. So is there something like this for calculation of length of line objects?
1
vote
0answers
34 views

Combining Datasets from multiple scraped data CSV files using FME [duplicate]

My main goal is to collect information of US Golf courses located in the United States and geocode them to create a meaningful map. I was able to scrape from four sites in which I created 4 CSV ...
4
votes
3answers
3k views

Create an ArcCatalog OLE DB Connection using Python

Is it possible to create an OLE DB connection (*.odc) to a database in ArcGIS 10 , but using Python instead of the ArcCatalog GUI wizard? I don't need to necessarily create a file on disk, just make ...
0
votes
0answers
129 views

How to use NewSQL Database with GPS tool with Node.JS as server side programming

I am a web project manager and I want to create a website to show current position of cars on the map (google or ARC). I know how to create the website, but I don't know how to fetch the longitudes ...
1
vote
1answer
89 views

Where to store lat/lon data with additional informations?

I have huge database of lat/lon GPS coordinate points. For every point, I have several other variables (height, surface type, temperature, pressure...). Also, data will be changed every day and old ...
2
votes
0answers
50 views

QGIS: Edits in attribute table are not updated in Postgis database. Why?

As the title say. I edit values in the attribute tables of my QGIS project but there is no update to the database. I refreshed in QGIS as well as the database. What else do I need to do?
6
votes
3answers
171 views

Efficient processing of difference between input data and database

I have an input dataset whose records will be appended to an existing database. Prior to being appended, the data will go through heavy, time-intensive processing. I want to filter out records from ...
0
votes
1answer
24 views

Adding data column by column in postgreSQL database

I organize my data in different txt files and dat. files, mostly in each file there is one specific column of data. Now I want to import and combine 4 of them to create a table. Say I have one file ...
-1
votes
1answer
226 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 ...
2
votes
1answer
167 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 ...
3
votes
1answer
2k views

Installed PostGIS extension not listed for database

I have a PostgreSQL database with the PostGIS extension enabled. I know that this extension is enabled, since I am using PostGIS functions, and I can actually see the PostGIS functions. However, ...
1
vote
1answer
75 views

Column length editing in QGIS or ARCGIS

Can anyone suggest how I can change the length of an existing column (For ex. column name -- ABCD, column_Type -- Text, Length -- 254). It would be great to have solution on platforms like ArcGIS or ...
0
votes
1answer
68 views

ArcGIS Route Analysis

I have a pipe network that is a imported CAD file converted to lines showing complete runs of pipe in a system. I also have a Access database imported to ArcGIS set up as a relate to my Pipe line ...
0
votes
1answer
313 views

Cannot add database connection using windows authetication SQL Server and ArcSDE 10.3

We can't seem to add a database connection from ArcSDE to sql server 2008 using ArcCatalog 10.3.1 from a specific computer with a specific username. When trying to add a database connection using this ...
1
vote
0answers
155 views

Why is mapserver returning a blank image?

I am trying to load a layer from a postgis database, mapserver does not return anything. I think I have narrowed the problem down to the fact that the sql query mapserver is running is returning ...
4
votes
1answer
215 views

Pulling CSV file directly from website into QGIS?

I want to be able to automatically update my csv files in a QGIS project. My organization has an online database that can easily export csv files. These csv files are constantly updated with new ...
0
votes
2answers
134 views

Seeking web service that returns elevation profile between two points and can process 5000 requests per second

I need a web service that provides elevation profile data between two coordinates with request rates at a minimum of 2000 requests per second but preferably at 5000 per second. The distance between ...
1
vote
0answers
35 views

Export only one value from a one-band raster

I have a PostGIS database with a georeferenced raster, with one band which contains values from 0 to 255. I should export it to a transparent GeoTiff picture in which the only visible pixels are those ...