Name: DESKTOP_ASSESSMENT

Display Field: PERSON_CONTACTED

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 32000

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_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field: GlobalID_2

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CROSSING_ID (type: esriFieldTypeInteger, alias: Crosing ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERSON_CONTACTED (type: esriFieldTypeString, alias: Person Contacted , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AFFILIATION_OF_CONTACT (type: esriFieldTypeString, alias: Affiliation Of Person Contacted, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DATE_OF_PERSON_CONTACT (type: esriFieldTypeString, alias: Date Of Contact For Person Contacted, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AGE_OF_STRUCTURE (type: esriFieldTypeInteger, alias: Age Of Structure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAZ_MIT_SIZE (type: esriFieldTypeString, alias: Site Identified in Hazard Mitigation Plan, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• REPLACEMENT_PLANS (type: esriFieldTypeString, alias: Replacement Plans, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HISTORY_OF_FLOODING (type: esriFieldTypeString, alias: History Of Flooding, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EMERGENCY_ACCES (type: esriFieldTypeString, alias: Emergency Access Or Evacuation Route, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• INTERVIEW_COMMENTS (type: esriFieldTypeString, alias: Other Interview Comments, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CROSSING_OUTLET_TO (type: esriFieldTypeString, alias: Crossing Outlets Directly To, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Atlantic Ocean: Atlantic Ocean], [Subtidal: Subtidal], [Both: Both], ... 1 more ...)
• NUM_DS_CROSSINGS (type: esriFieldTypeInteger, alias: Number Of Downstream Tidal Crossings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUM_US_CROSSINGS (type: esriFieldTypeInteger, alias: Number Of Upstream Tidal Crossings, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUM_DS_RESTRICTIONS (type: esriFieldTypeInteger, alias: Number Of Downstream Tidal Restrictions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUM_US_RESTRICTIONS (type: esriFieldTypeInteger, alias: Number Of Upstream Tidal Restrictions, SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_WATERSHED_AREA (type: esriFieldTypeDouble, alias: Upstream Watershed Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_SALT_MARSH_AREA (type: esriFieldTypeDouble, alias: Upstream Salt Marsh Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERCENT_WETLAND (type: esriFieldTypeDouble, alias: Watershed Land Use - Percent Wetland, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERCENT_FORESTED (type: esriFieldTypeDouble, alias: Watershed Land Use - Percent Forested, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERCENT_IMPERVIOUS (type: esriFieldTypeDouble, alias: Watershed Land Use - Percent Impervious, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERCENT_DEVELOPED (type: esriFieldTypeDouble, alias: Watershed Land Use - Percent Developed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_CHANNEL_WIDTH (type: esriFieldTypeInteger, alias: Upstream Channel Width , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_CHANNEL_WIDTH (type: esriFieldTypeInteger, alias: Downstream Channel Width , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_MAX_POOL_WIDTH (type: esriFieldTypeInteger, alias: Upstream Maximum Pool Width , SQL Type: sqlTypeOther, nullable: true, editable: true)
• DS_MAX_POOL_WIDTH (type: esriFieldTypeInteger, alias: Downstream Maximum Pool Width , SQL Type: sqlTypeOther, nullable: true, editable: true)
• CHANNEL_POOL_COMMENTS (type: esriFieldTypeString, alias: Channel And Pool Width Comments , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• IMPOUNDMENT (type: esriFieldTypeString, alias: Upstream Impoundment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• US_WATERSHED_MIGRATION (type: esriFieldTypeDouble, alias: US Watershed Area Of Marsh Migration , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_EVAL_UNIT_AREA_MIG (type: esriFieldTypeDouble, alias: US Eval. Unit Area Of Marsh Migration , SQL Type: sqlTypeOther, nullable: true, editable: true)
• NHBEOS (type: esriFieldTypeInteger, alias: NHBEOS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_NWI_CLASS (type: esriFieldTypeString, alias: Upstream NWI Classification , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DS_NWI_CLASS (type: esriFieldTypeString, alias: Downstream NWI Classification , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• MODELED_ROAD_SUR_INUND (type: esriFieldTypeString, alias: Modeled Road Surface Inundation , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• MODELED_ROAD_INUND_1_PER (type: esriFieldTypeString, alias: Modeled Road Inundation With 1% Annual Flood , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• INUNDATION_COMMENTS (type: esriFieldTypeString, alias: Inundation Risk Comments , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• US_INFRASTRUCTURE_IMPACTS (type: esriFieldTypeInteger, alias: Upstream Infrastructure Impacts , SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_IMPACTS_1_PER (type: esriFieldTypeInteger, alias: Upstream Infr. Impacts With 1% Annual Flood , SQL Type: sqlTypeOther, nullable: true, editable: true)
• CURRENT_QAQC_STATUS (type: esriFieldTypeString, alias: Current QA/QC Status , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• QAQC_STAFF (type: esriFieldTypeString, alias: QA/QC Staff , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [Shea Flanagan: Shea Flanagan], [Pete Steckler: Pete Steckler], [Other: Other])
• QAQC_COMMENTS (type: esriFieldTypeString, alias: QA/QC Comments , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• QAQC_ASSESS_TEAM_RESP (type: esriFieldTypeString, alias: QA/QC Assessment Team Response , SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EDIT_DATE (type: esriFieldTypeString, alias: EDIT_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EDITOR (type: esriFieldTypeString, alias: EDITOR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• EDITOR_COMMENTS (type: esriFieldTypeString, alias: EDITOR_COMMENTS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: DESKTOP_ASSESSMENT
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• SITE_INFORMATION (1) -- Related To: Site Information (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/14/2019 5:15:46 PM

Schema Last Edit Date: 5/14/2019 5:15:46 PM

Data Last Edit Date: 5/14/2019 5:15:46 PM

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