20190406
12474800
1.0
FALSE
CityGIS.DBO.ZoningCurrent
002
Server=lbbesripubdb01; Service=sde:sqlserver:lbbesripubdb01; Database=GISProd; User=col; Version=dbo.DEFAULT
ArcSDE Connection
893037.991203
979539.518330
7226553.645648
7320758.209535
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.6'><WKT>PROJCS["NAD_1983_StatePlane_Texas_North_Central_FIPS_4202_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0],PARAMETER["False_Northing",6561666.666666666],PARAMETER["Central_Meridian",-98.5],PARAMETER["Standard_Parallel_1",32.13333333333333],PARAMETER["Standard_Parallel_2",33.96666666666667],PARAMETER["Latitude_Of_Origin",31.66666666666667],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2276]]</WKT><XOrigin>-123407700</XOrigin><YOrigin>-86123500</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102738</WKID><LatestWKID>2276</LatestWKID></ProjectedCoordinateSystem>
FeatureClassToFeatureClass S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2 S:\gisds\Projects\Zoning\PlanningZoning.gdb\PlanningZoning ZoningCases2 # "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,Conditions,-1,-1;DesignHistoric "DesignHistoric" true true false 2 Short 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,DesignHistoric,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_ActionDate" true true false 2 Short 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,Notes,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,SHAPE_Length,-1,-1;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningNewSchema.gdb\ZoningCases2,SHAPE_Area,-1,-1" #
Sort ZoningCases2 S:\gisds\Projects\Zoning\PlanningZoning.gdb\PlanningZoning\ZoningCases "CityCouncil_ActionDate ASCENDING" UR
DeleteField "Zoning Cases\Zoning Cases" DesignHistoric
Append ZoningPending ZoningCases NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,ZoningPending,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,ZoningPending,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,ZoningPending,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#;SpecificUse "SpecificUse" true true false 2 Short 0 0 ,First,#,ZoningPending,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 0 ,First,#,ZoningPending,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 0 ,First,#,ZoningPending,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,ZoningPending,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,ZoningPending,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_ActionDate" true true false 2 Short 0 0 ,First,#,ZoningPending,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,ZoningPending,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 0 ,First,#,ZoningPending,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,ZoningPending,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,ZoningPending,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,ZoningPending,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,ZoningPending,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,ZoningPending,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,ZoningPending,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,ZoningPending,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,ZoningPending,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,ZoningPending,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,ZoningPending,Notes,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,ZoningPending,SHAPE_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,ZoningPending,SHAPE_Area,-1,-1" #
CalculateField ZoningCases SUFor Townhomes VB #
Append 'Reference Data\Annexation\Annexation Areas by Ordinance' Zoning\ZoningCases NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Reference Data\Annexation\Annexation Areas by Ordinance,NUMBER_ORD,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#;SpecificUse "SpecificUse" true true false 2 Short 0 0 ,First,#;Conditions "Conditions" true true false 2 Short 0 0 ,First,#;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 0 ,First,#;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 0 ,First,#;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Reference Data\Annexation\Annexation Areas by Ordinance,DATE_ORD,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 0 ,First,#;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#;Notes "Notes" true true false 255 Text 0 0 ,First,#;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#" #
AssignDomainToField "Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases" ZoningActual "Zoning Fields" #
Append 'Zoning Cases Pending' "Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases Pending,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases Pending,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases Pending,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases Pending,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases Pending,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases Pending,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases Pending,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases Pending,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases Pending,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases Pending,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases Pending,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Zoning Cases Pending,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,Zoning Cases Pending,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,Zoning Cases Pending,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,Zoning Cases Pending,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,Zoning Cases Pending,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Zoning Cases Pending,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Zoning Cases Pending,Shape.STLength(),-1,-1" #
CalculateField "Zoning Cases" CaseNumber "2565" VB #
CalculateField "Zoning Cases" CaseNumber "ANNEXATION ZONING" VB #
CalculateField "Zoning Cases" SpecificUse "0" VB #
CalculateField "Zoning Cases" Conditions "0" VB #
CalculateField "Zoning Cases" MinorChangeToCLUP "0" VB #
CalculateField "Zoning Cases" CityCouncil_Action "0" VB #
CalculateField "Zoning Cases" SpecificUse "0" VB #
CalculateField "Zoning Cases" Conditions "0" VB #
CalculateField "Zoning Cases" MinorChangeToCLUP "0" VB #
Append zc2126a "Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,zc2126a,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,zc2126a,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,zc2126a,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,zc2126a,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,zc2126a,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,zc2126a,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,zc2126a,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,zc2126a,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,zc2126a,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,zc2126a,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,zc2126a,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,zc2126a,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,zc2126a,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,zc2126a,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,zc2126a,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,zc2126a,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,zc2126a,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,zc2126a,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,zc2126a,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,zc2126a,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,zc2126a,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,zc2126a,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,zc2126a,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#;created_date "created_date" false true false 8 Date 0 0 ,First,#;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#" #
Append 'Zoning Cases Pending' "Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases Pending,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases Pending,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases Pending,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases Pending,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases Pending,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases Pending,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases Pending,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases Pending,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases Pending,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases Pending,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases Pending,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases Pending,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases Pending,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Zoning Cases Pending,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,Zoning Cases Pending,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,Zoning Cases Pending,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,Zoning Cases Pending,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,Zoning Cases Pending,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Zoning Cases Pending,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Zoning Cases Pending,Shape.STLength(),-1,-1" #
CalculateField "Zoning Cases" SUFor "Townhouses" VB #
CalculateField "Zoning Cases" SUFor "Veterinary hospital or clinic" VB #
CalculateField "Zoning Cases" SUFor "Garden home" VB #
CalculateField "Zoning Cases" OrdinanceNumber "008948" VB #
Append S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output "Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#;created_user "created_user" false true false 255 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,S:\gisds\Projects\Zoning\PlanningZoning.gdb\Export_Output,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#" #
Append Export_Output "Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Export_Output,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Export_Output,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Export_Output,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Export_Output,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Export_Output,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Export_Output,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Export_Output,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Export_Output,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Export_Output,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Export_Output,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Export_Output,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Export_Output,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Export_Output,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Export_Output,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Export_Output,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Export_Output,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Export_Output,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Export_Output,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Export_Output,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Export_Output,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Export_Output,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Export_Output,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#;created_user "created_user" false true false 255 Text 0 0 ,First,#,Export_Output,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,Export_Output,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,Export_Output,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,Export_Output,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#" #
Append 'Pending Zone Cases' "Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Pending Zone Cases,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Pending Zone Cases,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Pending Zone Cases,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Pending Zone Cases,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Pending Zone Cases,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Pending Zone Cases,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Pending Zone Cases,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Pending Zone Cases,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Pending Zone Cases,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Pending Zone Cases,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Pending Zone Cases,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Pending Zone Cases,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Pending Zone Cases,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Pending Zone Cases,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Pending Zone Cases,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Pending Zone Cases,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Pending Zone Cases,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Pending Zone Cases,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Pending Zone Cases,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Pending Zone Cases,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Pending Zone Cases,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Pending Zone Cases,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Pending Zone Cases,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,Pending Zone Cases,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,Pending Zone Cases,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,Pending Zone Cases,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,Pending Zone Cases,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Pending Zone Cases,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Pending Zone Cases,Shape.STLength(),-1,-1" #
FeatureClassToFeatureClass "Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases" C:\Users\17638\Desktop\CityDec2018.gdb ZoningCurrent # "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,GlobalID,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,last_edited_date,-1,-1;Shape_STArea__ "Shape_STArea__" false false true 0 Double 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,Shape.STArea(),-1,-1;Shape_STLength__ "Shape_STLength__" false false true 0 Double 0 0 ,First,#,Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning\CityGIS.DBO.ZoningCases,Shape.STLength(),-1,-1" #
FeatureClassToFeatureClass C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent "Database Connections\COL@CityGIS.sde\CityGIS.DBO.Zoning" ZoningCurrent # "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,last_edited_date,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,C:\Users\17638\Desktop\CityDec2018.gdb\ZoningCurrent,Shape_Area,-1,-1" #
Append 'Zoning Cases' "Current Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Zoning Cases,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STLength(),-1,-1" #
Append 'Zoning Cases' "Current Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Zoning Cases,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STLength(),-1,-1" #
Append 'Zoning Cases' "Current Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Zoning Cases,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STLength(),-1,-1" #
Append 'Zoning Cases' "Current Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Zoning Cases,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STLength(),-1,-1" #
Append 'Zoning Cases' "Current Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Zoning Cases,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STLength(),-1,-1" #
Append 'Zoning Cases' "Current Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#,Zoning Cases,GlobalID,-1,-1;created_user "created_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Zoning Cases,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Zoning Cases,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STArea(),-1,-1;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#,Zoning Cases,Shape.STLength(),-1,-1" #
Append 'Zoning Cases - Sorted' "Current Zoning Cases" NO_TEST "CaseNumber "CaseNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases - Sorted,CaseNumber,-1,-1;ZoningActual "ZoningActual" true true false 50 Text 0 0 ,First,#,Zoning Cases - Sorted,ZoningActual,-1,-1;OrdinanceNumber "OrdinanceNumber" true true false 50 Text 0 0 ,First,#,Zoning Cases - Sorted,OrdinanceNumber,-1,-1;SUFor "SUFor" true true false 255 Text 0 0 ,First,#,Zoning Cases - Sorted,SUFor,-1,-1;SpecificUse "SpecificUse" true true false 2 Short 0 5 ,First,#,Zoning Cases - Sorted,SpecificUse,-1,-1;Conditions "Conditions" true true false 2 Short 0 5 ,First,#,Zoning Cases - Sorted,Conditions,-1,-1;MinorChangeToCLUP "MinorChangeToCLUP" true true false 2 Short 0 5 ,First,#,Zoning Cases - Sorted,MinorChangeToCLUP,-1,-1;ZoningFrom "ZoningFrom" true true false 250 Text 0 0 ,First,#,Zoning Cases - Sorted,ZoningFrom,-1,-1;ZoningRequested "ZoningRequested" true true false 250 Text 0 0 ,First,#,Zoning Cases - Sorted,ZoningRequested,-1,-1;CityCouncil_Action "CityCouncil_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases - Sorted,CityCouncil_Action,-1,-1;CityCouncil_ActionDate "CityCouncil_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases - Sorted,CityCouncil_ActionDate,-1,-1;PZC_Action "PZC_Action" true true false 2 Short 0 5 ,First,#,Zoning Cases - Sorted,PZC_Action,-1,-1;PZC_ActionDate "PZC_ActionDate" true true false 8 Date 0 0 ,First,#,Zoning Cases - Sorted,PZC_ActionDate,-1,-1;ApplicationDate "ApplicationDate" true true false 8 Date 0 0 ,First,#,Zoning Cases - Sorted,ApplicationDate,-1,-1;ContinuationHistory "ContinuationHistory" true true false 250 Text 0 0 ,First,#,Zoning Cases - Sorted,ContinuationHistory,-1,-1;AddressOrLocation "AddressOrLocation" true true false 255 Text 0 0 ,First,#,Zoning Cases - Sorted,AddressOrLocation,-1,-1;Legal_Description "Legal_Description" true true false 350 Text 0 0 ,First,#,Zoning Cases - Sorted,Legal_Description,-1,-1;SubdivisionName "SubdivisionName" true true false 125 Text 0 0 ,First,#,Zoning Cases - Sorted,SubdivisionName,-1,-1;ProposedDevelopment "ProposedDevelopment" true true false 250 Text 0 0 ,First,#,Zoning Cases - Sorted,ProposedDevelopment,-1,-1;ApplicantName "ApplicantName" true true false 250 Text 0 0 ,First,#,Zoning Cases - Sorted,ApplicantName,-1,-1;ApplicantFor "ApplicantFor" true true false 250 Text 0 0 ,First,#,Zoning Cases - Sorted,ApplicantFor,-1,-1;Notes "Notes" true true false 255 Text 0 0 ,First,#,Zoning Cases - Sorted,Notes,-1,-1;GlobalID "GlobalID" false false false 38 GlobalID 0 0 ,First,#;created_user "created_user" true true false 255 Text 0 0 ,First,#,Zoning Cases - Sorted,created_user,-1,-1;created_date "created_date" true true false 8 Date 0 0 ,First,#,Zoning Cases - Sorted,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0 ,First,#,Zoning Cases - Sorted,last_edited_user,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0 ,First,#,Zoning Cases - Sorted,last_edited_date,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#" #
20190114
09522100
20190114
09522100
50000
5000
ItemDescription
Microsoft Windows 7 Version 6.1 (Build 7601) Service Pack 1; Esri ArcGIS 10.6.1.9270
Map
1
-102.036865
-101.743016
33.711025
33.444589
This dataset contains all zoning cases within the City of Lubbock.
Planning Department, GIS & Data Services, City of Lubbock, TX
planning
zoning
PZC
zone case
City of Lubbock
<DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>This data set was created using data obtained from various sources, and created exclusively for the internal use of the City of Lubbock. Portions of the information may be incorrect or not current. Any person or entity who relies on any information obtained from this data set does so at their own risk. Neither the City of Lubbock, Texas, nor any agency, officer, or employee of the City of Lubbock, Texas, warrants the accuracy, reliability, or timeliness of such information. THIS PUBLICATION IS PROVIDED 'AS IS' WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NONINFRINGEMENT. THE CITY OF LUBBOCK SHALL NOT BE LIABLE FOR ANY DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES RELATED TO THE USE OF THIS PUBLICATION, EVEN IF THE CITY OF LUBBOCK IS ADVISED OF SUCH DAMAGE. BY USING THIS DATA, THE USER AGREES TO BE BOUND BY ALL PARTS OF THIS DISCLAIMER.</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV>
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
5995
Simple
FALSE
5995
TRUE
FALSE
CityGIS.DBO.ZoningCurrent
Feature Class
5995
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.
CaseNumber
CaseNumber
String
50
0
0
ZoningActual
ZoningActual
String
50
0
0
OrdinanceNumber
OrdinanceNumber
String
50
0
0
SUFor
SUFor
String
255
0
0
SpecificUse
SpecificUse
SmallInteger
2
5
0
Conditions
Conditions
SmallInteger
2
5
0
MinorChangeToCLUP
MinorChangeToCLUP
SmallInteger
2
5
0
ZoningFrom
ZoningFrom
String
250
0
0
ZoningRequested
ZoningRequested
String
250
0
0
CityCouncil_Action
CityCouncil_Action
SmallInteger
2
5
0
CityCouncil_ActionDate
CityCouncil_ActionDate
Date
8
0
0
PZC_Action
PZC_Action
SmallInteger
2
5
0
PZC_ActionDate
PZC_ActionDate
Date
8
0
0
ApplicationDate
ApplicationDate
Date
8
0
0
ContinuationHistory
ContinuationHistory
String
250
0
0
AddressOrLocation
AddressOrLocation
String
255
0
0
Legal_Description
Legal_Description
String
350
0
0
SubdivisionName
SubdivisionName
String
125
0
0
ProposedDevelopment
ProposedDevelopment
String
250
0
0
ApplicantName
ApplicantName
String
250
0
0
ApplicantFor
ApplicantFor
String
250
0
0
Notes
Notes
String
255
0
0
GlobalID
GlobalID
GlobalID
38
0
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20190114
/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iiigAooooAKKKKACiiigAooooAKKKKACiiigCtcyIlvIGZQdhwCfase3lt0l3yuoVVJHuas6oQLoZ/uD+ZqS4hMIe7yHwoAQj1AHWtFovU3j7sfUykJWKMDGSOpFdFbDFrF/uD+Vc7Go8ry3GSvYjt2rpIOLeIf7I/lVVdkXiNkS0VRhvRNOYthHXBz6VerJqxzNNbhRRRSEFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFMZ0TG5lXPqcU3zov+eif99CgCWimqysMqQR7GnUAFFVrq4NvFvC7iTjBOKoDWJN5X7MpwRz5vb16VSi3sXGnKSukX7xFa0mJUEiNsEj2pL4KbKbcM/Lx9e361m3l+08PkiEDecH5+3X09qyroTxxMwjDx4GV3k9/pVKm92aRoS3ZbH+tb/dH9aaC4iLiRxgZ4OKiV0MPnCBgu3PHBxSRPFPCHjjlKEf3sf1rc7HZ7mrDYStEkizhSyg8ZB59wa04EaOFUdizAYLHvTLMg2cJ5xsHWrNczk3uefObk9QoooqSAooooAKKKKACiiigAooooAKKKKACiiigDOv7Q3RQApwOjGsaQ7LjYf4QVYdhyBnNW7vU0i1RIyse9chMsQehzxVSXUY7jUgrLFGzqQoDZLEE+1bQvsdVLmSS6Fq2uPs8gdAGXbjbuxVqbWYoogwidm7rkfLWG8cF3JuliH7voAxyTgHp+NQzxqwQmOGNWB6HGRgkZ49hVSinqaTpqTuzXvL572AQNbbQ56lgR0PaqLRKsQKxxxKHAypx/F6Y/zms+1umh2q0LPhiC6qCwH+fx+tLeuJBG1vM7K0i9G+UrnJ9s9aEkloOKUVoamwQsGLnBbJz0HBp0sqrAzBuo4I9az/tAPm7zIVjJLZOQBj9etVnEhs5GgdQhbKknqxAXjH4frVXL5jXaMLbkkvkLnlz6fWmwCNoVCSEkKM4aqNzenyHVgDkYwGP/AMT9KshZshFeSPjqwXn9KLhdElus0aANK6rjs3HtXRWJZrKEsSSV6nqawI4fkUmRycDrg/0pjX88OxIpZXwOQGP+fwqJxvsZVKfMlY62isy21GEWyCWRjIB8x2k8/lV6ORJYw6HKnocYrFpo5HFrdEtFFFIkKKKKACiiigAooqC6lMNs8i4yoyM0AlcJLmCIHzJkXHqwFILu2IyJ48f7wrmriVCTMFQs8rE5P1qO1jZoTiXKeYTnjpn6VqqZ0rD+Z1QuYD0lQ/8AAqUTwt0lQ/RhXLqmJSqKSOhYEA84qVIoYY2CKNuckAUey8x/V/MXWYIRqjuPlbyN27r35+nash7W2urr7TGwLLF3b7rEHn681L5A+2SzSRIFXoo24x7+9QJp1ubmYlSVXGwI+N3fA5x271aVlY0jFqKQxpQkLnyh5gY42rhsDnj8q07KBJLRWdPmbnuCKz3s4DflBHOhZfvLITuBPQHt9PardvDHaBd11L5ZGAjEjBJ6/rTRUb31JrqCOIJKi4cEjduOcEHPesW/SSF/NikYF5MbcnBAz19/etye2hukCMWkAOQN3ANY+paetvapIks5cTqF+fIGevGD70MJrQqW90oaSGdJFRmAZehOR29uM1fsTFLa3FrG5aMuPLyOgwtUrO1j1CVBdST+YgOBjDDnH90VdSzayVpDIEEbKyAjjrzn8/5UlciN9y69sIYpI4Y9zEhQWA745/Cpg8scLC4liDFeAT09ee9U7+/CW7slwgkUYAU8kkf/AF6rxSqbZdjeZd7M5K5KnnOT/Sncu6TNOO5by1RQJG+7uQ5HTrWpZ6SgtImaT52AYnb3NYoVV2jzFdmYMcE9c/WuutDmzgP/AEzX+VRUk1sZVpyjaxSGlbRgTn/vmr8EXkwrHnO3vU1FZuTe5zSnKW7CiiipJCiiigAooooAKjm/1L5GflNSU1lDKVPIIwaAOXW1ijg8uONRgccd6baWyQRuq4+ZjkA5Are/sy27K4/4GaQaVbjO0uuTk4I/wrf2kTs+sQ7HN/YrVbgiNXL8khXIx+vvVV4DumSITKAwIUP6Yznn3rTuLFBPMVaQEsV3AgEjp/SqqW7qJTuLAsdoWQqRz/XFUtTRNNXRRWyjVZ5CJyD8qKZO/rwaILVp23SmRSp27Y5D15Azg+nH40GBpll2vIjZ2orOcDbjPUcntUVs8kM7xSPODIRtEW3JPbqOOKQi9bSQ2V08U4xIcsjEZO3049KgvY7jUtQCIZooY17/AC7jn0P+eKdLpLTXfnT3EpYAY4B/pTlhuklZ1vm5J5eNTjn6dKfkGuzGWsl5FdCM5S08okEoN27POcDHepJ4mvVijW5BxKGKlMHOCailtJYSVivwpUH5fI3dfzp8AnEMXlXlvuA3MGjyc474PHWjyBdmSvbtFqEe1lYmJhgjGMEHtVSe6l/s3zdoEhdCQ/OTvU+vTGKYbm7a+iR5oG3q7sQmCo9OTnsKbcsZvs80LKU81UKdecDt1PSkK/YWS8eS3Ek1xHCxxtCRck56dSK0liaKAxxtklWJLZOSf61lrp7ssuAFLHu2RgHr7VqxzyG3ixETgAM4IwQBzTQ4+YrW0sjbgEPQE7iM4NdXaoY7OFCxYqgGT34rDHypzjgdq6CMYiQeiis6vQxxK2JKKKKyOYKKKKACiiigAooooAKKKKACiiigDl5932mQtLMAJHAAGRjcfaqqsHgcg57g7CewPWrN4IhcSs24tvfCr1PzelZ3lTC3dVn2zFwQAc47YOOldK2PQjpFIsRot3Cdw2pk54wf/rVlPbtauDHOyleFbG0DjryOasKjyq8RmUhPk3DgZJxz71Dp1rc3FtJtuwQJOSy5OQBxn05NDE3cW3n1GS5mH2kj92HB8vIxj/H0qSA6lDCokvLYZBY+YpY9frUUDX4lM8TQvsXBwcgLgkKRn6Vbtb8l3+1SQAnjCggf54pIEMC6mwLnyCWGUHTv14/xpGi1OIxMxtc56MSMHH19zRqUr/bYP36pGF3YAz64NOe5jZrZd67TkMxJAJ45NMOpnyG4sb+KeZY+AY2O5iCT3/8A1Vba2kMdslqUVXnMgyTxwe3px+tOuXjiAMi2hCqVRh87ewqe3lUvCH2KTuyDx69PalYEhLhG2vCsSgySAB1fp0PT86W2t7tBteKIxuOSG6fpVlkLqAGgyxHKr+PrTQ91HJyocBQOFOKZViYiQA4jCjBzhq6uuTnlk8soImBcEA5HB/Ot6xinjMnnZwcbQWz65qKhhiFsXqKKKxOUKKKKACiiigAooooAKKKKACiiigDipVn+1ySPcMqvIxBCDgEn296ixeTbGimSNjIePL6gZ7n+laMspAbDouFyMj/69Urd7mZ1xIvlrK43YGT1/wDr10pHoJaJFMR3kUsqJMq/NyCmQWyDmrUBubcGNxG0YICgfId2Bx7/AI02JZI5n3IJeeck5Jzj/Co4HkkMskgXCuMbWKjsMe/agFoLbvqCXFxI8UYU/wDLFmAwPXjrVO+a5mnaSKHyyq7W2LkH6tjH/wCupCZZ9Sc3CIG4HydBjBA/WpBdTQ3MsZi+QR4kjLAZPqD+dIndEr21xd3EUsqKYBH0DA5Pvx6+lU5JJJby3SSBP3asfLRuCAOpOMdjVz7ZLF5sEccaRon7pVYEn6/j9KFkuBcCFLNCiIGOTgk459u9Megltb3F9KkaW0Rmx5gLORwMc/rWrb6PN5YMtt86nB3Sbu3Ue1VdHuIrW+TNu6Eow49+a6q1nFxbpMqlQ2eD9azlJp6GM5yi9NjFh0mRJQfs6IAWwVwOMHA/OoBo90kZWMzR54+Vl/TJrqaKnnZn7aV7nNJp96sOySF5c85LDP8AOtbTrqSeHZcIY504ZT396v1G0SM6uVG5ehpSlzbilUc9ySiiipMwooooAKKKKACiiigAooooAKKKQ8g4oA5fLvDjZ1X1pltCbdNoiH13da1Bpk6qAGj49z/hVd7G8c7fKdQO6sOa6VOJ6CqQfUy5YnYsI0RiWLH5uRmobVZ5Mwx28byFwCW4x35FaM8U1r8oiDTYz87AZ6nr68Vn2M8cdyl0YgJHk3DA3bTznocjp6VMpdiJTSXuleWA/bZiVKyRE7wCAM45HQ4ojUrPcrJHuMig5jOSo5Gfy5q0VNxqM080e/c2W2ZIzjgfkagWdYbif9xIcsF9Npx3/DFNbalLa7M+0gWy1SSG2uJ5C2MeZyenPaui0fT7p9RZr6KURqh25yATxWcHjN27hGUttYAEZwO+D7V01trVoIIlkkbzNgzkVMrpaGVTmS90vy20MyqHXIXpyRinxRJDGsaDCr0FQ217b3hYQybivJ4Iq3WJzO+zCiiigQUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAGDqxxfRn0x/JqqWltEZIkC4DOxOPo1FFb/Yudi0p38hkUe26uYyxJEhGRxnAA6VTIxNck8qXAwf90DrRRVLZGkfhRLBbqb+5GTwoA9sgVcn0iHT5ZJYpJCzgL8x6ACiiok9UZybU4o0tJ++/+6K1aKKzn8RhW+NhRRRUmQUUUUAFFFFABRRRQAUUUUAf/9k=