I've successfully created a geoevent service that polls an external website for GeoJSON and adds that data to a FS. The problem I'm having is only the FS table is being populated... no point geometries are showing up.
Below is the GeoJSON structure. I should mention there are "Polygon" features in the featureCollection.
{
"type": "FeatureCollection",
"features": [
{
"type": "Feature",
"geometry": {
"type": "Point",
"coordinates": [-70.629598999794, 43.8801679996535]
},
"properties": {
"RecordId": 177,
"UtilityId": 1,
"OutageId": "null",
"CustomersOut": 13,
"OutageCause": "System Upgrade",
"EstimatedRestoration": "2025-04-25T19:00:00Z",
"DateTimeRecorded": "2025-04-25T15:13:17Z"
}
}
}
Below is the auto-generated definition.

...What am I missing here?
Other bonus question 😁:
- how can I prevent duplicate rows being created after each poll?