Acronym for Structured Query Language. A syntax for retrieving and manipulating data from a relational database.

learn more… | top users | synonyms

1
vote
1answer
65 views

Fastest way to transfer data from SQL to ArcMap?

I frequently have to use large tables and results from MS SQL in ArcMap and for that saving the data as .xls is one of the options. But when I add the data to arcmap, processes like joining and ...
0
votes
0answers
23 views

Dealing with NULL values in geodatabase using GDAL commands?

I have a geodatabase and I'd like to return a value for NULL. (When I look at my raster layer, there are a lot of zeroes which I am assuming is because of the NULL values) Is there a way to use the ...
1
vote
2answers
5k views

QGIS Select by Expression

A basic QGIS 2.2.0-Valmiera, Select By Expression - Field Calculator question. Introduction I am a geologist searching through a geological database (see attached figure). I have a shape file and ...
5
votes
0answers
327 views

Geoserver create SqlView Layer with Geoserver Manager

I would like to register a new sql view layer to geoserver through the rest api. I am using geoserver-manager. The registration is ok, the layer is working fine, except wms getFeatureInfo, which ...
1
vote
0answers
42 views

calculate positive difference by column common value with sql

I have one table with a few columns (and around 9000 rows) see below. Now I would like to calculate the positive difference from R where Xn has the same value and when Xn has the same value as Yn. ...
0
votes
1answer
178 views

SQL Make Table (from .mdb) to Point Shapefile

For my school assignment, I must compose an SQL statement which retrieves data from a database in .mdb format. I have no problem developing the SQL statement. It is a requirement that we have an ...
4
votes
1answer
1k views

Cartodb - SQL query of public visualization of a private table

The team at CartoDB have recently(last few days) made some useful updates that now allow public visualisation maps to reference data in private tables. The change has only been made in the last day ...
1
vote
1answer
569 views

How to import .csv file to CartoDB using SQL?

How to import .csv file to CartoDB using SQL, the data given below : POINT | TOP_dm | BOTTOM_dm | X_RD | Y_RD 35AP7600 | 4418 | 4368 | 262053 | 467223 35AP7601 | ...
4
votes
3answers
379 views

Filtering dataset using SQL or Python in ArcGIS Desktop?

Using ArcGIS Desktop 10.0 SP4. I have a large dataset of sites that needs to be filtered down to a usable size. There is an attribute for the site_ID and another one for the site_type. There are ...
4
votes
1answer
62 views

How to use MAX SQL statement in ArcGIS?

I would like to use a MAX SQL query for a column in a definition query, where there records that are being queried are the MAXIUM from the field UPDATE_DATE_DATE while grouping by the field ...
0
votes
1answer
65 views

SQL in Python using variable - Arcpy

I have a code in which I'd like a da.UpdateCursor, I have probles with the "where clause", here I am about to use a variable that I get from arcpy.Describe. I have no idea of this even possible. My ...
2
votes
1answer
170 views

SQL Server Geography Query works but Geometry Query Does Not - Different Tables, Similar Schemas

I am trying to get a Geometry query to work. A similar Geography query works fine but I must work with a table that uses a Geometry type. Although the Geography version returns lots of records as ...
0
votes
1answer
56 views

postGIS 'dynamic' SQL queries

I have a postGIS table: id value geometry 0 10 'g_0_10' 0 20 'g_0_20' 1 10 'g_1_10' 1 20 'g_1_20' 2 10 'g_2_10' 2 20 'g_2_20' ... ...
3
votes
1answer
468 views

Update a table with values from coordinates on GEOMETRY in Oracle

I have 2 columns in a table that represent the X and Y coordinates. The values in those columns don't match the actual coordinates and I want to update them with the coordinates values that are ...
2
votes
1answer
349 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 ...
2
votes
0answers
59 views

Error on qGIS with postgresql views

I have a PostGIS database with various tables and views. With pgAdmin I can make requests on the tables, on the views, all is working. I add tables in QGIS 2.8, it's working, I can read, write, modify ...
0
votes
0answers
92 views

ogr2ogr conversion error - Can't create fields of type Binary on shapefile layers

I'm having trouble using the ogr2ogr tool on the command line. My data is stored in SQL as binary, type is mixed polygons and multipolygons. I am using the following command for conversion from SQL to ...
3
votes
2answers
268 views

Trouble using ST_Difference to remove overlapping features

I am trying to use ST_Difference to create a set of polygons (processing.trimmedparcelsnew) that do not contain any of the area covered by another set of polygons (test.single_geometry_1) using ...
0
votes
2answers
90 views

Using ST_LINE_INTERPOLATE_POINT in OGR and python

I'm interested in finding the midpoint on a linestring using OGR and python. This can be a line with more segments. Could I use the ST_LINE_INTERPOLATE_POINT in python using the ExecuteSQL() method? ...
3
votes
1answer
787 views

Duplicate ObjectID in ArcSDE Table

After making a check in from an arcpad AXF file, i notice that there's duplicate ObjectID records. This ArcSDE PostgreSQL table is versioned and edited by Axf checkins and a .net engine application. ...
0
votes
1answer
109 views

Qgis 2.10 unable to add a new feature in spatialite via sql function “GeomFromText”

Using Python code in my plugin the function in sql language "GeomFromText(POINT(X Y))" gives the following error: "OperationalError: no such function: GeomFromText" Plugin functions in previous ...
1
vote
1answer
100 views

How can I limit a spatial binning query to a specific bounding box?

I am using Esri's GIS tools for Hadoop but I think the query is pretty standard stuff. The SQL/HQL below is from the Esri tutorial found here ...
0
votes
0answers
77 views

Creating Query Layer with 1:M relationship in ArcGIS?

I am trying to create a query layer in ArcGIS which contains 1:M relationship, When i execute query i am getting blank feature class. My query is as below SELECT a.Industrialcode, a.Industrialname, ...
2
votes
2answers
68 views

CartoDB's SQL API: Row too large

I am trying to run the following PostGIS query using CartoDB's SQL API: SELECT the_geom, ST_Area(ST_Intersection(the_geom::geography,ST_Buffer(ST_SetSRID(ST_MakePoint(-52.4379, ...
-1
votes
2answers
145 views

Sql Query in Postgresql

I am trying to execute a query but I am stuck. I have two tables A and B. The a table has columns gid, geometry(line-string) and value which cells is empty , the B table has got 3 columns gid, ...
0
votes
1answer
2k views

How can I show numbers as percentages in CartoDB?

I would like to format numbers as percentages in cartodb. What are the best functions to display numbers with decimals, comma separators or percenteges? Thanks
4
votes
1answer
41 views

Cartodb API Read Only

Is it possible to generate an API-key in Cartodb with read-only permission? Seems like the default API-key has full controll
0
votes
1answer
70 views

GDAL -SQL or -where options

ogr2ogr -overwrite -t_srs EPSG:3978 -f "ESRI Shapefile" -sql "SELECT * FROM 'Layer Name' WHERE FIELD_NAME = 'A CLASS'" dst.shp src.shp help me out here - looking to 1) reproject a shape and 2) ...
0
votes
1answer
74 views

Where clause in MapInfo Table Updates

Is it possible to add a where condition to an update query in MapInfo? At the moment I have to do a query to select the records I need and then do an update on that query. I believe this is ...
1
vote
2answers
71 views

Inputting integer values into SQL statement using ArcPy?

I am defining a function for use in a ArcGIS tool that will verify attributes, catch errors, and obtain user input to rectify those error. I want the tool to select and zoom to the segment that is ...
0
votes
0answers
70 views

Selecting all cells not containing a number in SQL

I have a field containing some values. In edit mode, when I click on any one of these values it gets replaced by 1.#QNAN in the cell. I would like to query the table for all cells containing ...
3
votes
2answers
1k views

Selection subquery using another table in database ArcGIS

I need to 'extract' a list of variables based on the IDs from another table. Using a subquery seems to be the best method. I have a large list of variables and have outside calculated a second list. ...
2
votes
1answer
172 views

Show Log of the Sql statements that QGIS generates to retrieve Data from Postgis

Is there a ways to - make QGis log its generated SQL Statement or to - force POSTGIS to log all interaction with QGIS? There is something strange happening to the WFS layer I retrieve in QGIS, since ...
1
vote
1answer
105 views

How to select from geometry column in postgresql?

I've got a table which it has a geometry column filed by some point (ex. "POINT Z (116.309627 39.991285 148)"). now I want to select point's id from the table. I wrote follow sql Code but I force an ...
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 ...
2
votes
3answers
593 views

How to use STUnion with GroupBy

I'm using SQL Server 2008 R2 to store Geometry data types. I have a bunch of lines as individual features, that share common names ('NAME' field). I would like to create a view that Groups By 'NAME' ...
2
votes
2answers
185 views

how to snap points to lines in QGIS/PostGIS?

I'm attempting to snap approximately 900 points to a line table. I've tried recreating what I have found from a couple of PostGIS answers but not having much luck. To test, I've created two ...
1
vote
1answer
65 views

How to store multi-valued attributes in PostGis using Postgresql [closed]

I have a with meterid,meterreading,reader and date read.I wish to store this data using Postgis database. I used this code via postgresql to create the table CREATE TABLE MeterRdg( meterid ...
1
vote
1answer
87 views

Updating static GTFS data android

I have an android application that takes a static GTFS data that I manually turned into a database. My question is how do I update this GTFS data automatically? Or is that not possible? Any ...
0
votes
1answer
34 views

Differences between columns in MapInfo

I have two columns in a nodes table, one column has the ground level of the node taken from the model and the other column has the ground level inferred from LiDAR. Is there a query that can be used ...
1
vote
0answers
106 views

PostGIS dijkstra routing - specifying source and target as bigint instead of int4?

I'm currently working on a problem where I have to use PostGIS's pgr_dijkstra to calculate the shortest route from a starting point to a destination, and then use ST_AsGeoJSON to convert the route to ...
5
votes
2answers
145 views

QGIS expression builder include relation attributes

I have a set of symbols based on a table in postgis such as this id|type|action_1|action_2|geom In QGIS I have this table symbolised using a rule expression which works effectively. However this ...
3
votes
2answers
334 views

Column 'SHAPE' cannot be null in mysql database even if the query string is correct

I am trying to write an POLYGON into an column named SHAPE which is a geometry type. And created query which looks $sql = "INSERT INTO rokka(zone,district,location,area,SHAPE) VALUES ...
2
votes
1answer
87 views

How can I do a subquery inside a subquery in PostGIS?

I need to add a subquery to a working function. Instead of select * from table, I'd like to select * from (select * from table where height>1500) as sub, something that works in other functions I ...
1
vote
1answer
46 views

PgRouting: Target vertex error

I'm trying to make a matrix that shows the cost from a node to the rest of the nodes in a network. The final result I'm looking for is not the cost, but only know if a car can or can not reach each ...
2
votes
1answer
98 views

ST_Union based on attribute

I have a road network of center lines of MultiLinestrings.They have nodes at every intersection. I try to understand how I can merge roads together that have the same category as attribute (There are ...
0
votes
1answer
46 views

Querying a raster per pixel using a secondary raster as a condition

So here's the problem. I have two rasters containing bathymetry data: one containing the bathymetry of the sea floor, we'll call this raster1, and another containing the difference between two ...
1
vote
1answer
107 views

CartoDB (PostGIS) near function (distance) points to polygons

I have a CartoDB map here: Link: https://dms2203.cartodb.com/viz/78db6c02-3148-11e5-a42f-0e018d66dc29/public_map I'm trying to find the distance of the points to the polygon. If the points are ...
1
vote
0answers
445 views

SQL-query should return GeoJSON FeatureCollection

I'm trying to return a GeoJSON FeatureCollection object from a SQL-query with PostgreSQL 9.3 and PostGIS 2.1. This is my query so far: SELECT row_to_json(fc) AS p FROM (SELECT 'FeatureCollection' ...
0
votes
1answer
118 views

What command to use in PostGIS to get same result as ArcGIS?

I have two shapefiles and i'm trying to do simple spatial analysis. When I want to know which polygon belongs to other polygon in other shapefile I always use select by location and in Spatial ...