Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103 | 103 | 117428 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | ||||||||
| 12496 | 12496 | 24276 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 350X Winding Way | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000825.35085 | 2086800.6303 | 37.710003801206796 | -122.438925891137 | (37.7100038012068, -122.438925891137) | |||
| 143078 | 143078 | 121420 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1155x Prague St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6000780.0 | 2086820.0 | 37.7100544057225 | -122.439084019343 | (37.7100544057225, -122.439084019343) | ||||
| 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) | |||
| 11690 | 11690 | 1262 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | |||
| 4658 | 4658 | 176983 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 3ft | 5996974.67191 | 2087476.2225099998 | 37.711638981816 | -122.452283225586 | (37.711638981816, -122.452283225586) | |||
| 79594 | 79594 | 12917 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
| 98542 | 98542 | 12918 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
| 4683 | 4683 | 176984 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2923 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | Width 3ft | 5996996.89662 | 2087496.1826099998 | 37.7116950608382 | -122.452207850721 | (37.7116950608382, -122.452207850721) | |||
| 59360 | 59360 | 207117 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 41 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 5992170.67066 | 2088214.0686700002 | 37.7133885481037 | -122.46894065558399 | (37.7133885481037, -122.468940655584) | ||||
| 60662 | 60662 | 207115 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992168.43399 | 2088239.2563900002 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | ||||
| 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) | ||||
| 93184 | 93184 | 119281 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992077.0 | 2088275.0 | 37.713550438396396 | -122.469268843393 | (37.7135504383964, -122.469268843393) | ||||
| 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) | ||||
| 68946 | 68946 | 207113 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992170.39113 | 2088282.9530900002 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | ||||
| 31147 | 31147 | 207112 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992171.746719999 | 2088295.8735200001 | 37.7136132266511 | -122.46894288591899 | (37.7136132266511, -122.468942885919) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 71643 | 71643 | 207108 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 89 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.92954 | 2088415.8272900002 | 37.7139424279717 | -122.468961347182 | (37.7139424279717, -122.468961347182) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||
| 179459 | 179459 | 176985 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2571 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 5998574.332719999 | 2088565.20963 | 37.714720604140204 | -122.44683269999399 | (37.7147206041402, -122.446832699994) | |||
| 85479 | 85479 | 49654 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 81 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46507 | 6011171.19956943 | 2088331.01703059 | 37.7147891465513 | -122.403276034448 | (37.7147891465513, -122.403276034448) | ||
| 33610 | 33610 | 84133 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 23 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50705 | 6011012.12355 | 2088466.5124700002 | 37.7151523039101 | -122.403835398892 | (37.7151523039101, -122.403835398892) | |
| 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) | ||
| 137935 | 137935 | 176980 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 5999548.7624699995 | 2089280.82364 | 37.716741137071295 | -122.443516055124 | (37.7167411370713, -122.443516055124) | |||
| 175676 | 175676 | 176981 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2315 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 1ft | 5999571.4621 | 2089300.9269299998 | 37.7167976306892 | -122.44343903719299 | (37.7167976306892, -122.443439037193) | |||
| 140815 | 140815 | 16566 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999574.07501 | 2089304.05837 | 37.716806377922104 | -122.44343023048201 | (37.7168063779221, -122.443430230482) | |||
| 139249 | 139249 | 16565 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999593.35864 | 2089327.05238 | 37.716870613942795 | -122.443365227339 | (37.7168706139428, -122.443365227339) | |||
| 179206 | 179206 | 176986 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 745 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002864.08823 | 2089338.03726 | 37.7170867510327 | -122.43206070495899 | (37.7170867510327, -122.432060704959) | |||
| 175633 | 175633 | 176982 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2157 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5999995.5387 | 2089705.6098099998 | 37.717932973520206 | -122.442002247903 | (37.7179329735202, -122.442002247903) | |||
| 83364 | 83364 | 31185 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34883 | 5992147.8527206 | 2089880.99524616 | 37.7179642061069 | -122.469140766842 | (37.7179642061069, -122.469140766842) | ||
| 100529 | 100529 | 9277 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2161X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000049.092019999 | 2089751.6792400002 | 37.7180625213905 | -122.44182044273701 | (37.7180625213905, -122.441820442737) | |||
| 96489 | 96489 | 50428 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47081 | 5996479.47890892 | 2089951.8399168998 | 37.7184080697361 | -122.454173429085 | (37.7184080697361, -122.454173429085) | ||
| 98101 | 98101 | 47351 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 246 Monticello St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45277 | 5991716.56988019 | 2090163.16086716 | 37.7187140338834 | -122.470652049529 | (37.7187140338834, -122.470652049529) | ||
| 107992 | 107992 | 45360 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 458 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46747 | 5993277.37926203 | 2090218.01876098 | 37.718954793548605 | -122.46526098645 | (37.7189547935486, -122.46526098645) | ||
| 113922 | 113922 | 50423 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47076 | 5995600.08487961 | 2090390.5729411999 | 37.7195622602365 | -122.45724482931699 | (37.7195622602365, -122.457244829317) | ||
| 115064 | 115064 | 105256 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 162 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771043 | 6004383.3 | 2090213.9 | 37.7195776934466 | -122.42687185683998 | (37.7195776934466, -122.42687185684) | ||
| 98932 | 98932 | 52980 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 531 Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2006 12:00:00 AM | Permit Number 49067 | 5992711.66457877 | 2090721.03501475 | 37.720303313737105 | -122.467252978798 | (37.7203033137371, -122.467252978798) | ||
| 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) | ||
| 90495 | 90495 | 49718 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1195 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
| 110211 | 110211 | 31168 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 570 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34869 | 5993027.58275469 | 2090995.29108117 | 37.7210745862886 | -122.466180882741 | (37.7210745862886, -122.466180882741) | ||
| 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) | ||
| 24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
| 104926 | 104926 | 45431 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 3 | 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) | ||
| 105417 | 105417 | 45429 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 1 | 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) | ||
| 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) | ||
| 37103 | 37103 | 207104 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | |||
| 103787 | 103787 | 50490 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | ||
| 107841 | 107841 | 50489 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | ||
| 130081 | 130081 | 207105 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995373.148580001 | 2091601.55002 | 37.7228742787075 | -122.458116856135 | (37.7228742787075, -122.458116856135) | |||
| 152163 | 152163 | 207138 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 123 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991217.227519999 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | |||
| 117712 | 117712 | 26830 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3590X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1999 12:00:00 AM | 8 | 3x18 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 148752 | 148752 | 207137 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 103 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | |||
| 167635 | 167635 | 207136 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 100 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991240.31686 | 2092039.5475299999 | 37.723838576763896 | -122.47243496690399 | (37.7238385767639, -122.472434966904) | |||
| 63860 | 63860 | 207135 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 99 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991243.409109999 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | |||
| 148023 | 148023 | 207134 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 98 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991244.20773 | 2092057.90852 | 37.723889216687496 | -122.47242285485201 | (37.7238892166875, -122.472422854852) | |||
| 185196 | 185196 | 207133 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 90 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991231.48328 | 2092142.9158700001 | 37.724121889294295 | -122.472473035196 | (37.7241218892943, -122.472473035196) | |||
| 67484 | 67484 | 207132 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 87 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5991236.29103 | 2092157.26983 | 37.7241615799784 | -122.472457461649 | (37.7241615799784, -122.472457461649) | |||
| 88909 | 88909 | 45437 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44224 | 5993813.83621392 | 2092411.23769418 | 37.7250077648019 | -122.46356576496599 | (37.7250077648019, -122.463565764966) | ||
| 99225 | 99225 | 46761 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 343 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44859 | 6006106.65621717 | 2092210.20384218 | 37.725156404551896 | -122.421056498489 | (37.7251564045519, -122.421056498489) | |||
| 89703 | 89703 | 37850 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 211 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40141 | 6003943.02561838 | 2092441.0681196998 | 37.725668101811706 | -122.42855239521201 | (37.7256681018117, -122.428552395212) | ||
| 115167 | 115167 | 47225 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1643 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45170 | 6006193.94874397 | 2092417.83045771 | 37.7257314225765 | -122.42076946999399 | (37.7257314225765, -122.420769469994) | ||
| 171177 | 171177 | 207103 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995614.83933 | 2092751.51074 | 37.726045680348705 | -122.457364540844 | (37.7260456803487, -122.457364540844) | |||
| 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) | ||
| 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) | |||||
| 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) | |||
| 154113 | 154113 | 201278 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 28 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012862.05555 | 2092837.94578 | 37.7272585546286 | -122.397747632568 | (37.7272585546286, -122.397747632568) | |||
| 79154 | 79154 | 976 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1599 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X4 | 6001942.44101 | 2093088.0021099998 | 37.7273310167784 | -122.43551450655701 | (37.7273310167784, -122.435514506557) | |||
| 3544 | 3544 | 253465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3561 | 3561 | 253462 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3567 | 3567 | 253463 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 3585 | 3585 | 253464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 132080 | 132080 | 207131 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Junipero Serra Blvd | 23 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991341.745569999 | 2093676.61882 | 37.7283394372056 | -122.47220362351901 | (37.7283394372056, -122.472203623519) | |||
| 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) | |||
| 84780 | 84780 | 33391 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 129 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37510 | 5993545.21642202 | 2093774.31911417 | 37.7287349718633 | -122.464593277929 | (37.7287349718633, -122.464593277929) | ||
| 172053 | 172053 | 207129 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4986 19th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5990655.7482 | 2093855.39662 | 37.7287905920011 | -122.47458816511002 | (37.7287905920011, -122.47458816511) | |||
| 94127 | 94127 | 30765 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1593 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34646 | 6014616.43299999 | 2093667.83534348 | 37.729634805621096 | -122.391740711397 | (37.7296348056211, -122.391740711397) | ||
| 57032 | 57032 | 30756 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1547 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34637 | 6015015.9888 | 2093715.5638 | 37.729788030208795 | -122.390362726863 | (37.7297880302088, -122.390362726863) | |
| 79212 | 79212 | 33405 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 390 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40744 | 5992420.09105205 | 2094203.06284675 | 37.729847269288896 | -122.468514054616 | (37.7298472692889, -122.468514054616) | ||
| 97029 | 97029 | 33402 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 377 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37520 | 5992522.58969687 | 2094276.01733921 | 37.730053504422 | -122.468165013068 | (37.730053504422, -122.468165013068) | ||
| 138680 | 138680 | 36317 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51552 | 5996115.78800404 | 2094224.07875239 | 37.730117759471895 | -122.455739200241 | (37.7301177594719, -122.455739200241) | ||
| 163400 | 163400 | 207139 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996097.007130001 | 2094250.7795400003 | 37.7301899955731 | -122.45580605711599 | (37.7301899955731, -122.455806057116) | |||
| 172032 | 172032 | 176987 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 5ft | 6002815.8897 | 2094148.3870700002 | 37.7302921639516 | -122.43257070868799 | (37.7302921639516, -122.432570708688) | |||
| 9386 | 9386 | 926 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6002807.701830001 | 2094157.47604 | 37.7303166558715 | -122.432599664217 | (37.7303166558715, -122.432599664217) | |||
| 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) | |||
| 132288 | 132288 | 207130 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Junipero Serra Blvd | 22 | : 4 | Tree 1 | Private 1 | 24 | Width 0ft | 5991387.56325 | 2094477.49413 | 37.7305410918021 | -122.472103582925 | (37.7305410918021, -122.472103582925) | |||
| 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) | ||
| 144076 | 144076 | 889 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1136X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6003353.033430001 | 2094335.58352 | 37.7308366096666 | -122.43072708407401 | (37.7308366096666, -122.430727084074) | |||
| 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) | ||||
| 11146 | 11146 | 890 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1146 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003547.94647 | 2094400.70663 | 37.7310264639915 | -122.430057882374 | (37.7310264639915, -122.430057882374) | |||
| 11074 | 11074 | 882 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1138X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2016 12:00:00 AM | 28 | 3x3 | 6003576.60001 | 2094409.9739299999 | 37.7310535326811 | -122.429959483056 | (37.7310535326811, -122.429959483056) | ||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 40186 | 40186 | 218289 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 Woodacre Dr | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991265.0261699995 | 2095485.2551900002 | 37.7333010580894 | -122.472600653515 | (37.7333010580894, -122.472600653515) | ||||
| 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) |
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");