trees
256 rows where qSpecies_id = 51 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107 | 264818 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 101x Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | |||||||||||||
12643 | 264817 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 101x Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | |||||||||||||
32611 | 10252 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 124 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005490.6368 | 2109629.255 | 37.7729503696302 | -122.424424432873 | (37.7729503696302, -122.424424432873) | 7 | 9 | 11 | 28852 | 10 | |||
32955 | 244933 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 276 Page St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | Width 0ft | 6005244.6732 | 2109942.1819 | 37.7737956984536 | -122.425297523476 | (37.7737956984536, -122.425297523476) | 7 | 9 | 11 | 28852 | 10 | ||
41057 | 244931 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 269 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005260.1713 | 2110078.6254 | 37.7741712147751 | -122.42525362408 | (37.7741712147751, -122.42525362408) | 7 | 9 | 11 | 28852 | 10 | |||
111085 | 10251 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 120 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6005509.0088 | 2109632.4226 | 37.7729601045446 | -122.424361107182 | (37.7729601045446, -122.424361107182) | 7 | 9 | 11 | 28852 | 10 | |||
121519 | 121218 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 441 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005284 | 2110767 | 37.7760626702732 | -122.425220189207 | (37.7760626702732, -122.425220189207) | 7 | 9 | 11 | 28852 | 10 | ||||
145244 | 138934 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 640 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004774.0843 | 2110917.8533 | 37.7764480564968 | -122.426994870545 | (37.7764480564968, -122.426994870545) | 7 | 9 | 11 | 28852 | 10 | |||
181145 | 244934 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 269 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005246.8004 | 2110075.5866 | 37.7741621155787 | -122.425299660149 | (37.7741621155787, -122.425299660149) | 7 | 9 | 11 | 28852 | 10 | |||
1333 | 152105 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 99 Woodward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6006517.15656 | 2107967.63961 | 37.7684458838038 | -122.420755586526 | (37.7684458838038, -122.420755586526) | 8 | 4 | 7 | 28853 | 19 | |||
9302 | 152106 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 99 Woodward St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6006515.83678 | 2107993.45255 | 37.7685166856291 | -122.420761984296 | (37.7685166856291, -122.420761984296) | 8 | 4 | 7 | 28853 | 19 | |||
14771 | 152104 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 99 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6006517.82562 | 2107949.84717 | 37.7683970676925 | -122.420752009018 | (37.7683970676925, -122.420752009018) | 8 | 4 | 7 | 28853 | 19 | |||
67276 | 107894 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 230X 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 | |
103410 | 107897 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 230X 11th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 | |
103655 | 107895 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 230X 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 | |
108618 | 107896 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 230X 11th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 | |
129348 | 251179 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
138609 | 251178 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007668 | 2109797 | 37.7735336727503 | -122.41690453761 | (37.7735336727503, -122.41690453761) | 8 | 2 | 9 | 28853 | 19 | ||||
165144 | 107893 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 73X Kissling St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998917 | (37.7726012817916, -122.41519998917) | 8 | 2 | 9 | 28853 | 19 |
3836 | 261734 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 540 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
4604 | 261733 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 540 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
89512 | 116065 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/30/2018 12:00:00 AM | 3 | 8x7 | 6011274.01561 | 2105377.63125 | 37.7616012651139 | -122.404119643106 | (37.7616012651139, -122.404119643106) | 10 | 3 | 8 | 28856 | 29 | |
106425 | 116064 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/30/2018 12:00:00 AM | 3 | 8x7 | 6011272.30638 | 2105412.17877 | 37.7616960293658 | -122.404127986133 | (37.7616960293658, -122.404127986133) | 10 | 3 | 8 | 28856 | 29 | |
117414 | 122753 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 693 Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 15 | 6011277.81019 | 2105311.62173 | 37.7614202297665 | -122.404101873421 | (37.7614202297665, -122.404101873421) | 10 | 3 | 8 | 28856 | 29 | |||
140468 | 150667 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 549 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781211 | 6011817.87875 | 2105812.76187 | 37.7628264097369 | -122.40226922595 | (37.7628264097369, -122.40226922595) | 8 | 3 | 8 | 28856 | 29 |
130616 | 116421 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 621 STOCKTON ST | 1 | Front Yard : Yard | Tree | Private 2 | 6010507 | 2116333 | 37.7916392690679 | -122.407544875665 | (37.7916392690679, -122.407544875665) | 5 | 1 | 10 | 28857 | 21 | |||||
7368 | 168515 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1999 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004111.08983 | 2117627.84996 | 37.7948345125635 | -122.429767061412 | (37.7948345125635, -122.429767061412) | 13 | 9 | 1 | 28858 | 27 | |||
26811 | 31665 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1813 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 3 | Permit Number 35173 | 6006528.4802 | 2117109.7376 | 37.7935484974802 | -122.42136572658 | (37.7935484974802, -122.42136572658) | 13 | 9 | 10 | 28858 | 32 | ||
50182 | 107502 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 998 CHESTNUT ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 773456 | 6007102 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | 5 | 1 | 1 | 28858 | 32 | ||
122900 | 107501 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 998 CHESTNUT ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 773456 | 6007102 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | 5 | 1 | 1 | 28858 | 32 | ||
128563 | 117383 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
130403 | 117387 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
133531 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006264 | 2119500 | 37.8000966404513 | -122.42245076966 | (37.8000966404513, -122.42245076966) | 13 | 9 | 1 | 28858 | 32 | ||||
145995 | 117385 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
161976 | 117384 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
167345 | 117448 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776857 | 6007658.8 | 2115857.7 | 37.7901743736919 | -122.417365949941 | (37.7901743736919, -122.417365949941) | 13 | 1 | 10 | 28858 | 21 | ||
170638 | 117382 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
183323 | 117386 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1601 POLK ST | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6006595 | 2116425 | 37.7916721288605 | -122.421086920214 | (37.7916721288605, -122.421086920214) | 13 | 9 | 10 | 28858 | 21 | |||||
190172 | 66791 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2417 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | Permit Number 782035 | 6006674.15789 | 2119535.82066 | 37.8002181241347 | -122.421034007614 | (37.8002181241347, -122.421034007614) | 5 | 9 | 1 | 28858 | 32 | |
9541 | 151619 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2742 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6010731.34402 | 2101826.94097 | 37.7518215236653 | -122.405746421383 | (37.7518215236653, -122.405746421383) | 10 | 4 | 8 | 28859 | 19 | |||
11417 | 108972 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772927 | 6005770.7 | 2106026.5 | 37.7630738748169 | -122.423199517734 | (37.7630738748169, -122.423199517734) | 8 | 4 | 5 | 28859 | 19 |
11750 | 156512 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 458 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 2.5x4 | 6007850.10821 | 2096721.59201 | 37.7376418266109 | -122.415348774236 | (37.7376418266109, -122.415348774236) | 2 | 7 | 7 | 28859 | 2 | |||
12529 | 256148 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1669 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010597 | 2100121 | 37.7471298703057 | -122.406090831159 | (37.7471298703057, -122.406090831159) | 2 | 7 | 7 | 28859 | 2 | ||||
15802 | 251596 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 3698 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1998 12:00:00 AM | 4x4 | Permit Number 39496 | 6005038 | 2104916 | 37.7599833282319 | -122.42565463807 | (37.7599833282319, -122.42565463807) | 2 | 4 | 5 | 28859 | 19 | ||
16671 | 237075 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 4ft | 6005306.75052 | 2101349.20074 | 37.750204911337 | -122.424471450323 | (37.750204911337, -122.424471450323) | 2 | 4 | 5 | 28859 | 19 | ||
21302 | 234841 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 141 Albion St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005926.24374 | 2106419.53529 | 37.7641618337257 | -122.42268947605 | (37.7641618337257, -122.42268947605) | 8 | 4 | 5 | 28859 | 19 | |||
22142 | 115377 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 42 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777462 | 6005449.5 | 2096333.6 | 37.7364412712621 | -122.423621255026 | (37.7364412712621, -122.423621255026) | 2 | 7 | 7 | 28859 | 2 | ||
39185 | 108613 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 859 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774597 | 6007577.26936 | 2095354.40031 | 37.7338724793659 | -122.416195309142 | (37.7338724793659, -122.416195309142) | 2 | 7 | 7 | 28859 | 2 | |
55458 | 255165 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 371 Prospect Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781717 | 6006352.58239 | 2097791.19314 | 37.7404944317648 | -122.420602351048 | (37.7404944317648, -122.420602351048) | 2 | 7 | 7 | 28859 | 2 | |
58345 | 234843 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 141 Albion St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005925.31783 | 2106426.47013 | 37.7641808229188 | -122.422693171361 | (37.7641808229188, -122.422693171361) | 8 | 4 | 5 | 28859 | 19 | |||
71232 | 256150 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 1669 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010597 | 2100121 | 37.7471298703057 | -122.406090831159 | (37.7471298703057, -122.406090831159) | 2 | 7 | 7 | 28859 | 2 | ||||
80106 | 114666 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774512 | 6007233.6 | 2095963.6 | 37.7355258779344 | -122.417426639907 | (37.7355258779344, -122.417426639907) | 2 | 7 | 7 | 28859 | 2 | |||
86498 | 234842 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 141 Albion St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6005925.78637 | 2106423.26838 | 37.7641720581045 | -122.422691323269 | (37.7641720581045, -122.422691323269) | 8 | 4 | 5 | 28859 | 19 | |||
97686 | 254340 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 45 Fair Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781300 | 6006812.15908 | 2099551.95878 | 37.745354989783 | -122.419138175127 | (37.745354989783, -122.419138175127) | 2 | 7 | 7 | 28859 | 2 |
104086 | 115378 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 42 Leese St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777462 | 6005449.5 | 2096333.6 | 37.7364412712621 | -122.423621255026 | (37.7364412712621, -122.423621255026) | 2 | 7 | 7 | 28859 | 2 | ||
118657 | 115383 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 324 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | 2 | 7 | 7 | 28859 | 2 | ||
125934 | 256878 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
133482 | 156498 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 414 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781293 | 6007484.42025 | 2096871.98526 | 37.7380342134096 | -122.416623786263 | (37.7380342134096, -122.416623786263) | 2 | 7 | 7 | 28859 | 2 |
146848 | 109413 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 114 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773149 | 6006968.5 | 2095329.1 | 37.7337687610147 | -122.418298220412 | (37.7337687610147, -122.418298220412) | 2 | 7 | 7 | 28859 | 2 |
151191 | 36551 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 859 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 774597 | 6007583.24246776 | 2095353.82916435 | 37.7338712469843 | -122.416174617809 | (37.7338712469843, -122.416174617809) | 2 | 7 | 7 | 28859 | 2 | ||
152203 | 152615 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
158582 | 108904 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772986 | 6008567.7 | 2096169.9 | 37.7361673058735 | -122.412828714971 | (37.7361673058735, -122.412828714971) | 10 | 7 | 7 | 28859 | 2 |
159426 | 225657 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 6 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781317 | 6007484.20689 | 2099531.29764 | 37.7453360824988 | -122.416812874134 | (37.7453360824988, -122.416812874134) | 2 | 7 | 7 | 28859 | 2 |
168048 | 122898 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 198X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006160 | 2102149 | 37.7524491239798 | -122.421577653162 | (37.7524491239798, -122.421577653162) | 2 | 4 | 5 | 28859 | 19 | |||
171617 | 84165 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 714-716 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2015 12:00:00 AM | 3x3 | Permit Number 52661 | 6010104.93425212 | 2104957.66520048 | 37.7603827422102 | -122.408133417925 | (37.7603827422102, -122.408133417925) | 2 | 4 | 8 | 28859 | 19 | ||
179256 | 152616 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009096.56353 | 2101019.92176 | 37.7495140728181 | -122.411342732484 | (37.7495140728181, -122.411342732484) | 2 | 4 | 7 | 28859 | 19 | |
180615 | 122686 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3474 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6005720 | 2106109 | 37.7632975389877 | -122.423380737252 | (37.7632975389877, -122.423380737252) | 8 | 4 | 5 | 28859 | 19 | |||
539 | 178708 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 500 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 3ft | 6001593.53028 | 2090821.75006 | 37.721088578565 | -122.436558547244 | (37.721088578565, -122.436558547244) | 9 | 7 | 6 | 28861 | 5 | ||
584 | 170688 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 499X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000526.86487 | 2092744.73897 | 37.726307994602 | -122.440383530269 | (37.726307994602, -122.440383530269) | 9 | 7 | 6 | 28861 | 25 | ||
1425 | 170341 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 56 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6001088.08008 | 2093656.24889 | 37.7288427310959 | -122.438508720824 | (37.7288427310959, -122.438508720824) | 9 | 7 | 6 | 28861 | 25 | ||
1441 | 262458 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 236 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6002498 | 2094223 | 37.730479001636 | -122.433675025832 | (37.730479001636, -122.433675025832) | 9 | 7 | 5 | 28861 | 25 | ||
3510 | 262437 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 500 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | Width 3ft | 6001593.53028 | 2090821.75006 | 37.721088578565 | -122.436558547244 | (37.721088578565, -122.436558547244) | 9 | 7 | 6 | 28861 | 5 | ||
9560 | 160641 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 538 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001479.16071 | 2090640.1306 | 37.7205833924964 | -122.436940893107 | (37.7205833924964, -122.436940893107) | 9 | 7 | 6 | 28861 | 5 | ||
9908 | 215094 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 218 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.20309 | 37.7123610457095 | -122.459746958272 | (37.7123610457095, -122.459746958272) | 9 | 8 | 6 | 28861 | 24 | |
10887 | 160642 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 552 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001431.26484 | 2090565.22993 | 37.7203750096919 | -122.437101093851 | (37.7203750096919, -122.437101093851) | 9 | 7 | 6 | 28861 | 5 | ||
12322 | 170690 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 499X San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000565.44218 | 2092713.91239 | 37.7262255483502 | -122.440247961077 | (37.7262255483502, -122.440247961077) | 9 | 7 | 6 | 28861 | 25 | ||
15207 | 171363 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 35 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6002659.06191 | 2092590.504 | 37.7260056740221 | -122.433001623328 | (37.7260056740221, -122.433001623328) | 9 | 7 | 6 | 28861 | 5 | |||
16078 | 170689 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 499X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000540.92778 | 2092733.68669 | 37.7262784482906 | -122.440334123336 | (37.7262784482906, -122.440334123336) | 9 | 7 | 6 | 28861 | 25 | ||
16545 | 262457 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 230 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6002522 | 2094231 | 37.7305023295928 | -122.43359262597 | (37.7305023295928, -122.43359262597) | 9 | 7 | 5 | 28861 | 25 | ||
17256 | 160459 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 90 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001198.86277 | 2090341.59094 | 37.7197477343465 | -122.437888420609 | (37.7197477343465, -122.437888420609) | 9 | 7 | 6 | 28861 | 5 | ||
18338 | 160460 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 90 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001209.98941 | 2090333.79491 | 37.7197269609185 | -122.437849401749 | (37.7197269609185, -122.437849401749) | 9 | 7 | 6 | 28861 | 5 | ||
18835 | 170687 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 499X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000509.3244 | 2092756.21089 | 37.7263384951143 | -122.440444989051 | (37.7263384951143, -122.440444989051) | 9 | 7 | 6 | 28861 | 25 | ||
30616 | 251746 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 700 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:33:00 AM | 3 | 3x3 | 6002943 | 2087289 | 37.7114650168122 | -122.431641737098 | (37.7114650168122, -122.431641737098) | 9 | 7 | 6 | 28861 | 5 | ||
43676 | 181035 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 170 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:20:00 PM | 3 | Width 4ft | 6000927.80601 | 2088408.31319 | 37.7144239699579 | -122.438686909772 | (37.7144239699579, -122.438686909772) | 9 | 7 | 6 | 28861 | 5 | ||
53637 | 181036 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 170 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:16:00 PM | 3 | Width 4ft | 6000944.46471 | 2088397.62402 | 37.7143955675655 | -122.438628565353 | (37.7143955675655, -122.438628565353) | 9 | 7 | 6 | 28861 | 5 | ||
58754 | 160609 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 750X France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2017 03:56:00 PM | 3 | Width 0ft | 6002789.45595 | 2089340.35461 | 37.7170888824363 | -122.432318838255 | (37.7170888824363, -122.432318838255) | 9 | 7 | 6 | 28861 | 5 | ||
78847 | 160610 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 750X France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2017 04:01:00 PM | 3 | Width 0ft | 6002805.02204 | 2089330.87742 | 37.7170637427805 | -122.432264357312 | (37.7170637427805, -122.432264357312) | 9 | 7 | 6 | 28861 | 5 | ||
92335 | 216804 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 297 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 02:14:00 PM | 3 | Width 2ft | 5994075.3134 | 2088701.73413 | 37.7148374215779 | -122.462392942697 | (37.7148374215779, -122.462392942697) | 9 | 8 | 6 | 28861 | 24 | ||
111218 | 160608 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 750X France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:37:00 PM | 3 | Width 0ft | 6002772.88317 | 2089351.94517 | 37.7171197678315 | -122.432376949735 | (37.7171197678315, -122.432376949735) | 9 | 7 | 6 | 28861 | 5 | |
113421 | 160611 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 750X France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 04:11:00 PM | 3 | Width 0ft | 6002821.18646 | 2089320.89201 | 37.717037241564 | -122.432207771993 | (37.717037241564, -122.432207771993) | 9 | 7 | 6 | 28861 | 5 | |
113669 | 159358 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 49 Naglee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998584.62871 | 2087583.88571 | 37.712026700246 | -122.446726546692 | (37.712026700246, -122.446726546692) | 9 | 7 | 6 | 28861 | 25 | |
124820 | 252888 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 301x Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 04:03:00 PM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
128054 | 108818 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 583 Naples St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774655 | 6002868.5584 | 2090237.17355 | 37.7195558341056 | -122.432109426582 | (37.7195558341056, -122.432109426582) | 9 | 7 | 6 | 28861 | 5 | |
146166 | 175543 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 187 Seville St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 09:37:00 AM | 3 | Width 6ft | 6001178.34372 | 2087386.3168 | 37.7116320444605 | -122.437747801713 | (37.7116320444605, -122.437747801713) | 9 | 7 | 6 | 28861 | 5 | ||
163308 | 69411 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 400 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2017 12:00:00 PM | 3 | Permit Number 33516 | 6002017.91695 | 2087759.83784 | 37.7127053547461 | -122.434872710526 | (37.7127053547461, -122.434872710526) | 9 | 7 | 6 | 28861 | 5 | |
163401 | 253099 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 210 Foote Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:59:00 AM | 3 | Width 0ft | 5998556.96811 | 2088452.26068 | 37.7144094800835 | -122.446884596259 | (37.7144094800835, -122.446884596259) | 9 | 7 | 6 | 28861 | 25 | ||
194382 | 259013 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 131 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996343 | 2090506 | 37.7199218359789 | -122.45468519116 | (37.7199218359789, -122.45468519116) | 9 | 8 | 6 | 28861 | 24 | ||
194404 | 162800 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 37 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2020 12:00:00 AM | 3 | 4x6 | 5996614.18155 | 2090524.98833 | 37.7199895242736 | -122.453749186181 | (37.7199895242736, -122.453749186181) | 9 | 8 | 6 | 28861 | 24 | ||
35320 | 114539 | Permitted Site 7 | Podocarpus gracilor :: Fern Pine 51 | 4515 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | Permit Number 770790 | 6001361.1 | 2104034.2 | 37.7573536660829 | -122.438308059404 | (37.7573536660829, -122.438308059404) | 2 | 4 | 5 | 28862 | 3 | |||
56257 | 120653 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 4000x 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003791 | 2101344 | 37.7501049179003 | -122.42971263777 | (37.7501049179003, -122.42971263777) | 2 | 4 | 5 | 28862 | 22 |
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) );