trees
1,650 rows where qSpecies_id = 64 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27907 | 108600 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
72188 | 108602 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
76551 | 108603 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
119223 | 103416 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1500 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 769963 | 5991394 | 2098432 | 37.7413995354896 | -122.472369502423 | (37.7413995354896, -122.472369502423) | 1 | 8 | 4 | 29491 | 40 | |
156521 | 108599 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
160783 | 103415 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1500 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 769963 | 5991394 | 2098432 | 37.7413995354896 | -122.472369502423 | (37.7413995354896, -122.472369502423) | 1 | 8 | 4 | 29491 | 40 | |
178715 | 108601 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 47 Manchester St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774588 | 6008247.58165 | 2099751.34896 | 37.7459832024183 | -122.41418880701 | (37.7459832024183, -122.41418880701) | 2 | 7 | 7 | 28859 | 2 |
123422 | 52483 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 650MAYFLOWER Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48593 | 6009757.2999459 | 2098381.34570201 | 37.7423061581468 | -122.408871740084 | (37.7423061581468, -122.408871740084) | 10 | 7 | 7 | 28859 | 2 | ||
171452 | 46164 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 553 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44494 | 5996949.78101651 | 2107345.31191782 | 37.7661932466683 | -122.453803159566 | (37.7661932466683, -122.453803159566) | 15 | 5 | 11 | 29492 | 12 | ||
163527 | 35007 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3518 Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 10 | Permit Number 38580 | 5984642.89464 | 2111111.30614 | 37.7758203306984 | -122.496647595381 | (37.7758203306984, -122.496647595381) | 11 | 6 | 2 | 55 | 26 | ||
124062 | 102101 | Property Tree 8 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.7184923011832 | -122.468164197766 | (37.7184923011832, -122.468164197766) | 9 | 8 | 6 | 64 | 24 |
2085 | 261253 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 245 Euclid Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 5998181.06314 | 2113969.03195 | 37.7844507871641 | -122.450021856673 | (37.7844507871641, -122.450021856673) | 15 | 6 | 1 | 54 | 31 | |||
47721 | 102066 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 229 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769725 | 6006956.6 | 2097728.3 | 37.7403557640328 | -122.418509430253 | (37.7403557640328, -122.418509430253) | 2 | 7 | 7 | 28859 | 2 |
1193 | 63195 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 492 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 7 | Permit Number 23736 | 5984412.04288 | 2112531.45624 | 37.7797061246547 | -122.497551031954 | (37.7797061246547, -122.497551031954) | 11 | 6 | 2 | 55 | 26 | |
73383 | 70425 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 33 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | 3 | Permit Number 53083 | 6005742.08039 | 2093385.20113 | 37.7283621315868 | -122.422400250478 | (37.7283621315868, -122.422400250478) | 9 | 7 | 7 | 309 | 5 | ||
43857 | 43115 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 200 Appleton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.014 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | 2 | 7 | 7 | 28859 | 2 | ||
134128 | 43116 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 200 Appleton Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/2003 12:00:00 AM | Permit Number 42938 | 6005863.014 | 2096788.574 | 37.7377138611244 | -122.422223875233 | (37.7377138611244, -122.422223875233) | 2 | 7 | 7 | 28859 | 2 | ||
148353 | 46970 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1682 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53995 | 5982549.0126 | 2103678.0012 | 37.7552877057293 | -122.503340226936 | (37.7552877057293, -122.503340226936) | 1 | 8 | 3 | 56 | 35 |
93049 | 52308 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 464@ NOE 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2005 12:00:00 AM | Permit Number 48468 | 6003585.05710238 | 2098376.65012733 | 37.7419456008039 | -122.430213129043 | (37.7419456008039, -122.430213129043) | 2 | 7 | 5 | 63 | 22 | ||
92810 | 41227 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 82 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 6 | Permit Number 41933 | 6001259.46454 | 2121509.87595 | 37.805331639599 | -122.439912537334 | (37.805331639599, -122.439912537334) | 13 | 9 | 1 | 57 | 17 | |
189085 | 41215 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1410 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 3 | Permit Number 41923 | 6002447.41667 | 2121634.7897 | 37.8057421711384 | -122.435810424609 | (37.8057421711384, -122.435810424609) | 13 | 9 | 1 | 57 | 17 | |
62407 | 68811 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 56 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 10 | Permit Number 32754 | 5984318.17629 | 2112844.77947 | 37.7805609168358 | -122.49789889557 | (37.7805609168358, -122.49789889557) | 11 | 6 | 2 | 55 | 26 | ||
33188 | 39188 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1189 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40841 | 6007685.90483064 | 2102746.1551156 | 37.7541746987817 | -122.416343098068 | (37.7541746987817, -122.416343098068) | 2 | 4 | 7 | 28859 | 19 | ||
145299 | 39187 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1189 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40841 | 6007685.90483064 | 2102746.1551156 | 37.7541746987817 | -122.416343098068 | (37.7541746987817, -122.416343098068) | 2 | 4 | 7 | 28859 | 19 | ||
172280 | 52223 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1331 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | 6 | Permit Number 48403 | 6006656.01014 | 2118694.90131 | 37.7979081488955 | -122.421037065315 | (37.7979081488955, -122.421037065315) | 13 | 9 | 10 | 28858 | 32 | ||
106240 | 122625 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 189 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 4x5 | Permit Number 774974 | 5984222 | 2094938 | 37.7313882480876 | -122.496909587532 | (37.7313882480876, -122.496909587532) | 1 | 8 | 4 | 64 | 35 | |
178269 | 122626 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 330 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 3x5 | Permit Number 774975 | 5984613 | 2095517 | 37.7330009316807 | -122.495600537949 | (37.7330009316807, -122.495600537949) | 1 | 8 | 4 | 64 | 35 | |
30707 | 107701 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1233 47TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | 5981397.7 | 2106680.5 | 37.7634639604224 | -122.50754451242 | (37.7634639604224, -122.50754451242) | 1 | 8 | 3 | 56 | 35 | ||
24296 | 33072 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1360 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37332 | 6011469.86115 | 2119995.38405 | 37.8017491407824 | -122.404471277147 | (37.8017491407824, -122.404471277147) | 3 | 1 | 10 | 308 | 23 | ||
127709 | 80063 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 830 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49842 | 5999067.87770464 | 2095624.46606775 | 37.7341318695922 | -122.44563415277 | (37.7341318695922, -122.44563415277) | 9 | 7 | 4 | 59 | 40 | ||
107516 | 48773 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 7777 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2002 12:00:00 AM | 20 | Permit Number 46030 | 5982884.10852 | 2112361.52314 | 37.7791498591369 | -122.50282415167 | (37.7791498591369, -122.50282415167) | 11 | 6 | 2 | 55 | 26 | ||
119443 | 51417 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 5 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2004 12:00:00 AM | Permit Number 47742 | 5998697.89125775 | 2106894.30410502 | 37.7650549606092 | -122.447724339473 | (37.7650549606092, -122.447724339473) | 15 | 5 | 11 | 29492 | 9 | |||
166539 | 51416 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 611 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2004 12:00:00 AM | Permit Number 47741 | 5996652.56500142 | 2107304.20235687 | 37.7660633258868 | -122.454828195737 | (37.7660633258868, -122.454828195737) | 15 | 5 | 11 | 29492 | 12 | ||
167627 | 256505 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 4023 Pacheco St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 780999 | 5982525.89889 | 2101484.48033 | 37.7492635534225 | -122.50325775688 | (37.7492635534225, -122.50325775688) | 1 | 8 | 3 | 29491 | 35 | |
175587 | 68987 | Planning Code 138.1 required 2 | Cordyline australis :: Dracena Palm 64 | 767 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 775182 | 5999291.63198947 | 2121477.34728573 | 37.8051301110493 | -122.44672010757 | (37.8051301110493, -122.44672010757) | 13 | 9 | 1 | 57 | 17 | |
43673 | 50397 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 126 Springfield Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 3 | Permit Number 47048 | 5986815.96523 | 2095005.27155 | 37.7317246157805 | -122.487946825187 | (37.7317246157805, -122.487946825187) | 1 | 8 | 4 | 64 | 35 | |
93775 | 101125 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1500 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769229 | 5990778.88299 | 2113421.77882 | 37.7825218418593 | -122.475590617114 | (37.7825218418593, -122.475590617114) | 11 | 6 | 2 | 54 | 26 | |
25592 | 68394 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 252 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1993 12:00:00 AM | 4 | Permit Number 32222 | 6001581.94485 | 2093980.34457 | 37.7297607041954 | -122.436824590994 | (37.7297607041954, -122.436824590994) | 9 | 7 | 6 | 28861 | 25 | |
14346 | 261807 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2257 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2020 12:00:00 AM | 3 | 4x6 | 5986031 | 2099874 | 37.7450470274178 | -122.491018723977 | (37.7450470274178, -122.491018723977) | 1 | 8 | 3 | 29491 | 35 | ||
63476 | 62185 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 197 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1985 12:00:00 AM | 76 | Permit Number 22303 | 6000217.71423 | 2092424.50852 | 37.7254111079318 | -122.441429277242 | (37.7254111079318, -122.441429277242) | 9 | 7 | 6 | 28861 | 25 | |
120739 | 97301 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1051 Portola Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/20/2011 12:00:00 AM | Permit Number 768134 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||
39210 | 54955 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1559 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2012 12:00:00 AM | 2 | Permit Number 769310 | 5982476.3168 | 2104511.3762 | 37.7575716444054 | -122.503653339691 | (37.7575716444054, -122.503653339691) | 1 | 8 | 3 | 56 | 35 | ||
128117 | 253466 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98X Marston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
138731 | 104238 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 169 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770721 | 6009785.90495 | 2088868.00046 | 37.7161861267679 | -122.408102056979 | (37.7161861267679, -122.408102056979) | 9 | 7 | 8 | 309 | 39 | |
158027 | 104239 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 169 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2013 12:00:00 AM | 13 | 3x3 | Permit Number 770721 | 6009791.07087 | 2088880.72075 | 37.716221343317 | -122.40808509757 | (37.716221343317, -122.40808509757) | 9 | 7 | 8 | 309 | 39 | |
27224 | 95764 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 425 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767500 | 6004118.7 | 2090668.4 | 37.7208106862046 | -122.427818850767 | (37.7208106862046, -122.427818850767) | 9 | 7 | 6 | 28861 | 5 | |
50937 | 95708 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 277 Athens St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767467 | 6004392 | 2091652 | 37.7235268927559 | -122.426944152742 | (37.7235268927559, -122.426944152742) | 9 | 7 | 6 | 28861 | 5 | ||
80340 | 95710 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767467 | 6004400.77828 | 2091660.5114 | 37.7235507595459 | -122.426914413678 | (37.7235507595459, -122.426914413678) | 9 | 7 | 6 | 28861 | 5 |
190066 | 95741 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 85 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767487 | 6004901.6 | 2091388.4 | 37.7228319067102 | -122.42516380777 | (37.7228319067102, -122.42516380777) | 9 | 7 | 6 | 28861 | 5 | |
150174 | 51296 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 400 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2004 12:00:00 AM | 6 | Permit Number 47669 | 6011440.29122 | 2106415.58211 | 37.764460534556 | -122.403617592093 | (37.764460534556, -122.403617592093) | 8 | 3 | 8 | 28856 | 29 | ||
151849 | 51297 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 400 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2004 12:00:00 AM | 10 | Permit Number 47669 | 6011440.20199 | 2106438.76449 | 37.7645241831718 | -122.403619531927 | (37.7645241831718, -122.403619531927) | 8 | 3 | 8 | 28856 | 29 | ||
10877 | 205247 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2002 12:00:00 AM | 7 | Width 3ft | Permit Number 45929 | 5990862.22967 | 2105614.49151 | 37.7610899852431 | -122.474732265294 | (37.7610899852431, -122.474732265294) | 1 | 8 | 4 | 56 | 12 | |
17817 | 205248 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2002 12:00:00 AM | 6 | Width 3ft | Permit Number 45929 | 5990867.58094 | 2105598.65136 | 37.7610468024976 | -122.474712601602 | (37.7610468024976, -122.474712601602) | 1 | 8 | 4 | 56 | 12 | |
24636 | 48634 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45929 | 5990866.95707843 | 2105617.12188587 | 37.761097481488 | -122.474716107382 | (37.761097481488, -122.474716107382) | 1 | 8 | 4 | 56 | 12 | ||
70945 | 48635 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1436 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45929 | 5990866.95707843 | 2105617.12188587 | 37.761097481488 | -122.474716107382 | (37.761097481488, -122.474716107382) | 1 | 8 | 4 | 56 | 12 | ||
12509 | 260552 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1822 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/27/2019 12:00:00 AM | 3 | 5983200.28736 | 2102724.03033 | 37.752706632515 | -122.501017410169 | (37.752706632515, -122.501017410169) | 1 | 8 | 3 | 56 | 35 | ||
129169 | 51283 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3999 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2004 12:00:00 AM | Permit Number 47655 | 6004645.53227808 | 2095323.45859057 | 37.7336222359392 | -122.426329013444 | (37.7336222359392, -122.426329013444) | 2 | 7 | 7 | 28861 | 2 | |||
130197 | 51282 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3999 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2004 12:00:00 AM | Permit Number 47655 | 6004645.53227808 | 2095323.45859057 | 37.7336222359392 | -122.426329013444 | (37.7336222359392, -122.426329013444) | 2 | 7 | 7 | 28861 | 2 | |||
125932 | 208471 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1175 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 08/23/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 780657 | 5991201.16474 | 2105172.16858 | 37.7598951180952 | -122.473527781682 | (37.7598951180952, -122.473527781682) | 1 | 8 | 4 | 56 | 12 | |
143837 | 888 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1134X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2011 12:00:00 AM | 12 | 3x4 | 6003357.55558 | 2094337.15167 | 37.7308411716555 | -122.430711562141 | (37.7308411716555, -122.430711562141) | 9 | 7 | 5 | 28861 | 25 | ||
108965 | 53009 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3560 JEFFERSON Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2006 12:00:00 AM | 38 | Permit Number 48994 | 5999214.77321 | 2121106.04415 | 37.8041062224979 | -122.446959349696 | (37.8041062224979, -122.446959349696) | 13 | 9 | 1 | 57 | 17 | ||
129465 | 73619 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3743-3743 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2011 12:00:00 AM | 8 | Permit Number 768173 | 5983932.95507 | 2111030.02949 | 37.7755555482879 | -122.499097411661 | (37.7755555482879, -122.499097411661) | 11 | 6 | 2 | 55 | 26 | |
32003 | 59294 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 357 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1980 12:00:00 AM | Permit Number 18631 | 5998269.35755712 | 2107529.98911826 | 37.7667758890994 | -122.449252327047 | (37.7667758890994, -122.449252327047) | 15 | 5 | 11 | 29492 | 9 | |||
7917 | 253285 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 5981372 | 2112274 | 37.7788205636315 | -122.508048563649 | (37.7788205636315, -122.508048563649) | 11 | 6 | 2 | 55 | 26 | |||
80966 | 203654 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 42 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001070.39767 | 2095226.13763 | 37.7331522778487 | -122.438682294452 | (37.7331522778487, -122.438682294452) | 9 | 7 | 5 | 63 | 40 | ||
85225 | 208852 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 42 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001113.97001 | 2095223.01163 | 37.7331461732542 | -122.438531429591 | (37.7331461732542, -122.438531429591) | 9 | 7 | 5 | 63 | 40 | ||
4394 | 261156 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4221 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/2020 12:00:00 AM | 3 | 3x3 | 5981166 | 2103448 | 37.7545747897022 | -122.508105942328 | (37.7545747897022, -122.508105942328) | 1 | 8 | 3 | 56 | 35 | |
166267 | 105547 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 238 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773246 | 5992159.29093 | 2113841.99404 | 37.7837555644039 | -122.47084566815 | (37.7837555644039, -122.47084566815) | 11 | 6 | 2 | 54 | 11 | |
109746 | 54767 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 7 | 3x3 | Permit Number 10616 | 6012845.85571 | 2087036.62523 | 37.7113283901643 | -122.397396968017 | (37.7113283901643, -122.397396968017) | 10 | 3 | 8 | 309 | 1 | |
82007 | 96910 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1399X 48TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981210 | 2105881 | 37.7612577047615 | -122.508134351337 | (37.7612577047615, -122.508134351337) | 1 | 8 | 3 | 56 | 35 | ||
191315 | 96911 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 4300 JUDAH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981169 | 2105631 | 37.7605688605658 | -122.508257593382 | (37.7605688605658, -122.508257593382) | 1 | 8 | 3 | 56 | 35 | ||
144616 | 38375 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3809 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 2 | Permit Number 40434 | 5982171.278 | 2102815.4467 | 37.7528971616744 | -122.504582620132 | (37.7528971616744, -122.504582620132) | 1 | 8 | 3 | 56 | 35 | |
94357 | 92495 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3626 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52865 | 5981730 | 2097424 | 37.7380677850415 | -122.505708970967 | (37.7380677850415, -122.505708970967) | 1 | 8 | 3 | 29491 | 35 | |
136328 | 92494 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3620 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52864 | 5981698.329 | 2097425.7769 | 37.7380707998658 | -122.505818603166 | (37.7380707998658, -122.505818603166) | 1 | 8 | 3 | 29491 | 35 |
159427 | 92491 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4626 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52861 | 5981634.7827 | 2098098.5099 | 37.7399141986787 | -122.50608817681 | (37.7399141986787, -122.50608817681) | 1 | 8 | 3 | 29491 | 35 |
166654 | 92492 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1936 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52862 | 5986966 | 2097599 | 37.7388550641297 | -122.487618605313 | (37.7388550641297, -122.487618605313) | 1 | 8 | 3 | 29491 | 35 | |
45857 | 54528 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4650 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | 21 | Permit Number 10323 | 5981096.26906 | 2110986.58772 | 37.7752694592632 | -122.508906792671 | (37.7752694592632, -122.508906792671) | 11 | 6 | 2 | 55 | 26 | ||
84819 | 92433 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2367 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52823 | 5983266.6 | 2099037.7 | 37.7425888819276 | -122.500515549194 | (37.7425888819276, -122.500515549194) | 1 | 8 | 3 | 29491 | 35 | |
189557 | 92457 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2174 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52847 | 5981421.6737 | 2100290.4816 | 37.7459201959872 | -122.506987562585 | (37.7459201959872, -122.506987562585) | 1 | 8 | 3 | 29491 | 35 |
63846 | 92402 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1535 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52802 | 5985244 | 2104754.6 | 37.7584018060121 | -122.494099636368 | (37.7584018060121, -122.494099636368) | 1 | 8 | 3 | 56 | 35 |
72417 | 92418 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1242 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52811 | 5984306.481 | 2106711.5777 | 37.7637202145355 | -122.497486421461 | (37.7637202145355, -122.497486421461) | 1 | 8 | 3 | 56 | 35 |
85384 | 92427 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1601 39th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52817 | 5984021 | 2104223.4 | 37.7568716403648 | -122.498290014097 | (37.7568716403648, -122.498290014097) | 1 | 8 | 3 | 56 | 35 | |
125371 | 92405 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1549 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52804 | 5985246.8 | 2104672.6 | 37.7581768205908 | -122.494083909336 | (37.7581768205908, -122.494083909336) | 1 | 8 | 3 | 56 | 35 | |
134887 | 92426 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1601 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52817 | 5984021 | 2104223.4 | 37.7568716403648 | -122.498290014097 | (37.7568716403648, -122.498290014097) | 1 | 8 | 3 | 56 | 35 | |
56843 | 38343 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1642 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 6 | Permit Number 40410 | 5982231.0624 | 2103923.0719 | 37.755941904631 | -122.504457930287 | (37.755941904631, -122.504457930287) | 1 | 8 | 3 | 56 | 35 | |
22498 | 92364 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1910 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52777 | 5986038.6 | 2102202.7 | 37.7514414512274 | -122.491163791724 | (37.7514414512274, -122.491163791724) | 1 | 8 | 3 | 29491 | 35 | |
31661 | 34649 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 1735 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 40399 | 5987784.82467276 | 2103483.81569075 | 37.7550609240819 | -122.485219205847 | (37.7550609240819, -122.485219205847) | 1 | 8 | 3 | 56 | 35 | ||
68447 | 34722 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3619 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3 | Permit Number 38377 | 5984323.32216 | 2111043.9635 | 37.7756166985977 | -122.497748087301 | (37.7756166985977, -122.497748087301) | 11 | 6 | 2 | 55 | 26 | |
13857 | 260533 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1514 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982198.3547 | 2104783.64712 | 37.7583028764812 | -122.504634801553 | (37.7583028764812, -122.504634801553) | 1 | 8 | 3 | 56 | 35 | ||
683 | 38304 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
24823 | 38314 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
36282 | 38313 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
116665 | 38307 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2000 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40376 | 6008042.39215173 | 2106787.37094181 | 37.7652909891949 | -122.415396349695 | (37.7652909891949, -122.415396349695) | 8 | 4 | 7 | 28859 | 19 | ||
3946 | 52915 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3017th ST Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2006 12:00:00 AM | Permit Number 48903 | 6000815.25066305 | 2106175.88788155 | 37.7632031545323 | -122.440349407902 | (37.7632031545323, -122.440349407902) | 15 | 5 | 5 | 28862 | 3 | |||
84064 | 52914 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3017th ST Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2006 12:00:00 AM | Permit Number 48903 | 6000815.25066305 | 2106175.88788155 | 37.7632031545323 | -122.440349407902 | (37.7632031545323, -122.440349407902) | 15 | 5 | 5 | 28862 | 3 | |||
107889 | 38373 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3741 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2014 12:00:00 AM | Permit Number 40432 | 5982426.74388672 | 2102835.76429046 | 37.7529679717779 | -122.503700690636 | (37.7529679717779, -122.503700690636) | 1 | 8 | 3 | 56 | 35 | ||
3002 | 43637 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 464 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43287 | 6006770.36235207 | 2101076.15554315 | 37.7495377351989 | -122.419390811234 | (37.7495377351989, -122.419390811234) | 2 | 4 | 7 | 28859 | 19 | ||
188510 | 43638 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 464 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43287 | 6006770.36235207 | 2101076.15554315 | 37.7495377351989 | -122.419390811234 | (37.7495377351989, -122.419390811234) | 2 | 4 | 7 | 28859 | 19 | ||
139869 | 253127 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1639 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780367 | 5982187.14146 | 2103946.19954 | 37.7560028231362 | -122.50461153425 | (37.7560028231362, -122.50461153425) | 1 | 8 | 3 | 56 | 35 | |
64400 | 48360 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 246 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45771 | 6003531.3283676 | 2101591.65736703 | 37.7507702195134 | -122.430628266841 | (37.7507702195134, -122.430628266841) | 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) );