1 / 13

Public Water in California

Public Water in California. What are the Drivers of Privatization in LA County?. The Model Automates Comparison between GSWC-Served Areas and Places with Public Water Utilities. Starts with the Census Places shape file, which already has race and GSWC marker.

elisha
Download Presentation

Public Water in California

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Public Water in California What are the Drivers of Privatization in LA County?

  2. The Model Automates Comparison between GSWC-Served Areas and Places with Public Water Utilities Starts with the Census Places shape file, which already has race and GSWC marker Creates two selections: places that are served by GSWC and places that are not Calculates mean and standard deviation for percent nonwhite nonasian. Outputs two tables, each containing the summary statistics

  3. Metadata

  4. Skills • Inset Map, Color Graduated Symbol • Color Graduated Symbol, Joined Excel Data from USGS on water usage to County Layer • Color Graduated Symbol • Color Graduated Symbol • Clipped Aqueducts and Dams to CA from a US data set; Made an attribute sub-set selection to exclude minor streams and exported selection as a new layer; Made a field query for conditional labeling • Water utilities: Geocoded from CA-EDD database using LA County Street File for address locator, manually added zip codes. Clipped census places to LA County, joined demographic data from American Fact Finder. Converted labels to annotation. Added inset map. • Created GSWC polygon file using information from GSWC website. Used select by location with an active selection in LA County to select dams in LA County and export them as a new layer. • Used select by location to find rivers originating in areas with high precipitation, i.e. “full” rivers. Exported as a new layer, then created 1 mile buffer around those rivers. • Used a model to compare race data inside and outside of GSWC service areas. Added hatching to represent GSWC service areas. • The model output as a .dbf file and this is the information from that file. • Metadata sheet.

More Related