{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 5, "name": "GisSurfaceProperty HPMS", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DataClassCode", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DataClassCode", "type": "esriFieldTypeString", "alias": "DataClassCode", "length": 1, "domain": null }, { "name": "Highway", "type": "esriFieldTypeString", "alias": "Highway", "length": 6, "domain": null }, { "name": "Mileage", "type": "esriFieldTypeDouble", "alias": "Mileage", "domain": null }, { "name": "GradingProjectNbr", "type": "esriFieldTypeString", "alias": "GradingProjectNbr", "length": 100, "domain": null }, { "name": "GradingYear", "type": "esriFieldTypeString", "alias": "GradingYear", "length": 4, "domain": null }, { "name": "SurfacingProjectNbr", "type": "esriFieldTypeString", "alias": "SurfacingProjectNbr", "length": 100, "domain": null }, { "name": "SurfacingYear", "type": "esriFieldTypeString", "alias": "SurfacingYear", "length": 4, "domain": null }, { "name": "ResurfacingProjectNbr", "type": "esriFieldTypeString", "alias": "ResurfacingProjectNbr", "length": 100, "domain": null }, { "name": "ResurfacingYear", "type": "esriFieldTypeString", "alias": "ResurfacingYear", "length": 4, "domain": null }, { "name": "SurfaceTypeCode", "type": "esriFieldTypeString", "alias": "SurfaceTypeCode", "length": 10, "domain": null }, { "name": "SurfaceWidthNbr", "type": "esriFieldTypeSmallInteger", "alias": "SurfaceWidthNbr", "domain": null }, { "name": "SurfaceThicknessNbr", "type": "esriFieldTypeSingle", "alias": "SurfaceThicknessNbr", "domain": null }, { "name": "PrimaryShoulderTypeCode", "type": "esriFieldTypeString", "alias": "PrimaryShoulderTypeCode", "length": 15, "domain": null }, { "name": "PrimaryShoulderTypeDesc", "type": "esriFieldTypeString", "alias": "PrimaryShoulderTypeDesc", "length": 250, "domain": null }, { "name": "PrimaryLeftShoulderWidthNbr", "type": "esriFieldTypeSmallInteger", "alias": "PrimaryLeftShoulderWidthNbr", "domain": null }, { "name": "PrimaryRightShoulderWidthNbr", "type": "esriFieldTypeSmallInteger", "alias": "PrimaryRightShoulderWidthNbr", "domain": null }, { "name": "CurbGutterInd", "type": "esriFieldTypeSmallInteger", "alias": "CurbGutterInd", "domain": null }, { "name": "SlopedFlattenedCode", "type": "esriFieldTypeString", "alias": "SlopedFlattenedCode", "length": 15, "domain": null }, { "name": "SlopedFlattenedDesc", "type": "esriFieldTypeString", "alias": "SlopedFlattenedDesc", "length": 250, "domain": null }, { "name": "LeftInslopeRateNbr", "type": "esriFieldTypeSmallInteger", "alias": "LeftInslopeRateNbr", "domain": null }, { "name": "RightInslopeRateNbr", "type": "esriFieldTypeSmallInteger", "alias": "RightInslopeRateNbr", "domain": null }, { "name": "SecondaryShoulderTypeCode", "type": "esriFieldTypeString", "alias": "SecondaryShoulderTypeCode", "length": 15, "domain": null }, { "name": "SecondaryShoulderTypeDesc", "type": "esriFieldTypeString", "alias": "SecondaryShoulderTypeDesc", "length": 250, "domain": null }, { "name": "SecondaryLeftShoulderWidthNbr", "type": "esriFieldTypeSmallInteger", "alias": "SecondaryLeftShoulderWidthNbr", "domain": null }, { "name": "SecondaryRightShoulderWidthNbr", "type": "esriFieldTypeSmallInteger", "alias": "SecondaryRightShoulderWidthNbr", "domain": null }, { "name": "GradingPCN", "type": "esriFieldTypeString", "alias": "GradingPCN", "length": 4, "domain": null }, { "name": "SurfacingPCN", "type": "esriFieldTypeString", "alias": "SurfacingPCN", "length": 4, "domain": null }, { "name": "SecondPreviousResurfacingProjec", "type": "esriFieldTypeString", "alias": "SecondPreviousResurfacingProjectNbr", "length": 100, "domain": null }, { "name": "SecondPreviousResurfacingPCN", "type": "esriFieldTypeString", "alias": "SecondPreviousResurfacingPCN", "length": 4, "domain": null }, { "name": "FirstPreviousResurfacingProject", "type": "esriFieldTypeString", "alias": "FirstPreviousResurfacingProjectNbr", "length": 100, "domain": null }, { "name": "FirstPreviousResurfacingPCN", "type": "esriFieldTypeString", "alias": "FirstPreviousResurfacingPCN", "length": 4, "domain": null }, { "name": "ResurfacingPCN", "type": "esriFieldTypeString", "alias": "ResurfacingPCN", "length": 4, "domain": null }, { "name": "DrivingSurfaceWidthNbr", "type": "esriFieldTypeSmallInteger", "alias": "DrivingSurfaceWidthNbr", "domain": null }, { "name": "DrivingSurfaceLeftShoulderWidth", "type": "esriFieldTypeSmallInteger", "alias": "DrivingSurfaceLeftShoulderWidthNbr", "domain": null }, { "name": "DrivingSurfaceRightShoulderWidt", "type": "esriFieldTypeSmallInteger", "alias": "DrivingSurfaceRightShoulderWidthNbr", "domain": null }, { "name": "DrivingSurfaceLeftShoulderTypeC", "type": "esriFieldTypeString", "alias": "DrivingSurfaceLeftShoulderTypeCode", "length": 15, "domain": null }, { "name": "DrivingSurfaceLeftShoulderTypeD", "type": "esriFieldTypeString", "alias": "DrivingSurfaceLeftShoulderTypeDesc", "length": 250, "domain": null }, { "name": "DrivingSurfaceRightShoulderType", "type": "esriFieldTypeString", "alias": "DrivingSurfaceRightShoulderTypeCode", "length": 15, "domain": null } ], "indexes": [ { "name": "R1344_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "ea68e42afa9e47cb8840cb7d4572b7cb" }