Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25729 | 25729 | 233231 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 4 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010116.17645 | 2099679.88413 | 37.7458917573937 | -122.407722389299 | (37.7458917573937, -122.407722389299) | |||
| 32348 | 32348 | 233229 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 2 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010110.29265 | 2099690.9553400003 | 37.745921827136996 | -122.407743515268 | (37.745921827137, -122.407743515268) | |||
| 38615 | 38615 | 177876 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 4117 San Bruno Ave | 1 | : Yard 23 | Tree 1 | Private 1 | 37 | Width 10ft | 6011467.53014 | 2087476.31968 | 37.7124588649577 | -122.40219173226299 | (37.7124588649577, -122.402191732263) | |||
| 40295 | 40295 | 233234 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 7 | : Yard 23 | Tree 1 | Private 1 | 4 | Width 3ft | 6010136.86006 | 2099655.53222 | 37.7458260502241 | -122.40764915121099 | (37.7458260502241, -122.407649151211) | |||
| 70403 | 70403 | 233232 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 5 | : Yard 23 | Tree 1 | Private 1 | 10 | Width 3ft | 6010129.8045 | 2099669.06085 | 37.7458628019252 | -122.407674502171 | (37.7458628019252, -122.407674502171) | |||
| 75041 | 75041 | 194131 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1310 Indiana St | 4 | : Yard 23 | Tree 1 | Private 1 | 37 | 6014985.85621 | 2102536.5970099997 | 37.754007092062004 | -122.391083210127 | (37.754007092062, -122.391083210127) | ||||
| 76157 | 76157 | 233604 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 10 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6010160.0797 | 2099615.7154599996 | 37.7457180218657 | -122.40756605383301 | (37.7457180218657, -122.407566053833) | |||
| 134356 | 134356 | 233602 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 8 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010143.5997 | 2099646.47131 | 37.7458015482156 | -122.40762520763701 | (37.7458015482156, -122.407625207637) | |||
| 152462 | 152462 | 233605 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 12 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010122.88511 | 2099649.32748 | 37.745808231063705 | -122.407697037414 | (37.7458082310637, -122.407697037414) | |||
| 154537 | 154537 | 233603 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 9 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010152.72418 | 2099634.5230799997 | 37.7457692517475 | -122.40759281407101 | (37.7457692517475, -122.407592814071) | |||
| 156957 | 156957 | 233233 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 6 | : Yard 23 | Tree 1 | Private 1 | 9 | Width 3ft | 6010125.251569999 | 2099665.5030400003 | 37.745852778088 | -122.407689994823 | (37.745852778088, -122.407689994823) | |||
| 169576 | 169576 | 233228 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 1 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6010113.61596 | 2099694.13241 | 37.7459307367175 | -122.407732247644 | (37.7459307367175, -122.407732247644) | |||
| 173331 | 173331 | 233230 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 199 Franconia St | 3 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010120.38838 | 2099686.6934 | 37.745910689944104 | -122.407708305 | (37.7459106899441, -122.407708305) | |||
| 45831 | 45831 | 246626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009022.37721 | 2099388.9393599997 | 37.7450315954447 | -122.411484058261 | (37.7450315954447, -122.411484058261) | ||||
| 59005 | 59005 | 246627 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6009025.0688 | 2099378.58818 | 37.7450033243595 | -122.411474020021 | (37.7450033243595, -122.411474020021) | ||||
| 62381 | 62381 | 248225 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 71 Fair Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6007150.64932 | 2099361.50355 | 37.744851098794996 | -122.417954229804 | (37.744851098795, -122.417954229804) | ||||
| 76093 | 76093 | 248224 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 71 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6007158.82795 | 2099359.7804799997 | 37.7448468279249 | -122.41792582744199 | (37.7448468279249, -122.417925827442) | ||||
| 188553 | 188553 | 246628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009031.72375 | 2099369.08818 | 37.7449776127301 | -122.411450337281 | (37.7449776127301, -122.411450337281) | ||||
| 557 | 557 | 194124 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 123706 | 123706 | 112614 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1799x 22ND ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 3 | Permit Number 776524 | 6012792.0 | 2103743.0 | 37.7571976263526 | -122.398754797925 | (37.7571976263526, -122.398754797925) | ||
| 3750 | 3750 | 253551 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 19 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3758 | 3758 | 253548 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 16 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3837 | 3837 | 253550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 18 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3840 | 3840 | 253546 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 14 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3841 | 3841 | 253549 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 17 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3842 | 3842 | 253547 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 15 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 60806 | 60806 | 96274 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6004001.3006 | 2094332.0064299998 | 37.7308634942567 | -122.428485665086 | (37.7308634942567, -122.428485665086) | ||||
| 154027 | 154027 | 96278 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003898.31997 | 2094328.2986700002 | 37.7308474854131 | -122.42884142159599 | (37.7308474854131, -122.428841421596) | ||||
| 5480 | 5480 | 87732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | ||
| 6941 | 6941 | 87735 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005457.063999999 | 2121526.81323 | 37.8056161950061 | -122.42538739630501 | (37.8056161950061, -122.425387396305) | ||
| 12362 | 12362 | 15901 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/1995 12:00:00 AM | 6 | 20 | 5998236.34112 | 2087033.73083 | 37.710496198018 | -122.447890739788 | (37.710496198018, -122.447890739788) | ||
| 13018 | 13018 | 15903 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5600 Mission St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/01/1992 12:00:00 AM | 6 | TR20 | 5998269.83738 | 2087060.55751 | 37.7105717725495 | -122.44777690001101 | (37.7105717725495, -122.447776900011) | ||
| 15839 | 15839 | 18557 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1700X Quesada Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014589.42489 | 2095117.7447900001 | 37.733614463738604 | -122.391935430178 | (37.7336144637386, -122.391935430178) | |||
| 16013 | 16013 | 22114 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3650X 03rd St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5X5 | 6015872.240569999 | 2098764.87252 | 37.7436998694469 | -122.38775470773999 | (37.7436998694469, -122.38775470774) | |||
| 17312 | 17312 | 29983 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1622X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005924.09258 | 2099580.5471799998 | 37.7453834354083 | -122.42221099896001 | (37.7453834354083, -122.42221099896) | ||
| 18005 | 18005 | 29702 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005878.4786 | 2100373.84581 | 37.747559079794996 | -122.42242508166099 | (37.747559079795, -122.422425081661) | |||
| 19265 | 19265 | 29699 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005882.22155 | 2100316.32182 | 37.747401343192 | -122.42240805210399 | (37.747401343192, -122.422408052104) | |||
| 19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
| 19586 | 19586 | 29705 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005872.46136 | 2100440.5238200002 | 37.747741822942 | -122.422450626014 | (37.747741822942, -122.422450626014) | |||
| 20311 | 20311 | 29991 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 681X San Jose Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005873.40419 | 2099356.34635 | 37.744764971617705 | -122.422370344434 | (37.7447649716177, -122.422370344434) | ||
| 21165 | 21165 | 30006 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 795X San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005619.53854 | 2098557.61175 | 37.742557503841205 | -122.42319139937099 | (37.7425575038412, -122.423191399371) | ||
| 23843 | 23843 | 233645 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1594x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005912.55723 | 2099806.72525 | 37.7460038183146 | -122.422266952984 | (37.7460038183146, -122.422266952984) | |||
| 26941 | 26941 | 233639 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 738x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005705.797780001 | 2098817.87018 | 37.743276982150604 | -122.42291163287099 | (37.7432769821506, -122.422911632871) | |||
| 32672 | 32672 | 233640 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 738x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005718.0637 | 2098849.84637 | 37.7433654736312 | -122.422871492542 | (37.7433654736312, -122.422871492542) | |||
| 36608 | 36608 | 107488 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6011453.59321 | 2119920.31769 | 37.80154211772779 | -122.40452228489599 | (37.8015421177278, -122.404522284896) | ||||
| 48474 | 48474 | 233642 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 688x San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005819.20445 | 2099183.8335 | 37.74428823292521 | -122.422545500883 | (37.7442882329252, -122.422545500883) | |||
| 50406 | 50406 | 233644 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1594x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005913.286069999 | 2099739.4537 | 37.7458191470481 | -122.422259654081 | (37.7458191470481, -122.422259654081) | |||
| 51946 | 51946 | 233643 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 688x San Jose Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005840.60494 | 2099248.2230599998 | 37.7444662393403 | -122.422476076803 | (37.7444662393403, -122.422476076803) | |||
| 54766 | 54766 | 117843 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5983810.12526 | 2111540.49138 | 37.776949922870294 | -122.49956003685301 | (37.7769499228703, -122.499560036853) | |||
| 55578 | 55578 | 107482 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6011457.97806 | 2119852.64786 | 37.801356557918794 | -122.404502345126 | (37.8013565579188, -122.404502345126) | ||||
| 55643 | 55643 | 107485 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6011457.45538 | 2119866.47345 | 37.8013944904094 | -122.40450512760401 | (37.8013944904094, -122.404505127604) | ||||
| 56556 | 56556 | 87733 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005465.59287 | 2121464.4175299997 | 37.8054453543938 | -122.425353437905 | (37.8054453543938, -122.425353437905) | ||
| 56671 | 56671 | 233635 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 795x San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005628.854669999 | 2098582.9928 | 37.74262772020089 | -122.42316099060699 | (37.7426277202009, -122.423160990607) | |||
| 62152 | 62152 | 107486 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1306x Montgomery St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 6011455.57226 | 2119886.9035799997 | 37.8014504813279 | -122.404513083014 | (37.8014504813279, -122.404513083014) | ||||
| 69761 | 69761 | 117845 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 6ft | 5983812.70856 | 2111515.33399 | 37.7768809995382 | -122.49954924088199 | (37.7768809995382, -122.499549240882) | |||
| 75483 | 75483 | 233649 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1534x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005892.8899 | 2100133.60175 | 37.746900237356 | -122.422358181107 | (37.746900237356, -122.422358181107) | |||
| 76029 | 76029 | 117836 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 6ft | 5983819.78589 | 2111279.0355 | 37.776232607542504 | -122.499507291354 | (37.7762326075425, -122.499507291354) | |||
| 76768 | 76768 | 233647 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1534x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005899.49267 | 2100009.81347 | 37.7465607153996 | -122.42232655552799 | (37.7465607153996, -122.422326555528) | |||
| 84021 | 84021 | 30019 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 710X San Jose Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
| 87352 | 87352 | 87731 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
| 88228 | 88228 | 87736 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
| 89578 | 89578 | 11198 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 186 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5995344.6608195 | 2099448.7962231003 | 37.74441926622529 | -122.45878317784799 | (37.7444192662253, -122.458783177848) | |||
| 101078 | 101078 | 30018 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 710X San Jose Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
| 105087 | 105087 | 813 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 111465 | 111465 | 810 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 113375 | 113375 | 30002 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 610X San Jose Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6006030.83928578 | 2099887.5672939997 | 37.74623246341729 | -122.42186369026399 | (37.7462324634173, -122.421863690264) | ||
| 113968 | 113968 | 87734 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | |||
| 114988 | 114988 | 812 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 125002 | 125002 | 87737 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005484.434281 | 2121339.2825599997 | 37.8051028305372 | -122.42527932450001 | (37.8051028305372, -122.4252793245) | ||
| 128619 | 128619 | 22523 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6600 03rd St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | |||
| 133687 | 133687 | 233648 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1534x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005895.98726 | 2100078.89273 | 37.7467501935748 | -122.422343584206 | (37.7467501935748, -122.422343584206) | |||
| 136451 | 136451 | 233641 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 688x San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005830.56896 | 2099219.38294 | 37.74438648474779 | -122.42250873031799 | (37.7443864847478, -122.422508730318) | |||
| 136461 | 136461 | 233650 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1534x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6005893.26396 | 2100151.80931 | 37.7469502522662 | -122.422358181105 | (37.7469502522662, -122.422358181105) | |||
| 145424 | 145424 | 809 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 150249 | 150249 | 233646 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1594x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005909.2658400005 | 2099851.98083 | 37.746127894184106 | -122.422281548977 | (37.7461278941841, -122.422281548977) | |||
| 150462 | 150462 | 210768 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 8x Judah St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5994536.81883 | 2106004.59746 | 37.7623733582716 | -122.46205183074 | (37.7623733582716, -122.46205183074) | |||
| 154625 | 154625 | 117847 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 640x 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 5983816.430369999 | 2111419.8653700002 | 37.7766190887274 | -122.49952930905701 | (37.7766190887274, -122.499529309057) | |||
| 167005 | 167005 | 233636 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 758x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005636.68539 | 2098604.551 | 37.7426873560463 | -122.42313544624399 | (37.7426873560463, -122.423135446244) | |||
| 167503 | 167503 | 117838 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5983820.62988 | 2111252.49481 | 37.7761597840052 | -122.499502409931 | (37.7761597840052, -122.499502409931) | |||
| 169348 | 169348 | 210767 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 750x Parnassus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 5994619.5923 | 2106010.48038 | 37.7623942765042 | -122.46176597673599 | (37.7623942765042, -122.461765976736) | |||
| 182264 | 182264 | 233638 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 750x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6005667.10941 | 2098695.24621 | 37.7429381014114 | -122.42303669349899 | (37.7429381014114, -122.423036693499) | |||
| 186073 | 186073 | 233637 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 758x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005642.24056 | 2098618.09907 | 37.74272486946911 | -122.423117200821 | (37.7427248694691, -122.423117200821) | |||
| 22907 | 22907 | 233756 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.04868 | 2107994.1327400003 | 37.768245263926396 | -122.43746090722 | (37.7682452639264, -122.43746090722) | |||
| 25730 | 25730 | 233142 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000859.74729 | 2102942.63257 | 37.754327958491395 | -122.43996366469901 | (37.7543279584914, -122.439963664699) | |||
| 25825 | 25825 | 233757 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.84947 | 2107982.08951 | 37.7682122417201 | -122.437457274854 | (37.7682122417201, -122.437457274854) | |||
| 30492 | 30492 | 194157 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Rhode Island St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011751.61895 | 2106914.05853 | 37.7658466245494 | -122.40257584440701 | (37.7658466245494, -122.402575844407) | |||
| 36703 | 36703 | 232957 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1500 Cole St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5998345.3439 | 2105333.405 | 37.7607489686178 | -122.448831267855 | (37.7607489686178, -122.448831267855) | |||
| 37783 | 37783 | 131938 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1545 Pacific Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6006702.042119999 | 2117656.1689 | 37.7950586451804 | -122.420803998799 | (37.7950586451804, -122.420803998799) | |||
| 41990 | 41990 | 131872 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 475 Marina Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6000857.63079 | 2121697.12511 | 37.805822893385 | -122.441316575098 | (37.805822893385, -122.441316575098) | |||
| 41998 | 41998 | 232864 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2784 23rd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6010097.8107199995 | 2102827.94887 | 37.7545346199892 | -122.408007862 | (37.7545346199892, -122.408007862) | |||
| 44274 | 44274 | 124649 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 19 Arguello Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 5995460.1391900005 | 2115780.29786 | 37.7892679654039 | -122.459566483421 | (37.7892679654039, -122.459566483421) | |||
| 46684 | 46684 | 131871 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 475 Marina Blvd | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6000836.15896 | 2121693.63297 | 37.8058120817332 | -122.441390630693 | (37.8058120817332, -122.441390630693) | |||
| 47035 | 47035 | 194173 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 612 Arkansas St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6012968.318519999 | 2104189.69747 | 37.7584339823465 | -122.398176354675 | (37.7584339823465, -122.398176354675) | |||
| 48644 | 48644 | 124648 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 5ft | 5995458.44608 | 2115807.32553 | 37.7893420787061 | -122.459574299668 | (37.7893420787061, -122.459574299668) | |||
| 49037 | 49037 | 194154 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 470 Carolina St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6012311.644719999 | 2105752.08257 | 37.762687347553296 | -122.40055718926901 | (37.7626873475533, -122.400557189269) | |||
| 53458 | 53458 | 233069 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 774 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6001540.64018 | 2099730.3572 | 37.7455465535424 | -122.43737896277901 | (37.7455465535424, -122.437378962779) | |||
| 54904 | 54904 | 233003 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 724 Anderson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6007739.01279 | 2095540.2064599998 | 37.7343917558762 | -122.415649262915 | (37.7343917558762, -122.415649262915) | |||
| 59070 | 59070 | 232958 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1500 Cole St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5998343.545080001 | 2105338.45207 | 37.760762723739795 | -122.448837852691 | (37.7607627237398, -122.448837852691) | |||
| 59477 | 59477 | 131848 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5999135.0033599995 | 2121188.05982 | 37.804326857662 | -122.44724130424801 | (37.804326857662, -122.447241304248) | |||
| 65964 | 65964 | 246019 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 609 Clayton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 0ft | 5998477.1179 | 2108551.0541 | 37.7695913556898 | -122.44860726821899 | (37.7695913556898, -122.448607268219) |
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");