Download the database and normalize it

Budget: 25 EUR Deadline: 1 day

Hello.
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.

Budget: 1500 EUR Deadline: 7 days

Good 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? Expand

Budget: 1750 EUR Deadline: 20 days

Hello 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.