{ "currentVersion": 10.31, "id": 5, "name": "Capitalisation Details", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROJECT_NO", "typeIdField": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 8, "domain": null }, { "name": "GlobalID_REL", "type": "esriFieldTypeGUID", "alias": "GlobalID_REL", "length": 38, "domain": null }, { "name": "FY_REPORT", "type": "esriFieldTypeSmallInteger", "alias": "Finance Year Reported", "domain": null }, { "name": "TOTAL_COST", "type": "esriFieldTypeDouble", "alias": "Total Costs", "domain": null }, { "name": "ACT_COST", "type": "esriFieldTypeDouble", "alias": "Actualised Costs", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "NOTE", "type": "esriFieldTypeString", "alias": "Note", "length": 255, "domain": null }, { "name": "CATEGORY", "type": "esriFieldTypeSmallInteger", "alias": "Category", "domain": { "type": "codedValue", "name": "ParkAssets_Category", "codedValues": [ { "name": "Bin", "code": 1 }, { "name": "Fence", "code": 2 }, { "name": "Footpath", "code": 3 }, { "name": "Furniture", "code": 4 }, { "name": "Light", "code": 5 }, { "name": "Playground", "code": 6 }, { "name": "Service", "code": 7 }, { "name": "Sign", "code": 8 }, { "name": "Sports", "code": 9 }, { "name": "Structure", "code": 10 } ] } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "PROJ_STAT", "type": "esriFieldTypeString", "alias": "Project Status", "length": 20, "domain": { "type": "codedValue", "name": "ParkAssets_ProjectStatus", "codedValues": [ { "name": "Complete", "code": "Complete" }, { "name": "In Progress", "code": "In Progress" } ] } }, { "name": "SITENAME", "type": "esriFieldTypeString", "alias": "Site Name", "length": 120, "domain": null }, { "name": "PROJECT_NO", "type": "esriFieldTypeString", "alias": "Project No", "length": 14, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null }, { "name": "PERC_RENEWED", "type": "esriFieldTypeSmallInteger", "alias": "Percent Renewed", "domain": null }, { "name": "PERC_RETIRED", "type": "esriFieldTypeSmallInteger", "alias": "Percent Retired", "domain": null }, { "name": "FINANCE_CAT", "type": "esriFieldTypeString", "alias": "Finance Category", "length": 40, "domain": { "type": "codedValue", "name": "ParkAssets_FinanceCategory", "codedValues": [ { "name": "New", "code": "New" }, { "name": "Renewed", "code": "Renewed" }, { "name": "Partially Renewed", "code": "Partially Renewed" }, { "name": "Upgraded", "code": "Upgraded" }, { "name": "Retired", "code": "Retired" }, { "name": "Partially Retired", "code": "Partially Retired" }, { "name": "Missing Data", "code": "Missing Data" }, { "name": "Data Update", "code": "Data Update" }, { "name": "Gifted", "code": "Gifted" }, { "name": "Renewed Missing Data", "code": "Renewed Missing Data" }, { "name": "Renewed Split", "code": "Renewed Split" }, { "name": "Partially Renewed Missing Data", "code": "Partially Renewed Missing Data" } ] } } ], "relationships": [ { "id": 10, "name": "GIS.WMC.parkassets_A", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "GlobalID_REL", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 6, "name": "GIS.WMC.parkassets_L", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GlobalID_REL", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 1, "name": "GIS.WMC.parkassets_P", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GlobalID_REL", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": false, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true } }