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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76161 | 76161 | 90650 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3350 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985244.351217 | 2110444.86641 | 37.77402569788379 | -122.494517894729 | (37.7740256978838, -122.494517894729) | |
| 77588 | 77588 | 90649 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3350 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985244.351217 | 2110444.86641 | 37.77402569788379 | -122.494517894729 | (37.7740256978838, -122.494517894729) | |
| 82136 | 82136 | 90665 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3636 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 8 | 4x4 | 5984356.369637 | 2110412.6389740002 | 37.773885200127 | -122.49758714758 | (37.773885200127, -122.49758714758) | |
| 86271 | 86271 | 90668 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3700 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984154.259047 | 2110405.3037610003 | 37.773853210641605 | -122.498285728583 | (37.7738532106416, -122.498285728583) | |
| 90226 | 90226 | 90644 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 94469 | 94469 | 90653 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3400 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985083.076571 | 2110439.01327 | 37.7740001866718 | -122.495075331328 | (37.7740001866718, -122.495075331328) | |
| 94921 | 94921 | 90651 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3350 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985244.351217 | 2110444.86641 | 37.77402569788379 | -122.494517894729 | (37.7740256978838, -122.494517894729) | |
| 96504 | 96504 | 90648 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3326 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985315.670548 | 2110447.4548029997 | 37.774036978686105 | -122.494271383414 | (37.7740369786861, -122.494271383414) | |
| 111630 | 111630 | 90646 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 114588 | 114588 | 90645 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 123325 | 123325 | 90647 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3320 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985333.500383999 | 2110448.101901 | 37.7740397988057 | -122.494209755562 | (37.7740397988057, -122.494209755562) | |
| 127391 | 127391 | 90662 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3518 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984718.446788 | 2110425.779815 | 37.7739424981767 | -122.49633565193199 | (37.7739424981767, -122.496335651932) | |
| 141454 | 141454 | 90654 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3400 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985083.076571 | 2110439.01327 | 37.7740001866718 | -122.495075331328 | (37.7740001866718, -122.495075331328) | |
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 114895 | 114895 | 116578 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 11 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | ||
| 6568 | 6568 | 92750 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2049 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/02/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52971 | 5998090.3691 | 2110284.0117 | 37.774327490890705 | -122.450069934151 | (37.7743274908907, -122.450069934151) |
| 15372 | 15372 | 116055 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/30/2016 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.40328006754801 | (37.7611252557522, -122.403280067548) | |
| 127092 | 127092 | 116522 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 324 08TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW for City Agency 2 | 8 | 3x3 | 5993416.0 | 2113304.0 | 37.7823509768718 | -122.466458848407 | (37.7823509768718, -122.466458848407) | ||
| 168957 | 168957 | 116048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4x4 | 6011498.51602 | 2105372.79225 | 37.7616005195649 | -122.403342842915 | (37.7616005195649, -122.403342842915) | ||
| 10036 | 10036 | 64803 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 110X VALLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779438 | 6005124.0 | 2099350.0 | 37.7447052436017 | -122.424961191686 | (37.7447052436017, -122.424961191686) | |
| 34434 | 34434 | 83787 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1926 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 9 | 5981682.722 | 2101945.6334 | 37.750480149523796 | -122.506207617383 | (37.7504801495238, -122.506207617383) | ||
| 35296 | 35296 | 75017 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Dorman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1997 12:00:00 AM | 14 | 6011095.51982 | 2097238.5902400003 | 37.7392432646533 | -122.40416415145201 | (37.7392432646533, -122.404164151452) | ||
| 36508 | 36508 | 31629 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2667 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35146 | 5981804.4287 | 2096935.1986 | 37.736730050914296 | -122.505415418144 | (37.7367300509143, -122.505415418144) | |
| 48592 | 48592 | 63207 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3633 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | Permit Number 23749 | 5984209.30853 | 2113126.2552799997 | 37.7813273844972 | -122.498296310267 | (37.7813273844972, -122.498296310267) | |
| 55465 | 55465 | 75612 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013522.58771 | 2104188.6871599997 | 37.7584620654811 | -122.396259360694 | (37.7584620654811, -122.396259360694) | ||
| 57301 | 57301 | 83542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 19 | 5980747.696719999 | 2109761.67142 | 37.7718856460039 | -122.51002154176399 | (37.7718856460039, -122.510021541764) | |||
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 75161 | 75161 | 41044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1444 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2000 12:00:00 AM | Permit Number 41825 | 6007214.22869275 | 2117785.20726397 | 37.795441807697294 | -122.41904090928001 | (37.7954418076973, -122.41904090928) | ||
| 75879 | 75879 | 35907 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2295 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 14 | Permit Number 39091 | 6011293.56173 | 2098002.1271 | 37.7413508375758 | -122.403533112479 | (37.7413508375758, -122.403533112479) | |
| 76036 | 76036 | 37096 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1467 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39696 | 5981524.9714 | 2105106.2752 | 37.759149087294794 | -122.506987547698 | (37.7591490872948, -122.506987547698) | |
| 78222 | 78222 | 38067 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1654X SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8x5 | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 92083 | 92083 | 38475 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 162 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40476 | 5999822.84916102 | 2087316.82231241 | 37.7113640595721 | -122.44242775396002 | (37.7113640595721, -122.44242775396) | ||
| 92242 | 92242 | 33912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 665 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 37882 | 6002076.88418057 | 2102621.6953038997 | 37.753515953271496 | -122.435731542402 | (37.7535159532715, -122.435731542402) | ||
| 96955 | 96955 | 41426 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 42033 | 6003639.60917921 | 2104762.31302618 | 37.759482223502395 | -122.430480029002 | (37.7594822235024, -122.430480029002) | ||
| 103613 | 103613 | 34289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38080 | 5987074.67438797 | 2114433.79174181 | 37.7850851064396 | -122.488479804204 | (37.7850851064396, -122.488479804204) | ||
| 123095 | 123095 | 63455 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 746 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | Permit Number 28489 | 6007346.89818679 | 2095405.54054849 | 37.7339999430548 | -122.41699539620001 | (37.7339999430548, -122.4169953962) | ||
| 127923 | 127923 | 81254 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | 5989768.37779 | 2110442.38687 | 37.7742826266156 | -122.478868506685 | (37.7742826266156, -122.478868506685) | |
| 139715 | 139715 | 32413 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2002 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | ||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 153246 | 153246 | 69457 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 19 | 3x3 | Permit Number 33567 | 5985660.203509999 | 2112573.9841400003 | 37.7798959764685 | -122.493236296991 | (37.7798959764685, -122.493236296991) |
| 154737 | 154737 | 79125 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825-875 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 4x4 | 5980734.99741 | 2110066.24575 | 37.772721168522295 | -122.51008810063601 | (37.7727211685223, -122.510088100636) | ||
| 159477 | 159477 | 79477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3518 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2001 12:00:00 AM | 4 | 5982515.1145 | 2100854.6307 | 37.7475335277544 | -122.503248420372 | (37.7475335277544, -122.503248420372) | ||
| 160901 | 160901 | 76366 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 7 | 6013050.90203 | 2119190.90632 | 37.7996284665342 | -122.398943613057 | (37.7996284665342, -122.398943613057) | ||
| 168440 | 168440 | 75548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013526.462719999 | 2104188.60864 | 37.758462065501796 | -122.39624595358102 | (37.7584620655018, -122.396245953581) | ||
| 177905 | 177905 | 43789 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 121 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 10 | Permit Number 43419 | 5988953.60454 | 2114542.0898700003 | 37.7854919174236 | -122.481987309149 | (37.7854919174236, -122.481987309149) | |
| 1 | 1 | 141565 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1988 12:00:00 AM | 21 | Width 0ft | Permit Number 25401 | 6000609.0 | 2110829.0 | 37.7759676911831 | -122.441396661871 | (37.7759676911831, -122.441396661871) | |
| 6 | 6 | 141566 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000587.8822 | 2110733.5952 | 37.7757045307049 | -122.441462866076 | (37.7757045307049, -122.441462866076) | |||
| 35 | 35 | 183515 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2562 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779639 | 5988336.7554 | 2097879.9474 | 37.7397063254514 | -122.482899813956 | (37.7397063254514, -122.482899813956) | |
| 114 | 114 | 251216 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 118 | 118 | 251217 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 191 | 191 | 210495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | Permit Number 779799 | 5992304.44524 | 2094447.3559700001 | 37.7305113566072 | -122.468931622808 | (37.7305113566072, -122.468931622808) | ||
| 263 | 263 | 141358 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 654 | 654 | 122328 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3015 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779630 | 5996535.0 | 2111432.0 | 37.7773904414434 | -122.455533202662 | (37.7773904414434, -122.455533202662) | |
| 694 | 694 | 120738 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700x 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Width 4ft | 5989768.19982 | 2110516.41697 | 37.7744858825371 | -122.478874537994 | (37.7744858825371, -122.478874537994) | ||
| 717 | 717 | 106656 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989753.9107099995 | 2110247.9151 | 37.773747820615704 | -122.47890432357 | (37.7737478206157, -122.47890432357) | |
| 720 | 720 | 104746 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989767.16587 | 2110527.4876599996 | 37.774516219561704 | -122.478878924469 | (37.7745162195617, -122.478878924469) | |
| 828 | 828 | 8634 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999136.363 | 2113194.1665 | 37.7823778250539 | -122.44666108993299 | (37.7823778250539, -122.446661089933) | |||
| 867 | 867 | 5563 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005047.93676 | 2102495.8008 | 37.753338590028 | -122.42544803402399 | (37.753338590028, -122.425448034024) | |||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 1011 | 1011 | 232310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 26 | Width 3ft | Permit Number 17854 | 5997696.0 | 2107004.0 | 37.7652988449505 | -122.451197528579 | (37.7652988449505, -122.451197528579) | |
| 1095 | 1095 | 54070 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1649 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 1 | Permit Number 9793 | 5981260.4052 | 2103836.5943 | 37.7556473215408 | -122.50780830550801 | (37.7556473215408, -122.507808305508) | ||
| 1214 | 1214 | 14441 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 57 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5998815.3699 | 2112874.8656 | 37.781482766726896 | -122.447748586483 | (37.7814827667269, -122.447748586483) | |||
| 1262 | 1262 | 251479 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 779194 | 5987090.84961 | 2106996.2792700003 | 37.7646647351899 | -122.48787719677 | (37.7646647351899, -122.48787719677) | ||||
| 1333 | 1333 | 187634 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 148 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779931 | 5987142.0 | 2114987.0 | 37.786607985699604 | -122.48828755026399 | (37.7866079856996, -122.488287550264) | |||
| 1412 | 1412 | 120316 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779745 | 5988743.0107 | 2113100.3508099997 | 37.7815210589505 | -122.482610207249 | (37.7815210589505, -122.482610207249) | |
| 1423 | 1423 | 54061 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 12 | Permit Number 779745 | 5988745.7457 | 2113084.32895 | 37.7814772265446 | -122.482599571173 | (37.7814772265446, -122.482599571173) | ||
| 1465 | 1465 | 210473 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.5743400003 | 37.765803096458995 | -122.46722890580901 | (37.765803096459, -122.467228905809) | |
| 1545 | 1545 | 142037 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1549 | 1549 | 142039 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1550 | 1550 | 142038 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1687 | 1687 | 18887 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2407 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003191.46268 | 2115855.10762 | 37.789914898090004 | -122.432822394747 | (37.78991489809, -122.432822394747) | |||
| 1992 | 1992 | 232379 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4235 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1972 12:00:00 AM | 16 | Width 3ft | Permit Number 10249 | 6001645.52772 | 2101734.6442400003 | 37.751055812089 | -122.43715975664499 | (37.751055812089, -122.437159756645) | |
| 2528 | 2528 | 138185 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1865 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003940.6794 | 2114739.7851 | 37.786894968468 | -122.43015057261002 | (37.786894968468, -122.43015057261) | |||
| 2855 | 2855 | 110902 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300x Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005485.732559999 | 2117962.0378900003 | 37.795829853409295 | -122.425034389936 | (37.7958298534093, -122.425034389936) | |||
| 3267 | 3267 | 2831 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6008484.02773 | 2116302.9533599997 | 37.791443325609606 | -122.414542237062 | (37.7914433256096, -122.414542237062) | |||
| 3830 | 3830 | 14440 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 45 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 5998808.9399 | 2112938.4889 | 37.78165709226779 | -122.44777541277399 | (37.7816570922678, -122.447775412774) | |||
| 4023 | 4023 | 232380 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 737 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 6001617.91184 | 2102022.2796 | 37.7518440201921 | -122.437275848296 | (37.7518440201921, -122.437275848296) | |||
| 4468 | 4468 | 253632 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 527 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6004455.0 | 2110106.0 | 37.7742008582336 | -122.42804080634701 | (37.7742008582336, -122.428040806347) | ||||
| 4547 | 4547 | 131706 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 135 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997495.0 | 2115921.0 | 37.789771092089794 | -122.452536302556 | (37.7897710920898, -122.452536302556) | |||
| 4551 | 4551 | 131707 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 135 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997495.0 | 2115921.0 | 37.789771092089794 | -122.452536302556 | (37.7897710920898, -122.452536302556) | |||
| 4979 | 4979 | 8629 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999229.0905 | 2113208.3802 | 37.78242214856029 | -122.44634131765899 | (37.7824221485603, -122.446341317659) | |||
| 5081 | 5081 | 253792 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5085 | 5085 | 253795 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5086 | 5086 | 110900 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300x Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005496.29651 | 2117906.44165 | 37.795677796936495 | -122.42499387908998 | (37.7956777969365, -122.42499387909) | |||
| 5092 | 5092 | 253791 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5097 | 5097 | 253793 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5099 | 5099 | 253794 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5433 | 5433 | 8620 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999320.4644 | 2113220.5634 | 37.7824608186771 | -122.446026081758 | (37.7824608186771, -122.446026081758) | |||
| 5601 | 5601 | 116211 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996580.5135 | 2114939.45555 | 37.7870235965959 | -122.455629343026 | (37.7870235965959, -122.455629343026) | |
| 5798 | 5798 | 8630 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999216.9073 | 2113207.365 | 37.7824186652585 | -122.44638339297501 | (37.7824186652585, -122.446383392975) | |||
| 5802 | 5802 | 122541 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2233 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779046 | 6001437.2497 | 2113869.2014 | 37.7843624618515 | -122.438749438347 | (37.7843624618515, -122.438749438347) | |
| 6574 | 6574 | 2832 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008465.75544 | 2116301.4842 | 37.7914382651038 | -122.414605355047 | (37.7914382651038, -122.414605355047) | |||
| 6978 | 6978 | 6035 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1826 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001552.687000001 | 2112546.4084 | 37.780736975678295 | -122.438255270265 | (37.7807369756783, -122.438255270265) | |||
| 7105 | 7105 | 61394 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2584 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1984 12:00:00 AM | 15 | 3x3 | Permit Number 21315 | 5999837.8956 | 2113700.6918 | 37.7838086607697 | -122.44427051519399 | (37.7838086607697, -122.444270515194) | |
| 7106 | 7106 | 8639 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 5999285.607000001 | 2113327.5047 | 37.7827524611939 | -122.446154367514 | (37.7827524611939, -122.446154367514) | |||
| 7131 | 7131 | 116025 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1425 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | 3x3 | 6006694.6941 | 2118351.37216 | 37.796967084814 | -122.42087880533501 | (37.796967084814, -122.420878805335) |
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");