Name: ARCPLN.ESTIP_PROJECTS_TBL

Display Field: PLAN_NAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

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

• ARC_ID ( type: esriFieldTypeOID, alias: ARC_ID, editable: false, nullable: false, defaultValue: null, modelName: ARC_ID )
• PLAN_NAME ( type: esriFieldTypeString, alias: PLAN_NAME, editable: true, nullable: true, length: 400, defaultValue: null, modelName: PLAN_NAME )
• PLAN_FULL_NAME ( type: esriFieldTypeString, alias: PLAN_FULL_NAME, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: PLAN_FULL_NAME )
• PLAN_OWNER ( type: esriFieldTypeString, alias: PLAN_OWNER, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: PLAN_OWNER )
• PLAN_CYCLE_FULL_NAME ( type: esriFieldTypeString, alias: PLAN_CYCLE_FULL_NAME, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: PLAN_CYCLE_FULL_NAME )
• START_YEAR ( type: esriFieldTypeSmallInteger, alias: START_YEAR, editable: true, nullable: true, defaultValue: null, modelName: START_YEAR )
• END_YEAR ( type: esriFieldTypeSmallInteger, alias: END_YEAR, editable: true, nullable: true, defaultValue: null, modelName: END_YEAR )
• PLAN_REVISION ( type: esriFieldTypeString, alias: PLAN_REVISION, editable: true, nullable: true, length: 400, defaultValue: null, modelName: PLAN_REVISION )
• REVISION_TYPE ( type: esriFieldTypeString, alias: REVISION_TYPE, editable: true, nullable: true, length: 400, defaultValue: null, modelName: REVISION_TYPE )
• REVISION_NOTES ( type: esriFieldTypeString, alias: REVISION_NOTES, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: REVISION_NOTES )
• APPROVAL_TYPE ( type: esriFieldTypeString, alias: APPROVAL_TYPE, editable: true, nullable: true, length: 400, defaultValue: null, modelName: APPROVAL_TYPE )
• APPROVAL_DATE ( type: esriFieldTypeDate, alias: APPROVAL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: APPROVAL_DATE )
• RANK_NO ( type: esriFieldTypeDouble, alias: RANK_NO, editable: true, nullable: true, defaultValue: null, modelName: RANK_NO )
• id ( type: esriFieldTypeString, alias: id, editable: true, nullable: true, length: 50, defaultValue: null, modelName: id )
• projectType ( type: esriFieldTypeString, alias: projectType, editable: true, nullable: true, length: 200, defaultValue: null, modelName: projectType )
• LEAD_AGENCY ( type: esriFieldTypeString, alias: LEAD_AGENCY, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LEAD_AGENCY )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 400, defaultValue: null, modelName: DESCRIPTION )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: COUNTY )
• MUNICIPALITY ( type: esriFieldTypeString, alias: MUNICIPALITY, editable: true, nullable: true, length: 400, defaultValue: null, modelName: MUNICIPALITY )
• CHANGE_REASON ( type: esriFieldTypeString, alias: CHANGE_REASON, editable: true, nullable: true, length: 400, defaultValue: null, modelName: CHANGE_REASON )
• customFieldName_projSuffix ( type: esriFieldTypeString, alias: customFieldName_projSuffix, editable: true, nullable: true, length: 43, defaultValue: null, modelName: customFieldName_projSuffix )
• LOCATION_NO ( type: esriFieldTypeString, alias: LOCATION_NO, editable: true, nullable: true, length: 400, defaultValue: null, modelName: LOCATION_NO )
• LOCATION_SYSTEM ( type: esriFieldTypeString, alias: LOCATION_SYSTEM, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION_SYSTEM )
• LOCATION_TYPE ( type: esriFieldTypeString, alias: LOCATION_TYPE, editable: true, nullable: true, length: 400, defaultValue: null, modelName: LOCATION_TYPE )
• ROUTE_ROAD_NAME ( type: esriFieldTypeString, alias: ROUTE_ROAD_NAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ROUTE_ROAD_NAME )
• BRIDGE_NUMBER ( type: esriFieldTypeString, alias: BRIDGE_NUMBER, editable: true, nullable: true, length: 800, defaultValue: null, modelName: BRIDGE_NUMBER )
• LOC_FROM ( type: esriFieldTypeDouble, alias: LOC_FROM, editable: true, nullable: true, defaultValue: null, modelName: LOC_FROM )
• LOC_TO ( type: esriFieldTypeDouble, alias: LOC_TO, editable: true, nullable: true, defaultValue: null, modelName: LOC_TO )
• PROJ_LENGTH ( type: esriFieldTypeDouble, alias: PROJ_LENGTH, editable: true, nullable: true, defaultValue: null, modelName: PROJ_LENGTH )
• FUND_FEDERAL ( type: esriFieldTypeDouble, alias: FUND_FEDERAL, editable: true, nullable: true, defaultValue: null, modelName: FUND_FEDERAL )
• fundType_state ( type: esriFieldTypeDouble, alias: fundType_state, editable: true, nullable: true, defaultValue: null, modelName: fundType_state )
• fundType_other ( type: esriFieldTypeDouble, alias: fundType_other, editable: true, nullable: true, defaultValue: null, modelName: fundType_other )
• fundType_advfed ( type: esriFieldTypeDouble, alias: fundType_advfed, editable: true, nullable: true, defaultValue: null, modelName: fundType_advfed )
• fundType_total ( type: esriFieldTypeDouble, alias: fundType_total, editable: true, nullable: true, defaultValue: null, modelName: fundType_total )
• fundType ( type: esriFieldTypeString, alias: fundType, editable: true, nullable: true, length: 100, defaultValue: null, modelName: fundType )
• fiscalYear ( type: esriFieldTypeString, alias: fiscalYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: fiscalYear )
• fundPhase ( type: esriFieldTypeDouble, alias: fundPhase, editable: true, nullable: true, defaultValue: null, modelName: fundPhase )
• customFieldName_letDate ( type: esriFieldTypeString, alias: customFieldName_letDate, editable: true, nullable: true, length: 7, defaultValue: null, modelName: customFieldName_letDate )
• CONTACT_TYPE ( type: esriFieldTypeString, alias: CONTACT_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONTACT_TYPE )
• CONTACT_FIRST_NAME ( type: esriFieldTypeString, alias: CONTACT_FIRST_NAME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CONTACT_FIRST_NAME )
• CONTACT_LAST_NAME ( type: esriFieldTypeString, alias: CONTACT_LAST_NAME, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CONTACT_LAST_NAME )
• CONTACT_PHONE ( type: esriFieldTypeString, alias: CONTACT_PHONE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONTACT_PHONE )
• CONTACT_EMAIL ( type: esriFieldTypeString, alias: CONTACT_EMAIL, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CONTACT_EMAIL )
• CONTACT_ORGANIZATION ( type: esriFieldTypeString, alias: CONTACT_ORGANIZATION, editable: true, nullable: true, length: 200, defaultValue: null, modelName: CONTACT_ORGANIZATION )
• idType ( type: esriFieldTypeString, alias: idType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: idType )
• ID_VALUE ( type: esriFieldTypeString, alias: ID_VALUE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID_VALUE )
• FMIS_ID ( type: esriFieldTypeString, alias: FMIS_ID, editable: true, nullable: true, length: 7, defaultValue: null, modelName: FMIS_ID )
• QUESTION_CATEGORY ( type: esriFieldTypeString, alias: QUESTION_CATEGORY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: QUESTION_CATEGORY )
• QUESTION_TEXT ( type: esriFieldTypeString, alias: QUESTION_TEXT, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: QUESTION_TEXT )
• ANSWER ( type: esriFieldTypeString, alias: ANSWER, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ANSWER )

Templates:

• Name: ARCPLN.ESTIP_PROJECTS_TBL
  Description:
  Prototype:
  QUESTION_TEXT: null
  ANSWER: null
  PLAN_NAME: null
  PLAN_FULL_NAME: null
  PLAN_OWNER: null
  PLAN_CYCLE_FULL_NAME: null
  START_YEAR: null
  END_YEAR: null
  PLAN_REVISION: null
  REVISION_TYPE: null
  REVISION_NOTES: null
  APPROVAL_TYPE: null
  APPROVAL_DATE: null
  RANK_NO: null
  id: null
  projectType: null
  LEAD_AGENCY: null
  DESCRIPTION: null
  COUNTY: null
  MUNICIPALITY: null
  CHANGE_REASON: null
  customFieldName_projSuffix: null
  LOCATION_NO: null
  LOCATION_SYSTEM: null
  LOCATION_TYPE: null
  ROUTE_ROAD_NAME: null
  BRIDGE_NUMBER: null
  LOC_FROM: null
  LOC_TO: null
  PROJ_LENGTH: null
  FUND_FEDERAL: null
  fundType_state: null
  fundType_other: null
  fundType_advfed: null
  fundType_total: null
  fundType: null
  fiscalYear: null
  fundPhase: null
  customFieldName_letDate: null
  CONTACT_TYPE: null
  CONTACT_FIRST_NAME: null
  CONTACT_LAST_NAME: null
  CONTACT_PHONE: null
  CONTACT_EMAIL: null
  CONTACT_ORGANIZATION: null
  idType: null
  ID_VALUE: null
  FMIS_ID: null
  QUESTION_CATEGORY: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata