Name: CE NoV Report Table
Display Field: DIVISION
Type: Table
Geometry Type: N/A
Description:
Definition Expression: N/A
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, AMF, geoJSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing 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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
, editable: false
, nullable: false
)
-
DIVISION
(
type: esriFieldTypeString
, alias: Division
, editable: true
, nullable: true
, length: 150
)
-
DEPARTMENT
(
type: esriFieldTypeString
, alias: Department
, editable: true
, nullable: true
, length: 150
)
-
CATEGORY
(
type: esriFieldTypeString
, alias: Category
, editable: true
, nullable: true
, length: 50
)
-
INCIDENT_ID
(
type: esriFieldTypeInteger
, alias: Oracle ID
, editable: true
, nullable: true
)
-
INCIDENT_NUMBER
(
type: esriFieldTypeString
, alias: Service Request Number
, editable: true
, nullable: true
, length: 15
)
-
INCIDENT_TYPE_ID
(
type: esriFieldTypeInteger
, alias: Service Request Type ID
, editable: true
, nullable: true
)
-
REQUEST_TYPE
(
type: esriFieldTypeString
, alias: Service Request Type
, editable: true
, nullable: true
, length: 50
)
-
REPORTED_DATE
(
type: esriFieldTypeDate
, alias: Reported Date
, editable: true
, nullable: true
, length: 8
)
-
REQUEST_SUMMARY
(
type: esriFieldTypeString
, alias: Service Request Summary
, editable: true
, nullable: true
, length: 2000
)
-
CREATED_BY_USER
(
type: esriFieldTypeString
, alias: Created By
, editable: true
, nullable: true
, length: 255
)
-
LAST_UPDATE_DATE
(
type: esriFieldTypeDate
, alias: Last Updated Date
, editable: true
, nullable: true
, length: 8
)
-
UPDATED_BY_USER
(
type: esriFieldTypeString
, alias: Updated By
, editable: true
, nullable: true
, length: 50
)
-
FOLLOWUP_DATE
(
type: esriFieldTypeDate
, alias: Follow Up Date
, editable: true
, nullable: true
, length: 8
)
-
NOV_DATE
(
type: esriFieldTypeDate
, alias: Notice Given Date
, editable: true
, nullable: true
, length: 8
)
-
Court_Date
(
type: esriFieldTypeDate
, alias: Court Date
, editable: true
, nullable: true
, length: 8
)
-
JOB_NOTES
(
type: esriFieldTypeString
, alias: Job Notes
, editable: true
, nullable: true
, length: 255
)
-
CLOSE_DATE
(
type: esriFieldTypeDate
, alias: Closed Date
, editable: true
, nullable: true
, length: 8
)
-
SUPERVISOR
(
type: esriFieldTypeString
, alias: Supervisor
, editable: true
, nullable: true
, length: 50
)
-
ADDRESS1
(
type: esriFieldTypeString
, alias: Location
, editable: true
, nullable: true
, length: 255
)
-
ADDRESS2
(
type: esriFieldTypeString
, alias: Apt/ Unit No
, editable: true
, nullable: true
, length: 100
)
-
ADDRESS3
(
type: esriFieldTypeString
, alias: P.O. Box
, editable: true
, nullable: true
, length: 100
)
-
CITY
(
type: esriFieldTypeString
, alias: City
, editable: true
, nullable: true
, length: 100
)
-
STATE
(
type: esriFieldTypeString
, alias: State
, editable: true
, nullable: true
, length: 50
)
-
POSTAL_CODE
(
type: esriFieldTypeString
, alias: Postal Code
, editable: true
, nullable: true
, length: 20
)
-
PARCEL_ID
(
type: esriFieldTypeString
, alias: Parcel ID
, editable: true
, nullable: true
, length: 20
)
-
PERSON_ADDRESS1
(
type: esriFieldTypeString
, alias: Owner Address1
, editable: true
, nullable: true
, length: 255
)
-
PERSON_ADDRESS2
(
type: esriFieldTypeString
, alias: Owner Address2
, editable: true
, nullable: true
, length: 255
)
-
PERSON_ADDRESS3
(
type: esriFieldTypeString
, alias: Owner Address3
, editable: true
, nullable: true
, length: 255
)
-
PERSON_STATE
(
type: esriFieldTypeString
, alias: Owner State
, editable: true
, nullable: true
, length: 50
)
-
PERSON_CITY
(
type: esriFieldTypeString
, alias: Owner City
, editable: true
, nullable: true
, length: 100
)
-
PERSON_ZIP_CODE
(
type: esriFieldTypeString
, alias: Owner Zip Code
, editable: true
, nullable: true
, length: 50
)
-
MAP_PG
(
type: esriFieldTypeString
, alias: Map Page
, editable: true
, nullable: true
, length: 50
)
-
MAP_BLK
(
type: esriFieldTypeString
, alias: Map Block
, editable: true
, nullable: true
, length: 50
)
-
CODE_DISTRICT
(
type: esriFieldTypeString
, alias: Code District
, editable: true
, nullable: true
, length: 50
)
-
CODE_SUBDISTRICT
(
type: esriFieldTypeString
, alias: Code Sub-District
, editable: true
, nullable: true
, length: 50
)
-
TARGET_BLOCK
(
type: esriFieldTypeString
, alias: Target Block
, editable: true
, nullable: true
, length: 50
)
-
MLGW_CUSTOMER
(
type: esriFieldTypeString
, alias: MLGW Customer
, editable: true
, nullable: true
, length: 255
)
-
MLGW_CONTACT1
(
type: esriFieldTypeString
, alias: MLGW Contact 1
, editable: true
, nullable: true
, length: 25
)
-
MLGW_CONTACT2
(
type: esriFieldTypeString
, alias: MLGW Contact 2
, editable: true
, nullable: true
, length: 25
)
-
MLGW_EMAIL
(
type: esriFieldTypeString
, alias: MLGW Contact Email
, editable: true
, nullable: true
, length: 100
)
-
X_COORD
(
type: esriFieldTypeDouble
, alias: X_COORD
, editable: true
, nullable: true
)
-
Y_COORD
(
type: esriFieldTypeDouble
, alias: Y_COORD
, editable: true
, nullable: true
)
-
Abate_Date
(
type: esriFieldTypeDate
, alias: Abatement Date
, editable: true
, nullable: true
, length: 8
)
-
Sect_3081
(
type: esriFieldTypeString
, alias: Sect. 308.1
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3082_3083
(
type: esriFieldTypeString
, alias: Sect. 308.1
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3092_3093_3095
(
type: esriFieldTypeString
, alias: Sect. 309.2;309.3;309.5
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_6054
(
type: esriFieldTypeString
, alias: Sect. 605.4
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_6023_6031
(
type: esriFieldTypeString
, alias: Sect. 602.3; 603.1
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3027_3041
(
type: esriFieldTypeString
, alias: Sect. 302.7; 304.1
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3081_3082
(
type: esriFieldTypeString
, alias: Sect. 308.1; 308.2
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3024
(
type: esriFieldTypeString
, alias: Sect. 302.4
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3021_3081
(
type: esriFieldTypeString
, alias: Sect. 302.1; 308.1
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3028_1
(
type: esriFieldTypeString
, alias: Sect. 302.8
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3028_2
(
type: esriFieldTypeString
, alias: Sect. 302.8
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Sect_3028_30281_30282
(
type: esriFieldTypeString
, alias: Sect. 302.8; 302.8.1; 302.8.2
, editable: true
, nullable: true
, length: 10
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
Other_Offense
(
type: esriFieldTypeString
, alias: Other Offenses
, editable: true
, nullable: true
, length: 255
)
-
GlobalID
(
type: esriFieldTypeGlobalID
, alias: GlobalID
, editable: false
, nullable: false
, length: 38
)
-
created_user
(
type: esriFieldTypeString
, alias: created_user
, editable: true
, nullable: true
, length: 255
)
-
created_date
(
type: esriFieldTypeDate
, alias: created_date
, editable: true
, nullable: true
, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString
, alias: last_edited_user
, editable: true
, nullable: true
, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate
, alias: last_edited_date
, editable: true
, nullable: true
, length: 8
)
-
SR_GUID
(
type: esriFieldTypeGUID
, alias: SR_GUID
, editable: true
, nullable: true
, length: 38
)
-
NOV_Recip
(
type: esriFieldTypeString
, alias: NOV_Recip
, editable: true
, nullable: true
, length: 255
)
-
NOV_Violation
(
type: esriFieldTypeString
, alias: NOV_Violation
, editable: true
, nullable: true
, length: 255
)
-
Violator
(
type: esriFieldTypeString
, alias: Violator
, editable: true
, nullable: true
, length: 255
)
-
Insp_PhoneNum
(
type: esriFieldTypeString
, alias: Insp_PhoneNum
, editable: true
, nullable: true
, length: 50
)
Templates:
-
Name: CE NoV Report Table
Description:
Prototype:
Violator: null
Insp_PhoneNum: null
DIVISION: null
DEPARTMENT: null
CATEGORY: null
INCIDENT_ID: null
INCIDENT_NUMBER: null
INCIDENT_TYPE_ID: null
REQUEST_TYPE: null
REPORTED_DATE: null
REQUEST_SUMMARY: null
CREATED_BY_USER: null
LAST_UPDATE_DATE: null
UPDATED_BY_USER: null
FOLLOWUP_DATE: null
NOV_DATE: null
Court_Date: null
JOB_NOTES: null
CLOSE_DATE: null
SUPERVISOR: null
ADDRESS1: null
ADDRESS2: null
ADDRESS3: null
CITY: null
STATE: null
POSTAL_CODE: null
PARCEL_ID: null
PERSON_ADDRESS1: null
PERSON_ADDRESS2: null
PERSON_ADDRESS3: null
PERSON_STATE: null
PERSON_CITY: null
PERSON_ZIP_CODE: null
MAP_PG: null
MAP_BLK: null
CODE_DISTRICT: null
CODE_SUBDISTRICT: null
TARGET_BLOCK: null
MLGW_CUSTOMER: null
MLGW_CONTACT1: null
MLGW_CONTACT2: null
MLGW_EMAIL: null
X_COORD: null
Y_COORD: null
Abate_Date: null
Sect_3081: null
Sect_3082_3083: null
Sect_3092_3093_3095: null
Sect_6054: null
Sect_6023_6031: null
Sect_3027_3041: null
Sect_3081_3082: null
Sect_3024: null
Sect_3021_3081: null
Sect_3028_1: null
Sect_3028_2: null
Sect_3028_30281_30282: null
Other_Offense: null
NOV_Violation: null
created_user: null
created_date: null
last_edited_user: null
last_edited_date: null
SR_GUID: null
NOV_Recip: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Create,Query,Update,Uploads,Editing
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
Supports Query With Historic Moment: false
Supports Coordinates Quantization: false
Supported Operations:
Query
Query Related Records
Apply Edits
Add Features
Update Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata