trees
1,914 rows where qSpecies_id = 45 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144 | 108797 | Undocumented 4 | :: 45 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
301 | 108803 | Undocumented 4 | :: 45 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
392 | 108811 | Undocumented 4 | :: 45 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||||
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 | ||
11763 | 108805 | Undocumented 4 | :: 45 | 401-499 University St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
11776 | 108812 | Undocumented 4 | :: 45 | 301-399 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
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 | ||
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 | ||
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 | |||||
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 | ||
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 | |||
15900 | 108806 | Undocumented 4 | :: 45 | 401-499 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
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 | ||
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 | ||
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 | ||
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 | |||
19220 | 122819 | Undocumented 4 | :: 45 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003309 | 2094407 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | 9 | 7 | 5 | 28861 | 25 | ||||
29145 | 121591 | Undocumented 4 | :: 45 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6000339 | 2095263 | 37.7332118579221 | -122.441213569672 | (37.7332118579221, -122.441213569672) | 9 | 7 | 5 | 63 | 40 | ||||
33016 | 31148 | Permitted Site 7 | :: 45 | 500 Hearst Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.7307613077995 | -122.44892931603 | (37.7307613077995, -122.44892931603) | 9 | 7 | 4 | 59 | 40 | ||
38005 | 35482 | Permitted Site 7 | :: 45 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | 9 | 3 | 7 | 309 | 28 | ||
42415 | 108792 | Permitted Site 7 | :: 45 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008053.41125 | 2093004.09823 | 37.7274458184293 | -122.414382893832 | (37.7274458184293, -122.414382893832) | 9 | 3 | 7 | 309 | 28 | ||||
45721 | 108810 | Undocumented 4 | :: 45 | 301-399 University St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
49143 | 108801 | Undocumented 4 | :: 45 | 501-599 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
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 | |||
51165 | 35095 | Permitted Site 7 | :: 45 | 647 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38637 | 6002415.60861753 | 2090011.70468142 | 37.7189110558626 | -122.433659002065 | (37.7189110558626, -122.433659002065) | 9 | 7 | 6 | 28861 | 5 | ||
52228 | 45785 | Permitted Site 7 | :: 45 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2001 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | 9 | 7 | 4 | 28861 | 40 | |||
54539 | 108802 | Undocumented 4 | :: 45 | 401-499 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
57424 | 101476 | Significant Tree 6 | :: 45 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | ||
61663 | 108793 | Permitted Site 7 | :: 45 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6008053.41125 | 2093004.09823 | 37.7274458184293 | -122.414382893832 | (37.7274458184293, -122.414382893832) | 9 | 3 | 7 | 309 | 28 | ||||
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 | |||
87438 | 219181 | DPW Maintained 1 | :: 45 | 431 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5999211.06214 | 2094946.25439 | 37.7322778337559 | -122.445090379531 | (37.7322778337559, -122.445090379531) | 9 | 7 | 4 | 59 | 40 | |||
96682 | 115070 | Significant Tree 6 | :: 45 | 401 DARIEN WAY | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5992724 | 2094938 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | 9 | 8 | 4 | 59 | 40 | ||||
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 | |||
99942 | 31149 | Permitted Site 7 | :: 45 | 500 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.7307613077995 | -122.44892931603 | (37.7307613077995, -122.44892931603) | 9 | 7 | 4 | 59 | 40 | ||
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 | |||||
114694 | 108807 | Undocumented 4 | :: 45 | 401-499 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
121161 | 108804 | Undocumented 4 | :: 45 | 401-499 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008323.15237 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | 9 | 3 | 7 | 309 | 28 | |||||
127804 | 109831 | DPW Maintained 1 | :: 45 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | 9 | 7 | 4 | 28861 | 40 | ||||
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 | |||
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 | ||||||
141463 | 52107 | Permitted Site 7 | :: 45 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48299 | 5996504.69473395 | 2098122.17494067 | 37.7408432986479 | -122.454676219762 | (37.7408432986479, -122.454676219762) | 9 | 7 | 4 | 59 | 40 | ||
151586 | 108799 | Undocumented 4 | :: 45 | 501-599 University St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
152288 | 108813 | Undocumented 4 | :: 45 | 301-399 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008160.40727 | 2092653.74948 | 37.7264898456848 | -122.413988233103 | (37.7264898456848, -122.413988233103) | 9 | 3 | 7 | 309 | 28 | |||||
156876 | 45784 | Permitted Site 7 | :: 45 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | 9 | 7 | 4 | 28861 | 40 | ||
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 | |||||
169454 | 108800 | Undocumented 4 | :: 45 | 501-599 University St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
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 | |||
174987 | 109571 | Permitted Site 7 | :: 45 | 400 Brazil Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003029.6 | 2091527.8 | 37.7231087370031 | -122.431644859747 | (37.7231087370031, -122.431644859747) | 9 | 7 | 6 | 28861 | 5 | |||
176269 | 108798 | Undocumented 4 | :: 45 | 501-599 University St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
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 | ||
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 | ||
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 | ||||
190627 | 108795 | Undocumented 4 | :: 45 | 501-599 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
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 | |||
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 | ||||
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 | ||
373 | 200940 | DPW Maintained 1 | :: 45 | 1515 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6008432.2434 | 2109068.8895 | 37.7715774111529 | -122.414209373869 | (37.7715774111529, -122.414209373869) | 8 | 2 | 9 | 28853 | 19 | |||
758 | 228462 | DPW Maintained 1 | :: 45 | 227 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.7683047783783 | -122.418472926402 | (37.7683047783783, -122.418472926402) | 8 | 4 | 7 | 28853 | 19 | |||
1432 | 228461 | Planning Code 138.1 required 2 | :: 45 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 782329 | 6005355.14245 | 2107219.1964 | 37.7663252752163 | -122.424721643507 | (37.7663252752163, -122.424721643507) | 8 | 4 | 5 | 28853 | 19 | ||
6593 | 261297 | Permitted Site 7 | :: 45 | 3180 18th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/01/2013 12:00:00 AM | 3 | 6008239.4944 | 2105648.95562 | 37.762176240156 | -122.414634049312 | (37.762176240156, -122.414634049312) | 8 | 4 | 7 | 28859 | 19 | ||||
18479 | 246372 | DPW Maintained 1 | :: 45 | 1999 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6006820.4847 | 2107009.8327 | 37.7658330635794 | -122.419638433278 | (37.7658330635794, -122.419638433278) | 8 | 4 | 7 | 28853 | 19 | |||
18687 | 104158 | DPW Maintained 1 | :: 45 | 525X Church St | 6 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
25068 | 246384 | DPW Maintained 1 | :: 45 | 1655 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6006982.6308 | 2109153.3972 | 37.7717279173795 | -122.419229672629 | (37.7717279173795, -122.419229672629) | 8 | 2 | 9 | 28853 | 19 | |||
27039 | 228495 | DPW Maintained 1 | :: 45 | 505 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004273.17296 | 2105900.15512 | 37.7626423365047 | -122.42836995112 | (37.7626423365047, -122.42836995112) | 8 | 4 | 5 | 28862 | 3 | |||
31577 | 104151 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
33531 | 228505 | DPW Maintained 1 | :: 45 | 74 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006699.63588 | 2109500.73575 | 37.7726656844924 | -122.420233227899 | (37.7726656844924, -122.420233227899) | 8 | 2 | 9 | 28853 | 19 | |||
35954 | 245454 | DPW Maintained 1 | :: 45 | 2700 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6008487.3357 | 2106844.226 | 37.7654720981168 | -122.41386141193 | (37.7654720981168, -122.41386141193) | 8 | 4 | 7 | 28853 | 19 | |||
39265 | 228487 | DPW Maintained 1 | :: 45 | 2880 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008652.20159 | 2106330.0546 | 37.7640695596822 | -122.413254813474 | (37.7640695596822, -122.413254813474) | 8 | 4 | 7 | 28859 | 19 | |||
39375 | 246383 | DPW Maintained 1 | :: 45 | 1655 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6006970.497 | 2109128.1185 | 37.771657824727 | -122.419269850794 | (37.771657824727, -122.419269850794) | 8 | 2 | 9 | 28853 | 19 | |||
40092 | 228506 | DPW Maintained 1 | :: 45 | 74 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006728.21542 | 2109473.21902 | 37.7725917404536 | -122.420132414803 | (37.7725917404536, -122.420132414803) | 8 | 2 | 9 | 28853 | 19 | |||
41954 | 228450 | DPW Maintained 1 | :: 45 | 2701 17th St | 2 | : | Tree | Private 2 | 1 | Width 5ft | 6009278.09164 | 2106368.2886 | 37.7642096605602 | -122.411092735367 | (37.7642096605602, -122.411092735367) | 8 | 4 | 7 | 28859 | 19 | |||
72393 | 29881 | DPW Maintained 1 | :: 45 | 270 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6006056.28059 | 2108026.10587 | 37.7685804313738 | -122.42235387246 | (37.7685804313738, -122.42235387246) | 8 | 4 | 5 | 28853 | 19 | |||
76329 | 246385 | DPW Maintained 1 | :: 45 | 1655 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6006994.7646 | 2109179.687 | 37.7718007862576 | -122.419189566122 | (37.7718007862576, -122.419189566122) | 8 | 2 | 9 | 28853 | 19 | |||
78434 | 104861 | DPW Maintained 1 | :: 45 | 3458A 18th St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 6006508 | 2105569.9 | 37.7618617394874 | -122.420617027809 | (37.7618617394874, -122.420617027809) | 8 | 4 | 7 | 28859 | 19 | ||||||
79291 | 104154 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
82523 | 200939 | DPW Maintained 1 | :: 45 | 1435 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6008734.9445 | 2109359.299 | 37.7723918057631 | -122.413182848986 | (37.7723918057631, -122.413182848986) | 8 | 2 | 9 | 28853 | 34 | |||
85945 | 228504 | DPW Maintained 1 | :: 45 | 60 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006682.42728 | 2109519.39101 | 37.7727159377106 | -122.420294078716 | (37.7727159377106, -122.420294078716) | 8 | 2 | 9 | 28853 | 19 | |||
87211 | 228488 | DPW Maintained 1 | :: 45 | 2880 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008610.43797 | 2106311.71269 | 37.7640168522296 | -122.413397964868 | (37.7640168522296, -122.413397964868) | 8 | 4 | 7 | 28859 | 19 | |||
87831 | 228465 | DPW Maintained 1 | :: 45 | 321 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004210.24642 | 2107036.07535 | 37.7657577400449 | -122.428668569211 | (37.7657577400449, -122.428668569211) | 8 | 4 | 5 | 28862 | 3 | |||
91019 | 246382 | DPW Maintained 1 | :: 45 | 1655 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6006956.341 | 2109096.7729 | 37.7715709599047 | -122.41931659335 | (37.7715709599047, -122.41931659335) | 8 | 2 | 9 | 28853 | 19 | |||
94668 | 104156 | DPW Maintained 1 | :: 45 | 525X Church St | 4 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 |
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) );