Latest Contributions by StudentFernie

I am looking to bounce some ideas off some heads to help build an interesting flood plain mapping model for the municipality I work for.   So here is what I have:   1. The city has one environment Canada water level gauge in the Elk River (the river that runs through town). Essentially the engineers can look at this meters website and get updated information on the rivers water level in that location every 15 minutes.    2. I have access to tons of classified Li-DAR data we had flown this year.    Essentially what I want to create out of these two things is a model that changes the extent of the overall water levels around the city when the the meter level changes. I've made simple flood plane analysis models but would like to make this a model that updates itself and can give the engineers an indication of what areas to check at what levels.    I'm open to all your great comments and constructive criticism. If you have a better thought on how to do this sort of thing id love to hear that too!    Cheers! ... View more

I am looking to bounce some ideas off some heads to help build an interesting flood plain mapping model for the municipality I work for. So here is what I have: 1. The city has one environment Canada water level gauge in the Elk River (the river that runs through town). Essentially the engineers can look at this meters website and get updated information on the rivers water level in that location every 15 minutes.  2. I have access to tons of classified Li-DAR data we had flown this year.  Essentially what I want to create out of these two things is a model that changes the extent of the overall water levels around the city when the the meter level changes. I've made simple flood plane analysis models but would like to make this a model that updates itself and can give the engineers an indication of what areas to check at what levels.  I'm open to all your great comments and constructive criticism. If you have a better thought on how to do this sort of thing id love to hear that too!  Cheers! ... View more

Basically i want to find duplicate records from my attribute tables in my mxd not my data base because my mxd. has several definition query's i would like to preserve. I am essentially trying to script this query   [FIELD_NAME] In (SELECT [FIELD_NAME] FROM [TABLE_NAME] GROUP BY [FIELD_NAME] HAVING Count(*)>1 ) Any tips as to why this wont cooperate? I either get a cannot combine string and layer objects error or an invalid query error because it says my layer does not exist because it wont find the table related to my mxd.  Cheers,   # Set workspace environments. Workspace must be a connection file to an ADMIN (sde) connection arcpy.env.workspace = r"\\fs\GIS\admin\temp_connect_files\COF_temp.sde" arcpy.env.overwriteOutput = True print "workspace environment connected" # Set workspace variable workspace = arcpy.env.workspace # Local variables: mxd = arcpy.mapping.MapDocument(r"P:\Joey_Plessis\service_cards\pdf_map_automation_script\DEFAULT_bc_one_call.mxd") df = arcpy.mapping.ListDataFrames(mxd,"*")[0] #DONT WORRY ABOUT THIS PART layer = arcpy.mapping.ListLayers(mxd, raw_input("enter layer name"), df)[0] field = raw_input("enter field name") print layer print field where = field +" " + "In" + " " + "(SELECT" +" "+ field + " "+ "FROM" +" " + "layer" + " "+ "GROUP BY" +" " + field +" "+ "HAVING Count(*)>1 )" print where arcpy.SelectLayerByAttribute_management(layer, "NEW_SELECTION" ,where) ... View more