{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "buildingid", "role": "esriRelRoleDestination", "composite": false, "name": "PRRD.GISOWNER.LNDPRRD_Buildings", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Assets Facilities", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "cityworks_description_asset": null, "uniformat_ii_lvl1_majorgrp": null, "prorated_pcnt_of_cost": null, "historical_cost": null, "current_replacement_value": null, "component_location": null, "buildingid": null, "manufacturer": null, "assessed_replacement_value": null, "insurance_value": null, "functionnum": null, "condition_rating": null, "sitename": null, "siteid": null, "unit_of_measure": null, "last_edited_date": null, "model": null, "assessed_date": null, "component_description": null, "conditionscore": null, "uniformat_ii_lvl3_component": null, "quantity": null, "created_user": null, "serial_number": null, "condition_by": null, "gis_layer_name": null, "inservice_date": null, "replacement_cost_date": null, "last_edited_user": null, "uniformat_ii_lvl2_componentgrp": null, "assetid": null, "condition_value": null, "estimated_useful_life_years": null, "asset_group": null, "created_date": null, "condition_date": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Assets Facilities", "displayField": "sitename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "AssetID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assetid", "length": 255, "alias": "AssetID", "type": "esriFieldTypeString" }, { "modelName": "SiteID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteid", "length": 255, "alias": "SiteID", "type": "esriFieldTypeString" }, { "modelName": "SiteName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sitename", "length": 255, "alias": "SiteName", "type": "esriFieldTypeString" }, { "modelName": "FunctionNum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "functionnum", "alias": "FunctionNum", "type": "esriFieldTypeInteger" }, { "modelName": "Asset_Group", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "asset_group", "length": 255, "alias": "Asset_Group", "type": "esriFieldTypeString" }, { "modelName": "GIS_Layer_Name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "gis_layer_name", "length": 255, "alias": "GIS_Layer_Name", "type": "esriFieldTypeString" }, { "modelName": "Cityworks_Description_Asset", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cityworks_description_asset", "length": 255, "alias": "Cityworks_Description_Asset", "type": "esriFieldTypeString" }, { "modelName": "Component_Location", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "component_location", "length": 255, "alias": "Component_Location", "type": "esriFieldTypeString" }, { "modelName": "Component_Description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "component_description", "length": 2147483647, "alias": "Component_Description", "type": "esriFieldTypeString" }, { "modelName": "Manufacturer", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manufacturer", "length": 255, "alias": "Manufacturer", "type": "esriFieldTypeString" }, { "modelName": "Model", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "model", "length": 255, "alias": "Model", "type": "esriFieldTypeString" }, { "modelName": "Serial_Number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "serial_number", "length": 255, "alias": "Serial_Number", "type": "esriFieldTypeString" }, { "modelName": "Quantity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "quantity", "alias": "Quantity", "type": "esriFieldTypeDouble" }, { "modelName": "Unit_of_Measure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit_of_measure", "length": 255, "alias": "Unit_of_Measure", "type": "esriFieldTypeString" }, { "modelName": "ConditionScore", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conditionscore", "alias": "Condition Score", "type": "esriFieldTypeInteger" }, { "modelName": "Condition_Rating", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_rating", "length": 10, "alias": "Condition_Rating", "type": "esriFieldTypeString" }, { "modelName": "Condition_Value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_value", "length": 15, "alias": "Condition_Value", "type": "esriFieldTypeString" }, { "modelName": "Condition_By", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_by", "length": 50, "alias": "Condition_By", "type": "esriFieldTypeString" }, { "modelName": "Condition_Date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "condition_date", "length": 29, "alias": "Condition_Date", "type": "esriFieldTypeDate" }, { "modelName": "InService_Date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inservice_date", "length": 29, "alias": "InService_Date", "type": "esriFieldTypeDate" }, { "modelName": "Estimated_Useful_Life_Years", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estimated_useful_life_years", "alias": "Estimated_Useful_Life_Years", "type": "esriFieldTypeInteger" }, { "modelName": "Historical_Cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "historical_cost", "length": 255, "alias": "Historical_Cost", "type": "esriFieldTypeString" }, { "modelName": "Assessed_Replacement_Value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessed_replacement_value", "length": 255, "alias": "Assessed_Replacement_Value", "type": "esriFieldTypeString" }, { "modelName": "Current_Replacement_Value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_replacement_value", "length": 255, "alias": "Current_Replacement_Value", "type": "esriFieldTypeString" }, { "modelName": "Replacement_Cost_Date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "replacement_cost_date", "length": 29, "alias": "Replacement_Cost_Date", "type": "esriFieldTypeDate" }, { "modelName": "Uniformat_II_Lvl1_MajorGrp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniformat_ii_lvl1_majorgrp", "length": 255, "alias": "Uniformat_II_Lvl1_MajorGrp", "type": "esriFieldTypeString" }, { "modelName": "Uniformat_II_Lvl2_ComponentGrp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniformat_ii_lvl2_componentgrp", "length": 255, "alias": "Uniformat_II_Lvl2_ComponentGrp", "type": "esriFieldTypeString" }, { "modelName": "Uniformat_II_Lvl3_Component", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "uniformat_ii_lvl3_component", "length": 255, "alias": "Uniformat_II_Lvl3_Component", "type": "esriFieldTypeString" }, { "modelName": "Insurance_Value", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "insurance_value", "length": 255, "alias": "Insurance_Value", "type": "esriFieldTypeString" }, { "modelName": "Assessed_Date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessed_date", "length": 29, "alias": "Assessed_Date", "type": "esriFieldTypeDate" }, { "modelName": "Prorated_pcnt_of_Cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "prorated_pcnt_of_cost", "length": 255, "alias": "Prorated_pcnt_of_Cost", "type": "esriFieldTypeString" }, { "modelName": "Status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 20, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "created_user", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "modelName": "buildingid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "buildingid", "length": 255, "alias": "BuildingID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g9077buildingid", "isUnique": false, "description": "", "fields": "buildingid", "isAscending": true }, { "name": "r885_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_885", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fe30cb8cb10043e0bab0080f62408d86", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 7410917.376900002, "xmin": -1.36077380184E7, "ymax": 7737270.038699999, "xmax": -1.3362196066599999E7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "buildingid", "role": "esriRelRoleOrigin", "composite": false, "name": "PRRD.GISOWNER.Assets_Facilities", "relatedTableId": 3, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "PRRD Buildings_PFA", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "cwassetgroup": null, "address": null, "comments": null, "featuretype": null, "prrdgroup": null, "buildingid": null, "dt_established": null, "dt_closed": null, "feature": null, "ownership": null, "functionnum": null, "dt_reviewed": null, "service": null, "siteid": null, "location": null, "status": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PRRD Buildings_PFA", "allowTrueCurvesUpdates": false, "displayField": "buildingid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "BuildingID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "buildingid", "length": 15, "alias": "BuildingID", "type": "esriFieldTypeString" }, { "modelName": "SiteID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteid", "length": 15, "alias": "SiteID", "type": "esriFieldTypeString" }, { "modelName": "Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 130, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "Location", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location", "type": "esriFieldTypeString" }, { "modelName": "Feature", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feature", "length": 130, "alias": "Feature", "type": "esriFieldTypeString" }, { "modelName": "FeatureType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "featuretype", "length": 50, "alias": "FeatureType", "type": "esriFieldTypeString" }, { "modelName": "PRRDGroup", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "prrdgroup", "length": 200, "alias": "PRRDGroup", "type": "esriFieldTypeString" }, { "modelName": "CWAssetGroup", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cwassetgroup", "length": 200, "alias": "CWAssetGroup", "type": "esriFieldTypeString" }, { "modelName": "Status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 15, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "Ownership", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownership", "length": 100, "alias": "Ownership", "type": "esriFieldTypeString" }, { "modelName": "FunctionNum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "functionnum", "length": 200, "alias": "FunctionNum", "type": "esriFieldTypeString" }, { "modelName": "Service", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "service", "length": 200, "alias": "Service", "type": "esriFieldTypeString" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "DT_Established", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dt_established", "length": 29, "alias": "DT_Established", "type": "esriFieldTypeDate" }, { "modelName": "DT_Reviewed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dt_reviewed", "length": 29, "alias": "DT_Reviewed", "type": "esriFieldTypeDate" }, { "modelName": "DT_Closed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dt_closed", "length": 29, "alias": "DT_Closed", "type": "esriFieldTypeDate" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriMeters" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "g9105buildingid", "isUnique": false, "description": "", "fields": "buildingid", "isAscending": true }, { "name": "r912_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_912", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a671_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "fe30cb8cb10043e0bab0080f62408d86", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": null, "color": [ 197, 0, 255, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "SHAPE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolygon" } ] }