
Fechado
Publicado
Pago na entrega
I need an excel sheet with all buildings in Canada. You are expected to research on the internet yourself. I have provided 1 source below I expect you to put extensive research into other web sources I expect a full list of the sources of data You will eliminate the duplicates and provide a clean human readable results excel sheet. Example. I have an ODB database sourced from the Statistics Canada page ([login to view URL] ) that lists every non-residential building across Canada. I need the entire dataset— every province, every building— exported into a single, clean .xlsx workbook. In addition, I will need to have every Commercial and Residential low, medium and high-rise building in the Country. This data will be sources from the same suite and additional researched sources which you will be required to research. Low rise buildings have 4 floors or more and should start there. Again all buildings are divided into the noted segments by province and then by city. Please place all fields in one master sheet and activate an auto-filter row so I can sort and slice instantly. At minimum each record must include: 1) building name (if present) 2) street address, 3) city 4) province 5) latitude, longitude 6) number of floors 7) Include every other column that appears in the original ODB file or source website format file. There might be a need to scrape data as well. Both the full address string and the explicit lat/long coordinates have to be preserved so I can map or geocode later. The ODB occasionally stores lookup tables in separate relations; bring those values across so the sheet is human-readable— no foreign-key IDs left unresolved. If you use any transformation scripts (Python, LibreOffice Base, SQL, Power Query, etc.) please hand those over as well; I may need to re-run the process when updated releases appear. If I decide to add extra columns later, I’ll let you know, so keep your workflow flexible enough to accommodate a quick re-extract. Deliverables for acceptance: • Clean, filter-ready .xlsx file with every building in Canada • Any code or queries used for the export/conversion That’s all— looking forward to a smooth, accurate conversion.
ID do Projeto: 40281060
51 propostas
Projeto remoto
Ativo há 10 dias
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
51 freelancers estão ofertando em média $23 CAD for esse trabalho

Hello Sir, Would you like to see a demo of our approach by compiling a sample dataset before making any commitments? I am committed to delivering a comprehensive Excel sheet containing all buildings in Canada, meticulously researched and formatted to ensure clarity and usability. I invite you to discuss this proposal further so we can outline a detailed plan and initiate the demo process. Regards, Smith
$20 CAD em 7 dias
7,2
7,2

With my 15 years of experience as a multi-skilled professional, I'm confident that I can handle this project flawlessly. My expertise in web scraping, web research, and data management makes me perfect for this task. Over the years, I've successfully scraped data from dynamic and protected websites using powerful technologies like Python (Selenium, BeautifulSoup, Scrapy, Requests) and have outputted them in various formats such as CSV, Excel, JSON etc., just as you require. Moreover, I'm well-versed with carrying out extensive web searches as well as filtering and cleaning large datasets to ensure an outcome that is 100% accurate and free of duplicates. I understand the need for detail-oriented work in your project and can assure you of my commitment to maintaining the integrity of data at all times. I pride myself on quick response timing and full dedication which are qualities crucial for your project. Let me assure you; if given the opportunity to work on this project, I will not only meet but also exceed your expectations. Looking forward to collaborating with you on this exciting project!
$30 CAD em 1 dia
6,9
6,9

I can extract the full building dataset from Statistics Canada and other sources, merge residential and commercial records across all provinces, remove duplicates, and deliver a clean, filter-ready Excel workbook with address, coordinates, floors, and all available fields. All data sources will be documented, and any scripts used for scraping, cleaning, or merging (Python/SQL/Power Query) will be included for future updates. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$30 CAD em 1 dia
6,5
6,5

Hello, I can research and compile a complete, clean Excel dataset of buildings across Canada using the Statistics Canada ODB file along with additional verified sources. I will extract all provinces and cities, remove duplicates, resolve lookup tables, and ensure each record includes building name (if available), full address, city, province, latitude/longitude, number of floors, and all original fields. The final deliverable will be a well-structured, filter-ready .xlsx file with documented data sources, along with any scripts or queries used so the process can easily be rerun or updated in the future. Regards, Zafar
$30 CAD em 1 dia
6,2
6,2

Hello I can create a clean, filter-ready Excel sheet with all buildings in Canada, combining the Statistics Canada ODB dataset with additional research for Commercial and Residential low, medium, and high-rise buildings. Each record will include building name, full address, city, province, latitude/longitude, number of floors, and all other columns from the source files, with foreign-key IDs resolved. I will also provide a full list of sources and any scripts or queries used to extract and clean the data for future updates. Regards Muhammad
$30 CAD em 1 dia
5,6
5,6

Hello Dear, I have carefully reviewed your project requirements for ODB Buildings Data to Excel. I am confident I can deliver a complete, clean, and filter-ready .xlsx workbook covering every building across Canada non-residential, commercial, and residential (low, mid, and high-rise, 4+ floors). Why Choose Me? ✅ 10+ years of full-stack & data engineering experience ✅ Expert in Python, web scraping & Excel automation ✅ Clean, documented & reusable code delivered every time ✅ 100% deadline commitment — always on time ✅ Clear communication throughout the project ✅ Client satisfaction is my #1 priority Let's connect and get started immediately! Best Regards, Md Toriqul Islam
$45 CAD em 2 dias
5,0
5,0

As a seasoned Mechanical Engineer and data expert, I possess the skills necessary to execute your ODB Buildings Data to Excel project with precision and efficiency. My extensive experience in conducting technical research, proficiency in Python scripting for data scraping and automation workflows, and my expertise in Excel are all instrumental in carrying out this task. Ever committed to delivering top-quality results, I have successfully completed over 180 projects - many of which involved complex data gathering and processing tasks similar to what you require. With this practical knowledge at my fingertips, I can seamlessly merge all the relevant information from your ODB database with supplemented researched sources and furnish an exhaustive yet facile-to-use Canadian building dataset for you. Moreover, your request for a flexible workflow aligns with my approach as I understand that changes may occur along the way. You can trust me to handle any updates or modifications efficiently, alongside providing clear documentation of the transformation scripts employed (e.g. Python or SQL). In choosing me for this project, you are opting for uncompromising attention to detail, timely delivery and a dedication to surpass your expectations at every turn. Let's leverage your ODB data into powerful insights together!
$30 CAD em 1 dia
5,2
5,2

I'm Eyesha, an expert in data analysis, processing, and advanced Excel skills. I've had substantial experience working on similar projects, including web research and consolidating data into clean, organized Excel files. Through rigorous investigation techniques—like scraping data and exploring multiple web sources—I can assure you a comprehensive compilation of all the commercial and residential low, medium and high-rise buildings across Canada. When it comes to data filtering and organization, my proficiency in using VBA and creating macros will come in handy. You require an auto-filter functionality to instantly sort and slice through the dataset, consider it done. Moreover, I'm skilled at preserving crucial information like the full address string and the explicit lat/long coordinates; this will ensure that the data remains practical for mapping or geocoding purposes. I am committed to delivering clean, human-readable outputs that maintain the integrity of all the necessary lookup tables without any unresolved foreign-key IDs. My work is not only structured but also designed to be flexible enough to cater to any future changes you may require in terms of added columns or re-running processes. Trust me for a smooth, accurate conversion you need for this project.
$20 CAD em 1 dia
4,8
4,8

Hi sir, I have a lot experience I can be the best for your project. I will do this project without any mistake. You can trust me. Please give me a chance so that I can show you my skill and tell you about my hard work.
$10 CAD em 1 dia
4,6
4,6

Hope you are doing well! The project requires extracting a nationwide building dataset from the Statistics Canada ODB and additional researched sources, so careful handling of relational tables, duplicate removal, and consistent address and coordinate formatting will be essential. Common challenges in similar data projects include unresolved foreign keys from ODB databases, inconsistent building naming across sources, and incomplete geolocation fields that require normalization. Strong experience exists in large-scale data extraction, web scraping, and dataset consolidation using tools such as Python, SQL queries, and spreadsheet transformation workflows. Previous projects involved converting government and open-data databases into clean Excel datasets where multiple lookup tables had to be merged to produce human-readable records. One project encountered heavy duplication across regional datasets, which was resolved through address standardization and coordinate-based duplicate detection. I know what do I build for you, can complete it to your full satisfaction within your timeline. I am ready for you and waiting here. Thank you.
$20 CAD em 7 dias
3,0
3,0

Hello, I read your project and understand you need a clean Excel sheet of buildings across Canada using the Statistics Canada ODB dataset and additional researched sources, with duplicates removed. I will deliver a single, filter-ready .xlsx master sheet including building name, full address, city, province, latitude/longitude, floors, and all available fields, plus a list of sources and any scripts/queries used. Ready to start once the source file is shared.
$20 CAD em 2 dias
3,1
3,1

I understand you require a comprehensive and clean Excel workbook listing every building in Canada, including commercial and residential low, medium, and high-rise buildings, with all relevant data fields and geospatial coordinates. You want duplicates removed, lookup tables resolved for readability, and all sources documented, with the ability to re-run the extraction using provided scripts. With over 15 years of experience and 200+ projects completed, I specialize in Python-driven data processing, API integration, and web scraping, which are essential for gathering and consolidating data from Statistics Canada and additional sources. My expertise in database design and Excel automation ensures the final file will be filter-ready and easy to navigate. I will build a flexible Python workflow to scrape, clean, and merge building datasets, resolving foreign keys and preserving lat/long data accurately. The output will be a single master .xlsx file with an active filter row, accompanied by all scripts and queries for future updates. I estimate this can be delivered within a few days, depending on data volume. Let’s discuss your priorities and any specifics you want me to focus on for the initial data extraction.
$11 CAD em 7 dias
2,4
2,4

Hi there! Collecting building data from multiple sources across Canada can become complex due to duplicates, missing coordinates, and inconsistent formats. I understand you need a clean, well-structured Excel dataset that includes every building with accurate fields and proper sources. I have experience working with large datasets, web research, and data extraction. I’ve handled projects involving government datasets, database exports, and Excel data cleanup while maintaining data accuracy. I’m also comfortable using tools like Excel, Power Query, and Python when needed to process and organize large amounts of data. My approach will start by extracting the full dataset from the Statistics Canada ODB source and converting all related tables into readable columns. Then I will research additional reliable sources to gather commercial and residential building data across all provinces and cities. After combining the datasets, I will remove duplicates, standardize addresses and formats, and ensure latitude and longitude values remain intact. The final Excel sheet will include all original fields, be fully human-readable, and have filters enabled so you can easily sort and analyze the data. check our work https://www.freelancer.com/u/ayesha86664 Would you like the buildings also categorized by type such as commercial, residential low-rise, mid-rise, and high-rise? Let me know if you’re interested & we can discuss it. Best Regards Ayesha
$20 CAD em 1 dia
2,6
2,6

Hello, I’ve read your brief carefully and I’m confident I can produce a single, clean .xlsx containing every non-residential and residential low/medium/high-rise building in Canada, with duplicates removed, source lists, and reusable extraction scripts. I’m a Django developer with practical experience building maintainable APIs (DRF), clean models and authentication, skills that shape how I design reliable, repeatable ETL pipelines and schema mappings so your master sheet stays clear and extensible. I will: research the provided Statistics Canada ODB source plus provincial and municipal building registries, scrape or ingest available distributions, resolve lookup tables into human-readable values, geocode/preserve lat-long and full address strings, supply transformation scripts (Python/SQL/Power Query) and deliver an auto-filter-ready workbook. Next step: I’ll prepare a sampling workflow and source inventory so you can approve the approach before full extraction. Which provinces or city datasets (if any) would you like prioritized first for the sampling workflow and source inventory? Sincerely, Cindy Viorina
$10 CAD em 15 dias
2,2
2,2

Hi, I am Abutalha, and I have experience with data collection, web research, scraping, and preparing structured datasets in Excel. I have worked with large datasets and can clean, merge, and organize data from multiple sources into a clear, usable format. For this task, I will collect the full building dataset from the Statistics Canada ODB source and research additional reliable sources to include residential and commercial buildings across all provinces. I will extract the data, merge multiple datasets, remove duplicates, and resolve lookup tables so everything is human-readable. Each record will include building name (if available), full address, city, province, latitude, longitude, number of floors, and any other fields from the original sources. The final dataset will be organized in one master Excel sheet with filters enabled for easy sorting and analysis. You will receive a clean, filter-ready .xlsx file with the full compiled dataset, a list of all data sources used, and any scripts or queries (Python/SQL/Power Query) used for extraction and processing so the workflow can be reused or updated later. Best regards, Abutalha.
$30 CAD em 6 dias
2,0
2,0

✔✔✔Hold on!! Looking for a Developer Who Gets Results? Hire Me, Relax, and Watch Your Project Turn Into Success✔✔✔ Hello, Before jumping into solutions, I focus on fully understanding the goal of the project and the real problem that needs to be solved. Clear communication and quick feedback are the keys to finishing projects smoothly and on time. I always keep clients updated, share progress frequently, and stay available for real-time discussion when needed. This helps avoid delays and ensures the final result matches expectations perfectly. If you’re looking for someone reliable who treats your project seriously and focuses on delivering results, I’d be happy to discuss the details and get started. Let’s talk and make this project a success. Best Regars Anton
$20 CAD em 7 dias
1,4
1,4

Hello, My name is Muhammad Azeem. I am a Python Automation Specialist and Data Analyst with hands-on experience in building automation scripts and data-driven solutions. I have worked on multiple projects involving web automation, data extraction, and workflow automation using tools such as Python, Selenium, Playwright, and APIs. I can efficiently automate repetitive tasks, scrape and process data, and build reliable scripts tailored to your requirements. I focus on writing clean, efficient, and scalable code to ensure the automation runs smoothly and saves time. I believe I am a strong fit for your project and would be happy to discuss your requirements in detail. Looking forward to your response. Best regards, Muhammad Azeem
$19 CAD em 7 dias
1,1
1,1

As a professional in the realm of Full-Stack development and Data Integration, I am equipped with the right skills and mindset to tackle your project. With over a decade of experience, I have ventured into emerging technologies, AI projects, and data integration which are all essential components of this project. Your project entails not just data extraction and conversion but also involves addressing possible issues like duplicates and conversion updates; areas in which I have proven expertise. Moreover, my ability in web scraping and script writing using Python will prove invaluable in sourcing data from various web sources as you've requested. Over my career, I've worked extensively with APIs, modern databases like MongoDB (which preserves full address string) as well as Power Query (which retains data fidelity). These experiences ensure that your desire for a clean, comprehensive xlsx file with every building in Canada can be met. To further assure you of my worthiness for this task, let me briefly share a story of import. In the past, I assisted a retailer by revamping their buggy checkout system that was costin
$60 CAD em 7 dias
3,3
3,3

Hello there What is the biggest challenge you foresee in ensuring the data from various sources is consistent and reliable across all provinces and building types? How do you want to handle potential missing or incomplete data, especially for fields like building name or precise latitude and longitude? Combining datasets from multiple sources is complex due to differing formats and possible inconsistencies. Ensuring accuracy while eliminating duplicates and preserving valuable metadata requires careful cross-validation. I will research extensively online to find supplementary sources and gather all data, then clean and combine it into one Excel sheet with a single master filter for easy use. I will include all requested columns and ensure the sheet is human-readable without unresolved IDs. Alongside, I will supply any scripts or queries needed for the conversions and future updates. Looking forward to delivering your full Canadian buildings dataset pronto.
$15 CAD em 1 dia
0,0
0,0

Hi, I can create a complete, clean, and filter-ready Excel workbook of all buildings in Canada, covering commercial and residential low-, medium-, and high-rise buildings. I’ll research additional sources beyond the Statistics Canada ODB, remove duplicates, standardize all fields, and preserve full addresses and latitude/longitude for mapping or geocoding. Each record will include: building name (if available), street address, city, province, lat/long, number of floors, and all other original columns. I’ll also resolve any lookup tables so the sheet is fully human-readable. If needed, I can provide any Python, SQL, or Power Query scripts used so you can re-run the process for updates. The final deliverable will be a master Excel sheet with an auto-filter row for instant sorting and slicing. I’ll ensure accuracy and a fully reproducible workflow.
$30 CAD em 7 dias
0,0
0,0

toronto, Canada
Método de pagamento verificado
Membro desde jan. 29, 2016
$30-250 CAD
$30-250 CAD
$10-30 CAD
$30-250 CAD
$10-30 CAD
$15-25 AUD / hora
$30-250 USD
₹600-1500 INR
$10-30 USD
mín. £36 GBP / hora
₹1500-12500 INR
£10-15 GBP / hora
₹100-400 INR / hora
₹750-1250 INR / hora
$750-1500 AUD
₹750-1250 INR / hora
$250-750 USD
£20-250 GBP
$30-250 AUD
$30-250 USD
€8-30 EUR
$10-30 USD
$30-250 USD
$250-750 USD
₹4500-6000 INR