20220223
17305300
1.0
FALSE
sde.WORCESTERSDE.Worc_addresses
002
Server=WCDBSVR2; Service=sde:sqlserver:WCDBSVR2; Database=sde; User=WORCESTERSDE; Version=sde.DEFAULT
ArcSDE Connection
519039.577002
570194.567386
37347.949465
88894.223689
1
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_StatePlane_Maryland_FIPS_1900
<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.8'><WKT>PROJCS["NAD_1983_StatePlane_Maryland_FIPS_1900",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-77.0],PARAMETER["Standard_Parallel_1",38.3],PARAMETER["Standard_Parallel_2",39.45],PARAMETER["Latitude_Of_Origin",37.66666666666666],UNIT["Meter",1.0],AUTHORITY["EPSG",26985]]</WKT><XOrigin>-36747099.999464899</XOrigin><YOrigin>-29091499.999582998</YOrigin><XYScale>7812.4999927240406</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0020480000019073501</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>2</MTolerance><HighPrecision>true</HighPrecision><WKID>26985</WKID><LatestWKID>26985</LatestWKID></ProjectedCoordinateSystem>
CalculateField Worcester_Addresses split_notes 1 VB #
CalculateField Worcester_Addresses split_notes 2 VB #
CalculateField Worcester_Addresses split_notes 3 VB #
CalculateField Worcester_Addresses split_notes 1 VB #
CalculateField Worcester_Addresses landmkname "Highland Park" VB #
CalculateField Worcester_Addresses3 tracking_dm NULL VB #
CalculateField Worcester_Addresses discrpagid "http://www.co.worcester.md.us/" VB #
CalculateField Worcester_Addresses landmkname NULL VB #
CalculateField Worcester_Addresses unit_type "UNIT" VB #
CalculateField Worcester_Addresses unit_type "SUITE" VB #
CalculateField Worcester_Addresses site_nguid !site_nguid!.replace('Site', 'SITE') PYTHON_9.3 #
CalculateField Worcester_Addresses unit_type "Apartment" VB #
CalculateField Worcester_Addresses unit_type "Building" VB #
CalculateField Worcester_Addresses unit_type "Room" VB #
CalculateField Worcester_Addresses unit_type !unit_type!.title() PYTHON_9.3 #
CalculateField Worcester_Addresses unit_type "Trailer" VB #
CalculateField Worcester_Addresses unit_type "Utility Building" VB #
CalculateField Worcester_Addresses site_nguid ""SITE" &[external_nguid]&"@co.worcester.md.us"" VB #
CalculateField Worcester_Addresses last_edited_user "DMARK" VB #
CalculateField Worcester_Addresses last_edited_user "DMARK" VB #
CalculateField Worcester_Addresses tracking_dm NULL VB #
CalculateField Worcester_Addresses notes_dm NULL VB #
CalculateField Worcester_Addresses tracking_dm UCase([tracking_dm]) VB #
CalculateField Worcester_Addresses notes_dm NULL VB #
CalculateField Worcester_Addresses tracking_dm NULL VB #
CalculateField Worcester_Addresses notes_dm UCase( [notes_dm] ) VB #
CalculateField Worcester_Addresses notes_dm UCase( [notes_dm]) VB #
CalculateField Worcester_Addresses notes_dm NULL VB #
CalculateField Worcester_Addresses notes_dm "RECOMMEND DELETION" VB #
CalculateField Worcester_Addresses tracking_dm NULL VB #
CalculateField Worcester_Addresses notes_dm "RECOMMEND DELETION" VB #
CalculateField Worcester_Addresses tracking_dm NULL VB #
CalculateField Worcester_Addresses tracking_dm "DELETE" VB #
CalculateField Worcester_Addresses tracking_dm NULL VB #
CalculateField Worcester_Addresses tracking_dm NULL VB #
CalculateField Worcester_Addresses notes_dm NULL VB #
CalculateField Worcester_Addresses notes_dm NULL VB #
CalculateField Worcester_Addresses tracking_dm "RECOMMENDED DELETION" VB #
CalculateField Worcester_Addresses tracking_dm NULL VB #
CalculateField Worcester_Addresses_orig Worcester_Addresses.last_edited_user !last_edited_user! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Worcester_Addresses_orig last_edited_user !last_edited_user! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Worcester_Addressescopy_orig leu [last_edited_user] VB #
CalculateField Worcester_Addressescopy_orig led [last_edited_date] VB #
FeatureClassToFeatureClass C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses "C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\~Post_Processing\Worcester County AGOL & Main Data\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb" Worcester_Addresses_USE_THIS_ONE # "discrpagid "discrpagid" true true false 75 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,discrpagid,-1,-1;dateupdate "dateupdate" true true false 8 Date 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,dateupdate,-1,-1;site_nguid "site_nguid" true true false 254 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,site_nguid,-1,-1;country "Country" true true false 2 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,country,-1,-1;state "State" true true false 2 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,state,-1,-1;county "County" true true false 40 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,county,-1,-1;addcode "addcode" true true false 6 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,addcode,-1,-1;inc_muni "inc_muni" true true false 100 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,inc_muni,-1,-1;addnum_pre "addnum_pre" true true false 15 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,addnum_pre,-1,-1;add_number "add_number" true true false 4 Long 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,add_number,-1,-1;st_premod "st_premod" true true false 15 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_premod,-1,-1;st_predir "st_predir" true true false 9 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_predir,-1,-1;st_pretyp "st_pretyp" true true false 50 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_pretyp,-1,-1;st_presep "st_presep" true true false 20 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_presep,-1,-1;st_name "st_name" true true false 60 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_name,-1,-1;st_postyp "st_postyp" true true false 50 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_postyp,-1,-1;st_posdir "st_posdir" true true false 9 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_posdir,-1,-1;st_posmod "st_posmod" true true false 25 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_posmod,-1,-1;lst_predir "lst_predir" true true false 2 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,lst_predir,-1,-1;lst_name "lst_name" true true false 75 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,lst_name,-1,-1;lst_type "lst_type" true true false 4 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,lst_type,-1,-1;lst_posdir "lst_posdir" true true false 2 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,lst_posdir,-1,-1;unit_type "unit_type" true true false 75 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,unit_type,-1,-1;unit_number "unit_number" true true false 75 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,unit_number,-1,-1;landmkname "landmkname" true true false 150 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,landmkname,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,last_edited_date,-1,-1;external_nguid "external_nguid" true true false 300 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,external_nguid,-1,-1;globalid "globalid" false false false 38 GlobalID 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,globalid,-1,-1;photo_front "PHOTO_FRONT" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_front,-1,-1;photo_back "PHOTO_BACK" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_back,-1,-1;photo_right "PHOTO_RIGHT" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_right,-1,-1;photo_left "PHOTO_LEFT" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_left,-1,-1;photo_front_link "PHOTO_FRONT_LINK" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_front_link,-1,-1;photo_back_link "PHOTO_BACK_LINK" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_back_link,-1,-1;photo_right_link "PHOTO_RIGHT_LINK" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_right_link,-1,-1;photo_left_link "PHOTO_LEFT_LINK" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_left_link,-1,-1;Site_Address_Points_Table_addnum_suf "addnum_suf" true true false 4 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,Site_Address_Points_Table_addnum_suf,-1,-1;zipcode "ZIPcode" true true false 5 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,zipcode,-1,-1;zip_src "ZIP_SRC" true true false 50 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,zip_src,-1,-1;veriftime "VerifTime" true true false 8 Date 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,veriftime,-1,-1;veriftype "VerifType" true true false 50 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,veriftype,-1,-1;photo_status "PHOTO_STATUS" true true false 8 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,photo_status,-1,-1;labrotate "Labrotate" true true false 4 Long 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,labrotate,-1,-1;inset "Inset" true true false 4 Long 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,inset,-1,-1;maptype "Maptype" true true false 12 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,maptype,-1,-1;comunity_l "comunity_l" true true false 20 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,comunity_l,-1,-1;comunity_r "comunity_r" true true false 20 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,comunity_r,-1,-1;full_address "Full_address" true true false 250 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,full_address,-1,-1;st_number "ST_NUMBER" true true false 5 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,st_number,-1,-1;cityl "CityL" true true false 4 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,cityl,-1,-1;cityr "cityr" true true false 4 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,cityr,-1,-1;street_unit "street_unit" true true false 15 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,street_unit,-1,-1;tracking_dm "tracking_dm" true true false 50 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,tracking_dm,-1,-1;notes_dm "notes_dm" true true false 100 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,notes_dm,-1,-1;Worcester_Addresses_last_edited_user "last_edited_user" true true false 512 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,Worcester_Addresses_last_edited_user,-1,-1;leu "leu" true true false 255 Text 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,leu,-1,-1;led "led" true true false 8 Date 0 0 ,First,#,C:\1-Working_DR\DR_Run_3\Worcester\~Deliverable_Working\DB_from_DM_Projects\MD_WORCESTER_DATA_DELIVERABLE_01042022\MD_WORCESTER_DATA_DELIVERABLE_01042022.gdb\Worcester_Addresses,led,-1,-1" #
CalculateField Worcester_Addresses_USE_THIS_ONE notes_dm !notes_dm!.upper() PYTHON_9.3 #
CalculateField Worcester_Addresses_USE_THIS_ONE discrpagid "http://www.co.worcester.md.us/" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE site_nguid ""Site"& [external_nguid]&"@"&"co.worcester.md.us"" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE site_nguid ""SITE"& [external_nguid]&"@"&"co.worcester.md.us"" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE country "US" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE state "MD" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE county "Worcester County" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE created_user "DMARK" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE created_date "2/4/2022 4:30:45" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE created_date "2/4/2022 14:30:45" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE last_edited_user "DMARK" VB #
CalculateField Worcester_Addresses_USE_THIS_ONE last_edited_date "2/8/2022 20:30:30" VB #
CalculateField Worcester_Addresses temp [external_nguid] VB #
CalculateField Worcester_Addresses uninc_muni "Worcester County" VB #
CalculateField Worc_addresses dateupdate [last_edited_date] VB #
CalculateField Worc_addresses unit_type "Building" VB #
CalculateField Worc_addresses unit_type "Suite" VB #
CalculateField Worc_addresses unit_type "Unit" VB #
FeatureClassToFeatureClass Worc_addresses "C:\Users\rebecca.mangin\OneDrive - Michael Baker International\Desktop\DATAMARK\DATA SERVICES\MD_WORCESTER\FINAL DELIVERABLE\WORCESTER_DATA_UPLOAD_022322.gdb" Worc_addresses_1 # "discrpagid "discrpagid" true true false 75 Text 0 0 ,First,#,Worc_addresses,discrpagid,-1,-1;dateupdate "dateupdate" true true false 8 Date 0 0 ,First,#,Worc_addresses,dateupdate,-1,-1;site_nguid "site_nguid" true true false 254 Text 0 0 ,First,#,Worc_addresses,site_nguid,-1,-1;country "Country" true true false 2 Text 0 0 ,First,#,Worc_addresses,country,-1,-1;state "State" true true false 2 Text 0 0 ,First,#,Worc_addresses,state,-1,-1;county "County" true true false 40 Text 0 0 ,First,#,Worc_addresses,county,-1,-1;addcode "addcode" true true false 6 Text 0 0 ,First,#,Worc_addresses,addcode,-1,-1;inc_muni "inc_muni" true true false 100 Text 0 0 ,First,#,Worc_addresses,inc_muni,-1,-1;uninc_muni "uninc_muni" true true false 100 Text 0 0 ,First,#,Worc_addresses,uninc_muni,-1,-1;addnum_pre "addnum_pre" true true false 15 Text 0 0 ,First,#,Worc_addresses,addnum_pre,-1,-1;add_number "add_number" true true false 4 Long 0 0 ,First,#,Worc_addresses,add_number,-1,-1;Site_Address_Points_Table_addnum_suf "addnum_suf" true true false 4 Text 0 0 ,First,#,Worc_addresses,Site_Address_Points_Table_addnum_suf,-1,-1;st_premod "st_premod" true true false 15 Text 0 0 ,First,#,Worc_addresses,st_premod,-1,-1;st_predir "st_predir" true true false 9 Text 0 0 ,First,#,Worc_addresses,st_predir,-1,-1;st_pretyp "st_pretyp" true true false 50 Text 0 0 ,First,#,Worc_addresses,st_pretyp,-1,-1;st_presep "st_presep" true true false 20 Text 0 0 ,First,#,Worc_addresses,st_presep,-1,-1;st_name "st_name" true true false 60 Text 0 0 ,First,#,Worc_addresses,st_name,-1,-1;st_postyp "st_postyp" true true false 50 Text 0 0 ,First,#,Worc_addresses,st_postyp,-1,-1;st_posdir "st_posdir" true true false 9 Text 0 0 ,First,#,Worc_addresses,st_posdir,-1,-1;st_posmod "st_posmod" true true false 25 Text 0 0 ,First,#,Worc_addresses,st_posmod,-1,-1;lst_predir "lst_predir" true true false 2 Text 0 0 ,First,#,Worc_addresses,lst_predir,-1,-1;lst_name "lst_name" true true false 75 Text 0 0 ,First,#,Worc_addresses,lst_name,-1,-1;lst_type "lst_type" true true false 4 Text 0 0 ,First,#,Worc_addresses,lst_type,-1,-1;lst_posdir "lst_posdir" true true false 2 Text 0 0 ,First,#,Worc_addresses,lst_posdir,-1,-1;unit_type "unit_type" true true false 75 Text 0 0 ,First,#,Worc_addresses,unit_type,-1,-1;unit_number "unit_number" true true false 75 Text 0 0 ,First,#,Worc_addresses,unit_number,-1,-1;landmkname "landmkname" true true false 150 Text 0 0 ,First,#,Worc_addresses,landmkname,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Worc_addresses,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Worc_addresses,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Worc_addresses,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Worc_addresses,last_edited_date,-1,-1;external_nguid "external_nguid" true true false 300 Text 0 0 ,First,#,Worc_addresses,external_nguid,-1,-1;globalid "globalid" false false false 38 GlobalID 0 0 ,First,#,Worc_addresses,globalid,-1,-1;photo_front "PHOTO_FRONT" true true false 255 Text 0 0 ,First,#,Worc_addresses,photo_front,-1,-1;photo_back "PHOTO_BACK" true true false 255 Text 0 0 ,First,#,Worc_addresses,photo_back,-1,-1;photo_right "PHOTO_RIGHT" true true false 255 Text 0 0 ,First,#,Worc_addresses,photo_right,-1,-1;photo_left "PHOTO_LEFT" true true false 255 Text 0 0 ,First,#,Worc_addresses,photo_left,-1,-1;photo_front_link "PHOTO_FRONT_LINK" true true false 255 Text 0 0 ,First,#,Worc_addresses,photo_front_link,-1,-1;photo_back_link "PHOTO_BACK_LINK" true true false 255 Text 0 0 ,First,#,Worc_addresses,photo_back_link,-1,-1;photo_right_link "PHOTO_RIGHT_LINK" true true false 255 Text 0 0 ,First,#,Worc_addresses,photo_right_link,-1,-1;photo_left_link "PHOTO_LEFT_LINK" true true false 255 Text 0 0 ,First,#,Worc_addresses,photo_left_link,-1,-1;zipcode "ZIPcode" true true false 5 Text 0 0 ,First,#,Worc_addresses,zipcode,-1,-1;zip_src "ZIP_SRC" true true false 50 Text 0 0 ,First,#,Worc_addresses,zip_src,-1,-1;veriftime "VerifTime" true true false 8 Date 0 0 ,First,#,Worc_addresses,veriftime,-1,-1;veriftype "VerifType" true true false 50 Text 0 0 ,First,#,Worc_addresses,veriftype,-1,-1;photo_status "PHOTO_STATUS" true true false 8 Text 0 0 ,First,#,Worc_addresses,photo_status,-1,-1;labrotate "Labrotate" true true false 4 Long 0 0 ,First,#,Worc_addresses,labrotate,-1,-1;inset "Inset" true true false 4 Long 0 0 ,First,#,Worc_addresses,inset,-1,-1;maptype "Maptype" true true false 12 Text 0 0 ,First,#,Worc_addresses,maptype,-1,-1;comunity_l "comunity_l" true true false 20 Text 0 0 ,First,#,Worc_addresses,comunity_l,-1,-1;comunity_r "comunity_r" true true false 20 Text 0 0 ,First,#,Worc_addresses,comunity_r,-1,-1;full_address "Full_address" true true false 250 Text 0 0 ,First,#,Worc_addresses,full_address,-1,-1;st_number "ST_NUMBER" true true false 5 Text 0 0 ,First,#,Worc_addresses,st_number,-1,-1;cityl "CityL" true true false 4 Text 0 0 ,First,#,Worc_addresses,cityl,-1,-1;cityr "cityr" true true false 4 Text 0 0 ,First,#,Worc_addresses,cityr,-1,-1;street_unit "street_unit" true true false 15 Text 0 0 ,First,#,Worc_addresses,street_unit,-1,-1;tracking_dm "tracking_dm" true true false 50 Text 0 0 ,First,#,Worc_addresses,tracking_dm,-1,-1;notes_dm "notes_dm" true true false 100 Text 0 0 ,First,#,Worc_addresses,notes_dm,-1,-1" #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses FULL_ADDR_DM_JOIN "[add_number]&" "& [st_predir]&" "& [st_name]&" "& [st_postyp]&" "& [unit_type]&" "& [unit_number]" VB #
CalculateField Master\Worc_addresses FULL_ADDR_DM_JOIN ' '.join(!FULL_ADDR_DM_JOIN! .split()) PYTHON_9.3 #
CalculateField Master\Worc_addresses FULL_ADDR_DM_JOIN ' '.join(!FULL_ADDR_DM_JOIN! .split()) PYTHON_9.3 #
CalculateField Master\Worc_addresses FULL_ADDR_DM_JOIN "[full_address]&" "& [unit_type]&" "& [unit_number]" VB #
CalculateField Master\Worc_addresses FULL_ADDR_DM_JOIN !FULL_ADDR_DM_JOIN!.upper() PYTHON_9.3 #
CalculateField Master\Worc_addresses FULL_ADDR_DM_JOIN ' '.join(!FULL_ADDR_DM_JOIN!.split()) PYTHON_9.3 #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM NULL VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM NULL VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM NULL VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM NULL VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM NULL VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM NULL VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM NULL VB #
CalculateField Master\Worc_addresses EDIT_NOTES_DM NULL VB #
CalculateField Worc_addresses temp [external_nguid] VB #
CalculateField Worc_addresses temp [external_nguid] VB #
CalculateField Worc_addresses EDIT_NOTES_DM "REMOVE AND REPLACE WITH WORC DATA" VB #
CalculateField Worc_addresses site_nguid !site_nguid!.replace('Site','SITE') PYTHON_9.3 #
CalculateField Worc_addresses dateupdate [last_edited_date] VB #
CalculateField Worc_addresses unit_type NULL VB #
CalculateField Worc_addresses unit_number NULL VB #
CopyFeatures C:\Users\mlaick\Desktop\MD_WORCESTER_DATA_DELIVERABLE_03022022.gdb\Worc_addresses "Database Connections\Connection_UN_WORCESTERSDE_get2worcester.sde\sde.WORCESTERSDE.Street_Network\sde.WORCESTERSDE.Worc_addresses" # 0 0 0
DeleteFeatures "Database Connections\Connection_UN_WORCESTERSDE_get2worcester.sde\sde.WORCESTERSDE.Street_Network\sde.WORCESTERSDE.Worc_addresses"
CalculateField sde.WORCESTERSDE.Worc_addresses external_nguid autoIncrement() PYTHON_9.3 "rec=0 def autoIncrement(): global rec pStart = 57582 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec"
CalculateField sde.WORCESTERSDE.Worc_addresses site_nguid ""SITE"+ [external_nguid]+"@co.worcester.md.us"" VB #
CalculateField sde.WORCESTERSDE.Worc_addresses Nguid_num [external_nguid] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses Nguid_num [external_nguid] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses site_nguid ""SITE" & [Nguid_num] & "@co.worcester.md.us"" VB #
CalculateField sde.WORCESTERSDE.Worc_addresses dateupdate "Date ( )" VB #
CalculateField sde.WORCESTERSDE.Worc_addresses dateupdate "Now ( )" VB #
CalculateField sde.WORCESTERSDE.Worc_addresses st_num_suffix [addnum_suf] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses st_prefix [lst_predir] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses st_type [lst_type] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses st_suffix [lst_posdir] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses Community [comunity_l] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses Community [comunity_l] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses Community [comunity_l] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses Community [comunity_l] VB #
Append TOC_addresspts_7_8_22 sde.WORCESTERSDE.Worc_addresses TEST # #
CalculateField sde.WORCESTERSDE.Worc_addresses add_number [st_number] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses add_number [st_number] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses add_number_1 [add_number] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses external_nguid_1 [external_nguid] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses add_number [add_number_1] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses external_nguid [external_nguid_1] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses lst_name [st_name] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses lst_type [st_type] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses lst_type [st_type] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses lst_predir [st_prefix] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses dateupdate "Now ( )" VB #
CalculateField sde.WORCESTERSDE.Worc_addresses lst_name [st_name] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses lst_type [st_type] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses Community [comunity_l] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses add_number [st_number] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses lst_predir [st_prefix] VB #
CalculateField sde.WORCESTERSDE.Worc_addresses lst_posdir [st_suffix] VB #
Append 'S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses' "Database Connections\Connection_UN_WORCESTERSDE_get2worcester.sde\sde.WORCESTERSDE.Street_Network\sde.WORCESTERSDE.Worc_addresses" NO_TEST "discrpagid "discrpagid" true true false 75 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,discrpagid,-1,-1;dateupdate "dateupdate" true true false 8 Date 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,dateupdate,-1,-1;site_nguid "site_nguid" true true false 254 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,site_nguid,-1,-1;country "Country" true true false 2 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,country,-1,-1;state "State" true true false 2 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,state,-1,-1;county "County" true true false 40 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,county,-1,-1;addcode "addcode" true true false 6 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,addcode,-1,-1;inc_muni "inc_muni" true true false 100 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,inc_muni,-1,-1;uninc_muni "uninc_muni" true true false 100 Text 0 0 ,First,#;addnum_pre "addnum_pre" true true false 15 Text 0 0 ,First,#;addnum_suf "addnum_suf" true true false 4 Text 0 0 ,First,#;st_premod "st_premod" true true false 15 Text 0 0 ,First,#;st_predir "st_predir" true true false 9 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_prefix,-1,-1;st_pretyp "st_pretyp" true true false 50 Text 0 0 ,First,#;st_presep "st_presep" true true false 20 Text 0 0 ,First,#;st_name "st_name" true true false 60 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_name,-1,-1;st_postyp "st_postyp" true true false 50 Text 0 0 ,First,#;st_posdir "st_posdir" true true false 9 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_suffix,-1,-1;st_posmod "st_posmod" true true false 25 Text 0 0 ,First,#;lst_predir "lst_predir" true true false 2 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_prefix,-1,-1;lst_name "lst_name" true true false 75 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_name,-1,-1;lst_type "lst_type" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_type,-1,-1;lst_posdir "lst_posdir" true true false 2 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_suffix,-1,-1;unit_type "unit_type" true true false 75 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,unit_type,-1,-1;unit_number "unit_number" true true false 75 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,unit_number,-1,-1;landmkname "landmkname" true true false 150 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,landmkname,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,last_edited_date,-1,-1;photo_front "PHOTO_FRONT" true true false 255 Text 0 0 ,First,#;photo_back "PHOTO_BACK" true true false 255 Text 0 0 ,First,#;photo_right "PHOTO_RIGHT" true true false 255 Text 0 0 ,First,#;photo_left "PHOTO_LEFT" true true false 255 Text 0 0 ,First,#;photo_front_link "PHOTO_FRONT_LINK" true true false 255 Text 0 0 ,First,#;photo_back_link "PHOTO_BACK_LINK" true true false 255 Text 0 0 ,First,#;photo_right_link "PHOTO_RIGHT_LINK" true true false 255 Text 0 0 ,First,#;photo_left_link "PHOTO_LEFT_LINK" true true false 255 Text 0 0 ,First,#;zipcode "ZIPcode" true true false 5 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,zipcode,-1,-1;zip_src "ZIP_SRC" true true false 50 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,zip_src,-1,-1;veriftime "VerifTime" true true false 8 Date 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,veriftime,-1,-1;veriftype "VerifType" true true false 50 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,veriftype,-1,-1;photo_status "PHOTO_STATUS" true true false 8 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,photo_status,-1,-1;labrotate "Labrotate" true true false 4 Long 0 10 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,labrotate,-1,-1;inset "Inset" true true false 4 Long 0 10 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,inset,-1,-1;maptype "Maptype" true true false 12 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,maptype,-1,-1;comunity_l "comunity_l" true true false 20 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,comunity_l,-1,-1;comunity_r "comunity_r" true true false 20 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,comunity_r,-1,-1;full_address "Full_address" true true false 250 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,full_address,-1,-1;st_number "ST_NUMBER" true true false 5 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_number,-1,-1;cityl "CityL" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,cityl,-1,-1;cityr "cityr" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,cityr,-1,-1;street_unit "street_unit" true true false 15 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,street_unit,-1,-1;tracking_dm "tracking_dm" true true false 50 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,tracking_dm,-1,-1;notes_dm "notes_dm" true true false 100 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,notes_dm,-1,-1;Nguid_num "Nguid_num" true true false 4 Long 0 10 ,First,#;st_prefix "st_prefix" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_prefix,-1,-1;st_type "st_type" true true false 15 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_type,-1,-1;st_suffix "st_suffix" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_suffix,-1,-1;st_num_suffix "st_num_suffix" true true false 10 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_num_suffix,-1,-1;Community "Community" true true false 40 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,comunity_l,-1,-1;add_number "add_number" true true false 10 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_number,-1,-1;external_nguid "external_nguid" true true false 4 Long 0 10 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,external_nguid,-1,-1" #
Append 'S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses' "Database Connections\Connection to WCDBSVR2_notDataowner.sde\sde.WORCESTERSDE.Street_Network\sde.WORCESTERSDE.Worc_addresses" NO_TEST "discrpagid "discrpagid" true true false 75 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,discrpagid,-1,-1;dateupdate "dateupdate" true true false 8 Date 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,dateupdate,-1,-1;site_nguid "site_nguid" true true false 254 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,site_nguid,-1,-1;country "Country" true true false 2 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,country,-1,-1;state "State" true true false 2 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,state,-1,-1;county "County" true true false 40 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,county,-1,-1;addcode "addcode" true true false 6 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,addcode,-1,-1;inc_muni "inc_muni" true true false 100 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,inc_muni,-1,-1;uninc_muni "uninc_muni" true true false 100 Text 0 0 ,First,#;addnum_pre "addnum_pre" true true false 15 Text 0 0 ,First,#;add_number "add_number" true true false 4 Long 0 10 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_number,-1,-1;addnum_suf "addnum_suf" true true false 4 Text 0 0 ,First,#;st_premod "st_premod" true true false 15 Text 0 0 ,First,#;st_predir "st_predir" true true false 9 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_prefix,-1,-1;st_pretyp "st_pretyp" true true false 50 Text 0 0 ,First,#;st_presep "st_presep" true true false 20 Text 0 0 ,First,#;st_name "st_name" true true false 60 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_name,-1,-1;st_postyp "st_postyp" true true false 50 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_type,-1,-1;st_posdir "st_posdir" true true false 9 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_suffix,-1,-1;st_posmod "st_posmod" true true false 25 Text 0 0 ,First,#;lst_predir "lst_predir" true true false 2 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_prefix,-1,-1;lst_name "lst_name" true true false 75 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_name,-1,-1;lst_type "lst_type" true true false 4 Text 0 0 ,First,#;lst_posdir "lst_posdir" true true false 2 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_suffix,-1,-1;unit_type "unit_type" true true false 75 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,unit_type,-1,-1;unit_number "unit_number" true true false 75 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,unit_number,-1,-1;landmkname "landmkname" true true false 150 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,landmkname,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,last_edited_date,-1,-1;external_nguid "external_nguid" true true false 300 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,external_nguid,-1,-1;photo_front "PHOTO_FRONT" true true false 255 Text 0 0 ,First,#;photo_back "PHOTO_BACK" true true false 255 Text 0 0 ,First,#;photo_right "PHOTO_RIGHT" true true false 255 Text 0 0 ,First,#;photo_left "PHOTO_LEFT" true true false 255 Text 0 0 ,First,#;photo_front_link "PHOTO_FRONT_LINK" true true false 255 Text 0 0 ,First,#;photo_back_link "PHOTO_BACK_LINK" true true false 255 Text 0 0 ,First,#;photo_right_link "PHOTO_RIGHT_LINK" true true false 255 Text 0 0 ,First,#;photo_left_link "PHOTO_LEFT_LINK" true true false 255 Text 0 0 ,First,#;zipcode "ZIPcode" true true false 5 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,zipcode,-1,-1;zip_src "ZIP_SRC" true true false 50 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,zip_src,-1,-1;veriftime "VerifTime" true true false 8 Date 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,veriftime,-1,-1;veriftype "VerifType" true true false 50 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,veriftype,-1,-1;photo_status "PHOTO_STATUS" true true false 8 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,photo_status,-1,-1;labrotate "Labrotate" true true false 4 Long 0 10 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,labrotate,-1,-1;inset "Inset" true true false 4 Long 0 10 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,inset,-1,-1;maptype "Maptype" true true false 12 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,maptype,-1,-1;comunity_l "comunity_l" true true false 20 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,comunity_l,-1,-1;comunity_r "comunity_r" true true false 20 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,comunity_r,-1,-1;full_address "Full_address" true true false 250 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,full_address,-1,-1;st_number "ST_NUMBER" true true false 5 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_number,-1,-1;cityl "CityL" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,cityl,-1,-1;cityr "cityr" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,cityr,-1,-1;street_unit "street_unit" true true false 15 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,street_unit,-1,-1;tracking_dm "tracking_dm" true true false 50 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,tracking_dm,-1,-1;notes_dm "notes_dm" true true false 100 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,notes_dm,-1,-1;Nguid_num "Nguid_num" true true false 4 Long 0 10 ,First,#;st_prefix "st_prefix" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_prefix,-1,-1;st_type "st_type" true true false 15 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_type,-1,-1;st_suffix "st_suffix" true true false 4 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_suffix,-1,-1;st_num_suffix "st_num_suffix" true true false 10 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,st_num_suffix,-1,-1;Community "Community" true true false 40 Text 0 0 ,First,#,S:\ComprehensivePlanning\Data Merge\addressdatamerge\Datamerge_addresspts.gdb\TOC_addresses,comunity_l,-1,-1" #
20220321
08061200
20220321
08061200
Version 6.2 (Build 9200) ; Esri ArcGIS 10.8.1.14362
Worcester Co Address Points
1
-75.644827
-75.050085
38.459475
37.986846
Worcester County
MD
Address Points
E911 addresses
Worcester County Address points data. A point located on a building or property that has an assigned address as per Worcester County MD.
SDE Feature Class
dataset
EPSG
4.5(3.0.1)
53590
Simple
FALSE
53590
TRUE
FALSE
sde.WORCESTERSDE.Worc_addresses
Feature Class
53590
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
discrpagid
discrpagid
String
75
0
0
dateupdate
dateupdate
Date
8
0
0
site_nguid
site_nguid
String
254
0
0
country
Country
String
2
0
0
state
State
String
2
0
0
county
County
String
40
0
0
addcode
addcode
String
6
0
0
inc_muni
inc_muni
String
100
0
0
uninc_muni
uninc_muni
String
100
0
0
addnum_pre
addnum_pre
String
15
0
0
addnum_suf
addnum_suf
String
4
0
0
add_number
add_number
Integer
4
10
0
st_premod
st_premod
String
15
0
0
st_predir
st_predir
String
9
0
0
st_pretyp
st_pretyp
String
50
0
0
st_presep
st_presep
String
20
0
0
st_name
st_name
String
60
0
0
st_postyp
st_postyp
String
50
0
0
st_posdir
st_posdir
String
9
0
0
st_posmod
st_posmod
String
25
0
0
lst_predir
lst_predir
String
2
0
0
lst_name
lst_name
String
75
0
0
lst_type
lst_type
String
4
0
0
lst_posdir
lst_posdir
String
2
0
0
unit_type
unit_type
String
75
0
0
unit_number
unit_number
String
75
0
0
landmkname
landmkname
String
150
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
external_nguid
external_nguid
String
300
0
0
photo_front
PHOTO_FRONT
String
255
0
0
photo_back
PHOTO_BACK
String
255
0
0
photo_right
PHOTO_RIGHT
String
255
0
0
photo_left
PHOTO_LEFT
String
255
0
0
photo_front_link
PHOTO_FRONT_LINK
String
255
0
0
photo_back_link
PHOTO_BACK_LINK
String
255
0
0
photo_right_link
PHOTO_RIGHT_LINK
String
255
0
0
photo_left_link
PHOTO_LEFT_LINK
String
255
0
0
zipcode
ZIPcode
String
5
0
0
zip_src
ZIP_SRC
String
50
0
0
veriftime
VerifTime
Date
8
0
0
veriftype
VerifType
String
50
0
0
photo_status
PHOTO_STATUS
String
8
0
0
labrotate
Labrotate
Integer
4
10
0
inset
Inset
Integer
4
10
0
maptype
Maptype
String
12
0
0
comunity_l
comunity_l
String
20
0
0
comunity_r
comunity_r
String
20
0
0
full_address
Full_address
String
250
0
0
st_number
ST_NUMBER
String
5
0
0
cityl
CityL
String
4
0
0
cityr
cityr
String
4
0
0
street_unit
street_unit
String
15
0
0
tracking_dm
tracking_dm
String
50
0
0
notes_dm
notes_dm
String
100
0
0
20220321
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiioWlKXSRnkOCRx0xigErkxIAyTgVG8
vlxl2XgHse3rSTzxQwmSQ/J0OBmoBdeerNF5RiAAyzd/Sk2UkTXE/koSE3Htk4H51SbVXgk2XNuY
s9DuB4qN5t7TJaxiUKFKqDlc+tV7+aKRFZRuuEHznbwPrWcpPoaRgtmi0+shIixVC27hc8ketXYW
uHw7iMIecDOcVnX8e6z8yQbpdvARchR15qvbXrpbQb5pTCBiQbfmU4z1Hajmaeo+RNXRsz3BVlig
KPMT90noO5rPl1W5TUWtkhjYBwqnPLfT6d6rfaGluTPawBAECbjjK8E/ruH5VoQ3lrfTogiYuoyH
28A45GaOa+zFy8u6uaNMmcxwu6gEgZwTin02QAxsCu4Y6etamKMWw1e4uL5YXVNjdD3rcrC062Vd
TDpC0K4Pyk5rdrOne2ppVtfQKKKK0MwooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooAKKKKACobpHe1lWLiQqQpHWpqhublLWIO4Y5YKAoySTSew1e+hnTXhnj+yxxOvBE4VdxT
J/XueM1JLYi9B+fy4gwBUJjIH4+tV1e9t52uzEkcTkmVQwIz2J4yOMf5zWha3dveK6IuCPvoQO/0
4NZqz0Zq7x1iVZYG05WmhuECEYZZj19AD2plq4t7LNzbOUcbi+CxPfkYzWjdL5kPlhQ+4gFSccd6
jkS4bMSPiPb99eH+g7U3Gz0EpXWpim6t5swgtMJm3OIzhj6DBA/Kh7QtblZGeK1/gZyjH6Y/DtWm
jLZyvAqbSB5gZ8MX9QMVk6tfia4QqjBgpG1wcD3x2P1rOSSV2axbbsi7Dp1vdJsE0L7duCqjcB3B
H+etW/sEEEibXIZmIAdj6HgD6Zrk5GJYN5jKrA7CAMgk9McD8fauj0XVPtIFtM26VBkNg/MPx+v4
0QlFu1gqQkldMvRXHlz/AGeVSp/hbBw56k+3Oe9WJS4iYxqGfHAJ60bpN5GwbcjDbuoomcxwu6jJ
UZArfoc/UytLikGo3LsmwAbSu4nn8a2Kz9JJkgkmYfPJISeK0KUNh1H7wUUUVRAUUUUAFFFFABRR
RQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABVe4tIrnl92ccYYjHvViihq402tiuII
pIFTdvQHnB+9jscf54pJLOF2Z1ASUgfOOvHSn+REWbrkncQGxz60x7SIs3Em6TqwY8VNh38zKuY5
YbyFZJTchshVGAw7dauw6gsWyGSCWPAwCR1x2FTfZILdvPVSzqCQCepJphke4tywyjpzhhj8KlJo
0bUkVb24jkvLeORJIn3HnOOMdaZNNFfGVHkRIk+6+AWPas25maWIs0hkk8zBP9wd8VOJYJbRpEgJ
lC7C3XHoaz5rs15LJGZITLcBZsuoGz5RjA9fftWnosEMl4su6XdtDKAMAY45P9PepTDPaKZIhFJA
RliUDEcf/WH507zsWswSMpdI5kMa4BI5Ax/PHtUxjZ3Y5SurI36r3bgW8iLy5GAB71j2muOLQCQb
pvMC5Y8YP/1qvX2JLqGLY2XIywx071tzprQw9m4y1LtrH5VrEmMYUcVLQBgYorQyeoUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUhIAyTgUhkQOELqGIzjPNQ
XUAmVSWCoCC5z2HP86TY0u4ki/Z52uQ+EYYkB9uhFNa6M6MLfhgcEtwR+FVJg0+9IA8luuA3PJ4H
3fwzV9ooWO1WVZVAAIPI9Km99i7JbkRFwsY3Kk0mPlzxn61QvrwR6ekcsR84nJRTjFaKyTxZWQCR
s4UgYJrJ1eyk3C5d3PPO0ZAFTO9tCqdnLUggvDdI4EZbLjMQ6fia1NNhihLqsO2RgcccEVi2wa2u
R+7lyvIUL1Poa2NNWc7dzYAJJAP3f9kiog9dTSorLQbc6SRGEtmZCxIbngA9qzrq1uLZ98rM5BHz
454PA/L+VbF1Pc+SIjFtkc7VkDYGe1Q+ZJfNNZkLH5YJkYc/Men+NVKK6ExlJbmLbSFXiUxbypwq
AZDED/8AXXTRHzr2R+cRfKARxn2qHS7AWtsglVTIhO1sc4P8q0cAdBTpwaWpNWab0CiiitTEKKKK
ACiiigAooooAKKKKACiiigAooooAKKKQsFBLEADqTQAtFRtMivsJ+bGcCmS3aQMokDKrdGxx/jSu
h2ZPRUNvcxXSF4W3KDtzjHNKsxNw8TKowAVO7kj6UXQWZLRSHduGMbcc0LnaN2N2OcdKYhaKRd2P
mxnPaloAKMjOKKpxokmpTOU+ZAoDYpNjSuLdxLJLEZIt8Yzk+lQrb72fcWjtVAATPDD19qluIAJB
IWlZSeUUZzx+lWwAFAxgelK12VeyGuwijJxwOg9fQVSltZZwJtixXCNkYPBPGTn8xV0R/vWcsSCA
NvYYz/jTi6hgpYAnoPWm1fcSdtirBvlWMzZWVePlY4PrTr9S1o2EZyCDtXqcdqSe5WG4VWfHyk4I
OPzrOZLp5PtEMhRJTtVGLAkf0NQ3ZWLSu7k0FqLpUvI5WScjnnOPY1HdWM0U4lhcDe3zNjhOeMCt
C2iht1IACv8Ax5bJ/OpUPmruyNpGMA5H1zRypoOdp+Rg3VxdE7Z2w6zBVIXjGDz696s6XBJHcXCS
xOfmOJSMH8+9Wbiwgld/Mm2/JzzyB659O1Xo0EcSIOigCkoO92OU1y2QqrtUDJOPU0tFFamIUUUU
AFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFRzR+bA8f8AeUipKKAM2LS4ivmhGhmLbvlY/KQMVKsU
slzG0uQUQjco75/wq5g7gc8elAGGJyee1TyovnbM1bS9S9d47gCMtkggVYmtp5HDrcKpHQGMHFWf
lD9PmbvjrSk4BOCcelHKgcmVUKM4tM8xYJBPLY5yPxxVlI1jUqgwCSfxPNIVLEMpCkjk45/z1qrH
dzNfSRtGggXI8zd344/WjbcWr2J/P8sMZtqgYGQc8mnu7KyBULBjgnP3RUNxIUeNUhLlmz0Hb3qa
OQSbuMYOKfkFupHLESrYUMCQdvTn39aggkZZzkRr5h7ZOfx6Vaysy8E8HscVTgt4YZVjQHcG3ks2
efSk9xrbUnvYmkgbZktjAXPBz3/CiBhHGVZlCxjnAIA/E9adcKzbNpOM8gDI+p/z3przQrHHIzER
nhVA70dbgtrE0sqQx73Py8cgVkXMRu9UintTu8vG5gflx/U/4Va/d3+6DJFuoHAyCeP5f4VVeFbS
/MUZljMuBEQflB5zx0qZO/oVBW9SaeCCR0muI98TNkkgja3TPParlrI8mSCjQ/wMp/SmxmfJWSIZ
zzzkNx29KsJGka7UUKvoKaWtyZPSwjQo7EsoORg5ps7iO3kbONqk9cU+QsI2KY3AcZ6VgRPPqVuU
8txKh2qwfjGepolK2gRjfVmmZFmaJUlYGQhnXd/DtPT8cdKvVSsraQRh7pAZQeMnO3jHHpViKbzZ
JlCnEbbc+pwD/WnHzFLyJaKKKokKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCOWPeFI
LAqdw2nGfaopzKs0LrIqoPvqT2qzUM1vHMG3oGJGOaTQ0+4wz7px5eWRc7yDwKsA5AI71WsIjDbe
W0YRlJBx396tUIJWvZBWRf2N1LZttfzJQ5x2+XIP58CtZiQpIGTjgetQ75tqllRCWwct0H+OaUkn
oxxbTuinaTo5jjklG6NVHz9S3cfyq/LLHAAz8BiFziqc9v5bQzMUbyslmI5P4Uryi5ZUMZKsCQcd
AKSbWhTSbuPYLazO6RHa65znjPpinrCZ1jknADgcgVXkikuhEjMNqkEqe+PWrs8y28DzPnagycUI
T8tyK4kKI8YBT5TtfGRRa5htIlfJCqBn1qBFTUoU8/cvfbnGamW2eFl8qVygbOwnt9f1o63G7JWH
XDBbZpwvKjf6Hj/61RvHBezIxZ90ZPA6A/5NNnmkkMlqyGMuCEk6g/5FWIS4g3EIzdfk6GnuxbIc
ABtUYYpgEt1qSmLJukdcfdxT6olkF5IYbSSQAttHQDOaj0xQunxYUqCM4Iq3RStrcL6WGu22NmUb
iAcAdz6Uy2i8mBVP3j8zH3PJqCS3AnTy0ALSBiwJ6DmrlC3G9EFFFFMkKKKKACiiigAooooAKKKK
ACiiigAooooAKKKKACiiigAooooArXIugQYHQLkZ3Dmp1LE8jAx+Oaiu03wHlwVIIKdc1Mudgz1x
zxS6lPYWqM9qHkklmy6DBRC2Bnn/ABq9UbSjzhEoDHGW5+6KGriTa2KZVrsiR1CsMhFJyB06+/FS
rLvj8u4BEgPIXofxFJd24kceXlZTyDg4/E0+1A3MG2NKv3mQcc84qepb2K8pmt5hMxVYARlc8im2
0gvppHd/3WdqoG6/UUapa/bHijR9r55Iz0qDT7IRyvBKrIyjAZOAR659al35rdClblv1NSGIRYQR
gIgwhzk4pLedJml2tyrlSuemOP6VBdW7C0VUkl2qcsVbLEZ/WpIrZLKKRoAxBy2wnqfrV63I0sNu
ZojPbxsGJMmQMemanconCsqPtwuelUhMj36zyxmNFBSORmGGJPYVoKMoN21jjkgcULUHpYbEm0bi
QzN1I71JR0oqiAooooATaNwbHIGM0tFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUA
FFFFABRRRQBWtlcTXGSxTf8AKGzx69alEymcxAjIGSM8/lSb9tyUaQfMMqp61AJ4kV1gIaQHB3HJ
HufapvYq1yxkSMpSXhT8wUg59jS7QhJRBliN3b8aZDAkWGwvmbcFhxmpqaExmS6gjhSOc5BFVrm6
FuFWNQzv0A5J/wA+tWXZgvyLuJ468UqIqKFHQdKGCstyhZRLDK80jKZphvIVTnHpzzU8ktt54Dyb
ZCuMEY4Pv2qWWOLyiG+RfVTjH41Db26AvIudr8FWXqPxqbW0RV09WTW8axRbEkaQAnknOPao7qTy
VdpJNkRXbvyPlPPP8qrFEilc2beVL1McgIV/w/qKfHci88ksiL8x+WTnJA7fnRfoO2tx85az09RA
qMyABd5wKbpSSi2LysxZ2JGTkY7EDsKdcW6LBcP5Zld1+YDqwH6VbX7ox6U0tRN+6LRRRVEBRRRQ
AUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFBIAyTgCgBkoJTKrll5A
zjNReThDKsKCcjnv+tH223wCZAAQWyfQU2WS4kVTa+XgjO5v5YqW0UkyztBIYgbgMZqGRjcwypEx
UkEB+2ap4vEuoRNcYDnBVFG31x69qmuZIkG1i8RjPybTjfn0pXHyi2AEMRiaQMxckHOSQc4/lVp2
ZVJVdx9AarSQs9t5kmFn8vDEHj1qC2jFxlxJIuOjAnr3ovbQGr6lm4nK2ZkMZyeNpFSwgqir1AUf
MeP0rMuLMyzIiyysjYDSF+/sKuLDJaA+U2+POdrckevNCbuNpWHyWiTSlpfnXOVU9BxTpk2wSlAd
wQ7QO3HaiNA8hm556DNTVVibkcI+RWYDzCoDGpKQKBnAxk5NLTJCiiigAooooAKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAKQkAZJApaQgMMEZFAEVxcpbKGcEj2rH1XU3kiWG1Vw
WGSSMZFXJbGD7dG7ykLtOI88Ajv+lRXdrLczi5gZdgUBecgj1FZS5mrG0OVNMx4S0iFJCRKi/KW+
6FH8+a1bG4iRUKwuHHys3Y+tJc6fFbojqmQgB3N0yT3qRy1mJpdpj3cnaMox/nURTjuaSkpLQluJ
IfMlhiUm5ZcgnOPzpYYp5nS68+N+BhSnQVFHexyTEyeaEbaYzsIwcdKtw2skMRxKPMJG444IHHT6
CtFqZPRWHNJcHcREhToBnJNMkE6ygQqkSvje7HPPoB606O7tgrJGflQ7BgEgnGeKa1u15CpuN0Zz
nYrdPrT32J23JG/clY4wdznk44HrUylivzLg+mazEW4tnmk8/wAxYR0kHbrwas2t3NKrNNCEUKGB
U5zQmDjoWkjWMYRQB1wKdUcU8c27YSdpwQQRj86kqyH5hRRRQAUUUUAFFFFABRRRQAUUUUAFFFFA
BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFACE4KjBOTjjtTZHUKwMqoQOTkcU+qUqLbyk+WhRwFjUAD
DYPftngUm7DSuRIWu9RdlUBYiEbJ5P5VZheMyNAqqMZyuCOP61WiT+z5WiUuVk+YMYy2G9CRU1xL
G+SS8bRHIcpjn0GetSjR6+guoQpJYOpUkKAQFGTx6VEblx8gtmZFAIVThh9RUIjuzaASSRr5rgkN
Hgjn3b2pzTSLdySlo0KJ8qTDb8vrkE9/ak31BLS25cUrcJiRdoZf9WepHr6iqwiuXdcTSwQITjdt
yegAPXI606S8G63fABbngb/l9Rjt05q4XVlAwTkkAFT1H/6utPRk6or/ALqwC7gcMPmk7kjpmlkv
AsBkMcqcHG5c/wAqit4J2uRPKSNoMezP8Prz1ycc8VYnjkljA2Rkhs4Y5Bx07Ua2B2vqQB2/s95V
2ee/3sDHPoc1ahbMYViC68NgY5qAWmXaVo4VmJ4dVzj86tAYHv3PrTSYpNAEVSxAALdT60tFFUSF
FFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFMkTftBUFQwJ5
xjHI/WiigBw3c5x14x6UMoYYPSiigBHRZEKuMqe1DRo5UsisVOVJGcUUUAOooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA/9k=