{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "planref", "role": "esriRelRoleDestination", "composite": false, "name": "BaseMapPrd_SDE_EMSPRPOLY", "relatedTableId": 12, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.3.0", "isDataArchived": false, "id": 17, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "DBO_Catalog_Planref_View", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "sheetcount": null, "notes": null, "planrefp": null, "bmelev": null, "type": null, "northing": null, "division": null, "path": null, "subprojectnumber": null, "warrantyperiod": null, "tag": null, "drawingdesigner": null, "apn": null, "tagp": null, "projectname": null, "easting": null, "sht_type": null, "update_date": null, "filename": null, "asbuiltcertdate": null, "twnrngsec": null, "siteplan": null, "add_date": null, "vendorout": null, "cityclerkarchive": null, "planref": null, "scale": null, "cadapprovedate": null, "linkfield": null, "benchmarkid": null, "verticaldatum": null, "scandate": null, "warrantydate": null, "sheet": null, "projectnumberp": null, "department": null, "reviewapprovedate": null, "projectid": null, "projectnumber": null, "address": null, "rotation": null, "vendorin": null, "projectidp": null, "engapprovedate": null, "prpolydate": null, "cit_st_zip": null, "typep": null, "imglink": null, "planreviewer": null, "add_datep": null, "category": null, "username": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "DBO_Catalog_Planref_View", "displayField": "filename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "planref", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planref", "length": 16, "alias": "PlanRef", "type": "esriFieldTypeString" }, { "modelName": "projectnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectnumber", "length": 50, "alias": "ProjectNumber", "type": "esriFieldTypeString" }, { "modelName": "projectid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectid", "alias": "ProjectID", "type": "esriFieldTypeInteger" }, { "modelName": "sht_type", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LU_SheetType", "description": "Description", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Aerial Photo" }, { "code": "C", "name": "Cover" }, { "code": "D", "name": "Details" }, { "code": "E", "name": "Elevations" }, { "code": "F", "name": "Profile" }, { "code": "I", "name": "Index Map" }, { "code": "L", "name": "Plan & Profile" }, { "code": "N", "name": "Notes" }, { "code": "P", "name": "Plan" }, { "code": "Q", "name": "Quanity" }, { "code": "S", "name": "Schedules" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sht_type", "length": 50, "alias": "Sht_Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "type", "domain": { "name": "LU_PlanType_1", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Architectural" }, { "code": "ALM", "name": "Fire Alarm" }, { "code": "B", "name": "Bridge" }, { "code": "BS", "name": "Booster Site" }, { "code": "C", "name": "Canal" }, { "code": "CIV", "name": "Civil" }, { "code": "COV", "name": "Cover Sheets" }, { "code": "D", "name": "Drainage" }, { "code": "E", "name": "Electric" }, { "code": "F", "name": "Final Plat" }, { "code": "FI", "name": "Fiber Conduit" }, { "code": "FIRE", "name": "Fire Protection" }, { "code": "FUR", "name": "Furnishings" }, { "code": "G", "name": "Grading" }, { "code": "H", "name": "Street Light" }, { "code": "I", "name": "Irrigation" }, { "code": "INT", "name": "Interiors" }, { "code": "J", "name": "Plumbing" }, { "code": "K", "name": "Mechanical" }, { "code": "L", "name": "Landscaping" }, { "code": "LS", "name": "Sewage Lift Station" }, { "code": "M", "name": "Re-plat, Amended" }, { "code": "MT", "name": "Meter" }, { "code": "N", "name": "Gas" }, { "code": "NPW", "name": "Non-Potable Water" }, { "code": "P", "name": "Paving" }, { "code": "P1", "name": "SLID" }, { "code": "P2", "name": "MIDS" }, { "code": "P3", "name": "Minor Lands" }, { "code": "PD", "name": "Permitted Design Plans" }, { "code": "PRV", "name": "Pressure Reducing Valve (PRV)" }, { "code": "Q", "name": "Structural" }, { "code": "R", "name": "Reuse" }, { "code": "RV", "name": "Reservoir" }, { "code": "S", "name": "Sewer" }, { "code": "SDS", "name": "Sewer Diversion Structure" }, { "code": "T", "name": "Traffic Control" }, { "code": "U", "name": "Water Reclamation Plant" }, { "code": "V", "name": "Plat, ALTA Survey, Map of Dedication" }, { "code": "W", "name": "Water" }, { "code": "WRF", "name": "Water Reclamation Facility" }, { "code": "WS", "name": "Well Site" }, { "code": "WTP", "name": "Water Treatment Plant" }, { "code": "X", "name": "Uncategorized" }, { "code": "Y", "name": "Miscellaneous" }, { "code": "Z", "name": "Signing and Striping" } ] }, "name": "type", "alias": "Type" }, { "modelName": "category", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "category", "length": 50, "alias": "Category", "type": "esriFieldTypeString" }, { "modelName": "sheet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sheet", "length": 50, "alias": "Sheet", "type": "esriFieldTypeString" }, { "modelName": "filename", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "filename", "length": 50, "alias": "Filename", "type": "esriFieldTypeString" }, { "modelName": "path", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "path", "length": 225, "alias": "Path", "type": "esriFieldTypeString" }, { "modelName": "rotation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rotation", "alias": "Rotation", "type": "esriFieldTypeInteger" }, { "modelName": "scale", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scale", "alias": "Scale", "type": "esriFieldTypeDouble" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 255, "alias": "Notes", "type": "esriFieldTypeString" }, { "modelName": "add_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "add_date", "length": 29, "alias": "Add_Date", "type": "esriFieldTypeDate" }, { "modelName": "tag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tag", "alias": "Tag", "type": "esriFieldTypeInteger" }, { "modelName": "linkfield", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "linkfield", "length": 255, "alias": "LinkField", "type": "esriFieldTypeString" }, { "modelName": "imglink", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imglink", "length": 200, "alias": "IMGLINK", "type": "esriFieldTypeString" }, { "modelName": "planrefp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planrefp", "length": 16, "alias": "PlanrefP", "type": "esriFieldTypeString" }, { "modelName": "projectnumberp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectnumberp", "length": 50, "alias": "ProjectNumberP", "type": "esriFieldTypeString" }, { "modelName": "projectidp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectidp", "alias": "ProjectIDP", "type": "esriFieldTypeInteger" }, { "modelName": "projectname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectname", "length": 254, "alias": "ProjectName", "type": "esriFieldTypeString" }, { "modelName": "subprojectnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subprojectnumber", "alias": "SubProjectNumber", "type": "esriFieldTypeInteger" }, { "modelName": "typep", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "typep", "length": 50, "alias": "TypeP", "type": "esriFieldTypeString" }, { "modelName": "warrantydate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "warrantydate", "length": 29, "alias": "WarrantyDate", "type": "esriFieldTypeDate" }, { "modelName": "warrantyperiod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "warrantyperiod", "length": 50, "alias": "WarrantyPeriod", "type": "esriFieldTypeString" }, { "modelName": "sheetcount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sheetcount", "alias": "SheetCount", "type": "esriFieldTypeInteger" }, { "modelName": "siteplan", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteplan", "length": 50, "alias": "SitePlan", "type": "esriFieldTypeString" }, { "modelName": "department", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "department", "length": 50, "alias": "Department", "type": "esriFieldTypeString" }, { "modelName": "division", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "division", "length": 50, "alias": "Division", "type": "esriFieldTypeString" }, { "modelName": "planreviewer", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planreviewer", "length": 50, "alias": "PlanReviewer", "type": "esriFieldTypeString" }, { "modelName": "reviewapprovedate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "reviewapprovedate", "length": 29, "alias": "ReviewApproveDate", "type": "esriFieldTypeDate" }, { "modelName": "asbuiltcertdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "asbuiltcertdate", "length": 29, "alias": "AsBuiltCertDate", "type": "esriFieldTypeDate" }, { "modelName": "engapprovedate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "engapprovedate", "length": 29, "alias": "EngApproveDate", "type": "esriFieldTypeDate" }, { "modelName": "drawingdesigner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "drawingdesigner", "length": 255, "alias": "DrawingDesigner", "type": "esriFieldTypeString" }, { "modelName": "twnrngsec", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "twnrngsec", "length": 50, "alias": "TwnRngSec", "type": "esriFieldTypeString" }, { "modelName": "cadapprovedate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "cadapprovedate", "length": 29, "alias": "CADApproveDate", "type": "esriFieldTypeDate" }, { "modelName": "cityclerkarchive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "cityclerkarchive", "length": 29, "alias": "CityClerkArchive", "type": "esriFieldTypeDate" }, { "modelName": "vendorout", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "vendorout", "length": 29, "alias": "VendorOut", "type": "esriFieldTypeDate" }, { "modelName": "vendorin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "vendorin", "length": 29, "alias": "VendorIn", "type": "esriFieldTypeDate" }, { "modelName": "prpolydate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "prpolydate", "length": 29, "alias": "PRPolyDate", "type": "esriFieldTypeDate" }, { "modelName": "verticaldatum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "verticaldatum", "length": 50, "alias": "VerticalDatum", "type": "esriFieldTypeString" }, { "modelName": "benchmarkid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "benchmarkid", "length": 50, "alias": "BenchMarkID", "type": "esriFieldTypeString" }, { "modelName": "bmelev", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bmelev", "alias": "BMElev", "type": "esriFieldTypeDouble" }, { "modelName": "easting", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "easting", "alias": "Easting", "type": "esriFieldTypeDouble" }, { "modelName": "northing", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "northing", "alias": "Northing", "type": "esriFieldTypeDouble" }, { "modelName": "username", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "username", "length": 50, "alias": "UserName", "type": "esriFieldTypeString" }, { "modelName": "add_datep", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "add_datep", "length": 29, "alias": "Add_DateP", "type": "esriFieldTypeDate" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 50, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "cit_st_zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cit_st_zip", "length": 50, "alias": "Cit_ST_ZIP", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 50, "alias": "APN", "type": "esriFieldTypeString" }, { "modelName": "scandate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "scandate", "length": 255, "alias": "ScanDate", "type": "esriFieldTypeString" }, { "modelName": "update_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "update_date", "length": 255, "alias": "Update_Date", "type": "esriFieldTypeString" }, { "modelName": "tagp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tagp", "alias": "TagP", "type": "esriFieldTypeInteger" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g3869planref", "isUnique": false, "description": "", "fields": "planref", "isAscending": true }, { "name": "r1553_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "6561b9e60a1e41ba8310fccba052321f", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }