Tomelilla kommun - konstig data

[salgo60]

Enormt konstig data

• www.dataportal.se/datasets/347_4226/grillplatser { "resultCount": 17, "offset": 0, "limit": 100, "queryTime": 2, "results": [ { "fid": "1", "sittplatser": "Ja", "photo1": "20220712_081917.jpg", "geom": "01010000A0C00B0000E038C0B233740541DC9FE370007F57410000000000000000", "photo2": "", "namn": "Grillplats" }, { "fid": "2", "sittplatser": "Ja och vindskydd", "photo1": "20220712_082648.jpg", "geom": "01010000A0C00B00001AFA49EB086A05416ABFEEA8F87E574100007AA825305340", "photo2": "20220712_082710.jpg", "namn": "Grillplats" }, { "fid": "3", "sittplatser": "Ja", "photo1": "20220712_083725.jpg", "geom": "01010000A0C00B0000538BDC7477640541D385A708E87E57413A37AFBE3A445240", "photo2": "", "namn": "Grillplats" }, { "fid": "4", "sittplatser": "Ja", "photo1": "20220712_084703.jpg", "geom": "01010000A0C00B000017BC0B5EFB5D054168BA2373ED7E574178E6B1379E665240", "photo2": "", "namn": "Grillplats" }, { "fid": "5", "sittplatser": "Ja", "photo1": "20220712_094134.jpg", "geom": "01010000A0C00B000096B76802A9DA054161B2166AE77C57410000000000000000", "photo2": "", "namn": "Grillplats" }, { "fid": "6", "sittplatser": "Ja och vindskydd", "photo1": "20220712_095429.jpg", "geom": "01010000A0C00B000068044AF5A1E10541EEDECD76DE7C5741000036EB49B15240", "photo2": "", "namn": "Grillplats" }, { "fid": "7", "sittplatser": "Ja", "photo1": "20220712_100713.jpg", "geom": "01010000A0C00B0000BE360FCCBCE40541659B7A7C057D574100008098195C4E40", "photo2": "", "namn": "Grillplats" }, { "fid": "8", "sittplatser": "Ja", "photo1": "20220712_103218.jpg", "geom": "01010000A0C00B000084EEEEDD171C06419C6ADBFC3B855741E4C2BFD281225A40", "photo2": "20220712_103231.jpg", "namn": "Grillplats" }, { "fid": "9", "sittplatser": "Ja och vindskydd", "photo1": "20220712_110129.jpg", "geom": "01010000A0C00B00007CA8D9D571E50641E8FD38C8CB90574100001AFFC8DE4D40", "photo2": "", "namn": "Grillplats" }, { "fid": "10", "sittplatser": "Ja", "photo1": "20220712_112036.jpg", "geom": "01010000A0C00B00007675458C81F30641A893339B719157410000F2C9DF974040", "photo2": "", "namn": "Grillplats" }, { "fid": "11", "sittplatser": "Ja och vindskydd", "photo1": "20220712_122740.jpg", "geom": "01010000A0C00B00006A28622A209B0641BBD9192F1D9157410000000000000000", "photo2": "20220712_122841.jpg", "namn": "Grillplats" }, { "fid": "12", "sittplatser": "Ja", "photo1": "", "geom": "01010000A0C00B0000AF2EFEA3390906414007D831639057417E5A6877CA8A5C40", "photo2": "20220712_130520.jpg", "namn": "Grillplats" }, { "fid": "13", "sittplatser": "Vindskydd", "photo1": "20220712_131142.jpg", "geom": "01010000A0C00B0000AC77B3ECDB0206414E2353FC559057410000C386426B5E40", "photo2": "", "namn": "Grillplats" }, { "fid": "15", "sittplatser": "Ja och vindskydd", "photo1": "20220712_134724.jpg", "geom": "01010000A0C00B0000DBAC0CD937900641CB762D46388357410000ED3364C25940", "photo2": "", "namn": "Grillplats" }, { "fid": "16", "sittplatser": "Ja", "photo1": "20220712_140707.jpg", "geom": "01010000A0C00B0000BB026E898D020741423624C2567E574100006C9728A94D40", "photo2": "", "namn": "Grillplats" }, { "fid": "17", "sittplatser": "Ja", "photo1": "20220712_141823.jpg", "geom": "01010000A0C00B0000ED59EE18690E0741D8AFB511A47E574100004BC811965040", "photo2": "", "namn": "Grillplats" }, { "fid": "18", "sittplatser": "Ja", "photo1": "20220712_144925.jpg", "geom": "01010000A0C00B0000DDF509ED9047064110A7B6087781574100003A59B8FD5340", "photo2": "", "namn": "Grillplats" } ] }

[salgo60]

Lite bättre på data.tomelilla.se eller denna

• dock denna url blir samma som ovan

[dpriskorn]

Chatgpt gissar att det är https://en.m.wikipedia.org/wiki/Well-known_text_representation_of_geometry https://chatgpt.com/c/66ebc371-d5a0-8012-b21b-d120d20ddea2

[salgo60]

Hm @dpriskorn blir vi gladare av det?

Bra föredrag om datadrivet och kommuner så jag la ner lite tid på att visa vad vi saknar

[dpriskorn]

Tyvärr blev avkodningen inte korrekt. Koordinaterna var i Danmark.

Min recension av den här datamängden: fullständigt värdelös, spill av min tid som datakonsument att sånt här skräp ens får finnas på dataportalen och att det inte finns någon vettig kontaktinformation till de som laddat up den.

Jag bad chatgpt utvärdera den här datamängden:

tl;dr

Long and polite version:

Given the information provided and the content of the web page you referenced, here is an analysis of the data quality, particularly focusing on the grillplatser (barbecue places) dataset:

1. Data Accessibility

• Pros:
  • The dataset is accessible through various formats (CSV, JSON, API), which is beneficial for different users and applications.
  • The data is openly available to the public, indicated by the "Publik" access rights, aligning with open data principles.
• Cons:
  • Lack of documentation or metadata describing the coordinate system or projection of the geometry data (geom), which is critical for geographic data interpretation and conversion.

2. Metadata Completeness

• The page mentions metadata download options (RDF/XML, TURTLE, N-TRIPLES, JSON-LD), which suggests the dataset has metadata available.
• Key missing elements in the provided description:
  • There is no explicit mention of the coordinate reference system (CRS) for the geometric data (geom), which makes it challenging to accurately convert to a standard system like WGS 84.
  • The dataset description and API references lack information on data quality, accuracy, or update frequency.
• Improvements Needed:
  • Including the CRS (e.g., EPSG code) in the metadata is crucial for anyone working with the geometry data.
  • Adding a section in the metadata explaining the data's precision, accuracy, and limitations would significantly enhance data usability.

3. Data Structure and Encoding

• The geometric data is provided as a hexadecimal string, which seems to follow a WKB-like structure. However, without proper documentation or specification of the exact format and CRS, decoding and converting this data accurately is problematic.
• Potential Issues:
  • Incorrect projection or transformation could result in misleading geographic information (e.g., positions showing up in Denmark instead of Sweden).
  • The structure of other data fields is unclear; for instance, fields like "sittplatser" (seating places) are marked as "Ja" (Yes) without context or specifications.
• Improvements Needed:
  • Explicitly define the encoding and CRS used for the geometry data in the documentation.
  • Provide field definitions, including data types, possible values, and descriptions.

4. Data Accuracy and Integrity

• The data appears to originate from a local government (Tomelilla kommun), which suggests it might be relatively reliable and accurate for public use.
• Quality Concerns:
  • Without information about the CRS, users can easily misinterpret or misuse the geometry data, leading to inaccuracies in applications.
• Recommendations:
  • The data provider should ensure that the coordinates are well-documented, with specific details about the CRS and precision.
  • Information about how often the data is updated (e.g., monthly, yearly) would add value, ensuring users know its currency.

5. Data Format Variety

• The availability of different formats (CSV, JSON, API) is a positive aspect as it allows flexibility in data usage.
• Gaps:
  • The lack of a specified CRS and detailed description in these formats affects the quality and usability of the geometric data.
• Suggestions:
  • When offering data through an API or downloadable files, always include a README or documentation file outlining key details like data encoding, CRS, and usage guidelines.

6. Usability

• For geographic data to be highly usable, users need to understand how to interpret the coordinates, which is impossible without CRS information.
• Further Clarification:
  • The data provider (Tomelilla kommun) should be contacted to confirm the exact CRS and provide a guide for interpreting the geometry data.

Overall Quality Assessment:

The main concern with this dataset is the lack of CRS information for the geometry data, which significantly hampers its usability for geographic applications. The absence of this crucial detail makes it difficult to correctly convert and map the coordinates.

Recommendations for improving data quality:

1. Explicitly include CRS information in the metadata and the main data documentation.
2. Provide a data dictionary or schema that explains each field and its format.
3. Add usage guidelines or an example of how to decode the geometry data, including transformations to standard coordinate systems like WGS 84.

Final Note

While the dataset seems valuable and potentially reliable (coming from a local municipality), the lack of key geographic metadata like the CRS critically impacts its usability. Improving the documentation and metadata quality will make this dataset more accessible and useful for broader applications.

[salgo60]

@dpriskorn Tror man måste inse att kommuner och även DIGG inte klarar av Öppen data se hur en kommun hittar på nya kooordinater varje gång en badplats anges