Sightbase Database Core

Back to Project Sightbase

Allegheny

Geospatial and civic data system focused on Allegheny County and surrounding regions.
Stores and serves datasets such as parcels, addresses, infrastructure, hydrology, and administrative boundaries.

Schema Look:

WPRDC → External data ingestion and base civic datasets

WPRDC PASDA → Standardized geospatial datasets (PASDA-aligned)

WPRDC PASDA MAPS → Curated map layers and geographic outputs

WPRDC

Core integration layer for Western Pennsylvania Regional Data Center (WPRDC) data.

Role:
→ Source-aligned data layer (closest to external truth)

WPRDC PASDA

Standardized dataset layer derived from PASDA (Pennsylvania Spatial Data Access) feeds.

Role:
→ Clean, normalized dataset layer for analysis and reuse

WPRDC PASDA MAPS

Presentation and composition layer built on top of PASDA datasets.

Role:
→ Final, user-facing map and visualization layer

How They Fit Together (important)

This is a clean pipeline:

WPRDC (raw / source-aligned)
    ↓
WPRDC PASDA (standardized datasets)
    ↓
WPRDC PASDA MAPS (curated / geographic outputs)

AUROS

Financial system architecture and accounting framework. Designed to model cash flow, financial operations, and reporting structures with precision and control. Serves as the internal financial truth engine, supporting forecasting, reconciliation, and structured financial logic.

Schema Look:

1 Intake

Raw data ingestion layer.

Role:
→ Entry point for all financial data

2 Processing

Transformation and normalization layer.

Role:
→ Converts raw inputs into usable financial data

3 Reporting

Final output and analytics layer.

Role:
→ Financial insight and reporting surface

Account

Chart of accounts and classification structure.

Role:
→ Financial classification backbone

Asset

Asset tracking and management.

Role:
→ Tracks what is owned

Documentation

Document management system.

Role:
→ Source-of-truth for financial documents

DZ

Custom logic and control layer.

Role:
→ Operator-level control and validation layer

FinTech

Financial systems and vendor ecosystem modeling.

Role:
→ Maps the financial technology landscape

Legal

Legal tracking and reference.

Role:
→ Legal oversight and exposure tracking

Map

Geographic or spatial linkage layer.

Role:
→ Spatial dimension of financial activity

PNC

Bank transaction classification layer.

Role:
→ Bank transaction interpretation

PNC_CHK

Checking account raw data.

Role:
→ Source data for checking activity

PNC_CSH

Cash account raw data.

Role:
→ Source data for cash activity

PNC_PTS

Points/rewards or auxiliary bank data.

Role:
→ Supplemental banking data

Record

Consolidated and historical records.

Role:
→ System memory and audit layer

Vendor

Vendor and counterparty master data.

Role:
→ Who money flows to/from

System Structure (Important)

This is your actual AUROS architecture:

1 Intake  →  2 Processing  →  3 Reporting
     ↓             ↓              ↓
   PNC_*        Account       Record
                Vendor        Documentation
                DZ            FinTech
                              Legal

Autos

Vehicle and VIN intelligence system. Handles vehicle identification, manufacturer data, specifications, and classification structures. Used for decoding, structuring, and analyzing automotive data at scale.

Schema Look:

1. Manufacturer (Brand Layer)

All OEM and vehicle brands.

Includes:
Acura, Audi, BMW, Buick, Cadillac, Chevrolet, Chevrolet Trucks, Chrysler, Daewoo, Daihatsu, Datsun, Dodge, Edsel, ElDorado National, Ford, Genesis, Geo, Gillig, GMC, Honda, Hyundai, Infiniti, Isuzu, Jaguar, Jeep, Kia, Land Rover, Lexus, Lincoln, Mazda, Mercedes-Benz, Mercury, Merkur, Mini, Mitsubishi, Nissan, Oldsmobile, Plymouth, Pontiac, Porsche, Ram, Saab, Saturn, Scion, Setra, Subaru, Suzuki, Toyota, Volkswagen, Volvo, Blue Bird, Capacity Trucks

Role:
→ Defines who makes the vehicle

2. Core Vehicle Structure (Dimensional Model)

The canonical vehicle hierarchy.

Includes:
Make, Model, Year

Role:
→ Defines what the vehicle is (identity spine)

3. Vehicle Systems (Mechanical Components)

Physical and functional subsystems of vehicles.

Includes:
Engine, Transmission, Drive, Fuel, Body

Role:
→ Defines how the vehicle operates

4. Features & Safety (Capability Layer)

Optional and standard vehicle capabilities.

Includes:
Feature, Safety

Role:
→ Defines what the vehicle can do

5. Manufacturer Mapping & Normalization

Bridges and standardization layers.

Includes:
Manufacturer, TAXA

Role:
→ Resolves inconsistencies across data sources (VIN, naming, mappings)

6. External / Infrastructure Systems

Non-vehicle but related systems.

Includes:
Road Signs

Role:
→ Extends vehicle context into environment

7. System / Control Layer

Internal control or placeholder schemas.

Includes:
auto

Role:
→ Likely staging or legacy system logic

8. Archive / Historical

Non-active or deprecated data.

Includes:
Archive

Role:
→ Historical retention

Food

Nutritional, ingredient, and food classification system. Organizes food into structured categories for analysis, comparison, and integration with health or supply systems. Intended as a foundational dataset for anything involving consumption or nutrition modeling.

Schema Look:

Algae
Food sources derived from algae.

Animal
Food sources derived from animals.

FreshMarket
Retail food data specific to Fresh Market.

Fungi
Food sources derived from fungi.

GE Cat
Internal or experimental categorization system, likely tied to Giant Eagle.

Giant Eagle
Retail food data specific to Giant Eagle.

Human
Human-specific food classification or consumption context.

Microbial
Food sources derived from microorganisms.

Mineral
Non-biological consumable substances such as salt and trace minerals.

Plant
Food sources derived from plants.

TAXA
Taxonomic classification structure for organizing food sources.

Walmart
Retail food data specific to Walmart.

Water
Water as a consumable resource.

GAMES

Interactive systems and game structure database. Defines game mechanics, rulesets, entities, and simulation logic. Supports both analysis of existing games and development of new structured interactive environments.

Schema Look:

Anime
Game-related data derived from anime franchises, including entities like characters, creatures, and world systems (e.g., Pokémon).

Baseball
Structured baseball data including pitch events, player activity, mappings, and game-level tracking.

Cards
Card-based systems including standard playing cards and tarot structures.

Chess
Chess system definitions including pieces and core game elements.

CODEXE
Prototype configuration and telemetry system for experimental or in-development game engines.

Command and Conquer
Game data for Command & Conquer, including units, buildings, and faction structures (e.g., Red Alert).

Dilithium
Custom or sci-fi system modeling assets, vehicles, and publications within a constructed universe.

EVNova
Game data for Escape Velocity Nova, including factions and ship systems.

GameofThrones
Game-structured data derived from Game of Thrones, including characters, creatures, and deities.

NFL
Football-related game and sports data structured for simulation or analysis.

Old Glyph
Legacy system definitions for a prior game engine, including world structures, entities, and configuration schemas.

Starcraft
Game data for Starcraft, including units and buildings.

Tiberium
Thematic or system layer related to Tiberium-based environments, likely tied to Command & Conquer extensions.

Total War
Game data for Total War, including units and factions (e.g., Rome).

Trivia
Structured trivia data, such as music or knowledge-based question systems.

GLYPH

Acts as the visual abstraction layer for communication and interface design.

Schema Look:

AmbientCG
Material and texture asset data sourced from AmbientCG, including maps and binary assets.

Auto
Automotive model and asset system, including model definitions, potential model matching, and Sketchfab-linked vehicle assets.

Human
Human motion capture dataset structures, including subjects, trials, categories, and reference links (CMU mocap).

MidiChlorian
Singular or early-stage schema for Midichlorian system concepts, likely transitional or experimental.

MidiChlorians
Full world-building system for a structured universe, including factions, regions, vehicles, manufacturers, and galactic hierarchy.

Mixamo
Animation and motion system, including motion classifications, skeleton mappings, animation parameters, and runtime combinations.

Sketchfab
3D model asset system sourced from Sketchfab, including model storage, categorization stages, and raw backup datasets.

Technology
Technology classification and system definitions, including conceptual or fictional technologies (e.g., Midichlorian technology).

Tiberium
Thematic or world system tied to Tiberium-based environments, likely linked to Command & Conquer-style constructs.

WAlker
Build and execution system for walker entities, including asset construction and run tracking.

Janus

Dual-perspective and state-transition system.
Designed to analyze and model opposing states, transitions, and boundary conditions.
Used for handling systems that require bidirectional logic or perspective flipping.

Stuff I’m trying to incorporate

Schema Look:

Academia
Academic classification systems, domains, and OECD research structures.

Alchemy
Alchemical concepts, substances, and symbolic systems.

Alphabetic
Alphabet structures and ordered character systems.

America
U.S.-specific data including presidents, executive orders, and military structures.

Animals
Animal classification and species-specific datasets.

Art
Artistic domains such as liberal arts and creative classification.

B1
Unclear or experimental schema, likely placeholder or early-stage system.

Bank
Banking structures including ledgers, transaction mappings, and financial records.

Bible
General biblical structures including manuscripts, translations, and terminology.

Bible Books 1 Genesis
Detailed structured breakdown of Genesis, including passages, characters, and narrative segments.

Christianity
Christian theological structures including angels, symbols, and religious mappings.

Core
Central system mapping and database structure definitions.

Dance
Dance classifications including styles and categories.

dbo
Default schema for miscellaneous or uncategorized tables.

Dz
User-specific or custom system layer tied to your personal structures or logic.

Econ
Economic data including GDP, inflation, employment, and macro indicators.

English
English language structures including words and definitions.

Form
Singular form definitions, likely structural or conceptual templates.

Forms
Applied form systems including templates and user-defined structures.

Geography
Geospatial data including landforms, populations, and regional mappings.

God
Entities and structures related to divine beings.

Govt
Government systems and administrative data (e.g., EBT locations).

Greek
Greek language, mythology, and cultural constructs.

Humor
Humor-related structures and conceptual mappings.

Ledger Activity Detail
Detailed financial activity tracking tied to specific ledger systems.

Life
Biological lifecycle data such as births and deaths.

Maps
Mapping systems and geospatial representations.

Music
Music theory structures including chords, scales, and tonal systems.

Names
Name meanings and linguistic identity structures.

People
Datasets of individuals or current persons.

PIP
Strategic and operational frameworks including tactics, systems, and planning structures.

PNC
Banking data specific to PNC accounts (checking, cash, points).

Purpose
Conceptual structures defining purpose and ordering systems.

Roman
Roman historical data such as emperors.

Science
Scientific datasets including elements, weather, and empirical measurements.

Starbucks
Retail product data specific to Starbucks.

Theology
Religious system mapping across belief structures.

Thought
Cognitive and philosophical models (e.g., Maslow, generational theory).

Time
Temporal systems including calendars and time-based classifications.

UU
Unitarian Universalism-related data and structures.

Value
Value systems and conceptual classifications (e.g., color).

Wolfe
Company-specific or internal Wolfe LLC data (e.g., payroll).

Words
Linguistic relationship systems including grammar, connections, and structure.

WW1
World War I data including factions and military structures.

Zodiac
Astrological systems including signs, symbols, and calendar mappings.

Linea

Primary role is to act as the real-world spatial backbone for mapping, Terra Firma terrain generation, and location-based analysis.

Secondary Role is to integrate Time and its dimensions

Schema Look:

TerraFirma

LOGOS

Core logic and language processing system. Defines words, meanings, relationships, and analytical structures across language. Acts as the semantic engine that connects terminology, reasoning, and structured thought.

Schema Look:

Authority
Authoritative source tracking and validation layer for linguistic or structured data.

BBC
BBC-sourced ingestion and asset tracking, including ingest runs and media assets.

Bibliography
Reference materials and source documentation for texts and datasets.

Corpus
Structured body of text used for linguistic analysis and modeling.

Curation
Manual or system-driven selection, refinement, and organization of data.

Domino
Web and release system for managing site assets, deployments, and page structures.

DZ
User-specific control layer for custom logic, overrides, and internal mappings.

Editorial
Content editing, refinement, and publication-ready structuring.

Etymology
Word origin tracking and historical linguistic development.

Export
Outbound data preparation and structured output for external use.

Family
Hierarchical grouping structures (e.g., lineage, classification families).

Geography
Geographic datasets including countries, regions, and population structures.

History
Temporal and historical mapping including eras, periods, and event snapshots.

Import
Inbound data ingestion and staging from external sources.

ISTA_UNIFIED
Unified canonical dataset for structured religious or textual corpora.

Lexeme
Core word units representing distinct meanings and dictionary entries.

Mapping
Cross-system mapping between entities, schemas, and datasets.

Morphology
Word structure analysis including roots, forms, and inflections.

NFL
Football-related datasets integrated into the LOGOS system.

OED
Oxford English Dictionary-aligned structures and definitions.

Orthography
Spelling systems and written representation of language.

Pattern
Pattern-based systems including structured logic and game theory models.

Philosophy
Philosophical systems, thinkers, schools, and conceptual frameworks.

Phonology
Sound systems and pronunciation structures.

PlayCard
Game/session system for structured interactions, matches, and event tracking.

Relations
Connections between entities, words, or concepts.

Religion
Religious texts, structures, and classification across belief systems.

Romans
Roman historical data including emperors and imperial structures.

Science
Scientific classification and analytical frameworks.

Semantics
Meaning structures and interpretation of words and concepts.

StandardGeography
Normalized geographic reference system (country, state, municipality, etc.).

StandardHousing
Standardized housing and property data structures.

Thesaurus
Synonym and related-word systems.

Translations
Cross-language mappings and translation structures.

Usage
Contextual usage patterns of words and language.

Vehicle
Vehicle-related logs and operational data within the system.

Website
Web structure mapping, including pages and navigation relationships.

POLIS

Civic, organizational, and governance system. Models institutions, jurisdictions, populations, and administrative structures. Used to represent how groups of people organize, govern, and interact at scale.

Schema Look:

ACHTUNG PANZER
Military vehicle data sourced from Achtung Panzer, focused on armored vehicles and historical equipment.

Battle
Battle-level data including engagements, event types, participants, and mapped history.

CHRONOS
Time system including eras, periods, and chronological structuring.

External Websites
Aggregated vehicle and military data sourced from external web platforms.

GLOBAL SECURITY
Military and defense data sourced from GlobalSecurity.org, including systems and platforms.

Military
Core military domain including models, classifications, and external source tracking.

MILITARY FACTORY
Military vehicle and equipment data sourced from MilitaryFactory.com.

Military Land
Land-based military platforms including animals, mechanized units, and vehicle classifications.

MilitaryAir
Air-based military platforms including aircraft and aerial systems.

MilitaryCyber
Cyber warfare and digital military systems.

MilitaryNaval
Naval platforms including ships and maritime systems.

MilitarySpace
Space-based military platforms and systems.

PANZERWORLD
Armored vehicle data sourced from Panzerworld, focused on tank history and specifications.

TANK ARCHIVES
Historical tank data sourced from Tank Archives.

TANK ENCYCLOPEDIA
Comprehensive tank data sourced from Tank Encyclopedia.

TANK MUSEUM
Museum-based tank and vehicle data sourced from The Tank Museum.

TERRA
Geospatial terrain system including Terra Avita and regional mapping.

TRUCK ENCYCLOPEDIA
Military and utility vehicle data sourced from Truck Encyclopedia.

WAR WHEELS
Military vehicle data sourced from WarWheels.net.

wiki Infantry mobility vehicle
Wikipedia-derived data for infantry mobility vehicles.

wiki List of armoured fighting vehicles by country
Wikipedia-derived structured list of armored vehicles by country.

wiki List of infantry fighting vehicles
Wikipedia-derived structured list of infantry fighting vehicles.

wiki Mine-resistant ambush protected vehicle
Wikipedia-derived data for MRAP vehicle classifications.

Wikipedia
General-purpose ingestion of Wikipedia pages and military-related content.

SONOS

Audio, sound, and signal-based system. Handles sound structures, audio data, and potentially music or signal processing frameworks. Designed as the auditory counterpart to visual and symbolic systems.

Schema Look:

BBC
Audio and media asset system sourced from BBC, including asset ingestion, categorization, tagging, and playback-related structures.

Sports

Sports data and analytics system. Tracks teams, players, games, seasons, and performance metrics.
Used for structured sports analysis, historical tracking, and statistical modeling.

Schema Look:

Field
Spatial and structural representation of sports fields, including regions, positions, and coordinate-based mappings.

NCAA
Collegiate sports data including schools, conferences, teams, and player datasets across multiple sports.

NFL
Professional football data including teams, games, seasons, stadiums, and player-related structures.

NFLVerse
Raw and processed NFL data pipeline sourced from NFLVerse, including play-by-play, rosters, schedules, and ingestion audit layers.

Theos

Theological and metaphysical system. Organizes religious texts, symbols, doctrines, and philosophical structures of divinity. Serves as the highest-order conceptual system, integrating meaning, belief, and existential frameworks.

Schema Look:

Art
Art-focused content system including pages and associated media assets.

History
Historical content system including pages and related images.

Philosophy
Philosophical content system including thinkers, schools, core areas, and structured page content.

Religion
Religious content system including structured pages, sections, content blocks, and associated media.

vPICList_Lite1

Reference and decoding database derived from NHTSA vPIC datasets.
Used specifically for VIN decoding, manufacturer identification, and regulatory vehicle data.
Acts as a supporting reference system for Autos.

Schema Look:

Work

For Work Stuff, dormant and empty for now while Unemployed

Schema Look: