{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 21,
 "name": "ProdGeoDB.REGIONALWATER.OwnershipPropertyReports",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "STREET_NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "LRO_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "Land Registry Office",
   "length": 2,
   "domain": {
    "type": "codedValue",
    "name": "Teranet_LandRegistrationOffices",
    "description": "Teranet - Land Registration Offices",
    "codedValues": [
     {
      "name": "Algoma",
      "code": "1"
     },
     {
      "name": "Brant",
      "code": "2"
     },
     {
      "name": "Bruce",
      "code": "3"
     },
     {
      "name": "Ottawa-Carleton",
      "code": "4"
     },
     {
      "name": "Cochrane",
      "code": "6"
     },
     {
      "name": "Dufferin",
      "code": "7"
     },
     {
      "name": "Dundas",
      "code": "8"
     },
     {
      "name": "Elgin",
      "code": "11"
     },
     {
      "name": "Essex",
      "code": "12"
     },
     {
      "name": "Frontenac",
      "code": "13"
     },
     {
      "name": "Glengarry",
      "code": "14"
     },
     {
      "name": "Grenville",
      "code": "15"
     },
     {
      "name": "Grey",
      "code": "16"
     },
     {
      "name": "Haldimand",
      "code": "18"
     },
     {
      "name": "Haliburton",
      "code": "19"
     },
     {
      "name": "Halton",
      "code": "20"
     },
     {
      "name": "Hastings",
      "code": "21"
     },
     {
      "name": "Huron",
      "code": "22"
     },
     {
      "name": "Kenora",
      "code": "23"
     },
     {
      "name": "Kent",
      "code": "24"
     },
     {
      "name": "Lambton",
      "code": "25"
     },
     {
      "name": "Lanark",
      "code": "27"
     },
     {
      "name": "Leeds",
      "code": "28"
     },
     {
      "name": "Lennox",
      "code": "29"
     },
     {
      "name": "Niagara North",
      "code": "30"
     },
     {
      "name": "Manitoulin",
      "code": "31"
     },
     {
      "name": "Middlesex",
      "code": "33"
     },
     {
      "name": "Muskoka",
      "code": "35"
     },
     {
      "name": "Nipissing",
      "code": "36"
     },
     {
      "name": "Norfolk",
      "code": "37"
     },
     {
      "name": "Northumberland",
      "code": "39"
     },
     {
      "name": "Durham",
      "code": "40"
     },
     {
      "name": "Oxford",
      "code": "41"
     },
     {
      "name": "Parry Sound",
      "code": "42"
     },
     {
      "name": "Peel",
      "code": "43"
     },
     {
      "name": "Perth",
      "code": "44"
     },
     {
      "name": "Peterborough",
      "code": "45"
     },
     {
      "name": "Prescott",
      "code": "46"
     },
     {
      "name": "Prince Edward",
      "code": "47"
     },
     {
      "name": "Rainy River",
      "code": "48"
     },
     {
      "name": "Renfrew",
      "code": "49"
     },
     {
      "name": "Russell",
      "code": "50"
     },
     {
      "name": "Simcoe",
      "code": "51"
     },
     {
      "name": "Stormont",
      "code": "52"
     },
     {
      "name": "Sudbury",
      "code": "53"
     },
     {
      "name": "Timiskaming",
      "code": "54"
     },
     {
      "name": "Thunder Bay",
      "code": "55"
     },
     {
      "name": "Victoria",
      "code": "57"
     },
     {
      "name": "Waterloo",
      "code": "58"
     },
     {
      "name": "Niagara South",
      "code": "59"
     },
     {
      "name": "Wellington",
      "code": "61"
     },
     {
      "name": "Hamilton Wentworth",
      "code": "62"
     },
     {
      "name": "York Region",
      "code": "65"
     },
     {
      "name": "Toronto",
      "code": "80"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PIN",
   "type": "esriFieldTypeInteger",
   "alias": "Property Identification No.",
   "domain": null
  },
  {
   "name": "STREET_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "Street No.",
   "length": 10,
   "domain": null
  },
  {
   "name": "STREET_NAME",
   "type": "esriFieldTypeString",
   "alias": "Street Name",
   "length": 34,
   "domain": null
  },
  {
   "name": "STREET_SUFFIX",
   "type": "esriFieldTypeString",
   "alias": "Street Suffix",
   "length": 6,
   "domain": null
  },
  {
   "name": "UNIT_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Unit Type",
   "length": 6,
   "domain": {
    "type": "codedValue",
    "name": "Teranet_UnitTypes",
    "description": "Teranet - Unit Types",
    "codedValues": [
     {
      "name": "Apartment",
      "code": "A"
     },
     {
      "name": "Number",
      "code": "N"
     },
     {
      "name": "Penthouse",
      "code": "P"
     },
     {
      "name": "Suite",
      "code": "S"
     },
     {
      "name": "Townhouse",
      "code": "T"
     },
     {
      "name": "Unit",
      "code": "U"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "UNIT_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "Unit No.",
   "length": 6,
   "domain": null
  },
  {
   "name": "MUNICIPALITY_NAME",
   "type": "esriFieldTypeString",
   "alias": "Municipality",
   "length": 24,
   "domain": null
  },
  {
   "name": "DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "Legal Description",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "OWNER_NAME_1",
   "type": "esriFieldTypeString",
   "alias": "Owner (1)",
   "length": 128,
   "domain": null
  },
  {
   "name": "OWNER_NAME_2",
   "type": "esriFieldTypeString",
   "alias": "Owner (2)",
   "length": 128,
   "domain": null
  },
  {
   "name": "OWNER_NAME_3",
   "type": "esriFieldTypeString",
   "alias": "Owner (3)",
   "length": 128,
   "domain": null
  },
  {
   "name": "OWNER_NAME_MORE",
   "type": "esriFieldTypeString",
   "alias": "Additional Owners (Y/N)",
   "length": 1,
   "domain": null
  },
  {
   "name": "REGISTRATION_SYSTEM",
   "type": "esriFieldTypeString",
   "alias": "Registration System",
   "length": 1,
   "domain": null
  },
  {
   "name": "INSTRUMENT_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "Instrument No.",
   "length": 10,
   "domain": null
  },
  {
   "name": "INSTRUMENT_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Instrument Type (code)",
   "length": 8,
   "domain": {
    "type": "codedValue",
    "name": "Teranet_InstrumentTypes",
    "description": "Teranet - Instrument Types",
    "codedValues": [
     {
      "name": "Crown Grant Public Lands Act",
      "code": "CGPLA  "
     },
     {
      "name": "Crown Patent",
      "code": "CP"
     },
     {
      "name": "Deed Pool",
      "code": "DP"
     },
     {
      "name": "Judgement Final Order of Foreclosure",
      "code": "JFOF   "
     },
     {
      "name": "Transfer (Grant)",
      "code": "T"
     },
     {
      "name": "Transfer Under Power of Sale (Grant)",
      "code": "TPSA   "
     },
     {
      "name": "Transmission by Personal Representative (Land)",
      "code": "TRAPL  "
     },
     {
      "name": "Quit Claim (Transfer)",
      "code": "QC"
     },
     {
      "name": "Transfer by Partnership",
      "code": "TLP"
     },
     {
      "name": "Transfer by Personal Representative",
      "code": "TPR"
     },
     {
      "name": "Transfer by Religious Organization",
      "code": "TRO"
     },
     {
      "name": "Transfer: Trustee In Bankruptcy",
      "code": "TTRBK"
     },
     {
      "name": "Letters Patent",
      "code": "LETPAFT"
     },
     {
      "name": "Application for Vesting Order",
      "code": "APLVO"
     },
     {
      "name": "Transfer Administrators (Grant)",
      "code": "TAD"
     },
     {
      "name": "Transfer and Appointment (Grant)",
      "code": "TAPOINT"
     },
     {
      "name": "Transfer Executors (Grant)",
      "code": "TEXEC"
     },
     {
      "name": "Transfer to Uses (Grant)",
      "code": "TUSES"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CONSIDERATION_AMOUNT",
   "type": "esriFieldTypeDouble",
   "alias": "Consideration Amount",
   "domain": null
  },
  {
   "name": "REGISTRATION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Registration Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PARTY_TO_1",
   "type": "esriFieldTypeString",
   "alias": "Party To (1)",
   "length": 128,
   "domain": null
  },
  {
   "name": "PARTY_TO_2",
   "type": "esriFieldTypeString",
   "alias": "Party To (2)",
   "length": 128,
   "domain": null
  },
  {
   "name": "PARTY_TO_3",
   "type": "esriFieldTypeString",
   "alias": "Party To (3)",
   "length": 128,
   "domain": null
  },
  {
   "name": "PARTY_TO_MORE",
   "type": "esriFieldTypeString",
   "alias": "Additional Party To (Y/N)",
   "length": 1,
   "domain": null
  },
  {
   "name": "PARTY_FROM_1",
   "type": "esriFieldTypeString",
   "alias": "Party From (1)",
   "length": 128,
   "domain": null
  },
  {
   "name": "PARTY_FROM_2",
   "type": "esriFieldTypeString",
   "alias": "Party From (2)",
   "length": 128,
   "domain": null
  },
  {
   "name": "PARTY_FROM_3",
   "type": "esriFieldTypeString",
   "alias": "Party From (3)",
   "length": 128,
   "domain": null
  },
  {
   "name": "PARTY_FROM_MORE",
   "type": "esriFieldTypeString",
   "alias": "Additional Party From (Y/N)",
   "length": 1,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R598_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G1178PIN",
   "fields": "PIN",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "OwnershipParcels",
   "relatedTableId": 12,
   "role": "esriRelRoleDestination",
   "keyField": "PIN",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{7F1D1C98-FE6E-4586-99DD-D2164A786DB6}"
  }
 ],
 "capabilities": "Data,Map,Query",
 "maxRecordCount": 1000,
 "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,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": false,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}