loadGeometry fails to transform geom_local_value when source is character

[kzollove]

This issue manifests as unable to transform source to wgs84, but after a little digging, it forces another issue: how to handle source data that contains multiple CRS.

Solution for multiple CRS: break into distinct DFs by CRS, transform to wgs84, then recombine.

When should this CRS step occur? Probably before the main error in this issue is ever encountered... A bit of a chicken or egg situation.

[tibbben]

Just need to force geom type on column, sometimes the geom column comes in as archer (not geom) during ETL.

[kzollove]

This was related to a data_source that isn't in the main catalog, but should be.

Once OHDSI/gaiaDB#24 and OHDSI/gaiaDB#9 are closed, try this again (101 in the example picture refers to aqs_sites from OHDSI/gaiaDB#24)

[kzollove]

Not sure if this is the exact same bug, but this can seemingly be reproduced with:

[kzollove]

Not sure if this is still a thing, would like to see if it can be reproduced.

If so address immediately.