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

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata