trees
208 rows where qLegalStatus_id = 5 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9006 | 112755 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2038 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 3x3 | 5989157.5 | 2111303.8 | 37.7766123371313 | -122.481044705999 | (37.7766123371313, -122.481044705999) | 11 | 6 | 2 | 55 | 26 | |||
10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
10365 | 256095 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | ||||
11543 | 110044 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 550 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2015 12:00:00 AM | 3 | 3x3 | 5985672.92923 | 2112141.09949 | 37.7787081437008 | -122.493160374959 | (37.7787081437008, -122.493160374959) | 11 | 6 | 2 | 55 | 26 | ||
13918 | 112756 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 590x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 3x3 | 5989085.68012 | 2111584.93801 | 37.7773800886213 | -122.481313741677 | (37.7773800886213, -122.481313741677) | 11 | 6 | 2 | 55 | 26 | |||
14180 | 256094 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777292 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | |
7043 | 112197 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2570 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2015 12:00:00 AM | 3 | 3x3 | 6001886.22681 | 2116705.46829 | 37.7921756543416 | -122.437399303646 | (37.7921756543416, -122.437399303646) | 13 | 6 | 1 | 29490 | 27 | ||
14057 | 107967 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 2405x Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770079 | 6001240.68928 | 2116684.58018 | 37.7920815807513 | -122.439631370586 | (37.7920815807513, -122.439631370586) | 13 | 6 | 1 | 29490 | 27 | |
14464 | 44040 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.74454 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | 13 | 6 | 1 | 29490 | 27 | ||
18226 | 98437 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1840 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2012 12:00:00 AM | 4 | 4x12 | Permit Number 768068 | 6005870.33263 | 2116931.58044 | 37.7930221942694 | -122.423630300016 | (37.7930221942694, -122.423630300016) | 13 | 9 | 1 | 28858 | 27 | |
2107 | 113082 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 414 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6010030.65327 | 2092539.3572 | 37.7262806120542 | -122.407514778095 | (37.7262806120542, -122.407514778095) | 10 | 3 | 7 | 309 | 28 | ||
4750 | 113090 | Section 806 (d) 5 | Pyrus calleryana :: Ornamental Pear 44 | 1213 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6008675.52728 | 2094042.60872 | 37.7303322746045 | -122.41230559973 | (37.7303322746045, -122.41230559973) | 9 | 3 | 7 | 309 | 28 | ||
1757 | 261740 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
2679 | 261736 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 540 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
3337 | 261748 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
3374 | 261742 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
3836 | 261734 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 540 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
4604 | 261733 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 540 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
5719 | 108450 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6014379.30863 | 2103997.39375 | 37.7579844490278 | -122.393283028308 | (37.7579844490278, -122.393283028308) | 10 | 3 | 8 | 28856 | 29 | |||
5885 | 261744 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
7112 | 261737 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 540 De Haro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
7842 | 108451 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014380.97285 | 2103975.72487 | 37.7579250434155 | -122.393275756387 | (37.7579250434155, -122.393275756387) | 10 | 3 | 8 | 28856 | 29 | |||
8951 | 108447 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014378.0974 | 2104018.35584 | 37.7580419391129 | -122.393288684138 | (37.7580419391129, -122.393288684138) | 10 | 3 | 8 | 28856 | 29 | |||
9940 | 261738 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 540 De Haro St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
10248 | 108452 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014381.40925 | 2103952.18314 | 37.757860427147 | -122.393272599772 | (37.757860427147, -122.393272599772) | 10 | 3 | 8 | 28856 | 29 | |||
11461 | 261747 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
12766 | 261739 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
14638 | 261745 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
14658 | 261743 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
14750 | 108453 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6014383.1993 | 2103935.66602 | 37.7578151741454 | -122.393265253191 | (37.7578151741454, -122.393265253191) | 10 | 3 | 8 | 28856 | 29 | |||
15024 | 261746 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
16452 | 261741 | Section 806 (d) 5 | Geijera parviflora :: Australian Willow 25 | 540 De Haro St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
17602 | 261735 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 540 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
18648 | 108454 | Section 806 (d) 5 | Acer x freemanii :: Freeman Maple 276 | 696 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014383.50929 | 2103916.35065 | 37.757762155526 | -122.393262829511 | (37.757762155526, -122.393262829511) | 10 | 3 | 8 | 28856 | 29 | |||
194328 | 258403 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2019 12:00:00 AM | 3 | 3x5 | 6011869 | 2103486 | 37.7564404909426 | -122.401928842587 | (37.7564404909426, -122.401928842587) | 10 | 3 | 8 | 28856 | 29 | ||
38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
2593 | 19154 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 64 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774356 | 6003450.27402 | 2107953.58185 | 37.7682339504649 | -122.431362651168 | (37.7682339504649, -122.431362651168) | 15 | 9 | 5 | 28862 | 3 | |
3076 | 228280 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
3160 | 228282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
3306 | 228286 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
5528 | 167133 | Section 806 (d) 5 | Melaleuca quinquenervia :: Cajeput 10 | 4564 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2019 12:00:00 AM | 3 | 3x5 | Permit Number 785333 | 6000784.60188 | 2104670.73247 | 37.7590686222364 | -122.440347461192 | (37.7590686222364, -122.440347461192) | 2 | 4 | 5 | 28862 | 3 | |
6383 | 228279 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
7100 | 228281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
7765 | 263633 | Section 806 (d) 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 160 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782824 | 6000235.49843 | 2104901.88273 | 37.7596720242526 | -122.442263109517 | (37.7596720242526, -122.442263109517) | 2 | 4 | 5 | 28862 | 3 | |
8602 | 228283 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
10725 | 228284 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
10740 | 228285 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
16057 | 167157 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 368 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782616 | 6001774.58914 | 2103700.91584 | 37.7564620577863 | -122.436854194887 | (37.7564620577863, -122.436854194887) | 2 | 4 | 5 | 28862 | 3 | |
6642 | 114245 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 54 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5996571 | 2114184 | 37.7849487713586 | -122.455607632252 | (37.7849487713586, -122.455607632252) | 11 | 6 | 1 | 54 | 31 | |||
1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
5830 | 98280 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 2 | Permit Number 58649 | 6008148.55904 | 2110896.00071 | 37.776578287595 | -122.415320022909 | (37.776578287595, -122.415320022909) | 8 | 2 | 9 | 28853 | 34 | ||
7728 | 116230 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 49 Grace St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2014 12:00:00 AM | 3 | 2.5x4 | Permit Number 770598 | 6008318.16403 | 2110322.45497 | 37.7750129977898 | -122.414692709823 | (37.7750129977898, -122.414692709823) | 8 | 2 | 9 | 28853 | 34 | |
8996 | 98282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008179.30272 | 2110863.50432 | 37.7764907880679 | -122.415211370411 | (37.7764907880679, -122.415211370411) | 8 | 2 | 9 | 28853 | 34 | ||
14850 | 98281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008165.69574 | 2110879.12634 | 37.7765329177037 | -122.415259547114 | (37.7765329177037, -122.415259547114) | 8 | 2 | 9 | 28853 | 34 | ||
2057 | 111315 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
3241 | 31650 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3632 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2015 12:00:00 AM | 3 | Permit Number 35160 | 5981711.46236471 | 2097421.70961548 | 37.7380604052223 | -122.505772893936 | (37.7380604052223, -122.505772893936) | 1 | 8 | 3 | 29491 | 35 | ||
4564 | 264686 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2455 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782284 | 5990129.23032 | 2098669.31502 | 37.7419778589065 | -122.476759924113 | (37.7419778589065, -122.476759924113) | 1 | 8 | 3 | 29491 | 35 | |
6557 | 264929 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 4725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784398 | 5981118.81181 | 2106198.14775 | 37.7621231273763 | -122.508473270866 | (37.7621231273763, -122.508473270866) | 1 | 8 | 3 | 56 | 35 | |
7146 | 112795 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.7637354441658 | -122.499848016409 | (37.7637354441658, -122.499848016409) | 1 | 8 | 3 | 56 | 35 | |||
7524 | 111636 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2625 35TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2015 12:00:00 AM | 3 | 3x3 | 5985486 | 2097347 | 37.7380767082098 | -122.492717127165 | (37.7380767082098, -122.492717127165) | 1 | 8 | 3 | 29491 | 35 | ||
7739 | 262320 | Section 806 (d) 5 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2567 31st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/07/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785009 | 5986744.29234 | 2097795.22153 | 37.7393809030196 | -122.48839957369 | (37.7393809030196, -122.48839957369) | 1 | 8 | 3 | 29491 | 35 | |
8728 | 96402 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2160 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2011 12:00:00 AM | 1 | 2x3 | 5985141.5215 | 2100472.7854 | 37.7466391224256 | -122.494138462065 | (37.7466391224256, -122.494138462065) | 1 | 8 | 3 | 29491 | 35 | ||
8961 | 260880 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
9406 | 111316 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
9833 | 262515 | Section 806 (d) 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1951 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 779100 | 5985670.12137 | 2101944.25665 | 37.7507102998335 | -122.49241898675 | (37.7507102998335, -122.49241898675) | 1 | 8 | 3 | 29491 | 35 | |
11539 | 262395 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2755 40th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784406 | 5983997.14788 | 2096421.7593 | 37.7354490751144 | -122.497796450434 | (37.7354490751144, -122.497796450434) | 1 | 8 | 3 | 29491 | 35 | |
12144 | 111632 | Section 806 (d) 5 | Tree(s) :: 17 | 1758 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 774682 | 5985071 | 2103231.6 | 37.7542099449347 | -122.49458566251 | (37.7542099449347, -122.49458566251) | 1 | 8 | 3 | 56 | 35 | ||
14443 | 260878 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
16827 | 111314 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
16964 | 264738 | Section 806 (d) 5 | Prunus cerasifera :: Cherry Plum 7 | 2722 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/29/2020 12:00:00 AM | 3 | 3x6 | Permit Number 781841 | 5983409.1923 | 2096639.50516 | 37.7360124610612 | -122.499845290879 | (37.7360124610612, -122.499845290879) | 1 | 8 | 3 | 29491 | 35 | |
17482 | 111313 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
18095 | 260879 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
18205 | 262139 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 1582 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782766 | 5981929 | 2104333 | 37.7570496794991 | -122.505532928251 | (37.7570496794991, -122.505532928251) | 1 | 8 | 3 | 56 | 35 | |
194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194349 | 265045 | Section 806 (d) 5 | Tree(s) :: 17 | 1250 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194351 | 265046 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
3533 | 263634 | Section 806 (d) 5 | Tree(s) :: 17 | 211 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 3x3 | 6008194.27066 | 2088426.33179 | 37.71488415001 | -122.413572307092 | (37.71488415001, -122.413572307092) | 9 | 7 | 8 | 309 | 39 | ||
16264 | 111321 | Section 806 (d) 5 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6010185.88551 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | 9 | 7 | 8 | 309 | 39 | ||||
881 | 254388 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
6545 | 254389 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
17 | 164866 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 719 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782492 | 5994853.78052 | 2092811.30491 | 37.7261661184654 | -122.459999785581 | (37.7261661184654, -122.459999785581) | 9 | 7 | 4 | 28861 | 40 | |
5386 | 262533 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
6755 | 264922 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
7830 | 262278 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
8745 | 262534 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
9135 | 262279 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
13211 | 262230 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 42 Dorantes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782723 | 5994180.46761 | 2100058.80006 | 37.7460271985036 | -122.462852932256 | (37.7460271985036, -122.462852932256) | 1 | 8 | 4 | 29491 | 40 | |
15035 | 164228 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991043.64805 | 2099007.36638 | 37.7429590601275 | -122.473622846338 | (37.7429590601275, -122.473622846338) | 1 | 8 | 4 | 29491 | 40 | |
15653 | 164229 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991045.42225 | 2098958.21862 | 37.7428242157788 | -122.47361312736 | (37.7428242157788, -122.47361312736) | 1 | 8 | 4 | 29491 | 40 | |
15881 | 264923 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
16663 | 262231 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 42 Dorantes Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782723 | 5994180.46761 | 2100058.80006 | 37.7460271985036 | -122.462852932256 | (37.7460271985036, -122.462852932256) | 1 | 8 | 4 | 29491 | 40 | |
18260 | 164230 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
194410 | 265060 | Section 806 (d) 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 48 Miraloma Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/28/2020 12:00:00 AM | 3 | 6x6 | Permit Number 782253 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | |
194417 | 265061 | Section 806 (d) 5 | Prunus serrulata :: Ornamental Cherry 84 | 48 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | ||||
3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
16128 | 103468 | Section 806 (d) 5 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 799X Battery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6012421.85953 | 2118740.3114 | 37.7983561695566 | -122.401088663417 | (37.7983561695566, -122.401088663417) | 3 | 1 | 10 | 28860 | 6 | ||||
194334 | 265023 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
194335 | 265024 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 |
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) );