Name: collectiontable

Display Field: parcelstatus

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• guid (type: esriFieldTypeGUID, alias: Parent Global ID From Feature, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• parcelstatus (type: esriFieldTypeString, alias: Parcel Status:, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Assessed: Assessed - Complete], [Assessed Return Needed: Assessed - Return Needed], [No Access: No Access], ... 1 more ...)
• Parentapn (type: esriFieldTypeString, alias: APN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• teamlead (type: esriFieldTypeString, alias: Team Lead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• datetimeonsite (type: esriFieldTypeDate, alias: Date and Time Onsite:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• datetimeoffsite (type: esriFieldTypeDate, alias: Date and Time Offsite:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• cgigas (type: esriFieldTypeString, alias: CGI/4 Gas Detected:, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• cgigasnotes (type: esriFieldTypeString, alias: CGI/4 Gas Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gammarad (type: esriFieldTypeString, alias: Gamma Rad Detected:, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• gammaradnotes (type: esriFieldTypeString, alias: Gamma Rad Notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• asbestosexists (type: esriFieldTypeString, alias: Suspect ACM exists onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• asbestostype (type: esriFieldTypeString, alias: Type of Asbestos, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Brake Pads: Brake Pads], [Cement Pipe (Transite): Cement Pipe (Transite)], [Cement Shingle (Transite): Cement Shingle (Transite)], ... 12 more ...)
• asbestosremoved (type: esriFieldTypeString, alias: ACM Removed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• asbestosremactivit (type: esriFieldTypeString, alias: Removal will take more than 2 Hours, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• asbestosunit (type: esriFieldTypeString, alias: Unit (Square Feet), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• asbestoscomments (type: esriFieldTypeString, alias: Suspect ACM Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• asbestosleftonsite (type: esriFieldTypeString, alias: Suspect ACM left on site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hhwexists (type: esriFieldTypeString, alias: HHW exists onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• hhwcomments (type: esriFieldTypeString, alias: HHW Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• selecthhw (type: esriFieldTypeString, alias: HHW Types Found, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Aerosols: Aerosols], [Antifreeze: Antifreeze], [Batteries: Batteries], ... 10 more ...)
• aerosolsc (type: esriFieldTypeSmallInteger, alias: Number Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• antifreezec (type: esriFieldTypeSmallInteger, alias: Number Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• solventsc (type: esriFieldTypeSmallInteger, alias: Number Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• poolchemicalsc (type: esriFieldTypeSmallInteger, alias: Number Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• householdcleanersc (type: esriFieldTypeSmallInteger, alias: Number Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• paintc (type: esriFieldTypeSmallInteger, alias: Number Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pesticidesc (type: esriFieldTypeSmallInteger, alias: Number Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fertilizersc (type: esriFieldTypeSmallInteger, alias: Number Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• oilwaterc (type: esriFieldTypeSmallInteger, alias: Amount Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mixedbatteryc (type: esriFieldTypeSmallInteger, alias: Amount Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fuelc (type: esriFieldTypeSmallInteger, alias: Amount Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fueltanksc (type: esriFieldTypeSmallInteger, alias: Amount Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• propanecylindersc (type: esriFieldTypeSmallInteger, alias: Amount Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• propanecylindersr (type: esriFieldTypeSmallInteger, alias: Amount Remaining - devalved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• acetylenecylindersc (type: esriFieldTypeSmallInteger, alias: Amount Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• otherc (type: esriFieldTypeSmallInteger, alias: Amount Recovered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• otherr (type: esriFieldTypeSmallInteger, alias: Amount Remaining, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ewasteonsite (type: esriFieldTypeString, alias: E-waste Collected Onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• transferinplace (type: esriFieldTypeString, alias: Transfer in Place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• emptycontainersleftonsite (type: esriFieldTypeString, alias: Empty containers identified and marked with white paint(x)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ammoleftonsite (type: esriFieldTypeString, alias: Ammunition Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• ammoleftgreater50 (type: esriFieldTypeString, alias: Is greater than 50 Cal?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• largetankleftonsite (type: esriFieldTypeString, alias: Is there a large propane onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• chimneyleftonsite (type: esriFieldTypeString, alias: Chimney onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• remnantleftonsite (type: esriFieldTypeString, alias: Did a Physical obstacle prevent full HHW assessment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• remnantdesc (type: esriFieldTypeString, alias: Physical Obstacle Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• revistyesno (type: esriFieldTypeString, alias: Is revisit required for additional Operations?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• revisittype (type: esriFieldTypeString, alias: Pick a reason for a revisit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [UXO: UXO], [Liquid Transfer: Liquid Transfer], [Drums: Drums], ... 2 more ...)
• revisitreasons (type: esriFieldTypeString, alias: Reason for Revisit, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• othernotes (type: esriFieldTypeString, alias: Assessment Notes:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• 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: collectiontable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• parcel (0) -- Related To: kincadefireParcelLayer (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/17/2020 11:07:50 PM

Schema Last Edit Date: 6/17/2020 11:07:50 PM

Data Last Edit Date: 6/17/2020 11:07:50 PM

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