Name: GSI_VSF_Keizer_2023
Display Field: Grid
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: GSI Vegetated Stormwater Facility locations in Keizer. December 2023.Field NameAliasData TypeField DescriptionsDomain NameCoded ValuesValue DefinitionsGridGridTextReference grid number used to locate assets; value used in Legacy IDs; Keizer grid is an extension of City of Salem reference grid.Asset_CodeAsset CodeTextA three letter abbreviation used to categorize the asset by its primary functionAsset_CodeAsset_NumberAsset NumberLongThe unique identification number for the asset Asset_IDAsset IDTextUnique numerical identification number assigned by Keizer to identify a specific asset; concatination of Asset_Code and Asset_NumberLegacy_IDLegacy IDTextThe historical ID number assigned to the asset; ID no longer in use; consists of a grid number followed by a unique identifier. Grid number + Asset IDReport_CodeReport CodetextSystem of letters assigned by the City of Keizer to indicate the owner and operator responsible for the assetReport_CodeKO_KM, KO_PM, PO_KM, PO_PM, GO_GMKO = Keizer Owned; KM = Keizer Maintained; PO = Privately Owned; PM = Privately Maintained; GO = Government Owned; GM = Government Maintained Report_StampReport StampTextSignifies that an alternate Report Code has been assigned to the asset; must be approved by a manager. First initial and last name of person who authorized the change. (ex: BLawyer)Asset_StatusAsset StatusTextDescribes the operational state of an asset (may include: Active, (In-Active) Abandoned, (In-Active) Buried, (In-Active) Removed, or Unknown)asset_statusActive, Abandoned, Buried, Removed, UnknownLocationLocationtextLocation of the asset (e.g., address, georeference, or street name)VSF_TypeVSF TypeTextReferes to the functional design of the facilityvsf_typeSwale, Planter, Basin, Other, UnknownVSF_SubtypeVSF SubtypeTextDescribes the operational purpose of the facilityvsf_subtypeGrass, Infiltration, Filtration, Conveyance, Combination, Unknown, Retetion, Detention, Wetland, Rain Garden, Infiltration = primary role is infiltration; Filtration = primary role is pass through treatment; Conveyance = primary role is conveying water (e.g., ditch); Combination = dual purpose design for treatment and infiltration; Unknown = primary function is unknown. Detention= basin that hold but doe not retain water, Retention= Basin that holds water, wetland- basin that mimics a wetland, Rain Garden= basin that collects rain water from a roof, driveway or street and allows it to soak into the ground.OverflowOverflowTextIndicates whether or not the facility contains an overflow device; if yes, the type of overflow structure installedOverflowBeehive, Catch Basin, Other, None, UnknownSystem_ConnectionSystem ConnectionTextIndicates that the facility (overflow) discharges to a public system and if yes, the type of storm drainage system.VSF_ConnectionMS4, UIC, SMF, None, UnknownMS4 = Municipal Storm Drainage System; UIC = Underground Injection Control; SMF = Stormwater Management Facility; or None = No Connection; or UnknownCurbCut_PresenceCurbCut PresenceDoubleIndicates whether or not the facility contains curb cut inlets; if yes, the number of inlets presentMS4_Drainage_IDMS4 Drainage IDTextThe ID number of the MS4 catchment or drainage the asset is associated withMS4_Outfall_IDMS4 Outfall IDTextThe ID number of the outfall that the asset discharges to UIC_Drainage_IDUIC Drainage IDTextUIC Id that point serving as deepest pooint forYear_InstalledYear InstalledlongYear the asset was installedInspect_FreqInspection FrequencyTextIndicates how often the asset is scheduled for inspectionFrequencyAnnual, Seasonal, Monthly, Weekly, Daily, None, UnknownInspect_LastLast Inspection DatedateDate of last inspectionMX_LastDate Last MaintaineddateDate of last maintanaceMX_TypeType of Last MaintenancetextType of maintenance last performed on the asset; + add a description to Note2_Maintenance comment field MXClean, Repair, Replace Abandon, Other (see MX comment), UnknownNote1_OperationNote1_OperationtextProvided for City staff to make comments pertaining to ownership and/or operation for historical record-keeping purposes (e.g., date of decommission)Note2_MaintenanceNote2_MaintenancetextProvided for City staff to make comments pertaining to installation and/or maintenance for historical record-keeping purposes (e.g., limited/no access)Note3_GISAdminNote3_GISAdmintextProvided for City staff to make comments pertaining to GIS administration for historical record-keeping purposes Note4_OtherNote4_OthertextProvided for City staff to make general comments (short or long term) CreatorCreatorTextwho created (automatically populated when editor tracking turned on)Created_DateCreated_Datedatewhen created (automatically populated when editor tracking turned on)EditorEditorTextwho edited last (automatically populated when editor tracking turned on)Edited_DateEdited_DateDatewhen it was last edited (automatically populated when editor tracking turned on)Lat_YLat_YDoubleCalculated are pulled from GNSS metadataLong_XLong_XDoubleCalculated are pulled from GNSS metadataSHAPE_LengthSHAPE_LengthdoubleGIS created fieldSHAPE_AreaSHAPE_AreadoubleGIS created fieldOBJECTIDOBJECTIDObject IDGIS created fieldShapeShapeGeometryGIS created fieldGNSS_Data WHEN APPROPRIATECREATED THRU ADD GPS METADATA GEOPROCESSING TOOL
Copyright Text: City of Keizer
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 7541177.87237532
YMin: 486504.881233603
XMax: 7557869.96981627
YMax: 509493.013779521
Spatial Reference: 2913 (2913)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,184,244,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Grid (type: esriFieldTypeString, alias: Grid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Asset_ID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Legacy_ID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Report_Code (type: esriFieldTypeString, alias: Report Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [PO_PM: PO_PM], [KO_KM: KO_KM], [PO_KM: PO_KM], ... 2 more ...)
- Asset_Status (type: esriFieldTypeString, alias: Asset Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Active: Active], [Removed: Removed], [Abandoned: Abandoned], ... 2 more ...)
- Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- VSF_Type (type: esriFieldTypeString, alias: VSF Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Swale: Swale], [Planter: Planter], [Other: Other], ... 1 more ...)
- VSF_Subtype (type: esriFieldTypeString, alias: VSF Subtype, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Infiltration: Infiltration], [Grass: Grass], [Conveyance: Conveyance], ... 6 more ...)
- Overflow (type: esriFieldTypeString, alias: Overflow Present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [No: No], [Type 1: Type 1], ... 4 more ...)
- System_Connection (type: esriFieldTypeString, alias: System Connection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [MS4: MS4], [UIC: UIC], [None: None], ... 1 more ...)
- CurbCut_Presence (type: esriFieldTypeDouble, alias: CurbCut Presence, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MS4_Drainage_ID (type: esriFieldTypeString, alias: MS4 Drainage ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- UIC_Drainage_ID (type: esriFieldTypeString, alias: UIC Drainage ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Year_Installed (type: esriFieldTypeInteger, alias: Year Installed, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Inspect_Freq (type: esriFieldTypeString, alias: Inspection Frequency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Note4_Other (type: esriFieldTypeString, alias: Note4_Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Asset_Code (type: esriFieldTypeString, alias: Asset Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Asset_Number (type: esriFieldTypeInteger, alias: Asset Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Report_Stamp (type: esriFieldTypeString, alias: Report Stamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MS4_Outfall_ID (type: esriFieldTypeString, alias: MS4 Outfall ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Inspect_Last (type: esriFieldTypeDate, alias: Last Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MX_Last (type: esriFieldTypeDate, alias: Date Last Maintained, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MX_Type (type: esriFieldTypeString, alias: Type of Last Maintenance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Note1_Operation (type: esriFieldTypeString, alias: Note1_Operation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Note2_Maintenance (type: esriFieldTypeString, alias: Note2_Maintenance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Note3_GISAdmin (type: esriFieldTypeString, alias: Note3_GISAdmin, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Area (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: GSI_VSF_Keizer_2023
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- Report_Code: KO_KM
- Asset_Status: Active
- CurbCut_Presence: 0
- MS4_Drainage_ID: None
- UIC_Drainage_ID: None
- Asset_Code: SW-VSF
- Report_Stamp: None
- MS4_Outfall_ID: None
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/3/2025 5:04:06 PM
Schema Last Edit Date: 3/3/2025 5:04:06 PM
Data Last Edit Date: 3/3/2025 5:04:03 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat