trees
3,247 rows where qSpecies_id = 22 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▲ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 321 | 219060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000072.85251 | 2094491.10418 | 37.731077247812 | -122.442078323383 | (37.731077247812, -122.442078323383) | 9 | 7 | 4 | 63 | 40 | |||
| 1246 | 160377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 824 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001767.32645 | 2089068.63157 | 37.7162847814869 | -122.435832414836 | (37.7162847814869, -122.435832414836) | 9 | 7 | 6 | 28861 | 5 | ||
| 1918 | 262485 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 500X Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6009406 | 2087980 | 37.7137265813857 | -122.409352565386 | (37.7137265813857, -122.409352565386) | 9 | 7 | 8 | 309 | 39 | |||
| 2109 | 71599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.459970121431 | (37.7083363538073, -122.459970121431) | 9 | 8 | 6 | 28861 | 25 | |||
| 2312 | 71328 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 228 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004151.95998 | 2089814.42795 | 37.7184677472758 | -122.427643069565 | (37.7184677472758, -122.427643069565) | 9 | 7 | 6 | 28861 | 5 | |||
| 2836 | 219119 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002030.49307 | 2095074.13161 | 37.7327894760326 | -122.435352122012 | (37.7327894760326, -122.435352122012) | 9 | 7 | 5 | 63 | 40 | |||
| 3155 | 171861 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009150.18336 | 2091330.30171 | 37.722911477365 | -122.410473193303 | (37.722911477365, -122.410473193303) | 9 | 3 | 7 | 309 | 28 | |||
| 3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
| 3595 | 219121 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002025.50342 | 2095049.38545 | 37.7327212453836 | -122.435367602937 | (37.7327212453836, -122.435367602937) | 9 | 7 | 5 | 63 | 40 | |||
| 3762 | 159863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 31 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781524 | 6001585.86798 | 2091604.37779 | 37.7232370625303 | -122.436641024974 | (37.7232370625303, -122.436641024974) | 9 | 7 | 6 | 28861 | 25 | |
| 3874 | 171862 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009157.70808 | 2091305.98211 | 37.722845122689 | -122.410445465398 | (37.722845122689, -122.410445465398) | 9 | 3 | 7 | 309 | 28 | |||
| 6502 | 71315 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 555 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6003422.952 | 2090101.24578 | 37.7192140226932 | -122.430183398047 | (37.7192140226932, -122.430183398047) | 9 | 7 | 6 | 28861 | 5 | |||
| 8505 | 71601 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994653.0975 | 2086384.07363 | 37.7085069255288 | -122.460228076664 | (37.7085069255288, -122.460228076664) | 9 | 8 | 6 | 28861 | 25 | |||
| 8515 | 76311 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299X Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 0 | 6006754.26056 | 2093151.90933 | 37.7277786091743 | -122.418884550584 | (37.7277786091743, -122.418884550584) | 9 | 3 | 7 | 309 | 5 | ||
| 8659 | 71325 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 114 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004555.30191 | 2090455.11867 | 37.7202497511935 | -122.426294473226 | (37.7202497511935, -122.426294473226) | 9 | 7 | 6 | 28861 | 5 | |||
| 8700 | 106117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.7217828139374 | -122.433585385445 | (37.7217828139374, -122.433585385445) | 9 | 7 | 6 | 28861 | 5 | |||
| 8732 | 261131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 205 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6002921 | 2092296 | 37.725211886246 | -122.432075099304 | (37.725211886246, -122.432075099304) | 9 | 7 | 6 | 28861 | 5 | ||
| 9176 | 176544 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 7 | : | Tree | Private 2 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.468531792305 | (37.7096104062721, -122.468531792305) | 9 | 8 | 4 | 64 | 24 | |||
| 9489 | 219078 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 23 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993714.36027 | 2087390.34861 | 37.7112158768855 | -122.463545422096 | (37.7112158768855, -122.463545422096) | 9 | 8 | 4 | 64 | 24 | |||
| 10523 | 262206 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000738 | 2088975 | 37.7159691653279 | -122.439383549479 | (37.7159691653279, -122.439383549479) | 9 | 7 | 6 | 28861 | 5 | ||||
| 10917 | 73960 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994666.9696 | 2086372.6899 | 37.7084764663958 | -122.460179309136 | (37.7084764663958, -122.460179309136) | 9 | 8 | 6 | 28861 | 25 | |||
| 11687 | 95013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.405649829104 | (37.7118779294401, -122.405649829104) | 9 | 7 | 8 | 309 | 39 | ||||
| 11718 | 176523 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 852 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 4 | Width 2ft | Permit Number 48053 | 6000783.87975 | 2089020.62281 | 37.7160970462187 | -122.439228236006 | (37.7160970462187, -122.439228236006) | 9 | 7 | 6 | 28861 | 5 | |
| 12292 | 74182 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994679.00139 | 2086362.08429 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | 9 | 8 | 6 | 28861 | 25 | |||
| 12736 | 219124 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 70 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001597.50006 | 2094955.90851 | 37.7324402629898 | -122.436840624998 | (37.7324402629898, -122.436840624998) | 9 | 7 | 5 | 63 | 40 | |||
| 15326 | 30913 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | 9 | 8 | 6 | 28861 | 24 | ||
| 16311 | 71600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Wilson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994689.24707 | 2086354.84413 | 37.7084287474492 | -122.460101024051 | (37.7084287474492, -122.460101024051) | 9 | 8 | 6 | 28861 | 25 | |||
| 16796 | 70557 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 20 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004148.34946 | 2093373.6236 | 37.7282403094269 | -122.42790902788 | (37.7282403094269, -122.42790902788) | 9 | 7 | 6 | 28861 | 5 | |||
| 17073 | 177097 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:08:00 PM | 3 | 3x3 | Permit Number 780184 | 6000986.95239 | 2093579.83618 | 37.7286271663089 | -122.438852851774 | (37.7286271663089, -122.438852851774) | 9 | 7 | 6 | 28861 | 25 | |
| 17481 | 52506 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 180 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48613 | 6000220.46380878 | 2092503.12984203 | 37.7256271406599 | -122.441425411243 | (37.7256271406599, -122.441425411243) | 9 | 7 | 6 | 28861 | 25 | ||
| 17720 | 73608 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5994710.3414 | 2086333.69481 | 37.7083718896252 | -122.460026588949 | (37.7083718896252, -122.460026588949) | 9 | 8 | 6 | 28861 | 25 | |||
| 17756 | 73719 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001003.51582 | 2093592.54046 | 37.7286629916874 | -122.438796501163 | (37.7286629916874, -122.438796501163) | 9 | 7 | 6 | 28861 | 25 | |||
| 17962 | 37394 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 9 | Permit Number 39876 | 6000430.23445 | 2087496.65427 | 37.7118924395572 | -122.440341369156 | (37.7118924395572, -122.440341369156) | 9 | 7 | 6 | 28861 | 5 | |
| 18644 | 219072 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995143.85497 | 2087382.22564 | 37.7112758346919 | -122.458604178052 | (37.7112758346919, -122.458604178052) | 9 | 8 | 6 | 28861 | 24 | |||
| 18963 | 262441 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 20111 | 1217 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3501 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993695.72185 | 2087421.09824 | 37.7112992341463 | -122.463612070865 | (37.7112992341463, -122.463612070865) | 9 | 8 | 4 | 64 | 24 | ||
| 20365 | 176527 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004589.78271 | 2090506.01263 | 37.7203914438823 | -122.42617890585 | (37.7203914438823, -122.42617890585) | 9 | 7 | 6 | 28861 | 5 | |||
| 21196 | 95772 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767507 | 6002653.48548 | 2089890.5721 | 37.7185919472416 | -122.432828107254 | (37.7185919472416, -122.432828107254) | 9 | 7 | 6 | 28861 | 5 |
| 21460 | 219112 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Brentwood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5995677.34458 | 2095602.53866 | 37.7338775046316 | -122.457354631219 | (37.7338775046316, -122.457354631219) | 9 | 7 | 4 | 59 | 40 | |||
| 22431 | 176546 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001153.2088 | 2093150.95928 | 37.7274590260883 | -122.438247383234 | (37.7274590260883, -122.438247383234) | 9 | 7 | 6 | 28861 | 25 | |||
| 23520 | 51660 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
| 23797 | 94990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.404779818423 | (37.7116594240627, -122.404779818423) | 9 | 7 | 8 | 309 | 39 | ||||
| 24803 | 219065 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 23 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5996669.35442 | 2091183.49582 | 37.721800793963 | -122.453605997028 | (37.721800793963, -122.453605997028) | 9 | 8 | 6 | 28861 | 24 | |||
| 25562 | 219059 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 436 Lansdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996081.02947 | 2096375.46798 | 37.7360229588021 | -122.456014839207 | (37.7360229588021, -122.456014839207) | 9 | 7 | 4 | 59 | 40 | |||
| 26417 | 66310 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | 9 | 7 | 5 | 63 | 40 | ||
| 27248 | 42307 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 245 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42530 | 5998732.16654968 | 2093631.30703212 | 37.7286399521282 | -122.446651448677 | (37.7286399521282, -122.446651448677) | 9 | 7 | 4 | 28861 | 40 | ||
| 27284 | 32001 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Brazil Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 35398 | 6004626.44544717 | 2090517.44642515 | 37.7204249107717 | -122.426052988126 | (37.7204249107717, -122.426052988126) | 9 | 7 | 6 | 28861 | 5 | ||
| 27585 | 47159 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52542 | 5992116.68521556 | 2095408.98560737 | 37.7331409014555 | -122.469650709796 | (37.7331409014555, -122.469650709796) | 9 | 8 | 4 | 59 | 40 | ||
| 29104 | 216866 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:20:00 PM | 3 | Width 3ft | 5995872.63368 | 2087895.25589 | 37.7127263548073 | -122.456122418814 | (37.7127263548073, -122.456122418814) | 9 | 8 | 6 | 28861 | 24 | ||
| 29415 | 108948 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774439 | 6002672.3 | 2089874.6 | 37.7185491584783 | -122.432761932836 | (37.7185491584783, -122.432761932836) | 9 | 7 | 6 | 28861 | 5 |
| 31785 | 219063 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 231 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5999201.21261 | 2094063.00873 | 37.7298520860886 | -122.445060957292 | (37.7298520860886, -122.445060957292) | 9 | 7 | 4 | 28861 | 40 | |||
| 34238 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 10x10 | 5992081.50866 | 2087171.04221 | 37.7105194967412 | -122.469172961285 | (37.7105194967412, -122.469172961285) | 9 | 8 | 4 | 64 | 24 | |||
| 36293 | 176526 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004597.29185 | 2090518.89763 | 37.720427247709 | -122.426153866008 | (37.720427247709, -122.426153866008) | 9 | 7 | 6 | 28861 | 5 | |||
| 36467 | 219120 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002027.68527 | 2095060.20973 | 37.7327510902846 | -122.435360833759 | (37.7327510902846, -122.435360833759) | 9 | 7 | 5 | 63 | 40 | |||
| 38355 | 176529 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 559 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003638.0746 | 2089931.06876 | 37.7187589360517 | -122.42942767166 | (37.7187589360517, -122.42942767166) | 9 | 7 | 6 | 28861 | 5 | |||
| 39018 | 219127 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 137 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001368.15711 | 2095390.11838 | 37.7336194657632 | -122.437664601839 | (37.7336194657632, -122.437664601839) | 9 | 7 | 5 | 63 | 40 | |||
| 39256 | 17240 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 288X Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994052.53109 | 2087477.46763 | 37.7114745641852 | -122.46238294313 | (37.7114745641852, -122.46238294313) | 9 | 8 | 6 | 28861 | 24 | |||
| 41278 | 66312 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 143 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29427 | 6001377.41574875 | 2095374.46813255 | 37.7335770202313 | -122.437631471673 | (37.7335770202313, -122.437631471673) | 9 | 7 | 5 | 63 | 40 | ||
| 41900 | 219062 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 323 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998589.31074 | 2094071.50054 | 37.729840458767 | -122.44717697484 | (37.729840458767, -122.44717697484) | 9 | 7 | 4 | 28861 | 40 | |||
| 42091 | 219138 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002033.17044 | 2094872.15307 | 37.7322350413038 | -122.435328423075 | (37.7322350413038, -122.435328423075) | 9 | 7 | 4 | 63 | 40 | |||
| 45818 | 254999 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1701 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 6001381 | 2091997 | 37.7243034696348 | -122.437377313626 | (37.7243034696348, -122.437377313626) | 9 | 7 | 6 | 28861 | 25 | ||||
| 46097 | 51658 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
| 46725 | 219131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001965.03109 | 2094900.87748 | 37.7323100420584 | -122.435566050051 | (37.7323100420584, -122.435566050051) | 9 | 7 | 4 | 63 | 40 | |||
| 46850 | 219122 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002020.04993 | 2095030.436 | 37.7326689048259 | -122.435385101949 | (37.7326689048259, -122.435385101949) | 9 | 7 | 5 | 63 | 40 | |||
| 48860 | 31103 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34833 | 5999457.19750616 | 2094476.41110403 | 37.7310017996631 | -122.444205686044 | (37.7310017996631, -122.444205686044) | 9 | 7 | 4 | 63 | 40 | ||
| 49766 | 176554 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 436 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009489.31256 | 2092266.89081 | 37.7255021606775 | -122.409366953445 | (37.7255021606775, -122.409366953445) | 9 | 3 | 7 | 309 | 28 | |||
| 51106 | 219114 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 409 Bella Vista Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997404.49541 | 2096329.01275 | 37.7359712783432 | -122.451435758472 | (37.7359712783432, -122.451435758472) | 9 | 7 | 4 | 59 | 40 | |||
| 51267 | 19073 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 207 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5994916.47783 | 2087386.74786 | 37.7112751808846 | -122.459390372563 | (37.7112751808846, -122.459390372563) | 9 | 8 | 6 | 28861 | 24 | |||
| 52611 | 219077 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 494 Victoria St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993267.6387 | 2090426.62452 | 37.7195270128342 | -122.465309800205 | (37.7195270128342, -122.465309800205) | 9 | 8 | 6 | 64 | 24 | |||
| 54863 | 50496 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 766 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 6 | Permit Number 47133 | 6001214.03711 | 2089205.20914 | 37.7166283477038 | -122.437754623095 | (37.7166283477038, -122.437754623095) | 9 | 7 | 6 | 28861 | 5 | |
| 57027 | 219128 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 132 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001338.63173 | 2095424.72317 | 37.7337128036929 | -122.437769157037 | (37.7337128036929, -122.437769157037) | 9 | 7 | 5 | 63 | 40 | |||
| 57219 | 219066 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 290 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5995673.80477 | 2091879.47013 | 37.7236546519175 | -122.457097650832 | (37.7236546519175, -122.457097650832) | 9 | 8 | 4 | 28861 | 24 | |||
| 57667 | 40671 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 102 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 1 | Permit Number 41657 | 6004099.1672 | 2093741.168 | 37.7292467218527 | -122.428105234782 | (37.7292467218527, -122.428105234782) | 9 | 7 | 6 | 28861 | 5 | |
| 58917 | 31098 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 106 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | 3x3 | Permit Number 34828 | 6000773.52308358 | 2094378.43446276 | 37.7308077879844 | -122.439647916066 | (37.7308077879844, -122.439647916066) | 9 | 7 | 4 | 63 | 40 | ||
| 61024 | 94991 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010722.4 | 2087213.8 | 37.7116964188451 | -122.404748673867 | (37.7116964188451, -122.404748673867) | 9 | 7 | 8 | 309 | 39 | ||||
| 61768 | 176552 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 445 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003586.76422 | 2092006.47485 | 37.7244546375487 | -122.429752978922 | (37.7244546375487, -122.429752978922) | 9 | 7 | 6 | 28861 | 5 | |||
| 64418 | 31097 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 106 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 7 | 3x3 | Permit Number 34828 | 6000767.82803 | 2094431.09703 | 37.730952063077 | -122.439671378748 | (37.730952063077, -122.439671378748) | 9 | 7 | 4 | 63 | 40 |
| 64519 | 176539 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010868.55665 | 2088874.81805 | 37.7162654064988 | -122.404360352946 | (37.7162654064988, -122.404360352946) | 9 | 7 | 8 | 309 | 39 | |||
| 66334 | 219125 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 149 Hamerton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6001356.75125 | 2095315.06653 | 37.7334127421955 | -122.437698661869 | (37.7334127421955, -122.437698661869) | 9 | 7 | 5 | 63 | 40 | |||
| 67457 | 176538 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 351 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781440 | 6011090.57956 | 2089007.63237 | 37.7166424922212 | -122.403602269453 | (37.7166424922212, -122.403602269453) | 9 | 7 | 8 | 309 | 39 | |
| 68798 | 19068 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 197 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1997 12:00:00 AM | 6 | 3X3 | 5995078.75797 | 2087384.27088 | 37.71127770888 | -122.458829316129 | (37.71127770888, -122.458829316129) | 9 | 8 | 6 | 28861 | 24 | ||
| 69929 | 109058 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772785 | 6000981.19022 | 2087817.6053 | 37.712805054485 | -122.438460096258 | (37.712805054485, -122.438460096258) | 9 | 7 | 6 | 28861 | 5 |
| 71337 | 65595 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 648 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1990 12:00:00 AM | Permit Number 28497 | 6002593.16557245 | 2089884.83914592 | 37.7185727844662 | -122.433036198966 | (37.7185727844662, -122.433036198966) | 9 | 7 | 6 | 28861 | 5 | ||
| 74209 | 176531 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 441 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002894.3605 | 2091289.67002 | 37.7224472185338 | -122.432095358539 | (37.7224472185338, -122.432095358539) | 9 | 7 | 6 | 28861 | 5 | |||
| 76262 | 19101 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 286 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2000 12:00:00 AM | 3 | 3X3 | 5994132.39945 | 2087476.81693 | 37.7114773763557 | -122.462106852145 | (37.7114773763557, -122.462106852145) | 9 | 8 | 6 | 28861 | 24 | ||
| 76927 | 84044 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 915 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49722 | 5995003.95807398 | 2090024.96350436 | 37.7185241280217 | -122.459278947225 | (37.7185241280217, -122.459278947225) | 9 | 8 | 6 | 28861 | 24 | ||
| 79133 | 176520 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1407 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999174.41377 | 2089660.47464 | 37.7177622156247 | -122.444837263538 | (37.7177622156247, -122.444837263538) | 9 | 7 | 6 | 28861 | 25 | |||
| 79381 | 219056 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995605.82709 | 2093268.59885 | 37.7274649625165 | -122.457433088986 | (37.7274649625165, -122.457433088986) | 9 | 7 | 4 | 28861 | 40 | |||
| 79989 | 219126 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 149 Hamerton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001351.76751 | 2095328.85853 | 37.7334503284649 | -122.437716879455 | (37.7334503284649, -122.437716879455) | 9 | 7 | 5 | 63 | 40 | |||
| 80817 | 61053 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 350 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1983 12:00:00 AM | Permit Number 20881 | 5999093.33834724 | 2094401.39075661 | 37.7307750462235 | -122.445458211566 | (37.7307750462235, -122.445458211566) | 9 | 7 | 4 | 59 | 40 | ||
| 84647 | 176542 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 5 | : | Tree | Private 2 | 1 | Width 3ft | 5992312.69836 | 2086838.42699 | 37.7096195712459 | -122.468349744347 | (37.7096195712459, -122.468349744347) | 9 | 8 | 4 | 64 | 24 | |||
| 85473 | 219076 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 105 Majestic Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997099.54595 | 2089348.6148 | 37.7167872911766 | -122.451986630097 | (37.7167872911766, -122.451986630097) | 9 | 8 | 6 | 28861 | 24 | |||
| 89753 | 25339 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2001 12:00:00 AM | 3 | 3X3 | 5994735.55505 | 2087387.95343 | 37.711268087013 | -122.460015770114 | (37.711268087013, -122.460015770114) | 9 | 8 | 6 | 28861 | 24 | ||
| 90701 | 51804 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.439431058942 | (37.7158284472863, -122.439431058942) | 9 | 7 | 6 | 28861 | 5 | |||
| 90803 | 219057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2043 Monterey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992040.14931 | 2095397.21608 | 37.7331041614161 | -122.469914455893 | (37.7331041614161, -122.469914455893) | 9 | 8 | 4 | 59 | 40 | |||
| 91484 | 219118 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002034.57495 | 2095088.74444 | 37.7328298313259 | -122.435339054851 | (37.7328298313259, -122.435339054851) | 9 | 7 | 5 | 63 | 40 | |||
| 92471 | 176530 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 519 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002857.33344 | 2090724.39946 | 37.7208930119788 | -122.432183003759 | (37.7208930119788, -122.432183003759) | 9 | 7 | 6 | 28861 | 5 | |||
| 92615 | 69418 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 156 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 6 | Permit Number 33523 | 6001409.83218 | 2087347.55332 | 37.7115387685699 | -122.436944943671 | (37.7115387685699, -122.436944943671) | 9 | 7 | 6 | 28861 | 5 | |
| 93251 | 176543 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 6 | : | Tree | Private 2 | 1 | Width 3ft | 5992283.95996 | 2086838.07777 | 37.7096169524177 | -122.468449043003 | (37.7096169524177, -122.468449043003) | 9 | 8 | 4 | 64 | 24 | |||
| 94025 | 52978 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 554 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48958 | 5993806.42000954 | 2090906.17268529 | 37.7208747934184 | -122.463482227177 | (37.7208747934184, -122.463482227177) | 9 | 8 | 6 | 64 | 24 |
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) );