Ugh. Could not drag + drop the city parcel data from #QGis into #PostGIS, but at least the message helps.
=
Failed to import layer!
Feature write errors:
Creation error for features from #-9223372036854775808 to #-9223372036854775808. Provider errors were:
PostGIS error while adding features: ERROR: numeric field overflow
DETAIL: A field with precision 23, scale 15 must round to an absolute value less than 10^8.
Stopping after 16940 error(s)
Only 17013 of 33953 features written
=
#BadMojo
Jim Spath
npub12s…fdgt7
2026-08-20 12:18:40 UTC
in reply to nevent1q…wjng
Author Public Key
npub12s54edrsm9u2n4rvvkszez557mka70c22774xmnjkx942lllvlzs2fdgt7Seen on
wss://relay.ditto.pubPublished at
2026-08-20 12:18:40 UTCEvent JSON
{
"id": "9f7c70b7daf35aa79d74b4924d635489e131e1cabfe7f02b1b84578d7058274f",
"pubkey": "54295cb470d978a9d46c65a02c8a94f6eddf3f0a57bd536e72b18b557fff67c5",
"created_at": 1787228320,
"kind": 1,
"tags": [
[
"e",
"41eab5aff645ef0f809378819d893513dd6f0a7b57f1527dda9bbbff62fefeb0",
"wss://relay.ditto.pub",
"reply"
],
[
"t",
"qgis"
],
[
"t",
"postgis"
],
[
"t",
"badmojo"
],
[
"proxy",
"https://chaos.social/users/jspath55/statuses/117127795197454794",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "Ugh. Could not drag + drop the city parcel data from #QGis into #PostGIS, but at least the message helps.\n\n=\nFailed to import layer!\n\nFeature write errors:\nCreation error for features from #-9223372036854775808 to #-9223372036854775808. Provider errors were:\nPostGIS error while adding features: ERROR: numeric field overflow\nDETAIL: A field with precision 23, scale 15 must round to an absolute value less than 10^8.\n\nStopping after 16940 error(s)\nOnly 17013 of 33953 features written\n=\n\n#BadMojo",
"sig": "3978e6bc79b367961e3e92317c675b260df16c1f0039addb54ff765f3f1d1df1c01888d4e57dde1b13a01fa0be8034a80ea36a16d82850834accbddaf34d4677"
}