trees
1,024 rows where qSpecies_id = 72 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6999 | 137503 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1142 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 6007446.54333 | 2119552.35251 | 37.8003070257165 | -122.418362418606 | (37.8003070257165, -122.418362418606) | 5 | 1 | 1 | 28858 | 32 | |||
34027 | 137506 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 150 Francisco St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6010570.56702 | 2121351.03968 | 37.8054211392381 | -122.407678906174 | (37.8054211392381, -122.407678906174) | 3 | 1 | 10 | 308 | 23 | |||
56430 | 250212 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 300 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 6011360.92473 | 2120092.038 | 37.8020084404915 | -122.404855058325 | (37.8020084404915, -122.404855058325) | 3 | 1 | 10 | 308 | 23 | |||
68099 | 249965 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 265 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 19 | Width 0ft | 6011638.85917 | 2120086.18138 | 37.8020078910172 | -122.403892855668 | (37.8020078910172, -122.403892855668) | 3 | 1 | 10 | 308 | 23 | |||
103195 | 137504 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2521 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007440.32409 | 2121045.18765 | 37.8044056238841 | -122.418489853424 | (37.8044056238841, -122.418489853424) | 5 | 1 | 1 | 28858 | 32 | |||
123621 | 52601 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1360WASHINGTON Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2006 12:00:00 AM | 12 | Permit Number 48694 | 6008501.73087 | 2117208.37484 | 37.7939303854283 | -122.414545082491 | (37.7939303854283, -122.414545082491) | 5 | 1 | 10 | 28857 | 21 | ||
175206 | 137505 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2521 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007440.6556 | 2121042.48362 | 37.8043982179661 | -122.418488514346 | (37.8043982179661, -122.418488514346) | 5 | 1 | 1 | 28858 | 32 | |||
185172 | 137502 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1360 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008496.5924 | 2117239.72456 | 37.7940161753676 | -122.414565081618 | (37.7940161753676, -122.414565081618) | 5 | 1 | 10 | 28857 | 21 | |||
728 | 102430 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.7794962351107 | -122.407028471514 | (37.7794962351107, -122.407028471514) | 14 | 2 | 9 | 28853 | 34 | |
3775 | 262460 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 88 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009992 | 2112469 | 37.7810008079546 | -122.409054015659 | (37.7810008079546, -122.409054015659) | 14 | 2 | 9 | 28853 | 34 | ||||
4818 | 102421 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010161.06831 | 2112431.87946 | 37.7809083532874 | -122.408466502752 | (37.7809083532874, -122.408466502752) | 14 | 2 | 9 | 28853 | 34 | |||
11007 | 260556 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 5ft | 6007048.80869 | 2109949.46518 | 37.7739174571708 | -122.41905723302 | (37.7739174571708, -122.41905723302) | 8 | 2 | 9 | 28853 | 19 | ||||
14282 | 84749 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 21 | Permit No. 49304 | 6015056.82948 | 2111496.40969 | 37.7786127186366 | -122.391464102698 | (37.7786127186366, -122.391464102698) | 6 | 2 | 9 | 28856 | 20 | ||
14666 | 102429 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.407076563634 | (37.7795357369219, -122.407076563634) | 14 | 2 | 9 | 28853 | 34 | |
19024 | 262461 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 88 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009992 | 2112469 | 37.7810008079546 | -122.409054015659 | (37.7810008079546, -122.409054015659) | 14 | 2 | 9 | 28853 | 34 | ||||
20345 | 243951 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.7742824946758 | -122.419184822535 | (37.7742824946758, -122.419184822535) | 8 | 2 | 9 | 28853 | 19 | |
23350 | 49326 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 690 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013271.22314 | 2110393.49802 | 37.7754851058895 | -122.397563870475 | (37.7754851058895, -122.397563870475) | 14 | 2 | 9 | 28856 | 20 | ||
24566 | 199505 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 121 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009689.53245 | 2111610.6533 | 37.7786270421403 | -122.410039791109 | (37.7786270421403, -122.410039791109) | 14 | 2 | 9 | 28853 | 34 | |||
24970 | 243952 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007022.68787 | 2110044.22077 | 37.7741761624211 | -122.419154312126 | (37.7741761624211, -122.419154312126) | 8 | 2 | 9 | 28853 | 19 | |
34266 | 95855 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 185 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010497.41028 | 2112077.91159 | 37.7799552706525 | -122.407277965014 | (37.7799552706525, -122.407277965014) | 14 | 2 | 9 | 28853 | 34 | |||
40838 | 243953 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007037.92355 | 2109985.61989 | 37.7740161163944 | -122.419097451613 | (37.7740161163944, -122.419097451613) | 8 | 2 | 9 | 28853 | 19 | |
41672 | 56949 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 87 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | 14 | 2 | 9 | 28853 | 34 | ||
50152 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
52356 | 203196 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Market St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 10ft | 6013792.25217 | 2116838.17263 | 37.7932096975269 | -122.396213271333 | (37.7932096975269, -122.396213271333) | 12 | 2 | 9 | 28855 | 6 | |||
52634 | 95854 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 185 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010514.67057 | 2112059.04775 | 37.7799044409625 | -122.407216923546 | (37.7799044409625, -122.407216923546) | 14 | 2 | 9 | 28853 | 34 | |||
53847 | 199501 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1012 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6010462.04247 | 2111980.93801 | 37.7796870244685 | -122.407393480232 | (37.7796870244685, -122.407393480232) | 14 | 2 | 9 | 28853 | 34 | |||
57241 | 253248 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
60543 | 199491 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 991 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6010160.46278 | 2112475.94927 | 37.7810293246804 | -122.408471707117 | (37.7810293246804, -122.408471707117) | 14 | 2 | 9 | 28853 | 34 | |||
61740 | 199495 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 87 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6010059.47218 | 2112539.81003 | 37.7811990150662 | -122.408825592144 | (37.7811990150662, -122.408825592144) | 14 | 2 | 9 | 28853 | 34 | |||
67863 | 62745 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 121 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1986 12:00:00 AM | 13 | Permit Number 23093 | 6009715.48574 | 2111589.25493 | 37.7785697418509 | -122.409948497336 | (37.7785697418509, -122.409948497336) | 14 | 2 | 9 | 28853 | 34 | ||
70745 | 26392 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1615X Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007128.16796 | 2109448.95649 | 37.7725476481609 | -122.418747213269 | (37.7725476481609, -122.418747213269) | 8 | 2 | 9 | 28853 | 19 | |||
76866 | 199443 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 625 King St | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 4ft | 6012254.77347 | 2108757.11148 | 37.7709353106325 | -122.400965034535 | (37.7709353106325, -122.400965034535) | 14 | 2 | 8 | 28856 | 20 | |||
77689 | 102432 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 982 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 4x4 | 6010557.78599 | 2112071.21552 | 37.7799402636687 | -122.407068625328 | (37.7799402636687, -122.407068625328) | 14 | 2 | 9 | 28853 | 34 | |||
77729 | 100555 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 | |||
79536 | 100875 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 995 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6010609.42845 | 2112029.45593 | 37.7798284914364 | -122.406887026109 | (37.7798284914364, -122.406887026109) | 14 | 2 | 9 | 28853 | 34 | ||||
79696 | 253247 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
81318 | 199494 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 281 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010924.08558 | 2111634.58421 | 37.7787618676114 | -122.405770660782 | (37.7787618676114, -122.405770660782) | 14 | 2 | 9 | 28853 | 34 | |||
82101 | 246312 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1601 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6007098.251 | 2109393.5574 | 37.7723938509682 | -122.418846769596 | (37.7723938509682, -122.418846769596) | 8 | 2 | 9 | 28853 | 19 | |||
90173 | 243954 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007048.80869 | 2109949.46518 | 37.7739174571708 | -122.41905723302 | (37.7739174571708, -122.41905723302) | 8 | 2 | 9 | 28853 | 19 | |
92502 | 102420 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6010175.35097 | 2112415.36622 | 37.7808638116673 | -122.408415926663 | (37.7808638116673, -122.408415926663) | 14 | 2 | 9 | 28853 | 34 | |||
93259 | 253749 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 2x Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
99500 | 199497 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 72 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6010024.2102 | 2112481.0403 | 37.7810356721041 | -122.408943433887 | (37.7810356721041, -122.408943433887) | 14 | 2 | 9 | 28853 | 34 | |||
107868 | 243955 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 80 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007056.38142 | 2109908.18867 | 37.7738045481647 | -122.419028109365 | (37.7738045481647, -122.419028109365) | 8 | 2 | 9 | 28853 | 19 | |
108937 | 84746 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 22 | Permit No. 49304 | 6015095.84023 | 2111532.74661 | 37.778714656793 | -122.391331689209 | (37.778714656793, -122.391331689209) | 6 | 2 | 9 | 28856 | 20 | ||
109117 | 243946 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 142 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007170.22447 | 2109376.5199 | 37.7723511223453 | -122.418596597579 | (37.7723511223453, -122.418596597579) | 8 | 2 | 9 | 28853 | 19 | |||
109444 | 255700 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 510 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
111082 | 84748 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015067.98121 | 2111507.0743 | 37.7786426202078 | -122.391426270004 | (37.7786426202078, -122.391426270004) | 6 | 2 | 9 | 28856 | 20 | ||
115969 | 102431 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 982 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6010575.87494 | 2112088.03468 | 37.7799874573922 | -122.407007233096 | (37.7799874573922, -122.407007233096) | 14 | 2 | 9 | 28853 | 34 | |||
119245 | 243948 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 11 | Width 5ft | Permit Number 47529 | 6006987.09759 | 2110205.04369 | 37.7746157393567 | -122.419288836304 | (37.7746157393567, -122.419288836304) | 8 | 2 | 9 | 28853 | 19 | |
119349 | 243949 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 12 | Width 5ft | Permit Number 47529 | 6006997.01742 | 2110160.92453 | 37.7744951573695 | -122.419251391244 | (37.7744951573695, -122.419251391244) | 8 | 2 | 9 | 28853 | 19 | |
120071 | 84745 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 18 | Permit No. 49304 | 6015113.58647 | 2111549.96085 | 37.7787629081139 | -122.391271501195 | (37.7787629081139, -122.391271501195) | 6 | 2 | 9 | 28856 | 20 | ||
120859 | 199506 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 121 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009672.01904 | 2111627.24224 | 37.778671609854 | -122.410101548456 | (37.778671609854, -122.410101548456) | 14 | 2 | 9 | 28853 | 34 | |||
122841 | 258453 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 98x 12th St | 4 | Median : Cutout | Tree | DPW 1 | Width 3ft | 6007064.67073 | 2109775.44951 | 37.7734405448826 | -122.41899001857 | (37.7734405448826, -122.41899001857) | 8 | 2 | 9 | 28853 | 19 | ||||
128513 | 199503 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.98308 | 2111924.50305 | 37.7795342467397 | -122.407254787701 | (37.7795342467397, -122.407254787701) | 14 | 2 | 9 | 28853 | 34 | |
132587 | 199504 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | 14 | 2 | 9 | 28853 | 34 | |
138663 | 112172 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 998X MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010071 | 2112545 | 37.7812139111906 | -122.408786077679 | (37.7812139111906, -122.408786077679) | 14 | 2 | 9 | 28853 | 34 | ||||
139922 | 102426 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010110.95279 | 2112392.33205 | 37.780796958746 | -122.408637087058 | (37.780796958746, -122.408637087058) | 14 | 2 | 9 | 28853 | 34 | |||
141961 | 243950 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.7744118459669 | -122.419222267617 | (37.7744118459669, -122.419222267617) | 8 | 2 | 9 | 28853 | 19 | |
144253 | 84744 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015122.21866 | 2111558.9441 | 37.7787880531604 | -122.391242266936 | (37.7787880531604, -122.391242266936) | 6 | 2 | 9 | 28856 | 20 | ||
144530 | 100554 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 | |||
148508 | 49637 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 63 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.7729020327715 | -122.416906845471 | (37.7729020327715, -122.416906845471) | 8 | 2 | 9 | 28853 | 19 | |
150821 | 243947 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 142 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007173.3402 | 2109359.55607 | 37.7723047191127 | -122.418584616798 | (37.7723047191127, -122.418584616798) | 8 | 2 | 9 | 28853 | 19 | |||
151031 | 203197 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Market St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 17 | Width 10ft | 6013808.49559 | 2116854.49545 | 37.7932554199655 | -122.396158212135 | (37.7932554199655, -122.396158212135) | 12 | 2 | 9 | 28855 | 6 | |||
151601 | 243945 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007159.40036 | 2109389.15821 | 37.7723852147468 | -122.418634935659 | (37.7723852147468, -122.418634935659) | 8 | 2 | 9 | 28853 | 19 | |||
152749 | 100874 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 995 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 6010596.81703 | 2112015.71985 | 37.7797900696951 | -122.406929686375 | (37.7797900696951, -122.406929686375) | 14 | 2 | 9 | 28853 | 34 | ||||
156472 | 199498 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1008 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6010028.24719 | 2112434.38373 | 37.7809077903144 | -122.40892617503 | (37.7809077903144, -122.40892617503) | 14 | 2 | 9 | 28853 | 34 | |||
157382 | 243944 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 142 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007141.91365 | 2109397.79413 | 37.7724079424095 | -122.418696036515 | (37.7724079424095, -122.418696036515) | 8 | 2 | 9 | 28853 | 19 | |||
160516 | 199502 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1012 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6010449.4105 | 2111969.43782 | 37.7796547406221 | -122.40743636892 | (37.7796547406221, -122.40743636892) | 14 | 2 | 9 | 28853 | 34 | |||
160803 | 49325 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 690 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013241.30936 | 2110424.30224 | 37.7755680215912 | -122.397669511153 | (37.7755680215912, -122.397669511153) | 14 | 2 | 9 | 28856 | 20 | ||
161612 | 102418 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 201 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010625.41098 | 2111944.37614 | 37.7795957765601 | -122.406825737323 | (37.7795957765601, -122.406825737323) | 14 | 2 | 9 | 28853 | 34 | |||
163114 | 253748 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 2x Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
164154 | 102419 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 201 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010609.19256 | 2111959.7498 | 37.7796370815369 | -122.406882927918 | (37.7796370815369, -122.406882927918) | 14 | 2 | 9 | 28853 | 34 | |||
164469 | 49327 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 650 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2003 12:00:00 AM | 17 | Permit Number 46321 | 6013204.31889 | 2110464.18207 | 37.7756754626729 | -122.397800268992 | (37.7756754626729, -122.397800268992) | 14 | 2 | 9 | 28856 | 20 | ||
166714 | 199492 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 281 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6010946.44549 | 2111612.84065 | 37.7787034152643 | -122.405691776779 | (37.7787034152643, -122.405691776779) | 14 | 2 | 9 | 28853 | 34 | |||
167532 | 203199 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 690 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6013299.63411 | 2110362.29852 | 37.7754010210678 | -122.397463400913 | (37.7754010210678, -122.397463400913) | 14 | 2 | 9 | 28856 | 20 | |||
168306 | 199496 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 87 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 4ft | 6010015.0817 | 2112492.094 | 37.7810655116096 | -122.408975794194 | (37.7810655116096, -122.408975794194) | 14 | 2 | 9 | 28853 | 34 | |||
169472 | 199490 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 483 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6010121.32315 | 2112524.17075 | 37.7811595375133 | -122.408610513875 | (37.7811595375133, -122.408610513875) | 14 | 2 | 9 | 28853 | 34 | |||
169608 | 199500 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 184 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6010448.06676 | 2112033.83872 | 37.7798314951708 | -122.407445559076 | (37.7798314951708, -122.407445559076) | 14 | 2 | 9 | 28853 | 34 | |||
170619 | 84747 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 170 King St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 19 | Permit No. 49304 | 6015084.20168 | 2111522.58673 | 37.7786861141091 | -122.391371241385 | (37.7786861141091, -122.391371241385) | 6 | 2 | 9 | 28856 | 20 | ||
170750 | 199499 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1008 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6009970.38295 | 2112379.67473 | 37.7807543308744 | -122.4091224952 | (37.7807543308744, -122.4091224952) | 14 | 2 | 9 | 28853 | 34 | |||
172235 | 51395 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1050X Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007651 | 2109542 | 37.7728325469688 | -122.416945272606 | (37.7728325469688, -122.416945272606) | 8 | 2 | 9 | 28853 | 19 |
172595 | 49328 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 650 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2003 12:00:00 AM | 19 | Permit Number 46321 | 6013181.12431 | 2110489.32106 | 37.7757431969273 | -122.397882269155 | (37.7757431969273, -122.397882269155) | 14 | 2 | 9 | 28856 | 20 | ||
174742 | 258452 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 98x 12th St | 3 | Median : Cutout | Tree | DPW 1 | Width 3ft | 6007064.67073 | 2109775.44951 | 37.7734405448826 | -122.41899001857 | (37.7734405448826, -122.41899001857) | 8 | 2 | 9 | 28853 | 19 | ||||
175248 | 51396 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 63 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.7729020327715 | -122.416906845471 | (37.7729020327715, -122.416906845471) | 8 | 2 | 9 | 28853 | 19 | |
176053 | 30858 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 99 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
177074 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
177172 | 49324 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 650 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2003 12:00:00 AM | Permit Number 46321 | 6013145.06683573 | 2110537.17362663 | 37.775872581057 | -122.398010359546 | (37.775872581057, -122.398010359546) | 14 | 2 | 9 | 28856 | 20 | |||
184823 | 199493 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 281 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6010934.97193 | 2111623.29262 | 37.7787314723253 | -122.405732204886 | (37.7787314723253, -122.405732204886) | 14 | 2 | 9 | 28853 | 34 | |||
186817 | 102428 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 184 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010438.87034 | 2112046.078 | 37.7798645866165 | -122.407478236832 | (37.7798645866165, -122.407478236832) | 14 | 2 | 9 | 28853 | 34 | |||
187618 | 253249 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
189711 | 203198 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Market St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.396090087604 | (37.7933092533841, -122.396090087604) | 12 | 2 | 9 | 28855 | 6 | |||
191738 | 102441 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1007X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010078.92624 | 2112396.71132 | 37.7808071894337 | -122.408748191999 | (37.7808071894337, -122.408748191999) | 14 | 2 | 9 | 28853 | 34 | |||
653 | 262559 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1209 | 199473 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6015478.1467 | 2109531.70871 | 37.7732414619454 | -122.389869319627 | (37.7732414619454, -122.389869319627) | 14 | 3 | 9 | 310 | 20 | |||
1778 | 262558 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
1943 | 262553 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2094 | 262557 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2398 | 262570 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
2589 | 262566 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 | ||||
3606 | 262564 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015928 | 2106803 | 37.7657739601897 | -122.388122739596 | (37.7657739601897, -122.388122739596) | 14 | 3 | 9 | 310 | 29 |
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) );