ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Property Development Investment Summary - DB SchemaDS-P1 - Property Development Investment Summary - API Schema
2
Record_TypeFieldNameTypeDescriptionRequest/property/constructioninvestmentsummary/{address}
3
Property InformationStateVARCHARProperty location - State/property/constructioninvestmentsummary/{parcel_number}
4
CountyVARCHARProperty location - CountyResponse{
5
CityVARCHARProperty location - City "property": {
6
Property_AddressVARCHARAddress of property "state": "AL",
7
SectorVARCHARResidential | Commercial "county": "Jefferson",
8
Parcel_NumberVARCHARParcel number for the property "city": "Birmingham",
9
Building_TypeVARCHARType of structure being built or renovated (Derived) "property_address": "123 Main Street",
10
Construction_TypeVARCHARNew | Renovation OR Remodel - (Latest or Current project) "sector": "commercial",
11
Investment Summary Projects_CountVARCHARNumber of active and historical projects associated with the property "parcel_number": "12-34-56-789-000",
12
Project_TypesVARCHARType of projects associated with the property (Roof, Plumbing, Pool ..) "building_type": "Commercial building",
13
Property_StatusVARCHARCurrent Status based on latest project (Planning | in-Progress | Complete) "construction_type": "Renovation",
14
Status_DateDATEDate status was updated (Latest project) "projects_count": 2,
15
Total_Cost_estVARCHAREstimated cost of all projects "project_types": [
16
Project_StagesVARCHARActive and historical project stages, including the corresponding dates "Addition",
17
Elapsed_DaysVARCHARDays elapsed - since latest project status date "Renovation"
18
Work Type IndicatorsAdditionCHARIndicator - work area or type ],
19
AlterationCHARIndicator - work area or type "property_status": "Complete",
20
BathCHARIndicator - work area or type "status_date": "2026-08-19",
21
DeckCHARIndicator - work area or type "total_cost_est": "$1,850,000",
22
DemolitionCHARIndicator - work area or type "elapsed_days": 26,
23
DoorCHARIndicator - work area or type "project_stages": [
24
ElectricalCHARIndicator - work area or type {
25
ElevatorCHARIndicator - work area or type "project_id": "JCCAL-REC26-00000-001GH",
26
ExteriorCHARIndicator - work area or type "stage": "Inspection Phase",
27
FlooringCHARIndicator - work area or type "open_date": "2026-02-05",
28
GarageCHARIndicator - work area or type "status_date": null,
29
GasCHARIndicator - work area or type "update_date": "2026-02-05"
30
GeneratorCHARIndicator - work area or type },
31
HVACCHARIndicator - work area or type {
32
InsulationCHARIndicator - work area or type "project_id": "JCCAL-REC26-00000-001GJ",
33
InteriorCHARIndicator - work area or type "stage": "Inspection Phase",
34
KitchenCHARIndicator - work area or type "open_date": "2026-02-05",
35
LandscapeCHARIndicator - work area or type "status_date": "2026-02-13",
36
MechanicalCHARIndicator - work area or type "update_date": "2026-02-05"
37
NewCHARIndicator - work area or type },
38
PaintingCHARIndicator - work area or type {
39
PanelCHARIndicator - work area or type "project_id": "JCCAL-REC26-00000-001GH",
40
PatioCHARIndicator - work area or type "stage": "Closed - Complete",
41
PlumbingCHARIndicator - work area or type "open_date": "2026-02-05",
42
PoolCHARIndicator - work area or type "status_date": "2026-08-19",
43
PorchCHARIndicator - work area or type "update_date": "2026-08-19"
44
RemodelCHARIndicator - work area or type }
45
RenovationCHARIndicator - work area or type ],
46
RepairCHARIndicator - work area or type "work_types": {
47
RoofCHARIndicator - work area or type "addition": "Y",
48
SolarCHARIndicator - work area or type "alteration": "Y",
49
WallCHARIndicator - work area or type "bath": "",
50
WindowCHARIndicator - work area or type "deck": "",
51
 "demolition": "",
52
 "door": "",
53
 "electrical": "",
54
 "elevator": "",
55
 "exterior": "",
56
 "flooring": "",
57
 "garage": "",
58
 "gas": "",
59
 "generator": "",
60
 "hvac": "Y",
61
 "insulation": "",
62
 "interior": "Y",
63
 "kitchen": "Y",
64
 "landscape": "",
65
 "mechanical": "",
66
 "new": "",
67
 "painting": "",
68
 "panel": "",
69
 "patio": "",
70
 "plumbing": "",
71
 "pool": "",
72
 "porch": "",
73
 "remodel": "Y",
74
 "renovation": "Y",
75
 "repair": "",
76
 "roof": "Y",
77
 "solar": "",
78
 "wall": "",
79
 "window": ""
80
 }
81
 }
82
}
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100