SPIKE - Can we get PID via API to BC Data Warehouse

mbertucci commented 1 month ago

Objective

The purpose of this SPIKE is to explore and develop a solution that enables our system to automatically retrieve the Parcel Identification Number (PID) associated with a property parcel whenever a user enters their address into our system. This will involve integrating ParcelMap BC through the BC Data Warehouse API and ensuring real-time or near-real-time retrieval of PIDs.

Background

ParcelMap BC provides a digital representation of parcel boundaries across British Columbia, including PIDs. By leveraging the integration between ParcelMap BC and the BC Data Warehouse, we aim to automate the retrieval of PIDs based on user-provided addresses, enhancing the user experience and streamlining data collection processes.

Goals

Understand API Integration
- Identify the relevant API endpoints within the BC Data Warehouse that interact with ParcelMap BC for address-based PID retrieval.
- Confirm that these APIs support real-time querying based on user input.
Real-Time Data Retrieval
- Investigate how to structure our system’s API calls to ensure that PID retrieval occurs seamlessly as users enter their address.
- Assess the response time and data accuracy of the PID retrieval process to meet user experience standards.
User Interface and Workflow Integration
- Determine how to integrate this API call into our existing user interface (UI), ensuring that the PID is retrieved without disrupting the user’s workflow.
- Explore options for handling cases where no PID is found or where multiple PIDs might be associated with a single address.
Error Handling and Validation
- Implement robust error handling to manage cases where the API call fails or returns unexpected data.
- Validate the retrieved PID against our existing data to ensure consistency and correctness.
Security and Compliance
- Ensure that the retrieval process complies with privacy regulations and that sensitive data, such as PIDs, is handled securely.
- Review any additional security measures required for accessing and storing PIDs within our system.
Documentation and Support
- Compile documentation on the integration process, including API usage, error codes, and best practices for handling PIDs.
- Identify and engage with technical support from the BC Data Warehouse or ParcelMap BC if needed.

Deliverables

A working prototype that automatically retrieves a PID based on a user-entered address in our system.
Documentation outlining the API integration process, including how to handle various edge cases.
A report detailing the performance of the API calls, including any limitations or challenges encountered.
Recommendations for further development or optimization based on the prototype’s performance.

Timebox

Allocate 3-4 days for this investigation and prototype development, including research, coding, and documentation.

Team Members

[Assign team members here]

Resources

Notes

Ensure that the solution is user-friendly and does not add noticeable delays to the user’s workflow.
Document findings and steps clearly to support future iterations or potential scaling of this feature.

mbertucci commented 1 month ago

Host certificate: to be worked on

Paragraph locked by Zhou, Fiona HOUS:EX An updated version is provided with more conditions. It will require legal review first. It's likely that #6 and #7 conditions can be removed.

Nice to have: For the #1 condition, it can be configured based on whether the rental property has PR requirements or not.

Wording - change “described below” to “described above”

Start date is when system or examiner approves the application. For provisional approved applications, the start date is the date when provisional approval is granted.

Property address: remove BC, Canada and postal code. The address must include civic address and city where the jurisdiction is located.

It's rare but possible that additional specific conditions were added to the certificate. Examiners will handle this outside of the system so that the certificate will be fixed.

mbertucci commented 4 weeks ago

ParcelMap BC Overview: ParcelMap BC is a comprehensive, up-to-date digital representation of the cadastre in British Columbia. It includes parcel boundaries, PIDs, and other related attributes. The system is designed to be used by professionals and government agencies for land administration and property-related purposes.

Retrieving PID Using ParcelMap BC: Integration with BC Data Warehouse:

ParcelMap BC is integrated with various BC Government services, including the BC Data Warehouse. If you have access to ParcelMap BC through the Data Warehouse, you can retrieve PIDs by querying parcel data based on geographic or address information. APIs and Access:

The data from ParcelMap BC can be accessed through APIs provided by the BC Data Service. This allows you to input an address or geographic location and retrieve corresponding PIDs. Geographic and Land Title Data:

ParcelMap BC links land title data with geographic data. This means you can effectively use an address to identify the correct parcel and, consequently, retrieve the PID associated with that parcel. Next Steps:

mbertucci commented 3 weeks ago

PIMS users enter the PID manually for the most part. You can get PIDs from queries against the Parcel Map though. ParcelMap BC Parcel Fabric - Open Government Portal (canada.ca) ParcelMap BC Parcel Fabric - Open Government Portal ParcelMap BC is the current, complete and trusted mapped representation of titled and Crown land parcels across British Columbia, considered to be the point of truth for the graphical...