{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [{ "keyField": "legacyid", "role": "esriRelRoleDestination", "composite": false, "name": "oroville.sde.RSignPoles", "relatedTableId": 10, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }], "indexes": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.7.0", "isDataArchived": false, "id": 18, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithDistance": true, "supportsQueryWithCacheHint": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "capabilities": "Query,Map,Data", "hasLastEditTime": false, "supportsExceedsLimitStatistics": true, "standardMaxRecordCount": 32000, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "tileMaxRecordCount": 2000, "currentVersion": 12.1, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "Street Signs", "displayField": "Sign_Code", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "id", "alias": "ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "classification", "alias": "Classification", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "sign_code", "length": 20, "alias": "Sign_Code", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sign_direction", "length": 5, "alias": "Sign_Direction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sheeting_material", "length": 10, "alias": "Sign Sheeting Material", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sheeting_size", "length": 15, "alias": "Sign Sheeting Size", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "sign_quality", "length": 10, "alias": "Sign Quality", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "comments", "length": 50, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "id2", "alias": "ID2", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "assetid", "length": 30, "alias": "AssetID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "legacyid", "length": 30, "alias": "LegacyID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "location", "length": 100, "alias": "Location", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "warrantydate", "length": 8, "alias": "WarrantyDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "installdate", "length": 8, "alias": "InstallDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "condition", "length": 30, "alias": "Condition", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "conditiondate", "length": 8, "alias": "ConditionDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "bollard_id", "alias": "Bollard_ID", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "mutcd_image", "length": 200, "alias": "Image", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "picture", "length": 100, "alias": "Picture", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": null }