Closed

Generate SQL geometry from KML/PNG accurately

We need a simple command line program that will run on windows 10 PRO 64 bit that will be able to take a KML and PNG and extract the polygons accurately from the PNG and place it into a geometry field in a MS SQL database.

• Input

o Account #

o Coverage #

o Strong color code

o Weak color code

o Kml path/filename

o Png path/filename

• [login to view URL]

o Sql connection code to connect to database

• Output

o Account_id – passthough

o Coverage_id – passthrough

o Time-created – auto generated

o Color – color of geometry in this line

o Is center color – is this the strong color

o Geom – geometry of all of color

o Second line with all of second color

• Scalability

o Needs to be able to read the png, and kml, extract 4 points of every pixel corner based on the size of the png

 i.e. if its 1000x1000 it would extract 4 points for every pixel based on the 4 points listed in the kml..

 This would be true if the PNG was 30,000 pixels

o Needs to identify color based on the center of the pixel

o Needs to be able to look for polygons and determine inner polygons, if they are not colored.

o As well as what point to use or to use multiple points in the polygon.

o Needs to be accurate /exact match of existing PNG except in SQL geometry form

o No loss of resolution in conversion

Included is KML/PNG to test with

.SQL for output database is included

Deliverables include 64bit .exe as well as all required files to run + all source code.

Skills: Database Programming, Microsoft SQL Server, C# Programming, Geographical Information System (GIS)

See more: sql geometry using, console application generate sql script csv, sql server 2005 auto backup set, png icon set 64x64, core platforms microsoft silverlight microsoft sql server asp net vb socket based architecture , java generate sql xml, paypal auto generate sql user ipn, generate sql update, generate sql update statements, generate sql sql update, delphi generate sql statements, delphi generate sql statement, generate sql script delphi, generate sql ddl excel, excel macro generate sql, excel macro generate sql query, generate sql traffic, generate sql myd, generate sql job sql server 2008

About the Employer:
( 2 reviews ) House springs, United States

Project ID: #28198141

14 freelancers are bidding on average $1177 for this job

AwaisChaudhry

Hi, I have read the brief details on the job listing. I am a full stack developer with 9 years of coding experience. I have worked with multiple similar jobs before. I have completed 150+ major projects just on this we More

$1500 USD in 22 days
(37 Reviews)
7.7
xtxskif

Dear Employer, I can help you. I'm professional cartographer. I have master degree in GIS and Cartography. I've graduated from AGH (Poland) and IFNTUOG (Ukraine). I can help you. You can see my last work in my portfol More

$1500 USD in 7 days
(15 Reviews)
5.5
(27 Reviews)
5.1
Jamoh1

Hie there, I have read your project details and Am interested to work in your project. Let me chip in and lend you a hand we save time and focus on the real task. I am a professional Cartographer, GIS specialist with c More

$1500 USD in 15 days
(2 Reviews)
5.3
vnazar1985

Hello. I can do this because I have a thorough understanding of raster and vector graphics, recently made a similar solution for automatic processing of raster images, vectorization, calculation of various characterist More

$1500 USD in 14 days
(1 Review)
4.5
DRG1990

Hello I have read your job description carefully. I am a web expert with 10 years of experience in C#, PHP, SQL, MySQL, Javascript, HTML, CSS. Also, I have rich experience in these fields. So I am interested in and I More

$1125 USD in 15 days
(5 Reviews)
3.9
Darwish001

Hi, I have confident to complete your project perfectly. I am C#/.NET, SQL server expert and have full experience for over 13 years. I can extract the color from kml file and put them to SQL server db. I have confident More

$1000 USD in 7 days
(1 Review)
4.0
rostikhr111

Hi, how are you? I have read project description carefully and I am very interested in your project. I have rich experience in generating SQL Geometry. I am sure that I can satisfy any requirements with my skill and e More

$1000 USD in 10 days
(1 Review)
3.0
vut4l1

Hello, I have reviewed the project description I have skills in: C, C++, C#, Python and Software Architecture. I can give you a great job I have excellent recommendations I have skills with the following programmin More

$1000 USD in 7 days
(8 Reviews)
2.9
Sergiobusquets

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. As a skillful software developer, I have rich experience with Image Processing and finished several GIS project. I promise I wi More

$750 USD in 7 days
(1 Review)
3.0
trimemfer

hello I read your proposal carefully. The application based on Geo location is one of my top skills. I have worked it in AR app development based on Geo location. So I am sure that I can complete your app as your requi More

$1125 USD in 7 days
(1 Review)
2.0
sarahrose3

Hello, I have checked The requirement and understand that as well. I have created SIMILAR in past. Do you want to see the DEMO ??? Can will send you ?? Thanks.

$1125 USD in 7 days
(0 Reviews)
0.0
d1master

Hi there. I am an experienced expert in C#/C++/SQL I am certainly confident I can perfectly meet your requirements. If you hire me, you will be happy with excellent work, high quality, and a short period. Looking forwa More

$1100 USD in 7 days
(0 Reviews)
0.0
Austech88

Hi This is Colby from Australia. I read the project description carefully and feel confident. I already built C# programs parsing KML files and also I am very experienced in image processing. Although I am new here I h More

$750 USD in 4 days
(0 Reviews)
0.0