trees
2,694 rows where qSpecies_id = 84 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
148815 | 28644 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 6 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003694.7628 | 2113348.3634 | 37.7830605429851 | -122.430902047868 | (37.7830605429851, -122.430902047868) | 15 | 9 | 11 | 29490 | 41 | ||
149281 | 118431 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 5400 Anza St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5981816.64658 | 2111695.18358 | 37.7772574943259 | -122.506467446284 | (37.7772574943259, -122.506467446284) | 11 | 6 | 2 | 55 | 26 | |||
149285 | 50550 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
154597 | 27753 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1299 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | 10 | 3 | 8 | 58 | 1 | ||
158048 | 36258 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 25 Elmhurst Dr | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39270 | 5991200.33310514 | 2094436.30103714 | 37.7304171492597 | -122.472747856373 | (37.7304171492597, -122.472747856373) | 9 | 8 | 4 | 64 | 40 | ||
159383 | 138186 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1865 Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6003941.622 | 2114719.9923 | 37.7868406758104 | -122.430145898895 | (37.7868406758104, -122.430145898895) | 13 | 9 | 11 | 29490 | 27 | |||
166470 | 35303 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3459 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | 8 | 4 | 5 | 28859 | 19 | |||
169317 | 110548 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
177460 | 142763 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010767.3863 | 2120009.5113 | 37.8017486483835 | -122.406903172911 | (37.8017486483835, -122.406903172911) | 3 | 1 | 10 | 308 | 23 | |||
181217 | 101447 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
184830 | 135937 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 98 Spruce St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780098 | 5997052.02369 | 2116054.59656 | 37.7901125223289 | -122.454078602473 | (37.7901125223289, -122.454078602473) | 11 | 6 | 1 | 54 | 31 | |
188339 | 42760 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
194014 | 36433 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 435 Montecito Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | 9 | 7 | 4 | 28861 | 40 | ||
2220 | 117168 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
4260 | 178882 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003684.48265 | 2090515.01932 | 37.7203649633559 | -122.4293088757 | (37.7203649633559, -122.4293088757) | 9 | 7 | 6 | 28861 | 5 | |||
5252 | 253357 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1705 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | 13 | 9 | 11 | 29490 | 13 | ||
7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
21027 | 196418 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010052.79507 | 2110841.75773 | 37.7765361885308 | -122.408728861943 | (37.7765361885308, -122.408728861943) | 8 | 2 | 9 | 28853 | 34 | |||
21733 | 37264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 910 Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | 2 | 4 | 5 | 28862 | 22 | ||
23229 | 101446 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
23943 | 91342 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 829 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100 | 2112601 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | 6 | 2 | 9 | 28856 | 34 | ||
23950 | 113748 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | ||||
25314 | 139145 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1500 GEARY BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004390.5718 | 2114066.8594 | 37.7850727536973 | -122.428546063814 | (37.7850727536973, -122.428546063814) | 13 | 9 | 11 | 29490 | 13 | |||
27494 | 109159 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 200 Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005726 | 2110076 | 37.7741903117261 | -122.423642051276 | (37.7741903117261, -122.423642051276) | 7 | 9 | 11 | 28852 | 10 | ||||
38528 | 106984 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1737-1795 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2012 12:00:00 AM | 3 | 6003775.6189 | 2114189.0991 | 37.7853735733153 | -122.430682332536 | (37.7853735733153, -122.430682332536) | 13 | 9 | 11 | 29490 | 13 | |||
41401 | 139419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1675 POST ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004207.4112 | 2114251.7374 | 37.7855700154683 | -122.429192929022 | (37.7855700154683, -122.429192929022) | 13 | 9 | 11 | 29490 | 13 | |||
41901 | 44164 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 41 Sycamore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | Permit Number 43637 | 6006615.48283376 | 2105833.54152838 | 37.7625916944433 | -122.420263998944 | (37.7625916944433, -122.420263998944) | 8 | 4 | 7 | 28859 | 19 | |||
58451 | 110547 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
60086 | 45551 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 345 Sloat Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | Permit Number 44299 | 5990416.87578702 | 2095931.52068495 | 37.7344772588746 | -122.475565486654 | (37.7344772588746, -122.475565486654) | 1 | 8 | 4 | 64 | 35 | |||
60107 | 214437 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 602 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992311.89414 | 2104591.93492 | 37.7583662094433 | -122.46964410349 | (37.7583662094433, -122.46964410349) | 1 | 8 | 4 | 56 | 12 | |||
60687 | 42765 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
61182 | 120889 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.7126036943297 | -122.407774785999 | (37.7126036943297, -122.407774785999) | 9 | 7 | 8 | 309 | 39 | |||
61618 | 244350 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2017 07:22:00 AM | 3 | Width 0ft | 6005619.219 | 2110418.7508 | 37.7751253943864 | -122.424035805431 | (37.7751253943864, -122.424035805431) | 7 | 9 | 11 | 28852 | 10 | ||
63949 | 32171 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
64335 | 138975 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 461 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005450.5842 | 2110864.9202 | 37.7763409448097 | -122.42465089693 | (37.7763409448097, -122.42465089693) | 7 | 9 | 11 | 28852 | 10 | |||
66396 | 138797 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1823 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6000490.7856 | 2114966.8512 | 37.7873224344393 | -122.442102683059 | (37.7873224344393, -122.442102683059) | 13 | 6 | 1 | 29490 | 27 | |||
71541 | 35302 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3459 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | 8 | 4 | 5 | 28859 | 19 | |||
71821 | 49405 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 288@ OCEAN Onondaga Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2003 12:00:00 AM | Permit Number 46355 | 5999928.15335168 | 2091616.69162038 | 37.7231765280064 | -122.442372291811 | (37.7231765280064, -122.442372291811) | 9 | 7 | 6 | 28861 | 25 | |||
76634 | 36246 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 134 Surrey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1998 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.7359046033608 | -122.434856848009 | (37.7359046033608, -122.434856848009) | 2 | 7 | 5 | 63 | 7 | |||
80467 | 139396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 496 Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005003.1486 | 2111107.1822 | 37.7769808572422 | -122.426215953949 | (37.7769808572422, -122.426215953949) | 7 | 9 | 11 | 28852 | 10 | |||
81051 | 28643 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 Webster St | 5 | Median : Cutout | Tree | DPW 1 | 10 | 20 | 6003700.2631 | 2113325.6745 | 37.7829985565916 | -122.430881399332 | (37.7829985565916, -122.430881399332) | 15 | 9 | 11 | 29490 | 41 | |||
83539 | 38753 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 133 Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | 1 | Permit Number 40630 | 6012187.7155 | 2112376.5476 | 37.7808697121074 | -122.40145140226 | (37.7808697121074, -122.40145140226) | 6 | 2 | 9 | 28856 | 34 | ||
85553 | 214468 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 623 Gennessee St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5997445.52698 | 2095470.21009 | 37.7336155617911 | -122.451231980178 | (37.7336155617911, -122.451231980178) | 9 | 7 | 4 | 59 | 40 | |||
88513 | 104081 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2610 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987336.5 | 2114673.6 | 37.7857588250819 | -122.487591604742 | (37.7857588250819, -122.487591604742) | 11 | 6 | 1 | 55 | 33 | |||||
90077 | 29251 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015137.8598649 | 2101142.4987414 | 37.7501876266135 | -122.390460137824 | (37.7501876266135, -122.390460137824) | 10 | 3 | 8 | 28856 | 1 | ||
90473 | 138872 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 OCTAVIA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005567.8228 | 2110765.4538 | 37.7760744547885 | -122.424238259715 | (37.7760744547885, -122.424238259715) | 7 | 9 | 11 | 28852 | 10 | |||
94594 | 135912 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011493.6768 | 2119059.8121 | 37.7991816185927 | -122.404322975344 | (37.7991816185927, -122.404322975344) | 3 | 1 | 10 | 308 | 23 | ||||
94971 | 196413 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 18 Langton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6009790.62694 | 2111119.41573 | 37.7772838848824 | -122.409655383101 | (37.7772838848824, -122.409655383101) | 8 | 2 | 9 | 28853 | 34 | |||
105774 | 36432 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 435 Montecito Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | 9 | 7 | 4 | 28861 | 40 | ||
106891 | 43833 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2690 35th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | Permit Number 43458 | 5985573.35768067 | 2097037.8388719 | 37.7372329419636 | -122.492392332362 | (37.7372329419636, -122.492392332362) | 1 | 8 | 3 | 29491 | 35 | ||
109263 | 12426 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1701X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/2014 12:00:00 AM | 3 | 4X4 | 6004430.11667 | 2114714.46186 | 37.7868531457277 | -122.428455426283 | (37.7868531457277, -122.428455426283) | 13 | 9 | 11 | 29490 | 27 | ||
110818 | 44089 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | 6 | 2 | 9 | 28856 | 34 | |
111647 | 119864 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
112149 | 88230 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2108 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802 | 2109918 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | 15 | 5 | 11 | 29492 | 16 | ||
113493 | 253347 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1700 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | 13 | 9 | 11 | 29490 | 13 | ||
120908 | 96277 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 5 | Back Yard : Yard | Tree | Private 2 | 2 | 6003933.28624 | 2094328.99121 | 37.7308513660015 | -122.428720586902 | (37.7308513660015, -122.428720586902) | 9 | 7 | 6 | 28861 | 5 | ||||
129191 | 94986 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 6 Leland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010873.097 | 2087120.3037 | 37.711448118617 | -122.404221245197 | (37.711448118617, -122.404221245197) | 9 | 7 | 8 | 309 | 39 | |||
129593 | 178911 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993783.22919 | 2086769.82188 | 37.7095160251039 | -122.463262397352 | (37.7095160251039, -122.463262397352) | 9 | 8 | 6 | 28861 | 25 | ||||
137367 | 196381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012369.74132 | 2112319.30273 | 37.7807226855437 | -122.400817659004 | (37.7807226855437, -122.400817659004) | 6 | 2 | 9 | 28856 | 34 | |||
142403 | 36033 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1660X BRYANT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1998 12:00:00 AM | Permit Number 39178 | 6009346 | 2106886 | 37.7656349852358 | -122.410894426294 | (37.7656349852358, -122.410894426294) | 8 | 4 | 7 | 28853 | 19 | |||
146228 | 23898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1581 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6003553.1196 | 2113987.2345 | 37.7848066960652 | -122.431437697157 | (37.7848066960652, -122.431437697157) | 13 | 9 | 11 | 29490 | 13 | ||
149815 | 139134 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1825 POST ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003440.8714 | 2114149.8668 | 37.7852468810092 | -122.43183765526 | (37.7852468810092, -122.43183765526) | 13 | 9 | 11 | 29490 | 13 | |||
150370 | 178934 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 249 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000059.66319 | 2091611.4621 | 37.7231696637395 | -122.441917314134 | (37.7231696637395, -122.441917314134) | 9 | 7 | 6 | 28861 | 25 | |||
153463 | 244108 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1950 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997159.4208 | 2108812.5222 | 37.7702338463195 | -122.453183989334 | (37.7702338463195, -122.453183989334) | 15 | 5 | 11 | 29492 | 9 | |||
173162 | 95011 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 141 Leland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010324.7589 | 2087356.7063 | 37.7120665771229 | -122.406133097694 | (37.7120665771229, -122.406133097694) | 9 | 7 | 8 | 309 | 39 | |||
179666 | 43324 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 32 Madrid St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | Permit Number 43085 | 6004171.91569518 | 2093420.14794731 | 37.7283693880979 | -122.427830872105 | (37.7283693880979, -122.427830872105) | 9 | 7 | 6 | 28861 | 5 | ||
181373 | 115685 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 100x Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005589 | 2109665 | 37.7730540708525 | -122.424086724818 | (37.7730540708525, -122.424086724818) | 7 | 9 | 11 | 28852 | 10 | ||||
184480 | 214460 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001504.80171 | 2094910.40142 | 37.7323100420806 | -122.437157847364 | (37.7323100420806, -122.437157847364) | 9 | 7 | 4 | 63 | 40 | |||
186593 | 102810 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.00689 | 37.7801402066402 | -122.493254729507 | (37.7801402066402, -122.493254729507) | 11 | 6 | 2 | 55 | 26 | |
186875 | 40946 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 88209 Hoff St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.7635776994032 | -122.420541432191 | (37.7635776994032, -122.420541432191) | 8 | 4 | 7 | 28859 | 19 | |||
190738 | 50537 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
193327 | 107756 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | ||||
193581 | 43004 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 205X Rose St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
193729 | 119871 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
1086 | 91876 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2015 02:50:00 PM | 3 | 3x3 | 5993617.143263 | 2106666.291015 | 37.7641372031802 | -122.465280687147 | (37.7641372031802, -122.465280687147) | 11 | 8 | 11 | 56 | 12 | ||
1961 | 259574 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 298 Public Park | 4 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
4527 | 35301 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3459 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | 8 | 4 | 5 | 28859 | 19 | |||
7694 | 44088 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 500 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43605 | 6013788.61209882 | 2112522.22157888 | 37.7813588929752 | -122.395923288248 | (37.7813588929752, -122.395923288248) | 6 | 2 | 9 | 28856 | 34 | |
8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
10215 | 45064 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2101 27th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43947 | 5987870.53797958 | 2100985.88306806 | 37.7482072643075 | -122.484739557427 | (37.7482072643075, -122.484739557427) | 1 | 8 | 3 | 29491 | 35 | ||
10688 | 31923 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2296 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.471361438247 | (37.7451690123809, -122.471361438247) | 1 | 8 | 4 | 29491 | 40 | ||
11581 | 98091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007129.63323 | 2115568.12393 | 37.7893494826426 | -122.419176280756 | (37.7893494826426, -122.419176280756) | 13 | 9 | 10 | 28858 | 21 | ||
12262 | 261408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
13229 | 21689 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1881 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003724.339 | 2114539.1952 | 37.7863319437467 | -122.43088473956 | (37.7863319437467, -122.43088473956) | 13 | 9 | 11 | 29490 | 13 | |||
14432 | 178904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011792.88406 | 2090769.73397 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | 10 | 3 | 8 | 309 | 28 | |||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
18214 | 46802 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 90 Ravenwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44890 | 5994259.7635246 | 2095973.46470501 | 37.7348144532504 | -122.462282494227 | (37.7348144532504, -122.462282494227) | 9 | 8 | 4 | 59 | 40 | ||
22903 | 40229 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
23647 | 102209 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 89X Elgin Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.423097025843 | (37.7700345996314, -122.423097025843) | 8 | 2 | 5 | 28853 | 19 | |
24064 | 178910 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993781.83724 | 2086767.02745 | 37.7095082720684 | -122.463267005492 | (37.7095082720684, -122.463267005492) | 9 | 8 | 6 | 28861 | 25 | ||||
28356 | 113747 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 6009570.41641 | 2118454.83114 | 37.7974128301892 | -122.410935389082 | (37.7974128301892, -122.410935389082) | 3 | 1 | 10 | 308 | 4 | |||
30425 | 142001 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 762 FULTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004249.2696 | 2111539.4607 | 37.7781251474871 | -122.428854679323 | (37.7781251474871, -122.428854679323) | 7 | 9 | 11 | 28852 | 41 | |||
30743 | 139133 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1825 POST ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003414.7227 | 2114147.3157 | 37.7852383939957 | -122.431927939461 | (37.7852383939957, -122.431927939461) | 13 | 9 | 11 | 29490 | 13 | |||
36097 | 115453 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 300 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
36216 | 36431 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 435 Montecito Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | 9 | 7 | 4 | 28861 | 40 | ||
36560 | 245991 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1250 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999788.9734 | 2108484.4317 | 37.769483351344 | -122.444064834189 | (37.769483351344, -122.444064834189) | 15 | 5 | 11 | 29492 | 9 | |||
37262 | 183938 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1813 Quintara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987797.5686 | 2100976.6866 | 37.7481777632633 | -122.484991205508 | (37.7481777632633, -122.484991205508) | 1 | 8 | 3 | 29491 | 35 | |||
39487 | 244972 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 209 Rose St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005534.5777 | 2109768.9686 | 37.7733364706745 | -122.424282374507 | (37.7733364706745, -122.424282374507) | 7 | 9 | 11 | 28852 | 10 | |||
39804 | 36386 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 701 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39327 | 5994874.34714832 | 2092695.1965564 | 37.7258484957944 | -122.459920281258 | (37.7258484957944, -122.459920281258) | 9 | 7 | 4 | 28861 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );