trees
563 rows where qSpecies_id = 52 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104015 | 64118 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 402 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24889 | 6003939.69845123 | 2098396.37778582 | 37.7420198489818 | -122.428988299782 | (37.7420198489818, -122.428988299782) | 2 | 7 | 5 | 63 | 22 | ||
104871 | 94381 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
105041 | 66384 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 289 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29510 | 6003897.0288205 | 2108659.24127875 | 37.7701968288604 | -122.429867711068 | (37.7701968288604, -122.429867711068) | 7 | 9 | 5 | 29492 | 10 | ||
105866 | 63269 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 39 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23826 | 6006964.49512199 | 2099515.87189553 | 37.7452644809694 | -122.418608862279 | (37.7452644809694, -122.418608862279) | 2 | 7 | 7 | 28859 | 2 | ||
106472 | 67812 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 950 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1995 12:00:00 AM | Permit Number 31466 | 6003745.95469336 | 2102716.06929971 | 37.7538697471416 | -122.429966268708 | (37.7538697471416, -122.429966268708) | 2 | 4 | 5 | 28862 | 22 | ||
106918 | 62431 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4402 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22591 | 5999916.26807627 | 2105779.65094566 | 37.76206395953 | -122.443430215898 | (37.76206395953, -122.443430215898) | 15 | 5 | 5 | 28862 | 3 | ||
107404 | 58502 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | Permit Number 17675 | 5999614.32190404 | 2108410.03271869 | 37.7692691057292 | -122.444663596269 | (37.7692691057292, -122.444663596269) | 15 | 5 | 11 | 29492 | 9 | |||
108671 | 33222 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 130 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | 1 | 8 | 4 | 59 | 40 | ||
111055 | 60695 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2901 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20340 | 6008888.31014725 | 2103298.66329221 | 37.7557593031988 | -122.41222391569 | (37.7557593031988, -122.41222391569) | 2 | 4 | 7 | 28859 | 19 | ||
113514 | 109631 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 390 BUCKINGHAM WAY | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x9 | 5989374 | 2093588 | 37.7279820381776 | -122.478999652651 | (37.7279820381776, -122.478999652651) | 1 | 8 | 4 | 64 | 14 | |||||
113696 | 65552 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 285 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28451 | 5995547.56425531 | 2097511.07200024 | 37.7391104150803 | -122.457941385434 | (37.7391104150803, -122.457941385434) | 9 | 7 | 4 | 59 | 40 | ||
114319 | 57736 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 321 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1976 12:00:00 AM | 4x4 | Permit Number 16654 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | 2 | 4 | 5 | 28859 | 19 | ||
115747 | 65553 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 283 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28452 | 5995572.37835094 | 2097534.90092934 | 37.7391772690895 | -122.457857313996 | (37.7391772690895, -122.457857313996) | 9 | 7 | 4 | 59 | 40 | ||
115879 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 5 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
116388 | 111865 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 2X CHRISTOPHER DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996768 | 2104018 | 37.7570468705973 | -122.454191553084 | (37.7570468705973, -122.454191553084) | 1 | 5 | 4 | 63 | 12 | ||||
117098 | 61664 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4900 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1994 12:00:00 AM | Permit Number 21660 | 5992426.26787439 | 2114159.4357735 | 37.7846426083195 | -122.469945157417 | (37.7846426083195, -122.469945157417) | 11 | 6 | 2 | 54 | 11 | ||
117164 | 69209 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1013 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33260 | 6008042.23882633 | 2102024.29023495 | 37.7522126526326 | -122.415059711834 | (37.7522126526326, -122.415059711834) | 2 | 4 | 7 | 28859 | 19 | ||
121358 | 63112 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 9 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1986 12:00:00 AM | Permit Number 23616 | 6007066.07091245 | 2099699.59516801 | 37.7457746619282 | -122.418270653095 | (37.7457746619282, -122.418270653095) | 2 | 7 | 7 | 28859 | 2 | ||
122768 | 54919 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 706 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/1988 12:00:00 AM | Permit Number 10786 | 6016194.08804658 | 2097035.77874441 | 37.7389699539681 | -122.386521286334 | (37.7389699539681, -122.386521286334) | 10 | 3 | 8 | 58 | 1 | ||
127142 | 65482 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 519 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1989 12:00:00 AM | Permit Number 28366 | 5994743.29707293 | 2091977.51972285 | 37.7238703903851 | -122.460321333166 | (37.7238703903851, -122.460321333166) | 9 | 8 | 4 | 28861 | 24 | ||
127698 | 257930 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000X Hudson Ave | Unaccepted Street : Cutout | Tree | DPW 1 | 3x3 | 6018755 | 2095128 | 37.7338730033489 | -122.377534379141 | (37.7338730033489, -122.377534379141) | 10 | 3 | 8 | 58 | 1 | |||||
128038 | 63102 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 151 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37593 | 6006585.95318508 | 2098816.77496864 | 37.74332359922 | -122.41986820091 | (37.74332359922, -122.41986820091) | 2 | 7 | 7 | 28859 | 2 | ||
128188 | 94201 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1227 Pierce St | 2 | Sidewalk: Property side : | Tree | Private 2 | 06/22/2010 12:00:00 AM | Permit Number 53604 | 6002086 | 2112766.6 | 37.7813718842821 | -122.436426049876 | (37.7813718842821, -122.436426049876) | 15 | 5 | 11 | 29490 | 41 | |||
129135 | 113327 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 237 Fairmount St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775932 | 6004215.8 | 2097159.4 | 37.7386390150291 | -122.427945503988 | (37.7386390150291, -122.427945503988) | 2 | 7 | 5 | 63 | 7 | |||
130009 | 107550 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 198X Jennings St | 3 | Front Yard : Yard | Tree | DPW 1 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |||||
130215 | 63183 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23722 | 6002224.85030351 | 2113085.27883033 | 37.7822547845521 | -122.435968505977 | (37.7822547845521, -122.435968505977) | 15 | 5 | 11 | 29490 | 41 | ||
130907 | 65395 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1199 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1990 12:00:00 AM | Permit Number 28618 | 6006415.64200439 | 2102619.79399643 | 37.7537562275815 | -122.420727018296 | (37.7537562275815, -122.420727018296) | 2 | 4 | 7 | 28859 | 19 | ||
131448 | 112486 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 6 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||
131970 | 92011 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | ||||
133408 | 102296 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1500 Michigan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016449 | 2101073.5 | 37.7500708170088 | -122.385921283567 | (37.7500708170088, -122.385921283567) | 10 | 3 | 8 | 58 | 1 | ||||
133966 | 187652 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 46 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992908 | 2101735 | 37.7505562410762 | -122.467374782979 | (37.7505562410762, -122.467374782979) | 1 | 8 | 4 | 29491 | 12 | ||||
134755 | 50874 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1160 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2004 12:00:00 AM | Permit Number 47384 | 6007625.30066101 | 2102900.0062832 | 37.7545937308752 | -122.41656358052 | (37.7545937308752, -122.41656358052) | 2 | 4 | 7 | 28859 | 19 | ||
137140 | 112418 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 268X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | ||||
137412 | 91083 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4055 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824 | 2101802 | 37.7513076735554 | -122.433089295463 | (37.7513076735554, -122.433089295463) | 2 | 4 | 5 | 28862 | 22 | ||
137503 | 60551 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 539 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20161 | 5985003.93496372 | 2112200.51497155 | 37.7788321315722 | -122.495479035088 | (37.7788321315722, -122.495479035088) | 11 | 6 | 2 | 55 | 26 | ||
137993 | 110179 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 321 Fair Oaks St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | 2 | 4 | 5 | 28859 | 19 | ||||
139377 | 63106 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 67 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1986 12:00:00 AM | Permit Number 23602 | 6006857.2853572 | 2099318.42969221 | 37.744716312649 | -122.418965575221 | (37.744716312649, -122.418965575221) | 2 | 7 | 7 | 28859 | 2 | ||
140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
144569 | 117548 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 2 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
145339 | 67105 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1205 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30520 | 5992960.34916512 | 2107265.37958459 | 37.765744243823 | -122.467595898952 | (37.765744243823, -122.467595898952) | 11 | 8 | 11 | 56 | 12 | ||
146550 | 32724 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1082 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37114 | 6006978.17320306 | 2114692.47231461 | 37.7869366280698 | -122.419638162258 | (37.7869366280698, -122.419638162258) | 13 | 9 | 10 | 28858 | 21 | ||
148069 | 66850 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1880 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30155 | 5998816.45099957 | 2110433.37978637 | 37.7747791387742 | -122.447569047166 | (37.7747791387742, -122.447569047166) | 15 | 5 | 11 | 29492 | 16 | ||
149348 | 65614 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 901 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 3x3 | Permit Number 28521 | 6001429.80797007 | 2088950.28994853 | 37.7159406631737 | -122.436990572562 | (37.7159406631737, -122.436990572562) | 9 | 7 | 6 | 28861 | 5 | |
150229 | 87675 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 11 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
151322 | 94377 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
153065 | 254084 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 170x Kensington Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5994883 | 2098695 | 37.7423229834884 | -122.460324888843 | (37.7423229834884, -122.460324888843) | 1 | 8 | 4 | 59 | 40 | ||||
153526 | 63705 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1679 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | Permit Number 24365 | 5994000.03328261 | 2104083.32941502 | 37.757067134665 | -122.463768902449 | (37.757067134665, -122.463768902449) | 1 | 5 | 4 | 56 | 12 | ||
153608 | 117546 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 1 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
154210 | 94386 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
154879 | 94599 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1709 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997540 | 2108126 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | 15 | 5 | 11 | 29492 | 9 | |||||
154893 | 62017 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 53 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1986 12:00:00 AM | Permit Number 22088 | 6004287.33949957 | 2108757.29100043 | 37.7704881450556 | -122.428524619186 | (37.7704881450556, -122.428524619186) | 7 | 9 | 11 | 29492 | 10 | ||
156558 | 68317 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1999X 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32130 | 5981353.71840295 | 2101490.23529545 | 37.7492103807501 | -122.507311533808 | (37.7492103807501, -122.507311533808) | 1 | 8 | 3 | 29491 | 35 | ||
156878 | 63136 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 75 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23653 | 6007261.8048924 | 2099033.40342516 | 37.7439564645667 | -122.417546624418 | (37.7439564645667, -122.417546624418) | 2 | 7 | 7 | 28859 | 2 | ||
157396 | 107712 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1798X 31st Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | 1 | 8 | 3 | 56 | 35 | ||||
157517 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
157949 | 91085 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4055 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824 | 2101802 | 37.7513076735554 | -122.433089295463 | (37.7513076735554, -122.433089295463) | 2 | 4 | 5 | 28862 | 22 | ||
158313 | 30787 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 488 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1995 12:00:00 AM | 3x3 | Permit Number 51964 | 6013865.01842582 | 2112595.14259648 | 37.7815633679001 | -122.395664068446 | (37.7815633679001, -122.395664068446) | 6 | 2 | 9 | 28856 | 6 | ||
158878 | 69022 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2094 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | Permit Number 33026 | 5981407.07152231 | 2100831.13487358 | 37.7474038185251 | -122.507078153918 | (37.7474038185251, -122.507078153918) | 1 | 8 | 3 | 29491 | 35 | ||
160162 | 33220 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 130 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | 1 | 8 | 4 | 59 | 40 | ||
160662 | 117457 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 90 NAVY RD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6018168 | 2093528 | 37.7294473579848 | -122.379452729346 | (37.7294473579848, -122.379452729346) | 10 | 3 | 8 | 58 | 1 | ||||
161363 | 254812 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 2595 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997881 | 2089586 | 37.7174838262402 | -122.449302633722 | (37.7174838262402, -122.449302633722) | 9 | 8 | 6 | 28861 | 24 | ||||
162723 | 114914 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200x MIDDLE POINT RD | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6017974 | 2095171 | 37.7339480130439 | -122.380237547959 | (37.7339480130439, -122.380237547959) | 10 | 3 | 8 | 58 | 1 | |||
166500 | 109495 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 342 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004048.2 | 2103384.6 | 37.7557224873033 | -122.428968694341 | (37.7557224873033, -122.428968694341) | 2 | 4 | 5 | 28862 | 22 | ||||
167115 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
167346 | 88605 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2719 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 52923 | 5991770.2 | 2096974.3 | 37.737418827963 | -122.470962580807 | (37.737418827963, -122.470962580807) | 1 | 8 | 4 | 29491 | 40 | ||
167497 | 51287 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 726 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 47659 | 5989465.45229129 | 2110387.70383509 | 37.7741148873605 | -122.479912367003 | (37.7741148873605, -122.479912367003) | 11 | 6 | 2 | 55 | 26 | ||
168866 | 60707 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1059 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/1983 12:00:00 AM | Permit Number 20357 | 6009209.04775492 | 2102998.94986664 | 37.754954349681 | -122.4110935285 | (37.754954349681, -122.4110935285) | 2 | 4 | 7 | 28859 | 19 | ||
170367 | 68260 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 330 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32066 | 6009617.65665916 | 2092860.11678258 | 37.7271382244341 | -122.408965114302 | (37.7271382244341, -122.408965114302) | 10 | 3 | 7 | 309 | 28 | ||
170435 | 66751 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1126 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30003 | 5998922.20523511 | 2106051.2337001 | 37.7627529185657 | -122.446887825215 | (37.7627529185657, -122.446887825215) | 15 | 5 | 5 | 29492 | 9 | ||
170920 | 111238 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 48X OAKHURST LN | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994967 | 2104000 | 37.7568940069608 | -122.460418748436 | (37.7568940069608, -122.460418748436) | 1 | 5 | 4 | 63 | 12 | ||||
172256 | 110178 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 321 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | 2 | 4 | 5 | 28859 | 19 | ||||
172792 | 112970 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1409 MCKINNON AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016184 | 2095282 | 37.7341538729229 | -122.386433919032 | (37.7341538729229, -122.386433919032) | 10 | 3 | 8 | 58 | 1 | |||||
173405 | 63699 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/1987 12:00:00 AM | Permit Number 24357 | 5993400.20760956 | 2105023.79114259 | 37.7596148153145 | -122.465911644507 | (37.7596148153145, -122.465911644507) | 1 | 8 | 4 | 56 | 12 | ||
174333 | 53071 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 530@ CAPITOL Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2006 12:00:00 AM | Permit Number 49042 | 5995240.54795335 | 2090593.06935713 | 37.7200976112635 | -122.458502260031 | (37.7200976112635, -122.458502260031) | 9 | 8 | 6 | 28861 | 24 | ||
174359 | 107852 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 150 APTOS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | 9 | 8 | 4 | 59 | 40 | ||||
175420 | 64980 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 50 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 26018 | 6005559.62367556 | 2099364.11059581 | 37.744768585112 | -122.423455890647 | (37.744768585112, -122.423455890647) | 2 | 7 | 5 | 28859 | 22 | ||
178439 | 107539 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 198X JENNINGS ST | 1 | Front Yard : Yard | Tree | DPW 1 | 6018784 | 2097136 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | 10 | 3 | 8 | 58 | 1 | |||||
178473 | 32831 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4259 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37188 | 6001527.35157379 | 2101718.97801883 | 37.7510060780925 | -122.437567299188 | (37.7510060780925, -122.437567299188) | 2 | 4 | 5 | 28862 | 22 | ||
179964 | 68255 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 235 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32060 | 6009537.98073102 | 2093299.04188101 | 37.7283389564803 | -122.409271515047 | (37.7283389564803, -122.409271515047) | 10 | 3 | 7 | 309 | 28 | ||
180688 | 32992 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
181933 | 112581 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 274X SAN MARCOS AVE | 2 | Median : Cutout | Tree | Private 2 | 3x20 | 5993121 | 2100271 | 37.7465487656332 | -122.466531821158 | (37.7465487656332, -122.466531821158) | 1 | 8 | 4 | 29491 | 40 | ||||
182225 | 63123 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 44 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1986 12:00:00 AM | Permit Number 23636 | 6007712.34207152 | 2099218.71581656 | 37.7444906318459 | -122.416001886054 | (37.7444906318459, -122.416001886054) | 2 | 7 | 7 | 28859 | 2 | ||
183570 | 107711 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1798X 31st Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | 1 | 8 | 3 | 56 | 35 | ||||
183646 | 99975 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2295 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
184159 | 55768 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 64 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2006 12:00:00 AM | Permit Number 48893 | 6004070.72244185 | 2102685.02755706 | 37.7538029009663 | -122.428840933443 | (37.7538029009663, -122.428840933443) | 2 | 4 | 5 | 28862 | 22 | ||
184426 | 32990 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
185978 | 65605 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 138 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | Permit Number 28509 | 6004309.62922812 | 2093740.61229591 | 37.7292571013758 | -122.427377609436 | (37.7292571013758, -122.427377609436) | 9 | 7 | 6 | 28861 | 5 | ||
186774 | 32991 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
187820 | 61115 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1106 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20962 | 6007608.55332469 | 2103202.26724843 | 37.7554227286129 | -122.416642908427 | (37.7554227286129, -122.416642908427) | 2 | 4 | 7 | 28859 | 19 | ||
189234 | 112390 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
189275 | 61657 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 162 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | Permit Number 21649 | 5993073.36079419 | 2114411.6730158 | 37.785372566948 | -122.467724802862 | (37.785372566948, -122.467724802862) | 11 | 6 | 2 | 54 | 11 | ||
189365 | 94382 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
190488 | 65550 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 292 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28449 | 5995404.07668865 | 2097513.82279858 | 37.7391097231572 | -122.458437696075 | (37.7391097231572, -122.458437696075) | 9 | 7 | 4 | 59 | 40 | ||
192628 | 121081 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 24X KEMPTON AVE | 5 | Side Yard : Yard | Tree | DPW 1 | 30x30 | 5992274 | 2087683 | 37.7119363308651 | -122.468544900416 | (37.7119363308651, -122.468544900416) | 9 | 8 | 4 | 64 | 24 | ||||
192906 | 61359 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | 5 | 1 | 10 | 28857 | 21 | ||
192976 | 253204 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2253 09th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5993186 | 2100608 | 37.7474778324271 | -122.466331547971 | (37.7474778324271, -122.466331547971) | 1 | 8 | 4 | 29491 | 40 | ||||
193103 | 251668 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 301x Laguna Honda Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995349 | 2100852 | 37.7482723626065 | -122.458869747183 | (37.7482723626065, -122.458869747183) | 1 | 5 | 4 | 63 | 40 | ||||
7446 | 243531 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2095 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6008748.77289 | 2106455.16153 | 37.764418495754 | -122.412929646495 | (37.764418495754, -122.412929646495) | 8 | 4 | 7 | 28859 | 19 | |||
43117 | 62644 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1255 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50627 | 5983022.3246657 | 2106594.48040873 | 37.7633233458854 | -122.501919183937 | (37.7633233458854, -122.501919183937) | 1 | 8 | 3 | 56 | 35 | |
164338 | 32593 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1375 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 1 | Permit Number 37061 | 5985530.1581728 | 2105866.8789552 | 37.7614725555795 | -122.493191928821 | (37.7614725555795, -122.493191928821) | 1 | 8 | 3 | 56 | 35 |
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) );