20240501 21583800 FALSE Server=OCGIS-PubSQL; Service=sde:sqlserver:OCGIS-PubSQL; Database=PublishingSDE; User=Property; Version=sde.DEFAULT ArcSDE Connection ProductionSDE.PROPERTY.Building 002 12616434.171060 12744091.290459 453663.236160 625330.517311 1 Relationship ProductionSDE.PROPERTY.BuildingHasFloors Relationship ProductionSDE.PROPERTY.BuildingHasAddress Relationship Projected GCS_North_American_1983 Linear Unit: Foot (0.304800) NAD_1983_StatePlane_Michigan_South_FIPS_2113_Feet_Intl <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_Michigan_South_FIPS_2113_Feet_Intl&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;,13123359.58005249],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-84.36666666666666],PARAMETER[&quot;Standard_Parallel_1&quot;,42.1],PARAMETER[&quot;Standard_Parallel_2&quot;,43.66666666666666],PARAMETER[&quot;Latitude_Of_Origin&quot;,41.5],UNIT[&quot;Foot&quot;,0.3048],AUTHORITY[&quot;EPSG&quot;,2253]]</WKT><XOrigin>-107138599.99927454</XOrigin><YOrigin>-97193799.999631718</YOrigin><XYScale>4139.337888</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808398950131233</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2253</WKID><LatestWKID>2253</LatestWKID></ProjectedCoordinateSystem> RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # DefineProjection "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" PROJCS['NAD_1983_StatePlane_Michigan_South_FIPS_2113_Feet_Intl',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',13123359.58005249],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-84.36666666666666],PARAMETER['Standard_Parallel_1',42.1],PARAMETER['Standard_Parallel_2',43.66666666666666],PARAMETER['Latitude_Of_Origin',41.5],UNIT['Foot',0.3048]] RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # DefineProjection "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" PROJCS['NAD_1983_StatePlane_Michigan_South_FIPS_2113_Feet_Intl',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',13123359.58005249],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-84.36666666666666],PARAMETER['Standard_Parallel_1',42.1],PARAMETER['Standard_Parallel_2',43.66666666666666],PARAMETER['Latitude_Of_Origin',41.5],UNIT['Foot',0.3048]] CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [SuffixDirection]&" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType] & " "&[UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings Type "Res, Single" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Buildings Address "[Address]& " "& [UnitPrefix] &[UnitNumber]" VB # CalculateField Buildings Address "[Address]& " "& [UnitPrefix] &" "&[UnitNumber]" VB # CalculateField Buildings Address "[Address]& " "& [UnitPrefix] &" "&[UnitNumber]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType]& " "& [UnitPrefix] &" "&[UnitNumber]" VB # CalculateField Buildings Address "[Address] & " "& [UnitPrefix] &" "&[UnitNumber]" VB # CalculateField Buildings Address "[SiteNumber]&" " &[StreetName] &" "& [StreetType]&" "& [UnitPrefix] &" " &[UnitNumber]" VB # CalculateField Buildings UnitName [UnitNumber] VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Addressing\Buildings Organization "Michigan Department of Transportation" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [SuffixDirection]&" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [SuffixDirection]&" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [PrefixDirection] &" "& [StreetName]&" "& [StreetType]" VB # CalculateField Addressing\Buildings Organization "[Organization]= "Michigan Department of Transportation"" VB # CalculateField Addressing\Buildings Organization "[Organization] = "Michigan Department of Transportation" " VB # CalculateField Addressing\Buildings Organization "Michigan Department of Transportation" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings UnitNumber [SiteNumber] VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Addressing\Buildings Address "[SiteNumber] &" "& [StreetName]&" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [SuffixDirection]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType] &" "&[SuffixDirection]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType]" VB # CalculateField Buildings StreetName "Crystal Waters" VB # CalculateField Buildings StreetName "Crystal Waters" VB # CalculateField Buildings StreetName "Crystal Waters" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings UnitName [Name] VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType] & " "&[UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings UnitName ""Bldg " & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Name "[Name] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "&"Stoneylake Dr"" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType] & [SuffixDirection]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType] &" "& [SuffixDirection]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType] &" "& [SuffixDirection]" VB # CalculateField Buildings Address "[SiteNumber] &" " & [StreetName] &" "& [StreetType] &" "& [SuffixDirection]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings SiteNumber " [UnitName]" VB # CalculateField Buildings StreetName " [UnitName] &" "& [StreetName]" VB # CalculateField Buildings Address " [UnitName] &" "& [StreetName]" VB # CalculateField Buildings Address " [UnitName] &" "& [StreetName]" VB # CalculateField Buildings SiteNumber " [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings SiteNumber [UnitName] VB # CalculateField Buildings Address "[UnitName] &" "& [StreetName]" VB # CalculateField Buildings UnitName "[UnitName] +1" VB # CalculateField Buildings SiteNumber [UnitName] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName]" VB # CalculateField Buildings SiteNumber [UnitName] VB # CalculateField Buildings Address "[UnitName] &" "& [StreetName]" VB # CalculateField Buildings Address "[UnitName] &" "& [StreetName]" VB # CalculateField Buildings SiteNumber [UnitName] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings SiteNumber " [UnitName]" VB # CalculateField Buildings Address " [UnitName]&" "& [StreetName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings SiteNumber [UnitName] VB # CalculateField Buildings Address "[UnitName]&" "& [StreetName]" VB # CalculateField Buildings Address "[UnitName]&" "& [StreetName]" VB # CalculateField Buildings SiteNumber [UnitName] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Scottie" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Energy" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [PrefixDirection]&" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" Apio Circle"" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings StreetName "Apio Circle" VB # CalculateField Buildings StreetName "Apio Circle" VB # CalculateField Buildings StreetName "Lake Apio" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "[StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber " [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings Address "[StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings Address "[StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings Address "[StreetName] &" "& [StreetType] &" "& [UnitPrefix] &" "& [UnitNumber]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address ""Holiday Isle Marina # "& [UnitName]" VB # CalculateField Buildings Address ""Holiday Isle Marina # "& [UnitName]" VB # CalculateField Buildings Address ""Marina Bay Yacht Club # "& [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber " [UnitName]" VB # CalculateField Buildings Address ""Tepa Marina # "& [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings Address "Summer Place Marina # "&[UnitName] VB # CalculateField Buildings Address "Village Cove Marina # "&[UnitName] VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings BuildingHeight "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Energy" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Address "[SiteNumber] &" "& [StreetName] &" "& [StreetType]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Apio" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Ipema" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Andres Crossing" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # ChangePrivileges 'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Floor';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.FloorPlanLine';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.FloorSection';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.InteriorSpace' Transportation GRANT GRANT ChangePrivileges 'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Addresses';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.FloorPlanLine';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Floor';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.FloorSection';'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.InteriorSpace' Transportation REVOKE REVOKE RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Lamac" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Meadow Cove West" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Par 5" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Sheldon Terrace" VB # CalculateField Buildings StreetName "Tyler" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Despelder" VB # CalculateField Buildings StreetName "River Haven" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Riverbank" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Brook Lane" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Platinum Pointe" VB # CalculateField Buildings StreetName "Crystal Circle" VB # CalculateField Buildings StreetType "Sunrise Circle" VB # CalculateField Buildings StreetName "Sunrise Circle" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Mill View" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Newcastle" VB # CalculateField Buildings StreetName "Brisben" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Pheasant Ridge" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Sundstorm" VB # CalculateField Buildings StreetName "Tall Tree" VB # CalculateField Buildings StreetName "Rosabelle Beach" VB # CalculateField Buildings StreetName "Scholten" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Karstan Heath" VB # CalculateField Buildings StreetName "Pine Ridge" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Vanderveen" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings UnitName "[UnitName] &" "& [UnitNumber]" VB # CalculateField Buildings UnitName "[UnitName] &" "& [UnitNumber]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Glengary" VB # CalculateField Buildings StreetName "Glengarry" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Whispering Pine" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Downyberry" VB # CalculateField Buildings StreetName "Hidden Cove" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Faringdom Grove" VB # CalculateField Buildings StreetName "12th Ave" VB # CalculateField Buildings StreetName "Braeburn" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN [PackedPIN] VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings UnitNumber ""Bldg "& [UnitName]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings UnitNumber Left( [UnitName],1 ) VB # CalculateField Buildings UnitNumber Right( [UnitName],1 ) VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Sundstrom" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Janes" VB # CalculateField Buildings StreetName "Bay Breeze" VB # CalculateField Buildings StreetName "Janes View" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Piper" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "View Pond" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Valley Vista" VB # CalculateField Buildings StreetName "Northern" VB # CalculateField Buildings StreetType "Northern" VB # CalculateField Buildings StreetName "Northern" VB # CalculateField Buildings StreetName "Bay" VB # CalculateField Buildings StreetName "Cottage Cove" VB # CalculateField Buildings StreetName "Cottage Wood" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Roxburo" VB # CalculateField Buildings StreetName "Ardleigh" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "West Side" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings UnitNumber ""Cabin "& [UnitNumber]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Leggat" VB # CalculateField Buildings StreetName "Leggat" VB # CalculateField Buildings StreetName "Clayton" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "East Valley" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Addressing\Buildings CondoPIN [PackedPIN] VB # CalculateField Addressing\Buildings StreetName "John S" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Baldwin Woods" VB # CalculateField Buildings StreetName "Baldwin Woods" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Addressing\Buildings Source "Aerial Photo 2017" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings Name "!Name! .title()" PYTHON_9.3 # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # MigrateStorage 'Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building' DEFAULTS RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Brindlewood" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Kaylee" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Michigan Dune" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Lakeshore Gardens" VB # CalculateField Buildings StreetName "Kaye" VB # CalculateField Buildings StreetName "Tysman" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Browtine" VB # CalculateField Buildings StreetName "Legends View" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Windborne" VB # CalculateField Buildings StreetName "Dalton" VB # CalculateField Buildings StreetName "Barrington" VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Pere Marquette" VB # CalculateField Buildings UnitNumber [UnitName] VB # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings UnitNumber " [UnitName]" VB # CalculateField Buildings UnitNumber " [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Sheldon Crossings" VB # CalculateField Buildings StreetType "Croft" VB # CalculateField Buildings StreetName "Croft" VB # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Sheldon Crossings" VB # CalculateField Buildings StreetName "Furrow" VB # CalculateField Buildings StreetName "Rowan" VB # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Golden Eagle" VB # CalculateField Buildings StreetName "Beacon Light" VB # CalculateField Buildings StreetName "Bay Point" VB # CalculateField Buildings StreetName "Duneland" VB # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Pine Nook" VB # CalculateField Buildings StreetName "Bayshore" VB # CalculateField Buildings StreetName "Tree Crest" VB # CalculateField Buildings StreetName "Jeans Meadow" VB # CalculateField Buildings StreetName "Praire View" VB # CalculateField Buildings SiteNumber [Fraction] VB # CalculateField Buildings SiteNumber [Fraction] VB # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # RemoveDomainFromField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName # AssignDomainToField "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" StreetName StreetNames # CalculateField Buildings StreetName "Lakeshore Flats" VB # CalculateField Buildings StreetName "Lakeshore Flats" VB # CalculateField Buildings StreetName "Perennial" VB # CalculateField Buildings StreetName "Kensley" VB # DeleteFeatures "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" Append 'Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building' "Database Connections\ProductionSDE@Property.sde\ProductionSDE.PROPERTY.Building" NO_TEST "BuildingID "Unique Building ID" true true false 4 Long 0 10 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,BuildingID,-1,-1;PackedPIN "Related Parcel ID" true true false 12 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,PackedPIN,-1,-1;CondoPINFlag "Building Has Condo Parcel ID" true true false 7 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,CondoPINFlag,-1,-1;CondoPIN "Condo Parcel ID" true true false 12 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,CondoPIN,-1,-1;Class "Building Class" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Class,-1,-1;Type "Building Type" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Type,-1,-1;Name "Name" true true false 70 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Name,-1,-1;UnitName "Unit Name" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,UnitName,-1,-1;Organization "Organization" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Organization,-1,-1;PrimaryBuilding "Primary Building" true true false 25 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,PrimaryBuilding,-1,-1;Status "Status" true true false 25 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Status,-1,-1;SiteNumber "Site/Property Number" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,SiteNumber,-1,-1;Fraction "Fractional Address Number" true true false 5 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Fraction,-1,-1;PrefixDirection "Street Prefix Direction" true true false 2 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,PrefixDirection,-1,-1;StreetName "Street Name" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,StreetName,-1,-1;StreetType "Street Type" true true false 25 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,StreetType,-1,-1;SuffixDirection "Street Suffix Direction" true true false 2 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,SuffixDirection,-1,-1;UnitPrefix "Building Address Prefix" true true false 25 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,UnitPrefix,-1,-1;UnitNumber "Building Address Number/Letter" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,UnitNumber,-1,-1;Address "Full Address" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Address,-1,-1;Zip "Zip Code" true true false 10 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Zip,-1,-1;GovernmentUnit "Government Unit" true true false 2 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,GovernmentUnit,-1,-1;BuildingHeight "Building Height" true true false 8 Double 8 38 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,BuildingHeight,-1,-1;MulitpleFloors "Mulitple Floors" true true false 7 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,MulitpleFloors,-1,-1;NumberofFloors "Number of Floors" true true false 4 Long 0 10 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,NumberofFloors,-1,-1;MulitpleSections "Mulitple Sections" true true false 7 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,MulitpleSections,-1,-1;NumberofSections "Number of Sections" true true false 4 Long 0 10 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,NumberofSections,-1,-1;Rental "Rental Property" true true false 7 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Rental,-1,-1;Description "Description" true true false 250 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Description,-1,-1;Source "Source" true true false 50 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,Source,-1,-1;DocLinks "Linked Documents" true true false 150 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,DocLinks,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,last_edited_date,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,GlobalID,-1,-1;SHAPE.STArea() "SHAPE.STArea()" false false true 0 Double 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,SHAPE.STArea(),-1,-1;SHAPE.STLength() "SHAPE.STLength()" false false true 0 Double 0 0 ,First,#,Database Connections\ProdSQL@GISAdmin.sde\ProductionSDE.PROPERTY.Building,SHAPE.STLength(),-1,-1" # CalculateField Buildings StreetName "Heyboer" VB # CalculateField Buildings StreetName "Shinnecock" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings StreetName "Gregory" VB # CalculateField Buildings StreetName "Buckley" VB # CalculateField Buildings StreetName "Sawmill" VB # CalculateField Buildings StreetName "Shorecrest" VB # CalculateField Buildings StreetName "Vandente" VB # CalculateField Buildings StreetName "Pinevalley" VB # CalculateField Buildings StreetName "Perennial" VB # CalculateField Buildings StreetName "Rare Bloom" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings StreetName "Wood Lane" VB # CalculateField Buildings StreetName "Wood Lane" VB # CalculateField Buildings CondoPIN [PackedPIN] VB # CalculateField Buildings StreetName "Bethpage" VB # CalculateField Buildings StreetName "Shinnecock" VB # CalculateField Buildings StreetName "Winged Foot" VB # CalculateField Buildings StreetName "Castlebar" VB # CalculateField Buildings StreetName "Castlebar" VB # CalculateField Buildings StreetName "Brayridge" VB # CalculateField Buildings StreetName "Baltrusol" VB # CalculateField Buildings StreetName "Baltrusol" VB # CalculateField Buildings StreetName "Blendon" VB # CalculateField Buildings StreetName "Rooster" VB # CalculateField Buildings StreetName "South Buttermilk" VB # CalculateField Buildings StreetName "Ability" VB # CalculateField Buildings UnitNumber [UnitName] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings StreetName "Winged Foot" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings StreetName "Vandebunte" VB # CalculateField Buildings StreetName "Warren" VB # CalculateField Buildings StreetName "Ridgeside" VB # CalculateField Buildings StreetName "Poppy Point" VB # CalculateField Buildings StreetName "Willa Springs" VB # CalculateField Buildings StreetName "Waverly Woods" VB # CalculateField Buildings StreetName "Langour" VB # CalculateField Buildings StreetName "Langour" VB # CalculateField Buildings Name ""Bldg "& [Name]" VB # CalculateField Buildings StreetName "Nicole" VB # CalculateField Buildings StreetName "Claudia" VB # CalculateField Buildings StreetName "Costen" VB # CalculateField Buildings StreetName "Eagle Shore" VB # CalculateField Buildings StreetName "Vandebunte" VB # CalculateField Buildings StreetName "Taylor Pines" VB # CalculateField Buildings StreetName "Signature" VB # CalculateField Buildings StreetName "Sheldon Sands" VB # CalculateField Buildings StreetName "Sheldon Sands" VB # CalculateField Buildings StreetName "Coppersteen" VB # CalculateField Buildings StreetName "Riverbend" VB # CalculateField Buildings StreetName "Ivy Grove North" VB # CalculateField Buildings StreetName "Ivy Grove South" VB # CalculateField Buildings StreetName "Ivy Grove West" VB # CalculateField Buildings StreetName "Nina" VB # CalculateField Buildings StreetName "Oakmere" VB # CalculateField Buildings StreetName "Oakmere" VB # CalculateField Buildings StreetName "Nina" VB # CalculateField Buildings StreetName "Elmwood Centre" VB # CalculateField Buildings StreetName "Zephyr" VB # CalculateField Buildings StreetName "Abbey" VB # CalculateField Buildings StreetName "Violet" VB # CalculateField Buildings StreetName "Tanoak" VB # CalculateField Buildings StreetName "Red Lilac" VB # CalculateField Buildings StreetName "Red Lilac" VB # CalculateField Buildings StreetName "Red Ivy" VB # CalculateField Buildings StreetName "Madrone" VB # CalculateField Buildings StreetName "Highbury" VB # CalculateField Buildings StreetName "Blendon Woods" VB # CalculateField Buildings StreetName "Blendon Woods" VB # CalculateField Buildings StreetName "Blendon Meadow" VB # CalculateField Buildings StreetName "Blendon Woods" VB # CalculateField Buildings StreetName "Blendon Woods" VB # CalculateField Buildings StreetName "Timber Dune" VB # CalculateField Buildings StreetName "Kouw" VB # CalculateField Buildings StreetName "3D" VB # CalculateField Buildings StreetName "Vriesland Crossing" VB # CalculateField Buildings SiteNumber [Fraction] VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings StreetName "Elmwood" VB # CalculateField Buildings StreetName "Elmwood" VB # CalculateField Buildings StreetName "Sprucewood" VB # CalculateField Buildings StreetName "Applewood" VB # CalculateField Buildings StreetName "Greenwood" VB # CalculateField Buildings StreetName "Vriesland" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings StreetName "Stern" VB # CalculateField Buildings StreetName "Masthead" VB # CalculateField Buildings StreetName "Masthead" VB # CalculateField Buildings StreetName "Keel" VB # CalculateField Buildings StreetName "Prairie View" VB # CalculateField Buildings StreetName "Prairie View" VB # UpdateSchema "\\publishingsde\Staff Projects\Staff_projects\Shane\ArcGISPro\Addressing\ProdSQL@Property.sde\ProductionSDE.PROPERTY.Building" "<operationSequence><workflow><AddAttributeRule><rule_name>BuildingID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue('BuildingID')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><field_name>BuildingID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>BuildingID</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Address</rule_name><rule_type>CALCULATION</rule_type><expression>TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM([$feature.Sitenumber]&amp;" "&amp;[$feature.Fraction])&amp;" "&amp;[$feature.PrefixDirection])&amp;" "&amp;[$feature.StreetName])&amp;" "&amp;[$feature.StreetType])&amp;" "&amp;[$feature.SuffixDirection])&amp;" "&amp;[$feature.UnitPrefix])&amp;" "&amp;[$feature.UnitNumber])</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>Address</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Address</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>ZipCode</rule_name><rule_type>CALCULATION</rule_type><expression>var fs = FeatureSetByName($datastore, "ProductionSDE.Political.ZipCodes", ["ZIP"], true) // intersect var intersect_fs = Intersects(fs, $feature) // return if(Count(intersect_fs) &gt; 0) { return First(intersect_fs).ZIP } return null</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>Zip</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>ZipCode</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>PrefixDirection</rule_name><rule_type>CALCULATION</rule_type><expression>var fs = FeatureSetByName($datastore, "ProductionSDE.Property.Building", ["PrefixDirection"], true) // intersect var intersect_fs = Intersects(fs, $feature) // return if(Count(intersect_fs) &gt; 0) { return First(intersect_fs).PrefixDirection } return null</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>PrefixDirection</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>PrefixDirection</rule_name><evaluation_order>8</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>SiteNumber</rule_name><rule_type>CALCULATION</rule_type><expression>var fs = FeatureSetByName($datastore, "ProductionSDE.Property.OwnerParcelCondo", ["AddressNumber"], true) // intersect var intersect_fs = Intersects(fs, $feature) // return if(Count(intersect_fs) &gt; 0) { return First(intersect_fs).AddressNumber } return null</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>SiteNumber</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>SiteNumber</rule_name><evaluation_order>9</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>PackedPIN</rule_name><rule_type>CALCULATION</rule_type><expression>var fs = FeatureSetByName($datastore, "ProductionSDE.Property.BaseParcel", ["PACKEDPIN"], true) // intersect var intersect_fs = Intersects(fs, $feature) // return if(Count(intersect_fs) &gt; 0) { return First(intersect_fs).PACKEDPIN } return null</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>PackedPIN</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>PackedPIN</rule_name><evaluation_order>16</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>PackedPINHolland</rule_name><rule_type>CALCULATION</rule_type><expression>var fs = FeatureSetByName($datastore, "ProductionSDE.Property.HollandParcels", ["FinalPackedPIN"], true) // intersect var intersect_fs = Intersects(fs, $feature) // return if(Count(intersect_fs) &gt; 0) { return First(intersect_fs).FinalPackedPIN } return null</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>PackedPIN</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>PackedPINHolland</rule_name><evaluation_order>17</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>GovernmentUnit</rule_name><rule_type>CALCULATION</rule_type><expression>var fs = FeatureSetByName($datastore, "ProductionSDE.Political.JurisdictionalBoundaries", ["GovernmentUnit"], true) // intersect var intersect_fs = Intersects(fs, $feature) // return if(Count(intersect_fs) &gt; 0) { return First(intersect_fs).GovernmentUnit } return null</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>GovernmentUnit</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>GovernmentUnit</rule_name><evaluation_order>18</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "\\publishingsde\Staff Projects\Staff_projects\Shane\ArcGISPro\Addressing\ProdSQL@Property.sde\ProductionSDE.PROPERTY.Building" <operationSequence><workflow><DeleteAttributeRule><rule_name>BuildingID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Address</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>ZipCode</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>PrefixDirection</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>SiteNumber</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>PackedPIN</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>PackedPINHolland</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>GovernmentUnit</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema "\\publishingsde\Staff Projects\Staff_projects\Shane\ArcGISPro\Addressing\ProdSQL@Property.sde\ProductionSDE.PROPERTY.Building" <operationSequence><workflow><DeleteAttributeRule><rule_name>BuildingID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Address</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>ZipCode</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>PrefixDirection</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>SiteNumber</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>PackedPIN</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>PackedPINHolland</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>GovernmentUnit</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema "\\publishingsde\Staff Projects\Staff_projects\Shane\ArcGISPro\Addressing\ProdSQL@Property.sde\ProductionSDE.PROPERTY.Building" <operationSequence><workflow><DeleteAttributeRule><rule_name>BuildingID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema "\\publishingsde\Staff Projects\Staff_projects\Shane\ArcGISPro\Addressing\ProdSQL@Property.sde\ProductionSDE.PROPERTY.Building" <operationSequence><workflow><DeleteAttributeRule><rule_name>BuildingID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> UpdateSchema "\\publishingsde\Staff Projects\Staff_projects\Shane\ArcGISPro\Addressing\ProdSQL@Property.sde\ProductionSDE.PROPERTY.Building" <operationSequence><workflow><DeleteAttributeRule><rule_name>BuildingID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> DeleteAttributeRule "\\publishingsde\Staff Projects\Staff_projects\Shane\ArcGISPro\Addressing\ProdSQL@Property.sde\ProductionSDE.PROPERTY.Building" Address;BuildingID;GovernmentUnit;PackedPIN;PackedPINHolland;PrefixDirection;SiteNumber;ZipCode Calculation CalculateField Buildings StreetName "West Elmwood Park" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings StreetName "Flowering" VB # CalculateField Buildings CondoPIN "[CondoPIN] & [UnitName]" VB # CalculateField Buildings StreetName "Gateway" VB # CalculateField Buildings StreetName "Farmway" VB # CalculateField Buildings StreetName "Stanton Pines" VB # CalculateField Buildings StreetName "Gordan" VB # CalculateField Buildings StreetName "Islandview" VB # CalculateField Buildings StreetName "Camino" VB # CalculateField Buildings StreetName "Bluestone" VB # CalculateField Buildings Organization "Clubside Townhomes" VB # CalculateField Buildings Organization "Clubside Townhomes" VB # CalculateField Buildings StreetName "Albatross" VB # CalculateField Buildings Organization "Clubside Villas" VB # CalculateField Buildings StreetName "Clubside" VB # CalculateField Buildings StreetName "Flagstick" VB # CalculateField Buildings Organization "Trailpoint Condos" VB # CalculateField Buildings Organization "Courtyard Homes" VB # CalculateField Buildings StreetName "Ravinewood" VB # CalculateField Buildings StreetName "Broadleaf" VB # CalculateField Buildings StreetName "Ravinewood" VB # CalculateField Buildings StreetName "Shore Oaks East" VB # CalculateField Buildings StreetName "Shore Oaks West" VB # CalculateField Buildings StreetName "Vista Green" VB # CalculateField Buildings StreetName "Vista Green" VB # CalculateField Buildings StreetName "James E" VB # CalculateField Buildings StreetName "Paramount" VB # CalculateField Buildings CondoPIN "[CondoPIN] + [UnitName]" VB # CalculateField Buildings CondoPIN "[CondoPIN] + [UnitName]" VB # 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.2.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68362f55464f66493239706535715a2f697a39755a61732b50704c51352b7a304f6f34586d31554e786c436f3d2a00;ENCRYPTED_PASSWORD=00022e684a58455a4d4c6e2f7336425866554f556a6f355a74574a71413844336246792f52723743464a547975616b3d2a00;SERVER=OCGIS-ProdSQL;INSTANCE=sde:sqlserver:OCGIS-ProdSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=OCGIS-ProdSQL;DATABASE=ProductionSDE;USER=Property;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ProductionSDE.PROPERTY.Building</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>StreetNamePreModifier</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Street Name Pre Modifier</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>StreetNamePreDirectional</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Street Name Pre Directional</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>StreetNameDirectional</field_domain></AddField></workflow><workflow><AddField><field_name>StreetNamePreType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Street Name Pre Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>StreetNameType</field_domain></AddField></workflow><workflow><AddField><field_name>StreetNamePreTypeSeperator</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Street Name Pre Type Separator</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>StreetNamePreTypeSeparator</field_domain></AddField></workflow><workflow><AddField><field_name>StreetName1</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Street Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>StreetNamePostType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Street_Name_Post_Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>StreetNameType</field_domain></AddField></workflow><workflow><AddField><field_name>StreetNamePostDirectional</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Street Name Post Directional</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>StreetNameDirectional</field_domain></AddField></workflow><workflow><AddField><field_name>StreetNamePostModifier</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Street Name Post Modifier</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>FullAddress</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Full Address</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LegacyStreetNamePreModifier</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Legacy Street Name Pre Modifier</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>tStreetModifier</field_domain></AddField></workflow><workflow><AddField><field_name>LegacyStreetNamePreDirection</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Legacy Street Name Pre Directional</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>tStreetPreDirection</field_domain></AddField></workflow><workflow><AddField><field_name>LegacyStreetNameTypePrefix</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Legacy Street Name Type Prefix</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LegacyStreetName</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Legacy Street Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LegacyStreetNameType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Legacy Street Name Type</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>StreetTypes</field_domain></AddField></workflow><workflow><AddField><field_name>LegacyStreetNamePostDirection</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Legacy Street Name Post Directional</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>tStreetSufDirection</field_domain></AddField></workflow><workflow><AddField><field_name>LegacyStreetNamePostModifier</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Legacy Street Name Post Modifier</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>tStreetModifier</field_domain></AddField></workflow><workflow><AddField><field_name>LegacyFullAddress</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Legacy Full Address</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>PostalCode</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Postal Code</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>tTextZipCode</field_domain></AddField></workflow><workflow><AddField><field_name>PostalCommunityName</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Postal Community Name</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>PropertyCity</field_domain></AddField></workflow><workflow><AddField><field_name>State</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>State</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_default_value>MI</field_default_value></AddField></workflow><workflow><AddField><field_name>County</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>County</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>tRoadCounty</field_domain><field_default_value>Ottawa County</field_default_value></AddField></workflow><workflow><AddField><field_name>Country</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Country</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_default_value>US</field_default_value></AddField></workflow><workflow><AddField><field_name>IncorporatedMunicipality</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Incorporated Municipality</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>UnincorporatedCommunity</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Unincorporated Community</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>MunicipalityDivision</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Municipality Division</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>NeighborhoodCommunity</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Neighborhood Community</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" UpdateSchema "\\oc-fileserver3\user1$\pavlak\My Documents\ArcGIS\Projects\AddressPoints\SQLServer-OCGIS-ProdSQL-ProductionSDE(Property).sde\ProductionSDE.PROPERTY.Building" "<operationSequence><workflow><AddAttributeRule><rule_name>PIN</rule_name><rule_type>CALCULATION</rule_type><expression>var PINvalue = FeatureSetByName($datastore, "ProductionSDE.PROPERTY.BaseParcel", ["PackedPIN"], false); var intersectLayer = Intersects(PINvalue, $feature); if (Count(intersectLayer) &gt; 0) { var layer = First(intersectLayer); if (layer != null) return layer.PackedPIN; } return null;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>0</error_number><rule_description>Get PIN From Parcel</rule_description><field_name>PackedPIN</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><DisableAttributeRules><rule_name>PIN</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><ReorderAttributeRule><rule_name>PIN</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>PostalCode</rule_name><rule_type>CALCULATION</rule_type><expression>var ZIPvalue = FeatureSetByName($datastore, "ProductionSDE.POLITICAL.Zipcodes", ["ZIP"], false); var intersectLayer = Intersects(ZIPvalue, $feature); if (Count(intersectLayer) &gt; 0) { var layer = First(intersectLayer); if (layer != null) return layer.ZIP; } return null;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>0</error_number><rule_description>Get ZIP from Zipcodes</rule_description><field_name>PostalCode</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>2147483647</category></AddAttributeRule><DisableAttributeRules><rule_name>PostalCode</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><ReorderAttributeRule><rule_name>PostalCode</rule_name><evaluation_order>6</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>PostalCommunityName</rule_name><rule_type>CALCULATION</rule_type><expression>var PostOfficeNamevalue = FeatureSetByName($datastore, "ProductionSDE.POLITICAL.Zipcodes", ["PostOfficeName"], false); var intersectLayer = Intersects(PostOfficeNamevalue, $feature); if (Count(intersectLayer) &gt; 0) { var layer = First(intersectLayer); if (layer != null) return layer.PostOfficeName; } return null;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>0</error_number><rule_description>Get Post Office Name from Zipcodes</rule_description><field_name>PostalCommunityName</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>2147483647</category></AddAttributeRule><ReorderAttributeRule><rule_name>PostalCommunityName</rule_name><evaluation_order>7</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>FullLegacyAddress</rule_name><rule_type>CALCULATION</rule_type><expression>if (IsEmpty($feature.LegacyStreetName)) { return null } else { return TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM($feature.Sitenumber + ' ' + $feature.Fraction) + ' ' + ($feature.LegacyStreetNamePreModifier + ' ' + $feature.LegacyStreetNamePreDirection) + ' ' + $feature.LegacyStreetNameTypePrefix) + ' ' + $feature.LegacyStreetName) + ' ' + $feature.LegacyStreetNameType) + ' ' + $feature.LegacyStreetNamePostDirection) + ' ' + $feature.LegacyStreetNamePostModifier) + ' ' + $feature.UnitPrefix) + ' ' + $feature.UnitNumber) }</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>0</error_number><rule_description>Caclulate Address</rule_description><field_name>LegacyFullAddress</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>2147483647</category></AddAttributeRule><DisableAttributeRules><rule_name>FullLegacyAddress</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><ReorderAttributeRule><rule_name>FullLegacyAddress</rule_name><evaluation_order>9</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>IncorporatedMunicipality</rule_name><rule_type>CALCULATION</rule_type><expression>var GovernmentUnitNamevalue = FeatureSetByName($datastore, "ProductionSDE.POLITICAL.JurisdictionalBoundaries", ["GovernmentUnitName"], false); var intersectLayer = Intersects(GovernmentUnitNamevalue, $feature); if (Count(intersectLayer) &gt; 0) { var layer = First(intersectLayer); if (layer != null) return layer.GovernmentUnitName; } return null;</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>0</error_number><rule_description>Get Government Unit from JurisdictionalBoundaries</rule_description><field_name>IncorporatedMunicipality</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>2147483647</category></AddAttributeRule><DisableAttributeRules><rule_name>IncorporatedMunicipality</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><ReorderAttributeRule><rule_name>IncorporatedMunicipality</rule_name><evaluation_order>10</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>BuildingID</rule_name><rule_type>CALCULATION</rule_type><expression>NextSequenceValue ('BUILDINGID')</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>0</error_number><rule_description>Get next value</rule_description><field_name>BuildingID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>BuildingID</rule_name><evaluation_order>11</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>if (IsEmpty($feature.StreetName)) { return null } else { return TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM($feature.Sitenumber + ' ' + $feature.Fraction) + ' ' + ($feature.StreetNamePreModifier + ' ' + $feature.StreetNamePreDirectional) + ' ' + $feature.StreetNamePreType) + ' ' + $feature.StreetNamePreTypeSeperator) + ' ' + $feature.StreetName) + ' ' +$feature.StreetNamePostType) + ' ' +$feature.StreetNamePostDirectional) + ' ' +$feature.StreetNamePostModifier) + ' ' + $feature.UnitPrefix) + ' ' + $feature.UnitNumber) }</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><error_number>0</error_number><rule_description>Caclulate Address</rule_description><field_name>FullAddress</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>2147483647</category></AddAttributeRule><DisableAttributeRules><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><ReorderAttributeRule><rule_name>FullAddress</rule_name><evaluation_order>14</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "\\oc-fileserver3\user1$\pavlak\My Documents\ArcGIS\Projects\AddressPoints\SQLServer-OCGIS-ProdSQL-ProductionSDE(Property).sde\ProductionSDE.PROPERTY.Building" "<operationSequence><workflow><AlterAttributeRule><rule_name>FullLegacyAddress</rule_name><rule_description>Caclulate Address</rule_description><error_number>0</error_number><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>if (IsEmpty($feature.LegacyStreetName)) { return null } else { return TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM($feature.Sitenumber + ' ' + $feature.Fraction) + ' ' + $feature.LegacyStreetNamePreModifier) + ' ' + $feature.LegacyStreetNamePreDirection) + ' ' + $feature.LegacyStreetNameTypePrefix) + ' ' + $feature.LegacyStreetName) + ' ' + $feature.LegacyStreetNameType) + ' ' + $feature.LegacyStreetNamePostDirection) + ' ' + $feature.LegacyStreetNamePostModifier) + ' ' + $feature.UnitPrefix) + ' ' + $feature.UnitNumber) }</expression><category>2147483647</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>FullAddress</rule_name><rule_description>Caclulate Address</rule_description><error_number>0</error_number><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>if (IsEmpty($feature.StreetName1)) { return null } else { return TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM($feature.Sitenumber + ' ' + $feature.Fraction) + ' ' + $feature.StreetNamePreModifier) + ' ' + $feature.StreetNamePreDirectional) + ' ' + $feature.StreetNamePreType) + ' ' + $feature.StreetNamePreTypeSeperator) + ' ' + $feature.StreetName1) + ' ' +$feature.StreetNamePostType) + ' ' +$feature.StreetNamePostDirectional) + ' ' +$feature.StreetNamePostModifier) + ' ' + $feature.UnitPrefix) + ' ' + $feature.UnitNumber) }</expression><category>2147483647</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "\\oc-fileserver3\user1$\pavlak\My Documents\ArcGIS\Projects\AddressPoints\SQLServer-OCGIS-ProdSQL-ProductionSDE(Property).sde\ProductionSDE.PROPERTY.Building" <operationSequence><workflow><EnableAttributeRules><rule_name>PIN</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow><workflow><EnableAttributeRules><rule_name>PostalCode</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow><workflow><EnableAttributeRules><rule_name>FullLegacyAddress</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow><workflow><EnableAttributeRules><rule_name>IncorporatedMunicipality</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow><workflow><EnableAttributeRules><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow></operationSequence> 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.2.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68362f55464f66493239706535715a2f697a39755a61732b50704c51352b7a304f6f34586d31554e786c436f3d2a00;ENCRYPTED_PASSWORD=00022e684a536e6d4d3737373976646c30796144394f72613063414174304d634f414a364b6953435a4535494b564d3d2a00;SERVER=OCGIS-ProdSQL;INSTANCE=sde:sqlserver:OCGIS-ProdSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=OCGIS-ProdSQL;DATABASE=ProductionSDE;USER=Property;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ProductionSDE.PROPERTY.Building</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>PrefixDirection</field_name><field_name>StreetName</field_name><field_name>StreetType</field_name><field_name>SuffixDirection</field_name><field_name>Address</field_name><field_name>Zip</field_name><field_name>GovernmentUnit</field_name></DeleteField></workflow></operationSequence> 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.2.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68362f55464f66493239706535715a2f697a39755a61732b50704c51352b7a304f6f34586d31554e786c436f3d2a00;ENCRYPTED_PASSWORD=00022e684a536e6d4d3737373976646c30796144394f72613063414174304d634f414a364b6953435a4535494b564d3d2a00;SERVER=OCGIS-ProdSQL;INSTANCE=sde:sqlserver:OCGIS-ProdSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=OCGIS-ProdSQL;DATABASE=ProductionSDE;USER=Property;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ProductionSDE.PROPERTY.Building</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>StreetName1</field_name><new_field_name>StreetName</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> UpdateSchema "\\oc-fileserver3\user1$\pavlak\My Documents\ArcGIS\Projects\AddressPoints\SQLServer-OCGIS-ProdSQL-ProductionSDE(Property).sde\ProductionSDE.PROPERTY.Building" <operationSequence><workflow><DeleteAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence> 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.2.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68362f55464f66493239706535715a2f697a39755a61732b50704c51352b7a304f6f34586d31554e786c436f3d2a00;ENCRYPTED_PASSWORD=00022e683455543674373070366337734979324c5a6330722f572b794b7152786266674d4562576679304b524f31733d2a00;SERVER=OCGIS-ProdSQL;INSTANCE=sde:sqlserver:OCGIS-ProdSQL;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=OCGIS-ProdSQL;DATABASE=ProductionSDE;USER=Property;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ProductionSDE.PROPERTY.Building</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>StreetName1</field_name><new_field_name>StreetName</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> UpdateSchema "\\oc-fileserver3\user1$\pavlak\My Documents\ArcGIS\Projects\AddressPoints\SQLServer-OCGIS-ProdSQL-ProductionSDE(Property).sde\ProductionSDE.PROPERTY.Building" "<operationSequence><workflow><AddAttributeRule><rule_name>FullAddress</rule_name><rule_type>CALCULATION</rule_type><expression>if (IsEmpty($feature.StreetName)) { return null } else { return TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM(TRIM($feature.Sitenumber + ' ' + $feature.Fraction) + ' ' + $feature.StreetNamePreModifier) + ' ' + $feature.StreetNamePreDirectional) + ' ' + $feature.StreetNamePreType) + ' ' + $feature.StreetNamePreTypeSeperator) + ' ' + $feature.StreetName) + ' ' +$feature.StreetNamePostType) + ' ' +$feature.StreetNamePostDirectional) + ' ' +$feature.StreetNamePostModifier) + ' ' + $feature.UnitPrefix) + ' ' + $feature.UnitNumber) } </expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculate Address</rule_description><field_name>FullAddress</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>FullAddress</rule_name><evaluation_order>7</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "\\oc-fileserver3\user1$\pavlak\My Documents\ArcGIS\Projects\AddressPoints\SQLServer-OCGIS-ProdSQL-ProductionSDE(Property).sde\ProductionSDE.PROPERTY.Building" "<operationSequence><workflow><AlterAttributeRule><rule_name>BuildingID</rule_name><rule_description>Get next value</rule_description><error_number>0</error_number><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>NextSequenceValue ('Property.BUILDINGID')</expression><category>0</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" 1.0 20190912 08460200 20190912 08460200 150000000 5000 ItemDescription Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9273 BuildingFootprints 1 -86.268047 -85.778538 43.207115 42.729280 <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Building Footprints with Parcel and Address information. Buildings are also typed by building class.</SPAN></P></DIV></DIV></DIV> Ottawa County Geospatial Insights & Solutions Building Outlines digitized from aerial imagery for Ottawa County, MI Property Buildings <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Ottawa County GIS users via SDE connection.</SPAN></P></DIV></DIV></DIV> SDE Feature Class dataset EPSG 5.3(9.0.0) 152379 Simple FALSE 152379 TRUE FALSE ProductionSDE.PROPERTY.Building Feature Class 152379 BuildingID Unique Building ID Integer 4 10 0 PackedPIN Related Parcel ID String 12 0 0 CondoPINFlag Building Has Condo Parcel ID String 7 0 0 CondoPIN Condo Parcel ID String 12 0 0 Class Building Class String 50 0 0 Type Building Type String 50 0 0 Name Name String 70 0 0 Organization Organization String 50 0 0 UnitName Unit Name String 50 0 0 SiteNumber Site/Property Number String 50 0 0 PrefixDirection Street Prefix Direction String 2 0 0 StreetName Street Name String 50 0 0 Fraction Fractional Address Number String 5 0 0 SuffixDirection Street Suffix Direction String 2 0 0 StreetType Street Type String 25 0 0 UnitPrefix Building Address Prefix String 25 0 0 UnitNumber Building Address Number/Letter String 50 0 0 Zip Zip Code String 10 0 0 Address Full Address String 50 0 0 BuildingHeight Building Height Double 8 38 8 Status Status String 25 0 0 GovernmentUnit Government Unit String 2 0 0 PrimaryBuilding Primary Building String 25 0 0 MulitpleFloors Mulitple Floors String 7 0 0 NumberofFloors Number of Floors Integer 4 10 0 MulitpleSections Mulitple Sections String 7 0 0 NumberofSections Number of Sections Integer 4 10 0 Rental Rental Property String 7 0 0 Description Description String 250 0 0 Source Source String 50 0 0 DocLinks Linked Documents String 150 0 0 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. 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 GlobalID GlobalID GlobalID 38 0 0 SHAPE.STArea() SHAPE.STArea() Double 0 0 0 SHAPE.STLength() SHAPE.STLength() Double 0 0 0 20190912 iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAEDZJREFUeJzt3dtPVFcbx/GlICAqoICiVunBqEXTpKZJb3rT2Nv+zb3tlWmb lp7QtorWE6gcxQO8+a43z2RLnQM6w8yC7yfZmQGHccLe/PZaaz9r7f6tra2tVMfKykqam5tLP/74 Yzp79mw6dOhQevXqVdrc3Ez9/f35NTw/cOBAmpqaSjMzM/XeSl22vLycfvrpp7S4uJhOnz6d99XQ 0FA6ePBg3Z95/fp1Wl1dTevr6+nPP/9MY2Nj6erVq7v6uaWq/6dOHRzQp06dShcvXkwnTpzIIUW+ scWBzvOBgYE0MjLS6K3UZc+ePcv7anJyMk1PTzcNK/T19eX9Ojw8nP75559d+6zSOwUWAcUBzkEb BzitKZXn5cuX6dixY+n48eN5n+5EBButabZmQSd1JbDyC/r7a90/lWtwcDA/vnjxIm1sbOTWFl0+ TkDsX1rJ9RBQtLb4GYYEGr1W6iSTaJ+gW/fkyZP08OHDHDzPnz/P41oEEWNa58+fb/jzhBTB1WDI U+o4A2ufOHr0aA4lQmttbS138blQcvfu3dpAPBdV6iGo6A7SworWmtSTgcXBSleCq0U8snGGjucc yHEW/vTTT/NZW72Fbh8BNTo6mvcn4cT3CCu6iI8ePcrdw+gy8si4V1wFvn//fhofH7eFpd4OLM6o S0tL6fbt2/kAp1sQZ9o460YJBGfuS5cuGVg93C1kq+LqL62uhYWF2r5lY3wr9i+BxWA9r23UCpO6 HlicaTn7/vDDD+nChQv5ChPdC7oUhw8fzn8AtKjm5+fT7OxsPsA50L2aWIaJiYm8rzjhsE9jv7LR 9fOKoIq7SkhZwyeffJKuXLmSz7RvQ2jRJaSVxc/YLSwD+9YaOu2ZwCJ4ONsSRHQDG72OwGJs68iR IwaWpN0PLLoEMbbRCIFFd4IB22avlaSOXSVsZTwqig+5kmhgSepqHVbMIayHVhhXkJgsa2BJ6mod VpQx1H2j/v7cJXz69KmBJan3u4QEFi0sangkqWuBFVuj1zDwXq18l6SujGE1a2U1CzRJ6qnJz620 xCSpY4HVSgjFFUS6gnYJJXX9KmHM3GdAnS2eE1AMtLMxH61RNbwkdTywGExnwvOtW7fSnTt3cmsr qt9j3mC8hvmGTM2RpK4EFqH08ccf5/mEtKqqS+Yyo5+NKveY7e8SJJK6FlgEEIElSd3kEsmSimFg SSqGgSWpGAaWpGIYWJKKYWBJKoaBJakYBpakYhhYkophYEkqhoElqRgGlqRiGFiSimFgSSqGgSWp GAaWpGIYWJKKYWBJKoaBJakYBpakYhhYkophYEkqhoElqRgGlqRiGFiSimFgSSqGgSWpGAaWpGIY WJKKYWBJKoaBJakYBpakYhhYkvZGYG1tbeXtwIEDeZOkng2spaWltLy8XPu6Glp9fX3p5MmT6eDB g539hJLUSmDNz8+nubm5NDg4mF69epXDidDieX9/f/rmm28MLEm9M4Y1OTmZvvjiize+d+/evfT7 77/n7qIk9URg0Zqi6zcwMPDG9w8dOpQf19fX87+zSVJXA+v169e5+7cdAUVorays5K4hgcb3HM+S tKuBtbm5mQfaaT0tLi7m0NpuaGgoHT9+PD158iS/jtAisGiRxVXFeC++f+bMGa8ySmp/YNGiunnz Znr27FneTpw48Z8fOnLkSDp37lwekF9YWMihFq0xQipaWs+fP89B9e2339ptlNSZwOLq4LVr1+qW LdAdHB8fT2NjY/nreoPvcZVRkjo2hkUAvW2wvYqWE13BRngPWlyS1PNTc6JSXpI6FlhOxZFURGAR VpYnSCqmrIErfu3oytlSk9TRwGKg/NixY+mXX37JWwyu0+qq1mRF+UK0yKKYlIF6vuY5dVxra2tt /cDaGU487KuNjY3afnFmgvZMYHFAX7x4MddQRZV7FIVWr/jxhxBdx+oyNLwmtuHh4TQ9PW3RaIdx ImHWwePHj9Pq6uobreMo4n3x4kUu+KVUhU3aMy2sDz74YEdvQjgRbvzhvHz5svYctLhcS6uz+J3T mmVSOitrVEULmMAizNgfBpb2dVkDfxBRs3X48OF2vKV2GFi0iNkPn3/+ee7Cbz9JsLYZMxjeNtVK KoVLJO8BMcYY65S9rUUbJxQDSyUzsPaAmHy+fYyRbiAXPWhdMefz9u3b6dSpU139rNL7MLD2gFiT jHC6ceNG7SpgrGfGI131Cxcu5FU2pFIZWHsA3UFKUWg9MZ5FSyvKUbjqy+oaR48ezVdtY/FFqUQG 1h4xMTGRN2kvM7AkFcPAUtdFJT7dWbqyXNHcXk8mwcBSR4MoVq6laJVAqlbhx+yImDHB63nNyMhI unz5sntG/2FgqWMIIFadpbyiOn0rVL+O0oynT5/Wgs0ZEtrOwFJHA+vBgwf5JiRsXMlsNPGakOJ+ l7TIKHBttqKt9h+PCHUMLSTKKRiPamWViKgbi6r9qCGTgoGljiFsWCGi3v0t6/1MVOk78K7tDCx1 FIFFWBFArYhi1xj3soWlKgNLHUPY0ErixrwMpDcTE7MJqlZer/3HwFLHu4RMvCa02Botv01LjIUI efRuS3obA0sdDSzmMVKqwOKCd+7cyYFEd4+B9Vi+OQbXKRhlkjYLDI6Ojtod1H8YWOp4YM3MzORK dsamYquOTcXzKCJlHIuupONX2s7AUkfRemJSNl3BuFmJ9VV6VwaWOi5WO5Xel4ElqRgGlqRiGFiS imFgSSqGgSWpGAaWpGIYWJKKYWBJKoaBJakYBpakYhhYkophYEkqhoElqRgGlqRiGFiSimFgSSqG gSWpGAaWpGIYWJKKYWBJKoaBJakYBpakYhhYkophYEkqhoElqRgGlqRiGFiSimFgSSqGgSWpGAaW pGIYWJKKYWBJKoaBJakYBpakYhhYkophYEkqhoElqRgGlqRiGFiSimFgSSqGgSWpGAaWpGIYWJKK YWBJKoaBJakYBpakYhhYkophYEkqhoElqRgGlqRiGFiSimFgSSqGgSWpGF0NrNevX6dXr17l7eXL l7WveRwaGkpjY2Pp4MGD3fyIkvZzYC0uLqY7d+7Uvo5A2tzcTH19fXlbWlrKgXXgwIF0/Pjx3f6I knrUrgbW1tZWevbsWbp161aamprK4XTo0KHU399fez4wMJBfs7q6mpaXlw0sSd0JLFpMbEeOHElf fvll3e7e4OBgevz4cVpfX9/Nj6c2n5xoNW/f+H78e9Xw8HA+Hjg+pJ7pEnJQ0qJqhH+nhfXgwYN0 6dKlXftsah/GIldWVnIr+cmTJ/n58+fP04sXL/J4ZQQWr+P5119/nccsaWlLPRNYceZtZHR0NI2M jKSnT5/u2udS+3CyuXv3brp582Y6depUOnz4cDpz5kxuORNI1ZYUYfb333/nEItxTKmosgbGsTi4 vUJYJq7ysjEmefLkyTwEwP7k6wisQHA9fPgwn8i2dxOlIgKLg5iD2rNt51q4BEo8soFAaceJgv3H e504cSJNTk7m92z0WvazYaWeDaxWzqYxQM/rHIhtDwKKCxmMJ0VQ0RVjXInnDHyfPXs2t3DfR+w7 xqeaYf9GeBpa6slBd86oGxsbudaq3tmc77PxOv6A7B6+P4Lq119/TX/88Uc6ffp0DihaP4QLQcaY 0/j4eFsCCwRhsxCqXk00sNRzgUVY8QfBmb1RV6H6uvf9A9L/EQqE1EcffZSuXr1aOynQElpYWMil JPE6woaTBb9/wiw2vlftSkbQ8EhQ8e+MWfH/tBJA7OfohtqSVs+2sLjEzTgHB2kc+DE9h42SBgpI +cPhKpMtrPdHgPB75PdJCUHg903QsF9+++232n6JfRU/x4kjZiBEuMRjhBNX/XivtbW12thYMwaV ejawOJtyBr5//36egoMYp+JMHyUPPD927Fjtj0edKyshjNgn58+fr41nUQvHRkDxyH7jefVKH4/V 8AJX/O7du5enYLV65S8+k11C9Vxg8YfBpe7Z2dkcWBz4/BHEeBZ/HHxNC4DXEloGVmfx+z169Gj6 7LPP2vJe21tfrTCw1JOBRbeCYkJCK9Q7sA2q8kTXPbqRzfZhnLC2t9Sknilr8ODcu2Iie3Tvq928 KKOoLilE15HBflrSdglVZOGoykVgRSuLx59//vmNAuAYzI/WF8FF95+pWM3mmEptP0KipgbVos84 QG32720xEM+YJFXulELE1cIYqI9xylhSiAF9QsvA0nsFVjTRm4UMJQpcyub10dyvhhPf56CkNsea qu6JfdLJEpE4MVE6MTMz07H/R/tTw8CKpT+ahQwL8s3NzdXGLNg4w/JzPGesgq9ZKoapH+qOKMZt tT7qXRBWHAetTMuR3jmwKDGgfoZlQQgYmucUbtJUv379esM3IZRo/l++fPk/Z9qYv0ZBIjU+6i72 M1NweIx1qSJgeP7VV1/lAfBmeC2talrXLCfDscLaV+xjlgWiheU8UHUssLhSQ5Uy0zZimsVff/3V cuEfARVz06pijaOYyKzuYd8wh5BxI2rcosvOPiJwaCXH8tScZAijuDFIvSLQGJNi/8dNQ2INLKlj gcXByYH74Ycf1sY4+B5nzWYijDiw6XJsH/Pi6+rVI3VHrE/FBOco0o1WMOUFjx49yq0jQiimSEVQ 1QurGJtkI6SiQt65gepoYMWBFqso7ORqXvxsvRZUrI9kYHVXnDi2X42LQfJz587VxizpFtIKiyt6 XuFVL6gduRyksZZ6LDlCi6mVcac4qBuxO9i74sYgV65c6fZHkVoPLEKHbmC1nKHVlhbjXzdu3Mjv Q8hVu4G02uheWIMlqW2BBW5yGrVU8/PzLYXMxMREbVE+AirCKWb1M0bC+3tTVEltCSzGrRg4ZfCV S94EDuMYfK8ZplXwuu21N9UWmoPuktoWWAy60lIidAgvwooSh1Yq02NQvdk4liS1JbDovlFHU12J UpJ6idPjJRXDwJJUDANLUjEMLEnlB9bbKtMt/JTUE4EVs/JjwmusvR3BFUvZ7nSeoSS1S//3339f mwwby8TEbP2oVueRZUdYNoTlSVpZL0mS2q0/Jj0jAipWXoglSHjOMjPczZfpNwaWpG7ov3btWtMX xRrtrOSw/a7BktSTVwlZhcG1uiX1dGDRuoqlj13XSlLPt7Bi1UkDS1LPB1asc+UYlqSe7xISWNRm teuednEPw3heDcK46UF0Ra37krSjwKJgNMJlp6IQNRb04z1iKeb4N8olAl+z0Q09c+bMW+/EI2n/ ablL+K4rhnJVcWFhIX333Xc5dFgmOUKLVUpjCWUQitVbjEWLjru5bL/foaT9Z0dlDYTIu5Q1EDrc D4+pPTzG4H3cF6/2YSq3n6JQlaCjWNVxM0k5I2ZnZ2vV7HHH5+rUnAgUWjt0zVpZ473euu9TU1O5 i9cKuoN0E7kDsSTlwPr3339zEBFYEVKERbSkCC/w9fT0dL5r8E7xHjsdsI/grA7OS9rf+q9fv97R /4AxKW7SGcG3EwRVdcUISftbzy7gF6tGMB3IwJK0q4G10wF7woquqWEladcDa6d1VDHgHwsKSkr7 3v8AHA/C25XmZlgAAAAASUVORK5CYII=