Fair enough. So, where tl_2010_06_bg10.shp is the tigerlines file for CA from the 2010 census (I think)...

$ ogrinfo -so tl_2010_06_bg10.shp tl_2010_06_bg10

INFO: Open of `tl_2010_06_bg10.shp'
      using driver `ESRI Shapefile' successful.

Layer name: tl_2010_06_bg10
Geometry: Polygon
Feature Count: 23212
Extent: (-124.482003, 32.528832) - (-114.131211, 42.009517)
Layer SRS WKT:
GEOGCS["GCS_North_American_1983",
    DATUM["North_American_Datum_1983",
        SPHEROID["GRS_1980",6378137,298.257222101]],
    PRIMEM["Greenwich",0],
    UNIT["Degree",0.017453292519943295]]
STATEFP10: String (2.0)
COUNTYFP10: String (3.0)   <-----County FIPS code
TRACTCE10: String (6.0)
BLKGRPCE10: String (1.0)
GEOID10: String (12.0)
NAMELSAD10: String (13.0)
MTFCC10: String (5.0)
FUNCSTAT10: String (1.0)
ALAND10: Real (14.0)
AWATER10: Real (14.0)
INTPTLAT10: String (11.0)
INTPTLON10: String (12.0)

COUNTYFP10 is the county FIPS code. So to limit the output by county, say Alameda which has a county FIPS code of 001 (these are in wikipedia and other sites, just google)...

ogr2ogr -f KML test.kml tl_2010_06_bg10.shp -where "COUNTYFP10 = '001'"

That results in a 2MB KML file which loads fine for me. The where clause is just SQL, so you can put whatever criteria you want, or multiple counties with "COUNTYFP10 in('001','002',...)"

Failing that, uDig is a pretty cool (and free) GIS tool that lets you perform basic GIS functions, like union.

GIS! Where there's a geek, there's a way! ;-)

-Kristian

On 08/11/2014 11:45 AM, Cameron Crum wrote:
Kristian et al,

While the ogr2ogr would work, this would require having the blocks in individual shape files if you wanted only a few. I think you can only get them as a shape (for free anyway) by whole state...could be wrong. That would either create a very large kml, which may not load in a google map, or could eat a lot of memory in google earth. i.e. Texas has almost 1 million blocks. I'm not sure you could load that many objects into either program although I haven't tried. Using a GIS tool to only select the ones you need and export to KML might be a better approach for those only needing a few blocks mapped. It might be well worth the time to have Brian or another GIS competent person do it for you.


On Mon, Aug 11, 2014 at 12:36 PM, Kristian Hoffmann <[email protected] <mailto:[email protected]>> wrote:

    Specifically...

    ogr2ogr -f output.kml input.shp

    -Kristian


    On 08/11/2014 09:00 AM, Sam Tetherow wrote:
    ogr2ogr will do all sorts of Geo formats, geojson, tiger shape,
    kml, kmz.


    On 08/11/2014 10:24 AM, Gino Villarini wrote:
    Anyone has a way to convert files for google earth evaluation?



    Gino A. Villarini
    President
    Aeronet Wireless Broadband Corp.
    www.aeronetpr.com <http://www.aeronetpr.com>
    @aeronetpr




    _______________________________________________
    Wireless mailing list
    [email protected]  <mailto:[email protected]>
    http://lists.wispa.org/mailman/listinfo/wireless



    _______________________________________________
    Wireless mailing list
    [email protected]  <mailto:[email protected]>
    http://lists.wispa.org/mailman/listinfo/wireless


    _______________________________________________
    Wireless mailing list
    [email protected] <mailto:[email protected]>
    http://lists.wispa.org/mailman/listinfo/wireless




_______________________________________________
Wireless mailing list
[email protected]
http://lists.wispa.org/mailman/listinfo/wireless


_______________________________________________
Wireless mailing list
[email protected]
http://lists.wispa.org/mailman/listinfo/wireless

Reply via email to