Power Plants Map Update April 28, 2008

From the CARMA site I entered all the zip codes in Delaware County and downloaded the data set of power plants locations for each company servicing Delaware, for which there was data.

These companies include:

Columbus Southern Power (Owned by American Electric Power)
Ohio Power Co. (Owned by AEP)
Columbus Public Utilities
Duke Energy
First Energy
Dayton Power and Light Inc.

Unfortunately, I do not have data on which power plants are Nuclear, Solar, Wind, Coal or Garbage incinerators.

I made a different datasheet for each company, formatted the files and imported them into ArcGIS. About 3 points had to be removed because they were planned projects or old facilities, or otherwise had no coordinates. It took some tweaking with the files to get everything to work properly, some had to be imported multiple times to get everything to work. I don’t know the problems, other than Excel being buggy saving the files from .csv to .dbf and ArcGIS being buggy importing them.

After I got all the data together, I found that some of these power companies owned facilities in California and Europe– unlikely places to supply Delaware. Using the Definition Query I restricted the datasets to show data points only within the range of the midwest, generally.

Then, I pulled up a United States map showing all counties and used the Select by Attributes tool to select only the states with power plants and create a new layer from those. I did the same with Delaware County, forming a new layer so that Delaware would be a different color, highlighting our geographic location and providing reference.

Delaware Zips and Power Companies April 23, 2008

43003-ASHLEY- FirstEnergy Corp.

43011-CENTERBURG- Columbus Southern Power

43013- Ohio Power Co., Duke Energy Ohio, Columbus Southern Power

43015- Columbus Southern Power

43016- Columbus Southern Power

43017- Columbus Southern Power

43021- First Energy Corp., Ohio Power Co., Duke Energy Ohio, Columbus Southern Power, Dayton Power and Light.

43031- Columbus Southern Power

43032-

1. DUKE ENERGY OHIO INC
2. OHIO POWER CO
3. COLUMBUS SOUTHERN POWER CO
4. DAYTON POWER & LIGHT CO (OH)

43035-

1. FIRSTENERGY CORP
2. DAYTON POWER & LIGHT CO (OH)
3. DUKE ENERGY OHIO INC
4. OHIO POWER CO
5. COLUMBUS SOUTHERN POWER CO

43040- DAYTON POWER & LIGHT CO (OH)

43054- COLUMBUS SOUTHERN POWER CO

43061-

1. DUKE ENERGY OHIO INC
2. DAYTON POWER & LIGHT CO (OH)
3. COLUMBUS SOUTHERN POWER CO
4. OHIO POWER CO

43064- FIRSTENERGY CORP

43065- COLUMBUS SOUTHERN POWER CO

43066-

1. COLUMBUS SOUTHERN POWER CO
2. OHIO POWER CO
3. DAYTON POWER & LIGHT CO (OH)
4. DUKE ENERGY OHIO INC

43074- COLUMBUS SOUTHERN POWER CO

43081- WESTERVILLE ELECTRIC DIVISION (No Data)

43082- COLUMBUS SOUTHERN POWER CO

43235- COLUMBUS DIV OF ELEC (OH)

43240- COLUMBUS DIV OF ELEC (OH)

43334-

1. UNION RURAL ELECTRIC COOP INC (OH)
2. CONSOLIDATED ELECTRIC COOP INC (OH)
3. FIRSTENERGY CORP
4. OHIO POWER CO

43342- PROSPECT CORP (No Data)

43344-

1. FIRSTENERGY CORP

43356-

1. MID-OHIO ENERGY COOP INC (No Data)
2. OHIO POWER CO

Power Plants Map April 22, 2008

Power Plants location data coming from CARMA

Data can be located by 3 terms: individual plants, companies, locations

The most useful data for us will be searching for all Ohio plants, but mapping all the power plants owned by the companies servicing the different zips of Delaware County would be best, provided I can make the data work.

Data from the site comes in CSV format and can usually be downloaded after going to a “Get More Information” page, which is a small hard to find link. The link on the sidebar only gives summary statistics, NOT plant locations and data.

CSV data is easily imported and takes minimal formatting. However, ArcGIS has some problems with it along the various steps:

1. Importing X,Y Coordinate data ( Import > X,Y Data )
Excel rounds the coordinate data to the whole, so the coordinate data when imported into ArcGIS is wrong. This is solved in Excel by formatting the Lat/Long columns as Numerical with 4 decimal places.

2. No X,Y Data
3 entries do not have X,Y Coordinate data. Instead of deleting these entries I looked them up.
I noticed one entry is a “power plant” producing 2MWh, which seemed like too small amount. The plant also had no CO2 emissions and no year 2000 record. Upon visiting the web site for the company that owned it, the news sections mentioned a solar power research facility. Maybe this is it?
So, I found the location (maybe), went into Google Earth and entered in the Lat and Long. Hopefully it works.

Crude Starter Map:

Plans: I can look up power companies servicing Delaware by zip codes. I plan to look up and map the power plants owned by the companies operating in Delaware.

Mapping Tasks March 31, 2008

See Lauren Woods for the type-up.

Delaware as a Global Locality (Bucceri, Janney, Woods)

map: source of energy (plants elsewhere pollute, benefits Delaware Co)

Ohio Consumers’ Council List of Electricity Providers
However, this is excluding the Co-op electric providers
Alternative Energy Projects
Public Utilities Commission of Ohio (PUCO) GIS Page

Breakdown of energy sources

CARMA

map: local energy sources (solar, wind)

Wind Power

map: garbage export?
map: source of food: 5 common grocery items w/problematic sources (global)

Bananas

‘Organic’ problems

Beef

Recycling

Solid Waste Dist. Information
Recycling Drop-off Addresses
Abitibi Paper Drop-off
Household Hazardous Waste Drop-offs

For more Information on Keep Delaware County Beautiful, Please contact Jenifer Way-Young, by email, or by calling 740.368.1700

more information on Solid Waste Disposal, Contact Doug Sams, R.S., Program Manager at 740.203.2064, or doug@delawarehealth.org

Composting

Ohio Dept. of Development

Delaware GIS Data March 3, 2008

• Annexations: annexations and conforming boundaries from 1853 to present (unknown last update).
• Census-Block: some brief census data in blocks, including total population, household data, family size. 2000 data.
• Census-BlockGroup: brief census data in block groups (maybe too large to see spatial patterns on the county level), including the above family demographics and poverty levels, ratios. 2000 data.
• Census-Tract: even larger census data grouping with the same information as Block Groups. 2000 data.
• Delaware_Address_pts: Contains Landuse data, address data, business names. May be the same as Master Point data.
• Delaware_Buildings_1: Contains points of fairgrounds, EMS stations, Fire Dept, Township Halls, Hospitals.
• Delaware_Buildings_2: City buildings such as police depts, libraries, interstate rest areas, weigh stations, city and state buildings.
• Delaware_Cemeteries: Point data on cemeteries. NO area data or anything else.
• Delaware_Farmlot: Farmlot data with area data and townships.
• Delaware_GolfCourse: point data for golfcourses including the name of the course.
• Delaware_Municipalities: Municipalities with name and area.
• Delaware_Parcels: Parcels with owner information, area, address, taxable land, market data, room #s, sale dates, basement types, garage types, school district, annual taxes.
• Delaware_Parks:
  • parkpts.shp: point data with park names.
  • park.shp: polygon data with name and address.

• Delaware_PostOffice: Point data with addresses for post offices.
• Delaware_Schools: Point data with school name, type.
• Delaware_Subdivision: polygon data for subdivisions with name, twp_id, date, number of lots, area, condos.
• Delaware_Taxdist:
• Delaware_Townships:
• Floodplains:
  • floodway> floodway.shp: polygon floodway data with area and perimeter, level data.
  • fp100> fl100.shp: polygon for 100-year floodplain. same data as floodway.
  • fp500> fl500.shp: polygon for 500-year floodplai. same data as floodway.
  • femagrid: ??? no description, just a large grid.
  • fpbfe: ??? a bunch of polylines down the major waterways with length data. no description.
  • fpcs: ??? same as fpbfe.
  • fpfw: floodway data.
  • usgsgrid: USGS grid data for the area.
    • a bunch of associated data files with the above.
• Historical_Archaeological: point data for archaeological sites and ref numbers, but no other data.
• Historical_Delaware: local historical site point data, no other data.
• Historical_National: national historical site point data, no other data.
• Hydro-detail:
• • fphydro.shp: waterway and floodplain data including waterways, area, perimeter, level, name.
  • arc_Clip:Polyline of Delaware Run
  • arc_Clip1: Olentangy River.
  • arc_clip1_buffer: Olentangy River polygon.
  • arc_clip1_buffer_erase: Olentangy River ???
  • arc_clip2: Mill Run
  • arc_clip2_buffer: Mill Run polygon.
  • arc_clip3: Sugar Run.
  • arc_clip3_buffer: Sugar Run polygon.
  • arc_clip4: NO DATA
  • arc_clip4_buffer: NO DATA
  • arc_clip5: Olentangy River through town.
  • arc_clip5_buffer: Olentangy River polygon.
  • arc_clip6: ponds, intermittent streams, delaware run and olentangy river in delaware city.
  • arc_clip6_buffer: intermittent streams polygon.
  • arc_clip_buffer: Delaware Run polygon.
  • arc_clip_buffer1: NO DATA in table. appears to be delaware run.
  • arc_clip_buffer2: NO DATA in table, appears to be delaware run.
  • buffer_of_del_run: Buffer of Delaware run.
  • buffer_of_del_run2: Buffer of Delaware Run, different size.
  • buffer_of_del_run3: Buffer of Delaware Run, different size.
  • buffer_of_del_run4: Buffer of Delaware Run, different size.
  • buffer_of_parcels: ???
  • delrun: Delaware run line with length.
• Master_Point: point map of landuse, address, subdivision name, houses/buildings
• Natural Heritage ODNR: point data with reference numbers, no other data.
• OrthoPhotoAp2006: Does not appear to display at the same coordinates as other data.
• • Delaware_2006_Half-ft_North.sid: photographs of the north side of Delaware taken in april 2006.
  • Delaware_2006_Half-ft_South.sid: photographs of the south side of Delaware taken in april 2006.
• Precincts: voting precincts with total voter data, party registrations data.
• Public Land Survey System: polygon areas with area data, perimeter data, ids, twp info.
• Railroad: polylines with length data.
• School: school district areas.
• Soil: Soil types and descriptions
• Topography: by township (20) not sure what the interval is.
• Townships_Historical: 18 historical township districts of delaware.
• Traffic_MORPSE: Traffic zones with population data,# cars, other data with abbreviations unknown.
• Watersheds_ODNR: Watersheds by area, but does not contain information about what they drain into.
• Wetlands: by area, perimeter, description, class, & more.
• Woodlands_ODNR: by area and code.
• Zip2004:
• • Zip2003: Zip code areas- 2003.
  • Zip2004: zip code areas, clear shapes and areas.
• Zoning:
  • historicdist: historical district
  • zoning0200: zoning area over delaware city with zoning codes.

Tutorial Ch. 17, 18, 19, 20 March 3, 2008

done, except I couldn’t do the address locater exercise.

Tutorial Ch. 14, 15, 16 March 2, 2008

The New Features wizard from ArcCatalog was completely different and almost unrecognizable from the one in the book. However, I think I completed the exercise correctly.

Tutortial Ch. 10-13 February 25, 2008

Finished. No problems. Even tinkered a little with making maps from the various datasets.

It will be difficult to remember all of the ArcToolbox functions.

Tutorial Ch. 8,9 February 22, 2008

Couldn’t get the report generator to work on my laptop, but it seems very useful. I will complete that part of 8 in the lab.

So, 8 and 9 complete. Should be useful for Airpollution

I didn’t know the difference between joins and relates.

Tutorial Ch. 3,4,5,6,7 February 21, 2008

Getting to Know ArcGIS Ch. 3-7

Was a little tedious, but I got a little more in depth with some software details than I did in 353. I hadn’t used ArcCatalog before, or gone into so much depth with the labeling details.