Tag Info

Hot answers tagged

4

I'm having difficulty with the classification of "search by attribute" as a "language". To understand an answer to this startlingly broad question requires understanding of the meanings of a number of computer terms, including: Application software, programming language, data format, user interface, and access paradigm. ArcGIS is application software. It ...


2

Actually, grid size zero is usually an indicator to ArcGIS to wait until after initial loading to determine the spatial index. In best practice, you shouldn't build an index until after the data is loaded -- it can significantly impact load performance to populate a large table with an index enabled. By the time loading is complete, you will know an ...


2

I always encourage to use field delimiters to access the fields in a right way: field_name = "UNIQUEID" input_value = 5 sql_exp = """{0} = {1}""".format(arcpy.AddFieldDelimiters('c:/data/file_gdb.gdb', field_name),input_value) print sql_exp >>> 'UNIQUEID=5' Another way to do this is to use the str.format(): sql_exp = """{0} = ...


1

I have an example here that uses window.open: You can enable the description column in your infowindows in order to retrieve the data from there and avoid the SQL query. layer.on('featureClick', function(e, pos, latlng, data) { cartodb.log.log(e, pos, latlng, data); window.open(data.url); });


1

You can use the following query to union the geometry, find all nodes and split the lines: SELECT row_number() OVER() new_id, geom FROM (SELECT (ST_Dump(ST_Node(ST_Union(the_geom)))).geom geom FROM multilines) a Then you must play a little bit to retrieve the original attributes by joining the previous table on "contains" or "within".


1

I see what you are asking for. Unfortunately the MapInfo SQL syntax doesn't support "tableA.*". You can only select all columns from both tables or specific columns. I see three workarounds Select all columns and then modify the table structure afterwards where you can remove the extra columns you don't want If your table structure is somewhat static, you ...


1

The problem here is you are converted the FID (objectID field type) value to string which should be a numeric value within the expression, try this: with arcpy.da.UpdateCursor('Sales_lyr', ["BOROUGH", "FID", "COUNT"]) as cursor: for row in cursor: expression = '"FID" = {}'.format(row[1]) ...


1

This is because Geography is designed to handle coordinates in degrees (lat/long) and "knows" how to convert these into metres for your STDistance method. Geometry, however, assumes you are on a flat plane and therefore treats your map units as simple distances - so you are asking for all points within 5000 degrees of the centre and since that exceeds the ...


1

Let's say you have a list of shapefiles and the field name for the attribute is the same in each shapefile. That means you can make the SQL query in the beginning of the script, so the first bit could look like this: search_id = arcpy.GetParameterAsText(0) shps = [r"path\to\shp1.shp",r"path\to\shp2.shp"] output_shp = r"path\to\output.shp" field = ...


1

You could try in the first instance the Metadata Data Model published by the British Geological Survey. http://www.earthdatamodels.org/designs/metadata_BGS.html This is really related to ISO 19115 metadata, which you mention in your tag. ISO 19119 only adds a little to the data model, that is, to hold all the metadata about your service you will need ISO ...


1

According to all of the documentation provided by the vendor, the following SQL features are supported using a subquery: IN GROUP BY MAX The query that should by all means work would then be: count in ( select max(count) from table group by id ) In 'pure' SQL (as some would put it), you would see this as: create table temp ( id ...



Only top voted, non community-wiki answers of a minimum length are eligible