{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 303, "name": "BUILDING MAINTENANCE", "type": "Group Layer", "description": "", "geometryType": null, "copyrightText": "", "parentLayer": null, "subLayers": [ { "id": 256, "name": "City Facility" } ], "minScale": 0, "maxScale": 0, "defaultVisibility": true, "extent": { "xmin": 1.1017894966314048E7, "ymin": 3624444.92307806, "xmax": 1.1039931087924138E7, "ymax": 3639092.5364993066, "spatialReference": { "wkid": 102747, "latestWkid": 2284, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111140600, "falseY": -91532100, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": null, "geometryField": {}, "indexes": [], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query", "supportsStatistics": false, "supportsExceedsLimitStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsPercentileStatistics": false, "supportsHavingClause": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsCountDistinct": false, "supportsPagination": false, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 256, "name": "City Facility", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102747, "latestWkid": 2284, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111140600, "falseY": -91532100, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": { "id": 303, "name": "BUILDING MAINTENANCE" }, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 223, 210, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 1.1017894966314048E7, "ymin": 3624444.92307806, "xmax": 1.1039931087924138E7, "ymax": 3639092.5364993066, "spatialReference": { "wkid": 102747, "latestWkid": 2284, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111140600, "falseY": -91532100, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Asset_ID", "type": "esriFieldTypeString", "alias": "Asset_ID", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R7473_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S5274_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Appliances", "relatedTableId": 260, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Boilers", "relatedTableId": 261, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "Chillers", "relatedTableId": 262, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "Compressors", "relatedTableId": 263, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "DomesticPump", "relatedTableId": 265, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "Doors", "relatedTableId": 266, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "Electrical", "relatedTableId": 267, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "Elevator", "relatedTableId": 268, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "Generator", "relatedTableId": 269, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "HVAC", "relatedTableId": 270, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "Pumps", "relatedTableId": 271, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "Refrigeration", "relatedTableId": 272, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "Tanks", "relatedTableId": 273, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 14, "name": "Tools", "relatedTableId": 274, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "WaterHeaters", "relatedTableId": 275, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "CoolingTowers", "relatedTableId": 287, "role": "esriRelRoleOrigin", "keyField": "Asset_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet" }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 260, "name": "Appliances", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Appliance", "description": "Appliance types", "codedValues": [ { "name": "Booster Heater/Washer", "code": "Booster Heater/Washer" }, { "name": "Cooker", "code": "Cooker" }, { "name": "Garbage Disposal", "code": "Garbage Disposal" }, { "name": "Ice Machine", "code": "Ice Machine" }, { "name": "Oven", "code": "Oven" }, { "name": "Oven/Stove", "code": "Oven/Stove" }, { "name": "Steamer", "code": "Steamer" }, { "name": "Stove", "code": "Stove" }, { "name": "Washer", "code": "Washer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "Decommissioned Date", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4159_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17212_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 261, "name": "Boilers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset _Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Boiler", "description": "Boiler types", "codedValues": [ { "name": "Boiler", "code": "Boiler" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4162_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17218_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 262, "name": "Chillers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Chiller", "description": "Chiller types", "codedValues": [ { "name": "Chiller", "code": "Chiller" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4163_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17220_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 263, "name": "Compressors", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset _Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_AirCompressor", "description": "Air Compressor types", "codedValues": [ { "name": "Air Compressor", "code": "Air Compressor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "Decommissioned_Date", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4164_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17221_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 265, "name": "DomesticPump", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_DomesticPump", "description": "DomesticPump types", "codedValues": [ { "name": "Chilled Water Pump", "code": "Chilled Water Pump" }, { "name": "Hot Water Pump", "code": "Hot Water Pump" }, { "name": "Pump", "code": "Pump" }, { "name": "Sump Pump", "code": "Sump Pump" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Hp", "type": "esriFieldTypeString", "alias": "Hp", "length": 255, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4166_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17223_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 266, "name": "Doors", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset _Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Door", "description": "Door types", "codedValues": [ { "name": "Garage Door", "code": "Garage Door" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeString", "alias": "DecommissionedDate", "length": 255, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4167_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17224_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 15, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 267, "name": "Electrical", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Electrical", "description": "Electrical types", "codedValues": [ { "name": "Solar Panels Electric", "code": "Solar Panels Electric" }, { "name": "Main Switch Gear", "code": "Main Switch Gear" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition_2", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4168_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17225_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 268, "name": "Elevator", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Elevator", "description": "Elevator types", "codedValues": [ { "name": "Condenser", "code": "Condenser" }, { "name": "Elevator", "code": "Elevator" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4169_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17226_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 269, "name": "Generator", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Generator", "description": "Generator types", "codedValues": [ { "name": "Generator", "code": "Generator" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 255, "domain": null }, { "name": "LastEditor", "type": "esriFieldTypeString", "alias": "LastEditor", "length": 255, "domain": null }, { "name": "LastUpdate", "type": "esriFieldTypeDate", "alias": "LastUpdate", "length": 8, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4170_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17227_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 270, "name": "HVAC", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_HVAC", "description": "HVAC equipment types", "codedValues": [ { "name": "Air Curtain", "code": "Air Curtain" }, { "name": "Air Handler Unit", "code": "Air Handler Unit" }, { "name": "Condensing Unit", "code": "Condensing Unit" }, { "name": "Cooling Rack Unit", "code": "Cooling Rack Unit" }, { "name": "Expansion Tank", "code": "Expansion Tank" }, { "name": "Fan", "code": "Fan" }, { "name": "Furnace", "code": "Furnace" }, { "name": "Heater", "code": "Heater" }, { "name": "Heating Unit", "code": "Heating Unit" }, { "name": "Make Up Air Unit", "code": "Make Up Air Unit" }, { "name": "Mini Split Unit", "code": "Mini Split Unit" }, { "name": "Package Unit", "code": "Package Unit" }, { "name": "Pneumatic Air Dryer", "code": "Pneumatic Air Dryer" }, { "name": "Pump", "code": "Pump" }, { "name": "Radiant Heater", "code": "Radiant Heater" }, { "name": "Recovery Wheel", "code": "Recovery Wheel" }, { "name": "Roof Top Air Handler", "code": "Roof Top Air Handler" }, { "name": "Roof Top Package Unit", "code": "Roof Top Package Unit" }, { "name": "Split Unit", "code": "Split Unit" }, { "name": "Tank", "code": "Tank" }, { "name": "Unit Heater", "code": "Unit Heater" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4171_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17228_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 271, "name": "Pumps", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Pump", "description": "Types of Pumps", "codedValues": [ { "name": "Chilled Water Pump", "code": "Chilled Water Pump" }, { "name": "Hot Water Pump", "code": "Hot Water Pump" }, { "name": "Pump", "code": "Pump" }, { "name": "Sump Pump", "code": "Sump Pump" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Hp", "type": "esriFieldTypeString", "alias": "Hp", "length": 255, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4172_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17229_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 13, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 272, "name": "Refrigeration", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Refrigeration", "description": "Types of Refrigeration equipment", "codedValues": [ { "name": "Condensing Unit", "code": "Condensing Unit" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4173_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17230_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 273, "name": "Tanks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Tank", "description": "Types of Tanks", "codedValues": [ { "name": "Tank", "code": "Tank" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": null }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4174_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17231_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 274, "name": "Tools", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_Tool", "description": "Types of Tools", "codedValues": [ { "name": "Battery Charger", "code": "Battery Charger" }, { "name": "Blast Cabinet", "code": "Blast Cabinet" }, { "name": "Car Lift", "code": "Car Lift" }, { "name": "CO Filler", "code": "CO Filler" }, { "name": "Crane", "code": "Crane" }, { "name": "Dock Leveler", "code": "Dock Leveler" }, { "name": "Hydraulic Lift", "code": "Hydraulic Lift" }, { "name": "Paint Booth", "code": "Paint Booth" }, { "name": "Rigging Basket", "code": "Rigging Basket" }, { "name": "Tool", "code": "Tool" }, { "name": "Welder", "code": "Welder" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4175_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17232_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 275, "name": "WaterHeaters", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_WaterHeater", "description": "Types of Water Heaters", "codedValues": [ { "name": "Water Heater", "code": "Water Heater" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeString", "alias": "InstallDate", "length": 255, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R4176_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17233_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 287, "name": "CoolingTowers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Asset_Type", "type": "esriFieldTypeString", "alias": "Asset_Type", "length": 255, "domain": { "type": "codedValue", "name": "StAsst_CoolingTower", "description": "CoolingTower types", "codedValues": [ { "name": "Cooling Tower", "code": "Cooling Tower" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Site", "type": "esriFieldTypeString", "alias": "Site", "length": 255, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 255, "domain": null }, { "name": "Ownership", "type": "esriFieldTypeSmallInteger", "alias": "Ownership", "domain": { "type": "codedValue", "name": "AssetOwner", "description": "The owner of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Maintenance_Responsibility", "type": "esriFieldTypeSmallInteger", "alias": "Maintenance_Responsibility", "domain": { "type": "codedValue", "name": "AssetManager", "description": "The manager of the asset", "codedValues": [ { "name": "Our Agency", "code": 1 }, { "name": "Private", "code": -1 }, { "name": "Other", "code": -2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "PurchaseDate", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "WarrantyDate", "length": 8, "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "ConditionDate", "length": 8, "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "Condition", "description": "The condition of the asset", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Very Good", "code": "Very Good" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Very Poor", "code": "Very Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 255, "domain": null }, { "name": "Vendor", "type": "esriFieldTypeString", "alias": "Vendor", "length": 255, "domain": null }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 255, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 255, "domain": null }, { "name": "ServiceLife", "type": "esriFieldTypeString", "alias": "ServiceLife", "length": 255, "domain": { "type": "codedValue", "name": "Asset_Lifecycle", "description": "Lifecycle status for the Streets Dept", "codedValues": [ { "name": "0-1 YEARS REMAINING", "code": "1" }, { "name": "2-4 YEARS REMAINING", "code": "2" }, { "name": "5-7 YEARS REMAINING", "code": "3" }, { "name": "8+ YEARS", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Decommissioned_Date", "type": "esriFieldTypeDate", "alias": "DecommissionedDate", "length": 8, "domain": null }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "LP_", "type": "esriFieldTypeString", "alias": "LP#", "length": 50, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 50, "domain": null } ], "indexes": [ { "name": "R4165_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_17222_Facili", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "City Facility", "relatedTableId": 256, "role": "esriRelRoleDestination", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "9a3389f94e6040c0b680b4ad38573fa9" } ] }