trees
39,840 rows where qLegalStatus_id = 7 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▲ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30 | 254372 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778036 | 6010859.22958 | 2088882.34048 | 37.7162855403434 | -122.404393121162 | (37.7162855403434, -122.404393121162) | 9 | 7 | 8 | 309 | 39 |
| 171 | 50655 | Permitted Site 7 | Tree(s) :: 17 | 430 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47238 | 6008643.36799877 | 2088325.11427356 | 37.7146314352433 | -122.412012884014 | (37.7146314352433, -122.412012884014) | 9 | 7 | 8 | 309 | 18 | ||||
| 226 | 56655 | Permitted Site 7 | Tree(s) :: 17 | 491 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993749.22353597 | 2090472.28724098 | 37.7196801529508 | -122.463648462413 | (37.7196801529508, -122.463648462413) | 9 | 8 | 6 | 64 | 24 | |||||
| 294 | 53493 | Permitted Site 7 | Tree(s) :: 17 | 262 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6403 | 5992228.28376051 | 2089608.56362168 | 37.717220822263 | -122.468842940668 | (37.717220822263, -122.468842940668) | 9 | 8 | 6 | 64 | 24 | |||
| 435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
| 499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
| 528 | 57932 | Permitted Site 7 | Tree(s) :: 17 | 583 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | Permit Number 16891 | 5999047.47505332 | 2086793.7936429 | 37.7098837148731 | -122.445070058439 | (37.7098837148731, -122.445070058439) | 9 | 7 | 6 | 28861 | 5 | |||
| 665 | 203589 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 50 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1993 12:00:00 AM | 24 | Width 3ft | Permit Number 32829 | 5999730.96004 | 2093799.89189 | 37.7291598500324 | -122.443210675031 | (37.7291598500324, -122.443210675031) | 9 | 7 | 4 | 63 | 40 | |
| 733 | 218511 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 318 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43359 | 5996829.51445 | 2089654.64111 | 37.7176120972009 | -122.45294206803 | (37.7176120972009, -122.45294206803) | 9 | 8 | 6 | 28861 | 24 | |
| 937 | 95737 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 445 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | 9 | 7 | 6 | 28861 | 5 | |
| 997 | 42493 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.95301 | 37.7264342507672 | -122.452230525303 | (37.7264342507672, -122.452230525303) | 9 | 7 | 4 | 28861 | 40 | ||
| 1052 | 65988 | Permitted Site 7 | Tree(s) :: 17 | 121 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1990 12:00:00 AM | Permit Number 29018 | 5995709.58889373 | 2096251.06183698 | 37.7356600432467 | -122.457290053496 | (37.7356600432467, -122.457290053496) | 9 | 7 | 4 | 59 | 40 | |||
| 1063 | 32734 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.7175397705127 | -122.458983271916 | (37.7175397705127, -122.458983271916) | 9 | 8 | 6 | 28861 | 24 | ||
| 1214 | 44389 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.436169094311 | (37.7132458927569, -122.436169094311) | 9 | 7 | 6 | 28861 | 5 | ||
| 1247 | 214916 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 13 | Width 2ft | Permit Number 32246 | 5993222.12997 | 2093186.27538 | 37.7271017173463 | -122.465667493867 | (37.7271017173463, -122.465667493867) | 9 | 8 | 4 | 59 | 40 | |
| 1314 | 67685 | Permitted Site 7 | Tree(s) :: 17 | 766 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | Permit Number 31289 | 5997024.37469935 | 2095029.17182905 | 37.7323804536882 | -122.452656198743 | (37.7323804536882, -122.452656198743) | 9 | 7 | 4 | 59 | 40 | |||
| 1331 | 25415 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
| 1347 | 109892 | Permitted Site 7 | Tree(s) :: 17 | 205 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2015 12:00:00 AM | 3 | 3x6 | 5995308.1 | 2091295.6 | 37.7220304751495 | -122.458319579925 | (37.7220304751495, -122.458319579925) | 9 | 8 | 4 | 28861 | 24 | ||
| 1357 | 54090 | Permitted Site 7 | Tree(s) :: 17 | 115 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9817 | 5991911.06498332 | 2095358.19732765 | 37.7329895631391 | -122.47035789011 | (37.7329895631391, -122.47035789011) | 9 | 8 | 4 | 59 | 40 | |||
| 1370 | 49770 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 333 Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | 9 | 7 | 8 | 309 | 39 | ||
| 1430 | 67640 | Permitted Site 7 | Tree(s) :: 17 | 66 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1992 12:00:00 AM | Permit Number 31239 | 5999465.40351772 | 2088851.00886819 | 37.7155562089288 | -122.443773323232 | (37.7155562089288, -122.443773323232) | 9 | 7 | 6 | 28861 | 25 | |||
| 1472 | 2091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 2X2 | 6001433.65825 | 2095553.49813 | 37.7340717929056 | -122.437449841319 | (37.7340717929056, -122.437449841319) | 9 | 7 | 5 | 63 | 40 | ||
| 1539 | 39700 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 360 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41085 | 5995865.64470652 | 2094899.35552532 | 37.7319575477065 | -122.456652788497 | (37.7319575477065, -122.456652788497) | 9 | 7 | 4 | 59 | 40 | ||
| 1559 | 68149 | Permitted Site 7 | Tree(s) :: 17 | 306 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | Permit Number 31907 | 5992597.64738181 | 2094843.40601485 | 37.731615747375 | -122.467946785243 | (37.731615747375, -122.467946785243) | 9 | 8 | 4 | 59 | 40 | |||
| 1585 | 34112 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1398 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
| 1663 | 27797 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
| 1702 | 46741 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 21 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44848 | 5993934.28224784 | 2089153.42556477 | 37.7160695363268 | -122.462913152344 | (37.7160695363268, -122.462913152344) | 9 | 8 | 6 | 64 | 24 | ||
| 1812 | 52955 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 516 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48942 | 5993282.16384919 | 2090617.22186434 | 37.7200511847077 | -122.465273429637 | (37.7200511847077, -122.465273429637) | 9 | 8 | 6 | 64 | 24 | ||
| 1822 | 51694 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47971 | 5995825.9822194 | 2092036.11859211 | 37.7240935095077 | -122.456582925823 | (37.7240935095077, -122.456582925823) | 9 | 8 | 4 | 28861 | 40 | |||
| 1853 | 214288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 38 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/23/2000 12:00:00 AM | 13 | Width 3ft | Permit Number 42619 | 5999806.95305 | 2093809.09712 | 37.7291894584065 | -122.442948622496 | (37.7291894584065, -122.442948622496) | 9 | 7 | 4 | 63 | 40 | |
| 1981 | 40499 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 44 Aptos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1999 12:00:00 AM | 3x3 | Permit Number 50329 | 5993102.74682774 | 2094714.88282209 | 37.7312920097199 | -122.466191234844 | (37.7312920097199, -122.466191234844) | 9 | 8 | 4 | 59 | 40 | ||
| 1988 | 53775 | Permitted Site 7 | Tree(s) :: 17 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1972 12:00:00 AM | Permit Number 9461 | 5992772.54452217 | 2094326.15826887 | 37.7302056116577 | -122.467304539962 | (37.7302056116577, -122.467304539962) | 9 | 8 | 4 | 59 | 40 | |||
| 2210 | 53264 | Permitted Site 7 | Tree(s) :: 17 | 523 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | Permit Number 6154 | 5993474.77624345 | 2089341.33970508 | 37.7165590253308 | -122.464515046881 | (37.7165590253308, -122.464515046881) | 9 | 8 | 6 | 64 | 24 | |||
| 2263 | 31189 | Permitted Site 7 | :: 45 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 2328 | 57118 | Permitted Site 7 | Tree(s) :: 17 | 567 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | Permit Number 14388 | 6001433.85993869 | 2090479.06392424 | 37.7201385647203 | -122.437085957535 | (37.7201385647203, -122.437085957535) | 9 | 7 | 6 | 28861 | 5 | |||
| 2478 | 110785 | Permitted Site 7 | Tree(s) :: 17 | 2 Edna St | 2 | Front Yard : Yard | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 5998788.4 | 2092979.9 | 37.7268545527586 | -122.446410203741 | (37.7268545527586, -122.446410203741) | 9 | 7 | 4 | 28861 | 40 | |||
| 2544 | 49162 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
| 2586 | 66958 | Permitted Site 7 | Tree(s) :: 17 | 283 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1992 12:00:00 AM | Permit Number 30294 | 5994190.17633556 | 2087741.03649596 | 37.7122061872577 | -122.461926308953 | (37.7122061872577, -122.461926308953) | 9 | 8 | 6 | 28861 | 24 | |||
| 2611 | 52930 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 36 Havelock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48915 | 5999971.05699015 | 2092944.44477133 | 37.7268246780096 | -122.442319255194 | (37.7268246780096, -122.442319255194) | 9 | 7 | 6 | 28861 | 25 | ||
| 2708 | 50426 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2014 12:00:00 AM | 3 | Permit Number 773627 | 5997303.25557645 | 2090612.9654569 | 37.7202705700793 | -122.45137364778 | (37.7202705700793, -122.45137364778) | 9 | 8 | 6 | 28861 | 24 | |
| 2745 | 260577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
| 2756 | 39703 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.4472036828 | (37.7318275120035, -122.4472036828) | 9 | 7 | 4 | 59 | 40 | ||
| 2834 | 43194 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52486 | 6007869.54574833 | 2094250.5524237 | 37.7308579825995 | -122.415106710419 | (37.7308579825995, -122.415106710419) | 9 | 3 | 7 | 309 | 28 | ||
| 2838 | 65166 | Permitted Site 7 | Tree(s) :: 17 | 439 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2006 12:00:00 AM | Permit Number 48848 | 5999406.26967916 | 2094532.50818101 | 37.7311529235029 | -122.444385781456 | (37.7311529235029, -122.444385781456) | 9 | 7 | 4 | 59 | 40 | |||
| 2965 | 47232 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 300 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45174 | 6006289.6051714 | 2092459.95918697 | 37.7258524899582 | -122.420441781421 | (37.7258524899582, -122.420441781421) | 9 | 7 | 7 | 309 | 5 | ||
| 3012 | 15898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5647X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5998341.15292 | 2087120.08013 | 37.7107392839911 | -122.447534700696 | (37.7107392839911, -122.447534700696) | 9 | 7 | 6 | 28861 | 5 | ||
| 3013 | 109184 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 3097 | 52514 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.2402014 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | 9 | 7 | 6 | 28861 | 25 | ||
| 3112 | 44154 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 3133 | 53387 | Permitted Site 7 | Tree(s) :: 17 | 272 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994766.71798377 | 2090393.02640531 | 37.7195210985022 | -122.460125633496 | (37.7195210985022, -122.460125633496) | 9 | 8 | 6 | 28861 | 24 | |||||
| 3151 | 47936 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 235 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2002 12:00:00 AM | Permit Number 45671 | 5996315.56567541 | 2094902.75702129 | 37.7319927097789 | -122.455097570602 | (37.7319927097789, -122.455097570602) | 9 | 7 | 4 | 59 | 40 | ||
| 3228 | 41394 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.7112689138709 | -122.413443728962 | (37.7112689138709, -122.413443728962) | 9 | 7 | 8 | 309 | 39 | ||
| 3264 | 1125 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2466 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5998958.39293 | 2088881.75103 | 37.7156116878713 | -122.445527983003 | (37.7156116878713, -122.445527983003) | 9 | 7 | 6 | 28861 | 25 | |||
| 3311 | 34090 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37972 | 5995596.86014406 | 2093332.4924806 | 37.7276398840061 | -122.457468708243 | (37.7276398840061, -122.457468708243) | 9 | 7 | 4 | 28861 | 40 | ||
| 3325 | 11719 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
| 3433 | 40543 | Permitted Site 7 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 24194127 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41590 | 5992157.46217744 | 2095224.52974994 | 37.7326367885511 | -122.469496311654 | (37.7326367885511, -122.469496311654) | 9 | 8 | 4 | 59 | 40 | ||
| 3472 | 95121 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 68 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54048 | 6002661 | 2094358 | 37.7308589285589 | -122.433121153797 | (37.7308589285589, -122.433121153797) | 9 | 7 | 5 | 28861 | 25 | |
| 3515 | 40789 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 27 Urbano Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41740 | 5993852.22414759 | 2092279.20351858 | 37.7246474428237 | -122.463423485902 | (37.7246474428237, -122.463423485902) | 9 | 8 | 4 | 59 | 40 | ||
| 3532 | 82116 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 471 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49834 | 5995281.66389903 | 2095825.83537331 | 37.7344678883998 | -122.458738770232 | (37.7344678883998, -122.458738770232) | 9 | 7 | 4 | 59 | 40 | ||
| 3535 | 57947 | Permitted Site 7 | Tree(s) :: 17 | 12 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | Permit Number 16906 | 5999407.80723315 | 2086738.68680627 | 37.7097529637216 | -122.443820730773 | (37.7097529637216, -122.443820730773) | 9 | 7 | 6 | 28861 | 5 | |||
| 3703 | 47931 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 421 Congo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2002 12:00:00 AM | Permit Number 45666 | 6000072.19761127 | 2095017.15680877 | 37.7325216284483 | -122.442118334295 | (37.7325216284483, -122.442118334295) | 9 | 7 | 4 | 63 | 40 | ||
| 3708 | 42448 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 378 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42591 | 5998927.04125576 | 2095270.07473747 | 37.7331507529913 | -122.44609558436 | (37.7331507529913, -122.44609558436) | 9 | 7 | 4 | 59 | 40 | ||
| 3734 | 67984 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 35 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31708 | 5996379.31437828 | 2088033.23094013 | 37.713134273022 | -122.454381139129 | (37.713134273022, -122.454381139129) | 9 | 8 | 6 | 28861 | 24 | ||
| 3900 | 36339 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | ||
| 3922 | 53770 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 316 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/1996 12:00:00 AM | Permit Number 9456 | 5992852.04223281 | 2094739.01017834 | 37.7313437896565 | -122.46705971241 | (37.7313437896565, -122.46705971241) | 9 | 8 | 4 | 59 | 40 | ||
| 3958 | 29691 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 235X Hahn St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2006 12:00:00 AM | 3 | 3X3 | 6007408.6946 | 2087074.91278 | 37.7111292927788 | -122.416191939068 | (37.7111292927788, -122.416191939068) | 9 | 7 | 8 | 309 | 39 | ||
| 3975 | 56564 | Permitted Site 7 | Tree(s) :: 17 | 250 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992102.77849477 | 2095182.39763056 | 37.7325179438205 | -122.469682298657 | (37.7325179438205, -122.469682298657) | 9 | 8 | 4 | 59 | 40 | |||||
| 4064 | 214029 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | Width 1ft | Permit Number 785373 | 6000729.59206 | 2094530.61609 | 37.7312231430208 | -122.439810699013 | (37.7312231430208, -122.439810699013) | 9 | 7 | 4 | 63 | 40 | |
| 4172 | 44480 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 295 Harvard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43790 | 6006326.11018523 | 2092518.45956429 | 37.7260151764118 | -122.420319736223 | (37.7260151764118, -122.420319736223) | 9 | 7 | 7 | 309 | 5 | ||
| 4196 | 45221 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 801-899X Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/2001 12:00:00 AM | Permit Number 44054 | 6008510.16746889 | 2093128.34888408 | 37.7278126322854 | -122.412812661196 | (37.7278126322854, -122.412812661196) | 9 | 3 | 7 | 309 | 28 | ||
| 4251 | 42457 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 571 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 9 | 3x3 | Permit Number 42600 | 5997658.92569742 | 2095237.95802388 | 37.7329900693173 | -122.450477464919 | (37.7329900693173, -122.450477464919) | 9 | 7 | 4 | 59 | 40 |
| 4343 | 65663 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.446492607567 | (37.7347645844735, -122.446492607567) | 9 | 7 | 4 | 59 | 40 | ||
| 4377 | 88323 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417 | 2092629 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | 9 | 7 | 6 | 28861 | 5 | |||
| 4426 | 42126 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42422 | 5999645.50083885 | 2093804.90397788 | 37.7291687386678 | -122.44350647351 | (37.7291687386678, -122.44350647351) | 9 | 7 | 4 | 63 | 40 | ||
| 4546 | 84843 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1201 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2007 12:00:00 AM | Permit No. 49246 | 6008311.7 | 2086994.1 | 37.7109581313437 | -122.413065210327 | (37.7109581313437, -122.413065210327) | 9 | 7 | 8 | 309 | 39 | |||
| 4627 | 36424 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Montecito Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | 9 | 7 | 4 | 28861 | 40 | |||
| 4683 | 62258 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.7293849331116 | -122.437715130621 | (37.7293849331116, -122.437715130621) | 9 | 7 | 6 | 28861 | 25 | ||
| 4762 | 84963 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 227 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51615 | 5999235.1 | 2094032 | 37.7297688774613 | -122.444941576876 | (37.7297688774613, -122.444941576876) | 9 | 7 | 4 | 28861 | 40 | ||
| 4858 | 39677 | Permitted Site 7 | Quercus keloggii :: California Black Oak 282 | 446 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41063 | 5993017.43068395 | 2090147.12878073 | 37.7187451525026 | -122.466154370624 | (37.7187451525026, -122.466154370624) | 9 | 8 | 6 | 64 | 24 | ||
| 4888 | 49048 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 18 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46220 | 5996635.99358217 | 2093756.55442749 | 37.7288638899456 | -122.453907042921 | (37.7288638899456, -122.453907042921) | 9 | 7 | 4 | 28861 | 40 | ||
| 4958 | 106604 | Permitted Site 7 | Tree(s) :: 17 | 499X Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2014 12:00:00 AM | Permit Number 772978 | 6002049.33574 | 2091000.17806 | 37.7216043931857 | -122.434995717595 | (37.7216043931857, -122.434995717595) | 9 | 7 | 6 | 28861 | 5 | |||
| 4973 | 33381 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 2275 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1996 12:00:00 AM | Permit Number 37503 | 5992540.8715622 | 2093773.0831922 | 37.7286736277184 | -122.468065241412 | (37.7286736277184, -122.468065241412) | 9 | 8 | 4 | 59 | 40 | |||
| 5000 | 42437 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42584 | 5996829.49530885 | 2093648.57745681 | 37.7285785035344 | -122.453230305718 | (37.7285785035344, -122.453230305718) | 9 | 7 | 4 | 28861 | 40 | ||
| 5223 | 62183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1957 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1985 12:00:00 AM | Permit Number 22301 | 5999981.22618008 | 2092577.81268407 | 37.7258185704465 | -122.44225779266 | (37.7258185704465, -122.44225779266) | 9 | 7 | 6 | 28861 | 25 | ||
| 5229 | 44454 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 95 Winding Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43779 | 6002576.22413505 | 2086867.96270094 | 37.710288143695 | -122.432879348949 | (37.710288143695, -122.432879348949) | 9 | 7 | 6 | 28861 | 5 | ||
| 5446 | 36410 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 591 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39333 | 5995339.97501455 | 2093247.68753987 | 37.7273922712597 | -122.458350621736 | (37.7273922712597, -122.458350621736) | 9 | 7 | 4 | 28861 | 40 | ||
| 5565 | 91066 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 20 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2008 12:00:00 AM | 3x3 | Permit Number 51973 | 5992794.6 | 2093140.2 | 37.7269505362801 | -122.467142098378 | (37.7269505362801, -122.467142098378) | 9 | 8 | 4 | 59 | 40 | ||
| 5635 | 907 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1206 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x6 | 6003162.80838 | 2094269.92054 | 37.7306455348647 | -122.431380036745 | (37.7306455348647, -122.431380036745) | 9 | 7 | 5 | 28861 | 25 | |||
| 5687 | 66315 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29430 | 6001458.61740114 | 2094962.10093841 | 37.7324493716412 | -122.43732121741 | (37.7324493716412, -122.43732121741) | 9 | 7 | 5 | 63 | 40 | ||
| 5910 | 24288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 340 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6001280.10777 | 2086581.35963 | 37.7094275956588 | -122.437338476184 | (37.7094275956588, -122.437338476184) | 9 | 7 | 6 | 28861 | 5 | |||
| 5974 | 62490 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 52 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1986 12:00:00 AM | Permit Number 22661 | 6000842.2540014 | 2092843.5185791 | 37.7265971735996 | -122.439300325407 | (37.7265971735996, -122.439300325407) | 9 | 7 | 6 | 28861 | 25 | ||
| 6049 | 35103 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.435437534334 | (37.7168332689419, -122.435437534334) | 9 | 7 | 6 | 28861 | 5 | ||
| 6156 | 49713 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 20 Arco Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2003 12:00:00 AM | Permit Number 46525 | 5999460.35062419 | 2093111.47695612 | 37.7272541884473 | -122.444096744934 | (37.7272541884473, -122.444096744934) | 9 | 7 | 6 | 28861 | 25 | |||
| 6162 | 46753 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.7175193444423 | -122.465247516931 | (37.7175193444423, -122.465247516931) | 9 | 8 | 6 | 64 | 24 | ||
| 6208 | 47715 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 178 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45511 | 6001758.80730105 | 2095060.28518468 | 37.7327360238789 | -122.436290415986 | (37.7327360238789, -122.436290415986) | 9 | 7 | 5 | 63 | 40 | ||
| 6276 | 11636 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
| 6332 | 62387 | Permitted Site 7 | Tree(s) :: 17 | 48 Liebig St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1985 12:00:00 AM | Permit Number 22537 | 5995755.88056567 | 2086462.13640381 | 37.7087846394558 | -122.456422387366 | (37.7087846394558, -122.456422387366) | 9 | 7 | 6 | 28861 | 25 | |||
| 6355 | 100391 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 6002817 | 2092256 | 37.7250961583897 | -122.432431760897 | (37.7250961583897, -122.432431760897) | 9 | 7 | 6 | 28861 | 5 | ||||
| 6377 | 82142 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
| 6431 | 43420 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | 9 | 7 | 6 | 28861 | 25 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );