trees
11,761 rows where qSpecies_id = 17 sorted by Latitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72238 | 65564 | DPW Maintained 1 | Tree(s) :: 17 | 228 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28463 | 6021524.08705829 | 2122941.38889516 | 37.8103949467147 | -122.369882282876 | (37.8103949467147, -122.369882282876) | 2 | 9 | 62 | 37 | ||||
174692 | 65563 | DPW Maintained 1 | Tree(s) :: 17 | 255 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/1990 12:00:00 AM | Permit Number 28462 | 6021766.42970205 | 2122905.90070123 | 37.8103107984086 | -122.369041103471 | (37.8103107984086, -122.369041103471) | 2 | 9 | 62 | 37 | ||||
33524 | 65565 | DPW Maintained 1 | Tree(s) :: 17 | 282 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28464 | 6022001.13211196 | 2122805.77301993 | 37.8100487398864 | -122.368221901586 | (37.8100487398864, -122.368221901586) | 2 | 9 | 62 | 37 | ||||
57815 | 65566 | Permitted Site 7 | Tree(s) :: 17 | 340 Yerba Buena Rd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1990 12:00:00 AM | Permit Number 28465 | 6022030.55852908 | 2122617.11164597 | 37.8095323316173 | -122.368107024455 | (37.8095323316173, -122.368107024455) | 2 | 9 | 62 | 37 | ||||
169670 | 66415 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1991 12:00:00 AM | Permit Number 29546 | 6006760.29248409 | 2122608.12240598 | 37.808658736106 | -122.420954201226 | (37.808658736106, -122.420954201226) | 1 | 1 | 28858 | 32 | |||||
78816 | 84934 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | |||
99636 | 84933 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
102582 | 84932 | Permitted Site 7 | Tree(s) :: 17 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | |||||
141144 | 65287 | Permitted Site 7 | Tree(s) :: 17 | 2701 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1989 12:00:00 AM | Permit Number 28099 | 6008264.52815506 | 2122079.849214 | 37.8072929076287 | -122.415710920925 | (37.8072929076287, -122.415710920925) | 5 | 1 | 10 | 308 | 23 | |||
190110 | 56951 | Permitted Site 7 | Tree(s) :: 17 | 1365 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | Permit Number 14203 | 6007207.06542342 | 2121825.08767513 | 37.8065338965346 | -122.41935242715 | (37.8065338965346, -122.41935242715) | 5 | 1 | 1 | 28858 | 32 | |||
84151 | 56029 | Permitted Site 7 | Tree(s) :: 17 | 765 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1973 12:00:00 AM | Permit Number 12114 | 6006557.68355005 | 2121805.96639434 | 37.8064447992553 | -122.421598378173 | (37.8064447992553, -122.421598378173) | 5 | 1 | 1 | 28858 | 32 | |||
108086 | 66294 | Permitted Site 7 | Tree(s) :: 17 | 555 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1990 12:00:00 AM | 3x3 | Permit Number 29405 | 6008080.29465502 | 2121671.77006146 | 37.806162067511 | -122.416319580987 | (37.806162067511, -122.416319580987) | 5 | 1 | 10 | 308 | 23 | ||
24953 | 104416 | Permitted Site 7 | Tree(s) :: 17 | 335 Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2013 12:00:00 AM | Permit Number 770730 | 6001759.6 | 2121793 | 37.806137479917 | -122.438202052281 | (37.806137479917, -122.438202052281) | 13 | 9 | 1 | 57 | 17 | |||
185216 | 65888 | Permitted Site 7 | Tree(s) :: 17 | 2455 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1990 12:00:00 AM | Permit Number 28894 | 6008809.73199714 | 2121641.71188951 | 37.8061205259521 | -122.413793104611 | (37.8061205259521, -122.413793104611) | 3 | 1 | 10 | 308 | 23 | |||
101904 | 61718 | Permitted Site 7 | Tree(s) :: 17 | 2740 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1984 12:00:00 AM | Permit Number 21718 | 6006913.180537 | 2121680.17299116 | 37.8061194416425 | -122.42035917989 | (37.8061194416425, -122.42035917989) | 5 | 1 | 1 | 28858 | 32 | |||
17589 | 251643 | DPW Maintained 1 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6007328 | 2121670 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | 5 | 1 | 1 | 28858 | 32 | |||
44362 | 61413 | Permitted Site 7 | Tree(s) :: 17 | 131 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1984 12:00:00 AM | Permit Number 21338 | 6010026.27404793 | 2121590.40064059 | 37.8060478811733 | -122.409579417139 | (37.8060478811733, -122.409579417139) | 3 | 1 | 10 | 308 | 23 | |||
66112 | 61630 | Permitted Site 7 | Tree(s) :: 17 | 2552 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1987 12:00:00 AM | Permit Number 24013 | 6008386.50068862 | 2121576.76295741 | 37.8059184157747 | -122.415253170652 | (37.8059184157747, -122.415253170652) | 5 | 1 | 10 | 308 | 23 | |||
115814 | 66127 | Permitted Site 7 | Tree(s) :: 17 | 185 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | Permit Number 29189 | 6002551.87129632 | 2121689.08916143 | 37.8058971959495 | -122.435452831173 | (37.8058971959495, -122.435452831173) | 13 | 9 | 1 | 57 | 17 | |||
100788 | 66139 | Permitted Site 7 | Tree(s) :: 17 | 455 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | Permit Number 29202 | 6000985.89994504 | 2121696.81673664 | 37.8058293527268 | -122.4408726592 | (37.8058293527268, -122.4408726592) | 13 | 9 | 1 | 57 | 17 | |||
169457 | 67535 | Permitted Site 7 | Tree(s) :: 17 | 60 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1992 12:00:00 AM | Permit Number 31074 | 6011134.98167148 | 2121448.73063522 | 37.8057209533484 | -122.405732549389 | (37.8057209533484, -122.405732549389) | 3 | 1 | 10 | 308 | 23 | |||
176746 | 52658 | Permitted Site 7 | Tree(s) :: 17 | 501@ SCOTT Marina Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | Permit Number 48739 | 6000588.64966073 | 2121660.78651717 | 37.8057077911166 | -122.442244812231 | (37.8057077911166, -122.442244812231) | 13 | 9 | 1 | 57 | 17 | |||
139146 | 96365 | Undocumented 4 | Tree(s) :: 17 | 2017 Grant Ave | 1 | Median : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767883 | 6010284.4 | 2121422.5 | 37.8056013282128 | -122.408674274121 | (37.8056013282128, -122.408674274121) | 3 | 1 | 10 | 308 | 23 | |
66761 | 86968 | Permitted Site 7 | Tree(s) :: 17 | 3250 Van Ness Ave | 1 | Median : Cutout | Tree | Private 2 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.425238273707 | (37.8055578865418, -122.425238273707) | 5 | 1 | 1 | 28858 | 32 | |||
189038 | 86969 | Permitted Site 7 | Tree(s) :: 17 | 3250 Van Ness Ave | 2 | Median : Cutout | Tree | Private 2 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.425238273707 | (37.8055578865418, -122.425238273707) | 5 | 1 | 1 | 28858 | 32 | |||
93547 | 49318 | Permitted Site 7 | Tree(s) :: 17 | 595 Marina Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.8054977726587 | -122.443873196152 | (37.8054977726587, -122.443873196152) | 13 | 9 | 1 | 57 | 17 | |||
158196 | 61410 | Permitted Site 7 | Tree(s) :: 17 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/1984 12:00:00 AM | Permit Number 21334 | 6006945.26287472 | 2121452.77130571 | 37.8054968624954 | -122.420232003803 | (37.8054968624954, -122.420232003803) | 5 | 1 | 1 | 28858 | 32 | |||
184910 | 61639 | Permitted Site 7 | Tree(s) :: 17 | 2653 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1984 12:00:00 AM | Permit Number 21625 | 6006898.77522094 | 2121410.25251795 | 37.8053774972256 | -122.420389861177 | (37.8053774972256, -122.420389861177) | 5 | 1 | 1 | 28858 | 32 | |||
31042 | 50954 | Permitted Site 7 | Tree(s) :: 17 | 240 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | Permit Number 47448 | 6000836.42503656 | 2121511.47248937 | 37.8053119330456 | -122.441376630841 | (37.8053119330456, -122.441376630841) | 13 | 9 | 1 | 57 | 17 | |||
114193 | 50821 | Permitted Site 7 | Tree(s) :: 17 | 240 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2011 12:00:00 AM | 3x5 | Permit Number 56957 | 6000836.42503656 | 2121511.47248937 | 37.8053119330456 | -122.441376630841 | (37.8053119330456, -122.441376630841) | 13 | 9 | 1 | 57 | 17 | ||
29815 | 56571 | Permitted Site 7 | Tree(s) :: 17 | 234 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010159.54644349 | 2121315.84330791 | 37.8053014819094 | -122.40909881886 | (37.8053014819094, -122.40909881886) | 3 | 1 | 10 | 308 | 23 | |||||
146972 | 104810 | Permitted Site 7 | Tree(s) :: 17 | 685 Marina Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | 13 | 9 | 1 | 57 | 17 | ||||
85268 | 62062 | Permitted Site 7 | Tree(s) :: 17 | 225 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1985 12:00:00 AM | Permit Number 22143 | 6010228.86837932 | 2121272.63837953 | 37.8051867350762 | -122.408855870259 | (37.8051867350762, -122.408855870259) | 3 | 1 | 10 | 308 | 23 | |||
70947 | 65850 | Permitted Site 7 | Tree(s) :: 17 | 67 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 9 | 3x3 | Permit Number 770220 | 6001319.42927239 | 2121416.09155385 | 37.8050775459314 | -122.439698294296 | (37.8050775459314, -122.439698294296) | 13 | 9 | 1 | 57 | 17 |
86610 | 71435 | Permitted Site 7 | Tree(s) :: 17 | 408 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773571 | 6009330.98606375 | 2121202.52490029 | 37.804943887073 | -122.411958155811 | (37.804943887073, -122.411958155811) | 3 | 1 | 10 | 308 | 23 | |
81815 | 60424 | Permitted Site 7 | Tree(s) :: 17 | 1554 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1982 12:00:00 AM | Permit Number 20008 | 6002777.03134735 | 2121327.895592 | 37.8049182387297 | -122.434647787028 | (37.8049182387297, -122.434647787028) | 13 | 9 | 1 | 57 | 17 | |||
146198 | 63939 | Permitted Site 7 | Tree(s) :: 17 | 1580 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1987 12:00:00 AM | Permit Number 24669 | 6002661.34098173 | 2121312.07170737 | 37.80486822214 | -122.435047013297 | (37.80486822214, -122.435047013297) | 13 | 9 | 1 | 57 | 17 | |||
77814 | 114983 | Undocumented 4 | Tree(s) :: 17 | 178 CERVANTES BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777197 | 6001129 | 2121320 | 37.8048028635373 | -122.440350399876 | (37.8048028635373, -122.440350399876) | 13 | 9 | 1 | 57 | 17 | |
102637 | 101518 | DPW Maintained 1 | Tree(s) :: 17 | 170 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2012 12:00:00 AM | 3x3 | Permit Number 769472 | 6010021.5 | 2121128.5 | 37.8047793494283 | -122.409563317566 | (37.8047793494283, -122.409563317566) | 3 | 1 | 10 | 308 | 23 | ||
32821 | 88995 | Permitted Site 7 | Tree(s) :: 17 | 5 Rico Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2008 12:00:00 AM | 3x3 | Permit Number 51744 | 6001709 | 2121299 | 37.8047782094669 | -122.438341747927 | (37.8047782094669, -122.438341747927) | 13 | 9 | 1 | 57 | 17 | |||
183614 | 104293 | Permitted Site 7 | Tree(s) :: 17 | 3665X Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2013 12:00:00 AM | 3x3 | Permit Number 770442 | 5999151.92915 | 2121319.46506 | 37.8046886279394 | -122.44719219431 | (37.8046886279394, -122.44719219431) | 13 | 9 | 1 | 57 | 17 | ||
49604 | 64008 | Permitted Site 7 | Tree(s) :: 17 | 111 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/1987 12:00:00 AM | Permit Number 24756 | 6011241.81470832 | 2121063.93162535 | 37.8046703636508 | -122.405335720448 | (37.8046703636508, -122.405335720448) | 3 | 1 | 10 | 28860 | 23 | |||
122417 | 96376 | Permitted Site 7 | Tree(s) :: 17 | 158 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | 6x3 | Permit Number 768038 | 6001209.7 | 2121263.4 | 37.8046520495219 | -122.440067068703 | (37.8046520495219, -122.440067068703) | 13 | 9 | 1 | 57 | 17 | ||
165631 | 93579 | Permitted Site 7 | Tree(s) :: 17 | 2155 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53401 | 6009385 | 2121027 | 37.8044649697806 | -122.411758823634 | (37.8044649697806, -122.411758823634) | 3 | 1 | 10 | 308 | 23 | |
130654 | 63947 | Permitted Site 7 | Tree(s) :: 17 | 1690 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1987 12:00:00 AM | Permit Number 24678 | 6002067.98740153 | 2121166.63228799 | 37.8044351747518 | -122.437089954262 | (37.8044351747518, -122.437089954262) | 13 | 9 | 1 | 57 | 17 | |||
46113 | 63794 | Permitted Site 7 | Tree(s) :: 17 | 199 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/1987 12:00:00 AM | Permit Number 24481 | 6010854.95421641 | 2120980.25536358 | 37.804418972449 | -122.406668595369 | (37.804418972449, -122.406668595369) | 3 | 1 | 10 | 308 | 23 | |||
124798 | 62152 | Permitted Site 7 | Tree(s) :: 17 | 2027 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/1985 12:00:00 AM | Permit Number 22266 | 5999521.42662743 | 2121169.12209771 | 37.8042969320983 | -122.445902696817 | (37.8042969320983, -122.445902696817) | 13 | 9 | 1 | 57 | 17 | |||
91104 | 87151 | Permitted Site 7 | Tree(s) :: 17 | 4 Bellair Pl | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||||
122127 | 87152 | Permitted Site 7 | Tree(s) :: 17 | 4 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50135 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||
122761 | 87153 | Permitted Site 7 | Tree(s) :: 17 | 4 Bellair Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 3x3 | Permit Number 50135 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||
1730 | 121323 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
22280 | 121321 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
45816 | 121324 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
76308 | 121322 | Undocumented 4 | Tree(s) :: 17 | 3699X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003556 | 2121083 | 37.8042900105203 | -122.431934584375 | (37.8042900105203, -122.431934584375) | 13 | 9 | 1 | 28858 | 17 | ||||
50914 | 92732 | Permitted Site 7 | Tree(s) :: 17 | 220 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | 3 | 1 | 10 | 28860 | 23 | ||
65122 | 92735 | Permitted Site 7 | Tree(s) :: 17 | 220 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | 3 | 1 | 10 | 28860 | 23 | ||
90210 | 92736 | Permitted Site 7 | Tree(s) :: 17 | 220 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | 3 | 1 | 10 | 28860 | 23 | ||
100910 | 98587 | Permitted Site 7 | Tree(s) :: 17 | 200 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/29/2012 12:00:00 AM | Permit Number 768509 | 6011190 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | 3 | 1 | 10 | 28860 | 23 | |||
164406 | 92733 | Permitted Site 7 | Tree(s) :: 17 | 220 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | 3 | 1 | 10 | 28860 | 23 | ||
185441 | 92734 | Permitted Site 7 | Tree(s) :: 17 | 220 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52963 | 6011190 | 2120909.7 | 37.8042439844534 | -122.405504162253 | (37.8042439844534, -122.405504162253) | 3 | 1 | 10 | 28860 | 23 | ||
173523 | 122851 | Undocumented 4 | Tree(s) :: 17 | 742 Francisco St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6007760 | 2120975 | 37.8042308974981 | -122.417378607523 | (37.8042308974981, -122.417378607523) | 5 | 1 | 1 | 308 | 32 | ||||
13917 | 106712 | Permitted Site 7 | Tree(s) :: 17 | 3713 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2014 12:00:00 AM | 3x3 | Permit Number 772877 | 6000611 | 2121098.3 | 37.804164627793 | -122.442127063949 | (37.804164627793, -122.442127063949) | 13 | 9 | 1 | 57 | 17 | ||
20630 | 62423 | Permitted Site 7 | Tree(s) :: 17 | 98 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1985 12:00:00 AM | Permit Number 22580 | 6001470.60482532 | 2121060.78917044 | 37.8041105836027 | -122.439149653649 | (37.8041105836027, -122.439149653649) | 13 | 9 | 1 | 57 | 17 | |||
38800 | 124741 | DPW Maintained 1 | Tree(s) :: 17 | 1735 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779309 | 6001858 | 2121050 | 37.8041029952336 | -122.43780827401 | (37.8041029952336, -122.43780827401) | 13 | 9 | 1 | 57 | 17 | |
137691 | 58344 | Permitted Site 7 | Tree(s) :: 17 | 876 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/1978 12:00:00 AM | Permit Number 17369 | 6007146.97201877 | 2120912.72816987 | 37.8040254050262 | -122.419495622457 | (37.8040254050262, -122.419495622457) | 5 | 1 | 1 | 28858 | 32 | |||
160092 | 66136 | Permitted Site 7 | Tree(s) :: 17 | 3650 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | Permit Number 29199 | 5999699.53351647 | 2121049.79254492 | 37.8039794535991 | -122.445277760857 | (37.8039794535991, -122.445277760857) | 13 | 9 | 1 | 57 | 17 | |||
92648 | 28968 | DPW Maintained 1 | Tree(s) :: 17 | 2455 Hyde St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6006975.5076786 | 2120876.6023829 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | 5 | 1 | 1 | 28858 | 32 | ||||||
78234 | 101358 | DPW Maintained 1 | Tree(s) :: 17 | 2201X Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2016 12:00:00 AM | 3 | 5x5 | Permit Number 769392 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.413295071436 | (37.803771736238, -122.413295071436) | 3 | 1 | 10 | 308 | 23 | |
37061 | 40101 | Permitted Site 7 | Tree(s) :: 17 | 1940 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41326 | 6009956.80858576 | 2120754.29790906 | 37.8037482583048 | -122.409760760125 | (37.8037482583048, -122.409760760125) | 3 | 1 | 10 | 308 | 23 | ||||
187342 | 63620 | Permitted Site 7 | Tree(s) :: 17 | 800 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1987 12:00:00 AM | Permit Number 24262 | 6007490.4861989 | 2120798.53519393 | 37.8037312025077 | -122.418298763986 | (37.8037312025077, -122.418298763986) | 5 | 1 | 1 | 28858 | 32 | |||
113580 | 55780 | Permitted Site 7 | Tree(s) :: 17 | 2144 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1973 12:00:00 AM | Permit Number 11820 | 6000057.2433755 | 2120948.7784784 | 37.8037225082525 | -122.444032623798 | (37.8037225082525, -122.444032623798) | 13 | 9 | 1 | 57 | 17 | |||
120876 | 63768 | Permitted Site 7 | Tree(s) :: 17 | 290 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/1987 12:00:00 AM | Permit Number 24447 | 6010878.35626765 | 2120720.07929167 | 37.8037059023298 | -122.406569264823 | (37.8037059023298, -122.406569264823) | 3 | 1 | 10 | 308 | 23 | |||
80380 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060 | 2120781 | 37.8036588138585 | -122.41978724304 | (37.8036588138585, -122.41978724304) | 5 | 1 | 1 | 28858 | 32 | ||
45355 | 66021 | Permitted Site 7 | Tree(s) :: 17 | 3574 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1990 12:00:00 AM | Permit Number 29056 | 6001209.73992765 | 2120899.08941713 | 37.8036517520429 | -122.440040791569 | (37.8036517520429, -122.440040791569) | 13 | 9 | 1 | 57 | 17 | |||
97947 | 57849 | Permitted Site 7 | Tree(s) :: 17 | 264 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1990 12:00:00 AM | Permit Number 29054 | 6001448.85521526 | 2120882.35482124 | 37.8036194127112 | -122.439212122633 | (37.8036194127112, -122.439212122633) | 13 | 9 | 1 | 57 | 17 | |||
117193 | 86908 | DPW Maintained 1 | Tree(s) :: 17 | 65 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780355 | 6001653.18429 | 2120872.66281 | 37.8036044259513 | -122.438504338416 | (37.8036044259513, -122.438504338416) | 13 | 9 | 1 | 57 | 17 | |
35073 | 93725 | Permitted Site 7 | Tree(s) :: 17 | 2050 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2010 12:00:00 AM | 3x3 | Permit Number 53314 | 6009477 | 2120679 | 37.8035146090917 | -122.411415847958 | (37.8035146090917, -122.411415847958) | 3 | 1 | 10 | 308 | 23 | ||
119632 | 93726 | Permitted Site 7 | Tree(s) :: 17 | 2050 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2010 12:00:00 AM | 3x3 | Permit Number 53314 | 6009477 | 2120679 | 37.8035146090917 | -122.411415847958 | (37.8035146090917, -122.411415847958) | 3 | 1 | 10 | 308 | 23 | ||
76886 | 106942 | Significant Tree 6 | Tree(s) :: 17 | 1300@ Embarcadero Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 07/02/2014 12:00:00 AM | Permit Number 772680 | 6012231.9986 | 2120618.97397 | 37.8035039293343 | -122.401877773891 | (37.8035039293343, -122.401877773891) | 3 | 1 | 10 | 28860 | 6 | |||
55815 | 52855 | Permitted Site 7 | Tree(s) :: 17 | 3560CAPRA WAY Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48864 | 6001218.21588434 | 2120838.32312827 | 37.8034853865059 | -122.440007100367 | (37.8034853865059, -122.440007100367) | 13 | 9 | 1 | 57 | 17 | |||
94720 | 64274 | Permitted Site 7 | Tree(s) :: 17 | 1916 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/1988 12:00:00 AM | Permit Number 25078 | 6009971.60434107 | 2120647.29275281 | 37.8034552778135 | -122.40970200099 | (37.8034552778135, -122.40970200099) | 3 | 1 | 10 | 308 | 23 | |||
66056 | 58317 | Permitted Site 7 | Tree(s) :: 17 | 1914 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1982 12:00:00 AM | Permit Number 19536 | 6009972.82091536 | 2120638.49315762 | 37.8034311844802 | -122.409697169486 | (37.8034311844802, -122.409697169486) | 3 | 1 | 10 | 308 | 23 | |||
164372 | 68835 | Permitted Site 7 | Tree(s) :: 17 | 2270 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2011 12:00:00 AM | Permit Number 767177 | 5999361.06837518 | 2120851.91110281 | 37.8034167987103 | -122.446434792903 | (37.8034167987103, -122.446434792903) | 13 | 9 | 1 | 57 | 17 | |||
112519 | 66025 | Permitted Site 7 | Tree(s) :: 17 | 3554 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1990 12:00:00 AM | Permit Number 29061 | 6001221.84844011 | 2120812.28041218 | 37.8034140869284 | -122.439992661315 | (37.8034140869284, -122.439992661315) | 13 | 9 | 1 | 57 | 17 | |||
62735 | 143025 | DPW Maintained 1 | Tree(s) :: 17 | 2147 MASON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2008 12:00:00 AM | 4 | Width 0ft | Permit Number 51763 | 6008956.6469 | 2120652.8991 | 37.8034137432208 | -122.413214712493 | (37.8034137432208, -122.413214712493) | 3 | 1 | 10 | 308 | 23 | |
184278 | 134809 | DPW Maintained 1 | Tree(s) :: 17 | 2430 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | Permit Number 778843 | 6007053.11654 | 2120656.70313 | 37.8033171384475 | -122.419802238604 | (37.8033171384475, -122.419802238604) | 5 | 1 | 1 | 28858 | 32 | ||
89552 | 107399 | Significant Tree 6 | Tree(s) :: 17 | 1300X Sansome St | 1 | Front Yard : Yard | Tree | Private 2 | 09/02/2014 12:00:00 AM | 3 | Permit Number 772689 | 6012222 | 2120529 | 37.8032563246841 | -122.401906046114 | (37.8032563246841, -122.401906046114) | 3 | 1 | 10 | 28860 | 6 | ||
74330 | 36193 | Permitted Site 7 | Tree(s) :: 17 | 150 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 39259 | 6012022.89460249 | 2120526.4557937 | 37.8032382250246 | -122.402594881782 | (37.8032382250246, -122.402594881782) | 3 | 1 | 10 | 28860 | 6 | ||||
77143 | 36192 | Permitted Site 7 | Tree(s) :: 17 | 150 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 39259 | 6012022.89460249 | 2120526.4557937 | 37.8032382250246 | -122.402594881782 | (37.8032382250246, -122.402594881782) | 3 | 1 | 10 | 28860 | 6 | ||||
87049 | 59920 | Permitted Site 7 | Tree(s) :: 17 | 1757 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1981 12:00:00 AM | Permit Number 19390 | 6010408.855593 | 2120529.5255822 | 37.8031564111073 | -122.408180557039 | (37.8031564111073, -122.408180557039) | 3 | 1 | 10 | 308 | 23 | |||
6104 | 92481 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 12 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
61377 | 92475 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 5 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
62383 | 92476 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 6 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
63865 | 92484 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 15 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
74399 | 92474 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 4 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
94535 | 87564 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 3 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
130338 | 92480 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 10 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
139299 | 87562 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 1 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
181279 | 87563 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 2 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 | ||
192331 | 92485 | Permitted Site 7 | Tree(s) :: 17 | 155 Greenwich St | 11 | Back Yard : Yard | Tree | Private 2 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015 | 2120477 | 37.8031019907049 | -122.402618721555 | (37.8031019907049, -122.402618721555) | 3 | 1 | 10 | 28860 | 6 |
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) );