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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4152 | 4152 | 216685 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.8719900001 | 37.720244788744104 | -122.46233566126101 | (37.7202447887441, -122.462335661261) | ||
| 4474 | 4474 | 162754 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 997x Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 11:43:00 AM | 3 | Width 0ft | 5995095.0 | 2090528.0 | 37.719910580533295 | -122.45900065774599 | (37.7199105805333, -122.459000657746) | ||
| 5406 | 5406 | 13016 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 407 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/2016 02:31:00 PM | 3 | 3X3 | 6010356.171 | 2120603.3463 | 37.8033561544514 | -122.408368084374 | (37.8033561544514, -122.408368084374) | ||
| 5910 | 5910 | 13011 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 396 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:12:00 AM | 3 | 3X3 | 6010476.6325 | 2120660.3892 | 37.8035195251148 | -122.40795524597999 | (37.8035195251148, -122.40795524598) | ||
| 7621 | 7621 | 29909 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 515-519 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 07:29:00 AM | 3 | 3x3 | 6009867.8709 | 2120537.6157 | 37.8031483182934 | -122.41005322890301 | (37.8031483182934, -122.410053228903) | ||
| 22867 | 22867 | 143011 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 650-654 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2017 12:26:00 PM | 3 | Width 0ft | 6009188.4253 | 2120483.2963 | 37.8029610657241 | -122.41240063587601 | (37.8029610657241, -122.412400635876) | ||
| 89140 | 89140 | 24659 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 3299X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772930 | 5997061.39714 | 2112911.4526400003 | 37.7814828219847 | -122.453819096525 | (37.7814828219847, -122.453819096525) | |
| 104340 | 104340 | 74892 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
| 105773 | 105773 | 102005 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1703 CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | |
| 107040 | 107040 | 119284 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 651 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5987187.0 | 2111505.0 | 37.777050030999604 | -122.487875935939 | (37.7770500309996, -122.487875935939) | ||
| 107527 | 107527 | 1444 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | ||
| 110276 | 110276 | 121108 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608.0 | 2106030.0 | 37.7623895873424 | -122.46526608917601 | (37.7623895873424, -122.465266089176) | ||
| 122317 | 122317 | 13082 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 650 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 10:37:00 AM | 3 | 3x3 | 6009219.60633 | 2120572.31429 | 37.803207236671604 | -122.41229902844101 | (37.8032072366716, -122.412299028441) | ||
| 125041 | 125041 | 13072 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2008 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
| 128131 | 128131 | 115769 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.709055747846705 | -122.43588629224399 | (37.7090557478467, -122.435886292244) | ||
| 128494 | 128494 | 13022 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 431 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2015 07:20:00 AM | 3 | 3X3 | 6010276.62799 | 2120585.425 | 37.803302492372396 | -122.408642082138 | (37.8033024923724, -122.408642082138) | ||
| 6621 | 6621 | 13040 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 515-519 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 07:26:00 AM | 3 | 3X3 | 6009890.5899 | 2120540.3695 | 37.8031571528751 | -122.409974803368 | (37.8031571528751, -122.409974803368) | ||
| 22647 | 22647 | 9116 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 5757 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/2015 12:00:00 AM | 3 | 3x3 | 5989143.6236 | 2112579.8502 | 37.7801152084298 | -122.48118616959499 | (37.7801152084298, -122.481186169595) | ||
| 120000 | 120000 | 102006 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1703 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | |
| 78192 | 78192 | 109745 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2730 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769296 | 6008568.6 | 2106948.2 | 37.7657621501348 | -122.413587690705 | (37.7657621501348, -122.413587690705) |
| 89928 | 89928 | 115438 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2500X Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777506 | 6006688.6 | 2119773.1 | 37.8008704472237 | -122.421000888697 | (37.8008704472237, -122.421000888697) | ||
| 96845 | 96845 | 13075 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/22/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774508 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |
| 4886 | 4886 | 17862 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.43099633374901 | (37.7882072868246, -122.430996333749) |
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");