trees
39,840 rows where qLegalStatus_id = 7 sorted by Neighborhoods (old) 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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23412 | 64741 | Permitted Site 7 | Tree(s) :: 17 | 1231 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2008 12:00:00 AM | 3x3 | Permit Number 50346 | 6000675.44421748 | 2109252.37556976 | 37.7716424628697 | -122.441053677824 | (37.7716424628697, -122.441053677824) | 15 | 5 | 11 | 29492 | 9 | ||
| 23461 | 39475 | Permitted Site 7 | Tree(s) :: 17 | 30 Ashbury Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40936 | 5999587.55794715 | 2106838.29242396 | 37.7649519741137 | -122.444643186495 | (37.7649519741137, -122.444643186495) | 15 | 5 | 5 | 29492 | 9 | |||
| 23543 | 58665 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 19 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 5x5 | Permit Number 17888 | 5997899.21227379 | 2107824.94085215 | 37.7675645727548 | -122.45055385809 | (37.7675645727548, -122.45055385809) | 15 | 5 | 11 | 29492 | 9 | ||
| 23571 | 59786 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 401 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2004 12:00:00 AM | Permit Number 19235 | 5998844.30042115 | 2109361.70149477 | 37.7718381757148 | -122.447395558288 | (37.7718381757148, -122.447395558288) | 15 | 5 | 11 | 29492 | 9 | ||
| 23764 | 63331 | Permitted Site 7 | Tree(s) :: 17 | 1323 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1987 12:00:00 AM | Permit Number 23904 | 5999483.53279533 | 2108251.02133254 | 37.7688250363658 | -122.445104554306 | (37.7688250363658, -122.445104554306) | 15 | 5 | 11 | 29492 | 9 | |||
| 23770 | 39620 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 176 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41019 | 5997495.40415115 | 2106779.2398399 | 37.7646702234482 | -122.451875122756 | (37.7646702234482, -122.451875122756) | 15 | 5 | 11 | 29492 | 9 | ||
| 23925 | 58489 | Permitted Site 7 | Tree(s) :: 17 | 476 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1978 12:00:00 AM | Permit Number 17654 | 5998581.70841159 | 2106416.76857601 | 37.7637371273208 | -122.448091798977 | (37.7637371273208, -122.448091798977) | 15 | 5 | 11 | 29492 | 9 | |||
| 24013 | 67828 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 710 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 3x3 | Permit Number 31489 | 5999080 | 2108181 | 37.768609734872 | -122.446495301803 | (37.768609734872, -122.446495301803) | 15 | 5 | 11 | 29492 | 9 | ||
| 24082 | 88257 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 436 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51241 | 5998536 | 2106665 | 37.76441609532 | -122.448267765661 | (37.76441609532, -122.448267765661) | 15 | 5 | 11 | 29492 | 9 | ||
| 24202 | 54896 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 168 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1972 12:00:00 AM | 3x3 | Permit Number 10761 | 5997518.11388038 | 2107130.00064711 | 37.7656346240705 | -122.451821882169 | (37.7656346240705, -122.451821882169) | 15 | 5 | 11 | 29492 | 9 | ||
| 24239 | 78664 | Permitted Site 7 | Cassia leptophylla :: Gold Medallion Tree 152 | 1110 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2008 12:00:00 AM | 3x3 | Permit Number 51506 | 6001236.93227028 | 2109383.43753665 | 37.7720342914694 | -122.439120856334 | (37.7720342914694, -122.439120856334) | 15 | 5 | 11 | 29492 | 9 | ||
| 24243 | 58456 | Permitted Site 7 | Tree(s) :: 17 | 191 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1979 12:00:00 AM | Permit Number 17610 | 5998919.47730354 | 2107067.58217122 | 37.7655434005651 | -122.44697040139 | (37.7655434005651, -122.44697040139) | 15 | 5 | 11 | 29492 | 9 | |||
| 24267 | 56501 | Permitted Site 7 | Tree(s) :: 17 | 1537 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998788.44674872 | 2108641.8195399 | 37.7698583712599 | -122.447536931666 | (37.7698583712599, -122.447536931666) | 15 | 5 | 11 | 29492 | 9 | |||||
| 24430 | 54910 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1035 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 777530 | 5997630.32227644 | 2106995.57897764 | 37.765271962328 | -122.451424083805 | (37.765271962328, -122.451424083805) | 15 | 5 | 11 | 29492 | 9 | ||
| 24676 | 45236 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1334 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2001 12:00:00 AM | Permit Number 44061 | 5999545.87613757 | 2108180.03786548 | 37.7686336918072 | -122.444883810639 | (37.7686336918072, -122.444883810639) | 15 | 5 | 11 | 29492 | 9 | |||
| 24910 | 50685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.7654709832109 | -122.446105453704 | (37.7654709832109, -122.446105453704) | 15 | 5 | 11 | 29492 | 9 | ||||
| 24982 | 58878 | Permitted Site 7 | Tree(s) :: 17 | 264 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1980 12:00:00 AM | Permit Number 18142 | 5999032.42620789 | 2106638.25007207 | 37.7643710147346 | -122.446548846713 | (37.7643710147346, -122.446548846713) | 15 | 5 | 11 | 29492 | 9 | |||
| 25014 | 67050 | Permitted Site 7 | Tree(s) :: 17 | 1027 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1992 12:00:00 AM | Permit Number 30431 | 5998091.50690344 | 2106748.69989672 | 37.7646204925326 | -122.44981116961 | (37.7646204925326, -122.44981116961) | 15 | 5 | 11 | 29492 | 9 | |||
| 25130 | 41116 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1799x PAGE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | 4x4 | Permit Number 41862 | 5998015 | 2108858 | 37.770407716093 | -122.450227838314 | (37.770407716093, -122.450227838314) | 15 | 5 | 11 | 29492 | 9 | ||
| 25248 | 58516 | Permitted Site 7 | Tree(s) :: 17 | 1466 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1979 12:00:00 AM | Permit Number 17693 | 5998700.97291587 | 2108334.63210145 | 37.7690099132353 | -122.447817381964 | (37.7690099132353, -122.447817381964) | 15 | 5 | 11 | 29492 | 9 | |||
| 25450 | 17122 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1931 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5997743.85041 | 2109170.01524 | 37.7712489089965 | -122.451188245827 | (37.7712489089965, -122.451188245827) | 15 | 5 | 11 | 29492 | 9 | |||
| 25511 | 94960 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998206 | 2108519 | 37.7694878371786 | -122.449542741076 | (37.7694878371786, -122.449542741076) | 15 | 5 | 11 | 29492 | 9 | ||||
| 25693 | 10445 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1509 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 2X3 | 5998900.22539 | 2108626.72926 | 37.76982332449 | -122.447149207323 | (37.76982332449, -122.447149207323) | 15 | 5 | 11 | 29492 | 9 | |||
| 25780 | 58593 | Permitted Site 7 | Tree(s) :: 17 | 67 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1979 12:00:00 AM | Permit Number 17793 | 5998357.05297189 | 2105972.49104504 | 37.7625044081411 | -122.448836806098 | (37.7625044081411, -122.448836806098) | 15 | 5 | 11 | 29492 | 9 | |||
| 26079 | 54889 | Permitted Site 7 | Tree(s) :: 17 | 158 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1972 12:00:00 AM | Permit Number 10754 | 5997606.08349851 | 2107142.25924967 | 37.7656733210449 | -122.451518500403 | (37.7656733210449, -122.451518500403) | 15 | 5 | 11 | 29492 | 9 | |||
| 26116 | 112034 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 153 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 6001363.3 | 2108479.6 | 37.7695597684122 | -122.438618967849 | (37.7695597684122, -122.438618967849) | 15 | 5 | 5 | 29492 | 9 | |||
| 26195 | 3880 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 7 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002005.1932098 | 2108677.8726821 | 37.7701406703185 | -122.436412879285 | (37.7701406703185, -122.436412879285) | 15 | 5 | 5 | 29492 | 9 | |||
| 26430 | 64783 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 159 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25776 | 5999862.92840033 | 2109021.20882221 | 37.7709614246447 | -122.443847598268 | (37.7709614246447, -122.443847598268) | 15 | 5 | 11 | 29492 | 9 | ||
| 26594 | 55558 | Permitted Site 7 | Tree(s) :: 17 | 832 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/1973 12:00:00 AM | Permit Number 11527 | 5998701.17938543 | 2107279.05467924 | 37.7661115766087 | -122.447740666988 | (37.7661115766087, -122.447740666988) | 15 | 5 | 11 | 29492 | 9 | |||
| 26712 | 58892 | Permitted Site 7 | Tree(s) :: 17 | 636 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/1980 12:00:00 AM | Permit Number 18162 | 5997015.92334997 | 2108862.0760676 | 37.7703616830203 | -122.453683922261 | (37.7703616830203, -122.453683922261) | 15 | 5 | 11 | 29492 | 9 | |||
| 26807 | 60672 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1024 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1983 12:00:00 AM | Permit Number 20308 | 6001654.02494566 | 2109441.95651111 | 37.7722186942397 | -122.437682294704 | (37.7722186942397, -122.437682294704) | 15 | 5 | 11 | 29492 | 9 | ||
| 26878 | 58431 | Permitted Site 7 | Tree(s) :: 17 | 737 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | Permit Number 17576 | 5999021.11115241 | 2108093.87581766 | 37.7683671501346 | -122.446692723268 | (37.7683671501346, -122.446692723268) | 15 | 5 | 11 | 29492 | 9 | |||
| 26960 | 53835 | Permitted Site 7 | Tree(s) :: 17 | 1364 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1972 12:00:00 AM | Permit Number 9537 | 5999572.9672158 | 2107984.71895497 | 37.7680989412934 | -122.444776063753 | (37.7680989412934, -122.444776063753) | 15 | 5 | 11 | 29492 | 9 | |||
| 26971 | 54605 | Permitted Site 7 | Tree(s) :: 17 | 75 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1972 12:00:00 AM | Permit Number 10428 | 6001161.75539938 | 2108774.69404635 | 37.7703585559243 | -122.439337256609 | (37.7703585559243, -122.439337256609) | 15 | 5 | 11 | 29492 | 9 | |||
| 27110 | 56263 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | Permit Number 12389 | 5997442.16701528 | 2106406.61050088 | 37.7636440286356 | -122.452032368392 | (37.7636440286356, -122.452032368392) | 15 | 5 | 11 | 29492 | 9 | |||
| 27844 | 58625 | Permitted Site 7 | Tree(s) :: 17 | 1220 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1979 12:00:00 AM | Permit Number 17842 | 5998223.33789577 | 2106177.62845524 | 37.7630600162405 | -122.44931405596 | (37.7630600162405, -122.44931405596) | 15 | 5 | 11 | 29492 | 9 | |||
| 27909 | 51596 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 130 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47889 | 5999316.0541876 | 2107729.2257987 | 37.7673827567962 | -122.445646320311 | (37.7673827567962, -122.445646320311) | 15 | 5 | 11 | 29492 | 9 | |||
| 27956 | 55348 | Permitted Site 7 | Tree(s) :: 17 | 109 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1972 12:00:00 AM | Permit Number 11281 | 6002332.52989434 | 2108851.54642576 | 37.770636129957 | -122.435293051238 | (37.770636129957, -122.435293051238) | 15 | 5 | 11 | 29492 | 9 | |||
| 28033 | 62545 | Permitted Site 7 | Tree(s) :: 17 | 304 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1986 12:00:00 AM | Permit Number 22740 | 6001815.31201294 | 2109448.4348605 | 37.7722456514753 | -122.437124853674 | (37.7722456514753, -122.437124853674) | 15 | 5 | 11 | 29492 | 9 | |||
| 28077 | 58867 | Permitted Site 7 | Tree(s) :: 17 | 15 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1980 12:00:00 AM | Permit Number 18127 | 5998578.77444847 | 2107225.30134727 | 37.7659569868254 | -122.448160168789 | (37.7659569868254, -122.448160168789) | 15 | 5 | 11 | 29492 | 9 | |||
| 28112 | 51709 | Permitted Site 7 | Tree(s) :: 17 | 510 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47985 | 5998606.93746757 | 2106231.34181968 | 37.7632294342171 | -122.447991188454 | (37.7632294342171, -122.447991188454) | 15 | 5 | 11 | 29492 | 9 | |||
| 28122 | 58591 | Permitted Site 7 | Tree(s) :: 17 | 246 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1980 12:00:00 AM | Permit Number 17791 | 5997582.85461659 | 2106170.83422874 | 37.7630047043289 | -122.451528768877 | (37.7630047043289, -122.451528768877) | 15 | 5 | 11 | 29492 | 9 | |||
| 28123 | 57445 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 1077 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1983 12:00:00 AM | Permit Number 20314 | 6001420.58726917 | 2109356.70066211 | 37.7719713271641 | -122.438483664715 | (37.7719713271641, -122.438483664715) | 15 | 5 | 11 | 29492 | 9 | ||
| 28207 | 53421 | Permitted Site 7 | Tree(s) :: 17 | 4710 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1969 12:00:00 AM | Permit Number 6320 | 5998606.27752639 | 2105706.29885329 | 37.7617877601927 | -122.447955667016 | (37.7617877601927, -122.447955667016) | 15 | 5 | 11 | 29492 | 9 | |||
| 28233 | 17097 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1685 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1994 12:00:00 AM | 6 | 3x3 | 5998961.33091 | 2109338.80165 | 37.7717819854662 | -122.44698909517 | (37.7717819854662, -122.44698909517) | 15 | 5 | 11 | 29492 | 9 | ||
| 28347 | 122501 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 575 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997973.69250609 | 2108644.65485494 | 37.7698195609286 | -122.450355338753 | (37.7698195609286, -122.450355338753) | 15 | 5 | 11 | 29492 | 9 | ||||
| 28360 | 62100 | Permitted Site 7 | Tree(s) :: 17 | 482 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1985 12:00:00 AM | Permit Number 22193 | 5998585.86422037 | 2106386.27791868 | 37.763653645206 | -122.44807522985 | (37.763653645206, -122.44807522985) | 15 | 5 | 11 | 29492 | 9 | |||
| 28449 | 54907 | Permitted Site 7 | Tree(s) :: 17 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1972 12:00:00 AM | Permit Number 10773 | 5997614.7422849 | 2107106.76684397 | 37.7655763637714 | -122.451485991473 | (37.7655763637714, -122.451485991473) | 15 | 5 | 11 | 29492 | 9 | |||
| 28536 | 31687 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 723 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35191 | 5998531.56699721 | 2108118.02123307 | 37.7684054707307 | -122.448387742887 | (37.7684054707307, -122.448387742887) | 15 | 5 | 11 | 29492 | 9 | |||
| 28579 | 116510 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500x Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998488 | 2108327 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | 15 | 5 | 11 | 29492 | 9 | ||||
| 28603 | 58473 | Permitted Site 7 | Liquidambar orientalis :: Oriental Sweet Gum 269 | 755 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 5x4 | Permit Number 32218 | 5998560.64278981 | 2107909.72137719 | 37.7678351944794 | -122.448272171383 | (37.7678351944794, -122.448272171383) | 15 | 5 | 11 | 29492 | 9 | |
| 28809 | 41114 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1799x COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | 4x4 | Permit Number 41862 | 5998015 | 2108858 | 37.770407716093 | -122.450227838314 | (37.770407716093, -122.450227838314) | 15 | 5 | 11 | 29492 | 9 | |
| 29217 | 58682 | Permitted Site 7 | Tree(s) :: 17 | 2 Ashbury Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1979 12:00:00 AM | Permit Number 17910 | 5999542.84930369 | 2107034.97290569 | 37.7654894581893 | -122.444811960692 | (37.7654894581893, -122.444811960692) | 15 | 5 | 5 | 29492 | 9 | |||
| 29218 | 63761 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 343 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24438 | 6003220.73981685 | 2109435.30524559 | 37.7722893887759 | -122.43226242096 | (37.7722893887759, -122.43226242096) | 15 | 9 | 11 | 29492 | 9 | ||
| 29473 | 80801 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 4832 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50898 | 5998124.87527273 | 2105680.72409437 | 37.7616900093761 | -122.449618794785 | (37.7616900093761, -122.449618794785) | 15 | 5 | 11 | 29492 | 9 | ||
| 29585 | 56814 | Permitted Site 7 | Tree(s) :: 17 | 980 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14045 | 5999238.55674578 | 2106649.81706748 | 37.7644145466661 | -122.445836733238 | (37.7644145466661, -122.445836733238) | 15 | 5 | 5 | 29492 | 9 | |||
| 29635 | 51146 | Permitted Site 7 | Tree(s) :: 17 | 148 Clifford Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2009 12:00:00 AM | 3x3 | Permit Number 52174 | 5999418.1990548 | 2106558.09908127 | 37.76417296764 | -122.445208807784 | (37.76417296764, -122.445208807784) | 15 | 5 | 5 | 29492 | 9 | ||
| 29811 | 58565 | Permitted Site 7 | Tree(s) :: 17 | 2 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1979 12:00:00 AM | Permit Number 17755 | 5998654.70368352 | 2107288.38453846 | 37.7661345376569 | -122.447902088354 | (37.7661345376569, -122.447902088354) | 15 | 5 | 11 | 29492 | 9 | |||
| 29829 | 55358 | Permitted Site 7 | Tree(s) :: 17 | 1132 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1972 12:00:00 AM | Permit Number 11291 | 6000706.73438273 | 2108962.10293655 | 37.7708472291666 | -122.440924616523 | (37.7708472291666, -122.440924616523) | 15 | 5 | 11 | 29492 | 9 | |||
| 29928 | 55562 | Permitted Site 7 | Tree(s) :: 17 | 838 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/1973 12:00:00 AM | Permit Number 11531 | 5998706.83266578 | 2107238.55440786 | 37.7660006961905 | -122.447718197647 | (37.7660006961905, -122.447718197647) | 15 | 5 | 11 | 29492 | 9 | |||
| 30352 | 17134 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2029 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1994 12:00:00 AM | 6 | 3X3 | 5997269.53804 | 2109046.53682 | 37.7708827008019 | -122.452819989539 | (37.7708827008019, -122.452819989539) | 15 | 5 | 11 | 29492 | 9 | ||
| 30363 | 58477 | Permitted Site 7 | Tree(s) :: 17 | 777 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/1978 12:00:00 AM | Permit Number 17634 | 5998580.63239754 | 2107766.515224 | 37.7674431294517 | -122.448192717001 | (37.7674431294517, -122.448192717001) | 15 | 5 | 11 | 29492 | 9 | |||
| 30420 | 52305 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 715 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | 15 | 5 | 5 | 29492 | 9 | ||
| 30429 | 48781 | Permitted Site 7 | Tree(s) :: 17 | 1514 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46036 | 5998437.02307743 | 2108297.85066166 | 37.768893830803 | -122.44872771433 | (37.768893830803, -122.44872771433) | 15 | 5 | 11 | 29492 | 9 | ||||
| 30452 | 66476 | Permitted Site 7 | Tree(s) :: 17 | 106 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1991 12:00:00 AM | Permit Number 29631 | 5998045.49690406 | 2106855.89533462 | 37.764912191507 | -122.449978031572 | (37.764912191507, -122.449978031572) | 15 | 5 | 11 | 29492 | 9 | |||
| 30534 | 35157 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 52 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44857 | 6002886.83329691 | 2108721.01150397 | 37.7703091758364 | -122.433366381141 | (37.7703091758364, -122.433366381141) | 15 | 5 | 5 | 29492 | 9 | ||
| 30675 | 17140 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2065 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997131.99502 | 2109098.46999 | 37.7710174132749 | -122.453299501563 | (37.7710174132749, -122.453299501563) | 15 | 5 | 11 | 29492 | 9 | |||
| 30747 | 67463 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 415 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1992 12:00:00 AM | Permit Number 30974 | 5998477.62565736 | 2106794.86202046 | 37.7647693262757 | -122.448479018432 | (37.7647693262757, -122.448479018432) | 15 | 5 | 11 | 29492 | 9 | |||
| 30777 | 67775 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31408 | 6003124.05257267 | 2108779.41932212 | 37.7704830045429 | -122.43255001344 | (37.7704830045429, -122.43255001344) | 15 | 5 | 5 | 29492 | 9 | ||
| 30793 | 56843 | Permitted Site 7 | Tree(s) :: 17 | 924 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14075 | 5998766.29144645 | 2106812.58983095 | 37.7648345028641 | -122.4474818788 | (37.7648345028641, -122.4474818788) | 15 | 5 | 11 | 29492 | 9 | |||
| 30803 | 60681 | Permitted Site 7 | Tree(s) :: 17 | 151 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1993 12:00:00 AM | Permit Number 31762 | 6001298.40167842 | 2109195.23115773 | 37.7715210212458 | -122.438894739576 | (37.7715210212458, -122.438894739576) | 15 | 5 | 11 | 29492 | 9 | |||
| 31039 | 62609 | Permitted Site 7 | Tree(s) :: 17 | 199 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1986 12:00:00 AM | Permit Number 22918 | 5997308.93705544 | 2106700.75318038 | 37.7644440373039 | -122.452514395206 | (37.7644440373039, -122.452514395206) | 15 | 5 | 11 | 29492 | 9 | |||
| 31059 | 44055 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 751Divisadero Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2006 12:00:00 AM | Permit Number 43583 | 6002120.85770365 | 2108760.0753661 | 37.7703729501471 | -122.436018680596 | (37.7703729501471, -122.436018680596) | 15 | 5 | 5 | 29492 | 9 | |||
| 31131 | 68391 | Permitted Site 7 | Tree(s) :: 17 | 759 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 3.5x4 | Permit Number 32219 | 5998564.2772658 | 2107883.68388152 | 37.7677639098986 | -122.448257725062 | (37.7677639098986, -122.448257725062) | 15 | 5 | 11 | 29492 | 9 | ||
| 31457 | 56745 | Permitted Site 7 | Tree(s) :: 17 | 115 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2014 12:00:00 AM | Permit Number 770975 | 6002804.43980097 | 2108936.88935097 | 37.7708972485784 | -122.433666810792 | (37.7708972485784, -122.433666810792) | 15 | 5 | 11 | 29492 | 9 | |||
| 31507 | 94354 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 31558 | 94351 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 31594 | 54908 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1025 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 10774 | 5997625.73992568 | 2107028.28129343 | 37.7653614921753 | -122.451442291891 | (37.7653614921753, -122.451442291891) | 15 | 5 | 11 | 29492 | 9 | ||
| 31892 | 94188 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 456 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2014 12:00:00 AM | 10 | 3x4 | Permit Number 772961 | 5998552 | 2106546 | 37.7640902659836 | -122.448203856901 | (37.7640902659836, -122.448203856901) | 15 | 5 | 11 | 29492 | 9 | |
| 31947 | 57244 | Permitted Site 7 | Tree(s) :: 17 | 112 Upper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | Permit Number 14532 | 5999813.94435353 | 2106926.85405892 | 37.7652080580188 | -122.443866538808 | (37.7652080580188, -122.443866538808) | 15 | 5 | 5 | 29492 | 9 | |||
| 31997 | 65573 | Permitted Site 7 | Tree(s) :: 17 | 876 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/1990 12:00:00 AM | Permit Number 28472 | 6001489.10367059 | 2108723.68900128 | 37.7702371319072 | -122.438201306809 | (37.7702371319072, -122.438201306809) | 15 | 5 | 11 | 29492 | 9 | |||
| 32003 | 59294 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 357 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1980 12:00:00 AM | Permit Number 18631 | 5998269.35755712 | 2107529.98911826 | 37.7667758890994 | -122.449252327047 | (37.7667758890994, -122.449252327047) | 15 | 5 | 11 | 29492 | 9 | |||
| 32497 | 46108 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 798 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
| 32698 | 58520 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1979 12:00:00 AM | 7x7 | Permit Number 17697 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | 15 | 5 | 11 | 29492 | 9 | ||
| 32846 | 51941 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1727 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | Permit Number 48166 | 5998310.14732999 | 2108922.34743282 | 37.7706012837126 | -122.449211564129 | (37.7706012837126, -122.449211564129) | 15 | 5 | 11 | 29492 | 9 | |||
| 32912 | 94410 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 63 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2010 12:00:00 AM | 3x3 | Permit Number 53650 | 6001682.9 | 2108449.6 | 37.7694955715896 | -122.437511336741 | (37.7694955715896, -122.437511336741) | 15 | 5 | 5 | 29492 | 9 | ||
| 32968 | 16997 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 903 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6002604.56537 | 2109869.28932 | 37.7734460452794 | -122.43442485558 | (37.7734460452794, -122.43442485558) | 15 | 5 | 11 | 29492 | 9 | |||
| 32998 | 58663 | Permitted Site 7 | Tree(s) :: 17 | 174 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | Permit Number 17885 | 5998322.46993297 | 2107744.05820254 | 37.7673667063087 | -122.449084043997 | (37.7673667063087, -122.449084043997) | 15 | 5 | 11 | 29492 | 9 | |||
| 33070 | 97928 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 275 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | Permit Number 12389 | 5997436 | 2106416 | 37.7636694565674 | -122.452054375547 | (37.7636694565674, -122.452054375547) | 15 | 5 | 11 | 29492 | 9 | |||
| 33421 | 58143 | Permitted Site 7 | Tree(s) :: 17 | 801 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1978 12:00:00 AM | Permit Number 17127 | 5997604.82756206 | 2107799.72274758 | 37.7674784762773 | -122.451570272219 | (37.7674784762773, -122.451570272219) | 15 | 5 | 11 | 29492 | 9 | |||
| 33870 | 58609 | Permitted Site 7 | Tree(s) :: 17 | 801 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1979 12:00:00 AM | Permit Number 17822 | 5997986.50451115 | 2107504.56289676 | 37.7666898923265 | -122.450228831016 | (37.7666898923265, -122.450228831016) | 15 | 5 | 11 | 29492 | 9 | |||
| 33874 | 89126 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 635 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 50531 | 5999771 | 2107673 | 37.7672543384354 | -122.444068690497 | (37.7672543384354, -122.444068690497) | 15 | 5 | 5 | 29492 | 9 | ||||
| 33910 | 50451 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 12 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47097 | 5999287.88101991 | 2108301.76865452 | 37.7689532065783 | -122.445784947419 | (37.7689532065783, -122.445784947419) | 15 | 5 | 11 | 29492 | 9 | |||
| 33913 | 58411 | Permitted Site 7 | Tree(s) :: 17 | 428 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1979 12:00:00 AM | Permit Number 17546 | 5998543.91812824 | 2106693.78259895 | 37.7644955777598 | -122.448242451895 | (37.7644955777598, -122.448242451895) | 15 | 5 | 11 | 29492 | 9 | |||
| 34119 | 100158 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 14 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | Permit Number 769008 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | 15 | 5 | 11 | 29492 | 9 | |||
| 34605 | 10379 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1316 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1990 12:00:00 AM | 18 | 3X3 | 5999827.9509 | 2108872.87214 | 37.7705521343685 | -122.44395792635 | (37.7705521343685, -122.44395792635) | 15 | 5 | 11 | 29492 | 9 | ||
| 34673 | 55615 | Permitted Site 7 | Tree(s) :: 17 | 852 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/1973 12:00:00 AM | Permit Number 11592 | 5997193.83050151 | 2107569.18411661 | 37.7668219312962 | -122.452975205534 | (37.7668219312962, -122.452975205534) | 15 | 5 | 11 | 29492 | 9 | |||
| 34713 | 56256 | Permitted Site 7 | Tree(s) :: 17 | 202 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | Permit Number 12382 | 5997706.85914509 | 2106495.99783193 | 37.7639046216399 | -122.451123332066 | (37.7639046216399, -122.451123332066) | 15 | 5 | 11 | 29492 | 9 | |||
| 34880 | 57509 | Permitted Site 7 | Tree(s) :: 17 | 529 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | Permit Number 16362 | 5998427.78706784 | 2108861.50408251 | 37.7704409513676 | -122.448800265569 | (37.7704409513676, -122.448800265569) | 15 | 5 | 11 | 29492 | 9 | |||
| 34951 | 52130 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 220 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48313 | 6002806.0471416 | 2109304.34219127 | 37.7719062747483 | -122.433687517115 | (37.7719062747483, -122.433687517115) | 15 | 5 | 11 | 29492 | 9 |
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) );