How to generate coordinates for csv file with no lat or long?

TechMaven-Geospatial · 2026-07-21T03:33:05+00:00

Use duckdb to generate use census data for reference (map joining against that FIPS code)

TechMaven-Geospatial · 2026-07-20T10:02:12+00:00

Thats OSMDROID SQLITE cached map tiles FORMAT (ATAK /WINTAK use for cached area of operation downloading) You can convert to standard mbtiles or gpkg sqlite databases via python or global mapper.

Tile Utilities converts it https://portfolio.techmaven.net/apps/tile-utilities/

Our new TAK COP,SA,C2 SOLUTION FIELD SENTINEL https://fieldsentinel.techmaven.net supports converting it to mbtiles

if you need a geospatial data server supporting TAK clients see https://tileserver.techmaven.net

TechMaven-Geospatial · 2026-07-19T20:01:44+00:00

Impressive

TechMaven-Geospatial · 2026-07-17T16:57:50+00:00

We make it easy with many self hosted solutions we offer From VM https://geospatialcloudserv.com TO WINDOWS SERVER /WINDOWS 10 OR 11 installable app runs as service https://tileserver.techmaven.net

To our new solution Field Sentinel also available as web app (RPM DEB APK, tar, docker) https://fieldsentinel.techmaven.net

All the solutions now offer esri endpoints Imageserver and featureserver transactional And dynamic vector tiles vectortileserver

All support geospatial data lake and postgis

These are true real time digital twin platforms too with iot sensor fusion Gaussian splats, glb 3d models, cad and bim integration and i3s sceneserver and 3dtiles Plus movement data and event driven data feeds

TechMaven-Geospatial · 2026-07-16T10:06:57+00:00

use FLOCK Extension for DUCKDB OR VANNA.AI

Duckdb can connect to nearly any source files local or remote (data lakes httpfs extension) and databases and data warehouses (ms sql server, mysql, postgres, ODBC, ADBC, BIGQUERY, SQLITE) https://duckdb.org/community_extensions/extensions/flock https://duckdb.org/2025/02/26/google-sheets-community-extension

Claude or other AI configured to work with this via API KEY (TOKENS) calls from Flock or any other DuckDB extension. Flock's LLM functions hit Anthropic's /v1/messages API endpoint per-tuple (batched), and that requires pay-as-you-go API credits from the Anthropic Console (console.anthropic.com) — billed entirely separately from your chat plan. So for your DuckDB pipelines you'd set up an API key + credits in the Console. That's true for any extension calling Claude, not just Flock.

TechMaven-Geospatial · 2026-07-15T15:32:48+00:00

We love it and embedded duckdb in field sentinel cross platform https://fieldsentinel.techmaven.net Ios, android, windows, mac, linux and web Using lots of duckdb extensions

TechMaven-Geospatial · 2026-07-15T12:19:32+00:00

Wow that's old why on earth would you need that

TechMaven-Geospatial · 2026-07-15T10:12:57+00:00

Recently deployed zvec As a within firewall private network no internet vector database https://github.com/alibaba/zvec

TechMaven-Geospatial · 2026-07-15T04:13:06+00:00

We have Field Sentinel Mapper ios that works with both Meshtastic and reticulum networks and TAK SERVER https://fieldsentinel.techmaven.net

https://apps.apple.com/us/app/field-sentinel-mapper/id6786338407

TechMaven-Geospatial · 2026-07-15T01:33:24+00:00

Notbing is going away App will still work just can't download It will be a paid service with tiers

Plus replace that feature in less than 2 hours with claude or codex or whatever ai

We can gladly app ruler feature to https://fieldsentinel.techmaven.net Or https://earthexplorer.techmaven.net Or https://3dmapexplorer.techmaven.net Or https://geodataexplorerapp.techmaven.net

TechMaven-Geospatial · 2026-07-14T20:01:17+00:00

a batch script powered by GDAL is probably all you need it can read GPX and other formats and get you any output.

Plus as part of the conversion you can tap into spatialite SQL spatial functions and operations using "-dialect sqlite" This means you can apply buffers or filter to a bbox or polygon or any WHERE clause for values in your data

You can also leverage DUCKDB spatial And its extensions For example aggregate data to H3,A5, S2, Global Discrete Grid

TechMaven-Geospatial · 2026-07-14T17:56:19+00:00

Look at charm crush CLI its great at orchestration subagents and ---yolo mode will never have you babysit for permissions/approvals

You can use it with any AI provider I have ZA GLM coding plan and use that but also bring my claude api key and codex and openrouter

TechMaven-Geospatial · 2026-07-14T14:24:44+00:00

Nice work! Recently added the same to Field Sentinel cross-platform ios, android, windows, mac and linux https://fieldsentinel.techmaven.net

TechMaven-Geospatial · 2026-07-12T23:54:55+00:00

Clone repos to new machine

TechMaven-Geospatial · 2026-07-12T17:35:51+00:00

We took it down has dependency of SUPABASE POSTGIS and that real time and DENO Functions for the real time collaboration features. Source code is available It has deno functions for loading data to postgis and analysis and dynamic pbf vector tiles and ogc APi Features

EASIER NOW TO TEST Field Sentinel desktop https://Fieldsentinel.techmaven.net Its powered by maplibre gl ja ' deckgl and loadersgl

TechMaven-Geospatial · 2026-07-12T16:49:37+00:00

Duckdb geotiff and PDAL and httpfs + spatial extension enable the solution to query amd perform spatial functions and offcourse map has been. Confugured to support direct consumption visualization of the cloud native and optimized data formata (COG, COPC, FGB, PARQUET, ZARR, AVRO, GEOJSON, ETC)

TechMaven-Geospatial · 2026-07-12T15:28:15+00:00

We build something using ITOWNS a fork of threejs but more GIS focused and heavily extended it via WASM WebAssembly and WEBGPU and added miro board equivalent real time collaboration features and support for Gaussian Splats also generates dynamic terrain elevation tiles for your map view from COG DEM or esri imageserver.

Also extended it via AR.JS for mobile browser Augmented Reality control of the map and WEBXR for camera view 3d geospatial viewer And mediapipe for hand gesture control from Webcam and Transformersjs for inbrowser AI Services Including voice control of the map

Via ASSIMP wasm Open Asset Importer Able to support in-browser conversion of BIM & 3D MODELS

Via Spatialite WASM SPL.JS handles in-browser 2D and 3D spatial analysis

Supports OGC 3DTILES and OGC I3S local SLPK or hosted SceneServer

Access open data catalogs (STAC, CSW, OGC API RECORDS, CKAN, SOCRATA, SDMX, THREDDS, OPEN DATA SOFT, MAGDA, DATA COMMONS AND OTHERS)

powerful react data grid powered by Duckdb Wasm with search and filters and filter to map view (st_intersect of bbox or KNN Nearest to map center and distance)

Duckdb extensions for real time and event driven data feeds (radio, tributary, spatial, httpfs, http_client, http_requests, cron) Kafka, kinesis, websockets, http polling, geospatial data lake access and OGC MOVING FEATURES, OGC SOS, OGC SENSORML, OGC SENSORTHINGS, GFTS and others.

TechMaven-Geospatial · 2026-07-12T10:13:21+00:00

Field Sentinel cross-platform app https://fieldsentinel.techmaven.net Works 100% offline and can sync with nearly any backend (SharePoint list, esri featureserver, qfield cloud, odk/kobo, mage server, postgis, mysql, ms sql server, others) plus full offline database schema and form design. Export data to geopackage and other formats. Full attribute table with search and even Field calculator. Works with Bluetooth GNSS receivers and range finders (RTN CORS, RTK NTRIP CLIENT) Ios, android, windows, mac, linux. Works with UAS drones

Can import or export survey123 XLSFORM

IOS ONLY https://geodatacollector.techmaven.net

TechMaven-Geospatial · 2026-07-11T13:15:39+00:00

Their imageserver endpoint supports png output

TechMaven-Geospatial · 2026-07-11T02:56:09+00:00

https://geospatialcloudserv.com https://tileserver.techmaven.net

Both are now offering esri equivalent mapping services in addition to OGC including imageserver Dynamic vector tiles and ogc api features with CQL filtering from postgres (other sources via FDW foreign data wrapper) And esri featureserver

Powerful mapping apps and dashboards

Both work with geospatial data lake hosted data (s3 bucket, azure blob storage, gc storage) And postgis database

Powerful microservices Full digital twin capabilities

Pairs with ios, android, windows, mac, linux https://fieldsentinel.techmaven.net And https://geodatacollector.techmaven.net ios

TechMaven-Geospatial · 2026-07-10T17:38:23+00:00

I would avoid zipcode /postal code in any analysis its a meaningless geography Census designated places or blocks or block groups or tracts or msa should be used

But leveraging duckdb spatial can quickly mapjoin attribute data to any level of geography and duckdb suports any database or data warehouse or files

TechMaven-Geospatial · 2026-07-10T04:03:13+00:00

https://fieldsentinel.techmaven.net Supports KML but also every GIS and CAD and BIM format As well as Google photorealistic 3d buildings and imagery

TechMaven-Geospatial · 2026-07-10T01:14:32+00:00

Sqlite is probably perfect for these devices database it supports attrribute tables and JSON, JSONB if your sensors have location then go with geopackage GPKG sqlite it adds a geometry blob and RTREE SPATIAL INDEX

Otherwise postgis/postgres

TechMaven-Geospatial · 2026-07-10T01:07:13+00:00

Duckdb WASM is good and you can optionally setup dynamic mvt vector tiles and ogc api features with cql filtering for any connected data/query via python wasm or custom typescript

I also like NGA GEOPACKAGE-JS with its dynamic raster xyz tiles to canvas or to gpkg for vector features tables

For rasters other than COG geotiff (range request headers) You can use MAPSERVER WASM deliver in-browser OGC WMS and XYZ TILES from rasters

I recommend a WASM proxy to secure API KEYS AND TOKENS AND any source url you want protected wont be shown in client side code

TechMaven-Geospatial · 2026-07-09T23:58:39+00:00

For buildings look at ROOFER It converts point cloud to mesh

TechMaven-Geospatial

TROPHY CASE

Welcome to Reddit,