176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

A advanced search that produces result in sortable table
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Sep 22, 2013

Job description changed. New Version|Previous Version

Sep 22, 2013

Job description changed. New Version|Previous Version

Sep 22, 2013

Job title changed to "A advanced search that produces result in sortable table". Previously: "A simple search bar that that allows results to jump to the result page"

Job description changed. New Version|Previous Version

Sep 21, 2013

Skills updated.

Groups updated.

Sep 20, 2013
Close

Job Description

  |  Change History >>

Updated

I need an advanced search bar. I will provide the sample databases with data fields. Milestone 1. Hierarchy site map. 1.1 provide an hierarchy structure site map of the zip codes so that users can see a page with list of the state full names. If user click one state, then it allows user to see all the counties or cities in that state in that state (Here allows users to choose to list of cities with population >xxxx). If the numbers of cities are too many, then list them in multiple pages with page numbers at the bottom of the page. When user click a city name, then it will lead user to a list of zip codes in that city. When user click the zip code than it will lead users to that zipcode xxxxx.php page. Print these site maps into html file to static page with meaning full name such as California_city_list, California_county_list, Statename_cityname_zipcode_list. Also give meaningful, title, and meta, header, H1 tag for the sitemap files. Milestone 2. 1. I need a program written in(C, perl, or MySQL whatever language) which allows me to run it to insert derived data fields from the sample database. The program should be able to run through the full database (until the end of the file) which contains a few ten thousand results. 1.a For example, given difference races population, calculate the percentage of each population over the sum of all races and insert White, Black, Asian, Indian Hispanic etc population percentages. 1.b. Insert population density (people per square mile) and (people per square km) by calculating (population/land area). 1.c Insert Annual Population change percentage from 2010 to 2012 by (population of 2012- population of 2010)/(population of 2010)/2. (The Average House value for 2000 and for 2010 is stored in different databases.) 1.d Insert Average house value over average income ratio. 1.e Insert Annual House appreciation/depreciation rate by (Housing value of 2010-housing value of 2000)/10*100 in percentage. Milestone 3: The advanced search bar shall contain the following search function. (Provide a few different variations) 3.1 Search database by searching State (drop down), County(drop down which can be skipped), City(drop down), zip code, population > a value (drop down with first letter typed and has a list to choose), Average House value (2010) (between xxx, xxx drop down), Income per household (between xxx, xxx drop down), When all the fields are empty, then the search result should list all it found limited by 20, 50 or 100 (a drop down) results per page for multiple pages. The result should be a sortable table which lists the following fields that can be sorted (with one uparrow and down arrow at the table headers): State, County(link), City(link), Zipcode(link), Population, White, Black, Asian, Indian Hawaiian, Hispanic, Average House value (2000), Average House Value (2010), Income per household (2010), Average House value/income ratio (2010) and all the above derived fields. The result is also listed by 20, 50 or 100 (a drop down) results per page for multiple pages. 3.2 Search database by searching State (drop down), County(drop down which can be skipped), City(drop down), two zip code text bar (here allows user to enter two zip codes) with a compare button on the right. The result page should be a page with left half page displaying left zip code's (xxxxx.php) and the right half page displaying right zip code's (xxxxx.php). The content at xxxxx.php will be updated in the future so just call the content from the relative location. *All these pages should have a meaningful, title, and meta, header, H1 tag with one meaningful sentence.

I need an advanced search bar. I will provide the sample databases with data fields. Milestone 1. Hierarchy site map. 1.1 provide an hierarchy structure site map of the zip codes so that users can see a page with list of the state full names. If user click one state, then it allows user to see all the counties or cities in that state in that state (Here allows users to choose to list of cities with population >xxxx). If the numbers of cities are too many, then list them in multiple pages with page numbers at the bottom of the page. When user click a city name, then it will lead user to a list of zip codes in that city. When user click the zip code than it will lead users to that zipcode xxxxx.php page. Print these site maps into html file to static page with meaning full name such as California_city_list, California_county_list, Statename_cityname_zipcode_list. Also give meaningful, title, and meta, header, H1 tag for the sitemap files. 1.2 Also allow users to choose two zip co...

Sep 22, 2013

I need an advanced search bar. I will provide the sample databases with data fields. Milestone 1. 1. I need a program written in(C, perl, or MySQL whatever language) which allows me to run it to insert derived data fields from the sample database. The program should be able to run through the full database (until the end of the file) which contains a few ten thousand results. 1.a For example, given difference races population, calculate the percentage of each population over the sum of all races and insert White, Black, Asian, Indian Hispanic etc population percentages. 1.b. Insert population density (people per square mile) and (people per square km) by calculating (population/land area). 1.c Insert Annual Population change percentage from 2010 to 2012 by (population of 2012- population of 2010)/(population of 2010)/2. (The Average House value for 2000 and for 2010 is stored in different databases.) 1.d Insert Average house value over average income ratio. 1.e Insert Annual House appreciation/depreciation rate by (Housing value of 2010-housing value of 2000)/10*100 in percentage. Milestone 2: The advanced search bar shall contain the following search function. (Provide a few different variations) Search database by searching State (drop down), County(drop down), City(drop down), zip code, population > a value (drop down), Average House value (2010) (between xxx, xxx drop down), Income per household (between xxx, xxx drop down), When all the fields are empty, then the search result should list all it found limited by 20, 50 or 100 (a drop down) results per page for multiple pages. The result should be a sortable table which lists the following fields that can be sorted (with one uparrow and down arrow at the table headers): State, County(link), City(link), Zipcode(link), Population, White, Black, Asian, Indian Hawaiian, Hispanic, Average House value (2000), Average House Value (2010), Income per household (2010), Average House value/income ratio (2010) and all the above derived fields. The result is also listed by 20, 50 or 100 (a drop down) results per page for multiple pages.

I need an advanced search bar. I will provide the sample databases with data fields. Milestone 1. Hierarchy site map. 1.1 provide an hierarchy structure site map of the zip codes so that users can see a page with list of the state full names. If user click one state, then it allows user to see all the counties or cities in that state in that state (Here allows users to choose to list of cities with population >xxxx). If the numbers of cities are too many, then list them in multiple pages with page numbers at the bottom of the page. When user click a city name, then it will lead user to a list of zip codes in that city. When user click the zip code than it will lead users to that zipcode xxxxx.php page. Print these site maps into html file to static page with meaning full name such as California_city_list, California_county_list, Statename_cityname_zipcode_list. Also give meaningful, title, and meta, header, H1 tag for the sitemap files. Milestone 2. 1. I need a program written in(C, perl, or MySQL whatever language) which allows me to run it to insert derived data fields from the sample database. The program should be able to run through the full database (until the end of the file) which contains a few ten thousand results. 1.a For example, given difference races population, calculate the percentage of each population over the sum of all races and insert White, Black, Asian, Indian Hispanic etc population percentages. 1.b. Insert population density (people per square mile) and (people per square km) by calculating (population/land area). 1.c Insert Annual Population change percentage from 2010 to 2012 by (population of 2012- population of 2010)/(population of 2010)/2. (The Average House value for 2000 and for 2010 is stored in different databases.) 1.d Insert Average house value over average income ratio. 1.e Insert Annual House appreciation/depreciation rate by (Housing value of 2010-housing value of 2000)/10*100 in percentage. Milestone 3: The advanced search bar shall contain the following search function. (Provide a few different variations) 3.1 Search database by searching State (drop down), County(drop down which can be skipped), City(drop down), zip code, population > a value (drop down with first letter typed and has a list to choose), Average House value (2010) (between xxx, xxx drop down), Income per household (between xxx, xxx drop down), When all the fields are empty, then the search result should list all it found limited by 20, 50 or 100 (a drop down) results per page for multiple pages. The result should be a sortable table which lists the following fields that can be sorted (with one uparrow and down arrow at the table headers): State, County(link), City(link), Zipcode(link), Population, White, Black, Asian, Indian Hawaiian, Hispanic, Average House value (2000), Average House Value (2010), Income per household (2010), Average House value/income ratio (2010) and all the above derived fields. The result is also listed by 20, 50 or 100 (a drop down) results per page for multiple pages. 3.2 Search database by searching State (drop down), County(drop down which can be skipped), City(drop down), two zip code text bar (here allows user to enter two zip codes) with a compare button on the right. The result page should be a page with left half page displaying left zip code's (xxxxx.php) and the right half page displaying right zip code's (xxxxx.php). The content at xxxxx.php will be updated in the future so just call the content from the relative location. *All these pages should have a meaningful, title, and meta, header, H1 tag with one meaningful sentence.

Sep 22, 2013

I need an advanced search bar. I will provide the sample databases with data fields. Milestone 1. 1. I need a program written in(C, perl, or MySQL whatever language) which allows me to run it to insert derived data fields from the sample database. The program should be able to run through the full database (until the end of the file) which contains a few ten thousand results. 1.a For example, given difference races population, calculate the percentage of each population over the sum of all races and insert White, Black, Asian, Indian Hispanic etc population percentages. 1.b. Insert population density (people per square mile) and (people per square km) by calculating (population/land area). 1.c Insert Annual Population change percentage from 2010 to 2012 by (population of 2012- population of 2010)/(population of 2010)/2. (The Average House value for 2000 and for 2010 is stored in different databases.) 1.d Insert Average house value over average income ratio. 1.e Insert Annual House appreciation/depreciation rate by (Housing value of 2010-housing value of 2000)/10*100 in percentage. Milestone 2: The advanced search bar shall contain the following search function. (Provide a few different variations) Search database by searching State (drop down), County(drop down), City(drop down), zip code, population > a value (drop down), Average House value (2010) (between xxx, xxx drop down), Income per household (between xxx, xxx drop down), When all the fields are empty, then the search result should list all it found limited by 20, 50 or 100 (a drop down) results per page for multiple pages. The result should be a sortable table which lists the following fields that can be sorted (with one uparrow and down arrow at the table headers): State, County, City, Zipcode, Population, White, Black, Asian, Indian Hawaiian, Hispanic, Average House value (2000), Average House Value (2010), Income per household (2010), Average House value/income ratio (2010) and all the above derived fields. The result is also listed by 20, 50 or 100 (a drop down) results per page for multiple pages.

I need an advanced search bar. I will provide the sample databases with data fields. Milestone 1. 1. I need a program written in(C, perl, or MySQL whatever language) which allows me to run it to insert derived data fields from the sample database. The program should be able to run through the full database (until the end of the file) which contains a few ten thousand results. 1.a For example, given difference races population, calculate the percentage of each population over the sum of all races and insert White, Black, Asian, Indian Hispanic etc population percentages. 1.b. Insert population density (people per square mile) and (people per square km) by calculating (population/land area). 1.c Insert Annual Population change percentage from 2010 to 2012 by (population of 2012- population of 2010)/(population of 2010)/2. (The Average House value for 2000 and for 2010 is stored in different databases.) 1.d Insert Average house value over average income ratio. 1.e Insert Annual House appreciation/depreciation rate by (Housing value of 2010-housing value of 2000)/10*100 in percentage. Milestone 2: The advanced search bar shall contain the following search function. (Provide a few different variations) Search database by searching State (drop down), County(drop down), City(drop down), zip code, population > a value (drop down), Average House value (2010) (between xxx, xxx drop down), Income per household (between xxx, xxx drop down), When all the fields are empty, then the search result should list all it found limited by 20, 50 or 100 (a drop down) results per page for multiple pages. The result should be a sortable table which lists the following fields that can be sorted (with one uparrow and down arrow at the table headers): State, County(link), City(link), Zipcode(link), Population, White, Black, Asian, Indian Hawaiian, Hispanic, Average House value (2000), Average House Value (2010), Income per household (2010), Average House value/income ratio (2010) and all the above derived fields. The result is also listed by 20, 50 or 100 (a drop down) results per page for multiple pages.

Sep 21, 2013

Close
  • Posted: Fri, Sep 20, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I need an advanced search bar.

I will provide the sample databases with data fields.
Milestone 1. Hierarchy site map.
1.1 provide an hierarchy structure site map of the zip codes so that users can see a page with list of the state full names. If user click one state, then it allows user to see all the counties or cities in that state in that state (Here allows users to choose to list of cities with population >xxxx). If the numbers of cities are too many, then list them in multiple pages with page numbers at the bottom of the page. When user click a city name, then it will lead user to a list of zip codes in that city. When user click the zip code than it will lead users to that zipcode xxxxx.php page. Print these site maps into html file to static page with meaning full name such as California_city_list, California_county_list, Statename_cityname_zipcode_list. Also give meaningful, title, and meta, header, H1 tag for the sitemap files.
1.2 Also allow users to choose two zip co...

Sign in or Register to see more

Job ID: 47059924
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Devajyoti Das      
Devajyoti Das's identity has been verified.  Learn More
 India  |  
INVITED
I have extensive experience in multiple small to large implementations of products and services implemented using different technologies...
4
  |  
 0.0   |  $4,742 Earnings   |  2 Jobs
Bid ID: 47657102  |  Submitted: Oct 5, 2013 02:04 ET 
Proposal SEALED

Hans B.      
Hans B.'s identity has been verified.  Learn More
 Netherlands  |  
INVITED
Mostly build back end software. Mostly logistic software for Fortune 250 companies
6
  |  
 4.9   |  $2,038 Earnings   |  5 Jobs
Bid ID: 47093261  |  Submitted: Sep 22, 2013 04:37 ET 
Proposal SEALED

Birinder Singh      
Birinder Singh's identity has been verified.  Learn More
 India  |  
INVITED
Hi I am a freelance web developers with more than 9 years of experience. I have developed web based application, ERPs and Web Sites using PHP +...
6
  |  
 5.0   |  $2,872 Earnings   |  15 Jobs
Bid ID: 47089711  |  Submitted: Sep 22, 2013 01:08 ET 
Proposal SEALED

Lal Chand K.      
Lal Chand K.'s identity has been verified.  Learn More
 India
My name is Lal Chand Kumawat and I am an experienced business analyst and project manager with 7+ years of experience. My forte is project...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 47066318  |  Submitted: Sep 21, 2013 02:24 ET 
Proposal SEALED

 Mauritius  |  
As a University Academic, from time to time I need to test my skills, update my knowledge and stay close to the industry. Elance is a great way to...
7
  |  
 5.0   |  Private   |  14 Jobs   |  1 verified credential(s)
Bid ID: 47063439  |  Submitted: Sep 21, 2013 00:17 ET 
Proposal SEALED

 China
Winner
Established in 2012 we earned trust of serial entrepreneurs from USA, Canada, Western Europe and Australia providing full-cycle mobile & web apps'...
2
  |  
 1.0   |  $255 Earnings   |  0 Jobs
Bid ID: 47060227  |  Submitted: Sep 20, 2013 20:42 ET 
Delivery
Within 2 weeks
$500.00
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »