Name: Crime_Incidents

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: false

Views

Description: PB_Philly_Crime.DBO.crime_incidents

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 10000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -75.2777
YMin: 39.8763000000001
XMax: -74.9575
YMax: 40.1364
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"visualVariables":[{"type":"sizeInfo","field":null,"valueExpression":"var ageMinutes = DateDiff(Now(), $feature.DISPATCH_DATE_TIME, 'minutes');\nvar ageHours = DateDiff(Now(), $feature.DISPATCH_DATE_TIME, 'hours');\n//var hello = Random()>0.5;\nageHours","valueExpressionTitle":"Hours Since Dispatch","valueUnit":"unknown","minSize":10.5,"maxSize":3,"minDataValue":24,"maxDataValue":24.001}],"authoringInfo":{"visualVariables":[{"type":"sizeInfo","minSliderValue":0.098925,"maxSliderValue":671.93227722222218}]},"type":"uniqueValue","field1":"UCR_Type","defaultSymbol":{"color":[170,170,170,255],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"defaultLabel":"Other","uniqueValueInfos":[{"value":"Agg. Assault","label":"Agg. Assault","symbol":{"color":[255,180,97,183],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[242,152,51,33],"width":5.25,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Burglary","label":"Burglary","symbol":{"color":[116,209,115,183],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[83,179,80,33],"width":5.25,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Larceny","label":"Larceny","symbol":{"color":[0,181,185,185],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[19,118,191,33],"width":5.25,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"MV Theft","label":"MV Theft","symbol":{"color":[163,147,209,183],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[132,110,191,33],"width":5.25,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Robbery","label":"Robbery","symbol":{"color":[235,121,83,183],"size":10.5,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[209,82,38,33],"width":5.25,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Other","label":"Other","symbol":{"color":[245,223,98,183],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[214,189,42,33],"width":5.25,"type":"esriSLS","style":"esriSLSSolid"}}}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ID

Unique ID Field:

Name : ID

IsSystemMaintained : True

Global ID Field:

Type ID Field: UCR_Type

Fields:

• DC_DIST (type: esriFieldTypeString, alias: DC_DIST, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SECTOR (type: esriFieldTypeString, alias: SECTOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DISPATCH_DATE_TIME (type: esriFieldTypeDate, alias: DISPATCH_DATE_TIME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DISPATCH_DATE (type: esriFieldTypeDate, alias: DISPATCH_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DISPATCH_TIME (type: esriFieldTypeString, alias: DISPATCH_TIME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LOCATION_BLOCK (type: esriFieldTypeString, alias: LOCATION_BLOCK, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UCR_GENERAL (type: esriFieldTypeString, alias: UCR_GENERAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TEXT_GENERAL_CODE (type: esriFieldTypeString, alias: TEXT_GENERAL_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Time_Pattern (type: esriFieldTypeString, alias: Time_Pattern, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Pattern (type: esriFieldTypeString, alias: Pattern, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DIV_NAME (type: esriFieldTypeString, alias: DIV_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PSA_NUM (type: esriFieldTypeString, alias: PSA_NUM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TimeBlock (type: esriFieldTypeString, alias: TimeBlock, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UCR_CATEGORY (type: esriFieldTypeString, alias: UCR_CATEGORY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Day_of_Week (type: esriFieldTypeString, alias: Day_of_Week, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UCR_Type (type: esriFieldTypeString, alias: UCR_Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ID (type: esriFieldTypeOID, alias: ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Hour_of_Day (type: esriFieldTypeString, alias: Hour of Day, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• day_of_week_num (type: esriFieldTypeInteger, alias: Day of Week Number, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: Agg. Assault
Name: Agg. Assault
Domains:

Templates:

Name: Agg. Assault
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• UCR_Type: Agg. Assault

---

ID: Burglary
Name: Burglary
Domains:

Templates:

Name: Burglary
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• UCR_Type: Burglary

---

ID: Larceny
Name: Larceny
Domains:

Templates:

Name: Larceny
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• UCR_Type: Larceny

---

ID: Murder
Name: Murder
Domains:

Templates:

Name: Murder
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• UCR_Type: Murder

---

ID: MV Theft
Name: MV Theft
Domains:

Templates:

Name: MV Theft
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• UCR_Type: MV Theft

---

ID: Robbery
Name: Robbery
Domains:

Templates:

Name: Robbery
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• UCR_Type: Robbery

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/2/2022 12:49:35 AM

Schema Last Edit Date: 3/2/2022 12:49:35 AM

Data Last Edit Date: 3/2/2022 12:49:35 AM

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