How rivai20/gis-produksi-kota-ternate works
GIS Produksi Kota Ternate is a Flask application for exploring fisheries and agriculture production by district, with map visualization and role-based data management. The main user flow is opening the dashboard, loading filtered district summaries and markers, then—if logged in—submitting production or dataset changes for the relevant admin to review. Separate importers prepare production data and district boundaries. The map and moderation links are supported by excerpts; unsampled template and schema details are represented only where the README documents them.
Main entry points: schema.sql MySQL database · script.js Map interface · app.py Authentication · index.html Map dashboard
Components 18
Map experience
- Map dashboard
templates/index.html - Map interface
static/script.js - Leaflet maps
- Map basemaps
Data workflows
- Login page
templates/login.html - Authentication
app.py - Map dataset API
app.py - Marker submissions
app.py - Production verification
app.py - Commodity management
static/script.js - Dataset change review
app.py
Production data
- MySQL database
schema.sql
Data preparation
- Crop importer
import_crop_data.py - Fisheries importer
import_fish_data.py - Boundary importer
import_public_boundaries.py - Zone overlap resolver
resolve_zone_overlaps.py
Other components
- Map visitor
- User or admin
Connections 22
- Map visitor → Map dashboard: opens
README.md - Map dashboard → Map interface: loads
README.md - Map interface → Map dataset API: fetches dataset
static/script.js - Map dataset API → MySQL database: reads summaries
app.py - Map interface → Leaflet maps: renders map
static/script.js - Map interface → Map basemaps: selects tiles
static/script.js - User or admin → Login page: signs in
README.md - Login page → Authentication: submits credentials
README.md - Authentication → MySQL database: checks account
app.py - User or admin → Marker submissions: submits production
README.md - Marker submissions → MySQL database: stores pending record
app.py - Map interface → Production verification: sends decision
static/script.js - Production verification → MySQL database: updates record
app.py - User or admin → Commodity management: manages commodities
README.md - Commodity management → Map dataset API: loads records
static/script.js - Commodity management → Dataset change review: submits changes
static/script.js - Dataset change review → MySQL database: records and reviews changes
app.py - Crop importer → MySQL database: upserts crop data
import_crop_data.py - Fisheries importer → Authentication: uses database connector
import_fish_data.py - Authentication → MySQL database: connects to
app.py - Boundary importer → MySQL database: writes boundaries
import_public_boundaries.py - Zone overlap resolver → MySQL database: updates zone geometry
resolve_zone_overlaps.py