Latest Contributions by DarrenWiens2

Can't you multiply population by proportion of continuous service to get number of people per pixel with continuous service? ... View more

As you have it now, you are only passing one field into the cursor - "COUNTY". This means that list of values in row only has one item - the county. row[0] would equal the county for that record. Change "COUNTY" to whatever the field you want to update is called. Then, it will be row[0]. ... View more

I'll just say, "no", but I'm not really one to spend much time looking for standard ways to do things. I spend all day looking at maps, so if I don't know "the standard way to symbolize" something, how would a general map reader know? Do something that makes sense to you. Show it to someone else. Does it make sense to them? If so, it's probably just fine. With that said, there just may be a stickler out there that knows how you're "supposed" to do this. ... View more

Can you provide an example of how this might be ambiguous? I'm looking around my office at several maps that cut off some jurisdiction part way. For example, a map of Canada that cuts off the US about halfway. There is no label stating, "This straight line is the bottom of the map. The US actually continues farther south." I guess they are just hoping that the map reader has the sense to know that the world doesn't end at the bottom of the map. ... View more

Both logic and formatting are available for labels. Logic: Label Expressions​ Formatting: Formatting Tags​ ... View more

Not sure how this differs from the previous suggestions, except you're glazing over the non-trivial point of populating the attribute based on the value of another attribute. Are you suggesting to do 13 selection/calculate field operations? ... View more

You need to get your query into the format: "Datefield" = date 'yyyy-mm-dd hh:mm:ss' Use strftime() to format the datetime object. The following works for a shapefile, which doesn't support time, but you can generally use this pattern: >>> report_time = datetime.datetime.now() ... SQL = '"OBSDATE" <= date \'' + str(report_time.strftime('%Y-%M-%d')) + '\'' ... print SQL ... arcpy.SelectLayerByAttribute_management("MY_LAYER","NEW_SELECTION", SQL) ... "OBSDATE" <= date '2016-05-26' ... View more

Try: -97 if !PRCHSCH13! == -99 and !PRCHSCH04! <> -99 else -98 if !PRCHSCH13! <> -99 and !PRCHSCH04! == -99 else -99 if !PRCHSCH13! == -99 and !PRCHSCH04! == -99 else float( !PRCHSCH13! ) - !PRCHSCH04! I'll just say this type of thing is somewhat frowned upon as being difficult to read. ... View more

Yes, this results in exactly the same output table: >>> inTable = r"c:\junk\Book3.csv" ... outLocation = r"c:\junk" ... outTable = "test.dbf" ... arcpy.TableToTable_conversion(inTable, outLocation, outTable) If I change the csv to include a decimal (e.g. 750050.00001), then it gets read as Double, which will display decimal places. Using the field map, I can force it back to Long (no more decimal places). The code via Copy As Python Snippet changes to: arcpy.TableToTable_conversion(in_rows="c:/junk/Book3.csv",out_path="c:/junk",out_name="test.dbf",where_clause="#",field_mapping="""X "X" true true false 4 Long 0 0 ,First,#,c:/junk/Book3.csv,X,-1,-1;Y "Y" true true false 8 Long 0 0 ,First,#,c:/junk/Book3.csv,Y,-1,-1;START_DTTM "START_DTTM" true true false 8 Date 0 0 ,First,#,c:/junk/Book3.csv,START_DTTM,-1,-1;END_DTTM "END_DTTM" true true false 8 Date 0 0 ,First,#,c:/junk/Book3.csv,END_DTTM,-1,-1;Value "Value" true true false 8 Double 0 0 ,First,#,c:/junk/Book3.csv,Value,-1,-1""",config_keyword="#") ... View more

Hmmm. That works for me. Can you get it to work properly through the GUI dialog? Do both X and Y come in as Long? ... View more

Can you post an example of your data? This has got to be a simple fix. ... View more

I believe you'd have to use the Field Mapping parameter of TableToTable (which uses FieldMap and FieldMappings objects) to force the values into a field of LONG datatype. Tip: set up the field mapping in the GUI tool, run it, then "Copy As Python Snippet" through the Results window to get the syntax correct. ... View more

Here's a Python script that should emulate your manual editing task using geometry objects, in place, and Basic licensing. Caveats: I have no idea if this works for versioned data. This is a n^2 operation, meaning for each feature in the original dataset, it does something for each feature in the new dataset. This may be problematic for large datasets. >>> main = 'main' # main dataset ... new = 'new' # new dataset ... with arcpy.da.UpdateCursor(main,'SHAPE@') as uCursor: ...    for uRow in uCursor: # loop through main polygons ...        with arcpy.da.SearchCursor(new,'SHAPE@') as sCursor: ...            for sRow in sCursor: # loop through new polygons ...                uRow[0] = uRow[0].difference(sRow[0]) # remove overlaps between main/new ...                uCursor.updateRow(uRow) # update main polygons minus new polygons ... arcpy.Append_management([new],'main',"NO_TEST") # append new polygons to main Original (no overlaps): With new shapefile overlain: Delete 'differences' (no overlaps, voids for new features): Append new to main (no overlaps): ... View more

Good to know. I can't say I've ever run into that situation (e.g. r'\'), but the lengthy and pointed discussion certainly makes me think it comes up more often than my brief experience. ... View more