Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Alexander Tsepkov
    @atsepkov
    actually, it seems like sublevel per-tract populations returned from citysdk don't match up with other sources
    for example this tract data from census:
    { name: 'Census Tract 1439.02, Los Angeles County, California',
    state: '06',
    county: '037',
    tract: '143902',
    population: '3003' }
    whereas http://proximityone.com/ziptractequiv.htm claims that tract's population is 82, and proximityone data actually adds up to correct zipcode data, so is citysdk wrong or am I doing something wrong?
    Logan
    @logantpowell
    @atsepkov you're right: sublevel should be 'true' and level should be 'tract'
    our zipcode implementation is rather rudementary, being hard-coded (here)[https://github.com/uscensusbureau/citysdk/blob/master/src/resources/zipcode-to-coordinates.json]
    I will start a dm with you...
    Tom Arnold
    @tomarnold2
    Hi, everyone. I'd like to be able to confirm if an address is within a city's or county's borders. I searched through TIGER on census.gov and also on Google Maps to see if there was an API for this (or a way to write my own) but I've had no luck. I've spent a few hours researching before bugging you good folks, but now I'm at the point of asking for help since this cannot be a rare request. Any advice where I should look to find this existing functionality or to at least find the building blocks to create it? - thank you.
    Try that
    Tom Arnold
    @tomarnold2
    Thank you, @logantpowell - if I'm reading that correctly, though, that's for looking up individual or batch addresses. I want this, for sure, but I also need a way to determine if that address resides with a city's limits or even a particular county's boundaries. (For example, my address is Wenatchee, Washington, but I'm outside of its city limits).
    Logan
    @logantpowell
    Just trying to understand what you're looking for is a way to verify whether or not an address is in a particular area?
    Logan Powell
    @loganpowell
    when I say particular, I mean predetermined
    BenTheMonk
    @BenTheMonk
    Hi everyone, I am new here
    Logan
    @logantpowell
    Hi Ben!
    BenTheMonk
    @BenTheMonk
    Howdy, Logan
    Tom Arnold
    @tomarnold2

    Hi, @logantpowell - here's my example: a government customer sells a type of city license on their website but it's only necessary for people who live within city limits. Too many people don't know this and attempt to buy the license even though they live outside of city limits (but, they have the same city name and postal code). So, I cannot use postal code alone to determine if they are in city limits. The website needs to alert the user that they are not required to make that purchase since they are outside of city limits (otherwise, the city has to refund those purchases and it's a hassle).

    The point is that if you look at Google maps for a city, you can see the boundary lines for the city limits. So, the data is out there. What I'm trying to figure out is how to check if an address is located within city limits and zip code alone won't do it. I need to get the lat/lng for the user's address, then check to see if it's in the city limits, then warn them that they don't need to do the purchase if they are outside of city limits.

    Sorry I'm not being more succinct. :-) I hope that helps, though?

    Logan
    @logantpowell
    If what you trying to do is "given a geographic area, does this user fall within its boundaries type of thing you may have to do some postGIS type stuff
    Check out terraformer.I'm
    Terraformer.io
    Cameron Banowsky
    @cbanowsky
    Hey anyone have a sample app or something similar to isolating education and age based on region or zip?
    Logan
    @logantpowell
    Cameron, we have education and age in ACS, which - in the 5-year collections - gets you down to zip
    Cameron Banowsky
    @cbanowsky
    omg could you share?
    Logan
    @logantpowell
    are you just looking for stats or would you be creating a map?
    Cameron Banowsky
    @cbanowsky
    save me so much time. I'd like to create map but data first :)
    god I love this community already
    Logan
    @logantpowell
    so, the citysdk might help which combines stats with geographic shapes/geojson, but if you want just the stats I can share the underlying stats api call for that
    which would you like?
    sorry wrong link sec
    Cameron Banowsky
    @cbanowsky
    Yeah that would be great, I will chart myself. Thank you so much
    Logan Powell
    @loganpowell
    this gets you total population (B01001_001E) males (B01001_002E) and females (B01001_002E) for all zipcodes in the US
    you can find a complete list of variables for ACS 5 (2015 latest vintage) here: http://api.census.gov/data/2015/acs5/variables.html
    Cameron Banowsky
    @cbanowsky
    thank you @loganpowell seriously saved me a couple hours
    Logan Powell
    @loganpowell
    you're very welcome
    Cameron Banowsky
    @cbanowsky
    i will be lurking in this channel lol
    Logan
    @logantpowell
    haha
    Cameron Banowsky
    @cbanowsky
    @loganpowell how can I use tableau? This is a new program to me. Import json or other?
    Logan
    @logantpowell
    sorry, i didn't mean to add the tableau reference
    but you can use it
    we've done such visualizations before using it
    Cameron Banowsky
    @cbanowsky
    what data files do I need to make something meaningful?
    Logan
    @logantpowell
    please elaborate
    Cameron Banowsky
    @cbanowsky
    I literally just launched app, so i guess what is starting point for a data visualization?
    just generally speaking
    Logan
    @logantpowell
    that's a hard question to answer, it depends on what you want to show and the tools you're using. With Tableau, we've generally seen people converting the json to .csv and then uploading
    with Tableau 10.2 you can also upload shapefiles
    Cameron Banowsky
    @cbanowsky
    ok that’s basically what i needed to know thank you. oh cool. I will get back to work. So much appreciated
    sancao
    @sancao
    hi there!, how can i call api to get KML of zip code five digits (such as: 85001,85002.....)
    Logan
    @logantpowell
    @sancao TigerWeb doesn't provide KML, but you can take the payload and translate it using something like terraformer (terraformer.io) you can also download Census ZIP code tabulation areas here https://www.census.gov/geo/maps-data/data/cbf/cbf_zcta.html
    "Jake"
    @JacobHorne
    SC county data, looking for JSON