The map is loading.

Please wait...

Please wait...

Operator / Function | Description | Aggregate? |
---|---|---|

x + y | Returns the sum of x and y | No |

x - y | Returns the difference of x and y | No |

x * y | Returns the product of x and y | No |

x / y | Returns the quotient of x and y | No |

-x | Returns the negative value of x | No |

x % y | Returns the remainder of division of x and y | No |

abs(x) | Returns the absolute value of x | No |

acos(x) | Returns the arccosine of x, in radians | No |

asin(x) | Returns the arcsine of x, in radians | No |

atan(x) | Returns the arctangent of x as a numeric value between -PI/2 and PI/2 radians | No |

atan2(y,x) | Returns the arctangent of the quotient of its arguments | No |

ceil(x) | Returns x, rounded upwards to the nearest integer | No |

cos(x) | Returns the cosine of x (x is in radians) | No |

exp(x) | Returns the value of E^{x} |
No |

floor(x) | Returns x, rounded downwards to the nearest integer | No |

log(x) | Returns the natural logarithm (base E) of x | No |

max(x,y,z,...,n) | Returns the number with the highest value | Yes |

min(x,y,z,...,n) | Returns the number with the lowest value | Yes |

pow(x,y) | Returns the value of x to the power of y | No |

random() | Returns a random number between 0 and 1 | No |

round(x) | Rounds x to the nearest integer | No |

sin(x) | Returns the sine of x (x is in radians) | No |

sqrt(x) | Returns the square root of x | No |

tan(x) | Returns the tangent of an angle | No |

Property | Description |
---|---|

totalPopulation | Total number of people |

malePopulation | Total number of men |

femalePopulation | Total number of women |

whitePopulation | Total number of white people |

blackPopulation | Total number of black people |

americanIndianPopulation | Total number of American Indians |

asianPopulation | Total number of asian people |

pacificIslanderPopulation | Total number of Pacific Islanders |

nonDefinedRacePopulation | Total number of other people |

multipleRacePopulation | Total number of multi-raced people |

under18Population | Total number of people under 18 years of age |

medianYearlyEarnings | Average yearly earnings |

commuteTime | Average commute time |

medianAnnualHouseholdIncome | Average income for one household |

medianNumberOfRooms | Average number of rooms per house |

monthlyHousingCost | Average cost of housing per month |

medianAgeFemale | Average female age |

medianAgeMale | Average male age |

nativePopulation | Number of natives |

foreignPopulation | Number of foreigners |

medianPublicTransportationToWorkAge | Average age that people start taking public transportation to work |

onePersonHouseholds | Total number of one-person households |

twoPersonHouseholds | Total number of two-person households |

threePersonHouseholds | Total number of three-person households |

fourOrMorePersonHouseholds | Total number of households with four or more rooms |

familyHouseholds | Total number of family households |

nonFamilyHouseholds | Total number of non-family households |

medianAgeAtFirstMarriageMale | Average age that men get married |

medianAgeAtFirstMarriageFemale | Average age that women get married |

povertyInLast12Months | Total number of people that were below the poverty line at some point in 2010 |

medianHouseholdIncome | Average household income |

annualPerCapitaIncome | Average yearly income per person |

mobileHomePopulation | Total number of people living in mobile homes |

homelessPopulation | Total number of homeless people |

aggregateNumberOfVehiclesAvailible | Average number of vehicles that people have available to them |