Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 560 | 560 | 131782 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | ||
| 2788 | 2788 | 252853 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | ||||
| 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) | ||
| 79381 | 79381 | 114695 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009121.0 | 2115613.0 | 37.7895846457112 | -122.41228952949498 | (37.7895846457112, -122.412289529495) | ||||
| 84179 | 84179 | 98330 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 147 Alhambra St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001593.9 | 2120254.3 | 37.801903193112004 | -122.438665159251 | (37.801903193112, -122.438665159251) | ||
| 87526 | 87526 | 97446 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 200X Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997060.8 | 2112843.2 | 37.7812953839865 | -122.453816232036 | (37.7812953839865, -122.453816232036) | ||
| 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) | |
| 89979 | 89979 | 93574 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2998 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | ||
| 93755 | 93755 | 115008 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | Permit Number 774445 | 5985969.5 | 2110831.9 | 37.775130796003204 | -122.49203801834601 | (37.7751307960032, -122.492038018346) | |||
| 96543 | 96543 | 76813 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1320 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.80158108443371 | -122.423282592369 | (37.8015810844337, -122.423282592369) | |||
| 98226 | 98226 | 116254 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
| 100092 | 100092 | 112520 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 146x ARLETA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010471.0 | 2087928.0 | 37.7136434126305 | -122.40566785728501 | (37.7136434126305, -122.405667857285) | ||||
| 101213 | 101213 | 103593 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 10X Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | ||
| 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) | ||
| 108555 | 108555 | 104604 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 10X Russell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.434880001 | 2118959.67619 | 37.798660985130795 | -122.419469576763 | (37.7986609851308, -122.419469576763) | ||
| 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) | ||
| 114164 | 114164 | 116239 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
| 117505 | 117505 | 105053 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 501X 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2013 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.6423299997 | 37.779031128568796 | -122.48680778308001 | (37.7790311285688, -122.48680778308) | ||
| 120569 | 120569 | 113398 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 603 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998367.0 | 2108846.0 | 37.7703949048055 | -122.44900941031099 | (37.7703949048055, -122.449009410311) | ||||
| 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) | ||
| 135481 | 135481 | 105010 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 11 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.785789717987704 | -122.455998396638 | (37.7857897179877, -122.455998396638) | ||
| 141309 | 141309 | 103086 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) |
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");