trees
2,306 rows where qSpecies_id = 15 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
34 | 262408 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 66X Edgehill Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994840 | 2098758 | 37.7424934921887 | -122.46047813267 | (37.7424934921887, -122.46047813267) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||
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 | ||||
182 | 20628 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1492X Sunset Blvd | 11 | Median : Cutout | Tree | DPW 1 | 36 | 60 | 5984803.7392562 | 2105036.6950477 | 37.7591505890295 | -122.495643037613 | (37.7591505890295, -122.495643037613) | 1 | 8 | 3 | 56 | 35 | |||
228 | 256437 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 3001 Sunset Blvd | 25 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
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 | ||||
243 | 21365 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2592X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||||
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 | ||||
289 | 211158 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Marietta Dr | 38 | Median : Cutout | Tree | DPW 1 | 21 | Width 5ft | 5999457.51761 | 2097516.55077 | 37.7393493243992 | -122.444422982731 | (37.7393493243992, -122.444422982731) | 9 | 7 | 4 | 59 | 40 | |||
306 | 20543 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1303X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
342 | 115652 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 18 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
390 | 255918 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 80 Molimo Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998634.42423 | 2096706.77911 | 37.7370788872961 | -122.447210599537 | (37.7370788872961, -122.447210599537) | 9 | 7 | 4 | 59 | 40 | ||||
430 | 121151 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Payson St | 1 | Side Yard : Yard | Tree | DPW 1 | 25 | 3x3 | 5992041 | 2087761 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | 9 | 8 | 4 | 64 | 24 | |||
451 | 114938 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 14 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
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 | |||||
515 | 262251 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
533 | 257925 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 274 Staples Ave | Back Yard : Yard | Tree | Private 2 | 10x10 | 5998272.17919 | 2093819.44967 | 37.7291302611298 | -122.448255187535 | (37.7291302611298, -122.448255187535) | 9 | 7 | 4 | 28861 | 40 | |||||
567 | 181420 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1500 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984891.1718 | 2104759.369 | 37.7583942485176 | -122.495320206303 | (37.7583942485176, -122.495320206303) | 1 | 8 | 3 | 56 | 35 | |||
628 | 256542 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 133 Olympia Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5996852 | 2101844 | 37.7510824274474 | -122.453744067192 | (37.7510824274474, -122.453744067192) | 1 | 5 | 4 | 63 | 38 | ||||
689 | 119914 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 400X Brotherhood Way | 1 | Front Yard : Yard | Tree | DPW 1 | 100x100 | ||||||||||||||
724 | 178311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | 10x10 | 5989003 | 2090507 | 37.7195008394357 | -122.480056810171 | (37.7195008394357, -122.480056810171) | 1 | 8 | 4 | 64 | 14 | |||
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 | |||
815 | 20416 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 453X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
844 | 254210 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 300x Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
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 | |||
932 | 111099 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 480X LAKESHORE DR | 20 | Median : Cutout | Tree | DPW 1 | 30x200 | 5984942 | 2095282 | 37.7323749444343 | -122.494445798495 | (37.7323749444343, -122.494445798495) | 1 | 8 | 4 | 64 | 35 | ||||
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 | |||
1144 | 20400 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
1176 | 119263 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Lakeshore Dr | 1 | Median : Yard | Tree | DPW 1 | 10x30 | ||||||||||||||
1189 | 261265 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 5 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
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 | ||||
1428 | 194473 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 851 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 8ft | 6014996.92919 | 2104399.34696 | 37.7591224196901 | -122.391175112734 | (37.7591224196901, -122.391175112734) | 10 | 3 | 8 | 28856 | 29 | |||
1523 | 260685 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 198X Miraloma Dr | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | ||||
1531 | 20287 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
1536 | 187084 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2600 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 0ft | 5985178.0339 | 2097042.9902 | 37.7372239657972 | -122.493759507537 | (37.7372239657972, -122.493759507537) | 1 | 8 | 3 | 29491 | 35 | |||
1886 | 20313 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
1978 | 87100 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 700 Connecticut St | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x3 | Permit Number 50056 | |||||||||||||
1982 | 20405 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 262X Sunset Blvd | 50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
2030 | 112443 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2199x 25TH ST | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6012503 | 2101856 | 37.7520002291367 | -122.399621792735 | (37.7520002291367, -122.399621792735) | 10 | 3 | 8 | 28856 | 29 | ||||
2059 | 264900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 35X Parkridge Dr | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5999060 | 2101975 | 37.7515684597407 | -122.446118026985 | (37.7515684597407, -122.446118026985) | 2 | 5 | 5 | 63 | 38 | ||||
2067 | 211204 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700 Junipero Serra Blvd | 150 | : | Tree | Private 2 | 8 | Width 0ft | 5991184.95958 | 2091479.43645 | 37.7222974463483 | -122.472585508941 | (37.7222974463483, -122.472585508941) | 9 | 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 | |||
2194 | 261477 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 6 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
2266 | 87917 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 160 Gardenside Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367 | 2102115 | 37.7519703925615 | -122.445066449965 | (37.7519703925615, -122.445066449965) | 2 | 5 | 5 | 63 | 38 | ||
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 | |||
2568 | 20451 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
2578 | 139478 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 416 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2020 12:00:00 AM | 3 | Width 0ft | 5999096.683 | 2111385.8942 | 37.7774105099956 | -122.446668218684 | (37.7774105099956, -122.446668218684) | 15 | 5 | 11 | 29492 | 16 | ||
2688 | 253070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 134 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | Width 0ft | Permit Number 780451 | 5995517 | 2087474 | 37.7115492645372 | -122.45732113821 | (37.7115492645372, -122.45732113821) | 9 | 8 | 6 | 28861 | 24 | |||
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 | ||||
2808 | 261474 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
2812 | 19775 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
2845 | 21487 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2792X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5985060.3629888 | 2096294.4798015 | 37.7351618711636 | -122.49411119238 | (37.7351618711636, -122.49411119238) | 1 | 8 | 3 | 29491 | 35 | |||
2894 | 11190 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 140 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 24 | 8 | 5995683.1150394 | 2099368.7198886 | 37.7442188444672 | -122.457607088025 | (37.7442188444672, -122.457607088025) | 1 | 8 | 4 | 59 | 40 | |||
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 | ||||
3000 | 20052 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY53 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
3020 | 260513 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1990 41st Ave | 1 | Back Yard : Yard | Tree | Health Dept 13 | 10x10 | 5983703 | 2101544 | 37.7494961014415 | -122.499191781388 | (37.7494961014415, -122.499191781388) | 1 | 8 | 3 | 29491 | 35 | ||||
3106 | 20323 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 101X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3149 | 21387 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2601X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5985098.343425 | 2097506.3093477 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||||
3176 | 233293 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Eugenia Ave | 32 | Front Yard : Yard | Tree | Private 2 | 24 | Width 10ft | 6006620.44914 | 2098098.60188 | 37.7413536002823 | -122.419697976596 | (37.7413536002823, -122.419697976596) | 2 | 7 | 7 | 28859 | 2 | |||
3197 | 261564 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
3269 | 178256 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 500x Mansell St | 14 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6010359.75763 | 2090312.49843 | 37.7201845359677 | -122.40622025079 | (37.7201845359677, -122.40622025079) | 10 | 3 | 8 | 309 | 28 | |||
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 | ||||
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 | ||
3639 | 20284 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
3872 | 262252 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4210 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
4038 | 20457 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 495X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
4148 | 111380 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301x OCEAN AVE | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | MTA | 24 | 3x3 | 5999454 | 2091552 | 37.7229718629586 | -122.44400669589 | (37.7229718629586, -122.44400669589) | 9 | 7 | 6 | 28861 | 25 | ||
4239 | 258982 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 239 Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997275 | 2101153 | 37.7492093542443 | -122.452231443092 | (37.7492093542443, -122.452231443092) | 1 | 5 | 4 | 63 | 38 | ||||
4407 | 185467 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 19 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985112.4406 | 2098402.8327 | 37.7409538906719 | -122.494086484448 | (37.7409538906719, -122.494086484448) | 1 | 8 | 3 | 29491 | 35 | |||
4494 | 20293 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 20X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
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 | ||||
4731 | 19749 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY15 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
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 | |||
4776 | 19969 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY43 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15 | |||||||||||||
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 | ||||
4854 | 117978 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 428 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5984094.13719 | 2112920.10602 | 37.7807546046446 | -122.498679507303 | (37.7807546046446, -122.498679507303) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||||
4884 | 260462 | Private 9 | Pinus radiata :: Monterey Pine 15 | 119 Moffitt St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002736 | 2096650 | 37.7371564911538 | -122.433025558613 | (37.7371564911538, -122.433025558613) | 2 | 7 | 5 | 63 | 7 | ||||
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 | |||
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 | |||||
5017 | 262484 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 10X Alpha St | 2 | Median : Yard | Tree | Private 2 | 3x3 | 6011300 | 2088596 | 37.7155239289484 | -122.402849469545 | (37.7155239289484, -122.402849469545) | 9 | 7 | 8 | 309 | 39 | ||||
5041 | 20311 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
5134 | 13416 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 442 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999568.3476194 | 2097073.0677048 | 37.7381379481581 | -122.444007926391 | (37.7381379481581, -122.444007926391) | 9 | 7 | 4 | 59 | 40 | |||
5205 | 261497 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1200X Portola Dr | 4 | Median : Yard | Tree | Private 2 | 10x10 | 5994638 | 2097987 | 37.7403648954334 | -122.46112071093 | (37.7403648954334, -122.46112071093) | 1 | 8 | 4 | 59 | 40 | ||||
5216 | 20045 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 STAIRWAY52 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
5276 | 9649 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 420X Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 5999128.38767 | 2111347.91542 | 37.7773080410323 | -122.446555809153 | (37.7773080410323, -122.446555809153) | 15 | 5 | 11 | 29492 | 16 | |||
5279 | 258778 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 701X Ortega Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x10 | 5991876 | 2102480 | 37.7525421857889 | -122.470997752755 | (37.7525421857889, -122.470997752755) | 1 | 8 | 4 | 29491 | 12 | ||||
5304 | 261473 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1000 Portola Dr | 3 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
5459 | 20942 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1992X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984875.9454268 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | 1 | 8 | 3 | 29491 | 35 | |||
5888 | 261561 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1801 25th St | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
5963 | 178185 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1540 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 6ft | 6007177.62531 | 2087487.59558 | 37.7122494380257 | -122.417019794631 | (37.7122494380257, -122.417019794631) | 9 | 7 | 8 | 309 | 39 |
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) );