trees
953 rows where qSpecies_id = 60 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128 | 110722 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
1204 | 72270 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 619 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002965.14713 | 2089877.08907 | 37.7185725974338 | -122.431749858784 | (37.7185725974338, -122.431749858784) | 9 | 7 | 6 | 28861 | 5 | |||
1684 | 65960 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2514 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 11 | Permit Number 28982 | 5988016.2527 | 2098169.589 | 37.7404829512667 | -122.484029196034 | (37.7404829512667, -122.484029196034) | 1 | 8 | 3 | 29491 | 35 | |
2438 | 262446 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 55 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | 6001156 | 2093630 | 37.7287745209628 | -122.438272037819 | (37.7287745209628, -122.438272037819) | 9 | 7 | 6 | 28861 | 25 | |||
2627 | 44717 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1991 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | Permit Number 43839 | 5989704.86545465 | 2101822.42727681 | 37.7506108546658 | -122.478457743126 | (37.7506108546658, -122.478457743126) | 1 | 8 | 3 | 29491 | 35 | ||
3037 | 73418 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5983001.5767 | 2098246.6338 | 37.7404012697688 | -122.50137340388 | (37.7404012697688, -122.50137340388) | 1 | 8 | 3 | 29491 | 35 | |||
3060 | 70445 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982997.1409 | 2098317.8833 | 37.7405966408958 | -122.501394010052 | (37.7405966408958, -122.501394010052) | 1 | 8 | 3 | 29491 | 35 | |||
3893 | 78349 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | 11 | 6 | 2 | 55 | 26 | |||
4319 | 71268 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | 15 | 5 | 11 | 29492 | 16 | |||
5626 | 52490 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.5363144 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | 2 | 7 | 7 | 28859 | 2 | ||
5884 | 44280 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.82633 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | 10 | 3 | 8 | 58 | 1 | ||
6670 | 48442 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
8029 | 70268 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 656 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6002561.31186 | 2089826.69987 | 37.7184113400032 | -122.433142152308 | (37.7184113400032, -122.433142152308) | 9 | 7 | 6 | 28861 | 5 | |||
8978 | 71997 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 362 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989369.28583 | 2112922.15861 | 37.7810682079879 | -122.48043057365 | (37.7810682079879, -122.48043057365) | 11 | 6 | 2 | 55 | 26 | |||
11282 | 258111 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1647 23rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5989010.97347 | 2104127.32105 | 37.756899168939 | -122.481025994257 | (37.756899168939, -122.481025994257) | 1 | 8 | 3 | 56 | 35 | ||||||
11406 | 72840 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2634 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5989285.167 | 2097358.0202 | 37.7383283873436 | -122.479582470664 | (37.7383283873436, -122.479582470664) | 1 | 8 | 3 | 29491 | 35 | |||
12444 | 260536 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5983685.38782 | 2106695.21091 | 37.7636388518254 | -122.499633347112 | (37.7636388518254, -122.499633347112) | 1 | 8 | 3 | 56 | 35 | ||||
13343 | 69152 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1245 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 5 | Permit Number 33187 | 5986742.1857 | 2106776.7875 | 37.7640417272514 | -122.48906697906 | (37.7640417272514, -122.48906697906) | 1 | 8 | 3 | 56 | 35 | |
16342 | 71996 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 340 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989363.9833 | 2113075.99146 | 37.7814902817874 | -122.48046018125 | (37.7814902817874, -122.48046018125) | 11 | 6 | 2 | 55 | 26 | |||
16761 | 72980 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.485044488235 | (37.7550761133303, -122.485044488235) | 1 | 8 | 3 | 56 | 35 | |||
17381 | 78348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5986606.5677 | 2110833.25993 | 37.7751717483754 | -122.489834389598 | (37.7751717483754, -122.489834389598) | 11 | 6 | 2 | 55 | 26 | |||
17506 | 32483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 10 | Permit Number 36991 | 6001817.38914 | 2106232.68155 | 37.763416104203 | -122.436887416735 | (37.763416104203, -122.436887416735) | 15 | 5 | 5 | 28862 | 3 | |
17900 | 262447 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 31 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 6001222 | 2093679 | 37.7289128173751 | -122.4380473805 | (37.7289128173751, -122.4380473805) | 9 | 7 | 6 | 28861 | 25 | ||
18161 | 56725 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1519 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015793.5491 | 2095580.2933 | 37.7349513047544 | -122.387804649295 | (37.7349513047544, -122.387804649295) | 10 | 3 | 8 | 58 | 1 | ||||
19123 | 30366 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694 | -122.397947987108 | (37.756469231694, -122.397947987108) | 10 | 3 | 8 | 28856 | 29 | |
20019 | 66828 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 154 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 5 | Permit Number 30314 | 5996849.4776 | 2111929.315 | 37.7787739785332 | -122.454481262068 | (37.7787739785332, -122.454481262068) | 15 | 6 | 2 | 54 | 16 | |
23509 | 44343 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 233 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2001 12:00:00 AM | Permit Number 43727 | 5991164.04904901 | 2113857.0036857 | 37.7837391697575 | -122.474289891692 | (37.7837391697575, -122.474289891692) | 11 | 6 | 2 | 54 | 26 | |||
24116 | 175767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | 1 | 8 | 4 | 64 | 14 | ||||
24194 | 32579 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.7638481208517 | -122.492272911774 | (37.7638481208517, -122.492272911774) | 1 | 8 | 3 | 56 | 35 | |
24510 | 204663 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000334.21865 | 2095199.11319 | 37.7330361672695 | -122.44122551784 | (37.7330361672695, -122.44122551784) | 9 | 7 | 5 | 63 | 40 | ||||
25164 | 56716 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1522 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015807.4304 | 2095648.0005 | 37.7351379840188 | -122.387761378928 | (37.7351379840188, -122.387761378928) | 10 | 3 | 8 | 58 | 1 | ||||
26486 | 47221 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
26513 | 39670 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
26892 | 56727 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1531 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6015734.3799 | 2095622.8211 | 37.7350647995931 | -122.388012186614 | (37.7350647995931, -122.388012186614) | 10 | 3 | 8 | 58 | 1 | ||||
27376 | 35610 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 325 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38967 | 5992638.71984217 | 2094691.8038829 | 37.7312018573426 | -122.467793768821 | (37.7312018573426, -122.467793768821) | 9 | 8 | 4 | 59 | 40 | |||
29254 | 71993 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | 11 | 6 | 2 | 55 | 26 | ||
30618 | 97004 | Property Tree 8 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195A Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
32778 | 47219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | 9 | 3 | 7 | 309 | 28 | |
33218 | 34342 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12661268 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38099 | 6010039 | 2101826 | 37.7517801982502 | -122.408140586549 | (37.7517801982502, -122.408140586549) | 2 | 4 | 7 | 28859 | 19 | ||
33277 | 69157 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1259 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33193 | 5983030.0636 | 2106498.5077 | 37.7630602867444 | -122.501885316454 | (37.7630602867444, -122.501885316454) | 1 | 8 | 3 | 56 | 35 | |
34069 | 247043 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 596 Valley St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6002094.89222 | 2099164.93967 | 37.7440255436471 | -122.435422008318 | (37.7440255436471, -122.435422008318) | 2 | 7 | 5 | 63 | 22 | ||||
34147 | 110720 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
34811 | 109380 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 725X BURNETT AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999257.1 | 2101645.9 | 37.7506760851616 | -122.445412771855 | (37.7506760851616, -122.445412771855) | 2 | 5 | 5 | 63 | 38 | |||||
36075 | 175765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5988629.85447 | 2089774.30196 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | 1 | 8 | 4 | 64 | 14 | ||||
37830 | 31102 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 215 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 6 | Permit Number 34832 | 6000072.59523 | 2094462.74015 | 37.7309993521219 | -122.442077177628 | (37.7309993521219, -122.442077177628) | 9 | 7 | 4 | 63 | 40 | |
37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
39187 | 33577 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37685 | 6007025.08907683 | 2097945.62097714 | 37.7409563345382 | -122.418288026055 | (37.7409563345382, -122.418288026055) | 2 | 7 | 7 | 28859 | 2 | |||
39368 | 43890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.7758395125283 | -122.41192485917 | (37.7758395125283, -122.41192485917) | 8 | 2 | 9 | 28853 | 34 | ||
40222 | 87642 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004813.344433 | 2112300.663017 | 37.7802471321724 | -122.426957567511 | (37.7802471321724, -122.426957567511) | 7 | 9 | 11 | 28852 | 41 | |||||
40426 | 47227 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 | ||
40666 | 110721 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
40733 | 46346 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44592 | 6005461.4442402 | 2101476.38644964 | 37.7505628685682 | -122.423945552398 | (37.7505628685682, -122.423945552398) | 2 | 4 | 5 | 28859 | 19 | ||
40880 | 39219 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | 9 | 8 | 6 | 64 | 24 | |||
41380 | 39674 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.7184378644924 | -122.462552614145 | (37.7184378644924, -122.462552614145) | 9 | 8 | 6 | 28861 | 24 | ||
42114 | 40737 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41716 | 6009144.8463962 | 2096601.1649491 | 37.737383844528 | -122.410863725513 | (37.737383844528, -122.410863725513) | 10 | 7 | 7 | 28859 | 2 | ||
42932 | 49808 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1546ARKANSAS 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46602 | 6013062.18652198 | 2105692.25425348 | 37.7625649012206 | -122.397957118424 | (37.7625649012206, -122.397957118424) | 14 | 3 | 8 | 28856 | 29 | ||
42933 | 38322 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | 8 | 4 | 7 | 28853 | 19 | ||
44456 | 37238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.7557291928217 | -122.48675431687 | (37.7557291928217, -122.48675431687) | 1 | 8 | 3 | 56 | 35 | ||
44477 | 204639 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 185 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5998393.85271 | 2093179.60638 | 37.7273803570158 | -122.447788509344 | (37.7273803570158, -122.447788509344) | 9 | 7 | 4 | 28861 | 40 | ||||
44825 | 52659 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 501@ SCOTT Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 8 | Permit Number 48739 | 6000536.81736 | 2121641.57816 | 37.8056520959413 | -122.44242280509 | (37.8056520959413, -122.44242280509) | 13 | 9 | 1 | 57 | 17 | ||
45162 | 100793 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Recently planted by FUF. | 6008363 | 2103862 | 37.7572766073656 | -122.414080464335 | (37.7572766073656, -122.414080464335) | 2 | 4 | 7 | 28859 | 19 | ||||
46708 | 37017 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39630 | 6008600.86286293 | 2102426.42877225 | 37.7533482108195 | -122.413156329636 | (37.7533482108195, -122.413156329636) | 2 | 4 | 7 | 28859 | 19 | ||
47496 | 45707 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.0354809 | 2103995.03426473 | 37.7571302242183 | -122.445339815815 | (37.7571302242183, -122.445339815815) | 2 | 5 | 5 | 28862 | 3 | |||
48513 | 36468 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.7289687842477 | -122.456513863949 | (37.7289687842477, -122.456513863949) | 9 | 7 | 4 | 28861 | 40 | ||
51152 | 108581 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1X GARDENSIDE DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999463 | 2102872 | 37.7540544083949 | -122.44478887768 | (37.7540544083949, -122.44478887768) | 2 | 5 | 5 | 63 | 38 | |||||
51550 | 175773 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990089.90179 | 2089410.48117 | 37.7165531625873 | -122.476219779021 | (37.7165531625873, -122.476219779021) | 1 | 8 | 4 | 64 | 14 | ||||
53155 | 46798 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.462081536077 | (37.7338125312017, -122.462081536077) | 9 | 8 | 4 | 59 | 40 | ||
53960 | 47228 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45171 | 6011142.39624 | 2091994.05057 | 37.724845479317 | -122.403633167442 | (37.724845479317, -122.403633167442) | 10 | 3 | 7 | 309 | 28 | |
54152 | 48439 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
54184 | 56623 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001932.70639357 | 2100631.3679946 | 37.7480427977008 | -122.43608772435 | (37.7480427977008, -122.43608772435) | 2 | 4 | 5 | 28862 | 22 | |||||
54578 | 99239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | 1 | 8 | 4 | 59 | 40 | ||||
56273 | 43665 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296 | (37.7832926725519, -122.47097524296) | 11 | 6 | 2 | 54 | 11 | |
56301 | 33288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.413361726687 | (37.7925058062477, -122.413361726687) | 5 | 1 | 10 | 28857 | 21 | |
58561 | 39663 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
61548 | 34932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2770 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1997 12:00:00 AM | 5 | Permit Number 38524 | 6000272.2691 | 2114453.3621 | 37.7859000712136 | -122.442821815392 | (37.7859000712136, -122.442821815392) | 13 | 6 | 1 | 29490 | 27 | ||
62828 | 39705 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 | ||
63122 | 36807 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Donner Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 8 | Permit Number 39531 | 6014713.4944 | 2091220.9181 | 37.7229214477716 | -122.391234181927 | (37.7229214477716, -122.391234181927) | 10 | 3 | 8 | 58 | 1 | |
66695 | 175758 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Tocoloma Ave | 5 | Front Yard : Yard | Tree | Private 2 | 4 | 6012839.87945 | 2087571.56346 | 37.7127968922232 | -122.397455115464 | (37.7127968922232, -122.397455115464) | 10 | 3 | 8 | 309 | 1 | ||||
66804 | 48736 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1633 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2002 12:00:00 AM | Permit Number 46017 | 6015017.13579754 | 2095815.21126112 | 37.7355533009373 | -122.39050541553 | (37.7355533009373, -122.39050541553) | 10 | 3 | 8 | 58 | 1 | ||
67527 | 30677 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 920 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 8 | Permit Number 34600 | 6008142.25986 | 2110035.66546 | 37.7742156570679 | -122.415280896104 | (37.7742156570679, -122.415280896104) | 8 | 2 | 9 | 28853 | 34 | |
67658 | 56722 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1560 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1974 12:00:00 AM | 9 | Permit Number 13995 | 6015605.7227 | 2095794.747 | 37.7355297446147 | -122.388469000899 | (37.7355297446147, -122.388469000899) | 10 | 3 | 8 | 58 | 1 | ||
72542 | 39664 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
72634 | 104807 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2069 GREEN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003141.4 | 2118171.7 | 37.7962728265697 | -122.433161198258 | (37.7962728265697, -122.433161198258) | 13 | 9 | 1 | 57 | 17 | ||||||
74586 | 113271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1321 Revere Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260 | 37.7286210040554 | -122.385097187433 | (37.7286210040554, -122.385097187433) | 10 | 3 | 8 | 58 | 1 | ||||
77330 | 37234 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
78077 | 37236 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
79794 | 63193 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 435 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 12 | Permit Number 23733 | 5984052.79771 | 2112895.3666 | 37.7806842528122 | -122.498820690126 | (37.7806842528122, -122.498820690126) | 11 | 6 | 2 | 55 | 26 | |
79831 | 102872 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 173 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.447738107529 | (37.7272185530423, -122.447738107529) | 9 | 7 | 4 | 28861 | 40 | ||||
80527 | 49416 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 17643RD/PHELPS La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 9 | Permit Number 46362 | 6014695.16416 | 2096823.71289 | 37.7383045729921 | -122.391689093304 | (37.7383045729921, -122.391689093304) | 10 | 3 | 8 | 58 | 1 | ||
80877 | 39671 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | 9 | 8 | 6 | 28861 | 24 | ||
81468 | 27528 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/25/2002 12:00:00 AM | 3 | 6008310.55132 | 2093825.05625 | 37.7297144349525 | -122.413551995327 | (37.7297144349525, -122.413551995327) | 9 | 3 | 7 | 309 | 28 | |||
81616 | 45782 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 243 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2001 12:00:00 AM | Permit Number 44422 | 5992531.14944144 | 2097322.97472388 | 37.7384201816637 | -122.468357005493 | (37.7384201816637, -122.468357005493) | 1 | 8 | 4 | 59 | 40 | |||
81632 | 56717 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1526 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6015787.6443 | 2095659.5423 | 37.7351685794067 | -122.387830592307 | (37.7351685794067, -122.387830592307) | 10 | 3 | 8 | 58 | 1 | ||||
82760 | 47226 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 | ||
85373 | 32334 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 150 Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/1996 12:00:00 AM | Permit Number 36897 | 6000779.60429895 | 2103438.99609434 | 37.7556862897816 | -122.440276412657 | (37.7556862897816, -122.440276412657) | 2 | 4 | 5 | 63 | 38 | |||
86196 | 56136 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 755 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 17 | Permit Number 12240 | 6012456.10249 | 2104419.18715 | 37.7590355667492 | -122.3999639524 | (37.7590355667492, -122.3999639524) | 10 | 3 | 8 | 28856 | 29 | ||
88465 | 38107 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
88999 | 43891 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009112.33188 | 2110593.08814 | 37.7758006806963 | -122.411964629875 | (37.7758006806963, -122.411964629875) | 8 | 2 | 9 | 28853 | 34 | ||
89296 | 54694 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4605 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Permit Number 10525 | 5981277.89948 | 2110939.72797 | 37.7751515013754 | -122.508275023697 | (37.7751515013754, -122.508275023697) | 11 | 6 | 2 | 55 | 26 | ||
89668 | 39704 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 |
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) );