Name: Crashes involving peds (2015-2019)

Display Field: rpt_sec_street_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -1092846.19778405
YMin: 9906931.28412394
XMax: 3713962.14297636
YMax: 13289029.1836285
Spatial Reference: PROJCS["NAD83 / Texas Central (ftUS)",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS 1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["false_easting",2296583.333],PARAMETER["false_northing",9842500.0],PARAMETER["central_meridian",-100.3333333333333],PARAMETER["standard_parallel_1",30.11666666666667],PARAMETER["standard_parallel_2",31.88333333333333],PARAMETER["latitude_of_origin",29.66666666666667],UNIT["US survey foot",0.3048006096012192]]

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[78,78,78,255],"size":2,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: fid

Unique ID Field:

Name : fid

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• fid (type: esriFieldTypeOID, alias: fid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• crash_id (type: esriFieldTypeInteger, alias: crash_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crash_time (type: esriFieldTypeString, alias: crash_time, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• crash_date (type: esriFieldTypeDate, alias: crash_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• death_cnt (type: esriFieldTypeInteger, alias: death_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• est_comp_cost (type: esriFieldTypeInteger, alias: est_comp_cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fhe_collsn_id (type: esriFieldTypeString, alias: fhe_collsn_id, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• latitude_primary (type: esriFieldTypeDouble, alias: latitude_primary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude_primary (type: esriFieldTypeDouble, alias: longitude_primary, SQL Type: sqlTypeOther, nullable: true, editable: true)
• non_injry_cnt (type: esriFieldTypeInteger, alias: non_injry_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nonincap_injry_cnt (type: esriFieldTypeInteger, alias: nonincap_injry_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• poss_injry_cnt (type: esriFieldTypeInteger, alias: poss_injry_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crash_pnts (type: esriFieldTypeDouble, alias: crash_pnts, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sus_serious_injry_cnt (type: esriFieldTypeInteger, alias: sus_serious_injry_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unkn_injry_cnt (type: esriFieldTypeInteger, alias: unkn_injry_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• noncr3 (type: esriFieldTypeInteger, alias: noncr3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mode_mv_cnt (type: esriFieldTypeInteger, alias: mode_mv_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mode_mc_cnt (type: esriFieldTypeInteger, alias: mode_mc_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mode_pd_fl (type: esriFieldTypeInteger, alias: mode_pd_fl, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mode_bc_fl (type: esriFieldTypeInteger, alias: mode_bc_fl, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mode_bc_cnt (type: esriFieldTypeInteger, alias: mode_bc_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cr3_mainlane (type: esriFieldTypeInteger, alias: cr3_mainlane, SQL Type: sqlTypeOther, nullable: true, editable: true)
• noncr3_mainlane (type: esriFieldTypeInteger, alias: noncr3_mainlane, SQL Type: sqlTypeOther, nullable: true, editable: true)
• i35_related (type: esriFieldTypeInteger, alias: i35_related, SQL Type: sqlTypeOther, nullable: true, editable: true)
• active_school_zone_fl (type: esriFieldTypeString, alias: active_school_zone_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• approval_date (type: esriFieldTypeString, alias: approval_date, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• approved_by (type: esriFieldTypeString, alias: approved_by, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• at_intrsct_fl (type: esriFieldTypeString, alias: at_intrsct_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• case_id (type: esriFieldTypeString, alias: case_id, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• city_id (type: esriFieldTypeInteger, alias: city_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• crash_fatal_fl (type: esriFieldTypeString, alias: crash_fatal_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• crash_sev_id (type: esriFieldTypeString, alias: crash_sev_id, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• crash_speed_limit (type: esriFieldTypeInteger, alias: crash_speed_limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• day_of_week (type: esriFieldTypeString, alias: day_of_week, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• geocode_date (type: esriFieldTypeString, alias: geocode_date, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• geocode_provider (type: esriFieldTypeInteger, alias: geocode_provider, SQL Type: sqlTypeOther, nullable: true, editable: true)
• geocode_status (type: esriFieldTypeString, alias: geocode_status, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• geocoded (type: esriFieldTypeString, alias: geocoded, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• hwy_nbr (type: esriFieldTypeInteger, alias: hwy_nbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hwy_sfx (type: esriFieldTypeString, alias: hwy_sfx, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• hwy_sys (type: esriFieldTypeString, alias: hwy_sys, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• hwy_sys_2 (type: esriFieldTypeString, alias: hwy_sys_2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• intrsct_relat_id (type: esriFieldTypeString, alias: intrsct_relat_id, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• investigator_narrative (type: esriFieldTypeString, alias: investigator_narrative, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• is_retired (type: esriFieldTypeString, alias: is_retired, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• last_update (type: esriFieldTypeString, alias: last_update, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latitude_geocoded (type: esriFieldTypeDouble, alias: latitude_geocoded, SQL Type: sqlTypeOther, nullable: true, editable: true)
• light_cond_id (type: esriFieldTypeString, alias: light_cond_id, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude_geocoded (type: esriFieldTypeDouble, alias: longitude_geocoded, SQL Type: sqlTypeOther, nullable: true, editable: true)
• obj_struck_id (type: esriFieldTypeString, alias: obj_struck_id, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• onsys_fl (type: esriFieldTypeString, alias: onsys_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• private_dr_fl (type: esriFieldTypeString, alias: private_dr_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• qa_status (type: esriFieldTypeInteger, alias: qa_status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• road_constr_zone_fl (type: esriFieldTypeString, alias: road_constr_zone_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• road_type_id (type: esriFieldTypeInteger, alias: road_type_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rpt_block_num (type: esriFieldTypeString, alias: rpt_block_num, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• rpt_city_id (type: esriFieldTypeInteger, alias: rpt_city_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rpt_hwy_num (type: esriFieldTypeString, alias: rpt_hwy_num, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• rpt_latitude (type: esriFieldTypeDouble, alias: rpt_latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rpt_longitude (type: esriFieldTypeDouble, alias: rpt_longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rpt_outside_city_limit_fl (type: esriFieldTypeString, alias: rpt_outside_city_limit_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• rpt_rdwy_sys_id (type: esriFieldTypeString, alias: rpt_rdwy_sys_id, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• rpt_road_part_id (type: esriFieldTypeString, alias: rpt_road_part_id, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• rpt_sec_block_num (type: esriFieldTypeString, alias: rpt_sec_block_num, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• rpt_sec_hwy_num (type: esriFieldTypeString, alias: rpt_sec_hwy_num, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• rpt_sec_hwy_sfx (type: esriFieldTypeString, alias: rpt_sec_hwy_sfx, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• rpt_sec_rdwy_sys_id (type: esriFieldTypeString, alias: rpt_sec_rdwy_sys_id, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• rpt_sec_road_part_id (type: esriFieldTypeString, alias: rpt_sec_road_part_id, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• rpt_sec_street_desc (type: esriFieldTypeString, alias: rpt_sec_street_desc, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• rpt_sec_street_name (type: esriFieldTypeString, alias: rpt_sec_street_name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• rpt_sec_street_pfx (type: esriFieldTypeString, alias: rpt_sec_street_pfx, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• rpt_sec_street_sfx (type: esriFieldTypeString, alias: rpt_sec_street_sfx, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• rpt_street_name (type: esriFieldTypeString, alias: rpt_street_name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• rpt_street_pfx (type: esriFieldTypeString, alias: rpt_street_pfx, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• rpt_street_sfx (type: esriFieldTypeString, alias: rpt_street_sfx, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• rpt_street_desc (type: esriFieldTypeString, alias: rpt_street_desc, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• rr_relat_fl (type: esriFieldTypeString, alias: rr_relat_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• schl_bus_fl (type: esriFieldTypeString, alias: schl_bus_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• street_name (type: esriFieldTypeString, alias: street_name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• street_name_2 (type: esriFieldTypeString, alias: street_name_2, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• street_nbr (type: esriFieldTypeInteger, alias: street_nbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• street_nbr_2 (type: esriFieldTypeInteger, alias: street_nbr_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• toll_road_fl (type: esriFieldTypeString, alias: toll_road_fl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• tot_injry_cnt (type: esriFieldTypeInteger, alias: tot_injry_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• traffic_cntl_id (type: esriFieldTypeString, alias: traffic_cntl_id, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• updated_by (type: esriFieldTypeString, alias: updated_by, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• wthr_cond_id (type: esriFieldTypeString, alias: wthr_cond_id, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• veh_body_styl_desc (type: esriFieldTypeString, alias: veh_body_styl_desc, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• veh_unit_desc_desc (type: esriFieldTypeString, alias: veh_unit_desc_desc, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• mode_pd_cnt (type: esriFieldTypeInteger, alias: mode_pd_cnt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• apd_confirmed_death_count (type: esriFieldTypeInteger, alias: apd_confirmed_death_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• is_south_lamar_related (type: esriFieldTypeInteger, alias: is_south_lamar_related, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Crashes involving peds (2015-2019)
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/30/2020 5:57:12 PM

Schema Last Edit Date: 3/30/2020 5:57:12 PM

Data Last Edit Date: 3/30/2020 5:57:12 PM

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