Name: Project Information

Display Field: project_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 53c0dbbdb33e45999860f9774fa21571

Copyright Text:

Default Visibility: false

MaxRecordCount: 20000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( modelName: objectid, nullable: false, defaultValue: null, editable: false, alias: OBJECTID, type: esriFieldTypeOID )
• project_id ( modelName: project_id, nullable: true, editable: true, defaultValue: null, length: 25, alias: Project ID, type: esriFieldTypeString )
• study_type ( modelName: study_type, nullable: true, editable: true, defaultValue: USACE, length: 25, alias: Study Type, type: esriFieldTypeString , Coded Values: [USACE: USACE] )
• project_site ( modelName: project_site, nullable: true, editable: true, defaultValue: null, length: 255, alias: Project/Site, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 50, alias: City, type: esriFieldTypeString )
• county ( modelName: county, nullable: true, editable: true, defaultValue: null, length: 50, alias: County, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 2, alias: State, type: esriFieldTypeString , Coded Values: [AL: Alabama] , [AK: Alaska] , [AZ: Arizona] , ...47 more... )
• investigator ( modelName: investigator, nullable: true, editable: true, defaultValue: null, length: 50, alias: Investigator(s), type: esriFieldTypeString )
• section ( modelName: section, nullable: true, editable: true, defaultValue: null, length: 25, alias: Section, type: esriFieldTypeString )
• twp ( modelName: twp, nullable: true, editable: true, defaultValue: null, length: 25, alias: Township, type: esriFieldTypeString )
• range ( modelName: range, nullable: true, editable: true, defaultValue: null, length: 25, alias: Range, type: esriFieldTypeString )
• landform ( modelName: landform, nullable: true, editable: true, defaultValue: null, length: 19, alias: Landform, type: esriFieldTypeString , Coded Values: [Basin / Depression: Basin / Depression] , [Channel: Channel] , [Flat : Flat ] , ...13 more... )
• local_relief ( modelName: local_relief, nullable: true, editable: true, defaultValue: null, length: 15, alias: Local Relief, type: esriFieldTypeString , Coded Values: [Concave: Concave] , [Convex: Convex] , [None: None] )
• slope ( modelName: slope, nullable: true, editable: true, defaultValue: null, alias: Slope (%), type: esriFieldTypeDouble )
• subregion ( modelName: subregion, nullable: true, editable: true, defaultValue: null, length: 8, alias: Subregion (LRR or MLRA), type: esriFieldTypeString )
• lat ( modelName: lat, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• long ( modelName: long, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• datum ( modelName: datum, nullable: true, editable: true, defaultValue: WGS84, length: 15, alias: Datum, type: esriFieldTypeString )
• remarks ( modelName: remarks, nullable: true, editable: true, defaultValue: null, length: 255, alias: Remarks, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• guid_rel ( modelName: guid_rel, nullable: true, editable: true, defaultValue: null, length: 38, alias: GUID REL, type: esriFieldTypeGUID )
• sampling_date ( modelName: sampling_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: Sampling Date, type: esriFieldTypeDate )
• applicant_owner ( modelName: applicant_owner, nullable: true, editable: true, defaultValue: null, length: 100, alias: Applicant/Owner, type: esriFieldTypeString )

Templates:

• Name: Project Information
  Description:
  Prototype:
  datum: WGS84
  applicant_owner: null
  city: null
  subregion: null
  sampling_date: null
  county: null
  range: null
  section: null
  twp: null
  local_relief: null
  slope: null
  project_site: null
  guid_rel: null
  landform: null
  long: null
  investigator: null
  study_type: USACE
  project_id: null
  state: null
  lat: null
  remarks: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• wetlands_data.DBO.Wetland_Areas (10) -- Related To: Wetland_Areas (11)
• wetlands_data.DBO.Culverts (8) -- Related To: Culverts (0)
• wetlands_data.DBO.General_Sample_Points (7) -- Related To: General_Sample_Points (1)
• wetlands_data.DBO.Soil_Test_Pits (5) -- Related To: Soil_Test_Pits (6)
• wetlands_data.DBO.Surface_Water_Lines (9) -- Related To: Surface_Water_Lines (9)
• wetlands_data.DBO.Surface_Water_Areas (11) -- Related To: Surface_Water_Areas (8)
• wetlands_data.DBO.Seeps (6) -- Related To: Seeps (5)

Capabilities: Create,Editing,Uploads,Query,Update,Delete,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata