Name: Currrent_Cleaned_Sheet_Geocoded_May23_2023_v3

Display Field: StName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: 140036.126122385
YMin: 66708.0702130198
XMax: 182552.738483265
YMax: 105254.609580651
Spatial Reference: 7132 (7132)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[64,42,132,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: AddNum, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: AddNumFrom, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: AddNumTo, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• StPreDir (type: esriFieldTypeString, alias: StPreDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• StateAbbr (type: esriFieldTypeString, alias: StateAbbr, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: LangCode, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Logitude_geocoded (type: esriFieldTypeDouble, alias: Logitude_geocoded, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude_geocoded (type: esriFieldTypeDouble, alias: Latitude_geocoded, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayX (type: esriFieldTypeDouble, alias: DisplayX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayY (type: esriFieldTypeDouble, alias: DisplayY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comp_score (type: esriFieldTypeString, alias: Comp_score, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Street (type: esriFieldTypeString, alias: Street or Intersection, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City or Placename, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• IN_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_ZIP (type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• USER_ObjectID__ (type: esriFieldTypeDouble, alias: ObjectID *, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Shape__ (type: esriFieldTypeString, alias: Shape *, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_AddNum (type: esriFieldTypeDouble, alias: AddNum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_AddNumFrom (type: esriFieldTypeDouble, alias: AddNumFrom, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_AddNumTo (type: esriFieldTypeDouble, alias: AddNumTo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_StPreDir (type: esriFieldTypeString, alias: StPreDir, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_StPreType (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_StName (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_StType (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_StDir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_StateAbbr (type: esriFieldTypeString, alias: StateAbbr, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_ZIP (type: esriFieldTypeDouble, alias: ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_LangCode (type: esriFieldTypeString, alias: LangCode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_DisplayX (type: esriFieldTypeDouble, alias: DisplayX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_DisplayY (type: esriFieldTypeDouble, alias: DisplayY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Comp_score (type: esriFieldTypeString, alias: Comp_score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Street_or_Intersection (type: esriFieldTypeString, alias: Street or Intersection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_City_or_Placename (type: esriFieldTypeString, alias: City or Placename, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_State1 (type: esriFieldTypeString, alias: State1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_ZIP_Code (type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Unique_ID (type: esriFieldTypeDouble, alias: Unique ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Include_In_Public_Reports_ (type: esriFieldTypeString, alias: Include In Public Reports?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Report_Included_In (type: esriFieldTypeString, alias: Report Included In, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Incident_Type (type: esriFieldTypeString, alias: Incident Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Emergency_Responder_Impact (type: esriFieldTypeString, alias: Emergency Responder Impact?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Transit_Impact_ (type: esriFieldTypeString, alias: Transit Impact?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Construction_Impact_ (type: esriFieldTypeString, alias: Construction Impact?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Incident_Date (type: esriFieldTypeDate, alias: Incident Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USER_Incident_Time_Reported (type: esriFieldTypeString, alias: Incident Time Reported, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_AV_Company_was_Called (type: esriFieldTypeString, alias: Time AV Company was Called, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_AV_Company_Called_Bac (type: esriFieldTypeString, alias: Time AV Company Called Back/Responded, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_SFPD_Dispatched (type: esriFieldTypeString, alias: Time SFPD Dispatched, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_SFPD_On_Scene (type: esriFieldTypeString, alias: Time SFPD On Scene, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_Cleared_by_SFPD (type: esriFieldTypeString, alias: Time Cleared by SFPD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_Cleared_of_AV (type: esriFieldTypeString, alias: Time Cleared of AV, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Apparent_Incident_Duration (type: esriFieldTypeString, alias: Apparent Incident Duration (in minutes), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Reported_Location (type: esriFieldTypeString, alias: Reported Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Location_for_Geocoding (type: esriFieldTypeString, alias: Location for Geocoding, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_City_for_Geocoding (type: esriFieldTypeString, alias: City for Geocoding, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_State_for_Geocoding (type: esriFieldTypeString, alias: State for Geocoding, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Longtitude (type: esriFieldTypeString, alias: Longtitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Summary (type: esriFieldTypeString, alias: Summary, SQL Type: sqlTypeOther, length: 32767, nullable: true, editable: true)
• USER_AV_Company_contacted_ (type: esriFieldTypeString, alias: AV Company contacted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Did_AV_Company_Call_Back_ (type: esriFieldTypeString, alias: Did AV Company Call Back?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_ETA_Provided_by_AV_Company (type: esriFieldTypeString, alias: ETA Provided by AV Company in Minutes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_AV_Company_Response_Notes (type: esriFieldTypeString, alias: AV Company Response Notes, SQL Type: sqlTypeOther, length: 32767, nullable: true, editable: true)
• USER_AV_Company_Involved (type: esriFieldTypeString, alias: AV Company Involved, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Number_of_AVs_Involved (type: esriFieldTypeDouble, alias: Number of AVs Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Driverless_ (type: esriFieldTypeString, alias: Driverless?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Other_Parties_Involved (type: esriFieldTypeString, alias: Other Parties Involved, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Police_CAD_TMC_Report (type: esriFieldTypeDouble, alias: Police CAD/TMC Report, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_License_Plate (type: esriFieldTypeString, alias: License Plate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Signal_Errors (type: esriFieldTypeString, alias: Signal Errors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Occured_on_Transit_Route (type: esriFieldTypeString, alias: Occured on Transit Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Impacted_Transit (type: esriFieldTypeString, alias: Impacted Transit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Muni_Routes_Impacted (type: esriFieldTypeString, alias: Muni Routes Impacted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Occurred_on_Bike_Route (type: esriFieldTypeString, alias: Occurred on Bike Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Occurred_on_HIN (type: esriFieldTypeString, alias: Occurred on HIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Additional_Notes (type: esriFieldTypeString, alias: Additional Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Media_Description (type: esriFieldTypeString, alias: Media Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Media_Link (type: esriFieldTypeString, alias: Media Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Media_Link__2 (type: esriFieldTypeString, alias: Media Link #2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Other_Links (type: esriFieldTypeString, alias: Other Links, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Cover_Photo_for_Reporting (type: esriFieldTypeString, alias: Cover Photo for Reporting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_SFMTA_Reviewed_Status (type: esriFieldTypeString, alias: SFMTA Reviewed Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_SFMTA_Reviewer (type: esriFieldTypeString, alias: SFMTA Reviewer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_SFMTA_Reviewer_2 (type: esriFieldTypeString, alias: SFMTA Reviewer 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Separate_out_CAD_and_CC_Lo (type: esriFieldTypeString, alias: Separate out CAD and CC Log, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_additional_cad_reports_or_ (type: esriFieldTypeString, alias: additional cad reports or cc reports, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_CAT_Claims_Number (type: esriFieldTypeString, alias: CAT Claims Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_F311_Verint_Case_Number (type: esriFieldTypeString, alias: 311 Verint Case Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_SFMTA_Salesforce_Case_Numb (type: esriFieldTypeString, alias: SFMTA Salesforce Case Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Other_Vehicle_Identifier (type: esriFieldTypeString, alias: Other Vehicle Identifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Transit_Video_Pulls (type: esriFieldTypeString, alias: Transit Video Pulls, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_TMC_Dispatched (type: esriFieldTypeString, alias: Time TMC Dispatched, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_TMC_On_Scene (type: esriFieldTypeString, alias: Time TMC On Scene, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_Cleared_by_TMC (type: esriFieldTypeString, alias: Time Cleared by TMC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Calculated_Duration (type: esriFieldTypeString, alias: Calculated Duration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_Transit_Blocked (type: esriFieldTypeString, alias: Time Transit Blocked, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Transit_Line_Blocked (type: esriFieldTypeString, alias: Transit Line Blocked, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Transit_Vehicle_Number (type: esriFieldTypeString, alias: Transit Vehicle Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Time_Transit_Resume_Normal (type: esriFieldTypeString, alias: Time Transit Resume Normal Service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Calculated_Max_Duration__L (type: esriFieldTypeString, alias: Calculated Max Duration (Latest - Earliest), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Public_Display_on_Dashboar (type: esriFieldTypeString, alias: Public Display on Dashboard, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Transit_Costs (type: esriFieldTypeString, alias: Transit Costs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_PCO_Hours (type: esriFieldTypeString, alias: PCO Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_PCO_Costs (type: esriFieldTypeString, alias: PCO Costs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Incident_Category_or_Prior (type: esriFieldTypeString, alias: Incident Category or Priority, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Collision (type: esriFieldTypeString, alias: Collision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Traffic_Obstruction (type: esriFieldTypeString, alias: Traffic Obstruction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Injuries (type: esriFieldTypeString, alias: Injuries, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_CVC_Driving_Infractions (type: esriFieldTypeString, alias: CVC Driving Infractions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_CVC_Parking_Infractions (type: esriFieldTypeString, alias: CVC Parking Infractions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_SF_TC_Parking_Infractions (type: esriFieldTypeString, alias: SF TC Parking Infractions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Citation_Issued (type: esriFieldTypeString, alias: Citation Issued, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Field (type: esriFieldTypeString, alias: Field, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Field1 (type: esriFieldTypeString, alias: Field1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Currrent_Cleaned_Sheet_Geocoded_May23_2023_v3
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/25/2023 8:45:54 PM

Schema Last Edit Date: 5/25/2023 8:45:54 PM

Data Last Edit Date: 5/25/2023 8:42:13 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat