trees

39,840 rows where qLegalStatus_id = 7

✎ View and edit SQL

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)
1257 260668 Permitted Site 7 Aesculus californica :: California Buckeye 168 9 Cardenas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5989909.11704 2090923.47277 37.7206969761498 -122.47695514418 (37.7206969761498, -122.47695514418) 1 8 4 64 14
1259 34123 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14   2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
1261 45997 Permitted Site 7 Tree(s) :: 17   115 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1265 120363 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 6118 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5988496.49362 2114018.15896 37.7840267560995 -122.483530334528 (37.7840267560995, -122.483530334528) 11 6 2 55 26
1275 46058 Permitted Site 7 Tree(s) :: 17   188 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1282 65048 Permitted Site 7 Trachycarpus fortunei :: Windmill Palm 116 375 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1994 12:00:00 AM     Permit Number 27001 6008641.92550277 2097033.56507471 37.7385429081789 -122.412633121744 (37.7385429081789, -122.412633121744) 10 7 7 28859 2
1283 41795 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 1201 08th St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42196 6012618.34920617 2107219.96513791 37.7667349263458 -122.39959946704 (37.7667349263458, -122.39959946704) 14 3 8 28856 20
1286 39945 Permitted Site 7 Quercus agrifolia :: Coast Live Oak 172 0 Ervine St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41215                    
1287 48142 Permitted Site 7 Tree(s) :: 17   252 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1288 233082 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 1418 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/25/2020 12:00:00 AM 3 3x3 Permit Number 785211 6001974.22065 2099890.10044 37.746009810513 -122.43589113876 (37.746009810513, -122.43589113876) 2 7 5 63 22
1303 35175 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   7 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
1308 52427 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1815X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2005 12:00:00 AM 5 3x3 Permit Number 48544 6004786.32091155 2115731.58720361 37.7896660673411 -122.427295522794 (37.7896660673411, -122.427295522794) 13 9 11 28858 27
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
1321 48199 Permitted Site 7 Tree(s) :: 17   58 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1326 43484 Permitted Site 7 Melaleuca linariifolia :: Flaxleaf Paperbark 103   6 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2000 12:00:00 AM     Permit Number 43169                    
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
1335 31615 Permitted Site 7 Gleditsia triacanthos :: Honey Locust 182 750 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1995 12:00:00 AM     Permit Number 35136 6005596.48777411 2104595.39586612 37.7591345667337 -122.423700300709 (37.7591345667337, -122.423700300709) 2 4 5 28859 19
1340 87020 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 10 Osceola Dr 2 Sidewalk: Property side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
1346 260123 Permitted Site 7 Olea europaea 'Fruitless' :: Fruitless Olive 177 3195X Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2019 12:00:00 AM 3 3x3                      
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
1356 44935 Permitted Site 7 Tree(s) :: 17   168 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
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
1358 109891 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1398x MARIPOSA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013218 2106201 37.7639704813344 -122.397453893083 (37.7639704813344, -122.397453893083) 14 3 8 28856 29
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
1371 52082 Permitted Site 7 Maytenus boaria :: Mayten 58 138 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/17/2005 12:00:00 AM     Permit Number 48280 6004279.40612984 2097417.63926751 37.7393516795249 -122.427743978882 (37.7393516795249, -122.427743978882) 2 7 5 63 7
1372 48323 Permitted Site 7 Tree(s) :: 17   189 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1381 84767 Permitted Site 7 Tree(s) :: 17 185 Berry St 13 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
1382 4111 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3385X Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1995 12:00:00 AM 3 3x3   6007239.656 2100524.9644 37.7480507095515 -122.417728911573 (37.7480507095515, -122.417728911573) 2 4 7 28859 2
1386 67784 Permitted Site 7 Tree(s) :: 17 1030 South Park 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1992 12:00:00 AM     Permit Number 31421                    
1389 35341 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 810 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM     Permit Number 38807 6013022.29386504 2103288.02203798 37.7559611845743 -122.397926431796 (37.7559611845743, -122.397926431796) 10 3 8 28856 29
1390 33763 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1580 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/23/1996 12:00:00 AM     Permit Number 37815 6007223.30298499 2109757.94023834 37.7734013999863 -122.418440043785 (37.7734013999863, -122.418440043785) 8 2 9 28853 19
1392 48291 Permitted Site 7 Tree(s) :: 17   101 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1395 33932 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
1397 44933 Permitted Site 7 Tree(s) :: 17   166 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1402 128081 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009658.72737 2121889.09987 37.8068474325394 -122.410872486877 (37.8068474325394, -122.410872486877) 3 1 10 308 23
1405 96265 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2776 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2011 12:00:00 AM     Permit Number 767311 6004841.3 2119075.5 37.798850712467 -122.427343605274 (37.798850712467, -122.427343605274) 13 9 1 57 17
1410 68319 Permitted Site 7 Heteromeles arbutifolia :: Toyon 186 100 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32134 5993677.209627 2114838.05789906 37.7865781513031 -122.465666673248 (37.7865781513031, -122.465666673248) 11 6 2 54 11
1411 44977 Permitted Site 7 Tree(s) :: 17   49 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1413 48094 Permitted Site 7 Tree(s) :: 17   218 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1417 88463 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 955X Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2008 12:00:00 AM 6 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471) 10 3 8 58 1
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
1431 60090 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/1982 12:00:00 AM     Permit Number 19591                    
1435 68125 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 172 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31874 6006033.71828156 2099220.36912277 37.7444006509706 -122.421806351312 (37.7444006509706, -122.421806351312) 2 7 5 28859 2
1446 44592 Permitted Site 7 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1447 43059 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 3033 Rivera St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42909 5983784.03584538 2100159.31178354 37.7456988823219 -122.498809278198 (37.7456988823219, -122.498809278198) 1 8 3 29491 35
1450 43844 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2736 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2003 12:00:00 AM     Permit Number 43466 5985584.65410627 2096702.64202879 37.7363132411039 -122.492328600224 (37.7363132411039, -122.492328600224) 1 8 3 29491 35
1451 44942 Permitted Site 7 Tree(s) :: 17   175 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1452 50129 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 126 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46851 5992933.01758855 2098244.53048723 37.740973745145 -122.467034533605 (37.740973745145, -122.467034533605) 1 8 4 59 40
1458 97747 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2685 30th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 18001 5986960.2 2097027.9 37.7372866359421 -122.487596715706 (37.7372866359421, -122.487596715706) 1 8 3 29491 35
1459 46036 Permitted Site 7 Tree(s) :: 17   110 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1460 30324 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 720 Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/17/1956 12:00:00 AM     Permit Number 16 6011772.9424544 2117800.56968196 37.7957396438077 -122.403267984357 (37.7957396438077, -122.403267984357) 3 1 10 28860 4
1461 44992 Permitted Site 7 Tree(s) :: 17   81 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1465 45986 Permitted Site 7 Tree(s) :: 17   226 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
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
1479 44582 Permitted Site 7 Tree(s) :: 17   146 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1489 69250 Permitted Site 7 Maytenus boaria :: Mayten 58 1838 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/1994 12:00:00 AM     Permit Number 33318 5991599.04334449 2102860.56941142 37.7535711078961 -122.471983242544 (37.7535711078961, -122.471983242544) 1 8 4 56 12
1498 44556 Permitted Site 7 Tree(s) :: 17   19 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1501 27903 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 33 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6015937.152 2112771.705 37.7821632154212 -122.388507741674 (37.7821632154212, -122.388507741674) 6 2 9 28856 6
1503 33210 Permitted Site 7 :: 45 80 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/06/1996 12:00:00 AM     Permit Number 37408 5996508.84910838 2099508.74034148 37.7446507048802 -122.454762009134 (37.7446507048802, -122.454762009134) 1 5 4 59 40
1508 48345 Permitted Site 7 Tree(s) :: 17   162 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1515 31846 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7   1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
1518 99500 Permitted Site 7 Aesculus hippocastanum :: White Horsechestnut 190 2698@Divisadero Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2           6000656 2117555 37.7944382299983 -122.441716891944 (37.7944382299983, -122.441716891944) 13 9 1 57 27
1529 36010 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 190 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39158 6005991.6913929 2099142.23667474 37.7441837468315 -122.421946122617 (37.7441837468315, -122.421946122617) 2 7 5 28859 2
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
1546 86589 Permitted Site 7 Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 2680 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/30/2007 12:00:00 AM 6 3x3   6009770 2101729 37.7514987921589 -122.40906398531 (37.7514987921589, -122.40906398531) 2 4 7 28859 19
1552 63329 Permitted Site 7 Tree(s) :: 17 225 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1987 12:00:00 AM     Permit Number 23902                    
1555 61775 Permitted Site 7 Tree(s) :: 17 157 Lacrosse Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/1984 12:00:00 AM     Permit Number 21796                    
1556 158441 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 49 Van Buren St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2020 12:00:00 AM 3 3x3 Permit Number 785489 6002069.34164 2096386.56921 37.7363953338756 -122.435311658815 (37.7363953338756, -122.435311658815) 2 7 5 63 7
1558 256904 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1571 37th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/03/2019 12:00:00 AM 3 3x3 Permit Number 782743 5984651.59496 2104500.79365 37.7576702424259 -122.496129679735 (37.7576702424259, -122.496129679735) 1 8 3 56 35
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
1561 24107 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 14 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
1571 56051 Permitted Site 7 Olea europaea :: Olive Tree 9 49 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/1973 12:00:00 AM 36   Permit Number 12140 6003182.54972715 2108023.57751638 37.7684109649411 -122.43229368198 (37.7684109649411, -122.43229368198) 15 5 5 28862 3
1572 36143 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 1027 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM   3x3 Permit Number 39232 5992592.32005608 2107256.68934819 37.7656991270754 -122.468868188853 (37.7656991270754, -122.468868188853) 11 8 11 56 12
1575 57819 Permitted Site 7 Tree(s) :: 17 3025 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/1977 12:00:00 AM     Permit Number 16758 5985127.82530714 2105650.40400841 37.7608546360174 -122.494567452266 (37.7608546360174, -122.494567452266) 1 8 3 56 35
1579 45978 Permitted Site 7 Tree(s) :: 17   129 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
1583 57636 Permitted Site 7 Tree(s) :: 17 358 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/1976 12:00:00 AM     Permit Number 16534 6001116.64364888 2104248.07049337 37.7579269953626 -122.439168812397 (37.7579269953626, -122.439168812397) 2 4 5 28862 38
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
1600 46288 Permitted Site 7 Robinia x ambigua :: Locust 196   15 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
1602 45381 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11   4 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2001 12:00:00 AM     Permit Number 44200 5989322.60767277 2117225.76237725 37.7928819736725 -122.480907237859 (37.7928819736725, -122.480907237859) 11   1 61 30
1605 35819 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 980 Houston St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/22/1998 12:00:00 AM     Permit Number 39055                    
1615 44603 Permitted Site 7 Tree(s) :: 17   121 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2001 12:00:00 AM     Permit Number 43835                    
1617 87946 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 143 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50969 6000889 2105548 37.7614833276299 -122.440049308669 (37.7614833276299, -122.440049308669) 15 5 5 28862 3
1619 95785 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 347 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM   3x3 Permit Number 767529                    
1626 56962 Permitted Site 7 Tree(s) :: 17 409 Dellbrook Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/1974 12:00:00 AM     Permit Number 14214 5997128.15585412 2102761.97155727 37.7536187770602 -122.452855347756 (37.7536187770602, -122.452855347756) 1 5 4 63 38
1627 35149 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 11 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/1998 12:00:00 AM     Permit Number 38681 6004664.75137838 2109286.2995173 37.7719620248453 -122.427256837171 (37.7719620248453, -122.427256837171) 7 9 11 28852 10
1631 30310 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 228 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 8                    
1633 50106 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1550 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46830 5992376.29027554 2096837.8582672 37.7370792283941 -122.468857136293 (37.7370792283941, -122.468857136293) 1 8 4 59 40
1637 35981 Permitted Site 7 Arecastrum romanzoffianum :: Queen Palm 135 83 Prospect Stairs Street 2 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1998 12:00:00 AM     Permit Number 39135                    
1642 92622 Permitted Site 7 Tree(s) :: 17 1150 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2009 12:00:00 AM   3x3 Permit Number 52926 6002360 2112465 37.7805593321564 -122.43545656304 (37.7805593321564, -122.43545656304) 15 5 11 29490 41
1643 44855 Permitted Site 7 Tree(s) :: 17   17 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
1648 35048 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 700 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1998 12:00:00 AM     Permit Number 38613                    
1649 92526 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 275 10th St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6008743 2109634 37.7731465224788 -122.413174412357 (37.7731465224788, -122.413174412357) 8 2 9 28853 34
1651 37169 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 151 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1998 12:00:00 AM     Permit Number 39743 6005565.93572779 2099898.57048032 37.7462364463923 -122.423472053683 (37.7462364463923, -122.423472053683) 2 7 5 28859 22
1657 40280 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 307 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41432 6007215.02535858 2105520.83315888 37.7617668348059 -122.418168222107 (37.7617668348059, -122.418168222107) 2 4 7 28859 19
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
1665 47611 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1201 Houston St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/1994 12:00:00 AM     Permit Number 45444                    
1669 35520 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 90 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41442 6005793.71652674 2102887.49607432 37.7544562030797 -122.422896805421 (37.7544562030797, -122.422896805421) 2 4 5 28859 19
1674 48081 Permitted Site 7 Tree(s) :: 17   245 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45761                    
1676 84541 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 838 31st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51852 5986369.18358167 2110196.92433931 37.7734106873115 -122.49060871536 (37.7734106873115, -122.49060871536) 11 6 2 55 26
1691 63071 Permitted Site 7 Tree(s) :: 17 71 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/1986 12:00:00 AM     Permit Number 23549 6008174.41886116 2098235.80863024 37.741817754914 -122.414334581564 (37.741817754914, -122.414334581564) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);