2010 census summary file 1 data engine
DESCRIPTION
2010 Census Summary File 1 Data Engine. MD State Data Center Affiliate meeting December 10, 2012. Summary File 1 DVD. 2 DVD set – US Summary (all states/ all geographies) & National level only User’s Guide on Disc1 with instructions - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/1.jpg)
Planning.Maryland.gov
2010 CENSUS SUMMARY FILE 2010 CENSUS SUMMARY FILE 11
DATA ENGINEDATA ENGINEMD State Data Center Affiliate
meetingDecember 10, 2012
![Page 2: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/2.jpg)
Planning.Maryland.gov
• 2 DVD set – US Summary (all states/ all geographies) & National level only• User’s Guide on Disc1 with instructions• Must install proprietary software AND data on your computer!• Data are in compressed proprietary format and can only be used with the software• Can do radius profile (need to provide lat/long)
SUMMARY FILE 1 DVDSUMMARY FILE 1 DVD
![Page 3: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/3.jpg)
Planning.Maryland.gov
• http://geocoder.us/
• http://stevemorse.org/jcal/latlon.php
URLS FOR ADDRESS LATITUDE URLS FOR ADDRESS LATITUDE AND LONGITUDEAND LONGITUDE
NOTE: SF1 DVD does NOT have capability to do radius profile from an address without having latitude and longitude coordinates
![Page 4: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/4.jpg)
Planning.Maryland.gov
•WORKSPACE Can save selections to a workspace and retrieve later
• PICK GEOGRAPHY Select the geographic area of interest
•OUTPUT Save to a file or to a temporary report; various file options
• VARIABLES Pick entire tables or individual items from table
APPLICATION TABSAPPLICATION TABS
![Page 5: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/5.jpg)
Planning.Maryland.gov
Database is the file you are using (2010 SF1)
Assigning a workspace is optional; if you want to reuse the variables or geographies later you should create one
![Page 6: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/6.jpg)
Planning.Maryland.gov
Select Geography Tab
Places by State
![Page 7: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/7.jpg)
Planning.Maryland.gov
![Page 8: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/8.jpg)
Planning.Maryland.gov
![Page 9: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/9.jpg)
Planning.Maryland.gov
Select a file such as xls, csv, html, db, shapefile or a print ready report
![Page 10: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/10.jpg)
Planning.Maryland.gov
![Page 11: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/11.jpg)
Planning.Maryland.gov
Click on latitude and longitude and then the select button to get the coordinates for Towson CDP
![Page 12: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/12.jpg)
Planning.Maryland.gov
To select the lat/long for a specific geographic area
![Page 13: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/13.jpg)
Planning.Maryland.gov
![Page 14: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/14.jpg)
Planning.Maryland.gov
Report is written to a temporary location
![Page 15: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/15.jpg)
Planning.Maryland.gov
Enter the coordinates from your report for Towson or if you have selected a specific address you must look up the coordinates from a website
To get a radius profile click on the File dropdown and select “Add Radius”
![Page 16: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/16.jpg)
Planning.Maryland.gov
![Page 17: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/17.jpg)
Planning.Maryland.gov
Variables Tab
![Page 18: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/18.jpg)
Planning.Maryland.gov
Your previous selections for radii are saved here under “Pick Geography”
![Page 19: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/19.jpg)
Planning.Maryland.gov
Output Tab
Select a file such as xls, csv, html, db, shapefile or a print ready report
![Page 20: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/20.jpg)
Planning.Maryland.gov
Summary Report for Towson CDP
Individual reports for Towson CDP and the 1,3,5 mile radii
![Page 21: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/21.jpg)
Planning.Maryland.gov
5 mile radius report from Towson CDP
![Page 22: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/22.jpg)
Planning.Maryland.gov
![Page 23: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/23.jpg)
Planning.Maryland.gov
To save work to an Excel spreadsheet select File for output
![Page 24: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/24.jpg)
Planning.Maryland.gov
Saved to a spreadsheet file
![Page 25: 2010 Census Summary File 1 Data Engine](https://reader036.vdocuments.us/reader036/viewer/2022062314/56812b4a550346895d8f6b25/html5/thumbnails/25.jpg)
Planning.Maryland.gov