Name: ZoningUses

Display Field: Zone

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Consolidated zoning land-use matrix. Primary generated zoning layer containing zoning geography and calculated land-use permission attributes. This layer represents the consolidated output used to answer “What can you do here?” zoning questions. It starts from current SDE zoning outside MTC areas, removes current zoning areas that are superseded by matching ZBL planned-development byproducts, appends PD records derived from the ZBL/current-zoning intersect, appends MTC records from the SDE MTC layer, and calculates land-use status fields plus summary buckets. Source data includes SDE Zoning (sde.SDE.Zoning\sde.SDE.Zoning), SDE MTC (sde.SDE.Planning\sde.SDE.MTC), ZBL_aliased geodatabase layer, Use_Table.xlsx, and Use_Table - PD Test.xlsx. Processing lineage: Created as zoning_uses in the script. Non-MTC zoning is selected from SDE zoning; ZBL intersections are selected where the zoning ordinance matches the ZBL ordinance; matched current zoning is erased; PD features are appended with ZoningType formatted as PD_<ordinance>_<PD zone>; MTC features are appended from SDE MTC excluding Pedestrian A and Pedestrian B. Use values are calculated from standard and PD Excel use tables. Update frequency: Regenerate after updates to SDE zoning, MTC, ZBL_aliased, standard use tables, or PD use tables. Review unmatched ordinances, missing PD sheets, and warnings emitted by the Python script.

Copyright Text: Created and maintained by the City of McKinney GIS Department, Planning Department

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2498294.006875947
YMin: 7097948.6820207685
XMax: 2568280.749725133
YMax: 7161361.999775827
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FilterID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: X
  Label: X
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [201, 252, 182, 0]
  Outline:
  Style: esriSLSSolid
  Color: [216, 122, 48, 255]
  Width: 0
• Value: P
  Label: P
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [179, 255, 71, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 0
• Value: A
  Label: A
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [245, 176, 27, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 0
• Value: C
  Label: C
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [197, 248, 250, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 0
• Value: M
  Label: M
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [30, 118, 150, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 0
• Value: S
  Label: S
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [125, 34, 156, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 0
• Value: T
  Label: T
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 209, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 255, 255, 255]
  Width: 0
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Zone ( type: esriFieldTypeString, alias: Zone, length: 100 )
• ZoningType ( type: esriFieldTypeString, alias: ZoningType, length: 50 )
• AttFID ( type: esriFieldTypeInteger, alias: AttFID )
• AccessoryBuildingDetached ( type: esriFieldTypeString, alias: AccessoryBuildingDetached, length: 4000 )
• AccessoryDwellingUnit ( type: esriFieldTypeString, alias: AccessoryDwellingUnit, length: 4000 )
• AccessoryStructure ( type: esriFieldTypeString, alias: AccessoryStructure, length: 4000 )
• AgRanchPrivWhlsl ( type: esriFieldTypeString, alias: AgRanchPrivWhlsl, length: 4000 )
• AgriculturalAndRanchingRetail ( type: esriFieldTypeString, alias: AgriculturalAndRanchingRetail, length: 4000 )
• AirptHeliLandFieldAcftHngr ( type: esriFieldTypeString, alias: AirptHeliLandFieldAcftHngr, length: 4000 )
• AirportTerminal ( type: esriFieldTypeString, alias: AirportTerminal, length: 4000 )
• AmenityCenterNeighborhood ( type: esriFieldTypeString, alias: AmenityCenterNeighborhood, length: 4000 )
• AnimalCareSvcInOnly ( type: esriFieldTypeString, alias: AnimalCareSvcInOnly, length: 4000 )
• AnimalCareSvcOutArea ( type: esriFieldTypeString, alias: AnimalCareSvcOutArea, length: 4000 )
• AnimalCareSvcOutBoard ( type: esriFieldTypeString, alias: AnimalCareSvcOutBoard, length: 4000 )
• ArtsOrCulturalCenter ( type: esriFieldTypeString, alias: ArtsOrCulturalCenter, length: 4000 )
• AssistedLivingFacility ( type: esriFieldTypeString, alias: AssistedLivingFacility, length: 4000 )
• AutoMcycleTruckBoatRentalSales ( type: esriFieldTypeString, alias: AutoMcycleTruckBoatRentalSales, length: 4000 )
• BanksAndFinancialServices ( type: esriFieldTypeString, alias: BanksAndFinancialServices, length: 4000 )
• BatchPlant ( type: esriFieldTypeString, alias: BatchPlant, length: 4000 )
• BatchPlantOutdoorTemporary ( type: esriFieldTypeString, alias: BatchPlantOutdoorTemporary, length: 4000 )
• BedAndBreakfast ( type: esriFieldTypeString, alias: BedAndBreakfast, length: 4000 )
• BodyArtStudio ( type: esriFieldTypeString, alias: BodyArtStudio, length: 4000 )
• CarWash ( type: esriFieldTypeString, alias: CarWash, length: 4000 )
• CaretakerSOrWatchmanSQuarters ( type: esriFieldTypeString, alias: CaretakerSOrWatchmanSQuarters, length: 4000 )
• Cemetery ( type: esriFieldTypeString, alias: Cemetery, length: 4000 )
• CivicClubFratOrg ( type: esriFieldTypeString, alias: CivicClubFratOrg, length: 4000 )
• ClinicMedicalOrDental ( type: esriFieldTypeString, alias: ClinicMedicalOrDental, length: 4000 )
• CollegeOrUniversity ( type: esriFieldTypeString, alias: CollegeOrUniversity, length: 4000 )
• CommercialEntertainmentIndoor ( type: esriFieldTypeString, alias: CommercialEntertainmentIndoor, length: 4000 )
• CommercialEntertainmentOutdoor ( type: esriFieldTypeString, alias: CommercialEntertainmentOutdoor, length: 4000 )
• CommercialLaundry ( type: esriFieldTypeString, alias: CommercialLaundry, length: 4000 )
• CommunityCareFacility ( type: esriFieldTypeString, alias: CommunityCareFacility, length: 4000 )
• CommunityCareHome ( type: esriFieldTypeString, alias: CommunityCareHome, length: 4000 )
• CommunityTransitionFacility ( type: esriFieldTypeString, alias: CommunityTransitionFacility, length: 4000 )
• CommunityGarden ( type: esriFieldTypeString, alias: CommunityGarden, length: 4000 )
• ConstructionFieldOffice ( type: esriFieldTypeString, alias: ConstructionFieldOffice, length: 4000 )
• ContractorSYard ( type: esriFieldTypeString, alias: ContractorSYard, length: 4000 )
• CottageIndustrial ( type: esriFieldTypeString, alias: CottageIndustrial, length: 4000 )
• CountryClub ( type: esriFieldTypeString, alias: CountryClub, length: 4000 )
• CraftConsumables ( type: esriFieldTypeString, alias: CraftConsumables, length: 4000 )
• CrisisSupportFacility ( type: esriFieldTypeString, alias: CrisisSupportFacility, length: 4000 )
• CrisisSupportHome ( type: esriFieldTypeString, alias: CrisisSupportHome, length: 4000 )
• DataCenter ( type: esriFieldTypeString, alias: DataCenter, length: 4000 )
• DayCareCenter ( type: esriFieldTypeString, alias: DayCareCenter, length: 4000 )
• DirtTopslExtrSandGrvlMineStor ( type: esriFieldTypeString, alias: DirtTopslExtrSandGrvlMineStor, length: 4000 )
• DispatchOffice ( type: esriFieldTypeString, alias: DispatchOffice, length: 4000 )
• DisplacementShelter ( type: esriFieldTypeString, alias: DisplacementShelter, length: 4000 )
• DonationCollectionContainer ( type: esriFieldTypeString, alias: DonationCollectionContainer, length: 4000 )
• DroneDelivery ( type: esriFieldTypeString, alias: DroneDelivery, length: 4000 )
• Duplex ( type: esriFieldTypeString, alias: Duplex, length: 4000 )
• ElecVehChrgFac ( type: esriFieldTypeString, alias: ElecVehChrgFac, length: 4000 )
• ElecVehChrgStaAccessory ( type: esriFieldTypeString, alias: ElecVehChrgStaAccessory, length: 4000 )
• FairgroundsOrRodeoGrounds ( type: esriFieldTypeString, alias: FairgroundsOrRodeoGrounds, length: 4000 )
• FarmersMarketPermanent ( type: esriFieldTypeString, alias: FarmersMarketPermanent, length: 4000 )
• FoodAndBeverageProcessing ( type: esriFieldTypeString, alias: FoodAndBeverageProcessing, length: 4000 )
• FoodTruckCourts ( type: esriFieldTypeString, alias: FoodTruckCourts, length: 4000 )
• FoodTruckOperationSites ( type: esriFieldTypeString, alias: FoodTruckOperationSites, length: 4000 )
• FuelSalesPassengerVehicles ( type: esriFieldTypeString, alias: FuelSalesPassengerVehicles, length: 4000 )
• FuelSalesTruck ( type: esriFieldTypeString, alias: FuelSalesTruck, length: 4000 )
• FuneralHomeOrMortuary ( type: esriFieldTypeString, alias: FuneralHomeOrMortuary, length: 4000 )
• GovtFacCityExclAirptUses ( type: esriFieldTypeString, alias: GovtFacCityExclAirptUses, length: 4000 )
• GovtPubFacNonCity ( type: esriFieldTypeString, alias: GovtPubFacNonCity, length: 4000 )
• GreenhouseOrPlantNursery ( type: esriFieldTypeString, alias: GreenhouseOrPlantNursery, length: 4000 )
• GunRangeIndoor ( type: esriFieldTypeString, alias: GunRangeIndoor, length: 4000 )
• GunRangeOutdoor ( type: esriFieldTypeString, alias: GunRangeOutdoor, length: 4000 )
• GymOrFitnessStudio ( type: esriFieldTypeString, alias: GymOrFitnessStudio, length: 4000 )
• HeavyMachRentalSalesStor ( type: esriFieldTypeString, alias: HeavyMachRentalSalesStor, length: 4000 )
• Helistop ( type: esriFieldTypeString, alias: Helistop, length: 4000 )
• HomeOccupation ( type: esriFieldTypeString, alias: HomeOccupation, length: 4000 )
• Hospital ( type: esriFieldTypeString, alias: Hospital, length: 4000 )
• HotelOrMotel ( type: esriFieldTypeString, alias: HotelOrMotel, length: 4000 )
• ImpoundLotOrYard ( type: esriFieldTypeString, alias: ImpoundLotOrYard, length: 4000 )
• IndependentLiving ( type: esriFieldTypeString, alias: IndependentLiving, length: 4000 )
• JunkOrSalvageYard ( type: esriFieldTypeString, alias: JunkOrSalvageYard, length: 4000 )
• LivestockAuction ( type: esriFieldTypeString, alias: LivestockAuction, length: 4000 )
• ManufacturedHome ( type: esriFieldTypeString, alias: ManufacturedHome, length: 4000 )
• ManufacturingHeavy ( type: esriFieldTypeString, alias: ManufacturingHeavy, length: 4000 )
• ManufacturingLight ( type: esriFieldTypeString, alias: ManufacturingLight, length: 4000 )
• MixedUseResidential ( type: esriFieldTypeString, alias: MixedUseResidential, length: 4000 )
• ModelHome ( type: esriFieldTypeString, alias: ModelHome, length: 4000 )
• MotorFreightTerminal ( type: esriFieldTypeString, alias: MotorFreightTerminal, length: 4000 )
• MultiFamilyCottage ( type: esriFieldTypeString, alias: MultiFamilyCottage, length: 4000 )
• MultiFamilyTraditional ( type: esriFieldTypeString, alias: MultiFamilyTraditional, length: 4000 )
• Office ( type: esriFieldTypeString, alias: Office, length: 4000 )
• OfficeShowroomWarehouse ( type: esriFieldTypeString, alias: OfficeShowroomWarehouse, length: 4000 )
• OilNatGasWellDrillOps ( type: esriFieldTypeString, alias: OilNatGasWellDrillOps, length: 4000 )
• OutdoorStorageAccessory ( type: esriFieldTypeString, alias: OutdoorStorageAccessory, length: 4000 )
• ParkGarLotPaidPriv ( type: esriFieldTypeString, alias: ParkGarLotPaidPriv, length: 4000 )
• PawnShop ( type: esriFieldTypeString, alias: PawnShop, length: 4000 )
• PersonalService ( type: esriFieldTypeString, alias: PersonalService, length: 4000 )
• PortableStorageContainer ( type: esriFieldTypeString, alias: PortableStorageContainer, length: 4000 )
• PowerPlantElecGenSta ( type: esriFieldTypeString, alias: PowerPlantElecGenSta, length: 4000 )
• PrivateClub ( type: esriFieldTypeString, alias: PrivateClub, length: 4000 )
• Quadplex ( type: esriFieldTypeString, alias: Quadplex, length: 4000 )
• RadioOrTvBroadcastStation ( type: esriFieldTypeString, alias: RadioOrTvBroadcastStation, length: 4000 )
• RailroadFreightTerminal ( type: esriFieldTypeString, alias: RailroadFreightTerminal, length: 4000 )
• ReceptionOrEventCenterIndoor ( type: esriFieldTypeString, alias: ReceptionOrEventCenterIndoor, length: 4000 )
• ReceptionOrEventCenterOutdoor ( type: esriFieldTypeString, alias: ReceptionOrEventCenterOutdoor, length: 4000 )
• RecreationAreaPrivate ( type: esriFieldTypeString, alias: RecreationAreaPrivate, length: 4000 )
• RecVehRentalSales ( type: esriFieldTypeString, alias: RecVehRentalSales, length: 4000 )
• RecyclingFacility ( type: esriFieldTypeString, alias: RecyclingFacility, length: 4000 )
• RefineStorPetroNatGasButProp ( type: esriFieldTypeString, alias: RefineStorPetroNatGasButProp, length: 4000 )
• ReligiousAssembly ( type: esriFieldTypeString, alias: ReligiousAssembly, length: 4000 )
• ReligPhilanUsesTemp ( type: esriFieldTypeString, alias: ReligPhilanUsesTemp, length: 4000 )
• RestaurantBrewPub ( type: esriFieldTypeString, alias: RestaurantBrewPub, length: 4000 )
• RestCarryOutDelivOnly ( type: esriFieldTypeString, alias: RestCarryOutDelivOnly, length: 4000 )
• RestaurantDineIn ( type: esriFieldTypeString, alias: RestaurantDineIn, length: 4000 )
• RestDriveInDriveThru ( type: esriFieldTypeString, alias: RestDriveInDriveThru, length: 4000 )
• RetailSales ( type: esriFieldTypeString, alias: RetailSales, length: 4000 )
• SanitaryLandfill ( type: esriFieldTypeString, alias: SanitaryLandfill, length: 4000 )
• SchoolBusinessOrTrade ( type: esriFieldTypeString, alias: SchoolBusinessOrTrade, length: 4000 )
• SchoolPublicPrivateOrParochial ( type: esriFieldTypeString, alias: SchoolPublicPrivateOrParochial, length: 4000 )
• SeasonalSales ( type: esriFieldTypeString, alias: SeasonalSales, length: 4000 )
• SelfStorage ( type: esriFieldTypeString, alias: SelfStorage, length: 4000 )
• SexuallyOrientedBusiness ( type: esriFieldTypeString, alias: SexuallyOrientedBusiness, length: 4000 )
• SingleFamilyAttached ( type: esriFieldTypeString, alias: SingleFamilyAttached, length: 4000 )
• SingleFamilyDetached ( type: esriFieldTypeString, alias: SingleFamilyDetached, length: 4000 )
• SmallLotSingleFamilyAttached ( type: esriFieldTypeString, alias: SmallLotSingleFamilyAttached, length: 4000 )
• SmallLotSingleFamilyDetached ( type: esriFieldTypeString, alias: SmallLotSingleFamilyDetached, length: 4000 )
• SolarFarm ( type: esriFieldTypeString, alias: SolarFarm, length: 4000 )
• StableCommercial ( type: esriFieldTypeString, alias: StableCommercial, length: 4000 )
• StockyardOrSlaughterhouse ( type: esriFieldTypeString, alias: StockyardOrSlaughterhouse, length: 4000 )
• StorageAutomobile ( type: esriFieldTypeString, alias: StorageAutomobile, length: 4000 )
• StorBoatTruckRecVeh ( type: esriFieldTypeString, alias: StorBoatTruckRecVeh, length: 4000 )
• SwimmingPool ( type: esriFieldTypeString, alias: SwimmingPool, length: 4000 )
• TelecomStructHighRise ( type: esriFieldTypeString, alias: TelecomStructHighRise, length: 4000 )
• TelecomStructLowRise ( type: esriFieldTypeString, alias: TelecomStructLowRise, length: 4000 )
• TelecomStructStealth ( type: esriFieldTypeString, alias: TelecomStructStealth, length: 4000 )
• TradersVillage ( type: esriFieldTypeString, alias: TradersVillage, length: 4000 )
• TransportationStation ( type: esriFieldTypeString, alias: TransportationStation, length: 4000 )
• Triplex ( type: esriFieldTypeString, alias: Triplex, length: 4000 )
• TruckStop ( type: esriFieldTypeString, alias: TruckStop, length: 4000 )
• UtilitySubstation ( type: esriFieldTypeString, alias: UtilitySubstation, length: 4000 )
• VehicleRepairMajor ( type: esriFieldTypeString, alias: VehicleRepairMajor, length: 4000 )
• VehicleRepairMinor ( type: esriFieldTypeString, alias: VehicleRepairMinor, length: 4000 )
• Warehouse ( type: esriFieldTypeString, alias: Warehouse, length: 4000 )
• WarmingStation ( type: esriFieldTypeString, alias: WarmingStation, length: 4000 )
• WaterWastewtrTrtmtPlant ( type: esriFieldTypeString, alias: WaterWastewtrTrtmtPlant, length: 4000 )
• WindEnergyConversionSystemWecs ( type: esriFieldTypeString, alias: WindEnergyConversionSystemWecs, length: 4000 )
• LotArea ( type: esriFieldTypeString, alias: LotArea, length: 4000 )
• LotWidth ( type: esriFieldTypeString, alias: LotWidth, length: 4000 )
• LotDepth ( type: esriFieldTypeString, alias: LotDepth, length: 4000 )
• FrontSetback ( type: esriFieldTypeString, alias: FrontSetback, length: 4000 )
• RearSetback ( type: esriFieldTypeString, alias: RearSetback, length: 4000 )
• SideInteriorSetback ( type: esriFieldTypeString, alias: SideInteriorSetback, length: 4000 )
• SideAtCornerSetback ( type: esriFieldTypeString, alias: SideAtCornerSetback, length: 4000 )
• BuildingHeight ( type: esriFieldTypeString, alias: BuildingHeight, length: 4000 )
• PUses ( type: esriFieldTypeString, alias: PUses, length: 1073741822 )
• AUses ( type: esriFieldTypeString, alias: AUses, length: 1073741822 )
• CUses ( type: esriFieldTypeString, alias: CUses, length: 1073741822 )
• SUses ( type: esriFieldTypeString, alias: SUses, length: 1073741822 )
• TUses ( type: esriFieldTypeString, alias: TUses, length: 1073741822 )
• MUses ( type: esriFieldTypeString, alias: MUses, length: 1073741822 )
• FilterID ( type: esriFieldTypeString, alias: FilterID, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata