Dataset 10009

From Data-gov Wiki

Jump to: navigation, search
Metadata
  • Title: ZCTAs (ZIP Code Tabulation Areas) - US Census 2000
  • Publisher: US Census Bureau
  • Description: The ZCTA file contains data for all 5 digit ZCTAs in the 50 states, District of Columbia and Puerto Rico as of Census 2000. The file is plain ASCII text, one line per record.
  • Keywords: zip code
  • Homepage:
  • Source: http://www.census.gov/tiger/tms/gazetteer/zcta5.txt
  • Parent Dataset:
RDF data
Links
  • Demos:
NOTES: This dataset covers data with following features: state,population,county,zipcode.
Infobox (Other Government Dataset) edit with form
  • name: ZCTAs (ZIP Code Tabulation Areas) - US Census 2000

  • description: The ZCTA file contains data for all 5 digit ZCTAs in the 50 states, District of Columbia and Puerto Rico as of Census 2000. The file is plain ASCII text, one line per record.
  • keyword(s): zip code
  • created: 2000
  • publisher(s): US Census Bureau
  • source: http://www.census.gov/tiger/tms/gazetteer/zcta5.txt
  • modified: 2010-5-17



Overview

The ZCTA file contains data for all 5 digit ZCTAs in the 50 states, District of Columbia and Puerto Rico as of Census 2000. The file is plain ASCII text, one line per record.

   * Columns 1-2: United States Postal Service State Abbreviation
   * Columns 3-66: Name (e.g. 35004 5-Digit ZCTA - there are no post office names)
   * Columns 67-75: Total Population (2000)
   * Columns 76-84: Total Housing Units (2000)
   * Columns 85-98: Land Area (square meters) - Created for statistical purposes only.
   * Columns 99-112: Water Area (square meters) - Created for statistical purposes only.
   * Columns 113-124: Land Area (square miles) - Created for statistical purposes only.
   * Columns 125-136: Water Area (square miles) - Created for statistical purposes only.
   * Columns 137-146: Latitude (decimal degrees) First character is blank or "-" denoting North or South latitude respectively
   * Columns 147-157: Longitude (decimal degrees) First character is blank or "-" denoting East or West longitude respectively

Queries

prefix rdf:       <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
prefix rdfs:      <http://www.w3.org/2000/01/rdf-schema#> 
prefix foaf:      <http://xmlns.com/foaf/0.1/> 
prefix dgp10009:  <http://data-gov.tw.rpi.edu/vocab/p/10009/>

select ?state ?population_zipcode  ?zipcode ?total_housing_zipcode
where {
  graph <http://data-gov.tw.rpi.edu/vocab/Dataset_10009> {
     ?s dgp10009:total_population         ?population_zipcode ;
        dgp10009:zipcode                  ?zipcode;
        dgp10009:total_housing            ?total_housing_zipcode;
        dgp10009:usps_state_abbreviation  ?state.
 }
}
limit 10
prefix rdf:       <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
prefix rdfs:      <http://www.w3.org/2000/01/rdf-schema#> 
prefix foaf:      <http://xmlns.com/foaf/0.1/> 
prefix dgp10009:    <http://data-gov.tw.rpi.edu/vocab/p/10009/>

select ?state (sum(?population_zipcode) as ?population)  (sum (?total_housing_zipcode) as ?total_housing)
where {
  graph <http://data-gov.tw.rpi.edu/vocab/Dataset_10009> {
    ?s dgp10009:total_population         ?population_zipcode ;
       dgp10009:total_housing            ?total_housing_zipcode;
       dgp10009:usps_state_abbreviation  ?state.
  }
} group by ?state limit 10
Facts about Dataset 10009RDF feed
Dc:identifierdgtwc10009  +
Dcterms:created2000  +
Dcterms:descriptionThe ZCTA file contains data for all 5 digit ZCTAs in the 50 states, District of Columbia and Puerto Rico as of Census 2000. The file is plain ASCII text, one line per record.
Dcterms:modified2010-5-17
Dcterms:publisherUS Census Bureau  +
Dcterms:sourcehttp://www.census.gov/tiger/tms/gazetteer/zcta5.txt  +
Dcterms:subjectzip code  +
Dgtwc:complete datahttp://data-gov.tw.rpi.edu/raw2/10009/data-10009.nt.gz  +
Dgtwc:link datahttp://data-gov.tw.rpi.edu/raw2/10009/link00001.rdf  +
Dgtwc:linked data entry pointhttp://data-gov.tw.rpi.edu/vocab/Dataset_10009  +
Dgtwc:number of entries33,233  +
Dgtwc:number of properties11  +
Dgtwc:number of triples398,957  +
Dgtwc:uses property10009/note  +, 10009/land area square meters  +, 10009/land area square miles  +, 10009/latitude  +, 10009/total population  +, 10009/longitude  +, 10009/water area square meters  +, 10009/zipcode  +, 10009/water area square miles  +, 10009/total housing  +, and 10009/usps state abbreviation  +
Dgtwc id10009  +
FeaturesZCTA  +
Foaf:nameZCTAs (ZIP Code Tabulation Areas) - US Census 2000
Has featureState  +, Population  +, County  +, and Zipcode  +
Rdfs:seeAlsohttp://data-gov.tw.rpi.edu/raw2/10009/index.rdf  +
Skos:altLabelZCTAs (ZIP Code Tabulation Areas) - US Census 2000  +, zctas (zip code tabulation areas) - us census 2000  +, and ZCTAS (ZIP CODE TABULATION AREAS) - US CENSUS 2000  +
Personal tools
internal pages