I have a MySQL table with 2 columns, id, a unique geometry id, and GeoJSON stored as a varchar, eg,
{"type": "Point", "coordinates": [116.4, 45.2, 11.1]}
{"type":"Polygon","coordinates":[[[-91.23046875,45.460130637921],[-79.8046875,49.837982453085],[-69.08203125,43.452918893555],[-88.2421875,32.694865977875],[-91.23046875,45.460130637921]]]}
{"type":"LineString","coordinates":[[-122.2963205,37.5359200],[-122.2975821,37.5370150]]}
{"type":"MultiPolygon","coordinates":[[[[-122.3035793,37.5391205],
[-122.3026703,37.5376882],[-122.3026739,37.5376868],[-122.3035843,37.5391212],[-122.3035326,37.5391600],[-122.3035298,37.5391576],[-122.3035793,37.5391205],[-122.3035793,37.5391205]]],[[[-122.3026703,37.5376882],[-122.3026703,37.5376882],[-122.3026703,37.5376882],[-122.3026703,37.5376882],[-122.3026703,37.5376882]]]]}
I wish to store this data in PostGIS, and then I will run queries to check if a given lat/lon is in any of the geometries stored in the DB or the distances to them, etc.
If I use the geometry datatype I will have to specify the type as point, polygon etc, but I want all types in one column.