I have a table with X, Y (long, lat) coordinates I wish to add to an existing Spatialite database. I am led to believe I need to create a geometry column specifying SRID 4326 when using long, lat. I have successfully imported the table and created the geometry column using help from here. However, I need to execute spatial queries with this table against others in my database, and all other tables have SRID 2898 - (NAD83(HARN) / Michigan South (ft). I assume tables need to be in the same SRID for spatial queries to work, e.g., ST_Contains. I tried using SetSRID, but received an error that this violates a geometry constraint. How should I proceed?
أكثر...
أكثر...