
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 an example of 1 source below - I need this resource to spend time to fully research many sources to gain accurate information 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: 40288186
29 propostas
Projeto remoto
Ativo há 2 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
29 freelancers estão ofertando em média $28 CAD for esse trabalho

Drawing from my 7 years of experience as a Full stack developer with a specialized focus on Web Scraping and Web Automation, I am confident in my ability to deliver the clean, human-readable .xlsx file you require for your project researching buildings in Canada. I have an absolute dedication to accuracy and efficiency in my work and always prioritize client satisfaction. My extensive skills in Excel including formulas, VBA, Macros, and more align perfectly with your requirement for data entry, analysis and processing. Additionally, I am adept at web scraping and gathering data from multiple sources using tools like Python and SQL. My background in R-programming and SPSS lends itself to ensuring that the records I gather are accurate, reliable, and organized. In conclusion, by selecting me for your project research needs, you can count on my uncompromising commitment to quality, timeliness, and flexibility. I have a proven track record of delivering successful projects of similar complexity and would relish the opportunity to leverage my skills for the success of your project. Let's transform your vision into reality together!
$80 CAD em 2 dias
8,6
8,6

Hi, I can do this project right now with 100% accuracy. If you need any sample please let me know. Thanks
$20 CAD em 7 dias
6,8
6,8

Hello, I can create a clean, comprehensive Excel database of all buildings in Canada, including non-residential, commercial, and residential low-, medium-, and high-rise buildings from Statistics Canada ODB and other verified sources. Each record will include building name, full address, city, province, latitude/longitude, number of floors, and all original fields, with duplicates removed and lookup tables resolved. The final .xlsx file will be filter-ready, and I’ll provide a list of sources and any scripts or queries used for future updates. Regards, Zafar
$30 CAD em 1 dia
6,3
6,3

As a data analyst with a strong background in Python and Excel, I'm well-equipped to handle the complex research and data processing needed for your project. I have extensive experience in lead generation and web scraping, which will go a long way when researching multiple sources to ensure maximum accuracy for your Canadian building dataset. Furthermore, my proficiency in data mining and cleaning means I can efficiently eliminate any duplicates from your comprehensive list while preserving all the crucial information you require. I understand the value of human-readable, filter-ready data, and I'm thorough in my approach to deliver exactly that. Moreover, I'm adept at maintaining flexible workflows and documenting my processes, so you'll have no trouble rerunning the process or accommodating any future modifications. Remember, your satisfaction is my top priority! Choose me for meticulous workmanship, detail-oriented results and an enjoyable partnership. Let's turn this daunting task into a smooth journey towards your precisely curated dataset.
$30 CAD em 5 dias
5,0
5,0

With a strong background in Mechanical Engineering, I'm well-versed in data-driven projects that require a meticulous approach. Having worked with tools like SolidWorks and ANSYS Fluent, I understand the necessity of clean, accurate and usable datasets. My well-developed skills in Python, Automation and Excel will facilitate the entire process from web research to building your dataset.I have particular expertise in data extraction, entry and analysis which you can witness by the success of my 180+ data projects. For a project that requires gathering comprehensive data on buildings across Canada while eliminating duplicates, my web scraping and research skills coupled with a deep understanding of Excel will prove invaluable. I assure you that your excel sheet will not only meet but effectively exceed your expectations since I strongly believe organizing the information making it actionable is just as important as collecting it. In fact, to ensure transparency, I will share with you all the sources of data used.
$30 CAD em 3 dias
5,5
5,5

With over 50 data projects under my belt, I am thus well-versed in all aspects of data analysis and processing. Your research challenge will leverage my extensive experience as a data analyst, where I've helped businesses uncover valuable insights through thorough research and data handling, guaranteeing that the final results are accurate and human-readable. My familiarity with tools like Python, LibreOffice Base, SQL, and Power Query allows me to automate processes intelligently, eliminating room for error. What sets me apart is not just my technical skills, but also my commitment to being adaptable and flexible. As you mentioned possible adjustments or additions to the columns needed in the future; this won't be a problem for me. I can easily adjust my workflow to accommodate such changes without compromising the quality or delivery of work. In summary, when you hire me for your project not only do you get an accomplished data analyst, but also a teammate who is determined to deliver most optimal solutions using prior code and queries along with logical reasoning. I'm confident that we can achieve perfect results for your building database needs and give you the ability to glean useful insights from your data effortlessly.
$25 CAD em 2 dias
5,0
5,0

As a software developer with over 7 years of experience, I have cultivated a honed skill set in data handling and analysis which makes me an excellent fit for this project. I am particularly familiar with efficiently navigating through vast amounts of data using Excel. Among my many endeavours, I have designed elaborate databases and developed sophisticated algorithms for making sense of complex data, often involving multiple sources as you've described here. My command over languages such as Python, SQL & PL/SQL, in conjunction with proficiency in various statistical and machine learning techniques equips me to not only extract the information you require but to present it efficiently while preserving the integrity of the data. Your satisfaction is my topmost priority- I've consistently delivered projects on time, in line with client's requirements and ensuring high quality outputs. Rest assured, I am fully committed to providing you with a comprehensive, de-duped and human-readable .xlsx file that will seamlessly integrate into your existing workflow— ready for sorting and slicing—as outlined in the provided specifications. With me at your service, accuracy and attention to detail are guaranteed and any technical elements needed will be passed on to you. Let’s collaborate towards a smooth, accurate conversion!
$20 CAD em 7 dias
4,7
4,7

Hello client, I’ve carefully reviewed your job description and have strong experience in these Excel, Data Scraping, Data Collection, Data Entry, Web Search, Data Management, Data Processing, Data Visualization, Data Analysis and Research. I can build a reliable web scraping solution tailored specifically to your needs. Whether using Node.js with Puppeteer/Cheerio or Python with Selenium/BeautifulSoup, I will extract, clean, and organize your data efficiently. I also handle anti-bot protections, pagination, and full automation as required. As you can see from my profile, my web scraping reviews are excellent, reflecting my commitment to quality work. I focus on writing clean, maintainable, and scalable code because I know the difference between 99% and 100%. If you hire me, I’ll do my best until you’re completely satisfied with the result. Let’s discuss your target website and preferred data format. Thanks, Denis
$30 CAD em 1 dia
3,4
3,4

I can provide a clean, comprehensive .xlsx master sheet of all Canadian buildings by consolidating the Statistics Canada ODB with additional researched sources.
$30 CAD em 3 dias
3,7
3,7

Hi there, I can research and compile a comprehensive dataset of buildings across Canada by combining the Statistics Canada ODB source with additional verified public sources. I’ll extract the data, resolve lookup tables, merge multiple datasets, and remove duplicates to produce a single clean, human-readable Excel workbook. Each record will include building name (if available), full street address, city, province, latitude/longitude, number of floors, and all other fields from the original datasets. I can use Python (pandas, scraping where needed) and database queries to process the ODB file, normalize the data, and organize everything into one master sheet with auto-filters for easy sorting by province and city. You will receive the final clean .xlsx file along with the scripts/queries used so the extraction can be repeated when updated data becomes available. Regards, Avinash
$20 CAD em 2 dias
3,0
3,0

Hi There I can handle this building data project by researching multiple reliable Canadian sources, extracting the records, resolving lookup values, removing duplicates, and delivering one clean Excel workbook with filters, full addresses, coordinates, floors, and all available source fields in a human-readable format. I also work with flexible extraction workflows, so I can provide the scripts or queries used for scraping, transformation, and export to help you refresh the dataset later. I have experience with large structured data collection, cleanup, and consolidation where accuracy and source tracking are critical. Do you want the final workbook separated by province in additional tabs as well, or should everything remain only in one master sheet with filters? Best Regards Waqas Ahmad
$20 CAD em 7 dias
3,1
3,1

Hello, I can research and compile a complete Excel dataset of buildings across Canada by combining Statistics Canada sources with additional verified datasets. I will extract, clean, and merge the data into one master .xlsx file, remove duplicates, and organize it by province and city with an auto-filter for easy sorting. Each record will include building name (if available), full address, city, province, latitude/longitude, number of floors, and all other fields from the original sources. I will also resolve lookup tables so the sheet remains fully human-readable, and provide a list of all sources plus any scripts/queries used for extraction. Regards, Bakhtawar
$10 CAD em 1 dia
3,2
3,2

Hi there! I see you need a complete, clean Excel sheet of all buildings in Canada, including commercial and residential low, medium, and high-rise buildings, with full addresses and coordinates. Ensuring accuracy and removing duplicates will be critical. I have extensive experience in data research, web scraping, and Excel processing, including compiling large datasets from multiple official sources like Statistics Canada. I’ve created master sheets with automated filters, clean formatting, and geocoding-ready fields for mapping and analysis. My approach will involve carefully combining your ODB dataset with additional verified sources, resolving all lookup tables, deduplicating entries, and providing the final workbook along with any scripts used for future updates. This ensures your dataset is ready to use immediately and easy to refresh later. check our work https://www.freelancer.com/u/ayesha86664 Do you want me to include a separate tab listing all sources used for transparency? Let me know if you’re interested & we can discuss it. Best Regards Ayesha
$180 CAD em 8 dias
2,6
2,6

I will provide a meticulously researched, deduplicated Excel master sheet aggregating Statistics Canada ODB, NRCan, and supplemental commercial databases. Each record will feature resolved location names, precise coordinates, and floor counts (4+ for residential). I’ll include all transformation scripts (Python/Power Query) for future re-runs, ensuring a clean, filter-ready, and human-readable dataset that meets your exact technical specifications. Best regards! Malaika Asad
$10 CAD em 1 dia
0,7
0,7

Hello, I see you need a comprehensive Excel sheet compiling all buildings in Canada, including commercial and residential low to high-rise structures, with detailed fields and clean formatting. You want thorough research beyond the provided Statistics Canada source, with duplicates removed and data fully human-readable. Your project requires gathering data from multiple sources, preserving all relevant columns, resolving lookup tables into readable values, and including geo-coordinates. The final sheet must have an auto-filter row and be flexible for future updates, plus you want any scripts or queries used to be delivered for reusability. I have built similar datasets by combining official databases and web scraping, transforming raw data with Python and SQL to produce clean, filter-ready Excel workbooks. For one project, I merged multiple city building records into a unified sheet with resolved lookup values and geo-coordinates, delivering both the data and transformation scripts for client reuse. I can complete this within 7 days, ensuring accuracy and clean formatting. Let’s discuss your priorities so I can start right away and deliver a reliable dataset with all requested details.
$11 CAD em 7 dias
0,0
0,0

I would immediately begin by thoroughly reviewing the provided Statistics Canada ODB database link
$10 CAD em 7 dias
0,0
0,0

Hi there This job will succeed only if the source hierarchy, building scope, and deduping rules are locked before extraction, because Canada wide building data is fragmented and inconsistent. The main risks are overlapping records across sources, unresolved lookup tables, missing floor counts, mixed residential definitions, bad lat long, and city province naming conflicts. I would first inspect the StatCan ODB structure and related tables, then build a merge and normalization workflow to resolve IDs, standardize addresses, and flag duplicates before exporting to one master sheet. Should condos and apartment towers be included in residential, and which source should win when floor counts or coordinates conflict? Also, you wrote low rise starts at 4 floors, is that the rule you want me to follow exactly? I have handled large multi source data consolidation where the hard part was making the final sheet clean, traceable, and rerunnable. I can start quickly and map the extraction workflow right away. Happy to discuss more on chat. Mykola Nahurskyi
$20 CAD em 7 dias
0,0
0,0

toronto, Canada
Método de pagamento verificado
Membro desde jan. 29, 2016
$30-250 CAD
$10-30 CAD
$30-250 CAD
$70-100 CAD
$30-250 CAD
$250-750 USD
$10-30 USD
₹1500-12500 INR
$1500-3000 USD
$2-8 USD / hora
$15-25 USD / hora
$15-25 USD / hora
$250-750 USD
$250-750 USD
$250-750 USD
₹600-1500 INR
₹750-1250 INR / hora
₹600-1500 INR
$750-1500 USD
$25 AUD
₹12500-37500 INR
$15-25 USD / hora
$250-750 USD
$30-250 USD
₹600-1500 INR