{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "SmallBridge", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "bridgeName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "ProjectID" }, { "name": "StepID", "type": "esriFieldTypeString", "alias": "StepID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StepID" }, { "name": "SmallBridgeApprovedBy", "type": "esriFieldTypeString", "alias": "SmallBridgeApprovedBy", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SmallBridgeApprovedBy" }, { "name": "SmallBridgeDateApproved", "type": "esriFieldTypeDate", "alias": "SmallBridgeDateApproved", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SmallBridgeDateApproved" }, { "name": "IsComplete", "type": "esriFieldTypeSmallInteger", "alias": "IsComplete", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsComplete" }, { "name": "bridgeName", "type": "esriFieldTypeString", "alias": "bridgeName", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "bridgeName" }, { "name": "bridgeNumber", "type": "esriFieldTypeString", "alias": "bridgeNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "bridgeNumber" }, { "name": "BIN", "type": "esriFieldTypeString", "alias": "BIN", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BIN" }, { "name": "facilityCarried", "type": "esriFieldTypeString", "alias": "facilityCarried", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "facilityCarried" }, { "name": "FeatureIntersected", "type": "esriFieldTypeString", "alias": "FeatureIntersected", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FeatureIntersected" }, { "name": "DeckCondition", "type": "esriFieldTypeString", "alias": "inspectionReport58", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "inspectionReport58" }, { "name": "substrucutreCondtion", "type": "esriFieldTypeString", "alias": "inspectionReport59", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "inspectionReport59" }, { "name": "superstructureCondition", "type": "esriFieldTypeString", "alias": "inspectionReport60", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "inspectionReport60" }, { "name": "CulvertCondition", "type": "esriFieldTypeString", "alias": "inspectionReport62", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "inspectionReport62" }, { "name": "LCCapacity", "type": "esriFieldTypeString", "alias": "LCCapacity", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LCCapacity" }, { "name": "bridgeMeetReq", "type": "esriFieldTypeSmallInteger", "alias": "bridgeMeetReq", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "bridgeMeetReq" }, { "name": "bridgePublicWay", "type": "esriFieldTypeSmallInteger", "alias": "bridgePublicWay", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "bridgePublicWay" }, { "name": "bridgeLCCapacityPosted", "type": "esriFieldTypeSmallInteger", "alias": "bridgeLCCapacityPosted", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "bridgeLCCapacityPosted" }, { "name": "grantRequest", "type": "esriFieldTypeString", "alias": "grantRequest", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "grantRequest" }, { "name": "chapter90Apportionment", "type": "esriFieldTypeString", "alias": "chapter90Apportionment", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "chapter90Apportionment" }, { "name": "projCost", "type": "esriFieldTypeString", "alias": "projCost", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "projCost" }, { "name": "fundingSource", "type": "esriFieldTypeString", "alias": "fundingSource", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "fundingSource" }, { "name": "reasonForApp", "type": "esriFieldTypeString", "alias": "reasonForApp", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "reasonForApp" }, { "name": "proposedProjType", "type": "esriFieldTypeString", "alias": "proposedProjType", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "proposedProjType" }, { "name": "scope", "type": "esriFieldTypeString", "alias": "scope", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "scope" }, { "name": "designApproval", "type": "esriFieldTypeSmallInteger", "alias": "designApproval", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "designApproval" }, { "name": "timeReqForDesignService", "type": "esriFieldTypeString", "alias": "timeReqForDesignService", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "timeReqForDesignService" }, { "name": "nearestDetourRdName", "type": "esriFieldTypeString", "alias": "nearestDetourRdName", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "nearestDetourRdName" }, { "name": "lengthSuitableDetour", "type": "esriFieldTypeSmallInteger", "alias": "lengthSuitableDetour", "domain": { "type": "codedValue", "name": "dLengthSuitableDetour", "description": "Length of Suitable Detour", "codedValues": [ { "name": "0 - 1 Mile", "code": 1 }, { "name": "2 Miles", "code": 2 }, { "name": "3 Miles", "code": 3 }, { "name": "4 Miles", "code": 4 }, { "name": "5 Miles", "code": 5 }, { "name": "6 Miles", "code": 6 }, { "name": "7 Miles", "code": 7 }, { "name": "8 Miles", "code": 8 }, { "name": "9 Miles", "code": 9 }, { "name": "10+ Miles", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "lengthSuitableDetour" }, { "name": "roadwayUsed", "type": "esriFieldTypeSmallInteger", "alias": "roadwayUsed", "domain": { "type": "codedValue", "name": "dRoadwayUsed", "description": "Roadway Used", "codedValues": [ { "name": "Semi-annually", "code": 3 }, { "name": "Monthly", "code": 5 }, { "name": "Weekly", "code": 8 }, { "name": "Daily", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "roadwayUsed" }, { "name": "impactLoacalEconomy", "type": "esriFieldTypeSmallInteger", "alias": "impactLoacalEconomy", "domain": { "type": "codedValue", "name": "dImpactLoacalEconomy", "description": "Impact Loacal Economy", "codedValues": [ { "name": "Serves one economy", "code": 4 }, { "name": "Serves a few economies", "code": 7 }, { "name": "Serves many economies", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "impactLoacalEconomy" }, { "name": "essentialServices", "type": "esriFieldTypeSmallInteger", "alias": "essentialServices", "domain": { "type": "codedValue", "name": "dEssentialServices", "description": "Essential Services", "codedValues": [ { "name": "No services", "code": 4 }, { "name": "A Few services", "code": 7 }, { "name": "Many services", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "essentialServices" }, { "name": "districtHQEval", "type": "esriFieldTypeSmallInteger", "alias": "districtHQEval", "domain": { "type": "codedValue", "name": "dDistrictHQEval", "description": "", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "6", "code": 6 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 }, { "name": "9", "code": 9 }, { "name": "10", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "districtHQEval" }, { "name": "BridgeInspectionDate", "type": "esriFieldTypeString", "alias": "BridgeInspectionDate", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BridgeInspectionDate" }, { "name": "StructurallyDeficient", "type": "esriFieldTypeString", "alias": "StructurallyDeficient", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "StructurallyDeficient" }, { "name": "Posted", "type": "esriFieldTypeString", "alias": "Posted", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Posted" } ], "indexes": [ { "name": "R184_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I225ProjectID", "fields": "ProjectID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SmallBridge", "description": "", "prototype": { "attributes": { "StructurallyDeficient": null, "Posted": null, "ProjectID": null, "StepID": null, "SmallBridgeApprovedBy": null, "SmallBridgeDateApproved": null, "IsComplete": null, "bridgeName": null, "bridgeNumber": null, "BIN": null, "facilityCarried": null, "FeatureIntersected": null, "DeckCondition": null, "substrucutreCondtion": null, "superstructureCondition": null, "CulvertCondition": null, "LCCapacity": null, "bridgeMeetReq": null, "bridgePublicWay": null, "bridgeLCCapacityPosted": null, "grantRequest": null, "chapter90Apportionment": null, "projCost": null, "fundingSource": null, "reasonForApp": null, "proposedProjType": null, "scope": null, "designApproval": null, "timeReqForDesignService": null, "nearestDetourRdName": null, "lengthSuitableDetour": null, "roadwayUsed": null, "impactLoacalEconomy": null, "essentialServices": null, "districtHQEval": null, "BridgeInspectionDate": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "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": "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 } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "52a9435a94e84733be7ce94b8d028452" }