[QUESTION] How To Geocode on US State Level?

[TheCedarPrince]

[QUESTION] How To Geocode on US State Level?

[kzollove]

It would be possible but we don't support it with a dedicated method.

For reference, this is the table that stores geocoded information and is used in downstream processes like creating CDM extension table exposure_occurrence,

While we recommend using our Gaia function for geocoding, this table can be created and populated by any means.

In your case, you could put any coordinates to represent a state or zip (centroid seems like the ideal choice) and then those patients or care sites that are geocoded could now be used in transformations at that level of granularity.

What we don't have is any way to maintain provenance for those geocoded addresses (populated via function, address-level vs zip-level), which could be nice.

We don't have plans to introduce a function to handle geocoding state or zip level information, though we have heard this brought up before and would accept a PR.

I will make a point to update geocoding documentation to better explain the geom_omop_location table and possibly include some examples to illustrate this.

[TheCedarPrince]

In your case, you could put any coordinates to represent a state or zip (centroid seems like the ideal choice) and then those patients or care sites that are geocoded could now be used in transformations at that level of granularity.

That's what I was thinking! But I didn't see how to then next filter by state level data using gaia -- would I just have to look through the variables.csv?

What we don't have is any way to maintain provenance for those geocoded addresses (populated via function, address-level vs zip-level), which could be nice.

Like a label to say "this data's lat/long were created artificially" versus "geocoded with degauss"?

We don't have plans to introduce a function to handle geocoding state or zip level information, though we have heard this brought up before and would accept a PR.

What would a PR like this look like? I'd only be interest in state at the moment so in my mind, it would be a function like stateCoder which would:

1. Grab the location table for a cohort
2. Look at the state table
3. Allow a user parameter for exact location handling method
   1. Centroid
   2. Specific location (this could handle the ZIP question too potentially)
4. Encode location using specified method

What do you think?

Thanks!