{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 7, "name": "Road PASER Scores", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SurveyDate", "type": "esriFieldTypeDate", "alias": "Survey Date", "length": 8, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 60, "domain": null }, { "name": "Rating", "type": "esriFieldTypeDouble", "alias": "Rating", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Inputed by", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "ParentFacilityID", "type": "esriFieldTypeString", "alias": "ParentFacilityID (deprecated)", "length": 20, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PASER_ParentGUID", "type": "esriFieldTypeGUID", "alias": "PASER_ParentGUID", "length": 38, "domain": null }, { "name": "SurfaceType", "type": "esriFieldTypeString", "alias": "Surface Type", "length": 20, "domain": { "type": "codedValue", "name": "SurfaceType", "description": "", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Brick", "code": "Brick" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Mixed", "code": "Mixed" }, { "name": "Block", "code": "Block" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aCracks", "type": "esriFieldTypeSmallInteger", "alias": "A Cracks", "domain": { "type": "codedValue", "name": "aCracks", "description": "Asphalt general cracks", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "8 - Tight (hairline) or sealed", "code": 8 }, { "name": "7 - Open 1/4\"", "code": 7 }, { "name": "6 - Open 1/4\"-1/2\"", "code": 6 }, { "name": "5 - Open > 1/2\", 1st signs of secondary cracking", "code": 5 }, { "name": "2 - Closely spaced with erosion", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aTransverse", "type": "esriFieldTypeSmallInteger", "alias": "A Transverse Cracks", "domain": { "type": "codedValue", "name": "aTransverse", "description": "Asphalt transverse cracks", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "8 - Cracks > 40' apart", "code": 8 }, { "name": "7 - Cracks 10' - 40' apart", "code": 7 }, { "name": "6 - Cracks <10' apart", "code": 6 }, { "name": "4 - Slight erosion at cracks", "code": 4 }, { "name": "3 - Extensive erosion at cracks", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aBlockCracks", "type": "esriFieldTypeSmallInteger", "alias": "A Block Cracking", "domain": { "type": "codedValue", "name": "aBlock", "description": "Asphalt block cracking", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "6 - Blocks 6' - 10' (large, stable)", "code": 6 }, { "name": "5 - Blocks 1' - 5'", "code": 5 }, { "name": "4 - Blocks <1'", "code": 4 }, { "name": "3 - Severe (alligator <25%)", "code": 3 }, { "name": "2 - Alligator cracking >25%", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aLongCracks", "type": "esriFieldTypeSmallInteger", "alias": "A Longitudinal Cracks", "domain": { "type": "codedValue", "name": "aLongitudinal", "description": "Asphalt longitudinal cracking", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "8 - Few, on joints", "code": 8 }, { "name": "5 - Firt signs, at edge", "code": 5 }, { "name": "4 - Wheel-path cracking", "code": 4 }, { "name": "3 - Extensive erosion", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aRutting", "type": "esriFieldTypeSmallInteger", "alias": "A Rutting", "domain": { "type": "codedValue", "name": "aRutting", "description": "Asphalt rutting", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "4 - rutting 1/2\" - 1\" deep", "code": 4 }, { "name": "3 - rutting 1\" - 2\" deep", "code": 3 }, { "name": "2 - rutting > 2\" deep", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aBase", "type": "esriFieldTypeSmallInteger", "alias": "A Base Visible?", "domain": { "type": "codedValue", "name": "aBase", "description": "Asphalt base", "codedValues": [ { "name": "10 - No", "code": 10 }, { "name": "1 - Yes (surface is extensively gone, not just a couple potholes)", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aPotholes", "type": "esriFieldTypeSmallInteger", "alias": "A Potholes", "domain": { "type": "codedValue", "name": "aPotholes", "description": "Asphalt potholes", "codedValues": [ { "name": "3 - Occasional", "code": 3 }, { "name": "2 - Frequent", "code": 2 }, { "name": "10 - None", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aPatches", "type": "esriFieldTypeSmallInteger", "alias": "A Patches", "domain": { "type": "codedValue", "name": "aPatches", "description": "Asphalt patches", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "7 - Few, in excellent condition", "code": 7 }, { "name": "6 - Few, in good condition", "code": 6 }, { "name": "5 - Some, in good condition", "code": 5 }, { "name": "4 - Some, in fair condition", "code": 4 }, { "name": "3 - Some, in poor condition", "code": 3 }, { "name": "2 - Extensive, in poor condition", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aRaveling", "type": "esriFieldTypeSmallInteger", "alias": "A Raveling", "domain": { "type": "codedValue", "name": "aRaveling", "description": "Asphalt raveling", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "7 - None - Little", "code": 7 }, { "name": "6 - Slight", "code": 6 }, { "name": "5 - Moderate", "code": 5 }, { "name": "4 - Severe", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cSpalling", "type": "esriFieldTypeSmallInteger", "alias": "C Spalling (can see aggregate)", "domain": { "type": "codedValue", "name": "cSpalling", "description": "Concrete spalling", "codedValues": [ { "name": "4 - On several slabs, >50% of surface", "code": 4 }, { "name": "5 - First signs in joint/crack", "code": 5 }, { "name": "3 - Most slabs severely spalled", "code": 3 }, { "name": "2 - Extensive, severe", "code": 2 }, { "name": "10 - None", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cFaulting", "type": "esriFieldTypeSmallInteger", "alias": "C Faulting", "domain": { "type": "codedValue", "name": "cFaulting", "description": "Concrete faulting", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "7 - Isolated, minor settlement/heaves", "code": 7 }, { "name": "5 - some, < 1/4\"", "code": 5 }, { "name": "4 - 1/4\" - 1/2\"", "code": 4 }, { "name": "3 - 1/2\" - 1\"", "code": 3 }, { "name": "2 - Extensive, severe settlements/heaves", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cJoints", "type": "esriFieldTypeSmallInteger", "alias": "C Joints", "domain": { "type": "codedValue", "name": "cJoint", "description": "Concrete joints", "codedValues": [ { "name": "10 - No issues", "code": 10 }, { "name": "9 - Joint rehabilitation, excellent condition", "code": 9 }, { "name": "8 - Sealant partial loss, joint in good condition", "code": 8 }, { "name": "7 - Some open", "code": 7 }, { "name": "6 - Tranverse or longitudinal joints open 1/4\"", "code": 6 }, { "name": "4 - Open 1\" on several slabs or buckling has caused blow-up", "code": 4 }, { "name": "3 - Open 1\" on most slabs", "code": 3 }, { "name": "2 - Joints failed (>1\")", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cCracks", "type": "esriFieldTypeSmallInteger", "alias": "C Cracks", "domain": { "type": "codedValue", "name": "cCrack", "description": "Concrete cracks", "codedValues": [ { "name": "10 - No issues", "code": 10 }, { "name": "9 - Slight map cracking (first signs)", "code": 9 }, { "name": "8 - Meander or at manholes, but isolated and well sealed/tight, minor map cracking", "code": 8 }, { "name": "7 - Isolated transverse cracks, some at manholes", "code": 7 }, { "name": "6 - Several at corners (sealed), transverse or meander cracks open 1/4\"", "code": 6 }, { "name": "5 - Cracks at corners -- multiple with broken pieces", "code": 5 }, { "name": "4 - Multiple transverse or meander cracks, corners missing pieces or patches", "code": 4 }, { "name": "3 - D-Cracking evident (patterned cracks parrallel to joint or linear crack)", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cScalePolish", "type": "esriFieldTypeSmallInteger", "alias": "C Scaling/Polishing", "domain": { "type": "codedValue", "name": "cScaling/Polishing", "description": "Concrete scaling and polishing", "codedValues": [ { "name": "10 - None", "code": 10 }, { "name": "9 - A few pop-outs", "code": 9 }, { "name": "8 - Minor pop-outs, first signs of scaling/polishing", "code": 8 }, { "name": "7 - Pop-outs extensive, minor scaling/polishing", "code": 7 }, { "name": "6 - Scaling or polishing across < 25% of surface", "code": 6 }, { "name": "5 - Scaling or polishing across 25% - 50% of surface", "code": 5 }, { "name": "4 - Scaling or polishing across >50% of surface", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cTreatment", "type": "esriFieldTypeSmallInteger", "alias": "C Treatment Condition", "domain": { "type": "codedValue", "name": "cTreatmentCond", "description": "Concrete treatment condition", "codedValues": [ { "name": "10 - No treatments", "code": 10 }, { "name": "9 - Recent concrete overlay", "code": 9 }, { "name": "7 - Full-depth repairs in excellent condition, Pop-outs extensive but sound", "code": 7 }, { "name": "3 - Patches extensive in fair to poor condition", "code": 3 }, { "name": "2 - Parches extensive in failed condition", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cPavementIntegrity", "type": "esriFieldTypeSmallInteger", "alias": "C Pavement Integrity", "domain": { "type": "codedValue", "name": "cPavementIntegrity", "description": "Concrete pavement integrity", "codedValues": [ { "name": "10 - Still in-tact", "code": 10 }, { "name": "1 - Total loss, speeds are restricted, potholes extensive", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cReinforcement", "type": "esriFieldTypeSmallInteger", "alias": "C Reinforcement (rusting visible)", "domain": { "type": "codedValue", "name": "cReinforcement", "description": "Concrete reinforcement issues", "codedValues": [ { "name": "10 - No issues", "code": 10 }, { "name": "6 - first signs of cracking", "code": 6 }, { "name": "5 - has caused spalling", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DrainageCondition", "type": "esriFieldTypeString", "alias": "DrainageCondition", "length": 20, "domain": { "type": "codedValue", "name": "RoadsideDrainageCondition", "description": "", "codedValues": [ { "name": "Adequate", "code": "Adequate" }, { "name": "Needs Cleaned", "code": "Needs Cleaned" }, { "name": "Needs Additional Capacity", "code": "Needs Capacity" }, { "name": "Needs Established", "code": "Needs Established" }, { "name": "Needs Maintenance (berm)", "code": "Needs Maintenance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SpotRepair", "type": "esriFieldTypeString", "alias": "Will Spot Repair Raise Condition Rating?", "length": 10, "domain": { "type": "codedValue", "name": "Yes_No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R51_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_51", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_51", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G85ParentFacilit", "fields": "ParentFacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_85_PASER_Par", "fields": "PASER_ParentGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "STREETS.Road_Segments", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "PASER_ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0753D662-5D47-4CCD-90C4-1DAF25D8AA92}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "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": "9cbb83575943476397b7ffdd7c712cc0" }