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

-1
votes
0answers
15 views

What is the name of the USGS catalog system in literature

We are going to make a database and we would like to see some examples(USGS Landsat8) but when we make a search with random related words, nothing comes up. So that would be great if you know the ...
0
votes
0answers
5 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 ...
0
votes
1answer
39 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 ...
1
vote
1answer
37 views

Database Tiled Aggregation request

We have a table in MariaDB that contains a lot of point of interest. These POI have a list of numerical attribute such has occurrence, weight, etc. We are looking for a way to aggregate these POI by ...
0
votes
1answer
33 views

Choosing database for spatial and nominal data for current QGIS version? [closed]

For a nature conservationist community we are running a database (Access) in combination with ArcGIS with data about position, number and species. Our new goal is to convert the data into a (spatial) ...
1
vote
0answers
28 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
22 views

Attribute table update after v.split on GRASS GIS

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
28 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
43 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
21 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
48 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
39 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
40 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
73 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
18 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
34 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
48 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
19 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
80 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
52 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
72 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
53 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
56 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
66 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
69 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
52 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
49 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
69 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 ...
0
votes
0answers
67 views

Getting netCDF data into PostGIS database using Python?

I can read the netCDF file data with netCDF-python or with gdalinfo, but I am unsure of the easiest way to get it into a PostGIS database. It would be really easy if I could convert the netCDF file ...
3
votes
1answer
449 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 ...
0
votes
0answers
134 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 ...
1
vote
3answers
223 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
1answer
193 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 ...
1
vote
1answer
26 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
74 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 ...
0
votes
2answers
96 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?
-2
votes
1answer
123 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
68 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
123 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 ...
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 ...
0
votes
0answers
104 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
75 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
46 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
150 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
21 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 ...
0
votes
1answer
121 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
votes
1answer
144 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
1answer
70 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
233 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 ...