Location data processing system

A system, comprising at least one processor configured to perform instructions, the instructions comprising:

• receiving a request to create a column of a table, the request indicating drat the column is for storing location-based data;
• determining that the request includes a parameter indicating that the column is to be configured to store location-based data across a plurality of different coordinate systems;
• configuring the column to store location-based data across the plurality of different coordinate systems, wherein each data entry in the configured column includes both specific location-based data for one of the plurality of different coordinate systems and an identifier as to which of the different coordinate systems the specific location-based data corresponds;
• receiving the location-based data to be stored in the configured column, the location-based data including location-based data corresponding to at least one unknown coordinate systems of the plurality of different coordinate systems, wherein an identity of the unknown coordinate system is unknown at the receiving;
• dividing the received location-based data into a plurality of fragments, including a first fragment comprising a plurality of data entries, wherein a first data entry of the plurality of data entries in the first fragment includes a coordinate specification including metadata indicating how to evaluate corresponding location-based data of a first coordinate system represented by the first data entry;
• receiving a query for data from the first fragment that satisfies one or more attributes of the query;
• evaluating of the plurality of data entries of the first fragment based on the coordinate specification to identify at least a subset of data entries of the plurality of data entries stored on the first fragment that satisfy the one or more attributes of the query;
• and
• returning the identified subset of data entries responsive to the query.

A non-transitory computer-readable medium having instructions stored thereon that, when executed by at least one computing device, cause the at least one computing device to perform operations comprising:

• receiving a request to create a column of a table, the request indicating that the column is for storing location-based data;
• determining that the request includes a parameter indicating that the column is to be configured to store location-based data across a plurality of different coordinate systems;
• configuring the column to store location-based data across the plurality of different coordinate systems, wherein each data entry in the configured column includes both specific location-based data for one of the plurality of different coordinate systems and an identifier as to which of the different coordinate systems the specific location-based data corresponds;
• receiving the location-based data to be stored in the configured column, the location-based data including location-based data corresponding to at least one unknown coordinate systems of the plurality of different coordinate systems, wherein an identity of the unknown coordinate system is unknown at the receiving;
• dividing the received location-based data into a plurality of fragments, including a first fragment comprising a plurality of data entries, wherein a first data entry of the plurality of data entries in the first fragment includes a coordinate specification including metadata indicating how to evaluate corresponding location-based data of a first coordinate system represented by the first data entry;
• receiving a query for data from the first fragment that satisfies one or more attributes of the query;
• evaluating of the plurality of data entries of the first fragment based on the coordinate specification to identify at least a subset of data entries of the plurality of data entries stored on the first fragment that satisfy the one or more attributes of the query;
• and
• returning the identified subset of data. entries responsive to the query.