20210313 11573100 1.0 FALSE CalculateField sde_vector.ARCADMIN.RP_Addresspt_New CITY "KIRKLAND" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt_New STATE "WA" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt_New LABEL_FLAG "BLDG" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt_New ADDR_TYPE "M" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt_New ADDR_TYPE "B" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt_New ADDR_TYPE "S" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt_New LABEL_FLAG "MAIN" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt_New LABEL_FLAG "STRUCTURE" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt_New ADDR_TYPE NULL VB # Append add_append_testdb sde_vector.ARCADMIN.RP_Addresspt_New NO_TEST "ADDR_ID "ADDR_ID" true true false 8 Double 8 38 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,REFPOINT_I,-1,-1;FULL_ADDRESS "FULL_ADDRESS" true true false 80 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,FULL_ADD,-1,-1;PIN "PIN" true true false 10 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,PIN,-1,-1;PARCEL_NUM "PARCEL_NUM" true true false 10 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,PARCEL_NUM,-1,-1;ADU "ADU" true true false 1 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,ADU,-1,-1;ADDR_NUM "ADDR_NUM" true true false 10 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,PRIM_NUM,-1,-1;FRACTION "FRACTION" true true false 4 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,FRACTION,-1,-1;UNIT_TYPE "UNIT_TYPE" true true false 5 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,UNIT_TYPE,-1,-1;UNIT_NUM "UNIT_NUM" true true false 10 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,UNIT_NUM,-1,-1;BLDG_NUM "BLDG_NUM" true true false 10 Text 0 0 ,First,#;PREFIX "PREFIX" true true false 2 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,PREFIX,-1,-1;STR_NAME "STR_NAME" true true false 30 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,NAME,-1,-1;STR_TYPE "STR_TYPE" true true false 4 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,TYPE,-1,-1;SUFFIX "SUFFIX" true true false 2 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,SUFFIX,-1,-1;ADDR_TYPE "ADDR_TYPE" true true false 20 Text 0 0 ,First,#;MAIL_FLAG "MAIL_FLAG" true true false 1 Text 0 0 ,First,#;RNAME "RNAME" true true false 10 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,RNAME,-1,-1;CITY "CITY" true true false 15 Text 0 0 ,First,#;STATE "STATE" true true false 2 Text 0 0 ,First,#;ZIPCODE "ZIPCODE" true true false 10 Text 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,ZIPCODE,-1,-1;XCOORD "XCOORD" true true false 8 Double 8 38 ,First,#;YCOORD "YCOORD" true true false 8 Double 8 38 ,First,#;LABEL_FLAG "LABEL_FLAG" true true false 10 Text 0 0 ,First,#;EDIT_DATE "EDIT_DATE" true true false 36 Date 0 0 ,First,#,M:\IT\Work\KPS\DatabaseSchemaChange2010\NorcomData\AA_streets2.gdb\add_append_testdb,EDIT_DATE,-1,-1" # Append RP_Addresspt_Annex sde_vector.ARCADMIN.RP_Addresspt_New NO_TEST "ADDR_ID "ADDR_ID" true true false 8 Double 8 38 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,ADDR_ID,-1,-1;FULL_ADDRESS "FULL_ADDRESS" true true false 80 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,FULL_ADDRESS,-1,-1;PIN "PIN" true true false 10 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,PIN,-1,-1;PARCEL_NUM "PARCEL_NUM" true true false 10 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,PARCEL_NUM,-1,-1;ADU "ADU" true true false 1 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,ADU,-1,-1;ADDR_NUM "ADDR_NUM" true true false 10 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,ADDR_NUM,-1,-1;FRACTION "FRACTION" true true false 4 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,FRACTION,-1,-1;UNIT_TYPE "UNIT_TYPE" true true false 5 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,UNIT_TYPE,-1,-1;UNIT_NUM "UNIT_NUM" true true false 10 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,UNIT_NUM,-1,-1;BLDG_NUM "BLDG_NUM" true true false 10 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,BLDG_NUM,-1,-1;PREFIX "PREFIX" true true false 2 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,PREFIX,-1,-1;STR_NAME "STR_NAME" true true false 30 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,STR_NAME,-1,-1;STR_TYPE "STR_TYPE" true true false 4 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,STR_TYPE,-1,-1;SUFFIX "SUFFIX" true true false 2 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,SUFFIX,-1,-1;ADDR_TYPE "ADDR_TYPE" true true false 20 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,ADDR_TYPE,-1,-1;MAIL_FLAG "MAIL_FLAG" true true false 1 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,MAIL_FLAG,-1,-1;RNAME "RNAME" true true false 10 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,RNAME,-1,-1;CITY "CITY" true true false 15 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,CITY,-1,-1;STATE "STATE" true true false 2 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,STATE,-1,-1;ZIPCODE "ZIPCODE" true true false 10 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,ZIPCODE,-1,-1;XCOORD "XCOORD" true true false 8 Double 8 38 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,XCOORD,-1,-1;YCOORD "YCOORD" true true false 8 Double 8 38 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,YCOORD,-1,-1;LABEL_FLAG "LABEL_FLAG" true true false 10 Text 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,LABEL_FLAG,-1,-1;EDIT_DATE "EDIT_DATE" true true false 36 Date 0 0 ,First,#,Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt_Annex,EDIT_DATE,-1,-1" # ChangePrivileges 'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Addresspt';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_BldgConcernAreas';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_BldgFootprint';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_BusAddresspt';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_CityLimits';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_CityPoly';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_CommonPlaces';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_Easements';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_row';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_SurveyControl';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_SurveyControlAnno';'Database Connections\arcadmin@sde_vector@srv-gist01.sde\sde_vector.ARCADMIN.RP_tax_parcel' gisuser GRANT # ChangePrivileges 'Database Connections\arcadmin@sde_vector@srv-gisdb01.sde\sde_vector.ARCADMIN.RP_Addresspt';'Database Connections\arcadmin@sde_vector@srv-gisdb01.sde\sde_vector.ARCADMIN.RP_BldgConcernAreas' st_editor GRANT GRANT CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_TYPE "[ADDR_TYPE] = "M"" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt EDIT_DATE DATE() VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADU "N" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0 \ndef autoIncrement(): \n global rec \n pStart = 42256 \n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec\n\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0 \ndef autoIncrement(): \n global rec \n pStart = 1 \n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec\n\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement(): \n global rec \n pStart = 1\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "def autoIncrement(): \n global rec \n pStart = 1\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "def autoIncrement(): \n global rec \n pStart = 42256\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec = 0\ndef autoIncrement(): \n global rec \n pStart = 1\n pInterval = 1 \n if (rec == 0): \n rec = pStart \n else: \n rec += pInterval \n return rec" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42256 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=42256\ndef autoIncrement():\n global rec\n pStart = 1 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 1 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 PYTHON_9.3 # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42256 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42256 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt PARCEL_NUM 111 PYTHON_9.3 # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 PYTHON_9.3 # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 1 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42256 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42257 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42257 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt PIN [ADDR_ID] VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42257 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt RNAME "111" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PIN 0 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID [PARCEL_NUM] VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt RNAME "11" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ZIPCODE "98034" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ZIPCODE "98011" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "UNIT & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM ""UNIT " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE " " VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM " " VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_NUM] & " " & [BLDG_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [BLDG_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE] " VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE] " VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "[UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ZIPCODE 98011 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ZIPCODE 98011 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42532 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt SUFFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42559 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42573 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42581 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42595\n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42595 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID 0 VB # CalculateField "RP_Addresspt (edit layer)" CITY "KIRKLAND" VB # CalculateField Edit_RP_Addresspt FULL_ADDRESS "replace ( [FULL_ADDRESS], " PL ", " CT ")" VB # CalculateField Edit_RP_Addresspt FULL_ADDRESS "replace ( [FULL_ADDRESS], " PL ", " CT ")" VB # CalculateField Edit_RP_Addresspt EDIT_DATE DATE() VB # CalculateField Edit_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42624 \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Edit_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42625\n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Edit_RP_Addresspt ADDR_NUM 12724 VB # CalculateField Edit_RP_Addresspt ADDR_NUM 12728 VB # CalculateField Edit_RP_Addresspt EDIT_DATE date() VB # CalculateField Edit_RP_Addresspt EDIT_DATE DATE() VB # CalculateField Edit_RP_Addresspt UNIT_TYPE "UNIT" VB # CalculateField Edit_RP_Addresspt EDIT_DATE DATE() VB # CalculateField Edit_RP_Addresspt FULL_ADDRESS "[FULL_ADDRESS] & ", UNIT " & [UNIT_NUM]" VB # CalculateField Edit_RP_Addresspt STR_NAME "137TH" VB # CalculateField Edit_RP_Addresspt EDIT_DATE DATE() VB # CalculateField Edit_RP_Addresspt FULL_ADDRESS "REPLACE ( [FULL_ADDRESS], "37TH", "137TH")" VB # CalculateField Edit_RP_Addresspt FRACTION "" VB # CalculateField Edit_RP_Addresspt UNIT_TYPE "" VB # CalculateField Edit_RP_Addresspt UNIT_NUM "" VB # CalculateField Edit_RP_Addresspt BLDG_NUM "" VB # CalculateField Edit_RP_Addresspt FRACTION "" VB # CalculateField Edit_RP_Addresspt PREFIX "" VB # CalculateField Edit_RP_Addresspt SUFFIX "" VB # CalculateField Edit_RP_Addresspt PREFIX "" VB # CalculateField Edit_RP_Addresspt SUFFIX "" VB # CalculateField Edit_RP_Addresspt FRACTION "" VB # CalculateField Edit_RP_Addresspt UNIT_TYPE "" VB # CalculateField Edit_RP_Addresspt UNIT_NUM "" VB # CalculateField Edit_RP_Addresspt BLDG_NUM "" VB # CalculateField Edit_RP_Addresspt SUFFIX "" VB # CalculateField Edit_RP_Addresspt FRACTION "" VB # CalculateField Edit_RP_Addresspt UNIT_TYPE "" VB # CalculateField Edit_RP_Addresspt UNIT_NUM "" VB # CalculateField Edit_RP_Addresspt BLDG_NUM "" VB # CalculateField Edit_RP_Addresspt SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt CITY "KIRKLAND" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt SUFFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_NUM "501" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt EDIT_DATE "DATE ()" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt CITY "KIRKLAND" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt CITY "KIRKLAND" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt RNAME "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt RNAME "BUSINESS" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PARCEL_NUM "4147700000" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42714 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec" CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42715 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec" CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" RNAME "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42752 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" PYTHON_9.3 # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42764 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" ADDR_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" LABEL_FLAG "" VB # CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42775 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42790 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42818#adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "EDIT (RP_Addresspt)" SUFFIX "" VB # CalculateField "EDIT (RP_Addresspt)" EDIT_DATE "date ()" VB # CalculateField "EDIT (RP_Addresspt)" FULL_ADDRESS !FULL_ADDRESS!.replace(" NE", " ") PYTHON_9.3 # CalculateField "EDIT (RP_Addresspt)" FULL_ADDRESS !FULL_ADDRESS!.replace(" NE", " ") PYTHON_9.3 # CalculateField "EDIT (RP_Addresspt)" SUFFIX "" PYTHON_9.3 # CalculateField "EDIT (RP_Addresspt)" SUFFIX "" VB # CalculateField "EDIT (RP_Addresspt)" PREFIX "" VB # CalculateField Edit_RP_Addresspt FRACTION "" VB # CalculateField Edit_RP_Addresspt UNIT_TYPE "" VB # CalculateField Edit_RP_Addresspt UNIT_NUM "" VB # CalculateField Edit_RP_Addresspt BLDG_NUM "" VB # CalculateField Edit_RP_Addresspt PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42828 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PARCEL_NUM [PIN] VB # CalculateField "RP_Addresspt (edit layer)" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42862 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "B" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "A" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PARCEL_NUM "1823600005" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PARCEL_NUM !PARCEL_NUM!.replace("172780", "387647") PYTHON_9.3 # CalculateField sde_vector.ARCADMIN.RP_Addresspt PARCEL_NUM "!PARCEL_NUM!.replace ("172780", "429820")" PYTHON_9.3 # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42878 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt SUFFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt RNAME "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42898 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42906 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt RNAME "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FRACTION "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42916 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt SUFFIX "" VB # CalculateField Edit_RP_Addresspt FRACTION "" VB # CalculateField Edit_RP_Addresspt BLDG_NUM "" VB # CalculateField Edit_RP_Addresspt UNIT_TYPE "" VB # CalculateField Edit_RP_Addresspt UNIT_NUM "" VB # CalculateField Edit_RP_Addresspt PREFIX "" VB # CalculateField Edit_RP_Addresspt SUFFIX "" VB # CalculateField Edit_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 42923 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Edit_RP_Addresspt FRACTION "" VB # CalculateField Edit_RP_Addresspt UNIT_TYPE "" VB # CalculateField Edit_RP_Addresspt UNIT_NUM "" VB # CalculateField Edit_RP_Addresspt BLDG_NUM "" VB # CalculateField Edit_RP_Addresspt PREFIX "" VB # CalculateField Edit_RP_Addresspt SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "E" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "D" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "F" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "J" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "G" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "H" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "F" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "E" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "A" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "D" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "B" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "C" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "A" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "B" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "C" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "D" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "E" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "H" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "G" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "F" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "J" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "K" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-2)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-1)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-3)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (RTrim((Left([UNIT_NUM],Len([UNIT_NUM])-1)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-3)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-3)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-3)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-3)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-2)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-3)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-1)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (RTrim((Left([UNIT_NUM],Len([UNIT_NUM])-1)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])-1)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM (LTrim((Left([UNIT_NUM],Len([UNIT_NUM])+1)))) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM Left( [UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM right([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM RIGHT([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM LEFT([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM LEFT([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM LEFT([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM LEFT([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM LEFT([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM LEFT([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "[BLDG_NUM] &[UNIT_NUM]" VB # CalculateField "RP_Addresspt (edit layer)" FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX] & ", " & [UNIT_NUM]" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM left([UNIT_NUM], 1) VB # CalculateField "RP_Addresspt (edit layer)" RNAME "" VB # CalculateField "RP_Addresspt (edit layer)" RNAME "BUSINESS" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_TYPE "" VB # CalculateField "RP_Addresspt (edit layer)" UNIT_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField "RP_Addresspt (edit layer)" RNAME "" VB # CalculateField "RP_Addresspt (edit layer)" FRACTION "" VB # CalculateField "RP_Addresspt (edit layer)" BLDG_NUM "" VB # CalculateField "RP_Addresspt (edit layer)" PREFIX "" VB # CalculateField "RP_Addresspt (edit layer)" SUFFIX "" VB # CalculateField KSunEditVersion.RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "7A" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43009 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PIN [PARCEL_NUM] VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "Bldg B1" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "BLDG A1" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "A1" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43022#adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "replace ( [FULL_ADDRESS], "38", "138")" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "REPLACE ( [BLDG_NUM], "UNIT ", "")" VB # CalculateField Synch_RP_Addresspt UNIT_NUM [BLDG_NUM] VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "left ( [UNIT_NUM] , 1)" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "RIGHT ( [UNIT_NUM] , 2)" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "[FULL_ADDRESS] & ", UNIT " & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "UNIT" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "REPLACE ( [BLDG_NUM], "UNIT ", "")" VB # CalculateField Synch_RP_Addresspt UNIT_NUM [BLDG_NUM] VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS !FULL_ADDRESS!.replace("-", "") PYTHON_9.3 # CalculateField Synch_RP_Addresspt UNIT_NUM !UNIT_NUM!.replace("-", "") PYTHON_9.3 # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43076 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Synch_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43077 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "!FULL_ADDRESS! .replace("LAKESHORE PLZ", "MARKET ST")" PYTHON_9.3 # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt STR_NAME "" VB # CalculateField Synch_RP_Addresspt STR_TYPE "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "[ADDR_NUM] &" " & [STR_NAME] & " " & [STR_TYPE]& ", " & [UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "[ADDR_NUM] &" " & [STR_NAME] & " " & [STR_TYPE]& ", " & [UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43089 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX] & ", " & [UNIT_TYPE] & " " & [BLDG_NUM] & "-" & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt UNIT_NUM ""CP" & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt RNAME "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] & " " & [STR_TYPE]" VB # CalculateField Synch_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43161 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt RNAME "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM [BLDG_NUM] VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "UNIT ", "")" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM [BLDG_NUM] VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "UNIT ", "")" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_TYPE "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt RNAME "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_TYPE "OTHER POINT" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_TYPE "OTHER POINT" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_TYPE "OTHER POINT" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_TYPE "OTHER POINT" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_TYPE "OTHER POINT" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt ADDR_TYPE "OTHER POINT" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt STR_NAME "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "right ( [UNIT_NUM], 1)" VB # CalculateField Synch_RP_Addresspt PREFIX left( [UNIT_NUM], 1) VB # CalculateField Synch_RP_Addresspt UNIT_NUM "[BLDG_NUM] & [PREFIX]" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX] & ", " & [UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "W" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "E" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "BLDG IV" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "IV" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43209 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "replace ( [FULL_ADDRESS], "UNIT", "SUITE")" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "left ( [BLDG_NUM], 4)" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "right ( [BLDG_NUM], 4)" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_TYPE "right ( [BLDG_NUM], 5)" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM "right ( [BLDG_NUM], 3)" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt BLDG_NUM "" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[FULL_ADDRESS] & ", " & [UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX] & ", " & [UNIT_TYPE] & " " & [BLDG_NUM] & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "[FULL_ADDRESS] & ", " & [UNIT_TYPE] & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS "[FULL_ADDRESS] & ", " & [UNIT_TYPE] & " " & [UNIT_NUM]" VB # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt FULL_ADDRESS !FULL_ADDRESS!.replace("SUITE", "UNIT") PYTHON_9.3 # CalculateField Synch_RP_Addresspt SUFFIX "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt ADDR_TYPE "" VB # CalculateField Synch_RP_Addresspt RNAME "" VB # CalculateField Synch_RP_Addresspt FRACTION "" VB # CalculateField Synch_RP_Addresspt UNIT_TYPE "" VB # CalculateField Synch_RP_Addresspt UNIT_NUM "" VB # CalculateField Synch_RP_Addresspt BLDG_NUM "" VB # CalculateField Synch_RP_Addresspt PREFIX "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "[BLDG_NUM] & [UNIT_NUM]" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" SUFFIX "" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" PREFIX "" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" PREFIX "" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" PREFIX "" VB # CalculateField "Edit production RP_Addresspt" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43268 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" PREFIX "" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" PREFIX "" VB # CalculateField "Edit production RP_Addresspt" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43278 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" PREFIX "" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" SUFFIX "" VB # CalculateField "Edit production RP_Addresspt" FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX] & " " & [STR_NAME] &" " & [STR_TYPE]" VB # CalculateField "Edit production RP_Addresspt" ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43283 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" SUFFIX "" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" PREFIX "" VB # CalculateField "Edit production RP_Addresspt" FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX]" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" PREFIX "" VB # CalculateField "Edit production RP_Addresspt" SUFFIX "" VB # CalculateField "Edit production RP_Addresspt" BLDG_NUM "" VB # CalculateField "Edit production RP_Addresspt" UNIT_NUM "" VB # CalculateField "Edit production RP_Addresspt" UNIT_TYPE "" VB # CalculateField "Edit production RP_Addresspt" FRACTION "" VB # CalculateField KS_Edit.RP_Addresspt FULL_ADDRESS "REPLACE ( [FULL_ADDRESS] ,"108TH", "106TH")" VB # CalculateField KS_Edit.RP_Addresspt EDIT_DATE date() VB # CalculateField KS_Edit.RP_Addresspt FULL_ADDRESS "replace ( [FULL_ADDRESS], "MARKET ST", "1ST ST")" VB # CalculateField KS_Edit.RP_Addresspt STR_NAME "1ST" VB # CalculateField KS_Edit.RP_Addresspt FULL_ADDRESS "[FULL_ADDRESS] & " " & [UNIT_NUM]" VB # CalculateField KS_Edit.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43422 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField KS_Edit.RP_Addresspt FULL_ADDRESS "[FULL_ADDRESS] & ", SUITE " & [UNIT_NUM] " VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "C" VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "A" VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "B" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "A", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "B", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "C", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "D", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "E", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "F", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "G", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "H", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "I", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "J", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "K", "")" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "REPLACE ( [UNIT_NUM], "L", "")" VB # CalculateField KS_Edit.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX] & ", UNIT" & [UNIT_NUM]" VB # CalculateField KS_Edit.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [STR_NAME] & " " & [STR_TYPE] & " " & [SUFFIX] & ", UNIT " & [UNIT_NUM]" VB # CalculateField KS_Edit.RP_Addresspt FULL_ADDRESS "[ADDR_NUM] & " " & [PREFIX]& " " & [STR_NAME] & " " & [STR_TYPE] & ", UNIT " & [UNIT_NUM]" VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "A" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "[UNIT_NUM] & [BLDG_NUM]" VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "A" VB # CalculateField KS_Edit.RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField KS_Edit.RP_Addresspt PIN [PARCEL_NUM] VB # CalculateField KS_Edit.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43533 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField KS_Edit.RP_Addresspt ADDR_ID 0 VB # CalculateField KS_Edit.RP_Addresspt FRACTION "" VB # CalculateField KS_Edit.RP_Addresspt UNIT_TYPE "" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "" VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "" VB # CalculateField KS_Edit.RP_Addresspt PREFIX "" VB # CalculateField KS_Edit.RP_Addresspt SUFFIX "" VB # CalculateField KS_Edit.RP_Addresspt FULL_ADDRESS "replace ( [FULL_ADDRESS], "12605", "12609")" VB # CalculateField KS_Edit.RP_Addresspt ADDR_ID autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 43555 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField KS_Edit.RP_Addresspt FRACTION "" VB # CalculateField KS_Edit.RP_Addresspt UNIT_TYPE "" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "" VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "" VB # CalculateField KS_Edit.RP_Addresspt PREFIX "" VB # CalculateField KS_Edit.RP_Addresspt SUFFIX "" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "right ( [UNIT_NUM] , 2)" VB # CalculateField sde_vector.ARCADMIN.RP_Addresspt UNIT_NUM autoIncrement() PYTHON_9.3 "rec=0\ndef autoIncrement():\n global rec\n pStart = 1 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd\n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec\n" CalculateField sde_vector.ARCADMIN.RP_Addresspt EDIT_DATE Date() VB # CalculateField KS_Edit.RP_Addresspt FRACTION "" VB # CalculateField KS_Edit.RP_Addresspt UNIT_TYPE "" VB # CalculateField KS_Edit.RP_Addresspt UNIT_NUM "" VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "" VB # CalculateField KS_Edit.RP_Addresspt PREFIX "" VB # CalculateField KS_Edit.RP_Addresspt SUFFIX "" VB # CalculateField KS_Edit.RP_Addresspt FRACTION "" VB # CalculateField KS_Edit.RP_Addresspt BLDG_NUM "" VB # CalculateField KS_Edit.RP_Addresspt PREFIX "" VB # CalculateField KS_Edit.RP_Addresspt SUFFIX "" VB # ChangePrivileges srv-gistest02.sde\sde_vector.ARCADMIN.RP_Addresspt NT-KIRKLAND\Ksun REVOKE REVOKE ChangePrivileges srv-gistest02.sde\sde_vector.ARCADMIN.RP_Addresspt IT_BRW_Editor REVOKE REVOKE ChangePrivileges srv-gistest02.sde\sde_vector.ARCADMIN.RP_Addresspt IT_ADST_EDITOR GRANT GRANT AddField "Database Connections\arcadmin@sde_vector@srv-gistest02.sde\sde_vector.ARCADMIN.RP_Addresspt" EDIT_NAME TEXT # # 20 "EDIT NAME" NULLABLE NON_REQUIRED # AlterField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" EDIT_DATE # EDIT_DATE AlterField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" EDIT_NAME # EDIT_NAME RegisterAsVersioned "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" NO_EDITS_TO_BASE ChangePrivileges 'Database Connections\arcadmin@sde_vector@srv-gisdb.sde\\sde_vector.ARCADMIN.RP_Addresspt' IT_ADST_EDITOR GRANT GRANT ChangePrivileges 'Database Connections\arcadmin@sde_vector@srv-gisdb.sde\\sde_vector.ARCADMIN.RP_Addresspt' IT_ADST_EDITOR GRANT GRANT AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" CREATE_NAME TEXT # # 20 CREATE_NAME NULLABLE NON_REQUIRED # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" CREATE_DATE DATE # # # CREATE_DATE NULLABLE NON_REQUIRED # EnableEditorTracking "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\\sde_vector.ARCADMIN.RP_Addresspt" CREATE_NAME CREATE_DATE EDIT_NAME EDIT_DATE NO_ADD_FIELDS DATABASE_TIME DisableEditorTracking "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\\sde_vector.ARCADMIN.RP_Addresspt" DISABLE_CREATOR DISABLE_CREATION_DATE DISABLE_LAST_EDITOR DISABLE_LAST_EDIT_DATE Append 'Database Connections\arcadmin@sde_vector@srv-gistest02.sde\sde_vector.ARCADMIN.RP_Addresspt' "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" TEST # # EnableEditorTracking "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\\sde_vector.ARCADMIN.RP_Addresspt" CREATE_NAME CREATE_DATE EDIT_NAME EDIT_DATE NO_ADD_FIELDS DATABASE_TIME EnableEditorTracking "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\\sde_vector.ARCADMIN.RP_Addresspt" CREATE_NAME CREATE_DATE EDIT_NAME EDIT_DATE NO_ADD_FIELDS UTC CalculateField RP_Addresspt CREATE_DATE [EDIT_DATE] VB # CalculateField RP_Addresspt PIN "4079700000" VB # CalculateField RP_Addresspt PARCEL_NUM "4079700000" VB # CalculateField RP_Addresspt CREATE_DATE [EDIT_DATE] VB # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" STATUS TEXT # # 30 STATUS NULLABLE NON_REQUIRED # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" SITEADDID TEXT # # 20 SITE_ADDRESS_ID NULLABLE NON_REQUIRED # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" ADDPTKEY TEXT # # 20 ADDRESS_POINT_ID NULLABLE NON_REQUIRED # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" ALTUNITTYPE TEXT # # 10 ALTERNATIVE_UNIT_TYPE NULLABLE NON_REQUIRED # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" ALTUNITID TEXT # # 10 ALTERNATIVE_UNIT_NUMBER NULLABLE NON_REQUIRED # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" SKETCH_PIN TEXT # # 10 SKETCH_PIN NULLABLE NON_REQUIRED # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" ANOMALY_TYPE TEXT # # 50 ANOMALY_TYPE NULLABLE NON_REQUIRED # AddField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" LABEL_ROTATE DOUBLE 38 8 # LABEL_ROTATE NULLABLE NON_REQUIRED # AssignDomainToField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" STATUS AD_ADDR_STATUS # AssignDomainToField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" ALTUNITTYPE AD_ADDR_UNIT_TYPE # AssignDomainToField "Database Connections\arcadmin@sde_vector@srv-gisdb.sde\sde_vector.ARCADMIN.RP_Addresspt" ANOMALY_TYPE AD_ANOMALY_TYPE # CalculateField RP_Addresspt ALTUNITTYPE "Unit" VB # CalculateField RP_Addresspt UNIT_TYPE "" VB # CalculateField RP_Addresspt ALTUNITID [UNIT_NUM] VB # CalculateField RP_Addresspt UNIT_NUM NULL VB # CalculateField RP_Addresspt UNIT_TYPE NULL VB # CalculateField RP_Addresspt ALTUNITID [BLDG_NUM] VB # CalculateField RP_Addresspt BLDG_NUM NULL VB # CalculateField RP_Addresspt ALTUNITID [BLDG_NUM] VB # CalculateField RP_Addresspt ALTUNITTYPE "Building" VB # CalculateField RP_Addresspt ALTUNITTYPE NULL VB # CalculateField RP_Addresspt ALTUNITID NULL VB # CalculateField RP_Addresspt BLDG_NUM NULL VB # CalculateField RP_Addresspt UNIT_TYPE NULL VB # CalculateField RP_Addresspt UNIT_NUM NULL VB # CalculateField RP_Addresspt BLDG_NUM NULL VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt MAIL_FLAG "N" VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt MAIL_FLAG "Y" VB # CalculateField RP_Addresspt STATUS "Current" VB # CalculateField RP_Addresspt MAIL_FLAG "Y" VB # CalculateField RP_Addresspt MAIL_FLAG "Y" VB # CalculateField RP_Addresspt STATUS "Current" VB # CalculateField RP_Addresspt FRACTION NULL VB # CalculateField RP_Addresspt PREFIX NULL VB # CalculateField RP_Addresspt PREFIX NULL VB # CalculateField RP_Addresspt PREFIX NULL VB # CalculateField RP_Addresspt PREFIX NULL VB # CalculateField RP_Addresspt PREFIX NULL VB # CalculateField RP_Addresspt FRACTION "" VB # CalculateField RP_Addresspt PREFIX NULL VB # CalculateField RP_Addresspt FRACTION NULL VB # CalculateField RP_Addresspt FRACTION NULL VB # CalculateField RP_Addresspt ADDR_NUM "replace ( [ADDR_NUM], " ", "")" VB # CalculateField RP_Addresspt ADDR_NUM "replace ( [ADDR_NUM], " ", "")" VB # CalculateField RP_Addresspt ADDR_NUM "replace ( [ADDR_NUM], " ", "")" VB # CalculateField RP_Addresspt ADDR_NUM NULL VB # CalculateField RP_Addresspt BLDG_NUM NULL VB # CalculateField RP_Addresspt BLDG_NUM NULL VB # CalculateField RP_Addresspt BLDG_NUM NULL VB # CalculateField RP_Addresspt SUFFIX NULL VB # CalculateField RP_Addresspt SUFFIX NULL VB # CalculateField RP_Addresspt FULL_ADDRESS "replace ( [FULL_ADDRESS], " ", "")" VB # CalculateField RP_Addresspt ADDR_TYPE "M" VB # CalculateField RP_Addresspt ADDR_TYPE "M" VB # CalculateField RP_Addresspt ZIPCODE "98034" VB # CalculateField RP_Addresspt PIN "2422700000" VB # CalculateField RP_Addresspt STATUS "Other" VB # CalculateField RP_Addresspt PIN "9118300000" VB # CalculateField RP_Addresspt PARCEL_NUM "9118300000" VB # CalculateField RP_Addresspt ADDR_TYPE "MULTI-FAMILY" VB # ChangePrivileges 'Database Connections\arcadmin@sde_vector@srv-gisdb01.sde\sde_vector.ARCADMIN.RP_Addresspt';'Database Connections\arcadmin@sde_vector@srv-gisdb01.sde\sde_vector.ARCADMIN.RP_Addresspt_Anno' gisuser GRANT # ChangePrivileges 'Database Connections\arcadmin@sde_vector@srv-gisdb01.sde\sde_vector.ARCADMIN.RP_Addresspt';'Database Connections\arcadmin@sde_vector@srv-gisdb01.sde\sde_vector.ARCADMIN.RP_Addresspt_Anno' IT_ADST_EDITOR # AS_IS CalculateField RP_Addresspt MAIL_FLAG "Y" VB # CalculateField RP_Addresspt PIN "1233100225" VB # CalculateField RP_Addresspt PARCEL_NUM "1233100225" VB # CalculateField RP_Addresspt PIN "1420700005" VB # CalculateField RP_Addresspt PARCEL_NUM "1420700005" VB # CalculateField RP_Addresspt PIN "2408700000" VB # CalculateField RP_Addresspt PARCEL_NUM "2408700000" VB # CalculateField RP_Addresspt PIN "515607" VB # CalculateField RP_Addresspt PARCEL_NUM "515607" VB # CalculateField RP_Addresspt SUFFIX "NE" VB # CalculateField RP_Addresspt SUFFIX "NE" VB # CalculateField RP_Addresspt SUFFIX "NE" VB # CalculateField RP_Addresspt PIN "4363000000" VB # CalculateField RP_Addresspt PARCEL_NUM "4363000000" VB # CalculateField RP_Addresspt STATUS "Current" VB # CalculateField RP_Addresspt MAIL_FLAG "Y" VB # CalculateField RP_Addresspt STATUS "Current" VB # CalculateField RP_Addresspt STATUS "Current" VB # CalculateField RP_Addresspt PIN "1620400010" VB # CalculateField RP_Addresspt PARCEL_NUM "1620400010" VB # CalculateField RP_Addresspt STATUS "Current" VB # CalculateField RP_Addresspt MAIL_FLAG "Y" VB # CalculateField RP_Addresspt PIN "1620400070" VB # CalculateField RP_Addresspt PARCEL_NUM "1620400070" VB # CalculateField RP_Addresspt PIN "162040090" VB # CalculateField RP_Addresspt PIN "1620400090" VB # CalculateField RP_Addresspt PARCEL_NUM "1620400090" VB # CalculateField RP_Addresspt PIN "1620400150" VB # CalculateField RP_Addresspt PARCEL_NUM "1620400150" VB # CalculateField RP_Addresspt MAIL_FLAG "Y" VB # CalculateField RP_Addresspt STATUS "Current" VB # CalculateField KSUN_RP_Addresspt PIN "3900230030" VB # CalculateField KSUN_RP_Addresspt PARCEL_NUM [PIN] VB # CalculateField RP_Addresspt PIN "3900100825" VB # CalculateField RP_Addresspt PARCEL_NUM "3900100825" VB # CalculateField RP_Addresspt PIN "3900100805" VB # CalculateField RP_Addresspt PARCEL_NUM "3900100805" VB # CalculateField RP_Addresspt PIN "2926059129" VB # CalculateField RP_Addresspt PARCEL_NUM "2926059129" VB # CalculateField RP_Addresspt ADDR_NUM "12202" VB # CalculateField RP_Addresspt ADDR_NUM "12120" VB # CalculateField RP_Addresspt PIN "5677800000" VB # CalculateField RP_Addresspt PARCEL_NUM "5677800000" VB # CalculateField RP_Addresspt PIN "0925059164" VB # CalculateField RP_Addresspt PARCEL_NUM "0925059164" VB # CalculateField RP_Addresspt STR_TYPE "PL" VB # CalculateField RP_Addresspt PIN "7981700000" VB # CalculateField RP_Addresspt PARCEL_NUM "7981700000" VB # CalculateField RP_Addresspt PIN "6390200000" VB # CalculateField RP_Addresspt PARCEL_NUM "6390200000" VB # CalculateField RP_Addresspt PIN "6390040000" VB # CalculateField RP_Addresspt PARCEL_NUM "6390040000" VB # CalculateField RP_Addresspt ADDR_TYPE "MULTI-FAMILY" VB # CalculateField RP_Addresspt PIN "7427550000" VB # CalculateField RP_Addresspt PARCEL_NUM "7427550000" VB # CalculateField RP_Addresspt PIN "3900101211" VB # CalculateField RP_Addresspt PARCEL_NUM "3900101211" VB # CalculateField RP_Addresspt PIN "8732460000" VB # CalculateField RP_Addresspt PARCEL_NUM "8732460000" VB # CalculateField RP_Addresspt PIN "7882600131" VB # CalculateField RP_Addresspt PARCEL_NUM "7882600131" VB # CalculateField RP_Addresspt PIN "2617410000" VB # CalculateField RP_Addresspt PIN "8944390010" VB # CalculateField RP_Addresspt PARCEL_NUM "8944390010" VB # CalculateField RP_Addresspt STATUS "Pending" VB # CalculateField RP_Addresspt PIN "2826059220" VB # CalculateField RP_Addresspt PARCEL_NUM "2826059220" VB # CalculateField RP_Addresspt PIN "6012900000" VB # CalculateField RP_Addresspt PARCEL_NUM "6012900000" VB # CalculateField RP_Addresspt PIN "8729850000" VB # CalculateField RP_Addresspt PARCEL_NUM "8729850000" VB # CalculateField RP_Addresspt PIN "8584500000" VB # CalculateField RP_Addresspt PARCEL_NUM "8584500000" VB # CalculateField RP_Addresspt PIN "1241500310" VB # CalculateField RP_Addresspt PIN "9999999999" VB # CalculateField RP_Addresspt PARCEL_NUM "4315000180" VB # CalculateField RP_Addresspt PIN "4315000180" VB # CalculateField RP_Addresspt PIN "7803990000" VB # CalculateField RP_Addresspt PARCEL_NUM "7803990000" VB # CalculateField RP_Addresspt PIN "8732490000" VB # CalculateField RP_Addresspt PIN "8732470000" VB # CalculateField RP_Addresspt PARCEL_NUM "8732470000" VB # CalculateField RP_Addresspt PIN "8944380050" VB # CalculateField RP_Addresspt PARCEL_NUM "8944380050" VB # Server=srv-azgissql02; Service=sde:sqlserver:srv-azgissql02; Database=sde_published; User=arcadmin; Version=dbo.DEFAULT ArcSDE Connection sde_vector.ARCADMIN.RP_Addresspt 002 1288916.277323 1316006.023310 237432.056272 273017.785184 1 sde_vector.ARCADMIN.Anno_904_17433 Relationship sde_vector.ARCADMIN.Anno_904_17433 Relationship Projected GCS_North_American_1983 Linear Unit: Foot_US (0.304801) NAD_1983_StatePlane_Washington_North_FIPS_4601_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.6'><WKT>PROJCS[&quot;NAD_1983_StatePlane_Washington_North_FIPS_4601_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1640416.666666667],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-120.8333333333333],PARAMETER[&quot;Standard_Parallel_1&quot;,47.5],PARAMETER[&quot;Standard_Parallel_2&quot;,48.73333333333333],PARAMETER[&quot;Latitude_Of_Origin&quot;,47.0],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2285]]</WKT><XOrigin>-117104299.999992</XOrigin><YOrigin>-99539599.999990687</YOrigin><XYScale>294529.62067492894</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>2.7161953971446441e-05</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>102748</WKID><LatestWKID>2285</LatestWKID></ProjectedCoordinateSystem> 20200610 01555100 20200610 01555100 150000000 5000 ItemDescription Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9270 Addresses 1 -122.261963 -122.149409 47.740849 47.641982 This authoritative data layer is published by the City of Kirkland. <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 0 0;"><SPAN>This point dataset shows the attributes and location of addresses within the City of Kirkland. The attribute field "Mailable" indicates whether the address point is a mailing (Y) or a non-mailable (N) address. In 2016, the City of Kirkland IT/GIS became responsible for all address assigning and maintenance.</SPAN></P></DIV></DIV></DIV> City of Kirkland Addresses Address Points Site Address real property <DIV STYLE="text-align:Left;"><P STYLE="margin:0 0 0 0;"><SPAN>This dataset is intended for general mapping purposes only. This dataset may not be used for commercial purposes.</SPAN></P></DIV> SDE Feature Class dataset EPSG 5.3(9.0.0) 45064 Simple FALSE 45064 TRUE FALSE sde_vector.ARCADMIN.RP_Addresspt Feature Class 45064 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. ADDR_ID ADDR_ID Double 8 38 8 FULL_ADDRESS FULL_ADDRESS String 80 0 0 PIN PIN String 10 0 0 PARCEL_NUM PARCEL_NUM String 10 0 0 ADU ADU String 1 0 0 ADDR_NUM ADDR_NUM String 10 0 0 FRACTION FRACTION String 4 0 0 UNIT_TYPE UNIT_TYPE String 5 0 0 UNIT_NUM UNIT_NUM String 10 0 0 BLDG_NUM BLDG_NUM String 10 0 0 PREFIX PREFIX String 2 0 0 STR_NAME STR_NAME String 30 0 0 STR_TYPE STR_TYPE String 4 0 0 SUFFIX SUFFIX String 2 0 0 ADDR_TYPE ADDR_TYPE String 20 0 0 MAIL_FLAG MAIL_FLAG String 1 0 0 RNAME RNAME String 10 0 0 CITY CITY String 15 0 0 STATE STATE String 2 0 0 ZIPCODE ZIPCODE String 10 0 0 XCOORD XCOORD Double 8 38 8 YCOORD YCOORD Double 8 38 8 LABEL_FLAG LABEL_FLAG String 10 0 0 EDIT_DATE EDIT_DATE Date 8 0 0 EDIT_NAME EDIT_NAME String 20 0 0 SHAPE SHAPE Geometry 4 0 0 Feature geometry. Esri Coordinates defining the features. CREATE_NAME CREATE_NAME String 20 0 0 CREATE_DATE CREATE_DATE Date 8 0 0 STATUS STATUS String 30 0 0 SITEADDID SITE_ADDRESS_ID String 20 0 0 ADDPTKEY ADDRESS_POINT_ID String 20 0 0 ALTUNITTYPE ALTERNATIVE_UNIT_TYPE String 10 0 0 ALTUNITID ALTERNATIVE_UNIT_NUMBER String 10 0 0 SKETCH_PIN SKETCH_PIN String 10 0 0 ANOMALY_TYPE ANOMALY_TYPE String 50 0 0 LABEL_ROTATE LABEL_ROTATE Double 8 38 8 GlobalID GlobalID GlobalID 38 0 0 20200610 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAorD8TeL9D8I2DXesX8UGF3JDuBll7YROrfyHfFcXN8fvA0UgRLi+mUgEvH akAe3zEHj6UAeoUV5pH8efAciAtf3UZI+61o+R+QNaWhfF3wX4g1GSxtdWWGUMqxm6XyRMTj7hbq cnGDg56AjmgDuaK5Kb4n+Cbe7e1l8SWKyozKw3EgFcgjOMdvxqE/FnwGAT/wktpx7P8A4UAaPirx tovgxbBtZmkiS9n8lHRNwTjJZvRRx0yeelbVjf2ep2cd5YXcF1bSZ2TQSB0bBwcEcda8B+O+s6Z4 p8NaRqeiajHe2lpdyQTGJxhHdAVyCN2SFOD0615b4H8W6j4U8R2FzBqU9rYm5j+1ohLI8WcNuT+L 5S2OOvTmgD7YorzNfjz4DMjqb67ULjDG0fDcZ44z7c16NaXUN9ZwXds/mQTxrLG+CNysMg8+xoAm ooooAKKKKACiiigAooooAKKKKACiiigAooooAyfEfiTTPCuknU9WleK0EiRl0jZ8FjgE4HA9/wCu BUOk+M/DWuyrFpeu2F1MwJWJJ13kAZJ2nnge1c/8ZbS+vfhXrKWPzMiJLKm0EtEjhn69MAbs/wCz XylpmtnS9NvbaC1jFxdgIb0M4liQHJVMMAM45yDkcUAek/HHX/DXi270zUvD999tuYFa2umSN1Cr ndH95Rnkv0JryCvav2e7y0ttc164u9Qt4J5IESI3MoXzGLMT1OT90Zwa6SPxfNr/AMR5/B/juy0d bK2jMQkMbRkzsoTdGxbID7zjvjB6igD5xp6SuiMqnAYgngdRnH8zT7tUS9nSNtyLIwVvUZ4NQ0AK zFmLMSWJySe9JRWho95p1ldSSalpQ1KJoyqxG4aHa2Rhsrye/HvQBZuoni8G6a7SjbNfXJWLfyAq Qjdj0JJGf9k1jVJJt2x7Y2TK8ljnccnkcdO34VHQBZtLQ3XnHzUjWJN7Fgx43BewP97vgcda+yfh zq+oax4NsZtQ0oaeFijjtyLpZhcRhBhwV6Z54PIxXxbXS+GvFOt6fqmh29pqYgisrzzLcTDMcRkI DlsclSOoHbOOaAPtqisrQ9cg1xL7yA2bG7ezlf5dryIBuK4J4ycc81q0AFFFFABRRRQAUUUUAFFF FABRRRQAUUUUAVdStP7Q0u7ssqPtELxZdA4G5SOVPBHPQ9a+G9astT0nUH0fVVmiuLAmLyZCSIwS W+X2JbdkcHOe9fd1cJ4/8B6Tro/t9tMgu9UsISVjlBKToDkqygjccbtvI5IzxQB8q6J4ZvPEGqxW NiV5i8+e4mBSK3jHLO7Hoq9z+AzxVHVp559UuGuLxb2RG8r7QpJEioNqkZAOMKMZGcV3PjT4pPrm mw6L4dsF0LQ0iMcltDgNLlicEjHy85x3JbOa4/xB4b1bwtqCWOs2jW1w8SzIpYNuRs4IIJ7gj8DQ BX0q4sbTUI59RsDf2yZLWwmMQc44yw5A78elQXZtmvJjZpKlsXJiWVgzhc8AkAAn3xUumy2MGoQy 6jaS3dqrZeCKbyi49N204H4Z9x1qK7aF7yd7dWWBpGMatjIXPAOOM4oAhrZ8Q6B/YNzEialp2oQy ruSeyuklB4BIIBypGcYYDODWNWpoGl2usaotld6pBpqyKdk9wpMe7srEfdzzz0oAqQQyXNvMkUW5 4h5xIIBCDhvc9jx0GT9K4UkDHJzjHetrwnqFlpniK3uNQjZ7Ng8E7KSDHHIhjZxgH5lDEgYPIq1f Wmg+Hta1O1kVtct1Qx2VxFOYULFQRIwAJYc5ABH1PWgDCuLG5tJ1guIWilZVcK/BAIyCfTjnmizl W01C2nnh8xI5EkaJuN6gg4/EfzqFt0heTHfJIHAzX03o3wH8NXvhq2k1a3vrfVbiGN5tk6gwPtXc qgDbjIPUE8nmgDvvAL6hN4I0y51V5Xv7mMzzGWERNudi2No6YBA9cda6Sora3itLWG2gXZFCixov ooGAPyqWgAooooAKKKKACiiigAooooAKKKKACiiigAooooA+V/jz4UTQ/GKalY6e0Gn38YZpEQCM z5O4DHQkYPOM5Nec6vrura7PHLq2oXF5JCgjjM0hbYo7DsPw6191XFvBdQPBcQxzQuCrRyKGVgex B615t4n+BfhLxBIJ7OOTR5wu3/QlURt6EoRjP0xnvQB87+B/A2p+P9bNjYNFBFCitcXDj5Yl6ZwO SxxwO56kda9m1f8AZ7tU8NLaaBqONTLDz5r3OyZc54Cg7COMEA8DB65rvvh/8OtL+H9hcRWcsl1d XLAzXMqgMwHRQB0A5/E1xPxC+MFz4X8dXGiWziOC2s1DsbYTH7Q5Vgcb1+URn16k8HigD5y1PTbr R9Vu9NvY/LurWVoZVznDKcHB7j3qpXpviLSrP4hTeJfHWnahFYWkDKZbS6Q+cW2KAQE3DDEdexzn gZPndvp95dW81zBaTy28GPOlSJmSLOcbiBx0PX0NAFap7iZJkg2oQ6R7JGJ+8QTgj/gO0fhUtxDZ QbokvGuHRmAkiiIjfgYILYbGc9VH0qvcQ/Z7mWHzEk8tym+Mna2DjIzg4NAHa+DtR8Ny6fZ6LrJ1 qK5bUvMim050VcP5QG8HkkGPIx0znrX2NXwt4WjM3i7RYgVBe/gUFwCBmReoPBH1r7poAKKKKACi iigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK+M/iwzN8U/EBckn7TjnHTauOntX2ZXyj8f NGOmfEqW7XPl6jbx3APOAwGwj/xwH/gVAHl1dHZeILSw8LavpEMN4TqXklg04CK0bEhjgAt95htP HIJyQMc5TlcqrAYwwwcjPGQfw6UACbPMXzAxTI3BTg474q8lvc67q8iafZs8svmSJbxckKqliB64 VT+VV7KxudRultrSIyzMrMFBA4VSxPPoAT+FWr6+txd2c+lRmzaC2iVnjZldpQo3vnJwS2emOMcZ zQBb8FY/4Tvw9lkUf2lb5MmNoHmL1z2r7ir4Y8KS28Hi/R5rt5UgjvYndoV3MAHB4Ffc9ABRRRQA UUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABXnXxh8AyeN/DCSWIB1XTy0tup/wCWoIG6 P6nAx7geua9FooA+BJ4JbaeSCeJ4pomKSRyKVZGBwQQeQQe1NDkRlMLgkHOOeM9/x/lXbfF7UINS +KGtPboqpDL9nOEVcsg2sSV68g8nnsemK49EW1vfLvYHIRissQbawPQ884I9x1HNAG94T8TQ+HbT XYv7O+03epWLWdvKHKmEuQGPHJyPT0A6E1h6hpt5pdwsF7byQStGkoWRSpKsoYHn2NOnsprSCG+j LG2kmdIJCACxQI3IBIBw68ZODxT9X1a41m7juLhUUxwRwIqbsBEUKOWJJ4Hc0AN0YK2uaeHZVU3M YJbOANw64yfyr7yr4Q0JDJ4h02MIXLXUQ2gZLZccV930AFFFFABRRRQAUUUUAFFFFABRRRQAUUUU AFFFFABRRRQAUUUUAFFFFAHwz4tvZdS8Y6zeTRCGWa9ldox/Ad54rGrp/iNLLN8R/ELzCUN9ulA8 1NjbQcLx9AMHuOa5pV3cllUZAJJ6fh1oA3PBmjWviPxbpujX12bW0uZSrSbwu35ScAtxkkAD1JAr ESJ5HZVwSoLH5h0Ayf5V6j8BtD0zW/HV7Dqdnb30ENg8iJNGHTd5kYBww64JxVDVPgt46g1C5EGh ebAJysbRXERDKScEcg4+oGPagDgbK7l0+/t72DaJreVZU3DI3KQRkd+RX1n8IvHmqePNF1C71WG0 jltrgRKLZGUEFQeck981leCPgzoaeELKPxXoFtJq+GMpSd8gE8BirAZAwOOP1rvvDPg/Q/B9rPba HZfZY53DyAyM5YgYHLE9qANyiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiuG 8Y6zr9v418JaRokMwhublpr2bZmIwqPmQnacHBJHTnb65AB4N8e4Ui+Kd06shMttC7Bc5B27cHI6 4UdMjBHfNefabpWoaxdfZdMsri8uNpfy4Iy7bR1OB2r1L4qWnjHxRrNxc3vgua3FoZfJu4UZj9lQ 9HIJU4JLZ6/NxxWl8LfAtr4v8KGIahrGi3tncP8Aamtg0YuUlQFOTwcAdux6fNkgGV8S/DzfC650 h/DOo3OnSXlsRcmC7kWWRgQTnGMJ0x75r6H8F6jNq/gjRNQuWdp57KJ5GfGWbaMscAdTz071z/jj 4VaT46k0+S9v76CSyi8lWjZWLrkH5iwJJ4PPvXYaPpkOi6LY6XbM7QWcCQRtIQWKqABnHfigC7RR RQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFAAAwBgCiigAooooAKKK KACiiigAooooAKKKKACiiigD/9k=