Tag Info

New answers tagged

0

I would suggest you avoid procedures that are documented as being "legacy" when working with new databases. Cross-database queries in SQL-Server are inefficient, and should be avoided as general practice, but if you really want to create such a view, the table should have a native geometry type (GEOMETRY or GEOGRAPHY). Then all you need to do is register ...


1

You could use regular expressions to do this: regexp_match( "NRN",'(\\b|_)(1|2|23|31)(\\b|_)') This will match either a "1", "2", "23" or "31" which is surrounded by "word boundaries" ( \b") or underscores. (A word boundary is either the start or end of the string, or certain whitespace characters). New numbers to match can be inserted into the ...


0

If you change the NRN field from 20_21 to _20_21_ then you can use "NRN" LIKE '%_21_%' to find all features which contain the number 21.


3

Here is a piece of code based on @artwork21's proposed workflow. It uses arcpy.da cursors so you need to have at least a 10.1 license. I've assumed the fields have the following format: height: numeric area_id: numeric or text (see comments in code) highest: numeric (short) import arcpy points = r"D:\test.gdb\points" ## make a list of unique area_id ...


0

I don't know of a way to express this in an SQL-style query within ArcGIS. Aside from the distance matrix, a brute-force approach would be to loop through each pharmacy, perform a select-by-location for hospitals within the search tolerance, and add a flag to the pharmacy and/or hospital(s) if any hospitals are found.


3

I would recommend to use python for this, the general code flow would go something like this: Use arcpy.da.search cursor to iterate through AREAid column Nest another arcpy.da.search cursor (with sql expression of AREAid value to filter by) to get HEIGHT values and use a max() method on the cursor to get max value (e.g. highValue = max(cursor)) Within ...


0

Two things I would try: Simply export the selection for your query and turn on labeling. So your SQL query would be something like (_Seq1_TractDepthSequence = 1 AND [_Seq1_DeckCorpRITot] <> 0) OR (_Seq1_TractDepthSequence = 1 AND [_Seq1_DeckCorpORRITot] <> 0) ...etc Then export the selection. Your new layer will only contain those that are ...


0

I found a way to get it to work! It only provides the label string if the query is true. Function FindLabel ( [_Seq1_DeckCorpRITot], [_Seq1_DeckCorpIntTot] ) strExp1 = [_Seq1_DeckCorpRITot] &" RI" strExp2 = [_Seq1_DeckCorpIntTot] &" CorpInt" if ([_Seq1_DeckCorpRITot] <> 0) then strExp = strExp1 if ([_Seq1_DeckCorpIntTot] <> ...


1

The reason your code was failing was you had multiple "if" statements without an "end if" for each of them. It looks like you wanted "elseif" for the second, third, and fourth checks. Function FindLabel ( [_Seq1_TractDepthSequence], [_Seq1_BegInterval] ,[_Seq1_EndInterval], [_Seq1_DeckCorpRITot], [_Seq1_DeckCorpORRITot] , [_Seq1_DeckCorpIntTot] , ...


0

I can think of several ways to do this, but maybe the simplest is to just build the label with all values, 0 included, then replace the 0's with empty spaces. Although honestly your function doesn't look like it's doing what you state. It looks like you're passing in seven fields, not four. Not as familiar with VBScript as I used to be, but you could try ...


1

Use "LIKE" with percentages. In my shapefile of countries I can select any country with a name like "This and that" with: "CNTRY_NAME" LIKE '% and %' this selects only "Bosnia and Herzegovina". If I remove the spaces: "CNTRY_NAME" LIKE '%and%' I get Iceland, England and all the others with "and" in them. That all works for shapefiles - the help for ...


0

AFAIK there is currently no API that offers such operator. You can use planet dumps and process it on your own by testing each POI node (or each building way) for checking the boundaries. Due to the amount of data, this can be pretty timeconsuming.



Top 50 recent answers are included