Vjylku

Forgetting the musical notes while performing in concert

What is required to make GPS signals available indoors?

Finitely generated matrix groups whose eigenvalues are all algebraic

Is it "common practice in Fourier transform spectroscopy to multiply the measured interferogram by an apodizing function"? If so, why?

Can a virus destroy the BIOS of a modern computer?

Avoiding the "not like other girls" trope?

Does the Idaho Potato Commission associate potato skins with healthy eating?

What are the G forces leaving Earth orbit?

Did 'Cinema Songs' exist during Hiranyakshipu's time?

Car headlights in a world without electricity

What's the meaning of "Sollensaussagen"?

Where would I need my direct neural interface to be implanted?

In Bayesian inference, why are some terms dropped from the posterior predictive?

What is the opposite of "eschatology"?

What Exploit Are These User Agents Trying to Use?

What do you call someone who asks many questions?

Why was the shrink from 8″ made only to 5.25″ and not smaller (4″ or less)

Do creatures with a speed 0ft., fly 30ft. (hover) ever touch the ground?

Why is the sentence "Das ist eine Nase" correct?

My ex-girlfriend uses my Apple ID to login to her iPad, do I have to give her my Apple ID password to reset it?

How do conventional missiles fly?

Machine learning testing data

How to travel to Japan while expressing milk?

Convert seconds to minutes

Selecting just the first row from a search cursor

Search cursor stops selecting after two iterationsUsing arcpy.da.InsertCursor to insert entire row that is fetched from search cursor?Insert cursor for first row in unique value set arcpyOutput the Search Cursor as a stringCursor update row operatorUsing Search/Update Cursor?Stratified random point sampling in PythonComparing value with value from the next rowDeleting row using ArcPy cursor?Switching from Nested Search Cursors to Dictionaries

0

Currently I am trying to select the top row of a feature class which is sorted using a Count field. I then would like to run the script a second time but the result will then be the second row of the table. I currently have the script below.

#import arcpy module

import arcpy

from arcpy import env



env.workspace = "D:\Trimble.gdb"



#allow overwrites

arcpy.env.overwriteOutput = True



#print list of feature classes

featList = arcpy.ListFeatureClasses()

print featList



#cheack if Messages and Township spatial join has been made

for feat in featList:

    if arcpy.Exists("TWP_Messages"):

        print "Township and Messages Without Roads joined already"

        print ""

        break

    else:

        #create spatial join between Messages and Townships

        target_features = "D:\Trimble.gdb\TWP"

        join_features = "D:\Trimble.gdb\Messages"

        out_feature = "D:\Trimble.gdb\TWP_Messages"

        arcpy.SpatialJoin_analysis(target_features, join_features, out_feature)



        #sort Join_Count field by Descending

        arcpy.Sort_management("TWP_Messages", "TWP_Messages_Sort",     [["Count_", "DESCENDING"]])

        print arcpy.GetMessage(2)

        messageSort = "D:\Trimble.gdb\TWP_Messages_Sort"



        #add field to messages sort feature to describe if item has been deleted already

        arcpy.AddField_management(messageSort, "Downloaded", "TEXT")

        #update all Downloaded fields to No

        with arcpy.da.UpdateCursor(messageSort, "Downloaded") as cursor:

            for row in cursor:

                row[0] = "No"

                cursor.updateRow(row)

        del row

        del cursor



messageSorted = "D:\Trimble.gdb\TWP_Messages_Sort"

i = 0

with arcpy.da.SearchCursor(messageSorted, ["DESCRIPTOR", "Count_"]) as cursor:

    for row in cursor:

        if row[1] != i:

            print("Descriptor: {}    Count: {}".format(row[0], row[1]))

            i = row[1]

            name = row[0]

            with arcpy.da.UpdateCursor(messageSorted, ["Count_", "Downloaded"]) as curs:

                for line in curs:

                    if line[0] == i:

                        line[1] = "Yes"

                        curs.updateRow(line)

            break



print name

Currently it is rewriting the fields it updates (Downloaded) every time and does not remember where it left off. Obviously the break is causing a problem here too.

I thought about making a table that updates each item that has previously been selected so then the search could check there and continue on to the next needed row. Unsure how to implement that too.

I appreciate any help you're able to give.

arcpy

share

asked 6 mins ago

BenjamBenjam

155

add a comment | 

0

Currently I am trying to select the top row of a feature class which is sorted using a Count field. I then would like to run the script a second time but the result will then be the second row of the table. I currently have the script below.

#import arcpy module

import arcpy

from arcpy import env



env.workspace = "D:\Trimble.gdb"



#allow overwrites

arcpy.env.overwriteOutput = True



#print list of feature classes

featList = arcpy.ListFeatureClasses()

print featList



#cheack if Messages and Township spatial join has been made

for feat in featList:

    if arcpy.Exists("TWP_Messages"):

        print "Township and Messages Without Roads joined already"

        print ""

        break

    else:

        #create spatial join between Messages and Townships

        target_features = "D:\Trimble.gdb\TWP"

        join_features = "D:\Trimble.gdb\Messages"

        out_feature = "D:\Trimble.gdb\TWP_Messages"

        arcpy.SpatialJoin_analysis(target_features, join_features, out_feature)



        #sort Join_Count field by Descending

        arcpy.Sort_management("TWP_Messages", "TWP_Messages_Sort",     [["Count_", "DESCENDING"]])

        print arcpy.GetMessage(2)

        messageSort = "D:\Trimble.gdb\TWP_Messages_Sort"



        #add field to messages sort feature to describe if item has been deleted already

        arcpy.AddField_management(messageSort, "Downloaded", "TEXT")

        #update all Downloaded fields to No

        with arcpy.da.UpdateCursor(messageSort, "Downloaded") as cursor:

            for row in cursor:

                row[0] = "No"

                cursor.updateRow(row)

        del row

        del cursor



messageSorted = "D:\Trimble.gdb\TWP_Messages_Sort"

i = 0

with arcpy.da.SearchCursor(messageSorted, ["DESCRIPTOR", "Count_"]) as cursor:

    for row in cursor:

        if row[1] != i:

            print("Descriptor: {}    Count: {}".format(row[0], row[1]))

            i = row[1]

            name = row[0]

            with arcpy.da.UpdateCursor(messageSorted, ["Count_", "Downloaded"]) as curs:

                for line in curs:

                    if line[0] == i:

                        line[1] = "Yes"

                        curs.updateRow(line)

            break



print name

Currently it is rewriting the fields it updates (Downloaded) every time and does not remember where it left off. Obviously the break is causing a problem here too.

I thought about making a table that updates each item that has previously been selected so then the search could check there and continue on to the next needed row. Unsure how to implement that too.

I appreciate any help you're able to give.

arcpy

share

asked 6 mins ago

BenjamBenjam

155

add a comment | 

Currently I am trying to select the top row of a feature class which is sorted using a Count field. I then would like to run the script a second time but the result will then be the second row of the table. I currently have the script below.

#import arcpy module

import arcpy

from arcpy import env



env.workspace = "D:\Trimble.gdb"



#allow overwrites

arcpy.env.overwriteOutput = True



#print list of feature classes

featList = arcpy.ListFeatureClasses()

print featList



#cheack if Messages and Township spatial join has been made

for feat in featList:

    if arcpy.Exists("TWP_Messages"):

        print "Township and Messages Without Roads joined already"

        print ""

        break

    else:

        #create spatial join between Messages and Townships

        target_features = "D:\Trimble.gdb\TWP"

        join_features = "D:\Trimble.gdb\Messages"

        out_feature = "D:\Trimble.gdb\TWP_Messages"

        arcpy.SpatialJoin_analysis(target_features, join_features, out_feature)



        #sort Join_Count field by Descending

        arcpy.Sort_management("TWP_Messages", "TWP_Messages_Sort",     [["Count_", "DESCENDING"]])

        print arcpy.GetMessage(2)

        messageSort = "D:\Trimble.gdb\TWP_Messages_Sort"



        #add field to messages sort feature to describe if item has been deleted already

        arcpy.AddField_management(messageSort, "Downloaded", "TEXT")

        #update all Downloaded fields to No

        with arcpy.da.UpdateCursor(messageSort, "Downloaded") as cursor:

            for row in cursor:

                row[0] = "No"

                cursor.updateRow(row)

        del row

        del cursor



messageSorted = "D:\Trimble.gdb\TWP_Messages_Sort"

i = 0

with arcpy.da.SearchCursor(messageSorted, ["DESCRIPTOR", "Count_"]) as cursor:

    for row in cursor:

        if row[1] != i:

            print("Descriptor: {}    Count: {}".format(row[0], row[1]))

            i = row[1]

            name = row[0]

            with arcpy.da.UpdateCursor(messageSorted, ["Count_", "Downloaded"]) as curs:

                for line in curs:

                    if line[0] == i:

                        line[1] = "Yes"

                        curs.updateRow(line)

            break



print name

Currently it is rewriting the fields it updates (Downloaded) every time and does not remember where it left off. Obviously the break is causing a problem here too.

I thought about making a table that updates each item that has previously been selected so then the search could check there and continue on to the next needed row. Unsure how to implement that too.

I appreciate any help you're able to give.

arcpy

share

asked 6 mins ago

BenjamBenjam

155

#import arcpy module

import arcpy

from arcpy import env



env.workspace = "D:\Trimble.gdb"



#allow overwrites

arcpy.env.overwriteOutput = True



#print list of feature classes

featList = arcpy.ListFeatureClasses()

print featList



#cheack if Messages and Township spatial join has been made

for feat in featList:

    if arcpy.Exists("TWP_Messages"):

        print "Township and Messages Without Roads joined already"

        print ""

        break

    else:

        #create spatial join between Messages and Townships

        target_features = "D:\Trimble.gdb\TWP"

        join_features = "D:\Trimble.gdb\Messages"

        out_feature = "D:\Trimble.gdb\TWP_Messages"

        arcpy.SpatialJoin_analysis(target_features, join_features, out_feature)



        #sort Join_Count field by Descending

        arcpy.Sort_management("TWP_Messages", "TWP_Messages_Sort",     [["Count_", "DESCENDING"]])

        print arcpy.GetMessage(2)

        messageSort = "D:\Trimble.gdb\TWP_Messages_Sort"



        #add field to messages sort feature to describe if item has been deleted already

        arcpy.AddField_management(messageSort, "Downloaded", "TEXT")

        #update all Downloaded fields to No

        with arcpy.da.UpdateCursor(messageSort, "Downloaded") as cursor:

            for row in cursor:

                row[0] = "No"

                cursor.updateRow(row)

        del row

        del cursor



messageSorted = "D:\Trimble.gdb\TWP_Messages_Sort"

i = 0

with arcpy.da.SearchCursor(messageSorted, ["DESCRIPTOR", "Count_"]) as cursor:

    for row in cursor:

        if row[1] != i:

            print("Descriptor: {}    Count: {}".format(row[0], row[1]))

            i = row[1]

            name = row[0]

            with arcpy.da.UpdateCursor(messageSorted, ["Count_", "Downloaded"]) as curs:

                for line in curs:

                    if line[0] == i:

                        line[1] = "Yes"

                        curs.updateRow(line)

            break



print name

share

asked 6 mins ago

BenjamBenjam

155

share

asked 6 mins ago

BenjamBenjam

155

asked 6 mins ago

BenjamBenjam

155

asked 6 mins ago

BenjamBenjam

155