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