Download the database and normalize it
You need to download the Open source database file (the database of apartment sales and the database of apartment diagnostics) and upload it to the cloud database. Normalize their format, create a match between them, and provide me with an API so that I can make requests to it.
Database 1:
https://explore.data.gouv.fr/fr/immobilier?onglet=carte&filtre=tous
Database 2.
https://observatoire-dpe-audit.ademe.fr/donnees-dpe-publiques
I need to be able to search by address.
And the databases should be linked together based on the address, area, etc.
Client's review of cooperation with Dmitro F.
Download the database and normalize itThe task was completed quickly and ahead of schedule. I recommend!
Freelancer's review of cooperation with Tony Aliyev
Download the database and normalize itI recommend for collaboration. Interesting projects!
-
Winning proposal7 days348 USD
4272 25 0 Winning proposal7 days348 USDI will merge the databases based on the criteria (and etc. does not apply, specific fields are needed). I will place it on your server and create an API with the endpoints you need.
-
7 days349 USD
2221 22 0 7 days349 USDGood day.
I will merge and normalize two databases + implement the necessary API access to it. You have described the technical specifications in detail, so I understand the task. I will complete everything quickly and efficiently.
-
8 days812 USD
277 8 days812 USDGood day!
I am interested in your project. I can:
upload both databases,
upload them to a cloud database (for example, PostgreSQL),
normalize the format and merge records by address/area,
implement a REST API for address search with access to the merged data (Python).
On your database and on your server.
-
1 day29 USD
162 1 day29 USDHello.
I am interested in your project. I am confident that I can deliver effective and high-quality work that meets your requirements and expectations. I have over 8 years of experience.
-
7 days1740 USD
251 7 days1740 USDGood morning!
I have extensive experience with similar projects for the real estate industry. Recently, I implemented an identical system for a real estate agency in Spain with automation and AI.
My proposal for implementation:
Stage 1 - Analysis and data retrieval:
I will check the API limitations of both databases (there is often a limit, e.g., 100 requests/day)
I will retrieve full data from explore.data.gouv.fr and observatoire-dpe-audit.ademe.fr
I will conduct a data structure analysis
… Stage 2 - Normalization and integration:
I will create a unified SQL database (PostgreSQL/MySQL)
I will merge data by address, area, postal code
I will implement matching algorithms for incomplete addresses
I will create indexes for fast searching
Stage 3 - API:
REST API with address search
Filters: area, price, energy class, region
API documentation + testing panel
Rate limiting and security
Additional possibilities (optional):
🎥 Video automation - like in the Spanish project:
Automatic creation of videos with listings (30s for $0.25)
Realistic AI avatars (HeyGen)
Auto-publishing on social media
In Spain: TikTok 500k views in a month!
Technologies: PHP + n8n + SQL + API integrations
Execution time: 3-7 days (after analyzing API limitations)
Can we discuss the details? I am interested in the budget and whether you are also considering marketing automation with video?
-
20 days2030 USD
421 20 days2030 USDHello Tony,
To combine France's public apartment sales (Data.gouv) and DPE diagnostics (ADEME) databases into a queryable cloud API with address-based search, I'll design a simplified pipeline. Kindly inbox me so that we can get to it.
Current freelance projects in the category Databases & SQL
Work with BAS CORPHello! Currently, the following tasks need to be completed: Adjustment of the printed form in BAS KORP according to the client's parameters. Specifically, the task is not to display certain fields. Updating the classifier of professions in BAS KORP for a number of… Payment Systems Integration, Databases & SQL ∙ 4 hours 57 minutes back ∙ 6 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 1 day 11 hours back ∙ 10 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 1 day 22 hours back ∙ 4 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 5 days 5 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
603 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 7 days 9 hours back ∙ 59 proposals |