The application's backend is anchored by a master database page, which comprises various sub-pages. These sub-pages host multiple databases and sub-databases essential for the system's operation. This hierarchical structure ensures organized data management and efficient system functionality.

Jurisdiction Database Management

Jurisdictions Page

Upon navigating to the jurisdictions page, users encounter a comprehensive database that catalogs all jurisdiction properties. This primary database is supported by various sub-databases, each serving a specific purpose in the ecosystem of jurisdiction management.

States Database

A crucial sub-database is the states database, which lists state names and the jurisdictions associated with each state. This database plays a key role in linking jurisdictions to their respective states, facilitating easy access and management of jurisdictional data.

Types of Databases Supporting Jurisdictions

Templated vs. Manual Databases

The jurisdiction database is enriched by two main types of databases: templated and manual. Templated databases provide a foundation of default items, such as maps, plans, and notes, which are automatically associated with a new jurisdiction upon its creation. Manual databases, on the other hand, are populated with data specific to each jurisdiction, such as timeline, costs, and zoning districts, reflecting the unique aspects of each jurisdiction.

Templated Databases

Jurisdiction Templates

Templates for jurisdictions include default elements for jurisdiction maps, plans, and notes. An example mentioned is the "questions for planner on duty," which illustrates how templated content supports the initial setup of a jurisdiction. These templates ensure that new jurisdictions have a standardized set of data to start with, streamlining the creation process.

Plans Database

The plans database starts with a set number of plans (e.g., four) but is designed to be flexible, allowing for modifications, deletions, and additions. This adaptability ensures that the database can evolve to meet the changing needs of each jurisdiction.

Manual Databases

Unique Jurisdiction Data

Manual databases cater to the data that varies from one jurisdiction to another, such as zoning districts and specific costs. For instance, jurisdictions like Lewisburg and Columbia would have distinct zoning districts, highlighting the need for manual databases to accommodate the diversity of jurisdictional requirements.

Projects DB

⁠

Loading…⁠

⁠

Project Database Structure and Functionality

Overview of the Projects Database

Main Projects Database and Sub-Databases

The system's architecture includes a central projects database that is supported by various sub-databases. These sub-databases supply information to the main projects database, indicating a layered and interconnected database structure.

Sub-Databases Explained

Project Status and Substatus Databases

The project status and the more detailed substatus databases provide categorization and tracking for project progress. Icons or markers within the system indicate when information is sourced from these specific sub-databases, offering insights into project phases and milestones.

Initial Research Database

Initial research data, crucial for project planning and execution, is organized within its own database. This allows for the grouping of research by project, ensuring relevant information is easily accessible and associated with the correct project.

Budget and Task Management

Budget Database

The budget database encompasses all budget items and associated costs for projects. It includes sub-databases, such as the phase sub-database, which allows for the organization and prioritization of budget items according to project phases.

Task Database

Tasks related to projects are managed in a dedicated task database. This simple yet essential database tracks items and activities associated with each project, facilitating project management and execution.

Project Templates and Pre-filled Data

Project Template Databases

Similar to jurisdiction management, project management benefits from template databases for initial research, budget items, and tasks. These templates provide a standardized starting point for every project, ensuring consistency and efficiency in project setup.

Utilization of Template Data in New Projects

When creating a new project, pre-filled template data from the Budget Item Template Database, Task Template Database, and Initial Research Template Database are automatically integrated. This process streamlines project creation by supplying essential, templated data that is universally applicable across projects.

Properties DB

⁠

Loading…⁠

⁠

Properties Database Structure and Functionality

Overview of the Properties Database

Main Properties Database

The system features a main properties database that catalogues all property-related information. This foundational database serves as the central repository for data on properties managed within the system.

Key Sub-Databases for Property Management

Initial Research Database

Each property is associated with an initial research database, which contains preliminary information crucial for understanding and evaluating the property. This database supports the detailed analysis and planning stages for property development.

Property Zoning Valuation Database

One of the more complex aspects of property management is addressed by the property zoning valuation database. This database stores zoning information specific to each property, illustrating the regulatory and planning framework applicable to the property. It includes details like zoning types and their relevance to individual properties or groups of properties within a project.

Integration with Projects

Project Association

The system allows for the association of properties with projects, where applicable, enabling the aggregation of property data for project-level analysis. In instances where properties are part of a project, the property zoning valuation database plays a critical role in supplying zoning data to inform project planning and execution.

Status Management and Relationships

Property Status and Sub-Statuses

Similar to the projects database, properties have statuses derived from a sub-statuses database, ensuring consistent tracking and categorization of property states within the system.

Relationship to Projects and Zoning Valuations

Properties are linked not only to projects but also to specific zoning valuations, highlighting the interconnected nature of property data. These relationships facilitate a comprehensive view of each property's context within the broader system, including its regulatory compliance and project involvement.

Initial Research Integration

Initial research associated with properties is detailed within the database, providing foundational data that supports further analysis and decision-making for property development.

Jurisdiction DB

Technical Structure and Database Management

Projects DB

Project Database Structure and Functionality

Properties DB

Properties Database Structure and Functionality

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.