trees
1,914 rows where qSpecies_id = 45 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 89 | 259623 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
| 103 | 253831 | DPW Maintained 1 | :: 45 | 699X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
| 2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
| 2635 | 259636 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 3035 | 259640 | DPW Maintained 1 | :: 45 | 198x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 4471 | 259626 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 4568 | 253833 | DPW Maintained 1 | :: 45 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
| 4944 | 259613 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 5006 | 259624 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 5098 | 251531 | DPW Maintained 1 | :: 45 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
| 6366 | 117001 | DPW Maintained 1 | :: 45 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 6535 | 259627 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 8424 | 261322 | Private 9 | :: 45 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2020 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 10803 | 259618 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 12379 | 259619 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 12908 | 259612 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 14450 | 259622 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 14847 | 259625 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 15760 | 251532 | DPW Maintained 1 | :: 45 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
| 15847 | 259635 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 16880 | 259621 | DPW Maintained 1 | :: 45 | 1398x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 17295 | 259617 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 17929 | 259649 | DPW Maintained 1 | :: 45 | 700 Delta St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 17931 | 259643 | DPW Maintained 1 | :: 45 | 241 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 18667 | 259652 | DPW Maintained 1 | :: 45 | 99x Cora St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 18887 | 259638 | DPW Maintained 1 | :: 45 | 99x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
| 19114 | 259651 | DPW Maintained 1 | :: 45 | 598x Rutland St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 11756 | 108765 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
| 142114 | 108771 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
| 110125 | 108826 | Undocumented 4 | :: 45 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | ||||
| 4234 | 259615 | DPW Maintained 1 | :: 45 | 935 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009702.19768 | 2087158.08788 | 37.7114863694621 | -122.408270858441 | (37.7114863694621, -122.408270858441) | 9 | 7 | 8 | 309 | 39 | ||
| 6300 | 259616 | DPW Maintained 1 | :: 45 | 941 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009687.32277 | 2087163.71083 | 37.7115009759818 | -122.408322666595 | (37.7115009759818, -122.408322666595) | 9 | 7 | 8 | 309 | 39 | ||
| 7724 | 259614 | DPW Maintained 1 | :: 45 | 928 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009731.2164 | 2087189.88087 | 37.7115752914499 | -122.408172802554 | (37.7115752914499, -122.408172802554) | 9 | 7 | 8 | 309 | 39 | ||
| 5982 | 259609 | DPW Maintained 1 | :: 45 | 1035 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009443.72066 | 2087255.36906 | 37.711739006489 | -122.40917108656 | (37.711739006489, -122.40917108656) | 9 | 7 | 8 | 309 | 39 | ||
| 8458 | 259610 | DPW Maintained 1 | :: 45 | 1107 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6009254.2033 | 2087326.13058 | 37.7119226839796 | -122.409831104788 | (37.7119226839796, -122.409831104788) | 9 | 7 | 8 | 309 | 39 | ||||
| 7054 | 259630 | DPW Maintained 1 | :: 45 | 25 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011219.86081 | 2087480.59399 | 37.7124567737707 | -122.403048058633 | (37.7124567737707, -122.403048058633) | 9 | 7 | 8 | 309 | 39 | ||
| 7856 | 259620 | DPW Maintained 1 | :: 45 | 1230 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008944.20258 | 2087484.57598 | 37.7123403644372 | -122.410913742428 | (37.7123403644372, -122.410913742428) | 9 | 7 | 8 | 309 | 39 | ||
| 7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
| 8942 | 259632 | DPW Maintained 1 | :: 45 | 31 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011179.21594 | 2087501.52553 | 37.7125119777417 | -122.40319001201 | (37.7125119777417, -122.40319001201) | 9 | 7 | 8 | 309 | 39 | ||
| 17095 | 259633 | DPW Maintained 1 | :: 45 | 37 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011138.57107 | 2087522.45708 | 37.7125671815686 | -122.403331965599 | (37.7125671815686, -122.403331965599) | 9 | 7 | 8 | 309 | 39 | ||
| 8417 | 259628 | DPW Maintained 1 | :: 45 | 100 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008465.19154 | 2087632.83273 | 37.7127205750598 | -122.412579828323 | (37.7127205750598, -122.412579828323) | 9 | 7 | 8 | 309 | 39 | ||
| 171514 | 115762 | Undocumented 4 | :: 45 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | |||
| 189112 | 115869 | Undocumented 4 | :: 45 | 84X Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
| 192835 | 115870 | Undocumented 4 | :: 45 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
| 570 | 259611 | DPW Maintained 1 | :: 45 | 1420 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008434.50928 | 2087674.99824 | 37.7128346308013 | -122.412688855365 | (37.7128346308013, -122.412688855365) | 9 | 7 | 8 | 309 | 39 | ||
| 2626 | 259634 | DPW Maintained 1 | :: 45 | 83 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010826.96041 | 2087682.93228 | 37.7129904051639 | -122.404420283412 | (37.7129904051639, -122.404420283412) | 9 | 7 | 8 | 309 | 39 | ||
| 519 | 259637 | DPW Maintained 1 | :: 45 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 7294 | 259631 | DPW Maintained 1 | :: 45 | 86 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010819.87099 | 2087731.57587 | 37.7131235744523 | -122.404448208813 | (37.7131235744523, -122.404448208813) | 9 | 7 | 8 | 309 | 39 | ||
| 3194 | 259639 | DPW Maintained 1 | :: 45 | 122 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010584.82353 | 2087852.62198 | 37.7134428042481 | -122.405269135112 | (37.7134428042481, -122.405269135112) | 9 | 7 | 8 | 309 | 39 | ||
| 138642 | 105046 | Permitted Site 7 | :: 45 | 268 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5995102.1 | 2087921.7 | 37.7127547049329 | -122.458787524461 | (37.7127547049329, -122.458787524461) | 9 | 8 | 6 | 28861 | 24 | ||||||
| 49781 | 217557 | DPW Maintained 1 | :: 45 | 111 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5995778.3452 | 2088036.9975 | 37.7131101315221 | -122.456458551068 | (37.7131101315221, -122.456458551068) | 9 | 8 | 6 | 28861 | 24 | |||
| 13540 | 259645 | DPW Maintained 1 | :: 45 | 243 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009883.66375 | 2088105.89025 | 37.7140990014395 | -122.407710448479 | (37.7140990014395, -122.407710448479) | 9 | 7 | 8 | 309 | 39 | ||
| 99077 | 217555 | DPW Maintained 1 | :: 45 | 240 Broad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5994537.6064 | 2088112.0778 | 37.713244974869 | -122.460752369399 | (37.713244974869, -122.460752369399) | 9 | 8 | 6 | 28861 | 24 | |||
| 3520 | 259641 | DPW Maintained 1 | :: 45 | 234 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009944.29036 | 2088126.34972 | 37.7141585726669 | -122.407502340313 | (37.7141585726669, -122.407502340313) | 9 | 7 | 8 | 309 | 39 | ||
| 3621 | 259642 | DPW Maintained 1 | :: 45 | 238 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009920.83207 | 2088134.90851 | 37.7141807602716 | -122.407584024659 | (37.7141807602716, -122.407584024659) | 9 | 7 | 8 | 309 | 39 | ||
| 12259 | 259644 | DPW Maintained 1 | :: 45 | 242 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009897.37379 | 2088143.4673 | 37.7142029478201 | -122.40766570902 | (37.7142029478201, -122.40766570902) | 9 | 7 | 8 | 309 | 39 | ||
| 16911 | 259646 | DPW Maintained 1 | :: 45 | 266 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6009756.62408 | 2088194.82004 | 37.7143360719186 | -122.408155816313 | (37.7143360719186, -122.408155816313) | 9 | 7 | 8 | 309 | 39 | ||
| 19078 | 217580 | DPW Maintained 1 | :: 45 | 646 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5992252.7325 | 2088559.8349 | 37.714342679649 | -122.468682167409 | (37.714342679649, -122.468682167409) | 9 | 8 | 6 | 64 | 24 | |||
| 17886 | 261591 | Planning Code 138.1 required 2 | :: 45 | 1747 Cayuga Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/28/2020 12:00:00 AM | 3 | Permit Number 784552 | 5998049.81023 | 2088594.07996 | 37.7147698965646 | -122.44864773571 | (37.7147698965646, -122.44864773571) | 9 | 7 | 6 | 28861 | 25 | ||
| 111386 | 116341 | Undocumented 4 | :: 45 | 201X Bright St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5993755.0695 | 2088847.02637 | 37.7152179130961 | -122.463510368547 | (37.7152179130961, -122.463510368547) | 9 | 8 | 6 | 64 | 24 | |||||
| 163818 | 116340 | Undocumented 4 | :: 45 | 201X Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5993755.0695 | 2088847.02637 | 37.7152179130961 | -122.463510368547 | (37.7152179130961, -122.463510368547) | 9 | 8 | 6 | 64 | 24 | |||||
| 184754 | 35137 | Permitted Site 7 | :: 45 | 832 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38668 | 6002000.93226273 | 2088942.9752097 | 37.7159530242515 | -122.435015979431 | (37.7159530242515, -122.435015979431) | 9 | 7 | 6 | 28861 | 5 | ||
| 435 | 108949 | Permitted Site 7 | :: 45 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003932.1 | 2088992 | 37.7161971007686 | -122.428344449747 | (37.7161971007686, -122.428344449747) | 9 | 7 | 6 | 28861 | 5 | |||
| 15437 | 187452 | DPW Maintained 1 | :: 45 | 5098 Mission St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6000296.2838 | 2089278.8073 | 37.7167782039769 | -122.440932105905 | (37.7167782039769, -122.440932105905) | 9 | 7 | 6 | 28861 | 25 | |||
| 192172 | 187451 | DPW Maintained 1 | :: 45 | 5098 Mission St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6000310.9137 | 2089292.2181 | 37.7168158602419 | -122.440882499178 | (37.7168158602419, -122.440882499178) | 9 | 7 | 6 | 28861 | 25 | |||
| 119776 | 200234 | DPW Maintained 1 | :: 45 | 2895 Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014768.3667 | 2089489.9029 | 37.7181714665431 | -122.390923576462 | (37.7181714665431, -122.390923576462) | 10 | 3 | 8 | 58 | 1 | |||
| 130912 | 200238 | DPW Maintained 1 | :: 45 | 917 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014595.9922 | 2089500.6344 | 37.7181913669776 | -122.391520156023 | (37.7181913669776, -122.391520156023) | 10 | 3 | 8 | 58 | 1 | |||
| 16374 | 200211 | DPW Maintained 1 | :: 45 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014078.3317 | 2089599.897 | 37.7184351760665 | -122.39331644356 | (37.7184351760665, -122.39331644356) | 10 | 3 | 8 | 58 | 1 | |||
| 63769 | 173868 | DPW Maintained 1 | :: 45 | 808 Capitol Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/31/2017 12:00:00 AM | 3 | 5995075.95943 | 2089664.90678 | 37.7175396369842 | -122.459004013836 | (37.7175396369842, -122.459004013836) | 9 | 8 | 6 | 28861 | 24 | |||
| 129547 | 173867 | DPW Maintained 1 | :: 45 | 808 Capitol Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/31/2017 12:00:00 AM | 3 | 5995075.95943 | 2089664.90678 | 37.7175396369842 | -122.459004013836 | (37.7175396369842, -122.459004013836) | 9 | 8 | 6 | 28861 | 24 | |||
| 143855 | 200204 | DPW Maintained 1 | :: 45 | 2 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014372.6432 | 2089670.326 | 37.7186449071271 | -122.392304046142 | (37.7186449071271, -122.392304046142) | 10 | 3 | 8 | 58 | 1 | |||
| 148127 | 200205 | DPW Maintained 1 | :: 45 | 1003 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014813.9755 | 2089679.7161 | 37.7186951869692 | -122.390779182777 | (37.7186951869692, -122.390779182777) | 10 | 3 | 8 | 58 | 1 | |||
| 69996 | 200194 | DPW Maintained 1 | :: 45 | 1011 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014781.1104 | 2089713.252 | 37.7187854464432 | -122.390895127615 | (37.7187854464432, -122.390895127615) | 10 | 3 | 8 | 58 | 1 | |||
| 107754 | 200193 | DPW Maintained 1 | :: 45 | 975 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | 10 | 3 | 8 | 58 | 1 | |||
| 12451 | 200191 | DPW Maintained 1 | :: 45 | 981 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.392715865878 | (37.7188778046353, -122.392715865878) | 10 | 3 | 8 | 58 | 1 | |||
| 122628 | 200190 | DPW Maintained 1 | :: 45 | 1027 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014706.6607 | 2089771.6044 | 37.7189415394071 | -122.391156549139 | (37.7189415394071, -122.391156549139) | 10 | 3 | 8 | 58 | 1 | |||
| 125844 | 200178 | DPW Maintained 1 | :: 45 | 3201 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014218.378 | 2089782.3359 | 37.7189438969212 | -122.39284511455 | (37.7189438969212, -122.39284511455) | 10 | 3 | 8 | 58 | 1 | |||
| 9415 | 200180 | DPW Maintained 1 | :: 45 | 1031 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | 10 | 3 | 8 | 58 | 1 | |||
| 9942 | 200177 | DPW Maintained 1 | :: 45 | 1041 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876 | (37.7190489123065, -122.39135410876) | 10 | 3 | 8 | 58 | 1 | |||
| 12815 | 261606 | DPW Maintained 1 | :: 45 | 108 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993739.19456 | 2089854.88419 | 37.7179843347129 | -122.463638343115 | (37.7179843347129, -122.463638343115) | 9 | 8 | 6 | 64 | 24 | |||||
| 191797 | 200172 | DPW Maintained 1 | :: 45 | 1053 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014576.5414 | 2089866.8464 | 37.7191958334242 | -122.391612979464 | (37.7191958334242, -122.391612979464) | 10 | 3 | 8 | 58 | 1 | |||
| 192580 | 200170 | DPW Maintained 1 | :: 45 | 1001 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014099.661 | 2089867.5171 | 37.7191711929066 | -122.393261433304 | (37.7191711929066, -122.393261433304) | 10 | 3 | 8 | 58 | 1 | |||
| 2263 | 31189 | Permitted Site 7 | :: 45 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 11783 | 31192 | Permitted Site 7 | :: 45 | 744 Shields St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 182359 | 31191 | Permitted Site 7 | :: 45 | 744 Shields St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 183030 | 31188 | Permitted Site 7 | :: 45 | 744 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 193705 | 31190 | Permitted Site 7 | :: 45 | 744 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 75061 | 200171 | DPW Maintained 1 | :: 45 | 1059 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014549.7127 | 2089886.9679 | 37.7192495938582 | -122.391707122944 | (37.7192495938582, -122.391707122944) | 10 | 3 | 8 | 58 | 1 | |||
| 103836 | 200167 | DPW Maintained 1 | :: 45 | 1019 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014049.3571 | 2089910.443 | 37.7192862641022 | -122.393438318502 | (37.7192862641022, -122.393438318502) | 10 | 3 | 8 | 58 | 1 | |||
| 100708 | 200169 | DPW Maintained 1 | :: 45 | 1061 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014525.5668 | 2089911.1138 | 37.7193145533562 | -122.391792274296 | (37.7193145533562, -122.391792274296) | 10 | 3 | 8 | 58 | 1 | |||
| 77012 | 200166 | DPW Maintained 1 | :: 45 | 1023 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014031.9185 | 2089919.1624 | 37.7193092369184 | -122.393499207549 | (37.7193092369184, -122.393499207549) | 10 | 3 | 8 | 58 | 1 | |||
| 295 | 200164 | DPW Maintained 1 | :: 45 | 1027 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | 10 | 3 | 8 | 58 | 1 | |||
| 118244 | 200165 | DPW Maintained 1 | :: 45 | 1071 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014485.3238 | 2089939.2839 | 37.7193896687982 | -122.391933349185 | (37.7193896687982, -122.391933349185) | 10 | 3 | 8 | 58 | 1 | |||
| 62817 | 200162 | DPW Maintained 1 | :: 45 | 1035 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013970.2124 | 2089969.4662 | 37.7194439323961 | -122.393716023061 | (37.7194439323961, -122.393716023061) | 10 | 3 | 8 | 58 | 1 | |||
| 43706 | 200497 | DPW Maintained 1 | :: 45 | 1110 Gilman Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014977.2953 | 2089975.1673 | 37.7195154981888 | -122.390235277748 | (37.7195154981888, -122.390235277748) | 10 | 3 | 8 | 58 | 1 | |||
| 95954 | 200161 | DPW Maintained 1 | :: 45 | 1083 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014425.6299 | 2089982.8806 | 37.7195060625081 | -122.392142737787 | (37.7195060625081, -122.392142737787) | 10 | 3 | 8 | 58 | 1 | |||
| 157514 | 200157 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014392.094 | 2090006.3557 | 37.7195686584119 | -122.392260301004 | (37.7195686584119, -122.392260301004) | 10 | 3 | 8 | 58 | 1 |
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) );