trees
215 rows where qLegalStatus_id = 9 sorted by Neighborhoods (old)
This data as json, CSV (advanced)
These facets timed out: Police Districts
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10049 | 261052 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Hooper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013012.2905 | 2108046.92839 | 37.769027533769 | -122.398294909078 | (37.769027533769, -122.398294909078) | 14 | 3 | 8 | 28856 | 20 | ||||
10235 | 191533 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016236.27796 | 2107216.03359 | 37.7669251365154 | -122.387085273085 | (37.7669251365154, -122.387085273085) | 14 | 3 | 9 | 310 | 20 | |||
10795 | 188785 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015978.05896 | 2106829.43815 | 37.7658493270204 | -122.38795143981 | (37.7658493270204, -122.38795143981) | 14 | 3 | 9 | 310 | 20 | |||
11397 | 191531 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016181.25153 | 2107212.70143 | 37.7669129399083 | -122.387275369984 | (37.7669129399083, -122.387275369984) | 14 | 3 | 9 | 310 | 20 | |||
13110 | 188782 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 6015982.12636 | 2106754.96915 | 37.7656450765832 | -122.387932174526 | (37.7656450765832, -122.387932174526) | 14 | 3 | 9 | 310 | 20 | |||
13982 | 189273 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015966.51086 | 2107036.5181 | 37.7664172839651 | -122.388005834417 | (37.7664172839651, -122.388005834417) | 14 | 3 | 9 | 310 | 20 | |||
14181 | 188787 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015968.04519 | 2106982.6549 | 37.7662694722874 | -122.387996768362 | (37.7662694722874, -122.387996768362) | 14 | 3 | 9 | 310 | 20 | |||
17556 | 75105 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015973.99843 | 2106904.23323 | 37.7660544731729 | -122.387970704195 | (37.7660544731729, -122.387970704195) | 14 | 3 | 9 | 310 | 20 | ||
17659 | 188786 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015977.25571 | 2106854.57611 | 37.7659183059205 | -122.387955972402 | (37.7659183059205, -122.387955972402) | 14 | 3 | 9 | 310 | 20 | |||
18111 | 191532 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016209.16515 | 2107214.5091 | 37.766919449199 | -122.38717894647 | (37.766919449199, -122.38717894647) | 14 | 3 | 9 | 310 | 20 | |||
18169 | 189274 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015965.43281 | 2107064.27168 | 37.7664934295578 | -122.388011500129 | (37.7664934295578, -122.388011500129) | 14 | 3 | 9 | 310 | 20 | |||
18958 | 191526 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015996.43331 | 2107204.26168 | 37.7668795291963 | -122.387914043316 | (37.7668795291963, -122.387914043316) | 14 | 3 | 9 | 310 | 20 | |||
19392 | 191529 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6016082.02245 | 2107209.57323 | 37.7668988547309 | -122.387618372283 | (37.7668988547309, -122.387618372283) | 14 | 3 | 9 | 310 | 20 | |||
137357 | 117353 | Private 9 | Pittosporum crassifolium :: Karo Tree 95 | 101X China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 772935 | 6015309.46376 | 2108739.72137 | 37.7710574836343 | -122.390397474374 | (37.7710574836343, -122.390397474374) | 14 | 3 | 9 | 310 | 20 | |||
33729 | 109829 | Private 9 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 629 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 775362 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||
893 | 226590 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784594 | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | 2 | 4 | 5 | 63 | 22 |
3984 | 243570 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 3 | 3x3 | Permit Number 784594 | 6001117.2647 | 2099653.19311 | 37.7453106011164 | -122.438837397829 | (37.7453106011164, -122.438837397829) | 2 | 4 | 5 | 63 | 22 | |
33896 | 104968 | Private 9 | Pinus halepensis :: Allepo Pine 330 | 495 COLLINGWOOD ST | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Permit Number 770776 | 6002186.6 | 2103026 | 37.7546323087418 | -122.435381040855 | (37.7546323087418, -122.435381040855) | 2 | 4 | 5 | 28862 | 22 | |||
83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
97720 | 104310 | Private 9 | Brachychiton populneus :: Bottle Tree 348 | 3747 23RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5x5 | 6004798 | 2102451 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | 2 | 4 | 5 | 28862 | 22 | |||
112431 | 104768 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 912 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6002431.1 | 2102873.8 | 37.7542282864134 | -122.434524613527 | (37.7542282864134, -122.434524613527) | 2 | 4 | 5 | 28862 | 22 | |||
122325 | 104309 | Private 9 | Myoporum laetum :: Myoporum 62 | 3747 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6004798 | 2102451 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | 2 | 4 | 5 | 28862 | 22 | ||||
165242 | 104317 | Private 9 | Pyrus calleryana :: Ornamental Pear 44 | 13011305 SANCHEZ ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003956 | 2100665 | 37.7482498839608 | -122.429093651106 | (37.7482498839608, -122.429093651106) | 2 | 4 | 5 | 63 | 22 | |||
186484 | 109125 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
20327 | 109501 | Private 9 | Ulmus americana :: American Elm 74 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard | Tree | Private 2 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.8021053817179 | -122.404424889694 | (37.8021053817179, -122.404424889694) | 3 | 1 | 10 | 308 | 23 | ||||
3361 | 261454 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
8479 | 204048 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
8858 | 261455 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
10378 | 163649 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 07/01/2020 12:00:00 AM | 3 | 3x4 | Permit Number 784460 | 5994737.04022 | 2087470.63166 | 37.71149518743 | -122.460016622663 | (37.71149518743, -122.460016622663) | 9 | 8 | 6 | 28861 | 24 |
11157 | 261456 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
12761 | 261857 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 176 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2020 12:00:00 AM | 3 | 5992988.80812 | 2088380.73889 | 37.7138934199028 | -122.466125014283 | (37.7138934199028, -122.466125014283) | 9 | 8 | 6 | 64 | 24 | |||
15121 | 261452 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
15415 | 261457 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
16566 | 261453 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
74288 | 105439 | Private 9 | Tree(s) :: 17 | 790 LAKEVIEW AVE | 1 | Front Yard : Yard | Tree | Private 2 | 5994224.8 | 2089960.8 | 37.7183031233486 | -122.461967505828 | (37.7183031233486, -122.461967505828) | 9 | 8 | 6 | 28861 | 24 | |||||
112528 | 104689 | Private 9 | Pinus radiata :: Monterey Pine 15 | 657 PALMETTO AVE | 1 | Back Yard : Yard | Tree | Private 2 | 30 | 5991786 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | 9 | 8 | 4 | 64 | 24 | ||||
119423 | 114977 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 183 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 774982 | 5996484.3 | 2091092.2 | 37.7215395068839 | -122.454239087603 | (37.7215395068839, -122.454239087603) | 9 | 8 | 6 | 28861 | 24 | |||
160381 | 256862 | Private 9 | Picea Spp :: Spruce Spp 200 | 133 Majestic Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5997017.00624 | 2089223.65081 | 37.7164394409514 | -122.452262915882 | (37.7164394409514, -122.452262915882) | 9 | 8 | 6 | 28861 | 24 | |||||
11394 | 260246 | Private 9 | Magnolia spp :: Magnolia 224 | 568 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784595 | 5998297.39121 | 2088148.96817 | 37.7135618752392 | -122.447759972312 | (37.7135618752392, -122.447759972312) | 9 | 7 | 6 | 28861 | 25 | |
60 | 264971 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 150 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | 5990555.23468 | 2114396.47455 | 37.7851851170506 | -122.476435559205 | (37.7851851170506, -122.476435559205) | 11 | 6 | 2 | 54 | 26 | |||
2685 | 264708 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
8224 | 254835 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 250 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2019 12:00:00 AM | 3 | 4x3 | Permit Number 784635 | 5989365 | 2113673 | 37.7831295589045 | -122.480500378386 | (37.7831295589045, -122.480500378386) | 11 | 6 | 2 | 55 | 26 |
8242 | 264706 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
17698 | 264705 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
17787 | 264681 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 840 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Permit Number 785486 | 5982954.56765 | 2110060.16253 | 37.7728351334222 | -122.502410039067 | (37.7728351334222, -122.502410039067) | 11 | 6 | 2 | 55 | 26 | ||
19591 | 264707 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
141599 | 251417 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5990003 | 2112517 | 37.7799925618685 | -122.478208632121 | (37.7799925618685, -122.478208632121) | 11 | 6 | 2 | 55 | 26 | ||||
190320 | 72375 | Private 9 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 4299X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1996 12:00:00 AM | 3x3 | Permit Number 773790 | 5990099.63678033 | 2109979.56687008 | 37.773031079694 | -122.477688796337 | (37.773031079694, -122.477688796337) | 11 | 6 | 2 | 55 | 26 | |
10283 | 264747 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
13028 | 264748 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
14046 | 262297 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 666 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009767 | 2091318 | 37.722912259595 | -122.408340109411 | (37.722912259595, -122.408340109411) | 9 | 3 | 7 | 309 | 28 | ||||
675 | 150019 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.62882 | 2105456.11878 | 37.7620514180509 | -122.389544911688 | (37.7620514180509, -122.389544911688) | 10 | 3 | 8 | 28856 | 29 | |
1077 | 149677 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011154.9566 | 2106050.92707 | 37.7634433311543 | -122.404578819881 | (37.7634433311543, -122.404578819881) | 8 | 3 | 8 | 28856 | 29 | |
3212 | 150016 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.18586 | 2105386.64383 | 37.7618609074738 | -122.389524298311 | (37.7618609074738, -122.389524298311) | 10 | 3 | 8 | 28856 | 29 | |
3416 | 262187 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 4 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
8842 | 150020 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.50926 | 2105477.62507 | 37.7621104630605 | -122.389546827243 | (37.7621104630605, -122.389546827243) | 10 | 3 | 8 | 28856 | 29 | |
8898 | 149678 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 2 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
14649 | 150018 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015492.47093 | 2105432.35195 | 37.7619863170408 | -122.389533421936 | (37.7619863170408, -122.389533421936) | 10 | 3 | 8 | 28856 | 29 | |
15916 | 150017 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.08881 | 2105409.25245 | 37.7619229804945 | -122.389526212978 | (37.7619229804945, -122.389526212978) | 10 | 3 | 8 | 28856 | 29 | |
18413 | 149679 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 3 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
142770 | 150735 | Private 9 | Cordyline australis :: Dracena Palm 64 | 783 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778950 | 6012760.80751 | 2103885.27159 | 37.7575865350131 | -122.398872659244 | (37.7575865350131, -122.398872659244) | 10 | 3 | 8 | 28856 | 29 | |
4985 | 260550 | Private 9 | Private shrub :: Private Shrub 284 | 155 Graystone Ter | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 3x3 | 5999080 | 2104142 | 37.7575196509651 | -122.446204727568 | (37.7575196509651, -122.446204727568) | 2 | 5 | 5 | 28862 | 3 | ||||
7435 | 239668 | Private 9 | Butia capitata :: Pindo Palm 313 | 180 Dolores St | 3 | Sidewalk: Property side : Pot | Landscaping | Private 2 | 23 | Width 4ft | 6004776.3298 | 2107329.36682 | 37.7665950691341 | -122.426731495165 | (37.7665950691341, -122.426731495165) | 8 | 4 | 5 | 28862 | 3 | |||
8510 | 259163 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
9208 | 259164 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
16189 | 104502 | Private 9 | Pinus radiata :: Monterey Pine 15 | 30X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 14 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
16349 | 259165 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
141416 | 118356 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 RACCOON DR | 2 | Back Yard : Cutout | Tree | Private 2 | 48 | 5998776 | 2103987 | 37.7570766935068 | -122.447244922317 | (37.7570766935068, -122.447244922317) | 15 | 5 | 5 | 63 | 3 | ||||
193423 | 108885 | Private 9 | Cupaniopsis anacardioides :: Carrotwood 195 | 707 NOE ST | 5 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003152.4 | 2104071.5 | 37.7575578048507 | -122.432115704961 | (37.7575578048507, -122.432115704961) | 2 | 4 | 5 | 28862 | 3 | ||||
9465 | 260400 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Parker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
15771 | 259520 | Private 9 | :: 45 | 190 Parker Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
18444 | 259521 | Private 9 | :: 45 | 190 Parker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
18936 | 260399 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Parker Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
11239 | 260905 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007589.07412 | 2119959.01259 | 37.8014316343257 | -122.417898047397 | (37.8014316343257, -122.417898047397) | 5 | 1 | 1 | 28858 | 32 | ||
12190 | 260906 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2215 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007586.25473 | 2119982.21322 | 37.8014951787433 | -122.417909449339 | (37.8014951787433, -122.417909449339) | 5 | 1 | 1 | 28858 | 32 | ||
985 | 262391 | Private 9 | Pinus Spp :: Pine Spp 100 | 2646 38th Ave | 1 | Back Yard : Yard | Tree | Private 2 | Width 0ft | 5984657 | 2097167 | 37.7375339667511 | -122.495570077384 | (37.7375339667511, -122.495570077384) | 1 | 8 | 3 | 29491 | 35 | ||||
4850 | 262150 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
6683 | 262152 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
8142 | 262151 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
18909 | 262153 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
107120 | 121090 | Private 9 | Pinus radiata :: Monterey Pine 15 | 1X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
181524 | 121089 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
193685 | 104552 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
16285 | 114961 | Private 9 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 220 Evelyn Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.450116261368 | (37.7429206264442, -122.450116261368) | 9 | 7 | 4 | 59 | 40 | |||
119017 | 105441 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 425 WAWONA ST | unknown : Yard | Tree | Private 2 | 5991587.6 | 2097036.5 | 37.7375790508831 | -122.471598439568 | (37.7375790508831, -122.471598439568) | 1 | 8 | 4 | 29491 | 40 | ||||||
150142 | 114761 | Private 9 | Pinus radiata :: Monterey Pine 15 | 2155 10TH AVE | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5993160 | 2101036 | 37.7486515109126 | -122.466452556212 | (37.7486515109126, -122.466452556212) | 1 | 8 | 4 | 29491 | 40 | ||||
160937 | 102060 | Private 9 | Cupressus macrocarpa :: Monterey Cypress 41 | 115 Kensington Way | 1 | Back Yard : Yard | Tree | Private 2 | 5994908.3 | 2098325.8 | 37.7413107073974 | -122.460210667073 | (37.7413107073974, -122.460210667073) | 1 | 8 | 4 | 59 | 40 | |||||
167961 | 104436 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 SAN FERNANDO WAY | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 5992040 | 2096369 | 37.7357724272627 | -122.469985704629 | (37.7357724272627, -122.469985704629) | 1 | 8 | 4 | 59 | 40 | ||||
180111 | 256895 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 701 Congo St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768867 | 6000183.68977 | 2096091.89275 | 37.7354789553486 | -122.441809987085 | (37.7354789553486, -122.441809987085) | 9 | 7 | 4 | 63 | 40 | |||
5914 | 254656 | Private 9 | :: 45 | 640 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004524 | 2112776 | 37.781535924842 | -122.427992425483 | (37.781535924842, -122.427992425483) | 7 | 9 | 11 | 29490 | 41 | ||||
18526 | 250107 | Private 9 | Tree(s) :: 17 | 1688 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005911.45005 | 2115583.38163 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | 13 | 9 | 1 | 28858 | 41 | |||
108163 | 104358 | Private 9 | Maytenus boaria :: Mayten 58 | 745X GOLDEN GATE AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3 | 6005986 | 2112447 | 37.7807151749226 | -122.422911209833 | (37.7807151749226, -122.422911209833) | 7 | 9 | 11 | 28852 | 41 | ||||
4221 | 160246 | Private 9 | Potential Site :: Potential Site 48 | 962 Edinburgh St | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 02/20/2020 12:00:00 AM | 3 | 3x3 | Permit Number 779047 | 6001480.24176 | 2088600.7563 | 37.7149837880375 | -122.436791243222 | (37.7149837880375, -122.436791243222) | 9 | 7 | 6 | 28861 | 5 |
14848 | 260375 | Private 9 | Tree(s) :: 17 | 67 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784562 | 5999904.1409 | 2088281.96487 | 37.714018757491 | -122.442216028541 | (37.714018757491, -122.442216028541) | 9 | 7 | 6 | 28861 | 5 |
15590 | 260947 | Private 9 | Tree(s) :: 17 | 143 Gambier St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005856 | 2093079 | 37.72752779603 | -122.421984681693 | (37.72752779603, -122.421984681693) | 9 | 7 | 7 | 309 | 5 | ||||
70534 | 104510 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 254 ALLISON ST | 1 | Back Yard : Yard | Tree | Private 2 | 40 | 6000052 | 2087408 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | 9 | 7 | 6 | 28861 | 5 | ||||
95724 | 85741 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 601X Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798 | 2114488.497614 | 37.7867229411628 | -122.398229721423 | (37.7867229411628, -122.398229721423) | 6 | 2 | 9 | 28855 | 6 | |
109240 | 115128 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 6 | ||||
128761 | 115129 | Private 9 | Geijera parviflora :: Australian Willow 25 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6015842 | 2114626 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | 6 | 2 | 9 | 28855 | 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) );