Load the shape file data into PostgreSQL using python

sedang Berlangsung Dipasang 1 tahun yang lalu Dibayar saat pengiriman
sedang Berlangsung Dibayar saat pengiriman

I need script in vs code for python and i need requirement file as well.

1.i have a folder it have so many zip folder

2. the first step is to unzip all the folders

3. each folder has 5 different shapefile Trasse, Netzelemente, Pressbohrungen, Rohrnetzknoten, Spuelbohrungen.

[login to view URL] we create a new table named Trasse in the database and the coloums for this table we take coloums from the trasse shape file eg fid, geom, nutzung, bauweise, medien, baudatum, laenge_in_, device_nam, kw, and then we add two more coloums called file name, data_import(time stamp)

[login to view URL] the file name coloum we need to fill it with the folder name wich we unzipped and time as timestamp

[login to view URL] this process we fill the datatable with all the trasse data from each folder

[login to view URL] create another datatable called Netzelemente and repeat the process.

8. then create another datatable called Pressbohrungen and repeat the process.

9. then create another datatable called Rohrnetzknoten and repeat the process.

10. then create another datatable called Spuelbohrungen and repeat the process.

Python PostgreSQL Automation

ID Proyek: #36189562

Tentang proyek

17 proposal Proyek online Aktif 1 tahun yang lalu

17 freelancer rata-rata menawar €41 untuk pekerjaan ini

gangabass

I can provide you a simple Python script that will process all your zip files and upload shapes files from each file into your PostgreSQL database. All I need to start is a couple of samples from you. Roman

€70 EUR dalam 1 hari
(389 Ulasan)
7.6
datascientist90

I'm a senior Python & ML developer and owner & founder of Dedeoglu Dev Company. Kindly send me a message to get in touch with me, Thanks, Yusuf

€19 EUR dalam 7 hari
(28 Ulasan)
6.6
kaloyan13

I am good with Python, and can complete your project in a few hours. Available to start right now......................

€45 EUR dalam 1 hari
(61 Ulasan)
5.4
robartint

Hello I am a professional python developer. My main specializations are automation, web scrapers and bots development. I have already developed over 200 scrapers. From the simplest (for example, a competitor's price Lebih banyak

€8 EUR dalam 7 hari
(9 Ulasan)
4.1
malkesh3m

⭐⭐⭐ Hi, My availability: Immediate. I read your project post of Python Developer. I am Python developer with skill sets in - Python, Django, Flask, FAstAPI, Jupyter Notebook, Selenium - Web App Development, Data Scie Lebih banyak

€30 EUR dalam 1 hari
(9 Ulasan)
3.6
ahmedabdulhamza

Hi I can help you to write a possible script in Python for unzipping folders and creating the required tables in a PostgreSQL database

€30 EUR dalam 7 hari
(5 Ulasan)
2.0
Oliveirajames01

I've been a GIS analyst for four years and I have several jobs involving task automation with the Python programming language. I can develop this task using the Arcgis native library or other free libraries to run in o Lebih banyak

€35 EUR dalam 4 hari
(1 Ulasan)
0.9
salmanmalik2015

Hey, I have Evaluated the scope of project and willing to get it done related to Automation, Python and PostgreSQL. I am an advanced level Excel expert having proficiency in MS Office 365, SQL, Presentations, Macros f Lebih banyak

€168 EUR dalam 3 hari
(0 Ulasan)
0.0
muhzainjaved

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Python Please come over chat and discuss your require Lebih banyak

€19 EUR dalam 7 hari
(0 Ulasan)
0.0
prashantbhardw26

As a data analyst with 2+ years of experience, I have gained a diverse set of skills and expertise in analyzing data and providing valuable insights to stakeholders. I have worked with various types of data, including Lebih banyak

€19 EUR dalam 7 hari
(0 Ulasan)
0.0
mcmbuvi

Hello, I am a geospatial engineer with over 7 years of experience processing geospatial datasets and technologies such as shapefiles, rasters, vectors, shp2pgsql. I would be very much interested in working on this pro Lebih banyak

€30 EUR dalam 3 hari
(0 Ulasan)
0.0
kevinzhang8492

I think there is no difficulty to finish this task. I have some experience in developing python scripts with database access feature. I have almost finished writing the codes and unit testing. I assumed that the shape Lebih banyak

€30 EUR dalam 2 hari
(0 Ulasan)
0.0
kviren101

Have worked on similar project , would love to connect and discuss the opportunities with you once. .

€30 EUR dalam 2 hari
(0 Ulasan)
0.0
mo7ammadihsan

As a professional full stack developer with over 5 years of experience, I am a qualified candidate for any freelancer website. I have a diverse set of skills that includes proficiency in programming languages such as C Lebih banyak

€20 EUR dalam 2 hari
(0 Ulasan)
0.0