{
 "layers": [],
 "tables": [
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 1,
   "name": "Cityworks.AZTECA.%WorkordersLastYear",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "PROJECTNAME",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "WORKORDERID",
     "type": "esriFieldTypeString",
     "alias": "WORKORDERID",
     "length": 60,
     "domain": null
    },
    {
     "name": "DESCRIPTION",
     "type": "esriFieldTypeString",
     "alias": "DESCRIPTION",
     "length": 60,
     "domain": null
    },
    {
     "name": "SUPERVISOR",
     "type": "esriFieldTypeString",
     "alias": "SUPERVISOR",
     "length": 50,
     "domain": null
    },
    {
     "name": "REQUESTEDBY",
     "type": "esriFieldTypeString",
     "alias": "REQUESTEDBY",
     "length": 50,
     "domain": null
    },
    {
     "name": "INITIATEDBY",
     "type": "esriFieldTypeString",
     "alias": "INITIATEDBY",
     "length": 50,
     "domain": null
    },
    {
     "name": "INITIATEDATE",
     "type": "esriFieldTypeDate",
     "alias": "INITIATEDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "PROJECTNAME",
     "type": "esriFieldTypeString",
     "alias": "PROJECTNAME",
     "length": 130,
     "domain": null
    },
    {
     "name": "LOCATION",
     "type": "esriFieldTypeString",
     "alias": "LOCATION",
     "length": 256,
     "domain": null
    },
    {
     "name": "PROJSTARTDATE",
     "type": "esriFieldTypeDate",
     "alias": "PROJSTARTDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "PROJFINISHDATE",
     "type": "esriFieldTypeDate",
     "alias": "PROJFINISHDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "ACTUALSTARTDATE",
     "type": "esriFieldTypeDate",
     "alias": "ACTUALSTARTDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "ACTUALFINISHDATE",
     "type": "esriFieldTypeDate",
     "alias": "ACTUALFINISHDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "WOCLOSEDBY",
     "type": "esriFieldTypeString",
     "alias": "WOCLOSEDBY",
     "length": 50,
     "domain": null
    },
    {
     "name": "CANCEL",
     "type": "esriFieldTypeString",
     "alias": "CANCEL",
     "length": 1,
     "domain": null
    },
    {
     "name": "PRIORITY",
     "type": "esriFieldTypeString",
     "alias": "PRIORITY",
     "length": 2,
     "domain": null
    },
    {
     "name": "NUMDAYSBEFORE",
     "type": "esriFieldTypeSmallInteger",
     "alias": "NUMDAYSBEFORE",
     "domain": null
    },
    {
     "name": "DATETOBEPRINTED",
     "type": "esriFieldTypeDate",
     "alias": "DATETOBEPRINTED",
     "length": 8,
     "domain": null
    },
    {
     "name": "DATEPRINTED",
     "type": "esriFieldTypeDate",
     "alias": "DATEPRINTED",
     "length": 8,
     "domain": null
    },
    {
     "name": "MAPTEMPLATENAME",
     "type": "esriFieldTypeString",
     "alias": "MAPTEMPLATENAME",
     "length": 250,
     "domain": null
    },
    {
     "name": "WOMAPEXTENT",
     "type": "esriFieldTypeString",
     "alias": "WOMAPEXTENT",
     "length": 1,
     "domain": null
    },
    {
     "name": "WOMAPSCALE",
     "type": "esriFieldTypeInteger",
     "alias": "WOMAPSCALE",
     "domain": null
    },
    {
     "name": "WOOUTPUT",
     "type": "esriFieldTypeString",
     "alias": "WOOUTPUT",
     "length": 1,
     "domain": null
    },
    {
     "name": "SOURCEWOID",
     "type": "esriFieldTypeString",
     "alias": "SOURCEWOID",
     "length": 20,
     "domain": null
    },
    {
     "name": "CYCLETYPE",
     "type": "esriFieldTypeString",
     "alias": "CYCLETYPE",
     "length": 1,
     "domain": null
    },
    {
     "name": "CYCLEINTERVALNUM",
     "type": "esriFieldTypeSmallInteger",
     "alias": "CYCLEINTERVALNUM",
     "domain": null
    },
    {
     "name": "CYCLEINTERVALUNIT",
     "type": "esriFieldTypeString",
     "alias": "CYCLEINTERVALUNIT",
     "length": 1,
     "domain": null
    },
    {
     "name": "SCHEDULEDATE",
     "type": "esriFieldTypeDate",
     "alias": "SCHEDULEDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "FROMDATE",
     "type": "esriFieldTypeDate",
     "alias": "FROMDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "WOXCOORDINATE",
     "type": "esriFieldTypeDouble",
     "alias": "WOXCOORDINATE",
     "domain": null
    },
    {
     "name": "WOYCOORDINATE",
     "type": "esriFieldTypeDouble",
     "alias": "WOYCOORDINATE",
     "domain": null
    },
    {
     "name": "SHOP",
     "type": "esriFieldTypeString",
     "alias": "SHOP",
     "length": 100,
     "domain": null
    },
    {
     "name": "WOCATEGORY",
     "type": "esriFieldTypeString",
     "alias": "WOCATEGORY",
     "length": 50,
     "domain": null
    },
    {
     "name": "UNATTACHED",
     "type": "esriFieldTypeString",
     "alias": "UNATTACHED",
     "length": 1,
     "domain": null
    },
    {
     "name": "WOCOST",
     "type": "esriFieldTypeDouble",
     "alias": "WOCOST",
     "domain": null
    },
    {
     "name": "WOLABORCOST",
     "type": "esriFieldTypeDouble",
     "alias": "WOLABORCOST",
     "domain": null
    },
    {
     "name": "WOMATCOST",
     "type": "esriFieldTypeDouble",
     "alias": "WOMATCOST",
     "domain": null
    },
    {
     "name": "WOEQUIPCOST",
     "type": "esriFieldTypeDouble",
     "alias": "WOEQUIPCOST",
     "domain": null
    },
    {
     "name": "WOPERMITCOST",
     "type": "esriFieldTypeDouble",
     "alias": "WOPERMITCOST",
     "domain": null
    },
    {
     "name": "WOTEMPLATEID",
     "type": "esriFieldTypeString",
     "alias": "WOTEMPLATEID",
     "length": 20,
     "domain": null
    },
    {
     "name": "ACCTNUM",
     "type": "esriFieldTypeString",
     "alias": "ACCTNUM",
     "length": 50,
     "domain": null
    },
    {
     "name": "SUBMITTO",
     "type": "esriFieldTypeString",
     "alias": "SUBMITTO",
     "length": 50,
     "domain": null
    },
    {
     "name": "DATESUBMITTO",
     "type": "esriFieldTypeDate",
     "alias": "DATESUBMITTO",
     "length": 8,
     "domain": null
    },
    {
     "name": "SUBMITTOOPENBY",
     "type": "esriFieldTypeString",
     "alias": "SUBMITTOOPENBY",
     "length": 50,
     "domain": null
    },
    {
     "name": "DATESUBMITTOOPEN",
     "type": "esriFieldTypeDate",
     "alias": "DATESUBMITTOOPEN",
     "length": 8,
     "domain": null
    },
    {
     "name": "STATUS",
     "type": "esriFieldTypeString",
     "alias": "STATUS",
     "length": 50,
     "domain": null
    },
    {
     "name": "CONTRACTORSID",
     "type": "esriFieldTypeDouble",
     "alias": "CONTRACTORSID",
     "domain": null
    },
    {
     "name": "WORKCOMPLETEDBY",
     "type": "esriFieldTypeString",
     "alias": "WORKCOMPLETEDBY",
     "length": 50,
     "domain": null
    },
    {
     "name": "DATEWOCLOSED",
     "type": "esriFieldTypeDate",
     "alias": "DATEWOCLOSED",
     "length": 8,
     "domain": null
    },
    {
     "name": "MAPPAGE",
     "type": "esriFieldTypeString",
     "alias": "MAPPAGE",
     "length": 100,
     "domain": null
    },
    {
     "name": "LEGALBILLABLE",
     "type": "esriFieldTypeString",
     "alias": "LEGALBILLABLE",
     "length": 1,
     "domain": null
    },
    {
     "name": "CONTRBILLABLE",
     "type": "esriFieldTypeString",
     "alias": "CONTRBILLABLE",
     "length": 1,
     "domain": null
    },
    {
     "name": "CANCELLEDBY",
     "type": "esriFieldTypeString",
     "alias": "CANCELLEDBY",
     "length": 50,
     "domain": null
    },
    {
     "name": "DATECANCELLED",
     "type": "esriFieldTypeDate",
     "alias": "DATECANCELLED",
     "length": 8,
     "domain": null
    },
    {
     "name": "CUSTOM1",
     "type": "esriFieldTypeDouble",
     "alias": "CUSTOM1",
     "domain": null
    },
    {
     "name": "CUSTOM2",
     "type": "esriFieldTypeDouble",
     "alias": "CUSTOM2",
     "domain": null
    },
    {
     "name": "CUSTOM3",
     "type": "esriFieldTypeString",
     "alias": "CUSTOM3",
     "length": 20,
     "domain": null
    },
    {
     "name": "CUSTOM4",
     "type": "esriFieldTypeString",
     "alias": "CUSTOM4",
     "length": 20,
     "domain": null
    },
    {
     "name": "CUSTOM5",
     "type": "esriFieldTypeString",
     "alias": "CUSTOM5",
     "length": 40,
     "domain": null
    },
    {
     "name": "UPDATEMAP",
     "type": "esriFieldTypeString",
     "alias": "UPDATEMAP",
     "length": 1,
     "domain": null
    },
    {
     "name": "TILENO",
     "type": "esriFieldTypeString",
     "alias": "TILENO",
     "length": 100,
     "domain": null
    },
    {
     "name": "CYCLEFROM",
     "type": "esriFieldTypeString",
     "alias": "CYCLEFROM",
     "length": 30,
     "domain": null
    },
    {
     "name": "APPLYTOENTITY",
     "type": "esriFieldTypeString",
     "alias": "APPLYTOENTITY",
     "length": 50,
     "domain": null
    },
    {
     "name": "DOMAINID",
     "type": "esriFieldTypeDouble",
     "alias": "DOMAINID",
     "domain": null
    },
    {
     "name": "WOCUSTFIELDCATID",
     "type": "esriFieldTypeDouble",
     "alias": "WOCUSTFIELDCATID",
     "domain": null
    },
    {
     "name": "ASSETGROUP",
     "type": "esriFieldTypeString",
     "alias": "ASSETGROUP",
     "length": 20,
     "domain": null
    },
    {
     "name": "WOADDRESS",
     "type": "esriFieldTypeString",
     "alias": "WOADDRESS",
     "length": 130,
     "domain": null
    },
    {
     "name": "CREATEDBYCYCLE",
     "type": "esriFieldTypeString",
     "alias": "CREATEDBYCYCLE",
     "length": 1,
     "domain": null
    },
    {
     "name": "TRANSTOWOID",
     "type": "esriFieldTypeString",
     "alias": "TRANSTOWOID",
     "length": 20,
     "domain": null
    },
    {
     "name": "STAGE",
     "type": "esriFieldTypeString",
     "alias": "STAGE",
     "length": 20,
     "domain": null
    },
    {
     "name": "EXPENSETYPE",
     "type": "esriFieldTypeString",
     "alias": "EXPENSETYPE",
     "length": 20,
     "domain": null
    },
    {
     "name": "UNITSACCOMPLISHED",
     "type": "esriFieldTypeDouble",
     "alias": "UNITSACCOMPLISHED",
     "domain": null
    },
    {
     "name": "UNITSACCOMPDESC",
     "type": "esriFieldTypeString",
     "alias": "UNITSACCOMPDESC",
     "length": 40,
     "domain": null
    },
    {
     "name": "PROJECTSID",
     "type": "esriFieldTypeDouble",
     "alias": "PROJECTSID",
     "domain": null
    },
    {
     "name": "LINEITEMCOST",
     "type": "esriFieldTypeDouble",
     "alias": "LINEITEMCOST",
     "domain": null
    },
    {
     "name": "CANCELREASON",
     "type": "esriFieldTypeString",
     "alias": "CANCELREASON",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT1",
     "type": "esriFieldTypeString",
     "alias": "TEXT1",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT2",
     "type": "esriFieldTypeString",
     "alias": "TEXT2",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT3",
     "type": "esriFieldTypeString",
     "alias": "TEXT3",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT4",
     "type": "esriFieldTypeString",
     "alias": "TEXT4",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT5",
     "type": "esriFieldTypeString",
     "alias": "TEXT5",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT6",
     "type": "esriFieldTypeString",
     "alias": "TEXT6",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT7",
     "type": "esriFieldTypeString",
     "alias": "TEXT7",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT8",
     "type": "esriFieldTypeString",
     "alias": "TEXT8",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT9",
     "type": "esriFieldTypeString",
     "alias": "TEXT9",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT10",
     "type": "esriFieldTypeString",
     "alias": "TEXT10",
     "length": 100,
     "domain": null
    },
    {
     "name": "NUM1",
     "type": "esriFieldTypeDouble",
     "alias": "NUM1",
     "domain": null
    },
    {
     "name": "NUM2",
     "type": "esriFieldTypeDouble",
     "alias": "NUM2",
     "domain": null
    },
    {
     "name": "NUM3",
     "type": "esriFieldTypeDouble",
     "alias": "NUM3",
     "domain": null
    },
    {
     "name": "NUM4",
     "type": "esriFieldTypeDouble",
     "alias": "NUM4",
     "domain": null
    },
    {
     "name": "NUM5",
     "type": "esriFieldTypeDouble",
     "alias": "NUM5",
     "domain": null
    },
    {
     "name": "DATE1",
     "type": "esriFieldTypeDate",
     "alias": "DATE1",
     "length": 8,
     "domain": null
    },
    {
     "name": "DATE2",
     "type": "esriFieldTypeDate",
     "alias": "DATE2",
     "length": 8,
     "domain": null
    },
    {
     "name": "DATE3",
     "type": "esriFieldTypeDate",
     "alias": "DATE3",
     "length": 8,
     "domain": null
    },
    {
     "name": "DATE4",
     "type": "esriFieldTypeDate",
     "alias": "DATE4",
     "length": 8,
     "domain": null
    },
    {
     "name": "DATE5",
     "type": "esriFieldTypeDate",
     "alias": "DATE5",
     "length": 8,
     "domain": null
    },
    {
     "name": "DISTRICT",
     "type": "esriFieldTypeString",
     "alias": "DISTRICT",
     "length": 50,
     "domain": null
    },
    {
     "name": "RESOLUTION",
     "type": "esriFieldTypeString",
     "alias": "RESOLUTION",
     "length": 100,
     "domain": null
    },
    {
     "name": "PRIMARYCONTRACTID",
     "type": "esriFieldTypeInteger",
     "alias": "PRIMARYCONTRACTID",
     "domain": null
    },
    {
     "name": "CONTRACTWOID",
     "type": "esriFieldTypeString",
     "alias": "CONTRACTWOID",
     "length": 30,
     "domain": null
    },
    {
     "name": "STREETNAME",
     "type": "esriFieldTypeString",
     "alias": "STREETNAME",
     "length": 50,
     "domain": null
    },
    {
     "name": "UNITSACCOMPDESCLOCK",
     "type": "esriFieldTypeString",
     "alias": "UNITSACCOMPDESCLOCK",
     "length": 1,
     "domain": null
    },
    {
     "name": "ISREACTIVE",
     "type": "esriFieldTypeString",
     "alias": "ISREACTIVE",
     "length": 1,
     "domain": null
    },
    {
     "name": "EFFORT",
     "type": "esriFieldTypeDouble",
     "alias": "EFFORT",
     "domain": null
    },
    {
     "name": "ACTIVITYZONE",
     "type": "esriFieldTypeString",
     "alias": "ACTIVITYZONE",
     "length": 50,
     "domain": null
    },
    {
     "name": "TEXT11",
     "type": "esriFieldTypeString",
     "alias": "TEXT11",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT12",
     "type": "esriFieldTypeString",
     "alias": "TEXT12",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT13",
     "type": "esriFieldTypeString",
     "alias": "TEXT13",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT14",
     "type": "esriFieldTypeString",
     "alias": "TEXT14",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT15",
     "type": "esriFieldTypeString",
     "alias": "TEXT15",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT16",
     "type": "esriFieldTypeString",
     "alias": "TEXT16",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT17",
     "type": "esriFieldTypeString",
     "alias": "TEXT17",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT18",
     "type": "esriFieldTypeString",
     "alias": "TEXT18",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT19",
     "type": "esriFieldTypeString",
     "alias": "TEXT19",
     "length": 100,
     "domain": null
    },
    {
     "name": "TEXT20",
     "type": "esriFieldTypeString",
     "alias": "TEXT20",
     "length": 100,
     "domain": null
    },
    {
     "name": "GUID",
     "type": "esriFieldTypeString",
     "alias": "GUID",
     "length": 50,
     "domain": null
    },
    {
     "name": "INITIATEDBYAPP",
     "type": "esriFieldTypeString",
     "alias": "INITIATEDBYAPP",
     "length": 50,
     "domain": null
    },
    {
     "name": "SUPERVISORSID",
     "type": "esriFieldTypeInteger",
     "alias": "SUPERVISORSID",
     "domain": null
    },
    {
     "name": "REQUESTEDBYSID",
     "type": "esriFieldTypeInteger",
     "alias": "REQUESTEDBYSID",
     "domain": null
    },
    {
     "name": "INITIATEDBYSID",
     "type": "esriFieldTypeInteger",
     "alias": "INITIATEDBYSID",
     "domain": null
    },
    {
     "name": "SUBMITTOSID",
     "type": "esriFieldTypeInteger",
     "alias": "SUBMITTOSID",
     "domain": null
    },
    {
     "name": "SUBMITTOOPENBYSID",
     "type": "esriFieldTypeInteger",
     "alias": "SUBMITTOOPENBYSID",
     "domain": null
    },
    {
     "name": "WORKCOMPLETEDBYSID",
     "type": "esriFieldTypeInteger",
     "alias": "WORKCOMPLETEDBYSID",
     "domain": null
    },
    {
     "name": "CANCELLEDBYSID",
     "type": "esriFieldTypeInteger",
     "alias": "CANCELLEDBYSID",
     "domain": null
    },
    {
     "name": "CLOSEDBYSID",
     "type": "esriFieldTypeInteger",
     "alias": "CLOSEDBYSID",
     "domain": null
    },
    {
     "name": "WORKORDERSID",
     "type": "esriFieldTypeDouble",
     "alias": "WORKORDERSID",
     "domain": null
    },
    {
     "name": "DomainName",
     "type": "esriFieldTypeString",
     "alias": "DomainName",
     "length": 30,
     "domain": null
    },
    {
     "name": "FACILITY_ID",
     "type": "esriFieldTypeString",
     "alias": "FACILITY_ID",
     "length": 256,
     "domain": null
    },
    {
     "name": "LEVEL_ID",
     "type": "esriFieldTypeString",
     "alias": "LEVEL_ID",
     "length": 256,
     "domain": null
    },
    {
     "name": "PROJECTPHASEID",
     "type": "esriFieldTypeInteger",
     "alias": "PROJECTPHASEID",
     "domain": null
    },
    {
     "name": "WOZCOORDINATE",
     "type": "esriFieldTypeDouble",
     "alias": "WOZCOORDINATE",
     "domain": null
    },
    {
     "name": "PERFORMANCEBUDGETID",
     "type": "esriFieldTypeInteger",
     "alias": "PERFORMANCEBUDGETID",
     "domain": null
    },
    {
     "name": "ESRI_OID",
     "type": "esriFieldTypeOID",
     "alias": "ESRI_OID",
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 20000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "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": "5c2f91786d194d1ba5352dd86b3f6ac3"
  }
 ]
}