ericjarvies
2/10/2017 - 8:14 AM

Vancouver

Vancouver

Neighborhoods

ARBUTUS RIDGE
DOWNTOWN
DOWNTOWN EASTSIDE
DUNBAR-SOUTHLANDS
FAIRVIEW
GRANDVIEW-WOODLAND
HASTINGS-SUNRISE
KENSINGTON-CEDAR COTTAGE
KERRISDALE
KILLARNEY
KITSLANO
MARPOLE
MOUNT PLEASANT
OAKRIDGE
RENFREW-COLLINGWOOD
RILEY PARK
SHAUGHNESSY
SOUTH CAMBIE
STRATHCONA
SUNSET
VICTORIA-FRASERVIEW
WEST END
WEST POINT GREY

Vancouver Open GIS

  1. Download shp and csv data files
  2. Suffix file name with MM-DD-YYYY
  3. Reproject shapefiles to WGS84
  4. Import csv file (including non-matching data) and output point shapefile
  5. Create rowIndex in shapefiles
  6. Move into git version controlled folder and git add . & git commit -m "02-10-2017 Initial commit of reprojected WGS84 and added rowIndex column"
  7. Convert shapefiles into GeoJSON files mapshaper *.shp -o format=geojson -o extension=geojson
http://data.vancouver.ca/datacatalogue/index.htm

ICIS_AddressBC.csv
  CIVIC_ID  √
  SITE_ID
  LATITUDE  √
  LONGITUDE √
  GEOGRAPHIC_DOMAIN
  ADDRESS_POINT_TYPE
  FULL_ADDRESS  √
  STREET_NUMBER_PREFIX
  STREET_NUMBER √
  STREET_NUMBER_SUFFIX
  STREET_DIR_PREFIX √
  STREET_NAME √
  STREET_TYPE √
  STREET_DIR_SUFFIX √
  LOCALITY
  LOCALITY_NAME_ALIAS
  MUNI_ID
  ISSUING_AGENCY
  COLLECTION_METHOD
  CREATED_BY
  CREATION_DATE
  RETIRED_DATE
  LAST_MODIFIED_BY
  LAST_MODIFIED_DATE
  
ICIS_GIS.shp (polygon)
  PID
  PARCEL_ID
  LEGAL_DESC
  
property_cadastral_boundaries.shp (polyline)
  DIMENSIONS
  TYPE

property_parcel_polygons.shp (polygon)
  SITE_ID
  CIVIC_NO
  STREETNAME
  TAX_COORD
  
property_tax_report_2016.csv
  PID
  LEGAL_TYPE
  FOLIO
  LAND_COORDINATE
  ZONE_NAME
  ZONE_CATEGORY
  LOT
  BLOCK
  PLAN
  DISTRICT_LOT
  FROM_CIVIC_NUMBER
  TO_CIVIC_NUMBER
  STREET_NAME
  PROPERTY_POSTAL_CODE
  NARRATIVE_LEGAL_LINE1
  NARRATIVE_LEGAL_LINE2
  NARRATIVE_LEGAL_LINE3
  NARRATIVE_LEGAL_LINE4
  NARRATIVE_LEGAL_LINE5
  CURRENT_LAND_VALUE
  CURRENT_IMPROVEMENT_VALUE
  TAX_ASSESSMENT_YEAR
  PREVIOUS_LAND_VALUE
  PREVIOUS_IMPROVEMENT_VALUE
  YEAR_BUILT
  BIG_IMPROVEMENT_YEAR
  TAX_LEVY
  NEIGHBOURHOOD_CODE
  
tie-lines.shp

Property Inquiry

Search by Civic Address, Folio, PID, and Plan;

https://revservices.vancouver.ca/tempestprd/webinquiry/frames.cfm

Result;

PID 002-511-649
Property No.  1290048
Civic Address 4430 CYPRESS ST
Folio 097-717-82-0000
Map Ref.  002511649
Plan  VAP6011
Lot 6
Block 706
MHR
Status

MyLTSA

Fetch Owner Name & Title Number (first login to MyLTSA);

https://apps.ltsa.ca/srs/api/titleSummaries/user/7@ericjarvies.com%3Bpids=002-511-649%3BfileReference=%3BselectedDistrictCode=ALL%3BselectedDistrictName=%3BincludeCancelledTitles=N?t=1485855234927

Fetch Owner Name & Title Number for multiple PIDs (first login to MyLTSA);

https://apps.ltsa.ca/srs/api/titleSummaries/user/7@ericjarvies.com%3Bpids=002-511-649:002-511-649%3BfileReference=%3BselectedDistrictCode=ALL%3BselectedDistrictName=%3BincludeCancelledTitles=N?t=1485855234927

Fetch Owner Name, Previous Owner Names, and Title number (first login to MyLTSA);

https://apps.ltsa.ca/srs/api/titleSummaries/user/7@ericjarvies.com%3Bpids=011-542-641%3BfileReference=%3BselectedDistrictCode=ALL%3BselectedDistrictName=%3BincludeCancelledTitles=Y?t=1485910928995

Result;

<TitleSummaries>
  <errors/>
  <itemsPerPage>20</itemsPerPage>
  <titleSearchResultByPidorShortLegal>
    <errors/>
    <pid>003-295-851</pid>
    <shortLegal>S/16072/////1</shortLegal>
    <titleSummary>
      <errors/>
      <concatShortLegal>
        0000000000000016072 00001 003295851001
      </concatShortLegal>
      <firstOwner>SAVICKY, ANN</firstOwner>
      <fullLegalDescription>
        LOT 1 DISTRICT LOT 135 GROUP 1 NEW WESTMINSTER DISTRICT PLAN 16072
      </fullLegalDescription>
      <index>1</index>
      <landTitleDistrict>NW</landTitleDistrict>
      <pid>003-295-851</pid>
      <shortLegal>S/16072/////1</shortLegal>
      <status>REGISTERED</status>
      <strataPlanCommonProperty>false</strataPlanCommonProperty>
      <titleNumber>AA65294E</titleNumber>
    </titleSummary>
  </titleSearchResultByPidorShortLegal>
  <titleSearchResultByPidorShortLegal>
    <errors/>
    <pid>011-156-635</pid>
    <shortLegal>S/5453/////2//6</shortLegal>
    <titleSummary>
      <errors/>
      <concatShortLegal>
        0000000000000005453 00002 006 011156635001
      </concatShortLegal>
      <firstOwner>WANG, LIBO</firstOwner>
      <fullLegalDescription>LOT 6 OF LOT 2 BLOCK 17 DISTRICT LOT 526 PLAN 5453</fullLegalDescription>
      <index>1</index>
      <landTitleDistrict>VA</landTitleDistrict>
      <pid>011-156-635</pid>
      <shortLegal>S/5453/////2//6</shortLegal>
      <status>REGISTERED</status>
      <strataPlanCommonProperty>false</strataPlanCommonProperty>
      <titleNumber>CA1340431</titleNumber>
    </titleSummary>
  </titleSearchResultByPidorShortLegal>
</TitleSummaries>

ICIS

Fetch by PID;

http://bcspatial.icisociety.ca/webservices/rest/services/Cadastral_Data_Public/MapServer/1/query?f=json&outFields=*&where=PID='003295851'

Result;

{
 "displayFieldName": "STREET_NAME",
 "fieldAliases": {
  "OBJECTID": "OBJECTID",
  "REGIONAL_DISTRICT": "REGIONAL_DISTRICT",
  "PROJECT": "PROJECT",
  "DATA_SOURCE_LINK_ID": "DATA_SOURCE_LINK_ID",
  "PID": "PID",
  "PIN": "PIN",
  "JUROL": "JUROL",
  "LAND_DISTRICT": "LAND_DISTRICT",
  "ICF_LEGAL_DESCRIPTION": "ICF_LEGAL_DESCRIPTION",
  "LTSA_LOT": "LTSA_LOT",
  "LTSA_BLOCK": "LTSA_BLOCK",
  "LTSA_PARCEL": "LTSA_PARCEL",
  "LTSA_PLAN": "LTSA_PLAN",
  "LEGAL_FREEFORM": "LEGAL_FREEFORM",
  "LAND_ACT_PRIMARY_DESCRIPTION": "LAND_ACT_PRIMARY_DESCRIPTION",
  "OWNERSHIP_CLASS": "OWNERSHIP_CLASS",
  "ADDRESS_CUSTODIAN": "ADDRESS_CUSTODIAN",
  "ADDRESS_REFERENCE": "ADDRESS_REFERENCE",
  "ADDRESS_TYPE": "ADDRESS_TYPE",
  "UNIT_NUMBER": "UNIT_NUMBER",
  "CIVIC_NUMBER": "CIVIC_NUMBER",
  "CIVIC_NUMBER_SUFFIX": "CIVIC_NUMBER_SUFFIX",
  "STREET_NAME": "STREET_NAME",
  "STREET_TYPE": "STREET_TYPE",
  "STREET_DIRECTION": "STREET_DIRECTION",
  "ALTERNATE_PLACE_NAME": "ALTERNATE_PLACE_NAME",
  "MUNICIPALITY": "MUNICIPALITY",
  "CAPTURE_METHOD": "CAPTURE_METHOD",
  "POSITIONAL_ACCURACY": "POSITIONAL_ACCURACY",
  "LAST_UPDATE_DATE": "LAST_UPDATE_DATE",
  "SOURCE_PROVISION_DATE": "SOURCE_PROVISION_DATE"
 },
 "geometryType": "esriGeometryPolygon",
 "spatialReference": {
  "wkt": "PROJCS[\"NAD_1983_Albers\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Albers\"],PARAMETER[\"False_Easting\",1000000.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-126.0],PARAMETER[\"Standard_Parallel_1\",50.0],PARAMETER[\"Standard_Parallel_2\",58.5],PARAMETER[\"Latitude_Of_Origin\",45.0],UNIT[\"Meter\",1.0]]"
 },
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID"
  },
  {
   "name": "REGIONAL_DISTRICT",
   "type": "esriFieldTypeString",
   "alias": "REGIONAL_DISTRICT",
   "length": 30
  },
  {
   "name": "PROJECT",
   "type": "esriFieldTypeString",
   "alias": "PROJECT",
   "length": 30
  },
  {
   "name": "DATA_SOURCE_LINK_ID",
   "type": "esriFieldTypeString",
   "alias": "DATA_SOURCE_LINK_ID",
   "length": 50
  },
  {
   "name": "PID",
   "type": "esriFieldTypeString",
   "alias": "PID",
   "length": 30
  },
  {
   "name": "PIN",
   "type": "esriFieldTypeString",
   "alias": "PIN",
   "length": 30
  },
  {
   "name": "JUROL",
   "type": "esriFieldTypeString",
   "alias": "JUROL",
   "length": 30
  },
  {
   "name": "LAND_DISTRICT",
   "type": "esriFieldTypeString",
   "alias": "LAND_DISTRICT",
   "length": 32
  },
  {
   "name": "ICF_LEGAL_DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "ICF_LEGAL_DESCRIPTION",
   "length": 255
  },
  {
   "name": "LTSA_LOT",
   "type": "esriFieldTypeString",
   "alias": "LTSA_LOT",
   "length": 16
  },
  {
   "name": "LTSA_BLOCK",
   "type": "esriFieldTypeString",
   "alias": "LTSA_BLOCK",
   "length": 16
  },
  {
   "name": "LTSA_PARCEL",
   "type": "esriFieldTypeString",
   "alias": "LTSA_PARCEL",
   "length": 16
  },
  {
   "name": "LTSA_PLAN",
   "type": "esriFieldTypeString",
   "alias": "LTSA_PLAN",
   "length": 32
  },
  {
   "name": "LEGAL_FREEFORM",
   "type": "esriFieldTypeString",
   "alias": "LEGAL_FREEFORM",
   "length": 32
  },
  {
   "name": "LAND_ACT_PRIMARY_DESCRIPTION",
   "type": "esriFieldTypeString",
   "alias": "LAND_ACT_PRIMARY_DESCRIPTION",
   "length": 255
  },
  {
   "name": "OWNERSHIP_CLASS",
   "type": "esriFieldTypeString",
   "alias": "OWNERSHIP_CLASS",
   "length": 32
  },
  {
   "name": "ADDRESS_CUSTODIAN",
   "type": "esriFieldTypeString",
   "alias": "ADDRESS_CUSTODIAN",
   "length": 50
  },
  {
   "name": "ADDRESS_REFERENCE",
   "type": "esriFieldTypeString",
   "alias": "ADDRESS_REFERENCE",
   "length": 30
  },
  {
   "name": "ADDRESS_TYPE",
   "type": "esriFieldTypeString",
   "alias": "ADDRESS_TYPE",
   "length": 12
  },
  {
   "name": "UNIT_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "UNIT_NUMBER",
   "length": 10
  },
  {
   "name": "CIVIC_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "CIVIC_NUMBER",
   "length": 15
  },
  {
   "name": "CIVIC_NUMBER_SUFFIX",
   "type": "esriFieldTypeString",
   "alias": "CIVIC_NUMBER_SUFFIX",
   "length": 10
  },
  {
   "name": "STREET_NAME",
   "type": "esriFieldTypeString",
   "alias": "STREET_NAME",
   "length": 40
  },
  {
   "name": "STREET_TYPE",
   "type": "esriFieldTypeString",
   "alias": "STREET_TYPE",
   "length": 16
  },
  {
   "name": "STREET_DIRECTION",
   "type": "esriFieldTypeString",
   "alias": "STREET_DIRECTION",
   "length": 16
  },
  {
   "name": "ALTERNATE_PLACE_NAME",
   "type": "esriFieldTypeString",
   "alias": "ALTERNATE_PLACE_NAME",
   "length": 32
  },
  {
   "name": "MUNICIPALITY",
   "type": "esriFieldTypeString",
   "alias": "MUNICIPALITY",
   "length": 50
  },
  {
   "name": "CAPTURE_METHOD",
   "type": "esriFieldTypeString",
   "alias": "CAPTURE_METHOD",
   "length": 12
  },
  {
   "name": "POSITIONAL_ACCURACY",
   "type": "esriFieldTypeString",
   "alias": "POSITIONAL_ACCURACY",
   "length": 12
  },
  {
   "name": "LAST_UPDATE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_UPDATE_DATE",
   "length": 36
  },
  {
   "name": "SOURCE_PROVISION_DATE",
   "type": "esriFieldTypeDate",
   "alias": "SOURCE_PROVISION_DATE",
   "length": 36
  }
 ],
 "features": [
  {
   "attributes": {
    "OBJECTID": 494005,
    "REGIONAL_DISTRICT": "GREATER VANCOUVER",
    "PROJECT": "BURNABY",
    "DATA_SOURCE_LINK_ID": "8057",
    "PID": "003295851",
    "PIN": null,
    "JUROL": null,
    "LAND_DISTRICT": "GROUP 1, NEW WESTMINSTER DIST",
    "ICF_LEGAL_DESCRIPTION": "L 1 DL 135 GP 1 NWD PL 16072",
    "LTSA_LOT": "1",
    "LTSA_BLOCK": null,
    "LTSA_PARCEL": null,
    "LTSA_PLAN": "16072",
    "LEGAL_FREEFORM": null,
    "LAND_ACT_PRIMARY_DESCRIPTION": "DL 135 GP 1 NWD",
    "OWNERSHIP_CLASS": "PRIVATE",
    "ADDRESS_CUSTODIAN": "LOCAL GOVERNMENT MUNICIPALITY",
    "ADDRESS_REFERENCE": null,
    "ADDRESS_TYPE": null,
    "UNIT_NUMBER": null,
    "CIVIC_NUMBER": "7320",
    "CIVIC_NUMBER_SUFFIX": null,
    "STREET_NAME": "CURTIS",
    "STREET_TYPE": "ST",
    "STREET_DIRECTION": null,
    "ALTERNATE_PLACE_NAME": null,
    "MUNICIPALITY": "BURNABY",
    "CAPTURE_METHOD": "COGO",
    "POSITIONAL_ACCURACY": "\u003c1",
    "LAST_UPDATE_DATE": null,
    "SOURCE_PROVISION_DATE": 1129075200000
   },
   "geometry": {
    "rings": [
     [
      [
       1222066.5098000008,
       477937.0728000002
      ],
      [
       1222036.4377000001,
       477935.76989999972
      ],
      [
       1222034.9080000003,
       477979.91860000044
      ],
      [
       1222064.9792999995,
       477981.23479999974
      ],
      [
       1222066.5098000008,
       477937.0728000002
      ]
     ]
    ]
   }
  }
 ]
}