trees

8,298 rows where qLegalStatus_id = 4 sorted by TreeID descending

✎ View and edit SQL

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)
22722 99750 Undocumented 4 Tree(s) :: 17 4210 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2           6002521.3 2100652.6 37.7481345176555 -122.434053910222 (37.7481345176555, -122.434053910222) 2 4 5 28862 22
33345 99749 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 4216 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3 Looks like it was planted at same time with permit to plant tree no. 1 6002493 2100648 37.7481202809952 -122.434151441743 (37.7481202809952, -122.434151441743) 2 4 5 28862 22
307 99748 Undocumented 4 Tree(s) :: 17 4224 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002441 2100645 37.7481090922721 -122.434331041256 (37.7481090922721, -122.434331041256) 2 4 5 28862 22
27836 99747 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 4250 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002274 2100636 37.7480748999105 -122.434907877013 (37.7480748999105, -122.434907877013) 2 4 5 28862 22
14524 99746 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 4250 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
14494 99745 Undocumented 4 Maytenus boaria :: Mayten 58 4295X 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 1201 Diamond St is true address 6002005.5 2100584.2 37.7479174208607 -122.435832632906 (37.7479174208607, -122.435832632906) 2 4 5 63 22
8683 99744 Undocumented 4 Maytenus boaria :: Mayten 58 431 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Probably planted at same time as tree no. 1 w/same permit. CB 6002387 2100900 37.7488061968535 -122.43453600134 (37.7488061968535, -122.43453600134) 2 4 5 28862 22
127413 99743 Undocumented 4 Tree(s) :: 17 447 Clipper St   Sidewalk: Curb side : Cutout Tree Private 2           6002285 2100894 37.7487839315189 -122.43488828753 (37.7487839315189, -122.43488828753) 2 4 5 28862 22
33210 99742 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 511 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001875 2100872 37.7487002375378 -122.436304489265 (37.7487002375378, -122.436304489265) 2 4 5 28862 22
54263 99731 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991009.5 2094863.7 37.7315796303384 -122.473438749026 (37.7315796303384, -122.473438749026) 1 8 4 64 40
164901 99730 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2601 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991009.5 2094863.7 37.7315796303384 -122.473438749026 (37.7315796303384, -122.473438749026) 1 8 4 64 40
32853 99729 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2645 Ocean Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990840.1 2094977 37.7318809123737 -122.474032655501 (37.7318809123737, -122.474032655501) 1 8 4 64 40
76825 99728 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2645 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990840.1 2094977 37.7318809123737 -122.474032655501 (37.7318809123737, -122.474032655501) 1 8 4 64 40
127519 99727 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2645 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990840.1 2094977 37.7318809123737 -122.474032655501 (37.7318809123737, -122.474032655501) 1 8 4 64 40
73246 99725 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
118753 99724 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
166587 99723 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
97677 99722 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
158224 99721 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1195X Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 17x15   6007168.5 2119816.6 37.8010169271687 -122.419343316605 (37.8010169271687, -122.419343316605) 5 1 1 28858 32
133335 99718 Undocumented 4 Ficus nitida :: Laurel Fig 53 430 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6005787 2111054 37.7768791059226 -122.423500585068 (37.7768791059226, -122.423500585068) 7 9 11 28852 10
59532 99705 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1543X Fillmore St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 6x6   6003133 2113608 37.7837415942563 -122.432864070472 (37.7837415942563, -122.432864070472) 13 9 11 29490 41
28959 99704 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1543X Fillmore St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 6x6   6003133 2113608 37.7837415942563 -122.432864070472 (37.7837415942563, -122.432864070472) 13 9 11 29490 41
99339 99703 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1543X Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 6x6   6003133 2113608 37.7837415942563 -122.432864070472 (37.7837415942563, -122.432864070472) 13 9 11 29490 41
175040 99701 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1543X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 6x6   6003133 2113608 37.7837415942563 -122.432864070472 (37.7837415942563, -122.432864070472) 13 9 11 29490 41
2343 99661 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1365 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2           5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
89801 99660 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1365 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2           5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
100305 99658 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1325 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629) 1 8 4 59 40
32576 99657 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1325 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629) 1 8 4 59 40
78831 99639 Undocumented 4 Ficus nitida :: Laurel Fig 53 2201 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006359 2118331 37.7968922206311 -122.422038941111 (37.7968922206311, -122.422038941111) 13 9 10 28858 32
153320 99638 Undocumented 4 Ficus nitida :: Laurel Fig 53 2201 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6006359 2118331 37.7968922206311 -122.422038941111 (37.7968922206311, -122.422038941111) 13 9 10 28858 32
158011 99628 Undocumented 4 Myoporum laetum :: Myoporum 62 1856 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005263.1 2117519.3 37.7946016288287 -122.425773211932 (37.7946016288287, -122.425773211932) 13 9 1 28858 27
182401 99616 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
67334 99615 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
188786 99614 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
176842 99613 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
99582 99612 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
66269 99611 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1 Entrada Ct 3 Sidewalk: Property side : Yard Tree Private 2           5992743 2092489 37.7251595224946 -122.467273147781 (37.7251595224946, -122.467273147781) 9 8 4 59 40
56391 99609 Undocumented 4 Aesculus californica :: California Buckeye 168 1 Entrada Ct 2 Sidewalk: Property side : Yard Tree Private 2           5992743 2092489 37.7251595224946 -122.467273147781 (37.7251595224946, -122.467273147781) 9 8 4 59 40
122922 99595 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
19076 99594 Undocumented 4 Ficus nitida :: Laurel Fig 53 1855X Evans Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6014349.8 2099426.2 37.7454312840379 -122.393065244865 (37.7454312840379, -122.393065244865) 10 3 8 58 1
182004 99583 Undocumented 4 Shrub :: Shrub 66 650X Brunswick St 23 Sidewalk: Curb side : Cutout Tree Private 2     3 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
93883 99582 Undocumented 4 Tree(s) :: 17 650X Brunswick St 22 Sidewalk: Curb side : Cutout Tree Private 2     10 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
111010 99581 Undocumented 4 Tree(s) :: 17 650X Brunswick St 21 Sidewalk: Curb side : Cutout Tree Private 2     10 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
36617 99580 Undocumented 4 Cordyline australis :: Dracena Palm 64 650X Brunswick St 20 Sidewalk: Property side : Cutout Tree Private 2     10 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
99288 99579 Undocumented 4 Tree(s) :: 17 650X Brunswick St 19 Sidewalk: Curb side : Cutout Tree Private 2     4 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
185260 99578 Undocumented 4 Tree(s) :: 17 650X Brunswick St 18 Sidewalk: Curb side : Cutout Tree Private 2     4 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
97231 99575 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 650X Brunswick St 17 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
2991 99574 Undocumented 4 Tree(s) :: 17 650X Brunswick St 16 Sidewalk: Curb side : Cutout Tree Private 2     4 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
84268 99573 Undocumented 4 Myoporum laetum :: Myoporum 62 650X Brunswick St 15 Sidewalk: Curb side : Cutout Tree Private 2     14 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
28026 99572 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 650X Brunswick St 14 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
36173 99571 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 650X Brunswick St 13 Sidewalk: Curb side : Cutout Tree Private 2     5 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
41703 99570 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 650X Brunswick St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
139161 99569 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 650X Brunswick St 11 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
65669 99568 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 650X Brunswick St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
108209 99567 Undocumented 4 Tree(s) :: 17 650X Brunswick St 9 Sidewalk: Curb side : Cutout Tree Private 2     4 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
181618 99566 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 650X Brunswick St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
188587 99565 Undocumented 4 Myoporum laetum :: Myoporum 62 650X Brunswick St 7 Sidewalk: Curb side : Cutout Tree Private 2     14 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
146726 99563 Undocumented 4 Myoporum laetum :: Myoporum 62 650X Brunswick St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
80187 99562 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 650X Brunswick St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
189249 99561 Undocumented 4 Eucalyptus macarthuri :: Camden Wollybutt 516 418 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2           6002462 2100938 37.748914793117 -122.434279368207 (37.748914793117, -122.434279368207) 2 4 5 28862 22
91868 99559 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1142 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6011567 2119203 37.7995788748768 -122.404079333017 (37.7995788748768, -122.404079333017) 3 1 10 308 23
115506 99545 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1345 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6016251.7 2093118.1 37.7282159817318 -122.386049062135 (37.7282159817318, -122.386049062135) 10 3 8 58 1
35685 99537 Undocumented 4 Agonis flexuosa :: Peppermint Willow 65 3720 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2012 12:00:00 AM   3x3 Permit Number 768635 6004924.7 2102557.1 37.7534999396673 -122.425878575683 (37.7534999396673, -122.425878575683) 2 4 5 28862 22
30009 99508 Undocumented 4 Aesculus x carnea :: Red Horse Chestnut 267 2828 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000030 2117468 37.7941636633745 -122.443876667305 (37.7941636633745, -122.443876667305) 13 9 1 57 27
112027 99507 Undocumented 4 Aesculus x carnea :: Red Horse Chestnut 267 2828 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000030 2117468 37.7941636633745 -122.443876667305 (37.7941636633745, -122.443876667305) 13 9 1 57 27
161837 99506 Undocumented 4 Aesculus x carnea :: Red Horse Chestnut 267 2828 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000030 2117468 37.7941636633745 -122.443876667305 (37.7941636633745, -122.443876667305) 13 9 1 57 27
187142 99505 Undocumented 4 Aesculus x carnea :: Red Horse Chestnut 267 2828 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000030 2117468 37.7941636633745 -122.443876667305 (37.7941636633745, -122.443876667305) 13 9 1 57 27
31197 99493 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 800X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565) 9 7 4 28861 40
171542 99492 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 800X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565) 9 7 4 28861 40
89622 99489 Undocumented 4 Pinus halepensis :: Allepo Pine 330 800X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565) 9 7 4 28861 40
74864 99487 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 700X Miramar Ave 4 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
142912 99486 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 700X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
1111 99485 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 700X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
161162 99484 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 700X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
32678 99483 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 700X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
106199 99481 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 650X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
109435 99480 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 650X Miramar Ave 8 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
41393 99479 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 650X Miramar Ave 7 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
111527 99477 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 650X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
101918 99474 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 650X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
49979 99473 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 600X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
139390 99472 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 600X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
100131 99470 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600X Miramar Ave 8 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
82305 99469 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600X Miramar Ave 6 Median : Cutout Tree Private 2     4 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
13816 99468 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600X Miramar Ave 4 Median : Cutout Tree Private 2     6 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
173522 99467 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600X Miramar Ave 3 Median : Cutout Tree Private 2     6 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
78448 99466 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
162431 99465 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 550X Miramar Ave 4 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
47231 99464 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 550X Miramar Ave 9 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
67361 99463 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 550X Miramar Ave 6 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
132340 99462 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 550X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
179086 99461 Undocumented 4 Pinus halepensis :: Allepo Pine 330 550X Miramar Ave 8 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
33425 99460 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 7 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
188497 99458 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
161917 99457 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 550X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
193394 99455 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 400X Miramar Ave 5 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
8149 99454 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 400X Miramar Ave 4 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
155211 99453 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 400X Miramar Ave 3 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
60005 99452 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 400X Miramar Ave 2 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
36279 99451 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 400X Miramar Ave 1 Median : Cutout Tree Private 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40

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