Welcome to NewandModern¶
Welcome to the comprehensive documentation for the NewandModern Database Schema. This documentation provides detailed information about the database structure, tables, relationships, and data sources for the real estate intelligence and property development tracking system.
Overview¶
This database schema is designed to support a comprehensive real estate intelligence and property development tracking system. The system integrates multiple data sources to provide insights into property ownership, transactions, building activities, and business entities involved in real estate development.
The database enables powerful analytics and AI-powered classifications to identify trends, track new construction, map builder activities, and analyze market intelligence.
What This Data Is About¶
The database tracks and analyzes comprehensive real estate and property development data from multiple sources:
-
Property Information
Comprehensive property data from ATTOM Data Solutions, including property characteristics, ownership details, tax assessments, and geographic information.
-
Real Estate Transactions
Deed transfers, mortgage records, and ownership changes linked to properties, providing a complete transaction history.
-
Building Permits
Municipal building permits tracking construction activities, renovations, and improvements across different jurisdictions.
-
MLS Listings
Multiple Listing Service data for active property listings, sales, and market activity with pricing and property details.
-
Business Entities
Company registrations, corporate structures, and member information for businesses involved in real estate development.
-
Builder & Contractor Data
Registered builder information, home improvement contractor licenses, and professional registrations with compliance tracking.
-
Geographic Data
Parcel information, neighborhood boundaries, and spatial relationships with geographic coordinates and boundaries.
-
Intelligence & Analytics
AI-powered classifications identifying new construction, builder lot purchases, company transactions, and property rankings.
Key Use Cases¶
This data supports a wide range of business intelligence and analytical applications:
New Construction Tracking¶
Identifying properties undergoing construction based on permit data, tax assessment changes, and transaction patterns. This enables early detection of new development projects and market trends.
Builder Intelligence¶
Mapping property transactions to registered builders and companies to track development activities. Understand which builders are active in specific markets and their development patterns.
Property Development Analysis¶
Correlating permits, transactions, and property changes to understand development trends. Analyze the lifecycle of properties from purchase through construction to sale.
Business Entity Mapping¶
Connecting real estate transactions to corporate entities and understanding company involvement in property development. Track business relationships and corporate structures in real estate.
Market Intelligence¶
Ranking properties, identifying hotspots, and analyzing price trends through transaction and assessment data. Support data-driven investment and market analysis decisions.
Data Sources¶
The database aggregates data from multiple authoritative sources:
-
ATTOM Data Solutions
Primary source for property and transaction data, providing comprehensive property records and ownership information. -
Municipal Governments
Building permit records from various municipalities, tracking construction activities and regulatory compliance. -
Multiple Listing Services (MLS)
Real estate listing data from MLS systems, including active listings, sales history, and property details. -
State & County Records
Parcel data, builder registrations, contractor licenses, and other official records from state and county agencies. -
Business Registrations
Corporate filings and entity information from business registration databases.
Database Schema Diagrams¶
Visual representations of the database structure and relationships:
-
High-Level Entity Relationship Diagram
Overview of main entities and their relationships across the database schema.
View Diagram → -
Core Property Data Flow
Data flow diagram showing how property information flows through the system.
View Diagram → -
Classification and Mapping Flow
Overview of how raw data is processed through classification and mapping systems.
View Diagram →
Explore the Documentation¶
-
Complete documentation of all database tables, columns, and their relationships. Includes detailed descriptions of core data tables, classification tables, and mapping tables.
-
Detailed reference for all tables in the system, including data types, constraints, and relationships.
-
Visual diagrams showing how different entities in the database relate to each other.
Quick Start¶
To get started exploring the database schema:
- Browse the Database Schema to see all available tables and their structures
- Review the Overview to understand the system's purpose and capabilities
- Check the Data Sources to see where information comes from
- Explore the Schema Diagrams for visual representations
For detailed information about specific tables, use the navigation menu or search functionality to find what you're looking for.