# andreijavan/pnp_sta.cruz_official architecture

> Architecture diagram of the GitHub repository andreijavan/pnp_sta.cruz_official, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/andreijavan/pnp_sta.cruz_official
- Repository: https://github.com/andreijavan/pnp_sta.cruz_official

## Overview

Sta. Cruz Crime Mapping & Reporting System serves public crime-map and information pages alongside police administration for incident reporting, bulletins, intelligence reports, and personnel. Public visitors browse mapped incidents, advisories, news, and hotlines; authorized staff manage records through protected admin routes. Facebook post synchronization is a separate ingestion capability that feeds bulletins. The sampled controller excerpts show database access and selected public data flows; README and route declarations establish additional capabilities whose internal implementation is not fully shown.

Main entry points: [`routes/admin.ts`](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/routes/admin.ts) (Admin routes), [`controllers/publicController.ts`](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts) (Public pages), [`config/database.ts`](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/config/database.ts) (Application database), [`app.ts`](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/app.ts) (Express application)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web application"]
  node_app["Express application<br/>[app.ts]"]
  node_public_routes["Public routes<br/>[public.ts]"]
  node_admin_routes["Admin routes<br/>[admin.ts]"]
  node_auth["Admin authorization<br/>[auth.ts]"]
  node_sessions[("Session persistence<br/>[sessionStore.ts]")]
end

subgraph group_public["Public information"]
  node_public_pages["Public pages"]
  node_crime_map["Crime map data"]
  node_public_bulletins["Bulletins and news"]
  node_public_services["Hotlines and language"]
  node_cache[("Response cache<br/>[cache.ts]")]
end

subgraph group_admin["Police administration"]
  node_admin_access["Admin access<br/>[adminController.ts]"]
  node_incident_management["Incident mapping<br/>[adminController.ts]"]
  node_report_processing["Intelligence reports<br/>[adminController.ts]"]
  node_bulletin_management["Bulletin management<br/>[adminController.ts]"]
  node_admin_operations["Admin operations<br/>[adminController.ts]"]
  node_database[("Application database<br/>[database.ts]")]
end

subgraph group_ingestion["External content"]
  node_facebook_sync["Facebook synchronization<br/>[facebookService.ts]"]
  node_facebook_source(("Facebook page"))
  node_classification["Category classification"]
  node_scraper["Facebook scraper<br/>[facebookScraper.ts]"]
end

node_visitor(("Public visitor"))
node_officer(("Police staff"))

node_visitor -->|"opens pages"| node_app
node_officer -->|"uses portal"| node_app
node_app -->|"mounts routes"| node_public_routes
node_app -->|"mounts routes"| node_admin_routes
node_app -->|"stores sessions"| node_sessions
node_public_routes -->|"dispatches requests"| node_public_pages
node_admin_routes -->|"guards requests"| node_auth
node_admin_routes -->|"dispatches requests"| node_admin_access
node_admin_routes -->|"dispatches requests"| node_incident_management
node_admin_routes -->|"dispatches requests"| node_report_processing
node_admin_routes -->|"dispatches requests"| node_bulletin_management
node_admin_routes -->|"dispatches requests"| node_admin_operations
node_public_pages -->|"loads map data"| node_crime_map
node_public_pages -->|"loads bulletins"| node_public_bulletins
node_public_pages -->|"serves services"| node_public_services
node_public_pages -->|"reads records"| node_database
node_public_pages -->|"caches results"| node_cache
node_admin_access -->|"reads and writes"| node_database
node_incident_management -->|"reads and writes"| node_database
node_report_processing -->|"reads and writes"| node_database
node_bulletin_management -->|"reads and writes"| node_database
node_admin_operations -->|"reads and writes"| node_database
node_facebook_source -->|"provides posts"| node_facebook_sync
node_facebook_sync -->|"upserts bulletins"| node_database
node_facebook_sync -->|"classifies posts"| node_classification
node_facebook_sync -->|"uses scraper"| node_scraper

click node_app "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/app.ts"
click node_public_routes "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/routes/public.ts"
click node_admin_routes "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/routes/admin.ts"
click node_auth "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/middleware/auth.ts"
click node_sessions "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/sessionStore.ts"
click node_public_pages "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts"
click node_crime_map "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts"
click node_public_bulletins "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts"
click node_public_services "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts"
click node_admin_access "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts"
click node_incident_management "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts"
click node_report_processing "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts"
click node_bulletin_management "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts"
click node_admin_operations "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts"
click node_database "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/config/database.ts"
click node_cache "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/cache.ts"
click node_facebook_sync "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/facebookService.ts"
click node_classification "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/categoryClassifier.ts"
click node_scraper "https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/facebookScraper.ts"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_app,node_public_routes,node_admin_routes,node_auth,node_sessions toneBlue
class node_public_pages,node_crime_map,node_public_bulletins,node_public_services,node_cache toneAmber
class node_admin_access,node_incident_management,node_report_processing,node_bulletin_management,node_admin_operations,node_database toneMint
class node_facebook_sync,node_facebook_source,node_classification,node_scraper toneRose
class node_visitor,node_officer toneIndigo
```

## Components

### Web application

- [Express application](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/app.ts): `app.ts`
- [Public routes](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/routes/public.ts): `routes/public.ts`
- [Admin routes](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/routes/admin.ts): `routes/admin.ts`
- [Admin authorization](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/middleware/auth.ts): `middleware/auth.ts`
- [Session persistence](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/sessionStore.ts): `utils/sessionStore.ts`

### Public information

- [Public pages](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts): `controllers/publicController.ts`
- [Crime map data](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts): `controllers/publicController.ts`
- [Bulletins and news](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts): `controllers/publicController.ts`
- [Hotlines and language](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/publicController.ts): `controllers/publicController.ts`
- [Response cache](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/cache.ts): `utils/cache.ts`

### Police administration

- [Admin access](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts): `controllers/adminController.ts`
- [Incident mapping](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts): `controllers/adminController.ts`
- [Intelligence reports](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts): `controllers/adminController.ts`
- [Bulletin management](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts): `controllers/adminController.ts`
- [Admin operations](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/controllers/adminController.ts): `controllers/adminController.ts`
- [Application database](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/config/database.ts): `config/database.ts`

### External content

- [Facebook synchronization](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/facebookService.ts): `utils/facebookService.ts`
- **Facebook page**
- [Category classification](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/categoryClassifier.ts): `utils/categoryClassifier.ts`
- [Facebook scraper](https://github.com/andreijavan/pnp_sta.cruz_official/blob/main/utils/facebookScraper.ts): `utils/facebookScraper.ts`

### Other components

- **Public visitor**
- **Police staff**

## Connections

- Public visitor → Express application: opens pages (evidence: `README.md`)
- Police staff → Express application: uses portal (evidence: `README.md`)
- Express application → Public routes: mounts routes (evidence: `app.ts`)
- Express application → Admin routes: mounts routes (evidence: `app.ts`)
- Express application → Session persistence: stores sessions (evidence: `app.ts`)
- Public routes → Public pages: dispatches requests (evidence: `routes/public.ts`)
- Admin routes → Admin authorization: guards requests (evidence: `routes/admin.ts`)
- Admin routes → Admin access: dispatches requests (evidence: `routes/admin.ts`)
- Admin routes → Incident mapping: dispatches requests (evidence: `routes/admin.ts`)
- Admin routes → Intelligence reports: dispatches requests (evidence: `routes/admin.ts`)
- Admin routes → Bulletin management: dispatches requests (evidence: `routes/admin.ts`)
- Admin routes → Admin operations: dispatches requests (evidence: `routes/admin.ts`)
- Public pages → Crime map data: loads map data (evidence: `controllers/publicController.ts`)
- Public pages → Bulletins and news: loads bulletins (evidence: `controllers/publicController.ts`)
- Public pages → Hotlines and language: serves services (evidence: `routes/public.ts`)
- Public pages → Application database: reads records (evidence: `controllers/publicController.ts`)
- Public pages → Response cache: caches results (evidence: `controllers/publicController.ts`)
- Admin access → Application database: reads and writes (evidence: `controllers/adminController.ts`)
- Incident mapping → Application database: reads and writes (evidence: `controllers/adminController.ts`)
- Intelligence reports → Application database: reads and writes (evidence: `controllers/adminController.ts`)
- Bulletin management → Application database: reads and writes (evidence: `controllers/adminController.ts`)
- Admin operations → Application database: reads and writes (evidence: `controllers/adminController.ts`)
- Facebook page → Facebook synchronization: provides posts (evidence: `utils/facebookService.ts`)
- Facebook synchronization → Application database: upserts bulletins (evidence: `utils/facebookService.ts`)
- Facebook synchronization → Category classification: classifies posts (evidence: `utils/facebookService.ts`)
- Facebook synchronization → Facebook scraper: uses scraper (evidence: `utils/facebookService.ts`)
