trees
3,965 rows where qSpecies_id = 70 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
148650 | 42069 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
109012 | 7699 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/1991 12:00:00 AM | 15 | 7x7 | 6008241.9422 | 2121047.1896 | 37.804456215657 | -122.415715918685 | (37.804456215657, -122.415715918685) | 5 | 1 | 10 | 308 | 23 | ||
69992 | 112618 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777210 | 6002384.2725 | 2115806.13213 | 37.7897346101096 | -122.435611691534 | (37.7897346101096, -122.435611691534) | 13 | 9 | 1 | 29490 | 27 | |
84675 | 42562 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 San Benito Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51025 | 5992910.18577839 | 2095362.95085697 | 37.7330603317539 | -122.46690404336 | (37.7330603317539, -122.46690404336) | 9 | 8 | 4 | 59 | 40 | ||
104514 | 87964 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
105134 | 87963 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 393 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50997 | 6008895 | 2121449 | 37.8055961756376 | -122.413484381593 | (37.8055961756376, -122.413484381593) | 3 | 1 | 10 | 308 | 23 | ||
142440 | 47878 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 41X 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45624 | 5990495.13219 | 2114853.70227 | 37.7864370505627 | -122.476676909352 | (37.7864370505627, -122.476676909352) | 11 | 6 | 1 | 55 | 33 | |
50299 | 14575 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1134 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1997 12:00:00 AM | 18 | 4X4 | 5999433.6283 | 2108924.6352 | 37.7706717613437 | -122.445325609236 | (37.7706717613437, -122.445325609236) | 15 | 5 | 11 | 29492 | 9 | ||
77281 | 10256 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/18/1998 12:00:00 AM | 30 | 3X3 | 6005382.9385 | 2109612.15 | 37.7728973211229 | -122.424795757535 | (37.7728973211229, -122.424795757535) | 7 | 9 | 11 | 28852 | 10 | ||
107377 | 7065 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1588 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/2014 12:00:00 AM | 30 | 3X3 | 5999848.9957 | 2109884.015 | 37.7733296774154 | -122.443957794129 | (37.7733296774154, -122.443957794129) | 15 | 5 | 11 | 29492 | 16 | ||
92600 | 56020 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2580 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 11 | Permit Number 12105 | 5996803.4076 | 2110776.9649 | 37.7756072847096 | -122.454557365701 | (37.7756072847096, -122.454557365701) | 15 | 6 | 2 | 54 | 16 | ||
162685 | 103476 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 147 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2013 12:00:00 AM | Permit Number 775299 | 6001179.7 | 2121217.2 | 37.8045234887457 | -122.440167571349 | (37.8045234887457, -122.440167571349) | 13 | 9 | 1 | 57 | 17 | |||
101045 | 116781 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778230 | 5997601.12717 | 2115625.0178 | 37.7889644837841 | -122.452147749912 | (37.7889644837841, -122.452147749912) | 11 | 6 | 1 | 54 | 31 | |
86132 | 5397 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 347 Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2014 12:00:00 AM | 30 | 6x6 | 6004921.39011 | 2106378.39566 | 37.7639921298444 | -122.42616204806 | (37.7639921298444, -122.42616204806) | 8 | 4 | 5 | 28859 | 19 | ||
90247 | 10486 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1672 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/1992 12:00:00 AM | 14 | 3X3 | 5998110.8706 | 2108597.7596 | 37.7696986484007 | -122.44987746519 | (37.7696986484007, -122.44987746519) | 15 | 5 | 11 | 29492 | 9 | ||
147671 | 116003 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 945 FRONT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | 3x3 | 6012663 | 2119386 | 37.8001425245044 | -122.400299613665 | (37.8001425245044, -122.400299613665) | 3 | 1 | 10 | 28860 | 6 | ||
66217 | 87839 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50724 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | ||
91561 | 34180 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | 13 | 6 | 1 | 29490 | 31 | |||
173722 | 250672 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781557 | 5986349.68151 | 2114864.86182 | 37.7862263710027 | -122.491019750162 | (37.7862263710027, -122.491019750162) | 11 | 6 | 1 | 55 | 33 | |
116894 | 34177 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 207 Maple St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1997 12:00:00 AM | 16 | Permit Number 38003 | 5996588.86091 | 2115573.89068 | 37.78876606454 | -122.455646338401 | (37.78876606454, -122.455646338401) | 11 | 6 | 1 | 54 | 31 | ||
85626 | 9376 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 312 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/1992 12:00:00 AM | 35 | 2X2 | 6001090.99664 | 2097832.55819 | 37.7403100728411 | -122.438797787215 | (37.7403100728411, -122.438797787215) | 2 | 7 | 5 | 63 | 7 | ||
140352 | 111337 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2178 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775561 | 5991058.1 | 2100603.7 | 37.7473430166558 | -122.473689301 | (37.7473430166558, -122.473689301) | 1 | 8 | 4 | 29491 | 40 | |
187313 | 49871 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2519SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 13 | 3x3 | Permit Number 50540 | 6001316.09409 | 2117246.4111 | 37.7936285135915 | -122.439410760611 | (37.7936285135915, -122.439410760611) | 13 | 9 | 1 | 29490 | 27 | |
165444 | 120228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 172 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781953 | 5988061.30942 | 2114851.82661 | 37.7862904310499 | -122.485097081718 | (37.7862904310499, -122.485097081718) | 11 | 6 | 1 | 55 | 33 | |
67722 | 120803 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 711 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | Width 2ft | 5989721.45934 | 2110495.24706 | 37.7744250415853 | -122.479034671677 | (37.7744250415853, -122.479034671677) | 11 | 6 | 2 | 55 | 26 | ||
2948 | 34162 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1321 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1997 12:00:00 AM | Permit Number 37995 | 6002005.24557776 | 2100252.01136141 | 37.7470052949129 | -122.435809748575 | (37.7470052949129, -122.435809748575) | 2 | 7 | 5 | 63 | 22 | |||
66144 | 220233 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Ashbury St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/23/1987 12:00:00 AM | 39 | Width 4ft | Permit Number 12054 | 5999170.85741 | 2106639.03394 | 37.7643810731487 | -122.446070109962 | (37.7643810731487, -122.446070109962) | 15 | 5 | 11 | 29492 | 9 | |
66355 | 124812 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3434 Baker St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/22/2019 12:00:00 AM | 3 | Width 3ft | 5999269.00527 | 2120608.31767 | 37.8027426982766 | -122.446735842084 | (37.8027426982766, -122.446735842084) | 13 | 9 | 1 | 57 | 17 | ||
91896 | 124813 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3434 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/22/2019 12:00:00 AM | 3 | Width 3ft | 5999267.34259 | 2120623.44736 | 37.802784145342 | -122.446742685044 | (37.802784145342, -122.446742685044) | 13 | 9 | 1 | 57 | 17 | ||
131261 | 104547 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 156 MADRONE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774728 | 5992588 | 2098182 | 37.7407821316344 | -122.468222919411 | (37.7407821316344, -122.468222919411) | 1 | 8 | 4 | 59 | 40 | |
180863 | 109131 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 156 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774728 | 5992631.8 | 2098170.8 | 37.740753908855 | -122.468070662321 | (37.740753908855, -122.468070662321) | 1 | 8 | 4 | 59 | 40 | |
142638 | 5601 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1120-1122 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2016 12:00:00 AM | 3 | 6X6 | 6005089.20528 | 2101804.2581 | 37.7514421059774 | -122.425256113291 | (37.7514421059774, -122.425256113291) | 2 | 4 | 5 | 28862 | 22 | ||
11658 | 6629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2013 12:00:00 AM | 17 | 4x4 | 6016652.34226 | 2097729.17939 | 37.7408992492988 | -122.38498513575 | (37.7408992492988, -122.38498513575) | 10 | 3 | 8 | 58 | 1 | ||
92108 | 65872 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 76 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1990 12:00:00 AM | 27 | Permit Number 28870 | 5996361.99979 | 2111724.55703 | 37.7781837973168 | -122.456152820686 | (37.7781837973168, -122.456152820686) | 11 | 6 | 2 | 54 | 16 | ||
112205 | 74759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Foerster St | 13 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 30 | 5x7 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
140886 | 47483 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1736 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 22 | Permit Number 45378 | 6002071.5211 | 2114540.3904 | 37.7862414391172 | -122.436603142325 | (37.7862414391172, -122.436603142325) | 13 | 6 | 1 | 29490 | 27 | |
77387 | 96356 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3622 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2011 12:00:00 AM | 2.5 x6 | 5999184 | 2121228 | 37.8044393220775 | -122.447074624063 | (37.8044393220775, -122.447074624063) | 13 | 9 | 1 | 57 | 17 | |||
63689 | 27070 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 801 Silver Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2000 12:00:00 AM | 6 | 4x15 | 6006926.95376 | 2093626.25966 | 37.7290907946921 | -122.418321164017 | (37.7290907946921, -122.418321164017) | 9 | 3 | 7 | 309 | 28 | ||
156355 | 36261 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 48818 | 5991187.85899012 | 2094553.0256484 | 37.7307369236006 | -122.472799488507 | (37.7307369236006, -122.472799488507) | 9 | 8 | 4 | 64 | 40 | ||
112352 | 5417 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/05/2013 12:00:00 AM | 24 | 6 | 6004853.9708326 | 2105864.857711 | 37.7625782660478 | -122.426358665446 | (37.7625782660478, -122.426358665446) | 8 | 4 | 5 | 28859 | 3 | ||
114240 | 8287 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1601 Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/2017 12:00:00 AM | 6 | 3x3 | 6015799.31492 | 2097666.33838 | 37.7406794801837 | -122.387930230222 | (37.7406794801837, -122.387930230222) | 10 | 3 | 8 | 58 | 1 | ||
184050 | 66480 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 127 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 30 | Permit Number 29809 | 5994252.33765 | 2114707.89192 | 37.7862539074759 | -122.463667435556 | (37.7862539074759, -122.463667435556) | 11 | 6 | 1 | 54 | 11 | ||
180703 | 22638 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1990 12:00:00 AM | 6 | 3X3 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
114499 | 98702 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3150 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2012 12:00:00 AM | 4x4 | Permit Number 768335 | 5999122.2 | 2116336.3 | 37.7910044917558 | -122.446936266113 | (37.7910044917558, -122.446936266113) | 13 | 6 | 1 | 29490 | 31 | ||
103937 | 51682 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2209 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | 15 | 3x3 | Permit Number 47962 | 6001952.8314 | 2114287.612 | 37.7855406286981 | -122.436995673401 | (37.7855406286981, -122.436995673401) | 13 | 6 | 11 | 29490 | 13 | |
165347 | 50952 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2340 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | Permit Number 47446 | 5992662.95043522 | 2099457.88176019 | 37.7442897076886 | -122.468056556621 | (37.7442897076886, -122.468056556621) | 1 | 8 | 4 | 29491 | 40 | |||
175180 | 203731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2342 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | 16 | Width 4ft | Permit Number 47446 | 5992657.79242 | 2099436.17889 | 37.7442298192534 | -122.468072813407 | (37.7442298192534, -122.468072813407) | 1 | 8 | 4 | 29491 | 40 | |
130547 | 98318 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | |
134464 | 98317 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773893 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | |
75907 | 40179 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1724 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1999 12:00:00 AM | 24 | Permit Number 41370 | 6002078.2803 | 2114497.9921 | 37.7861254083174 | -122.436576721435 | (37.7861254083174, -122.436576721435) | 13 | 6 | 1 | 29490 | 27 | ||
148722 | 68096 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2336 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1993 12:00:00 AM | 8 | Permit Number 31841 | 6004611.78604 | 2117244.74895 | 37.7938109545695 | -122.428007268927 | (37.7938109545695, -122.428007268927) | 13 | 9 | 1 | 28858 | 27 | ||
26685 | 324 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3470X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 20 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
32460 | 46703 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 332(North) Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2002 12:00:00 AM | Permit Number 44834 | 6005821.63060952 | 2110714.77999165 | 37.7759496446584 | -122.423356666691 | (37.7759496446584, -122.423356666691) | 7 | 9 | 11 | 28852 | 10 | |||
21261 | 55934 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2665 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1973 12:00:00 AM | 9 | Permit Number 11998 | 5986719.3111 | 2097252.7279 | 37.7378899014651 | -122.488446087215 | (37.7378899014651, -122.488446087215) | 1 | 8 | 3 | 29491 | 35 | ||
32061 | 49500 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 3x3 | Permit Number 46414 | 5994271.00866961 | 2115572.53954866 | 37.7886290700296 | -122.463665616673 | (37.7886290700296, -122.463665616673) | 11 | 6 | 1 | 54 | 11 | ||
74766 | 49501 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 3x3 | Permit Number 46414 | 5994271.00866961 | 2115572.53954866 | 37.7886290700296 | -122.463665616673 | (37.7886290700296, -122.463665616673) | 11 | 6 | 1 | 54 | 11 | ||
61043 | 68013 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.95817 | 2120820.40604 | 37.8033370269329 | -122.446024564694 | (37.8033370269329, -122.446024564694) | 13 | 9 | 1 | 57 | 17 | ||
39146 | 50877 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2601on STEINER Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2004 12:00:00 AM | 14 | Permit Number 47387 | 6002325.56696 | 2115734.74753 | 37.789535271782 | -122.435809697086 | (37.789535271782, -122.435809697086) | 13 | 6 | 1 | 29490 | 27 | ||
73455 | 51704 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 171 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2016 12:00:00 AM | 3 | Permit Number 777735 | 6001742.29918465 | 2107821.21142041 | 37.7677735488102 | -122.437260877297 | (37.7677735488102, -122.437260877297) | 15 | 5 | 5 | 29492 | 3 | ||
100260 | 49664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3630 Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 26 | Permit Number 46510 | 6000238.4271 | 2120737.06693 | 37.8031515390838 | -122.443390413534 | (37.8031515390838, -122.443390413534) | 13 | 9 | 1 | 57 | 17 | ||
129109 | 52614 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 230@ AVILA Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2006 12:00:00 AM | 10 | Permit Number 48779 | 6000874.42374 | 2121481.75095 | 37.8052324902599 | -122.441242997973 | (37.8052324902599, -122.441242997973) | 13 | 9 | 1 | 57 | 17 | ||
19338 | 65714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1990 12:00:00 AM | 16 | Permit Number 28646 | 5990406.78353 | 2113406.96053 | 37.7824595769169 | -122.476876823137 | (37.7824595769169, -122.476876823137) | 11 | 6 | 2 | 55 | 26 | ||
83887 | 110557 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 600 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777830 | 5987235.91404 | 2111803.79765 | 37.7778732980336 | -122.487728686455 | (37.7778732980336, -122.487728686455) | 11 | 6 | 2 | 55 | 26 | |
66013 | 46614 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Sola Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2002 12:00:00 AM | Permit Number 44737 | 5995007.33907927 | 2100649.9152063 | 37.7476978436736 | -122.460036555222 | (37.7476978436736, -122.460036555222) | 1 | 8 | 4 | 29491 | 40 | |||
100329 | 51666 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 | |||
121826 | 51665 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 444 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2005 12:00:00 AM | Permit Number 47943 | 5998559.54409269 | 2106579.38545488 | 37.7641823653154 | -122.448180168308 | (37.7641823653154, -122.448180168308) | 15 | 5 | 11 | 29492 | 9 | |||
92771 | 30421 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 530 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1956 12:00:00 AM | Permit Number 75 | 6009285.11323863 | 2120849.80325768 | 37.803972827811 | -122.412091961384 | (37.803972827811, -122.412091961384) | 3 | 1 | 10 | 308 | 23 | |||
114203 | 6023 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1785X Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/1993 12:00:00 AM | 18 | 3X3 | 6001921.74709 | 2112555.02371 | 37.7807816147859 | -122.436979132236 | (37.7807816147859, -122.436979132236) | 15 | 5 | 11 | 29490 | 41 | ||
180913 | 31199 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 31 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | 19 | Permit Number 34890 | 5998530.7281 | 2106872.07801 | 37.7649843779477 | -122.448300912461 | (37.7649843779477, -122.448300912461) | 15 | 5 | 11 | 29492 | 9 | ||
183452 | 31197 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 31 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | 21 | Permit Number 34890 | 5998546.82061 | 2106872.64956 | 37.7649868672854 | -122.448245293891 | (37.7649868672854, -122.448245293891) | 15 | 5 | 11 | 29492 | 9 | ||
60879 | 6836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1475 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3X3 | 6016046.71071 | 2097829.88517 | 37.7411422488076 | -122.387086226361 | (37.7411422488076, -122.387086226361) | 10 | 3 | 8 | 58 | 1 | ||
70005 | 116118 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700x NEWHALL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | 6013898 | 2095214 | 37.7338403506101 | -122.394332641739 | (37.7338403506101, -122.394332641739) | 10 | 3 | 8 | 58 | 1 | ||
133418 | 29972 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500X Junipero Serra Blvd | 16 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991341.172 | 2093706.68724 | 37.7284219643784 | -122.472207797253 | (37.7284219643784, -122.472207797253) | 9 | 8 | 4 | 64 | 40 | ||
186118 | 91400 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Maple St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52096 | 5996639.65876 | 2115525.86158 | 37.7886371044596 | -122.455467113417 | (37.7886371044596, -122.455467113417) | 11 | 6 | 1 | 54 | 31 | |
101676 | 10451 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1552 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2006 12:00:00 AM | 18 | 3x3 | 5998701.9695 | 2108681.2867 | 37.7699617956519 | -122.447838894996 | (37.7699617956519, -122.447838894996) | 15 | 5 | 11 | 29492 | 9 | ||
23222 | 53937 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 174 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 12 | 3x4 | Permit Number 9651 | 5993070.40109 | 2114326.65829 | 37.7851389689099 | -122.467728857293 | (37.7851389689099, -122.467728857293) | 11 | 6 | 2 | 54 | 11 | |
93005 | 25437 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2555 Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/1998 12:00:00 AM | 3 | 3x3 | 6010830.95304 | 2086585.06609 | 37.7099761086624 | -122.404329257674 | (37.7099761086624, -122.404329257674) | 10 | 3 | 8 | 309 | 1 | ||
54548 | 28654 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1275 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2004 12:00:00 AM | 3 | 6x3 | 6017442.42343 | 2097139.52518 | 37.739323847514 | -122.38221228939 | (37.739323847514, -122.38221228939) | 10 | 3 | 8 | 58 | 1 | ||
108199 | 22617 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.7814583745998 | -122.424145957729 | (37.7814583745998, -122.424145957729) | 7 | 9 | 11 | 28852 | 41 | ||
52641 | 30419 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
68481 | 30420 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
65596 | 52661 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1596 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 7x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | 1 | 8 | 4 | 56 | 12 | ||
98534 | 52660 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1596 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 5.5x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | 1 | 8 | 4 | 56 | 12 | ||
175572 | 89458 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3500X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987773.9063 | 2111900.87116 | 37.7781711994801 | -122.485874733482 | (37.7781711994801, -122.485874733482) | 11 | 6 | 2 | 55 | 26 | ||
60143 | 44378 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2914 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2001 12:00:00 AM | Permit Number 43741 | 6000185.55647701 | 2116798.34873064 | 37.7923338489092 | -122.443290306111 | (37.7923338489092, -122.443290306111) | 13 | 6 | 1 | 29490 | 27 | |||
25335 | 87291 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
88938 | 87293 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
123206 | 87292 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
148946 | 50822 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 240 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | 14 | Permit Number 47343 | 6000834.36183 | 2121507.8753 | 37.8053019385925 | -122.441383512537 | (37.8053019385925, -122.441383512537) | 13 | 9 | 1 | 57 | 17 | ||
8511 | 60095 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3343 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1982 12:00:00 AM | 10 | Permit Number 19596 | 5998235.21709 | 2116151.87187 | 37.7904473875938 | -122.449991880723 | (37.7904473875938, -122.449991880723) | 13 | 6 | 1 | 54 | 31 | |
18948 | 51496 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.440129480361 | (37.773809648853, -122.440129480361) | 15 | 5 | 11 | 29492 | 10 | |||
104200 | 51634 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 77 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47924 | 6005437.59121376 | 2109217.8235753 | 37.7718176826133 | -122.424578652037 | (37.7718176826133, -122.424578652037) | 7 | 9 | 5 | 28852 | 10 | |||
85871 | 24225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.40196 | 2094982.30239 | 37.7333853506538 | -122.383013103287 | (37.7333853506538, -122.383013103287) | 10 | 3 | 8 | 58 | 1 | ||
15697 | 40095 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | 13 | 6 | 11 | 29490 | 13 | |||
26922 | 40094 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | 13 | 6 | 11 | 29490 | 13 | |||
7938 | 369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
48296 | 11709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.40868 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | 9 | 8 | 4 | 64 | 40 | ||
183780 | 218318 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 407 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/07/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782718 | 5993261.50766 | 2099931.86652 | 37.7456256983858 | -122.466021325821 | (37.7456256983858, -122.466021325821) | 1 | 8 | 4 | 29491 | 40 | |
143678 | 68937 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847409 | (37.7784180283155, -122.46938847409) | 11 | 6 | 2 | 54 | 11 | |
69834 | 7648 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3303 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1999 12:00:00 AM | 3 | 4x4 | 6008513.3556 | 2099374.88287 | 37.7449644349621 | -122.413243176241 | (37.7449644349621, -122.413243176241) | 2 | 7 | 7 | 28859 | 2 |
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) );