trees
1,626 rows where qSpecies_id = 53 sorted by PermitNotes descending
This data as json, CSV (advanced)
qCaretaker_id ✖
- Private 868
- DPW 544
- Rec/Park 37
- Dept of Real Estate 21
- Police Dept 14
- DPW for City Agency 12
- SFUSD 9
- Fire Dept 8
- Public Library 6
- MTA 4
- Housing Authority 2
- Arts Commission 1
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
140527 | 15263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51766 | 6007587.5132074 | 2110099.4827033 | 37.7743596907053 | -122.417204392502 | (37.7743596907053, -122.417204392502) | 8 | 2 | 9 | 28853 | 19 | |
187371 | 89021 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51766 | 6007445.1 | 2110006.7 | 37.7740969185595 | -122.417690449841 | (37.7740969185595, -122.417690449841) | 8 | 2 | 9 | 28853 | 19 | |||
21359 | 87146 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
111614 | 87145 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
172669 | 87144 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2405 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50131 | 6008226 | 2104427 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | 2 | 4 | 7 | 28859 | 19 | ||
170556 | 87134 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 65 Mars St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50103 | 5999603 | 2105413 | 37.7610393570971 | -122.444487333455 | (37.7610393570971, -122.444487333455) | 15 | 5 | 5 | 28862 | 3 | |||
60087 | 86905 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49869 | 6005775 | 2106383 | 37.7640529822515 | -122.423209987967 | (37.7640529822515, -122.423209987967) | 8 | 4 | 5 | 28859 | 19 | ||
49452 | 86740 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1275 02nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | 15 | 5 | 11 | 56 | 12 | |||||
15941 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 1 | unknown : Cutout | Tree | Private 2 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | ||||
124317 | 91126 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | |||
185458 | 91127 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | |||
189256 | 91128 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | |||
191709 | 52838 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 795on Trenton Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48857 | 6010309.20673902 | 2118158.51574656 | 37.7966406195852 | -122.408358059553 | (37.7966406195852, -122.408358059553) | 3 | 1 | 10 | 308 | 4 | ||||
172873 | 33586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 248 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2006 12:00:00 AM | 3x3 | Permit Number 48813 | 6006863.32350459 | 2097675.63643968 | 37.7402059100197 | -122.418828210102 | (37.7402059100197, -122.418828210102) | 2 | 7 | 7 | 28859 | 2 | ||
147353 | 52716 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1330on LARKIN Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | Permit Number 48769 | 6007121.03491046 | 2115409.40396286 | 37.7889131924877 | -122.419194766666 | (37.7889131924877, -122.419194766666) | 13 | 9 | 10 | 28858 | 21 | |||
190125 | 52718 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1330on LARKIN Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2006 12:00:00 AM | Permit Number 48769 | 6007121.03491046 | 2115409.40396286 | 37.7889131924877 | -122.419194766666 | (37.7889131924877, -122.419194766666) | 13 | 9 | 10 | 28858 | 21 | |||
49890 | 52592 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 327CALIFORNIA 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48686 | 5988048.64326864 | 2113784.56845539 | 37.7833593060301 | -122.48506257055 | (37.7833593060301, -122.48506257055) | 11 | 6 | 2 | 55 | 26 | ||||
38373 | 52226 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 423 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2005 12:00:00 AM | Permit Number 48405 | 5997634.34727934 | 2115023.86499621 | 37.7873157808513 | -122.451989424725 | (37.7873157808513, -122.451989424725) | 11 | 6 | 1 | 54 | 31 | |||
74708 | 52076 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 245x North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2005 12:00:00 AM | Permit Number 48272 | 6009556.06624176 | 2121873.83782792 | 37.8067997698403 | -122.41122668881 | (37.8067997698403, -122.41122668881) | 3 | 1 | 10 | 308 | 23 | |||
25882 | 40606 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 744 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48110 | 6011762.49765618 | 2117875.03517526 | 37.7959435248288 | -122.403309366526 | (37.7959435248288, -122.403309366526) | 3 | 1 | 10 | 28860 | 4 | |||
82985 | 51836 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
107778 | 51837 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
131150 | 51835 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 601 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | Permit Number 48064 | 6011231.99946686 | 2117956.55670314 | 37.7961377205174 | -122.405150744824 | (37.7961377205174, -122.405150744824) | 3 | 1 | 10 | 28857 | 4 | |||
177096 | 51793 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 65 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2005 12:00:00 AM | Permit Number 48042 | 6005279.64463313 | 2105087.60921781 | 37.7604681781651 | -122.42483111417 | (37.7604681781651, -122.42483111417) | 2 | 4 | 5 | 28859 | 19 | |||
83229 | 51761 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 Tehama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2005 12:00:00 AM | 8 | Permit Number 48028 | 6011451.43524212 | 2112543.5849209 | 37.781287248696 | -122.404010328515 | (37.781287248696, -122.404010328515) | 6 | 2 | 9 | 28853 | 34 | ||
139096 | 51485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 253 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2005 12:00:00 AM | Permit Number 47796 | 6004792.25802571 | 2102204.70843345 | 37.7525248690267 | -122.426311501214 | (37.7525248690267, -122.426311501214) | 2 | 4 | 5 | 28862 | 22 | |||
183408 | 50980 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 201 Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | 13 | 9 | 1 | 57 | 17 | ||
131379 | 50854 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1375 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47369 | 5999134.27629696 | 2108342.5104784 | 37.7690563017942 | -122.446319185318 | (37.7690563017942, -122.446319185318) | 15 | 5 | 11 | 29492 | 9 | |||
24098 | 50784 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 4425@ EUREKA 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2004 12:00:00 AM | Permit Number 47310 | 6001319.3692016 | 2105218.84665198 | 37.760604043869 | -122.438537258087 | (37.760604043869, -122.438537258087) | 2 | 4 | 5 | 28862 | 3 | |||
71942 | 50566 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
111853 | 99974 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||||
115348 | 50571 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
173070 | 50573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
66213 | 50374 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2727 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47038 | 6001577.22511674 | 2117761.13132823 | 37.7950566585474 | -122.43854412401 | (37.7950566585474, -122.43854412401) | 13 | 9 | 1 | 57 | 27 | ||||
169402 | 50375 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2727 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47038 | 6001577.22511674 | 2117761.13132823 | 37.7950566585474 | -122.43854412401 | (37.7950566585474, -122.43854412401) | 13 | 9 | 1 | 57 | 27 | ||||
114328 | 50197 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3279@ DOLORES 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/2003 12:00:00 AM | Permit Number 46903 | 6005006.02996154 | 2106599.52754391 | 37.7646040888867 | -122.425885045341 | (37.7646040888867, -122.425885045341) | 8 | 4 | 5 | 28859 | 19 | ||
110473 | 49870 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 607@ JACKSON Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2003 12:00:00 AM | Permit Number 46636 | 6012838.36008757 | 2118235.08187981 | 37.7969921557212 | -122.399611944085 | (37.7969921557212, -122.399611944085) | 3 | 1 | 10 | 28860 | 6 | |||
3559 | 55849 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2801X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/13/2003 12:00:00 AM | Permit Number 46336 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | 13 | 6 | 1 | 29490 | 27 | ||
3993 | 49288 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
40156 | 49286 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
45439 | 49260 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
60857 | 49274 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
69985 | 49269 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
81758 | 49264 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
91238 | 49276 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
95381 | 49285 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
95982 | 49266 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
103493 | 49277 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
117139 | 49290 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
118155 | 49258 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
129463 | 49287 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
136842 | 49263 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
144032 | 49294 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
147296 | 49297 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
151649 | 49289 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
172671 | 49251 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
174050 | 49256 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
177069 | 49259 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
40083 | 49240 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
45931 | 49235 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
114688 | 49239 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
125521 | 49234 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
128922 | 49236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
129993 | 49238 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
156149 | 49237 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
178044 | 48952 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3046 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | 28 | Permit Number 46137 | 6008657.12939462 | 2102169.92315078 | 37.7526470627455 | -122.412943613067 | (37.7526470627455, -122.412943613067) | 2 | 4 | 7 | 28859 | 19 | |
85569 | 48875 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 650 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2002 12:00:00 AM | Permit Number 46082 | 6002579.05689486 | 2108874.6714316 | 37.7707136224387 | -122.434441965818 | (37.7707136224387, -122.434441965818) | 15 | 5 | 11 | 29492 | 9 | |||
192777 | 48866 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 129 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2002 12:00:00 AM | Permit Number 46075 | 6006370.62112219 | 2110394.65908683 | 37.7751016387897 | -122.421434823029 | (37.7751016387897, -122.421434823029) | 7 | 9 | 11 | 28852 | 10 | |||
19867 | 48735 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 36 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 46015 | 6001979.18448022 | 2107865.24554965 | 37.7679079189757 | -122.436444672891 | (37.7679079189757, -122.436444672891) | 15 | 5 | 5 | 29492 | 3 | |||
40462 | 48697 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
53416 | 48709 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
70254 | 48702 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
84798 | 48704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
95808 | 48700 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
100582 | 48699 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
132203 | 48698 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
145539 | 48701 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
168885 | 48703 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | 6 | 2 | 9 | 28855 | 6 | |||
29680 | 65045 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1066 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | Permit Number 45972 | 6007827.74406772 | 2119607.84984942 | 37.8004808586212 | -122.417047244449 | (37.8004808586212, -122.417047244449) | 5 | 1 | 1 | 308 | 32 | |||
59221 | 48449 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1971 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | Permit Number 45821 | 6004348.70626507 | 2107156.39257844 | 37.7660959373339 | -122.428198241647 | (37.7660959373339, -122.428198241647) | 8 | 4 | 5 | 28862 | 3 | |||
79513 | 47917 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 999 Revised) Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2002 12:00:00 AM | Permit Number 45655 | 6006486.39229912 | 2113910.68802822 | 37.7847623267063 | -122.421284078173 | (37.7847623267063, -122.421284078173) | 13 | 9 | 11 | 28858 | 41 | |||
147048 | 47565 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 920 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45425 | 6011901.71412119 | 2111593.71793264 | 37.7787042813354 | -122.402385767126 | (37.7787042813354, -122.402385767126) | 14 | 2 | 9 | 28856 | 34 | |||
4658 | 46466 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3310X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | 12 | 3x3 | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | 13 | 9 | 1 | 57 | 17 | |
75083 | 46223 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1888 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | 13 | 9 | 1 | 57 | 17 | |||
78273 | 45427 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||
132675 | 45428 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | |||
145968 | 45426 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||
135125 | 45390 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1501-1555 Mariposa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2001 12:00:00 AM | Permit Number 44202 | 6012875.34483574 | 2106095.24513094 | 37.7636610173266 | -122.398631621456 | (37.7636610173266, -122.398631621456) | 14 | 3 | 8 | 28856 | 29 | |||
66963 | 45334 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 946 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44166 | 6002468.75387281 | 2109900.46778234 | 37.7735239435411 | -122.434896876631 | (37.7735239435411, -122.434896876631) | 15 | 5 | 11 | 29492 | 10 | ||||
193861 | 44757 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43870 | 6003593.00847933 | 2105481.98628904 | 37.7614556341181 | -122.430692553071 | (37.7614556341181, -122.430692553071) | 15 | 4 | 5 | 28862 | 3 | ||||
187242 | 44341 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2294 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/1973 12:00:00 AM | Permit Number 43725 | 6002286.29088827 | 2107094.04279132 | 37.7658078311453 | -122.435327256937 | (37.7658078311453, -122.435327256937) | 15 | 5 | 5 | 28862 | 3 | |||
64328 | 44245 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 10 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43680 | 6010447.16728471 | 2099896.56831072 | 37.7465052482739 | -122.406593130128 | (37.7465052482739, -122.406593130128) | 2 | 7 | 7 | 28859 | 2 | |||
182516 | 44225 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43670 | 6013393.18767606 | 2119056.04835121 | 37.799277245684 | -122.397749707821 | (37.799277245684, -122.397749707821) | 3 | 1 | 10 | 28860 | 6 | ||||
157239 | 44224 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 150 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43669 | 6012974 | 2118691 | 37.7982515579635 | -122.399174613744 | (37.7982515579635, -122.399174613744) | 3 | 1 | 10 | 28860 | 6 | ||||
107111 | 44172 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 59 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | Permit Number 43639 | 6003760.97911216 | 2095401.48581894 | 37.733786440894 | -122.429392732684 | (37.733786440894, -122.429392732684) | 2 | 7 | 5 | 28861 | 25 | |||
153446 | 44127 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1455 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2000 12:00:00 AM | Permit Number 43631 | 6007204.94423628 | 2110535.86362082 | 37.7755363583765 | -122.418558723581 | (37.7755363583765, -122.418558723581) | 8 | 2 | 9 | 28853 | 34 | |||
55775 | 44125 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 431 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43629 | 6012046.82946857 | 2118068.4414971 | 37.796490448112 | -122.402339123693 | (37.796490448112, -122.402339123693) | 3 | 1 | 10 | 28860 | 4 | ||||
29776 | 44063 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
56427 | 44064 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
70447 | 44061 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 |
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) );