{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "uusd.DBO.structure", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "buildings_eap", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "building_number", "composite": false, "catalogID": "{DB06DC63-9E0D-4C1E-A846-202FEE0C9F5B}" }, { "id": 1, "name": "DBO.fm_departments", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "building_number", "composite": true, "catalogID": "{B862C919-1321-4420-ABB0-F0945B034150}" }, { "id": 2, "name": "DBO.building_names", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": true, "catalogID": "{B3046C36-2755-4A79-BF7E-B2F96BDE244F}" } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": false, "extent": { "xmin": 425062.07078124955, "ymin": 4508048.9725, "xmax": 431160.1921875002, "ymax": 4514190, "spatialReference": { "wkid": 26912, "latestWkid": 26912, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 4.504455473910538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26912, "latestWkid": 26912, "xyTolerance": 0.02, "zTolerance": 0.002, "mTolerance": 2.0E-5, "falseX": -5120900, "falseY": -9998100, "xyUnits": 6400, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 0, 0, 0, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSNull", "color": [ 110, 110, 110, 255 ], "width": 0 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "formal_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "primary_function", "type": "esriFieldTypeString", "alias": "primary_function", "domain": { "type": "codedValue", "name": "primary_building_function", "description": "", "codedValues": [ { "name": "Academic", "code": "Academic" }, { "name": "Utility", "code": "Utility" }, { "name": "Parking", "code": "Parking" }, { "name": "Housing", "code": "Housing" }, { "name": "Athletic", "code": "Athletic" }, { "name": "Storage", "code": "Storage" }, { "name": "Venue", "code": "Venue" }, { "name": "Support Services", "code": "Support Services" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Cultural", "code": "Cultural" }, { "name": "Hospital/Clinic", "code": "Hospital/Clinic" }, { "name": "Recreation", "code": "Recreation" }, { "name": "Research", "code": "Research" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "primary_function" }, { "name": "formal_name", "type": "esriFieldTypeString", "alias": "formal_name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "formal_name" }, { "name": "informal_name", "type": "esriFieldTypeString", "alias": "informal_name", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "informal_name" }, { "name": "building_number", "type": "esriFieldTypeInteger", "alias": "building_number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "building_number" }, { "name": "abbreviation", "type": "esriFieldTypeString", "alias": "abbreviation", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "abbreviation" }, { "name": "ownership", "type": "esriFieldTypeString", "alias": "ownership", "domain": { "type": "codedValue", "name": "structure_ownership", "description": "", "codedValues": [ { "name": "University", "code": "University" }, { "name": "Non-University", "code": "Non-University" }, { "name": "University Leased", "code": "University Leased" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ownership" }, { "name": "lifecycle", "type": "esriFieldTypeString", "alias": "lifecycle", "domain": { "type": "codedValue", "name": "lifecycle", "description": "Current lifecycle of a feature", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Construction", "code": "Construction" }, { "name": "Design", "code": "Design" }, { "name": "Demo Pending", "code": "Demo Pending" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "lifecycle" }, { "name": "year_built", "type": "esriFieldTypeInteger", "alias": "year_built", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "year_built" }, { "name": "route_participating", "type": "esriFieldTypeString", "alias": "route_participating", "domain": { "type": "codedValue", "name": "true_false", "description": "", "codedValues": [ { "name": "True", "code": "True" }, { "name": "False", "code": "False" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "route_participating" }, { "name": "centroid_x", "type": "esriFieldTypeDouble", "alias": "centroid_x", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "centroid_x" }, { "name": "centroid_y", "type": "esriFieldTypeDouble", "alias": "centroid_y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "centroid_y" }, { "name": "RuleID_DS", "type": "esriFieldTypeInteger", "alias": "RuleID_DS", "domain": { "type": "codedValue", "name": "structure_Rep1_Rules", "description": "Representation rules", "codedValues": [ { "name": "Rule_1DS", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RuleID_DS" }, { "name": "street_address", "type": "esriFieldTypeString", "alias": "street_address", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "street_address" }, { "name": "city", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "city" }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "state" }, { "name": "zip_code", "type": "esriFieldTypeInteger", "alias": "Zip Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "zip_code" }, { "name": "RuleID_1", "type": "esriFieldTypeInteger", "alias": "RuleID_1", "domain": { "type": "codedValue", "name": "structure_Rep2_Rules", "description": "Representation rules", "codedValues": [ { "name": "University Owned", "code": 1 }, { "name": "Non-University Owned", "code": 2 }, { "name": "Construction", "code": 3 }, { "name": "University Leased", "code": 4 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RuleID_1" }, { "name": "lattitude", "type": "esriFieldTypeDouble", "alias": "lattitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "lattitude" }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "longitude" }, { "name": "thumbnails", "type": "esriFieldTypeString", "alias": "thumbnails", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "thumbnails" }, { "name": "gsv_heading", "type": "esriFieldTypeInteger", "alias": "gsv_heading", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "gsv_heading" }, { "name": "gsv_pitch", "type": "esriFieldTypeInteger", "alias": "gsv_pitch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "gsv_pitch" }, { "name": "UIT_NetOwner", "type": "esriFieldTypeSmallInteger", "alias": "UIT_NetOwner", "domain": { "type": "codedValue", "name": "yes_no", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UIT_NetOwner" }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "domain": null, "editable": true, "nullable": true, "length": 750, "defaultValue": null, "modelName": "description" }, { "name": "district_name", "type": "esriFieldTypeString", "alias": "District Name", "domain": { "type": "codedValue", "name": "fm_district", "description": "Management districts managed by facilities management", "codedValues": [ { "name": "President's Circle", "code": "President's Circle" }, { "name": "Sciences", "code": "Sciences" }, { "name": "Engineering", "code": "Engineering" }, { "name": "Academic", "code": "Academic" }, { "name": "Health Sciences", "code": "Health Sciences" }, { "name": "Athletics, Auxiliary & Venues", "code": "Athletics, Auxiliary & Venues" }, { "name": "Plant", "code": "Plant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "district_name" }, { "name": "district_management", "type": "esriFieldTypeString", "alias": "Management Level", "domain": { "type": "codedValue", "name": "fm_district_management", "description": "Level of management that a district has for a specific entity", "codedValues": [ { "name": "Full Management", "code": "Full Management" }, { "name": "Custodial Service", "code": "Custodial Service" }, { "name": "Contact Only", "code": "Contact Only" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "district_management" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.area", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.area" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.len", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.len" }, { "name": "interactive", "type": "esriFieldTypeSmallInteger", "alias": "Interactive?", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "interactive" }, { "name": "gsf", "type": "esriFieldTypeDouble", "alias": "GSF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "gsf" }, { "name": "height", "type": "esriFieldTypeDouble", "alias": "Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "height" }, { "name": "list_type", "type": "esriFieldTypeString", "alias": "Bldg List", "domain": { "type": "codedValue", "name": "bldg_list", "description": "Different types of building list categories a building may belong to", "codedValues": [ { "name": "Primary", "code": "Primary" }, { "name": "Parking Structure", "code": "Parking Structure" }, { "name": "Dorms", "code": "Dorms" }, { "name": "Major Internal", "code": "Major Internal" }, { "name": "Research Park", "code": "Research Park" }, { "name": "Fort Douglas", "code": "Fort Douglas" }, { "name": "Internal", "code": "Internal" }, { "name": "Apartments", "code": "Apartments" }, { "name": "Red Butte Garden", "code": "Red Butte Garden" }, { "name": "Off Campus", "code": "Off Campus" }, { "name": "Context Only", "code": "Context Only" }, { "name": "VA Building", "code": "VA Building" }, { "name": "Not Listed", "code": "Not Listed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "list_type" }, { "name": "recycle_type", "type": "esriFieldTypeString", "alias": "Recycling", "domain": { "type": "codedValue", "name": "recycle_type", "description": "Different systems for handling recycling materials", "codedValues": [ { "name": "Source Separated", "code": "Source Separated" }, { "name": "Single Stream", "code": "Single Stream" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "recycle_type" }, { "name": "waste_servicer", "type": "esriFieldTypeString", "alias": "Waste Servicer", "domain": { "type": "codedValue", "name": "waste_servicer", "description": "Entities that may provide waste removal services", "codedValues": [ { "name": "Facilities Management", "code": "Facilities Management" }, { "name": "Housing Services", "code": "Housing Services" }, { "name": "Hospital Services", "code": "Hospital Services" }, { "name": "Research Park", "code": "Research Park" }, { "name": "Student Apartments", "code": "Student Apartments" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Facilities Management", "modelName": "waste_servicer" }, { "name": "recycle_schedule", "type": "esriFieldTypeString", "alias": "Recycle Schedule", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "recycle_schedule" }, { "name": "managing_entity", "type": "esriFieldTypeString", "alias": "Managing Entity", "domain": { "type": "codedValue", "name": "managing_entity", "description": "The University of Utah entity responsible for managing a building on campus", "codedValues": [ { "name": "Facilities Management", "code": "Facilities Management" }, { "name": "Health Sciences", "code": "Health Sciences" }, { "name": "University Student Apartments", "code": "University Student Apartments" }, { "name": "Real Estate Administration", "code": "Real Estate Administration" }, { "name": "Independent", "code": "Independent" }, { "name": "Housing & Residential Education", "code": "Housing & Residential Education" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "managing_entity" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R590_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_STRUCTURE", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "fname_idx", "fields": "formal_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "infname_idx", "fields": "informal_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "abbr_idx", "fields": "abbreviation", "isAscending": true, "isUnique": false, "description": "" }, { "name": "blg_num_idx", "fields": "building_number", "isAscending": true, "isUnique": false, "description": "" }, { "name": "addr_idx", "fields": "street_address", "isAscending": true, "isUnique": false, "description": "" }, { "name": "lifecycle_idx", "fields": "lifecycle", "isAscending": true, "isUnique": false, "description": "" }, { "name": "a483_ix1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "uusd.DBO.structure", "description": "", "prototype": { "attributes": { "recycle_schedule": null, "managing_entity": null, "primary_function": null, "formal_name": null, "informal_name": null, "building_number": null, "abbreviation": null, "ownership": null, "lifecycle": null, "year_built": null, "route_participating": null, "centroid_x": null, "centroid_y": null, "RuleID_DS": null, "street_address": null, "city": null, "state": null, "zip_code": null, "RuleID_1": null, "lattitude": null, "longitude": null, "thumbnails": null, "gsv_heading": null, "gsv_pitch": null, "UIT_NetOwner": null, "description": null, "district_name": null, "district_management": null, "waste_servicer": "Facilities Management", "recycle_type": null, "interactive": 1, "gsf": null, "height": null, "list_type": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "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": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "uusd.DBO.fm_departments", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "DBO.structure", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "building_number", "composite": true, "catalogID": "{B862C919-1321-4420-ABB0-F0945B034150}" } ], "isDataVersioned": true, "isDataArchived": false, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "dept_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "dept_name", "type": "esriFieldTypeString", "alias": "name", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "dept_name" }, { "name": "website_url", "type": "esriFieldTypeString", "alias": "website_url", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "website_url" }, { "name": "building_number", "type": "esriFieldTypeInteger", "alias": "building_number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "building_number" } ], "indexes": [ { "name": "R1428_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_52059_buildi", "fields": "building_number", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PK_FM_DEPARTMENTS", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "uusd.DBO.fm_departments", "description": "", "prototype": { "attributes": { "website_url": null, "building_number": null, "dept_name": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "uusd.DBO.building_names", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "DBO.structure", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "structure_id", "composite": true, "catalogID": "{B3046C36-2755-4A79-BF7E-B2F96BDE244F}" } ], "isDataVersioned": true, "isDataArchived": false, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "centroid_x", "type": "esriFieldTypeDouble", "alias": "centroid_x", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "centroid_x" }, { "name": "centroid_y", "type": "esriFieldTypeDouble", "alias": "centroid_y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "centroid_y" }, { "name": "name", "type": "esriFieldTypeString", "alias": "name", "domain": null, "editable": true, "nullable": false, "length": 200, "defaultValue": null, "modelName": "name" }, { "name": "structure_id", "type": "esriFieldTypeInteger", "alias": "structure_id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "structure_id" } ], "indexes": [ { "name": "R1003_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_BUILDING_NAMES", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "uusd.DBO.building_names", "description": "", "prototype": { "attributes": { "name": " ", "structure_id": 0, "centroid_x": null, "centroid_y": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "UUSD.DBO.buildings_eap", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "structure", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "building_number", "composite": false, "catalogID": "{DB06DC63-9E0D-4C1E-A846-202FEE0C9F5B}" } ], "isDataVersioned": true, "isDataArchived": false, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "building_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "building_number", "type": "esriFieldTypeInteger", "alias": "building_number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "building_number" }, { "name": "eap_id", "type": "esriFieldTypeString", "alias": "eap_id", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "eap_id" }, { "name": "building_name", "type": "esriFieldTypeString", "alias": "building_name", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "building_name" } ], "indexes": [ { "name": "R1581_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_55491_buildi", "fields": "building_number", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_55491_eap_id", "fields": "eap_id", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "UUSD.DBO.buildings_eap", "description": "", "prototype": { "attributes": { "eap_id": null, "building_name": null, "building_number": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }