Name: TIP (TABLE)

Display Field: SORT_TEXT

Type: Table

Geometry Type: N/A

Description: Projects in NCTCOG's TIP databases in tabular form, including all fields. Includes all tracked projects, including but not limited to non-mappable projects that cannot be represented in the point, line, and polygon layers in this service. See www.nctcog.org/trans/funds/tip for more information.

Service Item Id: b95e341b00bd4920962585159fd8fc27

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:

• SORT_CODE ( type: esriFieldTypeDouble, alias: SORT_CODE, editable: false, nullable: true, defaultValue: null, modelName: SORT_CODE )
• SHAPEID ( type: esriFieldTypeDouble, alias: SHAPEID, editable: false, nullable: true, defaultValue: null, modelName: SHAPEID )
• SORT_TEXT ( type: esriFieldTypeString, alias: TIP Code, editable: false, nullable: true, length: 50, defaultValue: null, modelName: SORT_TEXT )
• CITY ( type: esriFieldTypeString, alias: City, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CITY )
• CITY2 ( type: esriFieldTypeString, alias: CITY2, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CITY2 )
• CITY3 ( type: esriFieldTypeString, alias: CITY3, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CITY3 )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: false, nullable: true, length: 50, defaultValue: null, modelName: COUNTY )
• COUNTY2 ( type: esriFieldTypeString, alias: COUNTY2, editable: false, nullable: true, length: 50, defaultValue: null, modelName: COUNTY2 )
• PROJ_TYPE ( type: esriFieldTypeString, alias: Project Type, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PROJ_TYPE )
• AGENCY ( type: esriFieldTypeString, alias: Implementing Agency, editable: false, nullable: true, length: 50, defaultValue: null, modelName: AGENCY )
• AGENCY2 ( type: esriFieldTypeString, alias: AGENCY2, editable: false, nullable: true, length: 50, defaultValue: null, modelName: AGENCY2 )
• TIP_YEAR ( type: esriFieldTypeDouble, alias: Year of Implementation, editable: false, nullable: true, defaultValue: null, modelName: TIP_YEAR )
• TOTAL ( type: esriFieldTypeDouble, alias: TOTAL, editable: false, nullable: true, defaultValue: null, modelName: TOTAL )
• PROJ_LOC ( type: esriFieldTypeString, alias: PROJ_LOC, editable: false, nullable: true, length: 255, defaultValue: null, modelName: PROJ_LOC )
• PROJ_FROM ( type: esriFieldTypeString, alias: PROJ_FROM, editable: false, nullable: true, length: 255, defaultValue: null, modelName: PROJ_FROM )
• PROJ_TO ( type: esriFieldTypeString, alias: PROJ_TO, editable: false, nullable: true, length: 255, defaultValue: null, modelName: PROJ_TO )
• TIPINS_LOC ( type: esriFieldTypeString, alias: Street / Name, editable: false, nullable: true, length: 255, defaultValue: null, modelName: TIPINS_LOC )
• MAST_CODE ( type: esriFieldTypeDouble, alias: MAST_CODE, editable: false, nullable: true, defaultValue: null, modelName: MAST_CODE )
• MAST_LOC ( type: esriFieldTypeString, alias: MAST_LOC, editable: false, nullable: true, length: 255, defaultValue: null, modelName: MAST_LOC )
• MAST_CITY ( type: esriFieldTypeString, alias: MAST_CITY, editable: false, nullable: true, length: 50, defaultValue: null, modelName: MAST_CITY )
• MAST_CITY2 ( type: esriFieldTypeString, alias: MAST_CITY2, editable: false, nullable: true, length: 50, defaultValue: null, modelName: MAST_CITY2 )
• MAST_CITY3 ( type: esriFieldTypeString, alias: MAST_CITY3, editable: false, nullable: true, length: 50, defaultValue: null, modelName: MAST_CITY3 )
• MAST_CNTY ( type: esriFieldTypeString, alias: MAST_CNTY, editable: false, nullable: true, length: 50, defaultValue: null, modelName: MAST_CNTY )
• MAST_CNTY2 ( type: esriFieldTypeString, alias: MAST_CNTY2, editable: false, nullable: true, length: 50, defaultValue: null, modelName: MAST_CNTY2 )
• PROJ_CODE ( type: esriFieldTypeString, alias: PROJ_CODE, editable: false, nullable: true, length: 50, defaultValue: null, modelName: PROJ_CODE )
• PROJ_DESC ( type: esriFieldTypeString, alias: Project Description, editable: false, nullable: true, length: 255, defaultValue: null, modelName: PROJ_DESC )
• CSJS ( type: esriFieldTypeString, alias: CSJS, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CSJS )
• ComputedTotal ( type: esriFieldTypeDouble, alias: Total Project Cost, editable: false, nullable: true, defaultValue: null, modelName: ComputedTotal )
• TIP ( type: esriFieldTypeDouble, alias: TIP, editable: false, nullable: true, defaultValue: null, modelName: TIP )
• MTPROADWAY ( type: esriFieldTypeInteger, alias: MTPROADWAY, editable: false, nullable: true, defaultValue: null, modelName: MTPROADWAY )

Templates:

• Name: TIP (TABLE)
  Description:
  Prototype:
  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

Child Resources:   Field Groups   Contingent Values

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