Storm Water Structures

Storm Water Structure is a Point FeatureClass representing the various storm water structures in the City of Cupertino. It is primarily used as an inventory layer in Cityworks and as a reference layer. The layer is updated as needed by the Public Works Department and the GIS Division. Storm Water Structure has the following fields: OBJECTID: Unique identifier automatically generated by Esri type: OID, length: 4, domain: none Enabled: type: SmallInteger, length: 2, domain: EnabledDomain domain values:['False', 'True'] AncillaryRole: type: SmallInteger, length: 2, domain: AncillaryRoleDomain domain values:['None', 'Source', 'Sink'] AssetID: Cupertino maintained GIS primary key type: String, length: 20, domain: none LegacyID: Old identifiers used to track asset migration type: String, length: 20, domain: none Location: Further description of the location type: String, length: 50, domain: none Status: The active or construction status of the asset in the field type: String, length: 20, domain: pwStatus domain values:['Abandoned', 'Proposed', 'Auction', 'Denied', 'Active', 'Removed', 'Not Connected'] OwnedBy: Organization which owns the asset type: String, length: 50, domain: shdOwnedBy domain values:['Cupertino', 'San Jose Water', 'CalTrans', 'PGE', 'Los Altos', 'Santa Clara', 'Private HOA', 'Saratoga', 'Other Public', 'Santa Clara County', 'San Jose', 'Santa Clara Valley Water District', 'Private', 'California Water Service', 'State Parks', 'Sunnyvale', 'Cupertino Sanitary District', 'CWA'] MaintainedBy: Organization who is responsible for maintenance of asset type: String, length: 50, domain: shdOwnedBy domain values:['Cupertino', 'San Jose Water', 'CalTrans', 'PGE', 'Los Altos', 'Santa Clara', 'Private HOA', 'Saratoga', 'Other Public', 'Santa Clara County', 'San Jose', 'Santa Clara Valley Water District', 'Private', 'California Water Service', 'State Parks', 'Sunnyvale', 'Cupertino Sanitary District', 'CWA'] PlanNumber: Origniating plan number if known type: String, length: 50, domain: none PlanName: The name of the plan associated with the storm water structure type: String, length: 50, domain: none AsbuiltDate: Asbuilt date type: Date, length: 8, domain: none PrimaryImage: Hyperlink to photo or DMS type: String, length: 100, domain: none CreateDate: The date the database row was initially created type: Date, length: 8, domain: none UpdateDate: The date the database row was last updated type: Date, length: 8, domain: none DataSource: Description of what methods were used for data capture/migration type: String, length: 100, domain: shdDataSource domain values:['Digitized Plan as Reference', 'GPS SubFoot', 'Unknown Source', 'iStreetView', 'Field Verified', 'GPS SubMeter', 'Digitized Landbase as Reference', 'Legacy WO System', 'Digitized Ortho as Reference', 'Approximated Historical Source', 'Need Verification', 'Cogo from Plans'] SubWatershed: Field indicating what sub water shed is associated with the storm water structure type: String, length: 10, domain: swSubWaterShed InstallDate: The date the storm water structure was installed type: Date, length: 8, domain: none StructureType: Field indicating the type of storm water structure type: String, length: 20, domain: swStructureType domain values:['Thru Curb Drain', 'Area Drain', 'Catch Basin', 'BubbleUp', 'Pump Station', 'Outfall', 'Drop Inlet', 'Treatment Device', 'Unknown', 'Manhole', 'Clean Out', 'Dry Well', 'Inlet Culvert', 'Energy Dissipator'] IsCityStandard: type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] Depth: type: Double, length: 8, domain: none RimElev: type: Double, length: 8, domain: none AccessDiameter: Field indicating the diameter of the strucutre access type: SmallInteger, length: 2, domain: swAccessDiameter domain values:['24 inch', '48 inch', '36 inch'] CoverType: Filed indicating the cover type of the associated storm water structure type: String, length: 15, domain: swCoverType domain values:['Grate', 'Standard Lid', 'Bolt Down', 'Open Pipe'] HasHeadWall: Field indicating whether or not the pipe has a head wall type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasFlapGate: Field indicating whether or not the pipe has a flap gate type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasLadder: Field indicating whether or not the pipe has a ladder type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasStencil: Field indicating whether or not the pipe has a stencil type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasButton: Field indicating whether or not the pipe has a button type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] HasPrivateBMP: Field indicating whether or not the pipe has a private BMP type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] ErrosionControl: type: String, length: 10, domain: swErosionControl domain values:['Boulder', 'Sacrete', 'Gabion', 'RipRap', 'Concrete', 'T'] IsCheckPoint: type: String, length: 4, domain: shdBooleanYesNo domain values:['Yes', 'No'] IsInlineCheckValve: type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] Rotation: Field used for assigning rotation degree in Maplex Labeling Engine type: Double, length: 8, domain: none CheckValveInstallDate: The date the check valve was installed type: Date, length: 8, domain: none CheckValvePlanNumber: The plan number associated with the check valve type: String, length: 50, domain: none HasHeavyGrate: Field indicating whether or not the pipe has a heavy grate type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] ManualClean: type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] IsFloodProne: type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] BuinessLotFeed: EnterTextDescription type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] hasSmartCover: Field indicating whether or not the pipe has a smart cover type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] hasInspection: Field indicating whether or not the pipe has an inspection type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] Shape: Field that stores geographic coordinates associated with feature type: Geometry, length: 4, domain: none GlobalID: Unique identifier automatically generated for features in enterprise database type: GlobalID, length: 38, domain: none EOA: type: String, length: 50, domain: none DeviceModelType: The model type of the storm water structure device type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] HasTrashCaptureInsert: Field indicating whether or not the pipe has a trash capture insert type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] TrashCaptureInsertManufacturer: The manufacturer of the trash capture insert type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] TrashCaptureInsertDeviceModelTy: The model type of the trash capture device type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] TrashCaptureInsertInstallDate: The date the trash capture insert was installed type: Date, length: 8, domain: none HasCurbScreen: Field indicating whether or not the pipe has a curb screen type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] CurbScreenManufacturer: The manufacturer of the curb screen type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] CurbScreenDeviceModelType: The model type of the curb screen type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] CurbScreenInstallDate: The date the curb screen was installed type: Date, length: 8, domain: none HasDebrisRack: Field indicating whether or not the pipe has a debris rack type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] DebrisRackManufacturer: The manufacturer of the debris rack type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] DebrisRackDeviceModelType: The model type of the debris rack type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] DebrisRackInstallDate: The date the debris rack was installed type: Date, length: 8, domain: none HasDrainInsert: Field indicating whether or not the pipe has a drain insert type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] DrainInsertManufacturer: The manufacturer of the drain insert type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] DrainInsertDeviceModelType: The model type of the drain insert type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] DrainInsertInstallDate: The date the drain insert was installed type: Date, length: 8, domain: none HasFilterFabric: Field indicating whether or not the pipe has a filter fabric type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] FilterFabricManufacturer: The manufacturer of the filter fabric type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] FilterFabricDeviceModelType: The model type of the filter fabric device type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] FilterFabricInstallDate: The date the filter fabric was installed type: Date, length: 8, domain: none HasFiltersCatchPan: Field indicating whether or not the pipe has a filter catch pan type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] FiltersCatchPanManufacturer: The manufacturer of the filters catch pan type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] FiltersCatchPanDeviceModelType: The model type of the filters catch pan device type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] FiltersCatchPanInstallDate: The date the catch pan was installed type: Date, length: 8, domain: none HasHydrodynamicSeparators: Field indicating whether or not the pipe has hydrodynamic separators type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] HydrodynamicSeparatorsManufactu: The manufacturer of the hydrodynamic separator type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] HydrodynamicSeparatorsDeviceMod: The model type of the hydrodynamic separator type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] HydrodynamicSeparatorsInstallDa: The date the hydrodynamic separator was installed type: Date, length: 8, domain: none HasInterceptorSeperator: Field indicating whether or not the pipe has an interceptor separator type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] InterceptorSeperatorManufacture: The manufacturer of the interceptor separator type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] InterceptorSeperatorDeviceModel: The model type of the intercept separator type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] InterceptorSeperatorInstallDate: The date the intercept separator was installed type: Date, length: 8, domain: none HasMediaFilter: Field indicating whether or not the pipe has a media filter type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] MediaFilterManufacturer: The manufacturer of the media filter type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] MediaFilterDeviceModelType: The model type of the media filter device type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] MediaFilterInstallDate: The date the media filter was installed type: Date, length: 8, domain: none HasRetentionIrrigation: Field indicating whether or not the pipe has a retention irrigation type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] RetentionIrrigationManufacturer: The manufacturer of the retention irrigation type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] RetentionIrrigationDeviceModelT: The model type of the retention irrigation device type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] RetentionIrrigationInstallDate: The date the retention irrigation was installed type: Date, length: 8, domain: none HasRiser: Field indicating whether or not the pipe has a riser type: String, length: 3, domain: shdBooleanYesNo domain values:['Yes', 'No'] RiserManufacturer: The manufacturer of the riser type: String, length: 255, domain: swStructureManufacturer domain values:['Hydra', 'United', 'Stormtek', 'REM'] RiserDeviceModelType: The model type of the riser device type: String, length: 50, domain: swDeviceModelType domain values:['Pipe Screen', 'Manual Retractable', 'Wing Gate'] RiserInstallDate: The date the riser was installed type: Date, length: 8, domain: none Shape.STLength(): The length of the shape - in feet type: Double, length: 0, domain: none last_edited_date: The date the database row was last updated type: Date, length: 8, domain: none created_date: The date the database row was initially created type: Date, length: 8, domain: none