Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146760 | 146760 | 186517 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 1400 Lower Great Hwy | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5980906.8218 | 2104997.2844 | 37.7588134060814 | -122.509117272676 | (37.7588134060814, -122.509117272676) | |||
157249 | 157249 | 200733 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1462 Oakdale Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 14 | Width 0ft | 6015790.512 | 2094948.0194 | 37.7332150397253 | -122.387771048105 | (37.7332150397253, -122.387771048105) | |||
185674 | 185674 | 185392 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 38 | Width 0ft | 5985108.1339 | 2098944.4572 | 37.7424407935289 | -122.494141285581 | (37.7424407935289, -122.494141285581) | |||
35616 | 35616 | 185394 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2300 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985078.642000001 | 2098945.9568 | 37.7424431852403 | -122.494243368761 | (37.7424431852403, -122.494243368761) | |||
62916 | 62916 | 186533 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.4639 | 2104901.2839 | 37.7587746136444 | -122.495879549084 | (37.7587746136444, -122.495879549084) | |||
66024 | 66024 | 87113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
76180 | 76180 | 185454 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985131.0337 | 2098272.681 | 37.7405976170701 | -122.494012607503 | (37.7405976170701, -122.494012607503) | |||
133309 | 133309 | 186628 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980874.0957 | 2105652.4611 | 37.760610403518 | -122.509279108369 | (37.760610403518, -122.509279108369) | |||
134829 | 134829 | 186518 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1400 Lower Great Hwy | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980903.7154 | 2105000.9085 | 37.758823173681606 | -122.50912828496901 | (37.7588231736816, -122.509128284969) | |||
139638 | 139638 | 105139 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 4 | unknown : Yard 19 | Tree 1 | DPW 2 | 25 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
143716 | 143716 | 105138 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 4 | unknown : Yard 19 | Tree 1 | DPW 2 | 25 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
183984 | 183984 | 200230 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1079 Ingerson Ave | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 6013720.7054 | 2090151.9015 | 37.7199309952824 | -122.394591251483 | (37.7199309952824, -122.394591251483) | |||
24212 | 24212 | 181351 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 32 | Width 0ft | 5985090.6387 | 2098949.4558 | 37.7424534945744 | -122.49420214621 | (37.7424534945744, -122.49420214621) | |||
30894 | 30894 | 200231 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1079 Ingerson Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 6013732.1076 | 2090145.865 | 37.719915054156296 | -122.39455141525299 | (37.7199150541563, -122.394551415253) | |||
44552 | 44552 | 185455 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2400 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985131.0337 | 2098285.2977 | 37.7406322591341 | -122.494013537118 | (37.7406322591341, -122.494013537118) | |||
48440 | 48440 | 186534 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984706.503 | 2104895.4217 | 37.758756997201 | -122.49596890002701 | (37.758756997201, -122.495968900027) | |||
141981 | 141981 | 87114 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
168385 | 168385 | 186505 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1400 Lower Great Hwy | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980903.7154 | 2105004.5327 | 37.7588331246947 | -122.509128554095 | (37.7588331246947, -122.509128554095) | |||
170571 | 170571 | 186629 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980862.5019 | 2105665.4602 | 37.7606454117292 | -122.50932017074 | (37.7606454117292, -122.50932017074) | |||
73687 | 73687 | 186630 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.7453 | 2105672.8381 | 37.7606655657469 | -122.50932679385099 | (37.7606655657469, -122.509326793851) | |||
132337 | 132337 | 186535 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.8826 | 2104894.5843 | 37.7587562429314 | -122.495877606831 | (37.7587562429314, -122.495877606831) | |||
143327 | 143327 | 87115 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
178803 | 178803 | 186506 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980906.3041 | 2105016.4405 | 37.7588659727132 | -122.50912048557801 | (37.7588659727132, -122.509120485578) | |||
183931 | 183931 | 185393 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | Width 0ft | 5985089.6389999995 | 2098965.9512 | 37.742498727988895 | -122.49420681837499 | (37.7424987279889, -122.494206818375) | |||
27191 | 27191 | 186631 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.0426 | 2105683.7293 | 37.7606954284135 | -122.50933003298901 | (37.7606954284135, -122.509330032989) | |||
53924 | 53924 | 185395 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2300 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985077.1425 | 2098975.4486 | 37.7425240740104 | -122.494250726815 | (37.7425240740104, -122.494250726815) | |||
66692 | 66692 | 185457 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 13 | Width 0ft | 5985129.0416 | 2098307.8751 | 37.740694134038 | -122.494022088477 | (37.740694134038, -122.494022088477) | |||
147019 | 147019 | 186536 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 23 | Width 0ft | 5984741.2571 | 2104889.1409 | 37.758741787333705 | -122.495848242848 | (37.7587417873337, -122.495848242848) | |||
182401 | 182401 | 186519 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980902.9388 | 2105057.6001 | 37.758978786758 | -122.509135180581 | (37.758978786758, -122.509135180581) | |||
41370 | 41370 | 186537 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 14 | Width 0ft | 5984743.3507 | 2104891.2345 | 37.7587476583889 | -122.49584115676501 | (37.7587476583889, -122.495841156765) | |||
68374 | 68374 | 185458 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | Width 0ft | 5985125.7214 | 2098330.4524 | 37.7407559309555 | -122.49403523184401 | (37.7407559309555, -122.494035231844) | |||
131767 | 131767 | 186507 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980898.797 | 2105106.7845 | 37.759113588816 | -122.509153157003 | (37.759113588816, -122.509153157003) | |||
155462 | 155462 | 186632 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980861.0966 | 2105687.2426 | 37.7607051370684 | -122.509326648666 | (37.7607051370684, -122.509326648666) | |||
181170 | 181170 | 185396 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5985088.1394 | 2098992.4439 | 37.742571382036 | -122.49421395573499 | (37.742571382036, -122.494213955735) | |||
39317 | 39317 | 186508 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980903.4565 | 2105112.4796 | 37.759129500629896 | -122.50913746543199 | (37.7591295006299, -122.509137465432) | |||
58500 | 58500 | 186538 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 29 | Width 0ft | 5984747.9566 | 2104882.4413 | 37.7587237844572 | -122.495824579043 | (37.7587237844572, -122.495824579043) | |||
174389 | 174389 | 186633 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | |||
180431 | 180431 | 185459 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 28 | Width 0ft | 5985114.4327 | 2098335.7647 | 37.7407698565631 | -122.494074654765 | (37.7407698565631, -122.494074654765) | |||
32088 | 32088 | 186539 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984748.3754 | 2104879.0915 | 37.7587146113666 | -122.49582288356001 | (37.7587146113666, -122.49582288356) | |||
50995 | 50995 | 186509 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980901.3856 | 2105130.6001 | 37.759179132228 | -122.509145973072 | (37.759179132228, -122.509145973072) | |||
52895 | 52895 | 186634 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980874.0957 | 2105690.7559 | 37.7607155500113 | -122.509281952349 | (37.7607155500113, -122.509281952349) | |||
53840 | 53840 | 185397 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985126.1289 | 2099011.9385 | 37.742627131937 | -122.49408403757799 | (37.742627131937, -122.494084037578) | |||
55634 | 55634 | 185460 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985122.4012 | 2098351.0376 | 37.7408122581003 | -122.49404822844801 | (37.7408122581003, -122.494048228448) | |||
26814 | 26814 | 185398 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985116.1317 | 2099019.9363 | 37.7426485067542 | -122.49411919382099 | (37.7426485067542, -122.494119193821) | |||
34689 | 34689 | 186540 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984760.5184 | 2104876.1604 | 37.7587072745291 | -122.49578067192199 | (37.7587072745291, -122.495780671922) | |||
66913 | 66913 | 186510 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.759196251841395 | -122.509142853237 | (37.7591962518414, -122.509142853237) | |||
158735 | 158735 | 186635 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980866.0152 | 2105705.863 | 37.7607565533288 | -122.50931102062 | (37.7607565533288, -122.50931102062) | |||
161360 | 161360 | 185461 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985111.1125 | 2098351.0376 | 37.7408115975576 | -122.494087259969 | (37.7408115975576, -122.494087259969) | |||
150157 | 150157 | 186541 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5984745.863 | 2104876.5792 | 37.7587075661518 | -122.49583138713601 | (37.7587075661518, -122.495831387136) | |||
155117 | 155117 | 186636 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980864.6099 | 2105729.0507 | 37.7608201372164 | -122.509317602916 | (37.7608201372164, -122.509317602916) | |||
159653 | 159653 | 185399 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985110.1333 | 2099026.9344 | 37.7426673706481 | -122.49414044992399 | (37.7426673706481, -122.494140449924) | |||
174165 | 174165 | 186511 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980895.6906 | 2105140.9548 | 37.7592072275053 | -122.509166437696 | (37.7592072275053, -122.509166437696) | |||
182857 | 182857 | 181357 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985137.6741 | 2098360.3342 | 37.740838677714294 | -122.49399610623999 | (37.7408386777143, -122.49399610624) | |||
48044 | 48044 | 186542 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984733.3013 | 2104876.5792 | 37.7587068304654 | -122.495874830593 | (37.7587068304654, -122.495874830593) | |||
149629 | 149629 | 181352 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985091.6384 | 2099018.9366 | 37.7426443285892 | -122.494203809651 | (37.7426443285892, -122.494203809651) | |||
182655 | 182655 | 186512 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | |||
183371 | 183371 | 185462 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2400 Sunset Blvd | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985138.3382 | 2098374.943 | 37.740878828405 | -122.49399488645399 | (37.740878828405, -122.493994886454) | |||
29234 | 29234 | 186513 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980894.1374 | 2105147.1675 | 37.759224194224 | -122.509172270667 | (37.759224194224, -122.509172270667) | |||
64302 | 64302 | 181358 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5985132.3618 | 2098384.2396 | 37.7409040046765 | -122.49401623531 | (37.7409040046765, -122.49401623531) | |||
76866 | 76866 | 185401 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985086.14 | 2099023.9352 | 37.74265773164 | -122.494223189599 | (37.74265773164, -122.494223189599) | |||
172365 | 172365 | 186543 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 21 | Width 0ft | 5984724.0894 | 2104873.2294 | 37.7586970933352 | -122.495906441969 | (37.7586970933352, -122.495906441969) | |||
27012 | 27012 | 186514 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980897.7615 | 2105153.3803 | 37.759241466452295 | -122.509160198369 | (37.7592414664523, -122.509160198369) | |||
59949 | 59949 | 186544 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984717.8085 | 2104869.8796 | 37.7586875278599 | -122.495927916751 | (37.7586875278599, -122.495927916751) | |||
60510 | 60510 | 181353 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 34 | Width 0ft | 5985103.1353 | 2099041.4304 | 37.7427067632535 | -122.49416571483 | (37.7427067632535, -122.49416571483) | |||
185290 | 185290 | 185463 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985112.4406 | 2098384.9036 | 37.740904662190104 | -122.494085163354 | (37.7409046621901, -122.494085163354) | |||
46197 | 46197 | 186496 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980891.5487 | 2105237.2527 | 37.7594713896823 | -122.509187913256 | (37.7594713896823, -122.509187913256) | |||
152435 | 152435 | 185402 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985125.6291 | 2099042.93 | 37.742712196982495 | -122.494088049359 | (37.7427121969825, -122.494088049359) | |||
182172 | 182172 | 185464 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 46 | Width 0ft | 5985103.8081 | 2098378.9273 | 37.740887747752105 | -122.494114570537 | (37.7408877477521, -122.494114570537) | |||
23747 | 23747 | 186497 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980894.6551 | 2105244.501 | 37.7594914745751 | -122.509177708249 | (37.7594914745751, -122.509177708249) | |||
27414 | 27414 | 186546 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984749.2128 | 2104853.9681 | 37.758645678551105 | -122.495818134238 | (37.7586456785511, -122.495818134238) | |||
131257 | 131257 | 185403 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985110.6332 | 2099073.9214 | 37.742796413512 | -122.49414218382499 | (37.742796413512, -122.494142183825) | |||
69350 | 69350 | 186498 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980888.4423 | 2105252.2669 | 37.7595124312164 | -122.5091997715 | (37.7595124312164, -122.5091997715) | |||
72947 | 72947 | 186547 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 49 | Width 0ft | 5984724.5081 | 2104844.7562 | 37.7586189383832 | -122.495902893491 | (37.7586189383832, -122.495902893491) | |||
159555 | 159555 | 185466 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985111.7766 | 2098394.8642 | 37.740931972462796 | -122.494088193127 | (37.7409319724628, -122.494088193127) | |||
167557 | 167557 | 185404 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985080.6415 | 2099060.4251 | 37.7427576012847 | -122.494244890555 | (37.7427576012847, -122.494244890555) | |||
49038 | 49038 | 186494 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.3005 | 2105262.6215 | 37.7595406177816 | -122.50921486458799 | (37.7595406177816, -122.509214864588) | |||
166847 | 166847 | 185467 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985112.4406 | 2098402.8327 | 37.740953890671896 | -122.49408648444799 | (37.7409538906719, -122.494086484448) | |||
178149 | 178149 | 181354 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985076.1427 | 2099074.9211 | 37.742797140118796 | -122.494261514147 | (37.7427971401188, -122.494261514147) | |||
183109 | 183109 | 186548 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5984713.0979 | 2104804.2446 | 37.7585070365446 | -122.49593936599 | (37.7585070365446, -122.49593936599) | |||
38464 | 38464 | 185405 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 23 | Width 0ft | 5985107.634 | 2099090.4168 | 37.7428415299236 | -122.494153769583 | (37.7428415299236, -122.494153769583) | |||
61772 | 61772 | 185468 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985131.0337 | 2098396.1923 | 37.7409367458634 | -122.494021708019 | (37.7409367458634, -122.494021708019) | |||
65848 | 65848 | 186549 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5984751.8298 | 2104797.3357 | 37.7584903350171 | -122.495804906083 | (37.7584903350171, -122.495804906083) | |||
129570 | 129570 | 186495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980891.5487 | 2105262.6215 | 37.7595410451172 | -122.509189797166 | (37.7595410451172, -122.509189797166) | |||
58408 | 58408 | 186491 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5980895.1728 | 2105273.4939 | 37.759571111269004 | -122.509178070846 | (37.759571111269, -122.509178070846) | |||
136486 | 136486 | 186550 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 42 | Width 0ft | 5984736.7558 | 2104791.4736 | 37.7584733565115 | -122.49585660551 | (37.7584733565115, -122.49585660551) | |||
137933 | 137933 | 185406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5985111.1331 | 2099102.9134 | 37.742876046964604 | -122.494142591708 | (37.7428760469646, -122.494142591708) | |||
35633 | 35633 | 185470 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985119.081 | 2098414.7854 | 37.7409870981235 | -122.49406440544399 | (37.7409870981235, -122.494064405444) | |||
46337 | 46337 | 185407 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985075.6429 | 2099093.4159999997 | 37.742847892869 | -122.49426460522899 | (37.742847892869, -122.494264605229) | |||
58818 | 58818 | 186492 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980885.336 | 2105278.6712 | 37.759584746696 | -122.509212475259 | (37.759584746696, -122.509212475259) | |||
30380 | 30380 | 186493 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.8182 | 2105286.9549 | 37.7596074608269 | -122.509214881201 | (37.7596074608269, -122.509214881201) | |||
64027 | 64027 | 186552 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984760.623 | 2104776.3995 | 37.758433365006105 | -122.49577295137699 | (37.7584333650061, -122.495772951377) | |||
67708 | 67708 | 185471 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985135.682 | 2098419.4337 | 37.7410008324731 | -122.494007348608 | (37.7410008324731, -122.494007348608) | |||
73057 | 73057 | 185408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5985102.6354 | 2099127.4066 | 37.742942801420796 | -122.49417377884599 | (37.7429428014208, -122.494173778846) | |||
70982 | 70982 | 185472 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2400 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985147.6347 | 2098429.3943 | 37.741028880966894 | -122.493966755049 | (37.7410288809669, -122.493966755049) | |||
148409 | 148409 | 186553 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5984733.406 | 2104758.3944 | 37.7583823340555 | -122.495865750271 | (37.7583823340555, -122.495865750271) | |||
149365 | 149365 | 185409 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2300 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985081.6412 | 2099150.9001 | 37.7430060796886 | -122.494248101225 | (37.7430060796886, -122.494248101225) | |||
157531 | 157531 | 186484 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980883.7828 | 2105293.6854 | 37.7596258798004 | -122.50921896188801 | (37.7596258798004, -122.509218961888) | |||
34066 | 34066 | 185473 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5985104.4721 | 2098432.7145 | 37.741035471775206 | -122.494116238038 | (37.7410354717752, -122.494116238038) | |||
52894 | 52894 | 186485 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5980894.6551 | 2105298.8627 | 37.7596407361809 | -122.50918174518299 | (37.7596407361809, -122.509181745183) | |||
170252 | 170252 | 185410 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2300 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985099.6362 | 2099155.3989 | 37.7430194852088 | -122.494186211855 | (37.7430194852088, -122.494186211855) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");