{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 6, "name": "Parking Lot PASER Scores", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CreationDate", "creatorField": "Creator", "editDateField": "EditDate", "editorField": "Editor" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "ASSET.City_Parking_Lots", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PASER_ParentGUID", "composite": false, "catalogID": "{96FF8AC6-6454-4199-8D7F-856C99EC7F3D}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SurveyDate", "type": "esriFieldTypeDate", "alias": "Survey Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SurveyDate" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "NAME" }, { "name": "Rating", "type": "esriFieldTypeDouble", "alias": "Rating", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Rating" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreationDate" }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Inputed by", "domain": null, "editable": false, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Creator" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": false, "nullable": true, "length": 128, "defaultValue": null, "modelName": "Editor" }, { "name": "SurfaceType", "type": "esriFieldTypeString", "alias": "Surface Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SurfaceType" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aCracks" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aTransverse" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aBlockCracks" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aLongCracks" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aRutting" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aBase" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aPotholes" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aPatches" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "aRaveling" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "cSpalling" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "cFaulting" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "cJoints" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "cCracks" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "cScalePolish" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "cTreatment" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "cPavementIntegrity" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "cReinforcement" }, { "name": "DrainageCondition", "type": "esriFieldTypeString", "alias": "DrainageCondition", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DrainageCondition" }, { "name": "SpotRepair", "type": "esriFieldTypeString", "alias": "Will Spot Repair Raise Condition Rating?", "domain": { "type": "codedValue", "name": "Yes_No", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SpotRepair" }, { "name": "PASER_ParentGUID", "type": "esriFieldTypeGUID", "alias": "PASER_ParentGUID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "PASER_ParentGUID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R196_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_196", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "GDB_9321_PASER_P", "isAscending": true, "isUnique": false, "description": "", "fields": "PASER_ParentGUID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Parking Lot PASER Scores", "description": "", "prototype": { "attributes": { "PASER_ParentGUID": null, "SpotRepair": null, "SurveyDate": null, "NAME": null, "Rating": null, "Comments": null, "DrainageCondition": null, "cReinforcement": 10, "cPavementIntegrity": 10, "cTreatment": 10, "SurfaceType": null, "aCracks": 10, "aTransverse": 10, "aBlockCracks": 10, "aLongCracks": 10, "aRutting": 10, "aBase": 10, "aPotholes": 10, "aPatches": 10, "aRaveling": 10, "cSpalling": 10, "cFaulting": 10, "cJoints": 10, "cCracks": 10, "cScalePolish": 10 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "49e8c22c112042c3a3d2e058b55ffb23" }