Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172267 | 172267 | 186364 | Undocumented 2 | Shrub :: Shrub 98 | 1801 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984815.8043 | 2102571.1093 | 37.7523814800587 | -122.495419470402 | (37.7523814800587, -122.495419470402) | |||
| 71197 | 71197 | 186427 | Undocumented 2 | Shrub :: Shrub 98 | 1601 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984725.0315 | 2104075.456 | 37.7565066846119 | -122.495844334494 | (37.7565066846119, -122.495844334494) | |||
| 184478 | 184478 | 187025 | Undocumented 2 | Shrub :: Shrub 98 | 2501 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984975.6777 | 2097882.1396 | 37.7395162040617 | -122.494520977899 | (37.7395162040617, -122.494520977899) | |||
| 64376 | 64376 | 187053 | Undocumented 2 | Shrub :: Shrub 98 | 2501 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984954.1557 | 2097623.876 | 37.7388058219757 | -122.494576356208 | (37.7388058219757, -122.494576356208) | |||
| 34598 | 34598 | 187054 | Undocumented 2 | Shrub :: Shrub 98 | 2501 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984950.4566 | 2097599.3275 | 37.738738201883294 | -122.494587336532 | (37.7387382018833, -122.494587336532) | |||
| 42436 | 42436 | 187055 | Undocumented 2 | Shrub :: Shrub 98 | 2501 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984955.8371 | 2097567.7171 | 37.738651723125294 | -122.49456640389 | (37.7386517231253, -122.49456640389) | |||
| 31687 | 31687 | 187056 | Undocumented 2 | Shrub :: Shrub 98 | 2501 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984980.0493 | 2097557.2924 | 37.7386245167659 | -122.49448192258001 | (37.7386245167659, -122.49448192258) | |||
| 167803 | 167803 | 187122 | Undocumented 2 | Shrub :: Shrub 98 | 2600 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985165.8082 | 2097341.5801 | 37.7380430985113 | -122.49382377418101 | (37.7380430985113, -122.493823774181) | |||
| 183333 | 183333 | 187234 | Undocumented 2 | Shrub :: Shrub 98 | 2401 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984956.0101 | 2098625.8109 | 37.7415569740276 | -122.494643790117 | (37.7415569740276, -122.494643790117) | |||
| 55306 | 55306 | 187251 | Undocumented 2 | Shrub :: Shrub 98 | 2401 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984973.9834 | 2098481.6163 | 37.7411621065182 | -122.494571017919 | (37.7411621065182, -122.494571017919) | |||
| 73198 | 73198 | 187253 | Undocumented 2 | Shrub :: Shrub 98 | 2401 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984962.1374 | 2098459.5582 | 37.741100847588896 | -122.494610350765 | (37.7411008475889, -122.494610350765) | |||
| 185026 | 185026 | 187377 | Undocumented 2 | Shrub :: Shrub 98 | 2200 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985052.2703 | 2100029.8298 | 37.7454176637381 | -122.49441443213001 | (37.7454176637381, -122.49441443213) | |||
| 586 | 586 | 237035 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/12/2017 02:27:00 PM | 3 | Width 4ft | 6005709.86547 | 2109855.10938 | 37.7735828886787 | -122.423682154918 | (37.7735828886787, -122.423682154918) | ||
| 622 | 622 | 237036 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 04/13/2017 02:42:00 PM | 3 | Width 4ft | 6005705.053180001 | 2109878.39065 | 37.7736465417793 | -122.423700457022 | (37.7736465417793, -122.423700457022) | ||
| 643 | 643 | 239154 | DPW Maintained 3 | Shrub :: Shrub 98 | 150 Octavia St | 6 | : 4 | Tree 1 | DPW 2 | 04/13/2017 02:47:00 PM | 3 | Width 4ft | 6005701.84613 | 2109911.12293 | 37.773736235682 | -122.42371387848999 | (37.773736235682, -122.42371387849) | ||
| 863 | 863 | 244299 | DPW Maintained 3 | Shrub :: Shrub 98 | 350 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 11:32:00 AM | 3 | Width 0ft | 6005603.4021 | 2110525.6921 | 37.7754181362545 | -122.424098126533 | (37.7754181362545, -122.424098126533) | ||
| 852 | 852 | 244300 | DPW Maintained 3 | Shrub :: Shrub 98 | 350 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 11:46:00 AM | 3 | Width 0ft | 6005602.4578 | 2110538.44 | 37.775453085580295 | -122.424102299872 | (37.7754530855803, -122.424102299872) | ||
| 866 | 866 | 244301 | DPW Maintained 3 | Shrub :: Shrub 98 | 350 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 11:53:00 AM | 3 | Width 0ft | 6005600.097 | 2110553.5487 | 37.775494437113295 | -122.42411154116199 | (37.7754944371133, -122.424111541162) | ||
| 831 | 831 | 244348 | DPW Maintained 3 | Shrub :: Shrub 98 | 300 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2017 02:44:00 PM | 3 | Width 0ft | 6005622.9962 | 2110384.2841 | 37.7750309704349 | -122.424020287681 | (37.7750309704349, -122.424020287681) | ||
| 825 | 825 | 244349 | Undocumented 2 | Shrub :: Shrub 98 | 300 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2017 02:48:00 PM | 3 | Width 0ft | 6005619.6911 | 2110403.6421 | 37.77508393621179 | -122.424033097665 | (37.7750839362118, -122.424033097665) | ||
| 856 | 856 | 244351 | DPW Maintained 3 | Shrub :: Shrub 98 | 300 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 07:17:00 AM | 3 | Width 0ft | 6005616.3861 | 2110436.6924 | 37.7751744977295 | -122.42404688124701 | (37.7751744977295, -122.424046881247) | ||
| 659 | 659 | 244390 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:00:00 PM | 3 | Width 0ft | 6005651.6782 | 2110185.3753 | 37.774486434317105 | -122.423906923072 | (37.7744864343171, -122.423906923072) | ||
| 660 | 660 | 244391 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:16:00 PM | 3 | Width 0ft | 6005650.1507 | 2110201.4148 | 37.774530388668 | -122.42391334778499 | (37.774530388668, -122.423913347785) | ||
| 668 | 668 | 244392 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:27:00 PM | 3 | Width 0ft | 6005647.8593 | 2110218.2181 | 37.774576397101995 | -122.42392246931401 | (37.774576397102, -122.423922469314) | ||
| 664 | 664 | 244393 | Undocumented 2 | Shrub :: Shrub 98 | 250 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2017 01:35:00 PM | 3 | Width 0ft | 6005645.568 | 2110235.0213 | 37.774622405266 | -122.423931590501 | (37.774622405266, -122.423931590501) | ||
| 1666 | 1666 | 251642 | Undocumented 2 | Shrub :: Shrub 98 | 2253 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 3x3 | 6000298.51737 | 2116393.24113 | 37.7912279703404 | -122.442870356286 | (37.7912279703404, -122.442870356286) | ||||
| 2015 | 2015 | 251655 | DPW Maintained 3 | Shrub :: Shrub 98 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5991691.0 | 2087193.0 | 37.710557214846794 | -122.47052422929701 | (37.7105572148468, -122.470524229297) | ||||
| 1720 | 1720 | 251666 | Undocumented 2 | Shrub :: Shrub 98 | 76 Denslowe Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990680.0 | 2091936.0 | 37.723521814492294 | -122.474364317808 | (37.7235218144923, -122.474364317808) | ||||
| 1718 | 1718 | 251667 | Undocumented 2 | Shrub :: Shrub 98 | 1090x Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5988120.0 | 2094796.0 | 37.731225993649296 | -122.483423232518 | (37.7312259936493, -122.483423232518) | ||||
| 2066 | 2066 | 252868 | Undocumented 2 | Shrub :: Shrub 98 | 15 Foerster St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5998080.65269 | 2093664.7185 | 37.7286944544712 | -122.44890616611099 | (37.7286944544712, -122.448906166111) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");