Name: Retail_Crime_Partnership_SW_W

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

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

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: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• note1 (type: esriFieldTypeString, alias: Southwest Police Division Organized Retail Crime Partnership Pilot, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note2 (type: esriFieldTypeString, alias: As a follow-up to our partners call on organized retail crime impacting businesses in Southwest Philadelphia, our next step is to gather information to aid in the development of strategies and to identify deployment needs. The information will help to identify the top ten offenders at each business location, security policies, procedures and tools used in the detection, apprehension and prosecution of the offenders., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note3 (type: esriFieldTypeString, alias: The information you provide will be kept strictly confidential and is for law enforcement purposes only., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note4 (type: esriFieldTypeString, alias: Contact Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• business_name (type: esriFieldTypeString, alias: Business Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address (Center City locations):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• phone_number (type: esriFieldTypeString, alias: Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note5 (type: esriFieldTypeString, alias: note5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• asset (type: esriFieldTypeString, alias: Primary Asset Protection Contact:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• phone_number2 (type: esriFieldTypeString, alias: Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note6 (type: esriFieldTypeString, alias: note6, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• corporate (type: esriFieldTypeString, alias: Primary Corporate Security Contact:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• phone_number3 (type: esriFieldTypeString, alias: Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email2 (type: esriFieldTypeString, alias: Email Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note7 (type: esriFieldTypeString, alias: note7, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• orc (type: esriFieldTypeString, alias: Primary ORC Contact:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• phone_number4 (type: esriFieldTypeString, alias: Phone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email3 (type: esriFieldTypeString, alias: Email Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note8 (type: esriFieldTypeString, alias: Top Retail Theft Offenders, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• offenders (type: esriFieldTypeString, alias: How do you determine who is among your top offenders?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note9 (type: esriFieldTypeString, alias: Offender Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• name_address (type: esriFieldTypeString, alias: Name and address of top offender(s), if known:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• images (type: esriFieldTypeString, alias: Do you have images of the offender?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• times (type: esriFieldTypeString, alias: General Time of Day:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• day_week (type: esriFieldTypeString, alias: Day of the Week:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• items (type: esriFieldTypeString, alias: Top items stolen:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• losses (type: esriFieldTypeString, alias: Estimated losses attributed to each offender?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note10 (type: esriFieldTypeString, alias: Security/Asset Protection Staff/Police Services, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prevention (type: esriFieldTypeString, alias: Do you have Asset Protection/Loss Prevention Staff at this location?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• security_officers (type: esriFieldTypeString, alias: Do you have uniformed Security Officers at this location?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• specify (type: esriFieldTypeString, alias: Please specify the days of the week and hours:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• police_officers (type: esriFieldTypeString, alias: Do you hire Philadelphia Police Officers for this location?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• specify2 (type: esriFieldTypeString, alias: Please specify the days of the week and hours:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note11 (type: esriFieldTypeString, alias: Security Tools / Technology, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• deter (type: esriFieldTypeString, alias: Do you use security devices to deter theft?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• devices (type: esriFieldTypeString, alias: Please specify which devices:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note12 (type: esriFieldTypeString, alias: Technique /Tradecraft, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tradecraft (type: esriFieldTypeString, alias: Please provide details below on any tradecraft employed by offenders when taking merchandise:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• platforms (type: esriFieldTypeString, alias: Have you identified any online platforms being used to resell stolen merchandise?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• resell (type: esriFieldTypeString, alias: Please list the platforms:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• locations (type: esriFieldTypeString, alias: Have you identified any locations in the region where you believe your merchandise is being sold in person?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• region (type: esriFieldTypeString, alias: Please list the locations:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• technology (type: esriFieldTypeString, alias: Please provide information on any advancements in security technology that has proven effective again retail crime for your business or industry:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note13 (type: esriFieldTypeString, alias: Organizational Policies , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• company (type: esriFieldTypeString, alias: Does your company approach and detain suspected shoplifters? :, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• prosecute (type: esriFieldTypeString, alias: Does your company prosecute shoplifters? :, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• subpoena (type: esriFieldTypeString, alias: Does your company have a subpoena policy for employees to testify in court?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• policy (type: esriFieldTypeString, alias: Please describe the policy:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• threshold (type: esriFieldTypeString, alias: Do you have a financial threshold for approaching and prosecuting shoplifters for single incidents?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• financial (type: esriFieldTypeString, alias: Please select financial threshold:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [we_do_not_approach_or_apprehend_shoplifters: We do not approach or apprehend shoplifters], [50: 50], [100: 100], ... 4 more ...)
• cumulative (type: esriFieldTypeString, alias: Do you have a financial threshold for approaching and prosecuting shoplifters for cumulative incidents for repeat offenders?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• approaching (type: esriFieldTypeString, alias: What is the threshold?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• disposition (type: esriFieldTypeString, alias: Do you have any alternative disposition programs?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• programs (type: esriFieldTypeString, alias: Please list the programs:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• information (type: esriFieldTypeString, alias: Do you have any information that you believe would be beneficial as we develop a comprehensive plan to reduce retail theft in Center City?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• beneficial (type: esriFieldTypeString, alias: Please explain:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note14 (type: esriFieldTypeString, alias: note14, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note15 (type: esriFieldTypeString, alias: Thank you for your participation and ongoing efforts to make Center City safer!, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note16 (type: esriFieldTypeString, alias: note16, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• note17 (type: esriFieldTypeString, alias: If you have any questions or need more information, please contact Stacy Irving at Stacy.Irving@Phila.Gov, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/3/2023 7:42:44 PM

Schema Last Edit Date: 3/3/2023 7:42:44 PM

Data Last Edit Date: 3/3/2023 7:42:44 PM

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