trees
1,732 rows where qLegalStatus_id = 6 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5577 | 92312 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2711 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985822.132 | 2096946.3119 | 37.7369961745626 | -122.49152548244 | (37.7369961745626, -122.49152548244) | 1 | 8 | 3 | 29491 | 35 | ||
5983 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 131X Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.7962664536588 | -122.397554954018 | (37.7962664536588, -122.397554954018) | 3 | 1 | 10 | 28860 | 6 | |
7373 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
12033 | 259149 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 150 Lenox Way | 1 | Front Yard : Yard | Tree | Private 2 | 5x5 | 5993309.4847 | 2098463.34097 | 37.7415962663129 | -122.465748753199 | (37.7415962663129, -122.465748753199) | 1 | 8 | 4 | 59 | 40 | ||||
26906 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3700 Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | 11 | 6 | 1 | 54 | 31 | |
41336 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
100865 | 96279 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 55@ Alemany Trumbull St | 7 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
103743 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
171699 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.52821 | 37.8031223210123 | -122.418746939923 | (37.8031223210123, -122.418746939923) | 5 | 1 | 1 | 28858 | 32 | |
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
63 | 264975 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 1 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
68 | 264976 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 2 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
256 | 254254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
2352 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700X Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | 1 | 5 | 4 | 63 | 38 | |||||
2713 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
3462 | 233333 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 188 States St | 1 | Back Yard : Yard | Tree | Private 2 | 14 | Width 3ft | Permit Number 784841 | 6001049.9199 | 2106366.66768 | 37.763740347549 | -122.43955144426 | (37.763740347549, -122.43955144426) | 15 | 5 | 5 | 28862 | 3 | ||
4737 | 261021 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
4898 | 211279 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 350 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 10ft | 5999756.13451 | 2094992.8184 | 37.7324367835174 | -122.443209289192 | (37.7324367835174, -122.443209289192) | 9 | 7 | 4 | 63 | 40 | |||
5905 | 261162 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 595 Newhall St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 6016024 | 2097656 | 37.7406635379999 | -122.387152626875 | (37.7406635379999, -122.387152626875) | 10 | 3 | 8 | 58 | 1 | |||
6044 | 259265 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
6296 | 260461 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
6334 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
6519 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
6758 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 180 Yukon St | Back Yard : Cutout | Tree | Private 2 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.442406920559 | (37.7570738455347, -122.442406920559) | 2 | 4 | 5 | 28862 | 3 | ||||
7000 | 251607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 52 Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999455 | 2100046 | 37.7462944425817 | -122.444613441074 | (37.7462944425817, -122.444613441074) | 2 | 7 | 5 | 63 | 22 | |||||
7026 | 121414 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150 Raccoon Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 36 | 3x3 | 5998776 | 2103987 | 37.7570766935068 | -122.447244922317 | (37.7570766935068, -122.447244922317) | 15 | 5 | 5 | 63 | 3 | |||
7196 | 251612 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 60R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999394 | 2100048 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | 2 | 7 | 5 | 63 | 22 | |||||
7631 | 256540 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
8163 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 51 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | 2 | 7 | 7 | 28859 | 2 | |||
8965 | 261020 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
9066 | 260960 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1001 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
9862 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
9966 | 251172 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 363 Jersey St | 2 | Front Yard : Yard | Tree | Private 2 | 6002784.74363 | 2101501.25508 | 37.750479672211 | -122.433203561601 | (37.750479672211, -122.433203561601) | 2 | 4 | 5 | 28862 | 22 | |||||
11182 | 261019 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3450X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784867 | 5990575 | 2092822 | 37.725948465298 | -122.47479191789 | (37.725948465298, -122.47479191789) | 9 | 8 | 4 | 64 | 14 | |||
12289 | 254085 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5995707 | 2096451 | 37.7362088759349 | -122.457313463895 | (37.7362088759349, -122.457313463895) | 9 | 7 | 4 | 59 | 40 | ||||
14911 | 264785 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1738 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10x10 | 5991929 | 2103547 | 37.7554749546691 | -122.470892190435 | (37.7554749546691, -122.470892190435) | 1 | 8 | 4 | 56 | 12 | ||||
15093 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x Avalon Ave | 3 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
16781 | 260951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 190 Jackson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6013038 | 2118237 | 37.7970085486816 | -122.398921272101 | (37.7970085486816, -122.398921272101) | 3 | 1 | 10 | 28860 | 6 | ||||
17333 | 259266 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
18320 | 261763 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 315 Montcalm St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009577 | 2099558 | 37.7455268923792 | -122.409578193595 | (37.7455268923792, -122.409578193595) | 2 | 7 | 7 | 28859 | 2 | ||||
18957 | 259263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
19052 | 260948 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 370 Drumm St | 1 | Side Yard : Yard | Tree | Private 2 | 6013616 | 2118213 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | 3 | 1 | 10 | 28860 | 6 | |||||
19246 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
19844 | 254259 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
20972 | 254094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781012 | 5994209 | 2099943 | 37.7457108840866 | -122.462745872627 | (37.7457108840866, -122.462745872627) | 1 | 8 | 4 | 29491 | 40 | |||
22273 | 106336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 112 EUGENIA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6006345.6 | 2098165.7 | 37.7415223501304 | -122.420653072553 | (37.7415223501304, -122.420653072553) | 2 | 7 | 7 | 28859 | 2 | ||||
23065 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
23401 | 114142 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6001906.1 | 2108188.4 | 37.7687910682296 | -122.436720598265 | (37.7687910682296, -122.436720598265) | 15 | 5 | 5 | 29492 | 3 | ||||||
23427 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 4 | Back Yard : Yard | Tree | Private 2 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||||
24444 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 240 States St | 1 | Back Yard : Yard | Tree | Private 2 | 6001213 | 2106258 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | 15 | 5 | 5 | 28862 | 3 | |||||
25777 | 257968 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
28176 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard | Tree | Private 2 | 32 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
30556 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 533 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
30591 | 105422 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5827 DIAMOND HEIGHTS BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 6000844.1 | 2096795.2 | 37.7374476811542 | -122.439577108095 | (37.7374476811542, -122.439577108095) | 2 | 7 | 5 | 63 | 7 | ||||
31451 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard | Tree | Private 2 | 8 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
32937 | 178336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | MTA 3 | 29 | Width 8ft | 5998664.9682 | 2091522.93582 | 37.7228470175482 | -122.44673211619 | (37.7228470175482, -122.44673211619) | 9 | 7 | 6 | 28861 | 25 | |||
34293 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150x FONT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976 | 2089133 | 37.7158426125161 | -122.473136789074 | (37.7158426125161, -122.473136789074) | 1 | 8 | 4 | 64 | 14 | ||
34428 | 251636 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 22R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999148 | 2100052 | 37.7462933941297 | -122.445675437709 | (37.7462933941297, -122.445675437709) | 2 | 7 | 5 | 63 | 22 | |||||
34533 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 7X CASTRO ST | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002014.1 | 2108690 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | 15 | 5 | 5 | 29492 | 9 | ||||
34770 | 251426 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5020 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999455 | 2100046 | 37.7462944425817 | -122.444613441074 | (37.7462944425817, -122.444613441074) | 2 | 7 | 5 | 63 | 22 | |||||
34790 | 105768 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 98X GOLD MINE DR | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 6001350 | 2099153 | 37.7439504273559 | -122.437996817375 | (37.7439504273559, -122.437996817375) | 2 | 7 | 5 | 63 | 22 | ||||
35278 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999865 | 2112093 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | 15 | 5 | 1 | 29490 | 16 | ||||
35918 | 109061 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 36 ARBOR ST | Front Yard : Yard | Tree | Private 2 | Permit Number 774913 | 6002094.4 | 2096943.6 | 37.7379262346414 | -122.435264853151 | (37.7379262346414, -122.435264853151) | 2 | 7 | 5 | 63 | 7 | |||||
37143 | 257967 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
38051 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | 5998985.48572 | 2105240.3128 | 37.7605299471227 | -122.446610614338 | (37.7605299471227, -122.446610614338) | 15 | 5 | 5 | 28862 | 12 | ||||||
38864 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
39032 | 251604 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 48R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
39106 | 116501 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 71X PARKRIDGE DR | 2 | Median : Yard | Tree | Private 2 | 40 | 3x3 | 5999012 | 2102131 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | 2 | 5 | 5 | 63 | 38 | |||
39321 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
41301 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 5985761 | 2114995 | 37.7865492821054 | -122.493065995445 | (37.7865492821054, -122.493065995445) | 11 | 6 | 1 | 55 | 33 | |||||
42183 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6017060.74507 | 2098543.22184 | 37.7431570265693 | -122.383629676533 | (37.7431570265693, -122.383629676533) | 10 | 3 | 8 | 58 | 1 | |||
44600 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
44800 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
47402 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
49109 | 104146 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1710-1738 Diamond St | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 6001979.7 | 2099047.6 | 37.7436968136687 | -122.435811922611 | (37.7436968136687, -122.435811922611) | 2 | 7 | 5 | 63 | 22 | ||||
50063 | 105765 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 95 ORA WAY | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6001454.9 | 2097857 | 37.7403978808149 | -122.437541306682 | (37.7403978808149, -122.437541306682) | 2 | 7 | 5 | 63 | 7 | ||||
50856 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |
51080 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
51266 | 255290 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3353 19th Ave | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5990801 | 2093784 | 37.7286029699614 | -122.474080817952 | (37.7286029699614, -122.474080817952) | 9 | 8 | 4 | 64 | 40 | ||||
51304 | 255705 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 200X Blairwood Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5995660 | 2102951 | 37.7540535603115 | -122.457946200633 | (37.7540535603115, -122.457946200633) | 1 | 5 | 4 | 63 | 12 | ||||
51579 | 251199 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 4 | Front Yard : Yard | Tree | Private 2 | 3X3 | 6002515 | 2107976 | 37.768242455455 | -122.434599270731 | (37.768242455455, -122.434599270731) | 15 | 5 | 5 | 28862 | 3 | ||||
51852 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard | Tree | Private 2 | 32 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
53862 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1101 Connecticut St | 1 | Front Yard : Yard | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
53875 | 254255 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
54303 | 178335 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | MTA 3 | 33 | Width 8ft | 5998656.04486 | 2091523.12147 | 37.7228470175503 | -122.446762975526 | (37.7228470175503, -122.446762975526) | 9 | 7 | 6 | 28861 | 25 | |||
54493 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
58651 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1201 Holloway Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5992431.5 | 2091178.1 | 37.7215421255294 | -122.468254640211 | (37.7215421255294, -122.468254640211) | 9 | 8 | 6 | 64 | 24 | |||||
58933 | 116864 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 262X OAK PARK DR | 3 | Back Yard : Cutout | Tree | Private 2 | 10x10 | 5995091 | 2103085 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | 1 | 5 | 4 | 63 | 12 | ||||
59395 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
59764 | 105504 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 39 MAGELLAN AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5994694.1 | 2101166.3 | 37.7490976851152 | -122.461157135733 | (37.7490976851152, -122.461157135733) | 1 | 8 | 4 | 29491 | 40 | ||||
59956 | 255159 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 4150 Clement St | 1 | Front Yard : Yard | Tree | Private 2 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |||||
60038 | 258526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 50 Hermann St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
63888 | 254137 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1619 47th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 6x6 | 5981543 | 2104041 | 37.756225206981 | -122.506846181577 | (37.756225206981, -122.506846181577) | 1 | 8 | 3 | 56 | 35 | ||||
66713 | 107149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 612 WISCONSIN ST | 1 | Back Yard : Yard | Tree | Private 2 | 6012651.9 | 2104553.6 | 37.7594155491308 | -122.399296223309 | (37.7594155491308, -122.399296223309) | 10 | 3 | 8 | 28856 | 29 | |||||
66926 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 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) );