Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SIGMET invalid geometry #633

Open
globin opened this issue Aug 5, 2024 · 0 comments
Open

SIGMET invalid geometry #633

globin opened this issue Aug 5, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@globin
Copy link
Collaborator

globin commented Aug 5, 2024

Not all SIGMET geometries coordinates are polygons:

sqlalchemy.exc.InternalError: (sqlalchemy.dialects.postgresql.asyncpg.InternalServerError) <class 'asyncpg.exceptions.InternalServerError'>: geometry requires more points
HINT:  "...4 59.8,26.267 59.25,25.4 59.8))" <-- parse error at position 57 within geometry
[SQL: INSERT INTO sigmet ("isigmetId", "icaoId", "firId", "receiptTime", "validTimeFrom", "validTimeTo", "seriesId", hazard, qualifier, base, top, geom, dir, spd, chng, coords, "rawSigmet") VALUES ($1::INTEGER, $2::VARCHAR, $3::VARCHAR, $4::TIMESTAMP WITH TIME ZONE, $5::TIMESTAMP WITH TIME ZONE, $6::TIMESTAMP WITH TIME ZONE, $7::VARCHAR, $8::VARCHAR, $9::VARCHAR, $10::INTEGER, $11::INTEGER, $12::VARCHAR, $13::VARCHAR, $14::INTEGER, $15::VARCHAR, ST_GeomFromEWKT($16), $17::VARCHAR)]
[parameters: (781112, 'EETN', 'EETT', datetime.datetime(2024, 8, 5, 7, 45, 52, tzinfo=datetime.timezone.utc), datetime.datetime(2024, 8, 5, 8, 0, tzinfo=TzInfo(UTC)), datetime.datetime(2024, 8, 5, 12, 0, tzinfo=TzInfo(UTC)), 'T01', 'TS', 'FRQ', None, 33000, 'AREA', 'SSW', 5, 'NC', 'SRID=-1;POLYGON((25.4 59.8,26.267 59.25,25.4 59.8))', 'WSEO31 EETN 050745\nEETT SIGMET T01 VALID 050800/051200 EEMH-\nEETT TALLINN FIR FRQ TS FCST WI N5948 E02524 - N58937 E02700 - N5915\nE02616 - N5948 E02524 TOP FL330 MOV SSW 5KT NC=')]
@globin globin added the bug Something isn't working label Aug 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant