trees
246 rows where qSpecies_id = 20 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
149031 | 177298 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988403.4281 | 2091243.72009 | 37.721488831717 | -122.482183231171 | (37.721488831717, -122.482183231171) | 1 | 8 | 4 | 64 | 14 | ||||
166087 | 48710 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45977 | 6002865.90865477 | 2096146.69511849 | 37.735781899273 | -122.432540466241 | (37.735781899273, -122.432540466241) | 2 | 7 | 5 | 63 | 7 | |||
138010 | 95988 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 10 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767640 | 6007158.9 | 2099647 | 37.7456354723022 | -122.417945934991 | (37.7456354723022, -122.417945934991) | 2 | 7 | 7 | 28859 | 2 | ||
84061 | 229220 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 10 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007188.55641 | 2099623.37433 | 37.7455722705428 | -122.417841712947 | (37.7455722705428, -122.417841712947) | 2 | 7 | 7 | 28859 | 2 | |||
97114 | 208543 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 100 Vista Verde Ct | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999208.78816 | 2096056.42924 | 37.7353259823914 | -122.445178028358 | (37.7353259823914, -122.445178028358) | 9 | 7 | 4 | 63 | 40 | |||
25342 | 7018 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1055 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 2 | 3X3 | 6002378.8301 | 2110180.8206 | 37.7742886166676 | -122.435227992558 | (37.7742886166676, -122.435227992558) | 15 | 5 | 11 | 29492 | 10 | ||
104254 | 7016 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1055 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6002352.4572 | 2110178.4231 | 37.7742805360567 | -122.43531904959 | (37.7742805360567, -122.43531904959) | 15 | 5 | 11 | 29492 | 10 | |||
32343 | 229262 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 108 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004703.69496 | 2102959.30971 | 37.7545918213685 | -122.426671498699 | (37.7545918213685, -122.426671498699) | 2 | 4 | 5 | 28862 | 22 | |||
142205 | 200499 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1082 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6013591.41 | 2089958.2062 | 37.7193919575312 | -122.395024624648 | (37.7193919575312, -122.395024624648) | 10 | 3 | 8 | 58 | 1 | |||
30911 | 39141 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1088 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40819 | 6007414.12012463 | 2100977.25645313 | 37.7493024177021 | -122.417157664156 | (37.7493024177021, -122.417157664156) | 2 | 4 | 7 | 28859 | 19 | ||
160538 | 17695 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1100X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2004 12:00:00 AM | 3 | 3X3 | 6002388.932052 | 2112303.174651 | 37.7801166436013 | -122.435344894499 | (37.7801166436013, -122.435344894499) | 15 | 5 | 11 | 29490 | 41 | ||
25917 | 123969 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993630.62281 | 2114735.81846 | 37.7862947425232 | -122.46582041968 | (37.7862947425232, -122.46582041968) | 11 | 6 | 2 | 54 | 11 | |||
62848 | 177296 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 Newton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000995.34675 | 2087902.8646 | 37.7130399628101 | -122.438417271438 | (37.7130399628101, -122.438417271438) | 9 | 7 | 6 | 28861 | 5 | |||
76828 | 177295 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001002.00553 | 2087880.82642 | 37.7129798296258 | -122.438392678593 | (37.7129798296258, -122.438392678593) | 9 | 7 | 6 | 28861 | 5 | |||
79567 | 137580 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1150 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002381.2868 | 2112341.0686 | 37.7802202566686 | -122.435374054285 | (37.7802202566686, -122.435374054285) | 15 | 5 | 11 | 29490 | 41 | |||
115190 | 97119 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
157092 | 97121 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
184259 | 97120 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
19877 | 246803 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6010372.78366 | 2099322.13571 | 37.7449238197814 | -122.406809864293 | (37.7449238197814, -122.406809864293) | 2 | 7 | 7 | 28859 | 2 | |||
63595 | 37844 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40136 | 6010376.80138594 | 2099288.55656196 | 37.7448318435542 | -122.406793605579 | (37.7448318435542, -122.406793605579) | 2 | 7 | 7 | 28859 | 2 | ||
86063 | 37843 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40136 | 6010376.80138594 | 2099288.55656196 | 37.7448318435542 | -122.406793605579 | (37.7448318435542, -122.406793605579) | 2 | 7 | 7 | 28859 | 2 | ||
131472 | 246804 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 2 | : | Tree | Private 2 | 5 | Width 2ft | 6010378.07148 | 2099339.08892 | 37.7449706654762 | -122.406792774468 | (37.7449706654762, -122.406792774468) | 2 | 7 | 7 | 28859 | 2 | |||
164273 | 208552 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Vernon St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5992432.90306 | 2088632.12991 | 37.7145515909498 | -122.468064688039 | (37.7145515909498, -122.468064688039) | 9 | 8 | 6 | 64 | 24 | |||
109410 | 43909 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1179 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43508 | 6008693.56566701 | 2101689.35157322 | 37.7513295663287 | -122.412783637177 | (37.7513295663287, -122.412783637177) | 2 | 4 | 7 | 28859 | 19 | ||
58877 | 208545 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 12 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5996523.6042 | 2089967.17912 | 37.7184527177873 | -122.454022014425 | (37.7184527177873, -122.454022014425) | 9 | 8 | 6 | 28861 | 24 | |||
184176 | 208546 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 12 Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5996523.78627 | 2089975.89779 | 37.7184766676518 | -122.454022014422 | (37.7184766676518, -122.454022014422) | 9 | 8 | 6 | 28861 | 24 | |||
89049 | 177289 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1200 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999793.10154 | 2090324.86823 | 37.719621778009 | -122.442746423415 | (37.719621778009, -122.442746423415) | 9 | 7 | 6 | 28861 | 25 | |||
136520 | 208542 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1201 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995837.91455 | 2092068.13773 | 37.7241821115032 | -122.456543992205 | (37.7241821115032, -122.456543992205) | 9 | 7 | 4 | 28861 | 40 | |||
180489 | 208541 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1201 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995841.38448 | 2092081.24928 | 37.7242183119117 | -122.456532944957 | (37.7242183119117, -122.456532944957) | 9 | 7 | 4 | 28861 | 40 | |||
171270 | 208540 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1205 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995843.60881 | 2092100.29717 | 37.7242707405805 | -122.456526632611 | (37.7242707405805, -122.456526632611) | 9 | 7 | 4 | 28861 | 40 | |||
70046 | 40802 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 121 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | 4 | Permit Number 41751 | 5996513.2556 | 2113630.7306 | 37.7834263270019 | -122.455767400466 | (37.7834263270019, -122.455767400466) | 11 | 6 | 1 | 54 | 31 | ||
37036 | 177300 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001639.62994 | 2087602.93432 | 37.7122530470215 | -122.436168967218 | (37.7122530470215, -122.436168967218) | 9 | 7 | 6 | 28861 | 5 | |||
73392 | 177301 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001599.00625 | 2087595.59489 | 37.7122305864419 | -122.436308849585 | (37.7122305864419, -122.436308849585) | 9 | 7 | 6 | 28861 | 5 | |||
159248 | 177299 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001664.56674 | 2087607.40628 | 37.7122667427937 | -122.43608309818 | (37.7122667427937, -122.43608309818) | 9 | 7 | 6 | 28861 | 5 | |||
12536 | 43291 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 123 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 7 | Permit Number 43059 | 6013181.78147 | 2106427.07637 | 37.7645892203513 | -122.397595020318 | (37.7645892203513, -122.397595020318) | 14 | 3 | 8 | 28856 | 29 | |
59467 | 41687 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 124 Saturn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42140 | 5999927.88161805 | 2106008.33179804 | 37.7626925227356 | -122.443406475957 | (37.7626925227356, -122.443406475957) | 15 | 5 | 5 | 28862 | 3 | ||
53896 | 42075 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 125 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2005 12:00:00 AM | Permit Number 42387 | 6009870.15357172 | 2099865.41345763 | 37.7463874047531 | -122.408586191488 | (37.7463874047531, -122.408586191488) | 2 | 7 | 7 | 28859 | 2 | ||
35 | 16620 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 125 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/1999 12:00:00 AM | 6 | 3X3 | 6002913 | 2107540 | 37.7670678918229 | -122.433191472284 | (37.7670678918229, -122.433191472284) | 15 | 5 | 5 | 28862 | 3 | ||
30930 | 192814 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1251 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013571.38168 | 2106139.70119 | 37.7638218378314 | -122.396227345714 | (37.7638218378314, -122.396227345714) | 14 | 3 | 8 | 28856 | 29 | |||
178625 | 192813 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1251 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013542.5057 | 2106139.39713 | 37.7638193961669 | -122.396327198343 | (37.7638193961669, -122.396327198343) | 14 | 3 | 8 | 28856 | 29 | |||
83083 | 40054 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1294 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41290 | 6016570.04020415 | 2092976.75616645 | 37.7278454926494 | -122.384938693931 | (37.7278454926494, -122.384938693931) | 10 | 3 | 8 | 58 | 1 | ||
54737 | 84949 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1305 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1983 12:00:00 AM | 3x3 | Permit Number 49351 | 6009354 | 2101579 | 37.7510636126747 | -122.410491979069 | (37.7510636126747, -122.410491979069) | 2 | 4 | 7 | 28859 | 19 | ||
38714 | 229260 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1325 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009552.03774 | 2101426.1917 | 37.7506551353331 | -122.409796356326 | (37.7506551353331, -122.409796356326) | 2 | 4 | 7 | 28859 | 19 | |||
48773 | 229219 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1342 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 15 | Width 2ft | Permit Number 42176 | 6006959.38912 | 2107664.54838 | 37.7676385821924 | -122.419204437651 | (37.7676385821924, -122.419204437651) | 8 | 4 | 7 | 28853 | 19 | |
103553 | 41737 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1342-1344 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42176 | 6006947.20300055 | 2107647.30575448 | 37.767590551717 | -122.419245364711 | (37.767590551717, -122.419245364711) | 8 | 4 | 7 | 28853 | 19 | ||
120165 | 48972 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 135 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 46159 | 6003310.63727526 | 2108787.86549198 | 37.7705167748166 | -122.431905219461 | (37.7705167748166, -122.431905219461) | 15 | 9 | 5 | 29492 | 9 | ||
22680 | 46900 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1357 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44956 | 5991106.29954004 | 2106174.99705817 | 37.7626431240146 | -122.473929035532 | (37.7626431240146, -122.473929035532) | 1 | 8 | 11 | 56 | 12 | ||
125022 | 229258 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 143 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004624.04074 | 2097533.11714 | 37.7396882447137 | -122.426560605103 | (37.7396882447137, -122.426560605103) | 2 | 7 | 5 | 63 | 7 | |||
33431 | 39987 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1430 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 6 | Permit Number 41245 | 6017109.13931221 | 2093820.25947236 | 37.7301913909688 | -122.383133682915 | (37.7301913909688, -122.383133682915) | 10 | 3 | 8 | 58 | 1 | |
19604 | 78246 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1447 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5999064.52078 | 2089547.19331 | 37.7174448988403 | -122.445208973141 | (37.7174448988403, -122.445208973141) | 9 | 7 | 6 | 28861 | 25 | |||
60221 | 50521 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47159 | 5996798.3759 | 2112040.3174 | 37.7790758310411 | -122.454666063431 | (37.7790758310411, -122.454666063431) | 15 | 6 | 2 | 54 | 16 | |
28278 | 49981 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
33104 | 49982 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
113052 | 49980 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
158347 | 49979 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
102327 | 36962 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 146 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 7 | Permit Number 39591 | 5994303.22649 | 2114557.05479 | 37.785842681857 | -122.463480424277 | (37.785842681857, -122.463480424277) | 11 | 6 | 1 | 54 | 11 | |
164546 | 208548 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 150 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5995469.48283 | 2089658.18964 | 37.7175438071807 | -122.457643306389 | (37.7175438071807, -122.457643306389) | 9 | 8 | 6 | 28861 | 24 | |||
80382 | 37200 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1523 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 0 | Permit Number 39767 | 5986185.22517174 | 2104866.53832379 | 37.7587641880882 | -122.490852744095 | (37.7587641880882, -122.490852744095) | 1 | 8 | 3 | 56 | 35 | |
30847 | 229218 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 154 Julian Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006411.90444 | 2106966.83782 | 37.7656919861306 | -122.42104857575 | (37.7656919861306, -122.42104857575) | 8 | 4 | 7 | 28853 | 19 | |||
80931 | 41295 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 154 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41972 | 6006408.35563549 | 2106971.5871641 | 37.7657048266582 | -122.421061187567 | (37.7657048266582, -122.421061187567) | 8 | 4 | 7 | 28853 | 19 | ||
187508 | 229254 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 157 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001282.99504 | 2106223.75237 | 37.7633611996826 | -122.438735069383 | (37.7633611996826, -122.438735069383) | 15 | 5 | 5 | 28862 | 3 | |||
124243 | 37205 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1579 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 4 | Permit Number 39772 | 5986201.0748 | 2104494.9459 | 37.7577448234718 | -122.490770587951 | (37.7577448234718, -122.490770587951) | 1 | 8 | 3 | 56 | 35 | |
125651 | 229245 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1604 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005879.33617 | 2099593.72705 | 37.7454170997346 | -122.422366695864 | (37.7454170997346, -122.422366695864) | 2 | 7 | 5 | 28859 | 22 | |||
22730 | 4491 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1608 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 3 | 3X3 | 6004562.86857 | 2099453.04475 | 37.7449564687567 | -122.426908813616 | (37.7449564687567, -122.426908813616) | 2 | 7 | 5 | 63 | 22 | ||
87645 | 229235 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1626 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003320.17625 | 2098729.19184 | 37.7428985924036 | -122.431154158661 | (37.7428985924036, -122.431154158661) | 2 | 7 | 5 | 63 | 22 | |||
87868 | 40029 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1637 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 3 | Permit Number 41272 | 6014869.44662 | 2095922.83463 | 37.7358406185575 | -122.391023557209 | (37.7358406185575, -122.391023557209) | 10 | 3 | 8 | 58 | 1 | |
50140 | 177288 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 170 Lawrence Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5996808.94464 | 2087276.43363 | 37.7110809120333 | -122.452841609247 | (37.7110809120333, -122.452841609247) | 9 | 7 | 6 | 28861 | 25 | |||
12464 | 229252 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 171 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001736.09856 | 2107829.47275 | 37.7677958798953 | -122.43728291608 | (37.7677958798953, -122.43728291608) | 15 | 5 | 5 | 29492 | 3 | |||
15774 | 208544 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 171 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999615.39289 | 2094047.29924 | 37.7298325824993 | -122.443627964962 | (37.7298325824993, -122.443627964962) | 9 | 7 | 4 | 63 | 40 | |||
49315 | 141042 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996531.5303 | 2113164.047 | 37.7821459864366 | -122.45567043332 | (37.7821459864366, -122.45567043332) | 11 | 6 | 1 | 54 | 31 | |||
109450 | 68582 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32479 | 5996530.1767 | 2113176.907 | 37.7821812189094 | -122.455676045985 | (37.7821812189094, -122.455676045985) | 11 | 6 | 1 | 54 | 31 | ||
184881 | 177297 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 Nueva Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012935.72172 | 2087140.54754 | 37.7116187434797 | -122.397093648265 | (37.7116187434797, -122.397093648265) | 10 | 3 | 8 | 309 | 1 | |||
3119 | 264752 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
7535 | 264754 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
18449 | 264755 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
30898 | 254205 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1766 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982566.32735 | 2103096.10961 | 37.7536910129268 | -122.503237266994 | (37.7536910129268, -122.503237266994) | 1 | 8 | 3 | 56 | 35 | ||||
186826 | 254204 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1766 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781022 | 5982566.32735 | 2103096.10961 | 37.7536910129268 | -122.503237266994 | (37.7536910129268, -122.503237266994) | 1 | 8 | 3 | 56 | 35 | |
108785 | 141622 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1801 GROVE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998881.826 | 2110394.3314 | 37.7746756578154 | -122.447340091401 | (37.7746756578154, -122.447340091401) | 15 | 5 | 11 | 29492 | 16 | |||
136825 | 141620 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1801 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998848.2105 | 2110389.4859 | 37.7746604323894 | -122.447456024852 | (37.7746604323894, -122.447456024852) | 15 | 5 | 11 | 29492 | 16 | |||
162731 | 27135 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1921 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1999 12:00:00 AM | 7 | 2X3 | 6011851.93655 | 2095690.98382 | 37.7350361003237 | -122.401440051024 | (37.7350361003237, -122.401440051024) | 10 | 3 | 8 | 58 | 1 | ||
177265 | 21847 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 202X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 3 | 3X3 | 5994968.90714 | 2110807.33222 | 37.7755852784786 | -122.460905507707 | (37.7755852784786, -122.460905507707) | 11 | 6 | 2 | 54 | 11 | ||
5802 | 62147 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2057 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 3 | Permit Number 22261 | 5999361.52655 | 2121151.92571 | 37.8042405839018 | -122.446454803956 | (37.8042405839018, -122.446454803956) | 13 | 9 | 1 | 57 | 17 | |
7571 | 237826 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 210 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 785232 | 6002395.63458 | 2097149.51403 | 37.7385087290057 | -122.434238055364 | (37.7385087290057, -122.434238055364) | 2 | 7 | 5 | 63 | 7 | |
53505 | 229257 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 210 Moffitt St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002381.14665 | 2097165.58245 | 37.7385520268501 | -122.434289296035 | (37.7385520268501, -122.434289296035) | 2 | 7 | 5 | 63 | 7 | |||
52323 | 130435 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2127 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6003305.56754 | 2117513.80582 | 37.7944757298119 | -122.432546129322 | (37.7944757298119, -122.432546129322) | 13 | 9 | 1 | 29490 | 27 | |||
77081 | 44219 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2139 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 43665 | 5987260.984 | 2100720.2895 | 37.7474424963194 | -122.486827848138 | (37.7474424963194, -122.486827848138) | 1 | 8 | 3 | 29491 | 35 | |||
185492 | 44220 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2139 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2001 12:00:00 AM | 2 | Permit Number 43665 | 5987262.4786 | 2100698.6187 | 37.74738308124 | -122.486821088856 | (37.74738308124, -122.486821088856) | 1 | 8 | 3 | 29491 | 35 | ||
100896 | 45081 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2143 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43964 | 5987260.68011287 | 2100690.67520581 | 37.7473611656774 | -122.486826724588 | (37.7473611656774, -122.486826724588) | 1 | 8 | 3 | 29491 | 35 | ||
193435 | 45082 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2143 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43964 | 5987260.68011287 | 2100690.67520581 | 37.7473611656774 | -122.486826724588 | (37.7473611656774, -122.486826724588) | 1 | 8 | 3 | 29491 | 35 | ||
42561 | 130436 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2201 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007584.36539 | 2119972.20513 | 37.8014675927187 | -122.417915277469 | (37.8014675927187, -122.417915277469) | 5 | 1 | 1 | 28858 | 32 | |||
141863 | 130437 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2201 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007591.42221 | 2119948.52727 | 37.8014029764228 | -122.417889178244 | (37.8014029764228, -122.417889178244) | 5 | 1 | 1 | 28858 | 32 | |||
11239 | 260905 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007589.07412 | 2119959.01259 | 37.8014316343257 | -122.417898047397 | (37.8014316343257, -122.417898047397) | 5 | 1 | 1 | 28858 | 32 | ||
13810 | 115990 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 2x4 | Permit Number 777665 | 6007568.4 | 2119969.3 | 37.8014587174384 | -122.417970318963 | (37.8014587174384, -122.417970318963) | 5 | 1 | 1 | 28858 | 32 | |
103779 | 115991 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 2x4 | Permit Number 777665 | 6007568.4 | 2119969.3 | 37.8014587174384 | -122.417970318963 | (37.8014587174384, -122.417970318963) | 5 | 1 | 1 | 28858 | 32 | |
12190 | 260906 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2215 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007586.25473 | 2119982.21322 | 37.8014951787433 | -122.417909449339 | (37.8014951787433, -122.417909449339) | 5 | 1 | 1 | 28858 | 32 | ||
154896 | 229237 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 224 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004172.07476 | 2097038.42996 | 37.7383043850279 | -122.428088066711 | (37.7383043850279, -122.428088066711) | 2 | 7 | 5 | 63 | 7 | |||
70784 | 52521 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 225 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 6 | Permit Number 48914 | 6000062.86091 | 2091491.3711 | 37.7228401035632 | -122.441897645058 | (37.7228401035632, -122.441897645058) | 9 | 7 | 6 | 28861 | 25 | |
124056 | 52522 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 225 Onondaga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | 4 | Permit Number 48622 | 6000078.51361 | 2091484.10329 | 37.7228210397476 | -122.441843015763 | (37.7228210397476, -122.441843015763) | 9 | 7 | 6 | 28861 | 25 | ||
171110 | 177290 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 231 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004061.30791 | 2089085.46996 | 37.7164610594049 | -122.427904501587 | (37.7164610594049, -122.427904501587) | 9 | 7 | 6 | 28861 | 5 | |||
85882 | 18881 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2323 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2009 12:00:00 AM | 3 | 2X2 | 6003542.78856 | 2115901.08421 | 37.7900610577291 | -122.431610123004 | (37.7900610577291, -122.431610123004) | 13 | 9 | 1 | 29490 | 27 |
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) );