View In:   ArcGIS Online Map Viewer

Name: Two Year Gun Crime

Display Field: CCN

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>DC crime incident locations. The dataset contains a subset of locations and attributes of incidents reported in the ASAP (Analytical Services Application) crime report database by the District of Columbia Metropolitan Police Department (MPD). Visit </SPAN><A href="https://crimecards.dc.gov/"><SPAN>https://crimecards.dc.gov</SPAN></A><SPAN> for more information.</SPAN></P><P><SPAN>This data is shared via an automated process where addresses are geocoded to the District's Master Address Repository and assigned to the appropriate street block. Block locations for some crime points could not be automatically assigned resulting in 0,0 for x,y coordinates. These can be interactively assigned using the </SPAN><A href="https://octo.dc.gov/node/1161947"><SPAN>MAR Geocoder</SPAN></A><SPAN>. </SPAN></P><P><SPAN>On February 1 2020, the methodology of geography assignments of crime data was modified to increase accuracy. From January 1 2020 going forward, all crime data will have Ward, ANC, SMD, BID, Neighborhood Cluster, Voting Precinct, Block Group and Census Tract values calculated prior to, rather than after, anonymization to the block level. This change impacts approximately one percent of Ward assignments.</SPAN></P></DIV></DIV></DIV>

Copyright Text: https://mpdc.dc.gov

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 390103
YMin: 127300
XMax: 407806
YMax: 147441
Spatial Reference: 26985  (26985)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [53, 137, 38, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CCN ( type: esriFieldTypeString, alias: CCN, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CCN )
• REPORT_DAT ( type: esriFieldTypeDate, alias: REPORT_DAT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPORT_DAT )
• SHIFT ( type: esriFieldTypeString, alias: SHIFT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SHIFT )
• METHOD ( type: esriFieldTypeString, alias: METHOD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: METHOD )
• OFFENSE ( type: esriFieldTypeString, alias: OFFENSE, editable: true, nullable: true, length: 250, defaultValue: null, modelName: OFFENSE )
• BLOCK ( type: esriFieldTypeString, alias: BLOCK, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BLOCK )
• XBLOCK ( type: esriFieldTypeDouble, alias: XBLOCK, editable: true, nullable: true, defaultValue: null, modelName: XBLOCK )
• YBLOCK ( type: esriFieldTypeDouble, alias: YBLOCK, editable: true, nullable: true, defaultValue: null, modelName: YBLOCK )
• WARD ( type: esriFieldTypeString, alias: WARD, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WARD )
• ANC ( type: esriFieldTypeString, alias: ANC, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ANC )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DISTRICT )
• PSA ( type: esriFieldTypeString, alias: PSA, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PSA )
• NEIGHBORHOOD_CLUSTER ( type: esriFieldTypeString, alias: NEIGHBORHOOD_CLUSTER, editable: true, nullable: true, length: 200, defaultValue: null, modelName: NEIGHBORHOOD_CLUSTER )
• BLOCK_GROUP ( type: esriFieldTypeString, alias: BLOCK_GROUP, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BLOCK_GROUP )
• CENSUS_TRACT ( type: esriFieldTypeString, alias: CENSUS_TRACT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CENSUS_TRACT )
• VOTING_PRECINCT ( type: esriFieldTypeString, alias: VOTING_PRECINCT, editable: true, nullable: true, length: 25, defaultValue: null, modelName: VOTING_PRECINCT )
• XCOORD ( type: esriFieldTypeDouble, alias: XCOORD, editable: true, nullable: true, defaultValue: null, modelName: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: YCOORD, editable: true, nullable: true, defaultValue: null, modelName: YCOORD )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• BID ( type: esriFieldTypeString, alias: BID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BID )
• START_DATE ( type: esriFieldTypeDate, alias: START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START_DATE )
• END_DATE ( type: esriFieldTypeDate, alias: END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_DATE )
• SE_ANNO_CAD_DATA ( type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA, editable: true, nullable: true, defaultValue: null, modelName: SE_ANNO_CAD_DATA )
• OCTO_RECORD_ID ( type: esriFieldTypeString, alias: OCTO_RECORD_ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OCTO_RECORD_ID )

Templates:

• Name: Two Year Gun Crime
  Description:
  Prototype:
  SE_ANNO_CAD_DATA: null
  CCN: null
  REPORT_DAT: null
  SHIFT: null
  METHOD: null
  OFFENSE: null
  BLOCK: null
  XBLOCK: null
  YBLOCK: null
  WARD: null
  ANC: null
  DISTRICT: null
  PSA: null
  NEIGHBORHOOD_CLUSTER: null
  BLOCK_GROUP: null
  CENSUS_TRACT: null
  VOTING_PRECINCT: null
  XCOORD: null
  YCOORD: null
  LATITUDE: null
  LONGITUDE: null
  BID: null
  START_DATE: null
  END_DATE: null
  OCTO_RECORD_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata