194,517 rows sorted by qSiteInfo descending

View and edit SQL

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)
207 251656 DPW Maintained 1 Tree(s) :: 17 31x Malta Dr 1 unknown : Yard Tree Private 2       3x3   5999423 2096089 37.7354276387403 -122.44443976141 (37.7354276387403, -122.44443976141) 9 7 4 63 40
295 200164 DPW Maintained 1 :: 45 1027 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555) 10 3 8 58 1
987 186502 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 30 unknown : Yard Tree Private 2     5 Width 0ft   5980892.5842 2105334.0684 37.7597372788194 -122.509191521679 (37.7597372788194, -122.509191521679) 1 8 3 56 35
1202 254563 DPW Maintained 1 Pinus Spp :: Pine Spp 100 98x High St 1 unknown : Yard Tree DPW 1       3x3   5999731 2100707 37.748125134697 -122.443706547761 (37.748125134697, -122.443706547761) 2 4 5 63 22
1399 185502 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2400 Sunset Blvd 56 unknown : Yard Tree Private 2     8 Width 0ft   5985117.0889 2098738.1726 37.7418749156753 -122.494095121998 (37.7418749156753, -122.494095121998) 1 8 3 29491 35
2233 256484 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 177 1047 Hollister Ave 2 unknown : Yard Tree Private 2       Width 0ft   6014610.748 2089844.7127 37.7191369573176 -122.391493192738 (37.7191369573176, -122.391493192738) 10 3 8 58 1
2735 262549 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 923 Ingerson Ave 3 unknown : Yard Tree Private 2   08/20/2020 12:00:00 AM   Width 0ft   6014491.3602 2089577.767 37.7183973497527 -122.391887217647 (37.7183973497527, -122.391887217647) 10 3 8 58 1
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
5288 260453 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 4 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
5768 87061 Permitted Site 7 Eucalyptus Spp :: Eucalyptus 52     unknown : Yard Tree Private 2       3x3 Permit Number 50003                    
6379 186568 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501 Sunset Blvd 39 unknown : Yard Tree Private 2     2 Width 0ft   5984708.7013 2104680.5118 37.7581670432315 -122.495945443345 (37.7581670432315, -122.495945443345) 1 8 3 56 35
7863 260451 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 2 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
8110 200249 DPW Maintained 1 :: 45 1067 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6013803.2037 2090093.549 37.7197753570889 -122.394301997885 (37.7197753570889, -122.394301997885) 10 3 8 58 1
8305 86762 Permitted Site 7 Tree(s) :: 17 500 Brotherhood Way   unknown : Yard Tree Private 2   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
8587 260455 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 6 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
8775 186544 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501 Sunset Blvd 15 unknown : Yard Tree Private 2     1 Width 0ft   5984717.8085 2104869.8796 37.7586875278599 -122.495927916751 (37.7586875278599, -122.495927916751) 1 8 3 56 35
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
9415 200180 DPW Maintained 1 :: 45 1031 Hollister Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014690.5634 2089785.0188 37.7189774793874 -122.391213128817 (37.7189774793874, -122.391213128817) 10 3 8 58 1
9942 200177 DPW Maintained 1 :: 45 1041 Hollister Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014650.3204 2089811.8475 37.7190489123065 -122.39135410876 (37.7190489123065, -122.39135410876) 10 3 8 58 1
11749 200232 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 923 Ingerson Ave 1 unknown : Yard Tree Private 2   08/20/2020 12:00:00 AM 3 Width 0ft   6014491.3602 2089577.767 37.7183973497527 -122.391887217647 (37.7183973497527, -122.391887217647) 10 3 8 58 1
12451 200191 DPW Maintained 1 :: 45 981 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014255.2675 2089757.5194 37.7188778046353 -122.392715865878 (37.7188778046353, -122.392715865878) 10 3 8 58 1
12648 260457 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 8 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
12825 181360 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2400 Sunset Blvd 49 unknown : Yard Tree Private 2     47 Width 0ft   5985113.1047 2098629.2701 37.7415756656355 -122.494100873291 (37.7415756656355, -122.494100873291) 1 8 3 29491 35
13102 200235 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 923 Ingerson Ave 2 unknown : Yard Tree Private 2   08/20/2020 12:00:00 AM 0 Width 0ft   6014534.9569 2089547.5847 37.7183168953073 -122.39173441165 (37.7183168953073, -122.39173441165) 10 3 8 58 1
14544 105135 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 175X ESMERALDA AVE 1 unknown : Yard Tree DPW 1     26     6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
15799 186582 DPW Maintained 1 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 1501 Sunset Blvd 53 unknown : Yard Tree Private 2     6 Width 0ft   5984722.9379 2104579.1806 37.7578896497643 -122.495888732757 (37.7578896497643, -122.495888732757) 1 8 3 56 35
16690 260450 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 1 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
17811 185472 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2400 Sunset Blvd 24 unknown : Yard Tree Private 2     1 Width 0ft   5985147.6347 2098429.3943 37.7410288809669 -122.493966755049 (37.7410288809669, -122.493966755049) 1 8 3 29491 35
18816 185421 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2300 Sunset Blvd 37 unknown : Yard Tree Private 2     3 Width 0ft   5985094.1378 2099288.862 37.7433856170495 -122.494215058601 (37.7433856170495, -122.494215058601) 1 8 3 29491 35
19362 260454 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 5 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
19609 260452 Property Tree 8 Myoporum laetum :: Myoporum 62 3554 Alemany Blvd 3 unknown : Yard Tree Private 2       3x3   5993855 2087505 37.7115387848875 -122.463067653224 (37.7115387848875, -122.463067653224) 9 8 6 64 24
19971 186635 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 11 unknown : Yard Tree Private 2     4 Width 0ft   5980866.0152 2105705.863 37.7607565533288 -122.50931102062 (37.7607565533288, -122.50931102062) 1 8 3 56 35
21396 186498 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 18 unknown : Yard Tree Private 2     2 Width 0ft   5980888.4423 2105252.2669 37.7595124312164 -122.5091997715 (37.7595124312164, -122.5091997715) 1 8 3 56 35
21512 186501 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 29 unknown : Yard Tree Private 2     3 Width 0ft   5980893.6197 2105317.501 37.7596918505514 -122.509186710148 (37.7596918505514, -122.509186710148) 1 8 3 56 35
21600 105136 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 175X ESMERALDA AVE 2 unknown : Yard Tree DPW 1           6007213 2098808 37.7433348108676 -122.417699407763 (37.7433348108676, -122.417699407763) 2 7 7 28859 2
21617 186533 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501 Sunset Blvd 4 unknown : Yard Tree Private 2     2 Width 0ft   5984732.4639 2104901.2839 37.7587746136444 -122.495879549084 (37.7587746136444, -122.495879549084) 1 8 3 56 35
21649 185394 DPW Maintained 1 Podocarpus macrophyllus :: Yew Pine 137 2300 Sunset Blvd 4 unknown : Yard Tree Private 2     1 Width 0ft   5985078.642 2098945.9568 37.7424431852403 -122.494243368761 (37.7424431852403, -122.494243368761) 1 8 3 29491 35
21921 185481 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 34 unknown : Yard Tree Private 2     26 Width 0ft   5985135.018 2098495.7982 37.7412104699771 -122.494015271118 (37.7412104699771, -122.494015271118) 1 8 3 29491 35
22713 186516 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 2 unknown : Yard Tree Private 2     3 Width 0ft   5980905.2686 2104991.5894 37.7587976776767 -122.509122221366 (37.7587976776767, -122.509122221366) 1 8 3 56 35
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
24254 186636 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Lower Great Hwy 12 unknown : Yard Tree Private 2     3 Width 0ft   5980864.6099 2105729.0507 37.7608201372164 -122.509317602916 (37.7608201372164, -122.509317602916) 1 8 3 56 35
24467 186496 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 16 unknown : Yard Tree Private 2     2 Width 0ft   5980891.5487 2105237.2527 37.7594713896823 -122.509187913256 (37.7594713896823, -122.509187913256) 1 8 3 56 35
25674 185500 DPW Maintained 1 Juniperus chinensis :: Juniper 113 2400 Sunset Blvd 54 unknown : Yard Tree Private 2     6 Width 0ft   5985111.7766 2098706.9627 37.7417889108579 -122.494111190194 (37.7417889108579, -122.494111190194) 1 8 3 29491 35
26015 186626 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1300 Lower Great Hwy 2 unknown : Yard Tree Private 2     7 Width 0ft   5980879.19 2105650.5288 37.7606053983358 -122.509261346313 (37.7606053983358, -122.509261346313) 1 8 3 56 35
26072 185497 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2400 Sunset Blvd 51 unknown : Yard Tree Private 2     33 Width 0ft   5985111.7766 2098651.8474 37.7416375791026 -122.494107128969 (37.7416375791026, -122.494107128969) 1 8 3 29491 35
26178 181359 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 31 unknown : Yard Tree Private 2     22 Width 0ft   5985110.4485 2098473.2209 37.741147041149 -122.494098558838 (37.741147041149, -122.494098558838) 1 8 3 29491 35
26196 185484 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2400 Sunset Blvd 37 unknown : Yard Tree Private 2     2 Width 0ft   5985117.0889 2098499.1184 37.7412185372668 -122.494077507295 (37.7412185372668, -122.494077507295) 1 8 3 29491 35
26314 200498 DPW Maintained 1 :: 45 1055 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6013869.6047 2090039.2209 37.7196298737115 -122.394068670065 (37.7196298737115, -122.394068670065) 10 3 8 58 1
27177 101951 Property Tree 8 Tree(s) :: 17 21 Lyell St   unknown : Yard Tree Private 2           6003106 2094969 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292) 9 7 5 28861 25
28661 142738 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 333 BAY ST 3 unknown : Yard Tree Private 2     11 Width 0ft   6009098.7568 2121462.5595 37.805644845194 -122.412780209055 (37.805644845194, -122.412780209055) 3 1 10 308 23
28805 200245 DPW Maintained 1 :: 45 1075 Ingerson Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6013768.3263 2090118.3656 37.7198415597531 -122.394424294358 (37.7198415597531, -122.394424294358) 10 3 8 58 1
30476 185415 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 31 unknown : Yard Tree Private 2     16 Width 0ft   5985091.6384 2099216.8819 37.743187832897 -122.494218396427 (37.743187832897, -122.494218396427) 1 8 3 29491 35
32067 185505 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2400 Sunset Blvd 59 unknown : Yard Tree Private 2     19 Width 0ft   5985087.8712 2098781.9991 37.7419935417222 -122.494199375365 (37.7419935417222, -122.494199375365) 1 8 3 29491 35
33445 185494 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2400 Sunset Blvd 47 unknown : Yard Tree Private 2     25 Width 0ft   5985136.346 2098616.6534 37.7415423835049 -122.494019584309 (37.7415423835049, -122.494019584309) 1 8 3 29491 35
34911 185504 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2400 Sunset Blvd 58 unknown : Yard Tree Private 2     6 Width 0ft   5985115.0968 2098786.6474 37.7420078978362 -122.494105581845 (37.7420078978362, -122.494105581845) 1 8 3 29491 35
35872 200227 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1079 Ingerson Ave 1 unknown : Yard Tree Private 2     11 Width 0ft   6013668.3894 2090192.8153 37.7200404277679 -122.394774954905 (37.7200404277679, -122.394774954905) 10 3 8 58 1
36043 185476 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2400 Sunset Blvd 28 unknown : Yard Tree Private 2     2 Width 0ft   5985139.6662 2098449.3154 37.741083112699 -122.493995774621 (37.741083112699, -122.493995774621) 1 8 3 29491 35
37694 86761 Permitted Site 7 Arbutus unedo :: Strawberry Tree 106 500 Brotherhood Way   unknown : Yard Tree Private 2         Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
38006 186548 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 19 unknown : Yard Tree Private 2     11 Width 0ft   5984713.0979 2104804.2446 37.7585070365446 -122.49593936599 (37.7585070365446, -122.49593936599) 1 8 3 56 35
38575 185464 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 16 unknown : Yard Tree Private 2     46 Width 0ft   5985103.8081 2098378.9273 37.7408877477521 -122.494114570537 (37.7408877477521, -122.494114570537) 1 8 3 29491 35
38915 186491 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 21 unknown : Yard Tree Private 2     8 Width 0ft   5980895.1728 2105273.4939 37.759571111269 -122.509178070846 (37.759571111269, -122.509178070846) 1 8 3 56 35
39595 185474 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2400 Sunset Blvd 26 unknown : Yard Tree Private 2     27 Width 0ft   5985113.1047 2098438.0268 37.7410505630538 -122.494086781525 (37.7410505630538, -122.494086781525) 1 8 3 29491 35
39788 186497 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 17 unknown : Yard Tree Private 2     2 Width 0ft   5980894.6551 2105244.501 37.7594914745751 -122.509177708249 (37.7594914745751, -122.509177708249) 1 8 3 56 35
40118 142638 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 333 BAY ST 2 unknown : Yard Tree Private 2     8 Width 0ft   6009068.3546 2121458.9525 37.8056332348144 -122.412885165433 (37.8056332348144, -122.412885165433) 3 1 10 308 23
40373 186512 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400 Lower Great Hwy 13 unknown : Yard Tree Private 2     5 Width 0ft   5980899.8324 2105147.1675 37.7592245299801 -122.509152574968 (37.7592245299801, -122.509152574968) 1 8 3 56 35
41424 200250 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 917 Ingerson Ave 1 unknown : Yard Tree Private 2     5 Width 0ft   6014641.601 2089467.7692 37.7181036570096 -122.391360208379 (37.7181036570096, -122.391360208379) 10 3 8 58 1
41505 185426 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 42 unknown : Yard Tree Private 2     8 Width 0ft   5985086.6398 2099317.3541 37.7434634098799 -122.494243084048 (37.7434634098799, -122.494243084048) 1 8 3 29491 35
43178 185424 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2300 Sunset Blvd 40 unknown : Yard Tree Private 2     3 Width 0ft   5985084.6404 2099301.8584 37.7434207458763 -122.494248855446 (37.7434207458763, -122.494248855446) 1 8 3 29491 35
43382 186503 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 31 unknown : Yard Tree Private 2     4 Width 0ft   5980885.336 2105334.0684 37.7597368514834 -122.509216589167 (37.7597368514834, -122.509216589167) 1 8 3 56 35
44209 186506 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 6 unknown : Yard Tree Private 2     1 Width 0ft   5980906.3041 2105016.4405 37.7588659727132 -122.509120485578 (37.7588659727132, -122.509120485578) 1 8 3 56 35
44572 181354 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2300 Sunset Blvd 19 unknown : Yard Tree Private 2     25 Width 0ft   5985076.1427 2099074.9211 37.7427971401188 -122.494261514147 (37.7427971401188, -122.494261514147) 1 8 3 29491 35
45777 186843 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 33 unknown : Yard Tree Private 2     7 Width 0ft   5980882.2296 2105351.6713 37.7597850008387 -122.509228639712 (37.7597850008387, -122.509228639712) 1 8 3 56 35
45981 185462 DPW Maintained 1 Pinus Spp :: Pine Spp 100 2400 Sunset Blvd 13 unknown : Yard Tree Private 2     2 Width 0ft   5985138.3382 2098374.943 37.740878828405 -122.493994886454 (37.740878828405, -122.493994886454) 1 8 3 29491 35
46378 185499 DPW Maintained 1 Cedrus deodara :: Deodar Cedar 109 2400 Sunset Blvd 53 unknown : Yard Tree Private 2     1 Width 0ft   5985130.3697 2098685.0494 37.741729830799 -122.494045287668 (37.741729830799, -122.494045287668) 1 8 3 29491 35
47281 186628 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1300 Lower Great Hwy 4 unknown : Yard Tree Private 2     5 Width 0ft   5980874.0957 2105652.4611 37.760610403518 -122.509279108369 (37.760610403518, -122.509279108369) 1 8 3 56 35
47779 138264 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2600 GEARY BLVD 32 unknown : Yard Tree Private 2     1 Width 0ft   5999039.2359 2113177.9223 37.7823276740968 -122.446995936272 (37.7823276740968, -122.446995936272) 15 5 1 54 16
47826 186634 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1300 Lower Great Hwy 10 unknown : Yard Tree Private 2     2 Width 0ft   5980874.0957 2105690.7559 37.7607155500113 -122.509281952349 (37.7607155500113, -122.509281952349) 1 8 3 56 35
48446 185418 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2300 Sunset Blvd 34 unknown : Yard Tree Private 2     3 Width 0ft   5985092.1383 2099264.8686 37.7433196206545 -122.494220204145 (37.7433196206545, -122.494220204145) 1 8 3 29491 35
48827 185468 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2400 Sunset Blvd 20 unknown : Yard Tree Private 2     6 Width 0ft   5985131.0337 2098396.1923 37.7409367458634 -122.494021708019 (37.7409367458634, -122.494021708019) 1 8 3 29491 35
49179 86765 Permitted Site 7 Tree(s) :: 17 500 Brotherhood Way   unknown : Yard Tree Private 2   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
49684 138263 DPW Maintained 1 Myoporum laetum :: Myoporum 62 2600 GEARY BLVD 31 unknown : Yard Tree Private 2     17 Width 0ft   5999038.5591 2113167.7696 37.7822997587534 -122.446997546851 (37.7822997587534, -122.446997546851) 15 5 1 54 16
49732 186510 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400 Lower Great Hwy 11 unknown : Yard Tree Private 2     5 Width 0ft   5980902.4211 2105136.8129 37.7591962518414 -122.509142853237 (37.7591962518414, -122.509142853237) 1 8 3 56 35
49833 186558 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501 Sunset Blvd 29 unknown : Yard Tree Private 2     4 Width 0ft   5984755.5984 2104741.6454 37.7583376456641 -122.495787764797 (37.7583376456641, -122.495787764797) 1 8 3 56 35
50432 185406 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2300 Sunset Blvd 21 unknown : Yard Tree Private 2     15 Width 0ft   5985111.1331 2099102.9134 37.7428760469646 -122.494142591708 (37.7428760469646, -122.494142591708) 1 8 3 29491 35
50825 200155 DPW Maintained 1 :: 45 1091 Hollister Ave 1 unknown : Yard Tree Private 2     0 Width 0ft   6014363.9238 2090021.1115 37.7196076106807 -122.392358707449 (37.7196076106807, -122.392358707449) 10 3 8 58 1
50901 185402 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 2300 Sunset Blvd 16 unknown : Yard Tree Private 2     2 Width 0ft   5985125.6291 2099042.93 37.7427121969825 -122.494088049359 (37.7427121969825, -122.494088049359) 1 8 3 29491 35
50928 105667 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 301X DORADO TER 1 unknown : Yard Tree Private 2           5994306.4 2092922 37.7264385629619 -122.461900058607 (37.7264385629619, -122.461900058607) 9 8 4 28861 40
51838 186505 DPW Maintained 1 Cupressocyparis leylandii :: Leyland Cypress 185 1400 Lower Great Hwy 5 unknown : Yard Tree Private 2     2 Width 0ft   5980903.7154 2105004.5327 37.7588331246947 -122.509128554095 (37.7588331246947, -122.509128554095) 1 8 3 56 35
52493 185399 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2300 Sunset Blvd 12 unknown : Yard Tree Private 2     2 Width 0ft   5985110.1333 2099026.9344 37.7426673706481 -122.494140449924 (37.7426673706481, -122.494140449924) 1 8 3 29491 35
54336 186575 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 Sunset Blvd 46 unknown : Yard Tree Private 2     30 Width 0ft   5984766.4852 2104638.2207 37.7580543077882 -122.495742485113 (37.7580543077882, -122.495742485113) 1 8 3 56 35
54606 185398 DPW Maintained 1 Myoporum laetum :: Myoporum 62 2300 Sunset Blvd 11 unknown : Yard Tree Private 2     6 Width 0ft   5985116.1317 2099019.9363 37.7426485067542 -122.494119193821 (37.7426485067542, -122.494119193821) 1 8 3 29491 35
58275 86763 Permitted Site 7 Tree(s) :: 17 500 Brotherhood Way   unknown : Yard Tree Private 2   10/04/2007 12:00:00 AM     Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
58962 185390 DPW Maintained 1 Araucaria araucana :: Monkey puzzle 287 2300 Sunset Blvd 1 unknown : Yard Tree Private 2     2 Width 0ft   5985092.6382 2098924.4627 37.7423849872747 -122.4941933909 (37.7423849872747, -122.4941933909) 1 8 3 29491 35
60303 86768 Permitted Site 7 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 500 Brotherhood Way   unknown : Yard Tree Private 2         Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
60315 186488 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1400 Lower Great Hwy 34 unknown : Yard Tree Private 2     15 Width 0ft   5980888.4423 2105382.2174 37.7598692379346 -122.50920942184 (37.7598692379346, -122.50920942184) 1 8 3 56 35
60436 138256 DPW Maintained 1 Myoporum laetum :: Myoporum 62 2600 GEARY BLVD 1 unknown : Yard Tree Private 2     5 Width 0ft   5999357.6908 2113236.4692 37.7825066175753 -122.445898439469 (37.7825066175753, -122.445898439469) 15 5 1 54 16
60852 186535 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1501 Sunset Blvd 6 unknown : Yard Tree Private 2     2 Width 0ft   5984732.8826 2104894.5843 37.7587562429314 -122.495877606831 (37.7587562429314, -122.495877606831) 1 8 3 56 35
60913 186485 DPW Maintained 1 Myoporum laetum :: Myoporum 62 1400 Lower Great Hwy 25 unknown : Yard Tree Private 2     9 Width 0ft   5980894.6551 2105298.8627 37.7596407361809 -122.509181745183 (37.7596407361809, -122.509181745183) 1 8 3 56 35
60950 200230 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1079 Ingerson Ave 4 unknown : Yard Tree Private 2     9 Width 0ft   6013720.7054 2090151.9015 37.7199309952824 -122.394591251483 (37.7199309952824, -122.394591251483) 10 3 8 58 1
61239 186542 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501 Sunset Blvd 13 unknown : Yard Tree Private 2     1 Width 0ft   5984733.3013 2104876.5792 37.7587068304654 -122.495874830593 (37.7587068304654, -122.495874830593) 1 8 3 56 35

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);