All Layers and Tables (AV_Cleaned_Sheet_Geocoded_May23_2023

Layers:

Layer: Currrent_Cleaned_Sheet_Geocoded_May23_2023_v2 (6)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[31,70,135,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:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

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)
Long_Geocoded (type: esriFieldTypeDouble, alias: Longitude_Geocoded, SQL Type: sqlTypeOther, nullable: true, editable: true)
Lat_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_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: esriFieldTypeDate, alias: Incident Time Reported, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
USER_Time_AV_Company_was_Called (type: esriFieldTypeDate, alias: Time AV Company was Called, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
USER_Time_AV_Company_Called_Bac (type: esriFieldTypeDate, alias: Time AV Company Called Back/Responded, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
USER_Time_SFPD_Dispatched (type: esriFieldTypeDate, alias: Time SFPD Dispatched, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
USER_Time_SFPD_On_Scene (type: esriFieldTypeDate, alias: Time SFPD On Scene, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
USER_Time_Cleared_by_SFPD (type: esriFieldTypeDate, alias: Time Cleared by SFPD, SQL Type: sqlTypeOther, length: 8, 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: esriFieldTypeDouble, alias: Apparent Incident Duration (in minutes), SQL Type: sqlTypeOther, 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)
Field (type: esriFieldTypeInteger, alias: Field, SQL Type: sqlTypeOther, nullable: true, editable: true)
Field1 (type: esriFieldTypeInteger, alias: Field1, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (AV_Cleaned_Sheet_Geocoded_May23_2023_v2)

Layers:

Layer: Currrent_Cleaned_Sheet_Geocoded_May23_2023_v2 (6)