trees
2,306 rows where qSpecies_id = 15 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
159 | 117627 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
161 | 194506 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 26 | Median : Yard | Tree | DPW 1 | 18 | 6016624.93937 | 2096021.78221 | 37.7362095654157 | -122.384960961105 | (37.7362095654157, -122.384960961105) | 10 | 3 | 8 | 58 | 1 | ||||
170 | 108637 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 15 TUCKER AVE | Back Yard : Yard | Tree | Private 2 | 6011049.2 | 2088423.2 | 37.7150354478954 | -122.403704200211 | (37.7150354478954, -122.403704200211) | 9 | 7 | 8 | 309 | 39 | ||||||
176 | 194490 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 22nd St | 19 | Front Yard : Yard | Tree | Private 2 | 29 | 6013346.63868 | 2103825.44695 | 37.7574548949481 | -122.396842409144 | (37.7574548949481, -122.396842409144) | 10 | 3 | 8 | 28856 | 29 | ||||
230 | 114428 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 34x HIGUERA AVE | 2 | Median : Yard | Tree | Private 2 | 56 | 5987903 | 2090420 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | 1 | 8 | 4 | 64 | 14 | ||||
245 | 251484 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 7 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
483 | 173928 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51 Vulcan Stwy | 1 | Front Yard : Cutout | Tree | Private 2 | 6000543 | 2106304 | 37.7635394137592 | -122.441300222472 | (37.7635394137592, -122.441300222472) | 15 | 5 | 5 | 28862 | 3 | |||||
844 | 254210 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
1378 | 95407 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2X Cranleigh Dr | 9 | Median : Yard | Tree | DPW 1 | 80 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | ||||
2174 | 173658 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 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 | |||||
2512 | 99518 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
2907 | 194508 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 299x Cashmere St | 28 | Median : Yard | Tree | DPW 1 | 23 | 6016611.71691 | 2096022.49532 | 37.7362107920965 | -122.385006726687 | (37.7362107920965, -122.385006726687) | 10 | 3 | 8 | 58 | 1 | ||||
3166 | 194483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 930 Kansas St | 2 | Front Yard : Yard | Tree | Private 2 | 31 | 6011593.09908 | 2103991.17748 | 37.7578121947052 | -122.402918540071 | (37.7578121947052, -122.402918540071) | 10 | 3 | 8 | 28856 | 29 | ||||
3326 | 104499 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 44X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 18 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
4672 | 246634 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3320 Harrison St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6009032.675 | 2099260.65572 | 37.7446799344495 | -122.411439388921 | (37.7446799344495, -122.411439388921) | 2 | 7 | 7 | 28859 | 2 | ||||
4778 | 201565 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Jerrold Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | 6019673.98228 | 2093813.82501 | 37.7303151200443 | -122.374266134286 | (37.7303151200443, -122.374266134286) | 10 | 3 | 8 | 58 | 1 | ||||
4876 | 211087 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1840 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 56 | 5992084.81362 | 2102739.60541 | 37.7532670696221 | -122.47029454987 | (37.7532670696221, -122.47029454987) | 1 | 8 | 4 | 56 | 12 | ||||
4918 | 104883 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990322.1 | 2090011.1 | 37.7182157760013 | -122.475461023549 | (37.7182157760013, -122.475461023549) | 1 | 8 | 4 | 64 | 14 | |||||
5980 | 113539 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100X CASHMERE ST | 2 | Median : Yard | Tree | DPW 1 | 20 | 6017054 | 2095889 | 37.7358686950692 | -122.383468266853 | (37.7358686950692, -122.383468266853) | 10 | 3 | 8 | 58 | 1 | ||||
6239 | 261665 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 401X Greenwich St | 1 | Unaccepted Street : Cutout | Tree | DPW 1 | |||||||||||||||
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 | |||||
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 | |||||
7194 | 117622 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
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 | |||||
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 | |||
8847 | 110165 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 129x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
9254 | 87113 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 4 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
9602 | 98360 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | |||||
10032 | 254212 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 81X Elsie St | 10 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
10821 | 4986 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | ||||
11775 | 173632 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3300X Market St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
11878 | 104919 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 732 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
11983 | 247089 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2301 Castro St | 7 | Front Yard : Yard | Tree | Private 2 | 1 | 6002763.93739 | 2098596.7389 | 37.7425033709224 | -122.433068014888 | (37.7425033709224, -122.433068014888) | 2 | 7 | 5 | 63 | 22 | ||||
12060 | 101900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100 Ocean Ave | 1 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
12343 | 194488 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1401 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6012030.15727 | 2101805.35505 | 37.751834800344 | -122.401253403036 | (37.751834800344, -122.401253403036) | 10 | 3 | 8 | 28856 | 29 | ||||
12546 | 111544 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x BOSWORTH ST | 22 | Front Yard : Yard | Tree | DPW 1 | 10 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
12659 | 122532 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1900X Castro St | 1 | Unaccepted Street : Yard | Tree | Private 2 | |||||||||||||||
13538 | 178318 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 5988183.85887 | 2090397.25913 | 37.7191518903345 | -122.482880208457 | (37.7191518903345, -122.482880208457) | 1 | 8 | 4 | 64 | 14 | ||||
14499 | 114038 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 2x Moffitt St | 3 | Side Yard : Yard | Tree | Private 2 | 35 | 6002767.77413 | 2096661.31369 | 37.7371893582097 | -122.432916509122 | (37.7371893582097, -122.432916509122) | 2 | 7 | 5 | 63 | 7 | ||||
14673 | 187603 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 748 University St | 7 | Front Yard : Yard | Tree | Private 2 | 19 | 6008732.08795 | 2090689.33982 | 37.7211280830698 | -122.411873196707 | (37.7211280830698, -122.411873196707) | 9 | 7 | 7 | 309 | 18 | ||||
15093 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x Avalon Ave | 3 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
15154 | 102838 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15601 | 99374 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 21 Panorama Dr | Back Yard : Yard | Tree | Private 2 | 24 | 5998009 | 2100230 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | 1 | 5 | 4 | 63 | 38 | |||||
16189 | 104502 | Private 9 | Pinus radiata :: Monterey Pine 15 | 30X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 14 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
16196 | 251543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard | Tree | Private 2 | ||||||||||||||||
17896 | 100177 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 252 States St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768965 | 6000636 | 2106677.4 | 37.7645699751489 | -122.44100535545 | (37.7645699751489, -122.44100535545) | 15 | 5 | 5 | 28862 | 3 | ||||
18102 | 222602 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 395 Sussex St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 41 | 6000838.13576 | 2096656.80863 | 37.73706735137 | -122.439587811054 | (37.73706735137, -122.439587811054) | 2 | 7 | 5 | 63 | 7 | ||||
18372 | 121500 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 251X Pennsylvania Ave | 1 | Back Yard : Yard | Tree | DPW 1 | |||||||||||||||
18614 | 132205 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 12 Greenwich St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6012257.5514 | 2120548.1369 | 37.8033108539845 | -122.401784364564 | (37.8033108539845, -122.401784364564) | 3 | 1 | 10 | 28860 | 6 | ||||
18723 | 95885 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
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 | |||||
19174 | 261294 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 801 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6012760.41981 | 2103766.81895 | 37.7572612683759 | -122.398865686828 | (37.7572612683759, -122.398865686828) | 10 | 3 | 8 | 28856 | 29 | |||||
19407 | 233306 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 174 Carnelian Way | 1 | : Yard | Tree | Private 2 | 26 | 6000631.47853 | 2100513.23992 | 37.7476444344533 | -122.44057883697 | (37.7476444344533, -122.44057883697) | 2 | 4 | 5 | 63 | 22 | ||||
19601 | 95883 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
20180 | 99132 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 302X Pacheco St | 15 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
20589 | 178347 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 99 Bowdoin St | 1 | Side Yard : Yard | Tree | Private 2 | 37 | 6008416.70539 | 2094741.77162 | 37.7322374982533 | -122.413249807854 | (37.7322374982533, -122.413249807854) | 9 | 3 | 7 | 309 | 28 | ||||
20737 | 114465 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 404 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||||
22008 | 132208 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Union St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6012099.30323 | 2119801.66278 | 37.8012523849575 | -122.402279475534 | (37.8012523849575, -122.402279475534) | 3 | 1 | 10 | 28860 | 6 | ||||
22091 | 211169 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 87 Lippard Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 6001942.47836 | 2095586.20229 | 37.7341905055893 | -122.435693033412 | (37.7341905055893, -122.435693033412) | 2 | 7 | 5 | 63 | 7 | ||||
22111 | 178341 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 78 Mansfield St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6005254.35073 | 2091748.15576 | 37.7238396388741 | -122.423969991927 | (37.7238396388741, -122.423969991927) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||||
22742 | 112442 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 36 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
22835 | 247950 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 7 Joy St | 3 | Side Yard : Yard | Tree | Private 2 | 21 | 6010415.94161 | 2098863.8955 | 37.7436680064781 | -122.406628345115 | (37.7436680064781, -122.406628345115) | 2 | 7 | 7 | 28859 | 2 | ||||
23064 | 211175 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 24 Ashton Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5994178.62762 | 2090127.07323 | 37.7187570114974 | -122.462139154897 | (37.7187570114974, -122.462139154897) | 9 | 8 | 6 | 28861 | 24 | ||||
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 | ||||
23678 | 211144 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Terrace Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | 5993373.46569 | 2096862.7426 | 37.7372051149341 | -122.465411285997 | (37.7372051149341, -122.465411285997) | 1 | 8 | 4 | 59 | 40 | ||||
23741 | 99131 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 302X Pacheco St | 14 | Median : Cutout | Tree | Private 2 | 3 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
23834 | 107210 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 603 PERALTA AVE | 1 | unknown : Yard | Tree | Private 2 | 30 | 6009839.9 | 2098688.7 | 37.7431547125392 | -122.408607810015 | (37.7431547125392, -122.408607810015) | 10 | 7 | 7 | 28859 | 2 | ||||
24247 | 233316 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3980 22nd St | 9 | : | Tree | Private 2 | 8 | 6001893.37718 | 2102947.6571 | 37.7544005409683 | -122.43638947561 | (37.7544005409683, -122.43638947561) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |||||
24524 | 107157 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301X Esmeralda Ave | 1 | Unaccepted Street : Yard | Tree | Private 2 | 28 | 6007313 | 2098782 | 37.7432690474632 | -122.417351790512 | (37.7432690474632, -122.417351790512) | 2 | 7 | 7 | 28859 | 2 | ||||
24612 | 99521 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
24614 | 105834 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 3031 QUINTARA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5984010.9 | 2100823.5 | 37.747535864547 | -122.498073868906 | (37.747535864547, -122.498073868906) | 1 | 8 | 3 | 29491 | 35 | ||||
24957 | 234529 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 San Jose Av Off Ramp | 8 | Front Yard : Yard | Tree | Private 2 | 12 | 6002999.62487 | 2095331.39066 | 37.7335508412 | -122.432019955754 | (37.7335508412, -122.432019955754) | 2 | 7 | 5 | 63 | 7 | ||||
25020 | 54835 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 117 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 15 | Permit Number 10689 | 5998722.2979 | 2110262.8651 | 37.7743055679817 | -122.447882461981 | (37.7743055679817, -122.447882461981) | 15 | 5 | 11 | 29492 | 16 | ||
25153 | 211100 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 198x San Anselmo Ave | 4 | Median : Yard | Tree | DPW 1 | 41 | 5993653.9743 | 2096326.24073 | 37.7357481880204 | -122.464402505688 | (37.7357481880204, -122.464402505688) | 1 | 8 | 4 | 59 | 40 | ||||
25270 | 124269 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 9 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5994882.44582 | 2114964.8982 | 37.7869958645771 | -122.461506079992 | (37.7869958645771, -122.461506079992) | 11 | 6 | 1 | 54 | 11 | ||||
25280 | 111534 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x BOSWORTH ST | 12 | Front Yard : Yard | Tree | DPW 1 | 30 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
25286 | 201566 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 799 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6019697.16467 | 2093717.76615 | 37.7300526357971 | -122.374179337111 | (37.7300526357971, -122.374179337111) | 10 | 3 | 8 | 58 | 1 | ||||
25771 | 194495 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2 Tulare St | 13 | Front Yard : Yard | Tree | Private 2 | 6 | 6016190.05979 | 2100302.20421 | 37.7479386656413 | -122.38676294076 | (37.7479386656413, -122.38676294076) | 3 | 8 | 58 | 1 | |||||
26583 | 108044 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard | Tree | DPW 1 | 99 | 5985539 | 2095817 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | 1 | 8 | 4 | 64 | 35 | ||||
26584 | 104941 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 133X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
26762 | 247062 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 626 30th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 41 | 6002537.3852 | 2098319.51019 | 37.7417293118561 | -122.433831553686 | (37.7417293118561, -122.433831553686) | 2 | 7 | 5 | 63 | 7 | ||||
26929 | 178314 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | 5989006.41886 | 2090486.32798 | 37.7194442778983 | -122.480043480515 | (37.7194442778983, -122.480043480515) | 1 | 8 | 4 | 64 | 14 | ||||
27030 | 106971 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 3479X San Bruno Ave | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6011510.60551 | 2091910.03431 | 37.7246353494236 | -122.402354399294 | (37.7246353494236, -122.402354399294) | 10 | 3 | 7 | 309 | 28 | ||||
27105 | 211166 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 87 Lippard Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 34 | 6001935.96682 | 2095524.15312 | 37.7340197629844 | -122.435711108008 | (37.7340197629844, -122.435711108008) | 2 | 7 | 5 | 63 | 7 | ||||
27633 | 113114 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1x TOMASO CT | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
27645 | 251483 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 8 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
28156 | 114119 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
28407 | 194476 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900x Carolina St | 43 | Median : Yard | Tree | DPW 1 | 22 | 6012491.75598 | 2103075.93483 | 37.755349278054 | -122.399746327228 | (37.755349278054, -122.399746327228) | 10 | 3 | 8 | 28856 | 29 | ||||
28773 | 114213 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 230 SERRANO DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 60 | 5988981 | 2090766 | 37.7202107101289 | -122.480151800691 | (37.7202107101289, -122.480151800691) | 1 | 8 | 4 | 64 | 14 | ||||
28834 | 251489 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 31 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
28994 | 178321 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5989145.21541 | 2089457.74529 | 37.716628110272 | -122.479488503489 | (37.716628110272, -122.479488503489) | 1 | 8 | 4 | 64 | 14 |
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) );