20230113
14441000
1.0
FALSE
CreateFeatureclass "\\cdallend3585\MapFiles\EulessProjects\HTE Suites\LandRecords.sde" SuiteAppTEMP Point # No Yes "PROJCS["NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet",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",1968500.0],PARAMETER["False_Northing",6561666.666666666],PARAMETER["Central_Meridian",-98.5],PARAMETER["Standard_Parallel_1",32.13333333333333],PARAMETER["Standard_Parallel_2",33.96666666666667],PARAMETER["Latitude_Of_Origin",31.66666666666667],UNIT["Foot_US",0.3048006096012192]];-123407700 -86123500 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # # # # "Suites / Apartments TEMP"
UpdateSchema "\\cdallend3585\MapFiles\EulessProjects\HTE Suites\LandRecords.sde\SuiteAppTEMP" <operationSequence><workflow><AddField><field_name>Unit_Num</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>Unit_Type</field_name><field_type>TEXT</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow><workflow><AddField><field_name>HTE_Num</field_name><field_type>Long</field_type><field_is_nullable>TRUE</field_is_nullable><field_length>255</field_length></AddField></workflow></operationSequence>
UpdateSchema "\\cdallend3585\MapFiles\EulessProjects\HTE Suites\LandRecords.sde\SuiteAppTEMP" <operationSequence><workflow><AlterField><field_name>OBJECTID</field_name><field_alias>OBJECTID</field_alias></AlterField></workflow><workflow><AlterField><field_name>SHAPE</field_name><field_alias>SHAPE</field_alias></AlterField></workflow></operationSequence>
Append Apartment_Units "\\cdallend3585\MapFiles\EulessProjects\HTE Suites\LandRecords.sde\LandRecords.DBO.SuiteAppTEMP" "Use the field map to reconcile field differences" "Unit_Num "Unit_Num" true true false 255 Text 0 0,First,#,Apartment_Units,Unit_Number,0,50;Unit_Type "Unit_Type" true true false 255 Text 0 0,First,#,Apartment_Units,UnitType,0,50;HTE_Num "HTE_Num" true true false 255 Long 0 0,First,#" # #
Append SuitePoints_North "\\cdallend3585\MapFiles\EulessProjects\HTE Suites\LandRecords.sde\LandRecords.DBO.SuiteAppTEMP" "Use the field map to reconcile field differences" "Unit_Num "Unit_Num" true true false 255 Text 0 0,First,#,SuitePoints_North,SuiteNum,0,255;Unit_Type "Unit_Type" true true false 255 Text 0 0,First,#;HTE_Num "HTE_Num" true true false 255 Long 0 0,First,#,SuitePoints_North,HTE_IndexNum,-1,-1" # #
SpatialJoin "Suites / Apartments TEMP" LandRecords.DBO.Cadastre "\\cdallend3585\MapFiles\EulessProjects\HTE Suites\LandRecords.sde\LandRecords.DBO.SuiteApt" "Join one to one" KEEP_ALL "Unit_Num "Unit_Num" true true false 255 Text 0 0,First,#,Suites / Apartments TEMP,Unit_Num,0,255;Unit_Type "Unit_Type" true true false 255 Text 0 0,First,#,Suites / Apartments TEMP,Unit_Type,0,255;HTE_Num "HTE_Num" true true false 255 Long 0 0,First,#,Suites / Apartments TEMP,HTE_Num,-1,-1;Prop_Des_1 "Prop-Des-1" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Prop_Des_1,0,255;Prop_Des_2 "Prop-Des-2" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Prop_Des_2,0,255;Acreage "Acreage" true true false 8 Double 8 38,First,#,LandRecords.DBO.Cadastre,Acreage,-1,-1;DU "DU" true true false 2 Short 0 5,First,#,LandRecords.DBO.Cadastre,DU,-1,-1;PlatStatus "PlatStatus" true true false 2 Short 0 5,First,#,LandRecords.DBO.Cadastre,PlatStatus,-1,-1;UseCode "UseCode" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,UseCode,0,255;Prefix "Prefix" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Prefix,0,255;StName "StName" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,StName,0,255;Suffix "Suffix" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Suffix,0,255;SufDir "SufDir" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,SufDir,0,255;Lotno "Lotno" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Lotno,0,255;BlkNo "BlkNo" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,BlkNo,0,255;Prop_Add "Prop_Add" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Prop_Add,0,255;Addno "Addno" true true false 4 Long 0 10,First,#,LandRecords.DBO.Cadastre,Addno,-1,-1;EKEY "EKEY" true true false 4 Long 0 10,First,#,LandRecords.DBO.Cadastre,EKEY,-1,-1;GeoReference "GeoReference" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,GeoReference,0,255;YearBuilt "YearBuilt" true true false 2 Short 0 5,First,#,LandRecords.DBO.Cadastre,YearBuilt,-1,-1;PoliceDist "PoliceDist" true true false 50 Text 0 0,First,#,LandRecords.DBO.Cadastre,PoliceDist,0,50;CityOwned "CityOwned" true true false 50 Text 0 0,First,#,LandRecords.DBO.Cadastre,CityOwned,0,50;SKEY "SKEY" true true false 50 Text 0 0,First,#,LandRecords.DBO.Cadastre,SKEY,0,50;VacIndexNum "Vacant Lot Index Number" true true false 50 Text 0 0,First,#,LandRecords.DBO.Cadastre,VacIndexNum,0,50;FireDist "FireDist" true true false 2 Short 0 5,First,#,LandRecords.DBO.Cadastre,FireDist,-1,-1;PropertyZipPlus "PropertyZipPlus" true true false 50 Text 0 0,First,#,LandRecords.DBO.Cadastre,PropertyZipPlus,0,50;PropZip "PropZip" true true false 4 Long 0 10,First,#,LandRecords.DBO.Cadastre,PropZip,-1,-1;HTE_IndexNum "HTE_IndexNum" true true false 4 Long 0 10,First,#,LandRecords.DBO.Cadastre,HTE_IndexNum,-1,-1;SuiteNum "SuiteNum" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,SuiteNum,0,255;Owner_Name "Owner Name" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Owner_Name,0,255;Owner_Address "Owner Address" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Owner_Address,0,255;Owner_CityState "Owner City State" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Owner_CityState,0,255;Owner_Zip "Owner Zip" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Owner_Zip,0,255;Owner_Zip4 "Owner Zip +4" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Owner_Zip4,0,255;Situs_Address "Situs Address" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,Situs_Address,0,255;SB247_Flag "SB247 Flag" true true false 255 Text 0 0,First,#,LandRecords.DBO.Cadastre,SB247_Flag,0,255" Intersect # #
CalculateField LandRecords.DBO.SuiteApt HTE_IndexNum $feature.HTE_Num Arcade # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/3.0.0'><WorkspaceConnectionString>SERVER=maps2;INSTANCE=sde:sqlserver:maps2\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=maps2\sqlexpress;DATABASE=LandRecords;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>LandRecords.DBO.SuiteApt</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Join_Count</field_name><field_name>TARGET_FID</field_name><field_name>HTE_Num</field_name></DeleteField></workflow></operationSequence>
Copy "C:\arcgisserver\WebMapDocsPro\GoGovBaseMap\LandRecords.sde\SuiteApt " C:\arcgisserver\WebMapDocsPro\GoGovBaseMap\LandRecords.sde\LandRecords.DBO.SuiteApt_1 FeatureClass #
Rename C:\arcgisserver\WebMapDocsPro\GoGovBaseMap\LandRecords.sde\LandRecords.DBO.SuiteApt_1 C:\arcgisserver\WebMapDocsPro\GoGovBaseMap\LandRecords.sde\LandRecords.DBO.Suites FeatureClass
UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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/2.4.0'><WorkspaceConnectionString>SERVER=maps2;INSTANCE=sde:sqlserver:maps2\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=maps2\sqlexpress;DATABASE=LandRecords;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>LandRecords.DBO.Suites</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Unit_Type</field_name><new_field_name>Asset_ID</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
Rename "C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp18220\64edb259-a287-4103-8de0-32da53e1ab1f\Land Records.sde\LandRecords.DBO.Suites" "C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp18220\64edb259-a287-4103-8de0-32da53e1ab1f\Land Records.sde\LandRecords.DBO.Suites" FeatureClass
Rename "C:\arcgisserver\WebMapDocsPro\SQL_IMPORT_TEST_DELETE\LandRecords (3).sde\LandRecords.DBO.Suites" "C:\arcgisserver\WebMapDocsPro\SQL_IMPORT_TEST_DELETE\LandRecords (3).sde\LandRecords.DBO.SuitesOLD" FeatureClass
FeatureClassToFeatureClass C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.CadastreFeatures Suites # "Unit_Num "Unit_Num" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Unit_Num,0,255;Asset_ID "Unit_Type" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Asset_ID,0,255;Prop_Des_1 "Prop-Des-1" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Prop_Des_1,0,255;Prop_Des_2 "Prop-Des-2" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Prop_Des_2,0,255;Acreage "Acreage" true true false 8 Double 8 38,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Acreage,-1,-1;DU "DU" true true false 2 Short 0 5,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,DU,-1,-1;PlatStatus "PlatStatus" true true false 2 Short 0 5,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,PlatStatus,-1,-1;UseCode "UseCode" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,UseCode,0,255;Prefix "Prefix" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Prefix,0,255;StName "StName" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,StName,0,255;Suffix "Suffix" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Suffix,0,255;SufDir "SufDir" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,SufDir,0,255;Lotno "Lotno" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Lotno,0,255;BlkNo "BlkNo" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,BlkNo,0,255;Prop_Add "Prop_Add" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Prop_Add,0,255;Addno "Addno" true true false 4 Long 0 10,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Addno,-1,-1;EKEY "EKEY" true true false 4 Long 0 10,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,EKEY,-1,-1;GeoReference "GeoReference" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,GeoReference,0,255;YearBuilt "YearBuilt" true true false 2 Short 0 5,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,YearBuilt,-1,-1;PoliceDist "PoliceDist" true true false 50 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,PoliceDist,0,50;CityOwned "CityOwned" true true false 50 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,CityOwned,0,50;SKEY "SKEY" true true false 50 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,SKEY,0,50;VacIndexNum "Vacant Lot Index Number" true true false 50 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,VacIndexNum,0,50;FireDist "FireDist" true true false 2 Short 0 5,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,FireDist,-1,-1;PropertyZipPlus "PropertyZipPlus" true true false 50 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,PropertyZipPlus,0,50;PropZip "PropZip" true true false 4 Long 0 10,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,PropZip,-1,-1;HTE_IndexNum "HTE_IndexNum" true true false 4 Long 0 10,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,HTE_IndexNum,-1,-1;SuiteNum "SuiteNum" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,SuiteNum,0,255;Owner_Name "Owner Name" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Owner_Name,0,255;Owner_Address "Owner Address" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Owner_Address,0,255;Owner_CityState "Owner City State" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Owner_CityState,0,255;Owner_Zip "Owner Zip" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Owner_Zip,0,255;Owner_Zip4 "Owner Zip +4" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Owner_Zip4,0,255;Situs_Address "Situs Address" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,Situs_Address,0,255;SB247_Flag "SB247 Flag" true true false 255 Text 0 0,First,#,C:\Users\administrator.COE-NT\AppData\Local\Temp\2\ArcGISProTemp16988\609269c7-6cdf-4e98-a67a-5295ed962c7b\LandRecords.sde\LandRecords.DBO.SuitesOLD,SB247_Flag,0,255" #
AddFields LandRecords.DBO.Suites "Asset_ID TEXT 'Asset ID' 255 # #;LifeCycle TEXT 'Life Cycle' 255 # #" #
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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/3.0.0'><FeatureDataset>LandRecords.DBO.CadastreFeatures</FeatureDataset><WorkspaceConnectionString>SERVER=maps3;INSTANCE=sde:sqlserver:maps3\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=maps3\sqlexpress;DATABASE=LandRecords;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>LandRecords.DBO.Suites</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Unit_Type</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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/3.0.0'><FeatureDataset>LandRecords.DBO.CadastreFeatures</FeatureDataset><WorkspaceConnectionString>SERVER=maps3;INSTANCE=sde:sqlserver:maps3\sqlexpress;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=maps3\sqlexpress;DATABASE=LandRecords;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>LandRecords.DBO.Suites</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>LifeCycle</field_name><domain_name>LifeCycle</domain_name></AssignDomainToField><AssignDefaultToField><field_name>LifeCycle</field_name><default_value>ACT</default_value></AssignDefaultToField></workflow></operationSequence>
AddField "Database Connections\LandRecords.sde\LandRecords.DBO.CadastreFeatures\LandRecords.DBO.Suites" Owner-State TEXT # # # "Owner State" NULLABLE NON_REQUIRED #
LandRecords.DBO.Suites
002
Server=maps3; Service=sde:sqlserver:maps3\sqlexpress; Database=LandRecords; Version=dbo.DEFAULT
ArcSDE Connection
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_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/3.0.0'><WKT>PROJCS["NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet",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",1968500.0],PARAMETER["False_Northing",6561666.666666666],PARAMETER["Central_Meridian",-98.5],PARAMETER["Standard_Parallel_1",32.13333333333333],PARAMETER["Standard_Parallel_2",33.96666666666667],PARAMETER["Latitude_Of_Origin",31.66666666666667],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2276]]</WKT><XOrigin>-123407699.99998033</XOrigin><YOrigin>-86123499.999953434</YOrigin><XYScale>62499.99994179231</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.00012800000011920935</XYTolerance><ZTolerance>2</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102738</WKID><LatestWKID>2276</LatestWKID></ProjectedCoordinateSystem>
20230207
12334300
20230207
12334300
Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 20348) ; Esri ArcGIS 13.0.3.36057
Suites Address Points
City of Euless
Address points for suites and ROW address points.
Enterprise Geodatabase Feature Class
dataset
EPSG
5.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
LandRecords.DBO.Suites
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Unit_Num
Unit_Num
String
255
0
0
Asset_ID
Unit_Type
String
255
0
0
Prop_Des_1
Prop-Des-1
String
255
0
0
Prop_Des_2
Prop-Des-2
String
255
0
0
Acreage
Acreage
Double
8
38
8
DU
DU
SmallInteger
2
5
0
PlatStatus
PlatStatus
SmallInteger
2
5
0
UseCode
UseCode
String
255
0
0
Prefix
Prefix
String
255
0
0
StName
StName
String
255
0
0
Suffix
Suffix
String
255
0
0
SufDir
SufDir
String
255
0
0
Lotno
Lotno
String
255
0
0
BlkNo
BlkNo
String
255
0
0
Prop_Add
Prop_Add
String
255
0
0
Addno
Addno
Integer
4
10
0
EKEY
EKEY
Integer
4
10
0
GeoReference
GeoReference
String
255
0
0
YearBuilt
YearBuilt
SmallInteger
2
5
0
PoliceDist
PoliceDist
String
50
0
0
CityOwned
CityOwned
String
50
0
0
SKEY
SKEY
String
50
0
0
VacIndexNum
Vacant Lot Index Number
String
50
0
0
FireDist
FireDist
SmallInteger
2
5
0
PropertyZipPlus
PropertyZipPlus
String
50
0
0
PropZip
PropZip
Integer
4
10
0
HTE_IndexNum
HTE_IndexNum
Integer
4
10
0
SuiteNum
SuiteNum
String
255
0
0
Owner_Name
Owner Name
String
255
0
0
Owner_Address
Owner Address
String
255
0
0
Owner_CityState
Owner City State
String
255
0
0
Owner_Zip
Owner Zip
String
255
0
0
Owner_Zip4
Owner Zip +4
String
255
0
0
Situs_Address
Situs Address
String
255
0
0
SB247_Flag
SB247 Flag
String
255
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
20230207
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2/wA6
P+9R50f96qlFZgWvPj/vfpR58fr+lVaKYHO+LfCcOuyx6jYXH2PV4F2pPtysi/3XHcfyrj5IPFlo
3lT+HDcuOPNtLhSje+GwRXqVFcmIwVHEO9SN2dFLE1KStBnmtp4T1/xE4TWFXSdMJ/ewRSb55h/d
LDAUH2ya9Ms47TT7OG0tYRFBCoSNFGAoHam0VrRoU6MeSmrIzqVZ1XzTdyx9oT0b8qPtC+jVXorU
zLH2hf7po+0D+6ar0UAT/aP9n9aPtH+z+tQUUAT/AGn/AGP1rh9f8Dm51KXVdBul068mO64iZN8N
wfVl4w3uCPxrsaKmUIzi4zV0yoycHeLszzT/AIR7xuzbPL0VB083zJG/Hbj+tdF4a8GxaPenVNQu
TqOqldqzOoVIQeojXt9etdTRWNHCUaD5qcUma1MRVqK0pXJvtDegpPtD+gqKiugxJftD+i0faH9F
/KoqKAIdStYNX0+ewvoUmtpl2ujDqK85n8M+JNAYxWMaaxp6/wCqDS7J0HoSeGx68V6ZRWNbD068
eWoro0pVZ0neDPL4LPxdqD+Tb+HhZses15cLtX3wuSf0rtvCXg+Lw6s11c3BvdVucfaLplxwOiqP
4VHpW/bffarFRQwVHD6042ZVbEVKvxsKKKSukwFqWNg6+W34VEKKYCspVsGgVL/ro/8AaFRCgAoo
ooAKKKKACiiigCjRRRSGFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRR
RQBJb/farNVrf/WN9Ks0xBSGloNIAFFAooAmg+8fpUIqW3++fpUQpgLRRRQAUUUUAFFFFAFGiiik
MKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCS3/1p+lWaqwf64/S
rVMQUGig0gAUUCigCW3++fpUVSwffP0qI9aYC0UCikAUUUUwCiiigCjRRRSGFFFFABRRRQAUUUUA
FFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA+D/XfhVqqsP8Arvwq1TEFBoopAAooooAl
g++fpUZ6mpIPv/hUZ6mqASlpKWkAUUUUgCiiigCjRRRQMKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKACiiigB8P8Arh9KtVUh/wBeKt0xBRRRSAKKKKAJYPv/AIVG33j9afB/
rKY33j9aYCUtJRQMWiiikIKKKKAKNFFFAwooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA
CiiigAooooAKKKKAHRf69fxq3VSP/XLVumIKKKKQBRRRQBJB/rBTG+8frUkIwS56Cl8yPOdlUBDR
U3mR/wByk8xP7lICKlqTzU/uCl81f7ooAioqXzV/uijzR/cFAGZRRRSGFFFFABRRRQAUUUUAFFFF
ABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA6P/XLVuqaf65auUwCiiikIKOpoqWFeS56CmgF
k+SMIOvU1DSsxZiTSUMAooooAKWkooGLRRRSEZ+72P5Ubv8AZP5VoYooAobv9lvyoyf7rflV+igC
hlv7jflR839xqv0UAUfn/uNRh/8Anm1XqKYFHbJ/zzajbJ/zzNXqKQFHZL/zzNLsl/uVdoxQBS8u
X+5R5cv9z9au4oxQBS8qX+6PzpfKm/uj86t0UDKnkzeg/OjyZvRfzq3RQBU8ib/Zo8iX/Zq5SUCK
vkS+q0eRL6irVFMZV+zy/wB4UfZ5P74/KrVFAFdIGVwxYHFWKMUYpAFFFFMQAZOBU0h2IIx+NJCu
MuegqNjuYk96YCUUUUhhRRRQIKKKKAClpKKQxaKKKBBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABR
RRQAUGiigBKUUmKKBi0UZozQIKKM0ZoAKKKKACkAycUtSxADLnoKaAJTsQRj8ahpWJZiT3pKGMKK
KKACiiigQUUUUDCiiigQtFFFIAooopgFFFGKACijB9DS4PoaAEopcH0NGD6H8qAEopdp9D+VG1vQ
/lQAlFLtb0NGxv7poASinbG/umjY3900ANop2xv7po8t/wC6aAG0GneW/wDdNHlP/dNADKKf5T/3
TR5T/wB2gYyin+U/92l8l/SiwiOlp/kv6UeS/pRYBgGTipZDtURj8aVEKZZu1RE7iSe9MBKSlpKk
AooopgFFFFABRRRSGFFFFMRN53+wKPO/2BUVFFwJfOP90Unnn+6KjpKLgS+cf7oo85vQVHRRcCTz
m9BR5zegqOii4EnnN7Uec/tUdFFwJPOf2/Kjzn9R+VR0UXAk85/UflSec/rTKKAH+a/rR5r+tMoo
Af5r+tHmv60yigB/mN/eNJ5j/wB402igB3mP/eNJ5j/3jTaKAHeY/wDeNHmP/eNNopgO3t/eNJvb
1NJRQApYnqTRSUtIApKWkpAFFFFMAooooAKKKKQwooopiFooopAFJSmkoAWiiigAooooAKKKKACi
iigAooopgFFFFABRRRQAUUUUAJRQaKACiiigAooooAKUUlAoGLSUtJSEFFFFMAooooAKKKKQwooo
piFooopAIaKKKBi0UUUCCiiigAooooAKKKKACiiimAUUUUAFFFFABRRRQAhooooAKKKKACiiigAo
oooAWkoopAFFFFMAooooAKKKKQwooopiP//Z