[OSGeo-Discuss] Population statistics in GIS Softwares

Stephen Woodbridge woodbri at swoodbridge.com
Sat Jun 3 11:29:34 PDT 2017

You can get all the Ceneus polygon areas that they report statistics 
about here:


ZCTA5 - Zip code tabulation areas
BG - block groups

There is good documention. If you loade these into postgis, then you can 
dos a simple query like:

select * from <table> where st_intersects(geom, 
st_setsrid(st_makepoint(long, lat),4326);

Also PostGIS has a Tiger geocoder and you could load that up, and then 
query to your hearts content.

-Steve W

On 6/3/2017 1:04 PM, Parv Aggarwal wrote:
> Hi all,
> I know the census geocoder can get lat/long and FIPS codes, up til 1000 
> entries… 1) what’s the best free alternative for over 1000 entries which 
> still preserves data privacy? 2) what’s the best way to batch 
> map/convert FIPS codes to zip codes or vice versa? I need to create an 
> equivalency to  be able to simultaneously view census and our own 
> population data.
> Sincerely
> Parv
> *From:* Parv Aggarwal
> *Sent:* Monday, May 22, 2017 11:59 AM
> *To:* 'discuss at lists.osgeo.org' <discuss at lists.osgeo.org>
> *Subject:* Population statistics in GIS Softwares
> Hi QGIS Community,
> I’m Parv, an analytics intern at the Latino Community Credit Union here 
> in North Carolina. I’m tasked with finding and using GIS software to 
> visualize both US Census data and our membership data at micro levels to 
> determine best locations for expansions. As per my instructions, this 
> means being able to:
> -Visualize Hispanic or Latino population by smaller units than zip 
> codes.  We have worked with Census tracts in the past and that is ideal, 
> but there are even smaller areas with population data, like census 
> blocks.  If we can see in a map where the higher number of Latinos live 
> and also see the streets so that we can imagine potential locations and 
> draw areas around them, we could identify optimal locations.
> -If we get a proposal for a location, for example a realtor contacts us 
> and says “I have a great place for rent at 1309 Cúcuta Dr,” we should be 
> able to enter the address in the software and define an area around it, 
> draw that area and know how many Latinos live there.  The areas could be 
> circles, free shape forms, circles cut by major highways or barriers we 
> would think people wouldn’t cross…
> -Of course we should be able to add our own data to the software, like 
> those addresses of our current members, and be able to look at, say, 
> total balances of members who live in a defined area.
> As we’re a non-profit, we prefer Open Source Ware over high cost ware 
> like ArcGIS. I have installed QGIS and am currently exploring its 
> capabilities via the user guide/training manual. I know I first have to 
> do a join on census csv population data and tract or block shapefiles. 
> Assuming I’m able to do that, I am trying to find relevant sections that 
> would show me how to do this micro level aggregation of population data. 
> I believe in ArcGIS this is called “create buffers around a point” but I 
> am not sure if this is the relevant way to do it in QGIS or not. I 
> searched for buffers in the training manual but I still can’t tell if it 
> means the same thing or is relevant for my purposes. I’m also going 
> through the vector analysis and processing sections but end up getting 
> lost on what’s relevant and what’s not. I wanted to ask if QGIS was 
> indeed the best suited software for this purpose or is there something 
> simpler out there I should check out instead.
> Sincerely
> Parv
> _______________________________________________
> Discuss mailing list
> Discuss at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/discuss

This email has been checked for viruses by Avast antivirus software.

More information about the Discuss mailing list