KML into MySQL or PostGIS
Required skills: Geolocation, Google Earth, MySQL
A relatively straightforward requirement...
1. Create a polygon in Google Earth eg a rectangle, pentagon etc, and save as KML.
2. Import the KML polygon into MySQL (or PostGIS) as a spatial object and index (R-tree?).
3. For a series of lat/long points determine if the points are within the polygon by using spatial queries.
We would like this to run from a browser, but may require server side processing?
Also we would like the polygon stored in the database to be shown on Google Maps with a transparent fill, say red.
MySQL v5.5 is our preference but we are open to using PostGIS if this is easier/better. Please advise your recommendation as to the database.
1. Create a polygon in Google Earth eg a rectangle, pentagon etc, and save as KML.
2. Import the KML polygon into MySQL (or PostGIS) as a spatial object and index (R-tree?).
3. For a series of lat/long points determine if the points are within the polygon by using spatial queries.
We would like this to run from a browser, but may require server side processing?
Also we would like the polygon stored in the database to be shown on Google Maps with a transparent fill, say red.
MySQL v5.5 is our preference but we are open to using PostGIS if this is easier/better. Please advise your recommendation as to the database.
Posted In:MySQL |
Related projects:
Custom Php Script To Parse Xml And Csv Into Mysql
oad (or the url to the file) I choose a company from a drop down list. When processing the file the script will check the database for the id and save the data in the temporarily file in this format: local id - source id - company - value. The "local id" is found by checking my database WHERE source_id = source_id. The company is the one I selected from the drop down list.
This is a very simple script and should be clean and function properly.
Please PM Questions.
This is a very simple script and should be clean and function properly.
Please PM Questions.
move mssql to other sql such as mysql or mongo DB
hi i am looking for someone who can move my current sql which is mssql to others such as mysql or mongo DB. need someone asap.
want to minimise coding change or if you can help with change the coding, please indicate up to what stage you can help
thank you
want to minimise coding change or if you can help with change the coding, please indicate up to what stage you can help
thank you
CSV into mysql using codeigniter
Additional files submitted: (Files are only available for logged in users)
instruction.txt
prepare.csv
Read pdf invoice and insert into mysql tables
java program to read these pdf and insert into mysql
Products crawler several web sites into mySQL DB
s should be saved on MySQL DB.
Product video URLs must be saved on MySQL DB
Crawler must have 2 modes:
Full – each products details information crawled and stored on DB
List – all categories crawled and only stock level and price stored on DB for all existing products and for new products stored information only available from the List.
Product video URLs must be saved on MySQL DB
Crawler must have 2 modes:
Full – each products details information crawled and stored on DB
List – all categories crawled and only stock level and price stored on DB for all existing products and for new products stored information only available from the List.
Products crawler into mySQL DB
hs should be saved on MySQL DB.
Product video URLs must be saved on MySQL DB
Crawler must have 2 modes:
Full – each products details information crawled and stored on DB
List – all categories crawled and only stock level and price stored on DB for all existing products and for new products stored information only available from the List.
Product video URLs must be saved on MySQL DB
Crawler must have 2 modes:
Full – each products details information crawled and stored on DB
List – all categories crawled and only stock level and price stored on DB for all existing products and for new products stored information only available from the List.
Real Estate website - Properties parsing - Google MAP API
(drupal, jombla, etc) who can be used. We are also willing to purchase a good real estate script if you have a good script you already work with in the past and if you think the final product will be much better.
Please shows us similar projects you worked on before and don't hesitate to suggest any idea to get that done in a good way.
Thanks
Please shows us similar projects you worked on before and don't hesitate to suggest any idea to get that done in a good way.
Thanks
Ms Access To Mysql Searchpage
d and blackberry users. The main website will need a page created where users can pay (paypal, visa, mastercard, etc.) to create their account to add their record into the database. The users would then receive an email confirming their purchase/sign-up and user-id/password. The user should also then be able to securely edit or delete his record and account. I also need to have a procedure to extract text only data from 5 pre-specified websites and upload it into the database.
Csv Import Into Mysql
e (even if many) to me statically
- beside csv name is a drop down with potential categories from the categories table (has been pre-populated)
- I select the correct category based on the name of csv and hit submit
- script goes through each line of csv and matches the keyword in db and the keyword in the csv file and and assigns it to the category join table and adds the extra data to the data table
- script deletes csv file it just processed and starts over
- beside csv name is a drop down with potential categories from the categories table (has been pre-populated)
- I select the correct category based on the name of csv and hit submit
- script goes through each line of csv and matches the keyword in db and the keyword in the csv file and and assigns it to the category join table and adds the extra data to the data table
- script deletes csv file it just processed and starts over
enter 1,000s entries from xml file into mysql database
rdpress database(mysql). The xml file is from blogger.
The auto-import did not work once past 7,000 comments. So I need to enter them in DB automatically - including the right date and post association.
let me know how long you think it will take you to accomplish this goal.
RESULT - I need instructions and scripts, and properly formatted data to get them in the database
The auto-import did not work once past 7,000 comments. So I need to enter them in DB automatically - including the right date and post association.
let me know how long you think it will take you to accomplish this goal.
RESULT - I need instructions and scripts, and properly formatted data to get them in the database
Tecdoc To Mysql
need to convert tecdoc parts catalog into mysql or EPC. Latest version. Need database dump with all linkage. If we can see a sample of data instant pay easy job for right person!
Database To Convert Into Mysql
I need to convert the Tecdoc database into MySql.
Mandatory is that:
- the database needs to have all the links (between article informations and car models, technical data and car models etc).
The aplication is big (over 16GB). For link PM.
All the best!
Mandatory is that:
- the database needs to have all the links (between article informations and car models, technical data and car models etc).
The aplication is big (over 16GB). For link PM.
All the best!
[Perl cms DB_FILE into mysql 2]
s,section etc.
4) the columns for each table will be under 10 or so. such as id,name,path,news_date,section, etc.
5) the relations for all tables will be under 5 or so. such as author to works etc.
6) the data structure itself is simple. but there are many images. 1GB or more.
7) this project should be started soon and completed within 4 days or so.
You can place a temporal bid and fix later after you see the script.
Thank you.
4) the columns for each table will be under 10 or so. such as id,name,path,news_date,section, etc.
5) the relations for all tables will be under 5 or so. such as author to works etc.
6) the data structure itself is simple. but there are many images. 1GB or more.
7) this project should be started soon and completed within 4 days or so.
You can place a temporal bid and fix later after you see the script.
Thank you.
[Perl cms DB_FILE into mysql]
his project.
3) the data will be under 5-8 or so. such as news,author,works,section etc.
4) the columns for each table will be under 10 or so. such as id,name,path,news_date,section, etc.
5) the relations for all tables will be under 5 or so. such as author to works etc.
6) the data structure itself is simple. but there are many images. 1GB or more.
You can place a temporal bid and fix later after you see the script.
Thank you.
3) the data will be under 5-8 or so. such as news,author,works,section etc.
4) the columns for each table will be under 10 or so. such as id,name,path,news_date,section, etc.
5) the relations for all tables will be under 5 or so. such as author to works etc.
6) the data structure itself is simple. but there are many images. 1GB or more.
You can place a temporal bid and fix later after you see the script.
Thank you.
Need an enwiki XML feed processed into mysql
. So if you think you can do the job that is great.
This is the second time I have posted this project because the last service provider won the auction then never did anything not even contact me after he won the project bid. So if you have no intentions of doing this project please do not bid.
This is or should be an easy job estimated job cost is 30.00 The MAX I am willing to pay is 50.00 if you bid above 50.00 you bid will be ignored
This is the second time I have posted this project because the last service provider won the auction then never did anything not even contact me after he won the project bid. So if you have no intentions of doing this project please do not bid.
This is or should be an easy job estimated job cost is 30.00 The MAX I am willing to pay is 50.00 if you bid above 50.00 you bid will be ignored
parse xml file into mysql db
presents
The script must do this:
- create php page call "upload.php" with an upload file form that send the upload XML file to another page call "send.php"
- the page "send.php" must have this script that elaborate node, child and attribute , and put data into mysql db with some variabiles with foreach cicle
we give you a XML file , a mysql structure , and the variabiles to be loaded into the database
The script must do this:
- create php page call "upload.php" with an upload file form that send the upload XML file to another page call "send.php"
- the page "send.php" must have this script that elaborate node, child and attribute , and put data into mysql db with some variabiles with foreach cicle
we give you a XML file , a mysql structure , and the variabiles to be loaded into the database
Transcribe Audio File into MIDI or Different Audio Format
rding of on-hold music. Please contain all laughter, I work at Bell Mobility so I have to listen to it all the time and it's become an inside joke of sorts at the store I work at. It's not complex as it only uses three instruments, Piano, Drum Kit, and Guitar, and fairly repetitive. I am Finale literate and a musician, but I don't have the proper resources and time since I am a full time student. Please contact me if you're interested.
Website design (PSD) into Joomla or Wordpress
adding-left: 20px; width: 320px">
Additional information submitted: 07/05/2011 at 17:06 EDT:
Site must be SEO friendly
Additional information submitted: 07/05/2011 at 17:06 EDT:
Site must be SEO friendly
Convert business into flyer or brochure
I want this converted into brochure or flyer. The design will remain exactly the same, except page sequence and text update. I think this will be max four pages including covers.
2. update text on business card and letterhead so they can be sent for printing.
I have all the source files located at http://www.agiletesters.co.uk/letterhead.zip
2. update text on business card and letterhead so they can be sent for printing.
I have all the source files located at http://www.agiletesters.co.uk/letterhead.zip
Web Scraping - Data Mining
ew Full PDF Report". The pdf file is in a structured format and sample information to be extracted for each Brokerage Firm includes company name, CRD#, SEC#, Main Office Location, Mailing Address, Business Telephone Number, Firm Profile Information, Direct Owners & Executive Officers, Registrations, and Types of Business. Similar fields will also need to be extracted for each Broker record, although this pdf file is structured differently.
The site is protected by Captcha.
The site is protected by Captcha.
