Additional data to be added to census blocks

[amandaaprahamian]

Currently, only usage data has been joined to the census block shape files.

Join the additional data to the shape files:

1. x miles from the beach
2. xxxx landscaped area
3. xxx people
4. xxx water saving improvements*
5. total savings of $XXX*
6. competition details**
7. Your address is eligible for the XXX rebate program**
8. Here’s your goal: xxxxxx xxx xxxx**
9. Text and photos regarding stormdrain education*** (ex: Remember, your stormdrains drain excess outdoor watering directly to the ocean, this outfall drains your neighborhood water into the nearest stream…see photos here...)

what is our time frame for these numbers? in the last year? the last 5 years? I suggest a time period that gives us impressive numbers, but is easy to take in (so maybe not 5 long years)? applicable only if unique to census blocks. if water district wide, we can add text about it to the web app without needing it joined to the shape files some census blocks have no outfalls in view. we need to decide what to write in this section for those census blocks (we could just make it general and have stock photos of outfalls for these census blocks).

[patwater]

Sorry for the delay. We're on this internally though and will get back to you ASAP. CC @monobina @dmarulli @datwater

[monobina]

I just shared the link to the data with @amandaaprahamian cc @patwater @datwater @dmarulli

[monobina]

@amandaaprahamian let us know if you need anything else

[amandaaprahamian]

@monobina thanks! I can't quite tell what the column names stand for. Does this link include information about miles from the beach, landscaped area, # of people, # of water saving improvements, total saving$, competition details, the different rebate programs, and individual or overall goals?

[monobina]

@amandaaprahamian hhsize column stands for the household size, irr_area_sf is the irrigated area of of the household,usage_et_amount is the ET information, and usage_ccf is their water usage. I think this data does not have miles from beach but should be easy to calculate with the geiod in GIS? Looks like this specific data does not have the rebate details. @dmarulli @patwater @datwater do we have any ready to share data yet with the rebate programs and water savings details @amandaaprahamian is asking for?

[monobina]

Looking at the data i think the hhsize is number of people in that census block and irr_area_sf is the total irrigated area in the block? Correct me if I am wrong @dmarulli

[dmarulli]

Hey, that's correct @monobina. And just to be explicit, we arrive at those values aggregating up from the customer-level. This allows us track any changes at the census block-level with monthly granularity as opposed to decadal granularity (the frequency with which block-level data are released by the US Census Bureau). One can still use the geoid column to join with any relevant Census data of course.

[monobina]

Thanks @dmarulli ! This makes sense

[amandaaprahamian]

@monobina what are the units of usage_ccf (water usage)? Is it per capita or total for that census block? @leighphan

[monobina]

@dmarulli do you know what are the units of usage_ccf in the data? is it per capita or total for the census block?

[dmarulli]

Total usage for the month (each record represents a single month) @monobina @amandaaprahamian @leighphan

[patwater]

And @monobina usage_ccf is in ccf I believe

[monobina]

@patwater yes it's ccf

[patwater]

Great do you all have the data you need?

[monobina]

I did not receive any link to the data yet.

[christophertull]

I thought I sent an email last week @monobina. Maybe it didn't go through? will resend now.

[monobina]

I did not find any email with the data. It could be that it bounced back.

[monobina]

@christophertull received your dropbox data link now