Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119851 | 119851 | 34725 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 114 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38379 | 5981286.97907127 | 2111325.91865707 | 37.776212402307 | -122.508272287748 | (37.776212402307, -122.508272287748) | ||
| 120269 | 120269 | 85386 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | ||||
| 121341 | 121341 | 46382 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2495 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.740172110361705 | -122.501371213543 | (37.7401721103617, -122.501371213543) | ||
| 122120 | 122120 | 36328 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1998 12:00:00 AM | Permit Number 39300 | 5995640.5044713 | 2092769.77027097 | 37.7260972907371 | -122.457277138944 | (37.7260972907371, -122.457277138944) | ||
| 122863 | 122863 | 50817 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2004 12:00:00 AM | Permit Number 47340 | 5995605.94135709 | 2094497.43585496 | 37.7308390591092 | -122.457521563876 | (37.7308390591092, -122.457521563876) | ||||
| 123140 | 123140 | 40483 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 165 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41562 | 5996732.70371963 | 2089259.1130924 | 37.716520521088796 | -122.45324815845699 | (37.7165205210888, -122.453248158457) | ||
| 123353 | 123353 | 44124 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 751 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2000 12:00:00 AM | Permit Number 43628 | 5981028.36208653 | 2110606.15983469 | 37.774220913121 | -122.509113438342 | (37.774220913121, -122.509113438342) | |||
| 123417 | 123417 | 247871 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009746.3542 | 2098404.30325 | 37.742368581453704 | -122.40891120669201 | (37.7423685814537, -122.408911206692) | ||||
| 123652 | 123652 | 45430 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.72272209583179 | -122.463136201451 | (37.7227220958318, -122.463136201451) | ||
| 126023 | 126023 | 40449 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 255 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47061 | 6008102.60669454 | 2097399.44811028 | 37.7395172589666 | -122.414523716357 | (37.7395172589666, -122.414523716357) | ||
| 126240 | 126240 | 31667 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2571 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1995 12:00:00 AM | Permit Number 35175 | 5981777.56166178 | 2097600.02639588 | 37.7385539042174 | -122.505557573977 | (37.7385539042174, -122.505557573977) | ||
| 127237 | 127237 | 50114 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1252 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46839 | 5992244.12505327 | 2098460.15223335 | 37.7415260004029 | -122.469432140867 | (37.7415260004029, -122.469432140867) | ||
| 127621 | 127621 | 54526 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4530 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777496 | 5981479.33824 | 2110998.9232400004 | 37.7753259029383 | -122.507582607669 | (37.7753259029383, -122.507582607669) | ||
| 127692 | 127692 | 63441 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 299 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1997 12:00:00 AM | Permit Number 24028 | 6008993.82853707 | 2096920.83270323 | 37.738253113659 | -122.411408443517 | (37.738253113659, -122.411408443517) | ||
| 128729 | 128729 | 105136 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175X ESMERALDA AVE | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | |||||
| 128740 | 128740 | 69291 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 830 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1994 12:00:00 AM | Permit Number 33363 | 5991479.92264349 | 2102518.55863113 | 37.752625141975706 | -122.472370253301 | (37.7526251419757, -122.472370253301) | ||
| 129429 | 129429 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 38 | 155 Winston Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990788.0 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | |||||
| 129606 | 129606 | 80358 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 336 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 3 | 6011201.39619 | 2088230.4496900002 | 37.714514695375705 | -122.403164591892 | (37.7145146953757, -122.403164591892) | ||
| 130276 | 130276 | 191375 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 6011300.325759999 | 2104333.131 | 37.7587347705187 | -122.40395514093399 | (37.7587347705187, -122.403955140934) | ||||
| 130366 | 130366 | 191373 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6011285.49599 | 2104337.84522 | 37.758746886173896 | -122.40400676112 | (37.7587468861739, -122.40400676112) | ||||
| 131762 | 131762 | 191368 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 60 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6012502.16132 | 2102909.3105599997 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | ||||
| 132346 | 132346 | 191376 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011285.447430001 | 2104312.53247 | 37.758677380280105 | -122.40400514772699 | (37.7586773802801, -122.404005147727) | ||||
| 132469 | 132469 | 129472 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012528.94679 | 2120206.6635 | 37.8023883923599 | -122.400821180758 | (37.8023883923599, -122.400821180758) | ||||
| 132758 | 132758 | 191401 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010711.19096 | 2107913.74245 | 37.768533387842396 | -122.406244924566 | (37.7685333878424, -122.406244924566) | ||||
| 133901 | 133901 | 51414 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1531 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 0 | Permit Number 47738 | 5988357.88494646 | 2104888.81015522 | 37.7589520258954 | -122.48334041038 | (37.7589520258954, -122.48334041038) | |
| 136052 | 136052 | 218293 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5991192.67429 | 2095369.91493 | 37.7329801745819 | -122.47284238406799 | (37.7329801745819, -122.472842384068) | ||||
| 136701 | 136701 | 207107 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992169.5585900005 | 2088419.4087099999 | 37.7139522980308 | -122.46895943344299 | (37.7139522980308, -122.468959433443) | ||||
| 136797 | 136797 | 191395 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6010771.29847 | 2107917.19939 | 37.7685462418407 | -122.406037260315 | (37.7685462418407, -122.406037260315) | ||||
| 137835 | 137835 | 129468 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1151 Lombard St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6006718.96895 | 2120094.36111 | 37.8017542606157 | -122.420918621021 | (37.8017542606157, -122.420918621021) | ||||
| 137937 | 137937 | 129474 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6012536.27851 | 2120200.91706 | 37.8023730229664 | -122.400795405292 | (37.8023730229664, -122.400795405292) | ||||
| 139074 | 139074 | 63714 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1997 12:00:00 AM | Permit Number 24378 | 6007857.54148412 | 2100263.37846132 | 37.7473672046192 | -122.41557376317499 | (37.7473672046192, -122.415573763175) | ||
| 140587 | 140587 | 31580 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1841 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35119 | 5989049.89925793 | 2102807.07383274 | 37.75327638601021 | -122.48079472188999 | (37.7532763860102, -122.48079472189) | ||
| 141290 | 141290 | 48774 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 629 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47773 | 6007825.24973386 | 2095718.75627166 | 37.7348868619711 | -122.415363748684 | (37.7348868619711, -122.415363748684) | ||
| 143225 | 143225 | 47963 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 558 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45693 | 5996827.75466141 | 2095403.22069376 | 37.73339623393571 | -122.453362951949 | (37.7333962339357, -122.453362951949) | ||
| 143336 | 143336 | 58925 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3925 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | Permit Number 18201 | 5982715.08927534 | 2104886.86517056 | 37.7586166666309 | -122.502855377053 | (37.7586166666309, -122.502855377053) | ||
| 143583 | 143583 | 34718 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 626 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38373 | 5981358.16274912 | 2111480.6327423 | 37.7766413961782 | -122.508037533581 | (37.7766413961782, -122.508037533581) | ||
| 144258 | 144258 | 35419 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 221 Crestmont Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.45969708953301 | (37.7562443131302, -122.459697089533) | |||
| 145098 | 145098 | 68368 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 194 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | Permit Number 32189 | 6002712.41508002 | 2094283.54436078 | 37.730657406687 | -122.432938086411 | (37.730657406687, -122.432938086411) | ||
| 145765 | 145765 | 68315 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3820 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32128 | 5981623.22584135 | 2100818.01716678 | 37.7473805290726 | -122.506329747472 | (37.7473805290726, -122.506329747472) | ||
| 146129 | 146129 | 49012 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 361 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | Permit Number 46198 | 6003561.60300767 | 2099494.42119752 | 37.7450134133041 | -122.430373957908 | (37.7450134133041, -122.430373957908) | |||
| 147602 | 147602 | 129471 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6012526.59847 | 2120207.76193 | 37.8023912773999 | -122.40082938436701 | (37.8023912773999, -122.400829384367) | ||||
| 148496 | 148496 | 227674 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 83 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005065.1015800005 | 2097012.05309 | 37.7382824451638 | -122.42499854026899 | (37.7382824451638, -122.424998540269) | ||||
| 150156 | 150156 | 191402 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010700.42675 | 2107913.45144 | 37.7685319866755 | -122.406282136733 | (37.7685319866755, -122.406282136733) | ||||
| 150938 | 150938 | 227672 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.42489737911801 | (37.7383979127325, -122.424897379118) | ||||
| 150971 | 150971 | 52086 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 550 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2005 12:00:00 AM | 7 | Permit Number 48283 | 5982264.87127 | 2112012.82882 | 37.7781560348973 | -122.50494046388201 | (37.7781560348973, -122.504940463882) | |
| 151607 | 151607 | 191377 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6011285.82751 | 2104250.98235 | 37.75850839857429 | -122.40399950177601 | (37.7585083985743, -122.403999501776) | ||||
| 152532 | 152532 | 129478 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012509.68294 | 2120230.66756 | 37.80245322719529 | -122.400889531035 | (37.8024532271953, -122.400889531035) | ||||
| 153486 | 153486 | 207109 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992170.77084 | 2088338.0326 | 37.713728928924105 | -122.46894932506599 | (37.7137289289241, -122.468949325066) | ||||
| 154417 | 154417 | 191378 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011285.84337 | 2104240.2990099997 | 37.7584790653842 | -122.40399869511002 | (37.7584790653842, -122.40399869511) | ||||
| 154704 | 154704 | 191400 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010721.657430001 | 2107914.21049 | 37.76853525842721 | -122.406208754734 | (37.7685352584272, -122.406208754734) | ||||
| 154916 | 154916 | 37082 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1268 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2002 12:00:00 AM | 6 | Permit Number 44549 | 5982146.28824129 | 2106471.58463776 | 37.762934408685396 | -122.504939947841 | (37.7629344086854, -122.504939947841) | |
| 155355 | 155355 | 32594 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1379 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 1 | Permit Number 37062 | 5985531.05347187 | 2105840.85496484 | 37.76140115330671 | -122.49318691517 | (37.7614011533067, -122.49318691517) | |
| 158119 | 158119 | 46395 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2091 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 9 | Permit Number 44627 | 5981974.76389525 | 2100876.77542895 | 37.74756255280229 | -122.505118527994 | (37.7475625528023, -122.505118527994) | |
| 159182 | 159182 | 78557 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2234 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2016 12:00:00 AM | 3 | Permit Number 771299 | 5981748.2661 | 2099861.5988 | 37.7447618317919 | -122.505826480334 | (37.7447618317919, -122.505826480334) | |
| 159748 | 159748 | 191397 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6010751.13717 | 2107916.6697400003 | 37.768543659889005 | -122.406106959582 | (37.768543659889, -122.406106959582) | ||||
| 159861 | 159861 | 227676 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 427 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | ||||
| 160532 | 160532 | 38367 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4245 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 5 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
| 162496 | 162496 | 207110 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | ||||
| 162968 | 162968 | 191403 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010692.2016199995 | 2107913.0668 | 37.7685304704432 | -122.40631055979601 | (37.7685304704432, -122.406310559796) | ||||
| 164753 | 164753 | 207116 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992178.8337 | 2088240.4151599999 | 37.7134613608383 | -122.46891435762801 | (37.7134613608383, -122.468914357628) | ||||
| 165701 | 165701 | 42597 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1950 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42667 | 6005420.67346 | 2116544.61332 | 37.7919342879744 | -122.42515859980499 | (37.7919342879744, -122.425158599805) | ||
| 166033 | 166033 | 129485 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012301.33061 | 2120559.21941 | 37.803343726885 | -122.40163364357099 | (37.803343726885, -122.401633643571) | ||||
| 167106 | 167106 | 47850 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1342 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 7 | Permit Number 45609 | 5983405.04544412 | 2106002.56953842 | 37.7617206013965 | -122.50055173019501 | (37.7617206013965, -122.500551730195) | |
| 168815 | 168815 | 191391 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011306.2123 | 2104378.54497 | 37.7588597960547 | -122.40393797827299 | (37.7588597960547, -122.403937978273) | ||||
| 169634 | 169634 | 191405 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6016216.75475 | 2100305.37684 | 37.7479488549636 | -122.386670851103 | (37.7479488549636, -122.386670851103) | ||||
| 170082 | 170082 | 191380 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6011289.9844 | 2104226.0484599997 | 37.7584401679041 | -122.403983370659 | (37.7584401679041, -122.403983370659) | ||||
| 171720 | 171720 | 207111 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | ||||
| 171814 | 171814 | 129480 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012320.77236 | 2120522.45554 | 37.8032438670795 | -122.401563778859 | (37.8032438670795, -122.401563778859) | ||||
| 171831 | 171831 | 191396 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010761.0499599995 | 2107917.30957 | 37.7685459711594 | -122.40607271698799 | (37.7685459711594, -122.406072716988) | ||||
| 171868 | 171868 | 218294 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5991183.55146 | 2095353.09261 | 37.7329334566034 | -122.472872697534 | (37.7329334566034, -122.472872697534) | ||||
| 172620 | 172620 | 191407 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6016225.71134 | 2100306.15132 | 37.747951477381 | -122.386639933312 | (37.747951477381, -122.386639933312) | ||||
| 173361 | 173361 | 46399 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2110 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 5 | Permit Number 44629 | 5981721.80383178 | 2100709.75793181 | 37.7470890826019 | -122.505980852245 | (37.7470890826019, -122.505980852245) | |
| 174070 | 174070 | 129473 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6012532.2991 | 2120205.0438900003 | 37.8023841322847 | -122.400809466192 | (37.8023841322847, -122.400809466192) | ||||
| 175448 | 175448 | 191392 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6011311.05886 | 2104374.20224 | 37.7588481426559 | -122.403920910926 | (37.7588481426559, -122.403920910926) | ||||
| 175563 | 175563 | 129481 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012317.54236 | 2120532.7765200003 | 37.8032720257522 | -122.401575682271 | (37.8032720257522, -122.401575682271) | ||||
| 176379 | 176379 | 129482 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6012315.37501 | 2120537.75286 | 37.803285568636 | -122.401583532467 | (37.803285568636, -122.401583532467) | ||||
| 177899 | 177899 | 191399 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010727.66479 | 2107914.7241700003 | 37.7685370048986 | -122.406188011877 | (37.7685370048986, -122.406188011877) | ||||
| 178085 | 178085 | 227673 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1000 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005078.09924 | 2097049.5351099998 | 37.738386096529204 | -122.424956266738 | (37.7383860965292, -122.424956266738) | ||||
| 178121 | 178121 | 47450 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5049 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45359 | 5982925.588409999 | 2111676.1494 | 37.7772704608477 | -122.502629914355 | (37.7772704608477, -122.502629914355) | |
| 178473 | 178473 | 122182 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5991497.785680001 | 2114857.01928 | 37.7865042639669 | -122.473208256238 | (37.7865042639669, -122.473208256238) | ||||
| 182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
| 185104 | 185104 | 191404 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Tulare St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6016173.59275 | 2100299.3088 | 37.7479298037296 | -122.3868196817 | (37.7479298037296, -122.3868196817) | ||||
| 186287 | 186287 | 191379 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 800 Vermont St | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011295.7098900005 | 2104243.81406 | 37.758489268176 | -122.403964819445 | (37.758489268176, -122.403964819445) | ||||
| 186348 | 186348 | 129483 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012307.75016 | 2120551.4086599997 | 37.8033226386787 | -122.401610879045 | (37.8033226386787, -122.401610879045) | ||||
| 187814 | 187814 | 102790 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3445 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Permit Number 42050 | 5983633.0 | 2103554.0 | 37.7550108962308 | -122.499582370415 | (37.7550108962308, -122.499582370415) | |||
| 188045 | 188045 | 191393 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 6011318.33835 | 2104379.19174 | 37.758862249405 | -122.40389608603901 | (37.758862249405, -122.403896086039) | ||||
| 188108 | 188108 | 247870 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6009721.06953 | 2098395.0417 | 37.74234173489771 | -122.40899798048099 | (37.7423417348977, -122.408997980481) | ||||
| 188129 | 188129 | 207114 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992175.21623 | 2088282.1627599997 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | ||||
| 188419 | 188419 | 129470 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 45 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6008463.14234 | 2119145.61201 | 37.799247391416394 | -122.414815771241 | (37.7992473914164, -122.414815771241) | ||||
| 188897 | 188897 | 84120 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 336 Campbell Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2006 12:00:00 AM | 6 | 6011186.92342 | 2088226.0732 | 37.7145018701492 | -122.403214308206 | (37.7145018701492, -122.403214308206) | ||
| 23148 | 23148 | 973 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1599 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 0 | 6001917.27172 | 2093023.46154 | 37.72715237348 | -122.435596901293 | (37.72715237348, -122.435596901293) | |||
| 102052 | 102052 | 23670 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 317 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006937.941544901 | 2098264.8464559 | 37.7418279505329 | -122.41861198258002 | (37.7418279505329, -122.41861198258) | |||
| 8966 | 8966 | 18882 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2323 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6003557.0695 | 2115907.1327400003 | 37.7900784748972 | -122.43156114415001 | (37.7900784748972, -122.43156114415) | |||
| 18602 | 18602 | 234 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2994 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 2X3 | 5990616.60068 | 2095284.10448 | 37.7327111945568 | -122.474827739114 | (37.7327111945568, -122.474827739114) | |||
| 108468 | 108468 | 1383 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2550X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X2 | 6002248.65699 | 2096984.18535 | 37.7380464314256 | -122.434734413124 | (37.7380464314256, -122.434734413124) | |||
| 12047 | 12047 | 909 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1217 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003163.68633 | 2094174.8948400002 | 37.7303846655151 | -122.431370220756 | (37.7303846655151, -122.431370220756) | |||
| 17570 | 17570 | 1213 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3411 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5993897.04108 | 2087339.7447 | 37.711087454604204 | -122.46291036762199 | (37.7110874546042, -122.462910367622) | |||
| 21000 | 21000 | 29586 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500X Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 3X3 | 5991342.7865 | 2093687.81781 | 37.7283702470744 | -122.47220084100901 | (37.7283702470744, -122.472200841009) | |||
| 21489 | 21489 | 29601 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991172.090009999 | 2091066.888 | 37.7211639453471 | -122.472599932234 | (37.7211639453471, -122.472599932234) | ||
| 21749 | 21749 | 29627 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900X Junipero Serra Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 12 | 3X3 | 5991152.87782 | 2090760.03066 | 37.7203202787275 | -122.472643981031 | (37.7203202787275, -122.472643981031) |
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");