Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9605 | 9605 | 17889 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2231 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 8 | 3x3 | 6003230.4792 | 2115158.6176 | 37.7880047264698 | -122.432637629177 | (37.7880047264698, -122.432637629177) | ||
| 14778 | 14778 | 32943 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 999X Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37261 | 6015287.47006 | 2104039.63341 | 37.7581508424957 | -122.39014514528499 | (37.7581508424957, -122.390145145285) |
| 21042 | 21042 | 2393 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 2656 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2002 12:00:00 AM | 8 | 3X3 | 6009747.5539 | 2101876.46868 | 37.7519024509371 | -122.409152011861 | (37.7519024509371, -122.409152011861) | ||
| 23575 | 23575 | 229749 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3420 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006865.442430001 | 2100893.1642400003 | 37.7490406373221 | -122.41904904288401 | (37.7490406373221, -122.419049042884) | |||
| 24056 | 24056 | 229874 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3570 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004568.82488 | 2103108.4476799998 | 37.7549936933086 | -122.42714853777001 | (37.7549936933086, -122.42714853777) | |||
| 24122 | 24122 | 226450 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008406.2637 | 2102737.10298 | 37.7541903253409 | -122.413851270843 | (37.7541903253409, -122.413851270843) | |||
| 24375 | 24375 | 129099 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 240 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002192.1868900005 | 2118975.47765 | 37.79842589939221 | -122.43650322546499 | (37.7984258993922, -122.436503225465) | |||
| 25783 | 25783 | 70682 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 8 | 6010606.08274 | 2106339.87511 | 37.764206026409795 | -122.406497569303 | (37.7642060264098, -122.406497569303) | ||
| 25919 | 25919 | 40096 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 359 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | 8 | Permit Number 44400 | 6014088.36289 | 2105304.3939 | 37.7615570193592 | -122.394380761457 | (37.7615570193592, -122.394380761457) | ||
| 27369 | 27369 | 69766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6014547.15395 | 2096165.5632900002 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | ||
| 28348 | 28348 | 226784 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 549 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003023.04842 | 2105091.7124400004 | 37.7603517290589 | -122.432635928409 | (37.7603517290589, -122.432635928409) | |||
| 28783 | 28783 | 226457 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008057.367869999 | 2104469.97829 | 37.758928805544 | -122.415180498503 | (37.758928805544, -122.415180498503) | |||
| 28840 | 28840 | 37987 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 613 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40209 | 6013866.01576 | 2104192.39502 | 37.7584913501141 | -122.39507188416 | (37.7584913501141, -122.39507188416) | |
| 30375 | 30375 | 229824 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1306 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010048.45335 | 2101561.1915599997 | 37.751053622231495 | -122.408089221836 | (37.7510536222315, -122.408089221836) | |||
| 30551 | 30551 | 226313 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2479 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008246.47754 | 2104016.96539 | 37.7576955616045 | -122.414494411095 | (37.7576955616045, -122.414494411095) | |||
| 36302 | 36302 | 38643 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 850 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 8 | Permit Number 41006 | 6012722.66852 | 2103506.4045 | 37.7565441236392 | -122.39897796896099 | (37.7565441236392, -122.398977968961) | |
| 40456 | 40456 | 229883 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3784 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008413.69404 | 2097282.5968400002 | 37.7392138829104 | -122.413439846296 | (37.7392138829104, -122.413439846296) | |||
| 40748 | 40748 | 229794 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 270 14th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.768382235178706 | -122.419295689168 | (37.7683822351787, -122.419295689168) | |||
| 40930 | 40930 | 226331 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 155 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6006477.527480001 | 2105222.5882 | 37.7609063850338 | -122.420697763712 | (37.7609063850338, -122.420697763712) | |||
| 42129 | 42129 | 108456 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 980 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015231.85708 | 2103981.85157 | 37.7579891012316 | -122.390333443542 | (37.7579891012316, -122.390333443542) | ||||
| 42935 | 42935 | 226446 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3102 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008932.04499 | 2101596.23583 | 37.75108727397021 | -122.411952365814 | (37.7510872739702, -122.411952365814) | |||
| 44950 | 44950 | 101142 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 450 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6x5 | 6013202.87541 | 2105008.80467 | 37.7606961334358 | -122.397422590588 | (37.7606961334358, -122.397422590588) | |||
| 45657 | 45657 | 229886 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1420 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007989.59839 | 2099723.5875 | 37.7458924813579 | -122.41507891646002 | (37.7458924813579, -122.41507891646) | |||
| 46089 | 46089 | 229832 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1216 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010283.83962 | 2102006.15901 | 37.7522885811545 | -122.407306593143 | (37.7522885811545, -122.407306593143) | |||
| 46593 | 46593 | 229810 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1801 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009529.11729 | 2106277.27866 | 37.7639738421376 | -122.41021807989999 | (37.7639738421376, -122.4102180799) | |||
| 47649 | 47649 | 226766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 84 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005428.90079 | 2099643.2891700002 | 37.7455277666988 | -122.42392775438101 | (37.7455277666988, -122.423927754381) | |||
| 47760 | 47760 | 226378 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 511 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008209.356369999 | 2096429.78748 | 37.7368607798011 | -122.414086039755 | (37.7368607798011, -122.414086039755) | |||
| 48009 | 48009 | 190733 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010530.15081 | 2107694.7357900003 | 37.767921917195004 | -122.406855692832 | (37.767921917195, -122.406855692832) | |||
| 50888 | 50888 | 226456 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008043.14081 | 2104467.44618 | 37.7589210533947 | -122.41522952324 | (37.7589210533947, -122.41522952324) | |||
| 51559 | 51559 | 190682 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 546 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010644.5889099995 | 2105668.4578400003 | 37.7623646204591 | -122.40631707628799 | (37.7623646204591, -122.406317076288) | |||
| 54838 | 54838 | 226397 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1490 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008007.72496 | 2099487.35787 | 37.745244866072 | -122.414999519809 | (37.745244866072, -122.414999519809) | |||
| 55903 | 55903 | 226361 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005760.58737 | 2103420.35055 | 37.7559174283599 | -122.423049246236 | (37.7559174283599, -122.423049246236) | |||
| 59202 | 59202 | 226813 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Belcher St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003766.50306 | 2108228.71833 | 37.7690073251557 | -122.43028847844101 | (37.7690073251557, -122.430288478441) | |||
| 60691 | 60691 | 37945 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 829 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40186 | 6012472.75193 | 2104081.82753 | 37.7581101796629 | -122.39988268066601 | (37.7581101796629, -122.399882680666) | |
| 60773 | 60773 | 226327 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 351 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007824.63975 | 2105811.28938 | 37.7625986546389 | -122.41608037450399 | (37.7625986546389, -122.416080374504) | |||
| 62884 | 62884 | 229791 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1471 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007593.88535 | 2107340.0945599996 | 37.7667834204575 | -122.416986798497 | (37.7667834204575, -122.416986798497) | |||
| 63247 | 63247 | 190720 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 315 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6014070.97859 | 2105596.2230599998 | 37.762357352140796 | -122.394461321843 | (37.7623573521408, -122.394461321843) | |||
| 63954 | 63954 | 228524 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 29 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519303999 | (37.7708619961085, -122.42386519304) | |||
| 64662 | 64662 | 228544 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1457 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009585.793980001 | 2100740.24888 | 37.7487735800335 | -122.40963121470399 | (37.7487735800335, -122.409631214704) | |||
| 64880 | 64880 | 226441 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 507 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006831.87915 | 2100767.2588 | 37.7486930394633 | -122.419156175534 | (37.7486930394633, -122.419156175534) | |||
| 65147 | 65147 | 100089 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2034 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003188.20593 | 2118955.0281 | 37.7984262977915 | -122.43305523462601 | (37.7984262977915, -122.433055234626) | |||
| 70859 | 70859 | 226812 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Belcher St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 6003760.63198 | 2108231.56549 | 37.7690148102126 | -122.430308989291 | (37.7690148102126, -122.430308989291) | |||
| 71295 | 71295 | 228531 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1744 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009451.253190001 | 2106552.40785 | 37.7647249190387 | -122.41050681893199 | (37.7647249190387, -122.410506818932) | |||
| 72778 | 72778 | 226311 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2070 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008053.75125 | 2106490.49002 | 37.764476461547204 | -122.415336042545 | (37.7644764615472, -122.415336042545) | |||
| 76262 | 76262 | 226425 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3529 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005988.7983800005 | 2101974.74893 | 37.7519610156893 | -122.42215731931101 | (37.7519610156893, -122.422157319311) | |||
| 82302 | 82302 | 100215 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 59 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 7x6 | 6008249.0 | 2099678.0 | 37.745781882165495 | -122.41417871405301 | (37.7457818821655, -122.414178714053) | |||
| 103667 | 103667 | 68104 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 77 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 8 | 5x7 | Permit Number 31850 | 6008263.32103821 | 2099576.36139011 | 37.7455036095439 | -122.414122004435 | (37.7455036095439, -122.414122004435) |
| 110754 | 110754 | 40302 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 241 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41447 | 6006718.06702337 | 2104716.40691697 | 37.7595300830635 | -122.41982992299299 | (37.7595300830635, -122.419829922993) |
| 118442 | 118442 | 229790 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1471 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007575.95086 | 2107340.46198 | 37.766783420442295 | -122.417048857113 | (37.7667834204423, -122.417048857113) | |||
| 118944 | 118944 | 68103 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 67 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 8 | 3x3 | Permit Number 31849 | 6008260.07157656 | 2099634.80152159 | 37.745663890633296 | -122.414137374358 | (37.7456638906333, -122.414137374358) |
| 120817 | 120817 | 41339 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 791 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2000 12:00:00 AM | 8 | Permit Number 41992 | 6002462.02491535 | 2103606.38445454 | 37.756241543596104 | -122.434470043403 | (37.7562415435961, -122.434470043403) | ||
| 122553 | 122553 | 37969 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 601 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40199 | 6013584.10507 | 2104296.87899 | 37.758762559563706 | -122.396054186654 | (37.7587625595637, -122.396054186654) | |
| 122577 | 122577 | 37677 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 8 | 0x0 | Permit Number 40072 | 6008031.0 | 2104525.0 | 37.7590784006599 | -122.41527558618401 | (37.7590784006599, -122.415275586184) |
| 124012 | 124012 | 65976 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 59 & 1/2 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 8 | 6x6 | Permit Number 31847 | 6008257.472006501 | 2099681.55363989 | 37.745792115536204 | -122.414149670347 | (37.7457921155362, -122.414149670347) |
| 127350 | 127350 | 37673 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3330 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 8 | 0x0 | Permit Number 40071 | 6008076.0 | 2104474.0 | 37.758940895326 | -122.415116344354 | (37.758940895326, -122.415116344354) |
| 127435 | 127435 | 104712 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 303 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x4 | 6012983.0 | 2105615.0 | 37.7623483675995 | -122.39822557732 | (37.7623483675995, -122.39822557732) | |||
| 129653 | 129653 | 78436 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1379 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 8 | 6012015.72942 | 2101977.3514400003 | 37.75230626003879 | -122.401315382525 | (37.7523062600388, -122.401315382525) | ||
| 129988 | 129988 | 229894 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1435 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008020.95699 | 2099824.31502 | 37.7461708188376 | -122.414977610555 | (37.7461708188376, -122.414977610555) | |||
| 133452 | 133452 | 49994 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 908@ 20TH ST Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 8 | Permit Number 46738 | 6011568.01566 | 2104131.09801 | 37.758194984815795 | -122.40301513085899 | (37.7581949848158, -122.403015130859) | |
| 137568 | 137568 | 229817 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 Treat Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008585.08431 | 2102813.4393 | 37.7544099685703 | -122.413238260532 | (37.7544099685703, -122.413238260532) | |||
| 146164 | 146164 | 37674 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3318 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 8 | Permit Number 40071 | 6008076.0 | 2104474.0 | 37.758940895326 | -122.415116344354 | (37.758940895326, -122.415116344354) | |
| 147439 | 147439 | 226348 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3171 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008541.46923 | 2101528.9029099997 | 37.7508804721644 | -122.41329826061 | (37.7508804721644, -122.41329826061) | |||
| 149409 | 149409 | 226332 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 375 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006554.33185 | 2103938.10379 | 37.757383817915 | -122.420340959477 | (37.757383817915, -122.420340959477) | |||
| 150373 | 150373 | 229747 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 84 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005427.81149 | 2099645.37238 | 37.74553342522071 | -122.423931669125 | (37.7455334252207, -122.423931669125) | |||
| 153203 | 153203 | 229834 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2899 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010114.090419999 | 2101618.66364 | 37.7512151027139 | -122.40786629340799 | (37.7512151027139, -122.407866293408) | |||
| 156251 | 156251 | 32967 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 571 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 8 | Permit Number 37282 | 6014131.46964 | 2104484.11535 | 37.7593071089655 | -122.394174242052 | (37.7593071089655, -122.394174242052) | |
| 160031 | 160031 | 229851 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3476 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005224.27496 | 2103144.25068 | 37.7551290439715 | -122.42488434973801 | (37.7551290439715, -122.424884349738) | |||
| 160847 | 160847 | 129100 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004473.20652 | 2110925.86056 | 37.7764530246232 | -122.42803626308701 | (37.7764530246232, -122.428036263087) | |||
| 161505 | 161505 | 229798 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006019.29949 | 2105109.06322 | 37.7605688353024 | -122.422274509073 | (37.7605688353024, -122.422274509073) | |||
| 163625 | 163625 | 226422 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3354 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007858.2602 | 2104522.84344 | 37.759062769454204 | -122.41587285146099 | (37.7590627694542, -122.415872851461) | |||
| 164307 | 164307 | 226454 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3273 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006579.319019999 | 2103170.3163099997 | 37.755277058897796 | -122.420200053701 | (37.7552770588978, -122.420200053701) | |||
| 166050 | 166050 | 37937 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1833 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40182 | 6012230.739080001 | 2105130.49486 | 37.7609760932842 | -122.400793343137 | (37.7609760932842, -122.400793343137) | |
| 167485 | 167485 | 229869 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 314 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003810.99153 | 2099557.89821 | 37.7452018299076 | -122.42951614338001 | (37.7452018299076, -122.42951614338) | |||
| 171875 | 171875 | 226791 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 43 Yukon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000246.5901 | 2104825.81574 | 37.759463795150104 | -122.442219288501 | (37.7594637951501, -122.442219288501) | |||
| 171915 | 171915 | 226448 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008365.48905 | 2102731.18987 | 37.75417179929121 | -122.413991861854 | (37.7541717992912, -122.413991861854) | |||
| 173875 | 173875 | 228528 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6009443.5955 | 2106700.35684 | 37.7651307237316 | -122.410543753197 | (37.7651307237316, -122.410543753197) | |||
| 176414 | 176414 | 248003 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 428 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009956.29023 | 2098510.13636 | 37.7426709335279 | -122.40819277067699 | (37.7426709335279, -122.408192770677) | |||
| 177492 | 177492 | 39550 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 815 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40976 | 6012466.9688800005 | 2104165.36194 | 37.7583392243866 | -122.399908546943 | (37.7583392243866, -122.399908546943) | |
| 177654 | 177654 | 226351 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3273 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006624.340340001 | 2103173.55504 | 37.7552884883831 | -122.420044586082 | (37.7552884883831, -122.420044586082) | |||
| 178091 | 178091 | 226347 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008486.7284 | 2101525.46437 | 37.7508679571961 | -122.413487316996 | (37.7508679571961, -122.413487316996) | |||
| 180535 | 180535 | 226382 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 58 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009331.97291 | 2097098.9463900002 | 37.738761135424795 | -122.410251874634 | (37.7387611354248, -122.410251874634) | |||
| 182886 | 182886 | 190722 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2200 Alameda St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010363.6035400005 | 2107883.96222 | 37.7684321691431 | -122.407445105823 | (37.7684321691431, -122.407445105823) | |||
| 183574 | 183574 | 226406 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1417 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008014.498269999 | 2099882.17848 | 37.7463293360461 | -122.415004038921 | (37.7463293360461, -122.415004038921) | |||
| 186181 | 186181 | 142077 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 36 ATALAYA TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998850.2457 | 2110939.7307 | 37.776171379653896 | -122.447488599832 | (37.7761713796539, -122.447488599832) | |||
| 188478 | 188478 | 226383 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007419.20582 | 2097997.75063 | 37.7411216480553 | -122.416929004483 | (37.7411216480553, -122.416929004483) |
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");