Name: Projects with null location

Display Field: AGENCY_NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d9d40ffc2534462a8e9859da3d093245

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• PROJ_ID ( type: esriFieldTypeInteger, alias: PROJ_ID, editable: true, nullable: true, defaultValue: null, modelName: PROJ_ID )
• PROJECT_ID ( type: esriFieldTypeString, alias: PROJECT_ID, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PROJECT_ID )
• PROJECT_STATUS ( type: esriFieldTypeString, alias: PROJECT_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PROJECT_STATUS )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COUNTY )
• PROJECT_TYPE ( type: esriFieldTypeString, alias: PROJECT_TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PROJECT_TYPE )
• FACILITY_TYPE ( type: esriFieldTypeString, alias: FACILITY_TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FACILITY_TYPE )
• PROJECT_PURPOSE ( type: esriFieldTypeString, alias: PROJECT_PURPOSE, editable: true, nullable: true, length: 512, defaultValue: null, modelName: PROJECT_PURPOSE )
• CALL_FOR_PROJECTS_PRIORITY ( type: esriFieldTypeDouble, alias: CALL_FOR_PROJECTS_PRIORITY, editable: true, nullable: true, defaultValue: null, modelName: CALL_FOR_PROJECTS_PRIORITY )
• AGENCY_NAME ( type: esriFieldTypeString, alias: AGENCY_NAME, editable: true, nullable: true, length: 250, defaultValue: null, modelName: AGENCY_NAME )
• DOT_UNIT ( type: esriFieldTypeString, alias: DOT_UNIT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DOT_UNIT )
• DOT_STIP_ID ( type: esriFieldTypeString, alias: DOT_STIP_ID, editable: true, nullable: true, length: 256, defaultValue: null, modelName: DOT_STIP_ID )
• FLMA_ACCESSED ( type: esriFieldTypeString, alias: FLMA_ACCESSED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLMA_ACCESSED )
• POSTED_ROUTE ( type: esriFieldTypeString, alias: POSTED_ROUTE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: POSTED_ROUTE )
• BMP ( type: esriFieldTypeDouble, alias: BMP, editable: true, nullable: true, defaultValue: null, modelName: BMP )
• EMP ( type: esriFieldTypeDouble, alias: EMP, editable: true, nullable: true, defaultValue: null, modelName: EMP )
• ROUTEID ( type: esriFieldTypeString, alias: ROUTEID, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ROUTEID )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• PDC_APPROVAL_DATE ( type: esriFieldTypeDate, alias: PDC_APPROVAL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PDC_APPROVAL_DATE )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OWNER )
• HQ_IMPROVEMENT_TYPE ( type: esriFieldTypeString, alias: HQ_IMPROVEMENT_TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HQ_IMPROVEMENT_TYPE )
• FLMA ( type: esriFieldTypeString, alias: FLMA, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FLMA )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT_NAME, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROJECT_NAME )
• ENGINEERS_ESTIMATE_RANGE ( type: esriFieldTypeString, alias: ENGINEERS_ESTIMATE_RANGE, editable: true, nullable: false, length: 34, defaultValue: null, modelName: ENGINEERS_ESTIMATE_RANGE )
• AWARD_AMOUNT ( type: esriFieldTypeDouble, alias: AWARD_AMOUNT, editable: true, nullable: true, defaultValue: null, modelName: AWARD_AMOUNT )
• DELPHI_PROJECT_NUMBER ( type: esriFieldTypeString, alias: DELPHI_PROJECT_NUMBER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DELPHI_PROJECT_NUMBER )
• AWARD_DATE ( type: esriFieldTypeDate, alias: AWARD_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AWARD_DATE )
• PSE_DELIVERY_DATE ( type: esriFieldTypeDate, alias: PSE_DELIVERY_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PSE_DELIVERY_DATE )
• NOTICE_TO_PROCEED_DATE ( type: esriFieldTypeDate, alias: NOTICE_TO_PROCEED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NOTICE_TO_PROCEED_DATE )
• NUMBER_OF_BRIDGES_IMPROVED ( type: esriFieldTypeDouble, alias: NUMBER_OF_BRIDGES_IMPROVED, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_BRIDGES_IMPROVED )
• PROJECT_MANAGER ( type: esriFieldTypeString, alias: PROJECT_MANAGER, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROJECT_MANAGER )
• STATE ( type: esriFieldTypeString, alias: STATE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: STATE )
• PROJECT_PHASE ( type: esriFieldTypeString, alias: PROJECT_PHASE, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROJECT_PHASE )
• PRIMARY_PROGRAM ( type: esriFieldTypeString, alias: PRIMARY_PROGRAM, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PRIMARY_PROGRAM )
• PSE_DELIVERY_YEAR ( type: esriFieldTypeString, alias: PSE_DELIVERY_YEAR, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PSE_DELIVERY_YEAR )
• PROJECT_DESCRIPTION ( type: esriFieldTypeString, alias: PROJECT_DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROJECT_DESCRIPTION )
• AWARD_YEAR ( type: esriFieldTypeString, alias: AWARD_YEAR, editable: true, nullable: true, length: 32, defaultValue: null, modelName: AWARD_YEAR )
• CONGRESSIONAL_DISTRICT ( type: esriFieldTypeString, alias: CONGRESSIONAL_DISTRICT, editable: true, nullable: true, length: 32, defaultValue: null, modelName: CONGRESSIONAL_DISTRICT )
• DELIVERY_METHOD ( type: esriFieldTypeString, alias: DELIVERY_METHOD, editable: true, nullable: true, length: 32, defaultValue: null, modelName: DELIVERY_METHOD )
• ADWITH ( type: esriFieldTypeString, alias: ADWITH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADWITH )
• CONSTRUCTION_CONTRACT_NUMBER ( type: esriFieldTypeString, alias: CONSTRUCTION_CONTRACT_NUMBER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONSTRUCTION_CONTRACT_NUMBER )
• CONSTRUCTION_OPERATIONS_ENG ( type: esriFieldTypeString, alias: CONSTRUCTION_OPERATIONS_ENG, editable: true, nullable: true, length: 32, defaultValue: null, modelName: CONSTRUCTION_OPERATIONS_ENG )
• HIGHWAY_DESIGN_MANAGER ( type: esriFieldTypeString, alias: HIGHWAY_DESIGN_MANAGER, editable: true, nullable: true, length: 32, defaultValue: null, modelName: HIGHWAY_DESIGN_MANAGER )
• FLAP ( type: esriFieldTypeString, alias: FLAP, editable: true, nullable: true, length: 32, defaultValue: null, modelName: FLAP )
• END_OF_PREVIOUS_MONTH ( type: esriFieldTypeDate, alias: END_OF_PREVIOUS_MONTH, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_OF_PREVIOUS_MONTH )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: PROJECT_NUMBER, editable: true, nullable: true, length: 88, defaultValue: null, modelName: PROJECT_NUMBER )
• PE ( type: esriFieldTypeDouble, alias: PE, editable: true, nullable: true, defaultValue: null, modelName: PE )
• CE ( type: esriFieldTypeDouble, alias: CE, editable: true, nullable: true, defaultValue: null, modelName: CE )
• PL ( type: esriFieldTypeDouble, alias: PL, editable: true, nullable: true, defaultValue: null, modelName: PL )
• CN ( type: esriFieldTypeDouble, alias: CN, editable: true, nullable: true, defaultValue: null, modelName: CN )
• TOTAL_UDO ( type: esriFieldTypeDouble, alias: TOTAL_UDO, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_UDO )
• TOTAL_EXPENDITURE ( type: esriFieldTypeDouble, alias: TOTAL_EXPENDITURE, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_EXPENDITURE )
• TOTAL ( type: esriFieldTypeDouble, alias: TOTAL, editable: true, nullable: true, defaultValue: null, modelName: TOTAL )
• PROGRAM_FY ( type: esriFieldTypeString, alias: PROGRAM_FY, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROGRAM_FY )
• division_id ( type: esriFieldTypeSmallInteger, alias: division_id, editable: true, nullable: false, defaultValue: null, modelName: division_id )
• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )

Templates:

• Name: Projects with null location
  Description:
  Prototype:
  division_id: 0
  PROJ_ID: null
  PROJECT_ID: null
  PROJECT_STATUS: null
  COUNTY: null
  PROJECT_TYPE: null
  FACILITY_TYPE: null
  PROJECT_PURPOSE: null
  CALL_FOR_PROJECTS_PRIORITY: null
  AGENCY_NAME: null
  DOT_UNIT: null
  DOT_STIP_ID: null
  FLMA_ACCESSED: null
  POSTED_ROUTE: null
  BMP: null
  EMP: null
  ROUTEID: null
  LATITUDE: null
  LONGITUDE: null
  PDC_APPROVAL_DATE: null
  OWNER: null
  HQ_IMPROVEMENT_TYPE: null
  FLMA: null
  PROJECT_NAME: null
  ENGINEERS_ESTIMATE_RANGE:
  AWARD_AMOUNT: null
  DELPHI_PROJECT_NUMBER: null
  AWARD_DATE: null
  PSE_DELIVERY_DATE: null
  NOTICE_TO_PROCEED_DATE: null
  NUMBER_OF_BRIDGES_IMPROVED: null
  PROJECT_MANAGER: null
  STATE: null
  PROJECT_PHASE: null
  PRIMARY_PROGRAM: null
  PSE_DELIVERY_YEAR: null
  PROJECT_DESCRIPTION: null
  AWARD_YEAR: null
  CONGRESSIONAL_DISTRICT: null
  DELIVERY_METHOD: null
  ADWITH: null
  CONSTRUCTION_CONTRACT_NUMBER: null
  CONSTRUCTION_OPERATIONS_ENG: null
  HIGHWAY_DESIGN_MANAGER: null
  FLAP: null
  END_OF_PREVIOUS_MONTH: null
  PROJECT_NUMBER: null
  PE: null
  CE: null
  PL: null
  CN: null
  TOTAL_UDO: null
  TOTAL_EXPENDITURE: null
  TOTAL: null
  PROGRAM_FY: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata