Name: K12SchoolShootings_Geocoded

Display Field: Loc_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: K12SchoolShootings_Geocoded

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: -161.76087
YMin: 17.7035400000001
XMax: -64.8663799999999
YMax: 61.2319600000001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[111,196,134,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.75}}},"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)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• 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: 500, nullable: true, editable: true)
• LongLabel (type: esriFieldTypeString, alias: LongLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ShortLabel (type: esriFieldTypeString, alias: ShortLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PlaceName (type: esriFieldTypeString, alias: PlaceName, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Place_addr (type: esriFieldTypeString, alias: Place_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Rank (type: esriFieldTypeDouble, alias: Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddBldg (type: esriFieldTypeString, alias: BuildingName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: AddressNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: AddNumFrom, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: AddNumTo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddRange (type: esriFieldTypeString, alias: AddressRange, SQL Type: sqlTypeOther, length: 100, 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: 5, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgType (type: esriFieldTypeString, alias: BldgType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: BldgName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LevelType (type: esriFieldTypeString, alias: LevelType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LevelName (type: esriFieldTypeString, alias: LevelName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitType (type: esriFieldTypeString, alias: UnitType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: UnitName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SubAddr (type: esriFieldTypeString, alias: SubAddress, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Nbrhd (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• MetroArea (type: esriFieldTypeString, alias: MetroArea, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• RegionAbbr (type: esriFieldTypeString, alias: RegionAbbr, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Territory (type: esriFieldTypeString, alias: Territory, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Postal (type: esriFieldTypeString, alias: Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PostalExt (type: esriFieldTypeString, alias: PostalExt, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: LangCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, 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)
• Xmin (type: esriFieldTypeDouble, alias: Xmin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmax (type: esriFieldTypeDouble, alias: Xmax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymin (type: esriFieldTypeDouble, alias: Ymin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymax (type: esriFieldTypeDouble, alias: Ymax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExInfo (type: esriFieldTypeString, alias: ExtraInfo, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ResultID (type: esriFieldTypeInteger, alias: ResultID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IN_Address (type: esriFieldTypeString, alias: Address or Place, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address3 (type: esriFieldTypeString, alias: Address3, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Region (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Postal (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_PostalExt (type: esriFieldTypeString, alias: ZIP4, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_CountryCode (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• USER_Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• USER_School (type: esriFieldTypeString, alias: School, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Reliability_Score__1_5_ (type: esriFieldTypeInteger, alias: Reliability Score (1-5), SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Killed__includes_shooter_ (type: esriFieldTypeInteger, alias: Killed (includes shooter), SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Wounded (type: esriFieldTypeInteger, alias: Wounded, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Total_Injured_Killed_Victi (type: esriFieldTypeInteger, alias: Total Injured/Killed Victims, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Gender_of_Victims__M_F_Bot (type: esriFieldTypeString, alias: Gender of Victims (M/F/Both), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Victim_s_Affiliation_w__Sc (type: esriFieldTypeString, alias: Victim's Affiliation w/ School, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Victim_s_age_s_ (type: esriFieldTypeString, alias: Victim's age(s), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Targeted_Specific_Victim_s (type: esriFieldTypeString, alias: Targeted Specific Victim(s), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Random_Victims (type: esriFieldTypeString, alias: Random Victims, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Bullied__Y_N__N_A_ (type: esriFieldTypeString, alias: Bullied (Y/N/ N/A), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Domestic_Violence__Y_N_ (type: esriFieldTypeString, alias: Domestic Violence (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Suicide__Shooter_was_only_ (type: esriFieldTypeString, alias: Suicide (Shooter was only victim) Y/N/ N/A, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Suicide__shot_self_immedia (type: esriFieldTypeString, alias: Suicide (shot self immediately following initial shootings) Y/N/ N/A, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Suicide__e_g___shot_self_a (type: esriFieldTypeString, alias: Suicide (e.g., shot self at end of incident - time period between first shots and suicide, different location, when confronted by police) Y/N/ N/A, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Suicide__or_attempted_suic (type: esriFieldTypeString, alias: Suicide (or attempted suicide) by Shooter (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Shooter_s_actions_immediat (type: esriFieldTypeString, alias: Shooter's actions immediately after shots fired, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Pre_planned_school_attack_ (type: esriFieldTypeString, alias: Pre-planned school attack (Columbine style; not domestic), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Summary (type: esriFieldTypeString, alias: Summary, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Category (type: esriFieldTypeString, alias: Category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_School_Type (type: esriFieldTypeString, alias: School Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Narrative__Detailed_Summar (type: esriFieldTypeString, alias: Narrative (Detailed Summary/ Background), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Sources (type: esriFieldTypeString, alias: Sources, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Time_of_Occurrence__12_hou (type: esriFieldTypeString, alias: Time of Occurrence (12 hour AM/PM), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Day_of_week (type: esriFieldTypeString, alias: Day of week, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_During_School_Day__Y_N_ (type: esriFieldTypeString, alias: During School Day (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Time_Period (type: esriFieldTypeString, alias: Time Period, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Number_of_Shots_Fired (type: esriFieldTypeString, alias: Number of Shots Fired, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Firearm_Type (type: esriFieldTypeString, alias: Firearm Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Caliber_of_Firearm (type: esriFieldTypeString, alias: Caliber of Firearm, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Number_of_Shooters (type: esriFieldTypeString, alias: Number of Shooters, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Shooter_Name (type: esriFieldTypeString, alias: Shooter Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Shooter_Age (type: esriFieldTypeString, alias: Shooter Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Shooter_Gender (type: esriFieldTypeString, alias: Shooter Gender, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Shooter_s_Affiliation_with (type: esriFieldTypeString, alias: Shooter's Affiliation with School, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Hostages_Taken__Y_N_ (type: esriFieldTypeString, alias: Hostages Taken (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Field41 (type: esriFieldTypeString, alias: Field41, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Field42 (type: esriFieldTypeString, alias: Field42, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• USER_Field43 (type: esriFieldTypeString, alias: Field43, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: K12SchoolShootings_Geocoded
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• USER_Field42:
• USER_Field43:
• IN_Address:
• IN_Address2:
• IN_Address3:
• IN_Neighborhood:
• IN_City:
• IN_Subregion:
• IN_Region:
• IN_Postal:
• IN_PostalExt:
• IN_CountryCode:
• USER_School:
• USER_City:
• USER_State:
• USER_Gender_of_Victims__M_F_Bot:
• USER_Victim_s_Affiliation_w__Sc:
• USER_Victim_s_age_s_:
• USER_Targeted_Specific_Victim_s:
• USER_Random_Victims:
• USER_Bullied__Y_N__N_A_:
• USER_Domestic_Violence__Y_N_:
• USER_Suicide__Shooter_was_only_:
• USER_Suicide__shot_self_immedia:
• USER_Suicide__e_g___shot_self_a:
• USER_Suicide__or_attempted_suic:
• USER_Shooter_s_actions_immediat:
• USER_Pre_planned_school_attack_:
• USER_Summary:
• USER_Category:
• USER_School_Type:
• USER_Narrative__Detailed_Summar:
• USER_Sources:
• USER_Time_of_Occurrence__12_hou:
• USER_Day_of_week:
• USER_During_School_Day__Y_N_:
• USER_Time_Period:
• USER_Location:
• USER_Number_of_Shots_Fired:
• USER_Firearm_Type:
• USER_Caliber_of_Firearm:
• USER_Number_of_Shooters:
• USER_Shooter_Name:
• USER_Shooter_Age:
• USER_Shooter_Gender:
• USER_Shooter_s_Affiliation_with:
• USER_Hostages_Taken__Y_N_:
• USER_Field41:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/19/2018 3:13:58 PM

Schema Last Edit Date: 10/19/2018 3:13:58 PM

Data Last Edit Date: 10/19/2018 3:13:58 PM

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