trees
105 rows where Neighborhoods (old) = 34 and qLegalStatus_id = 2
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
728 | 102430 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.7794962351107 | -122.407028471514 | (37.7794962351107, -122.407028471514) | 14 | 2 | 9 | 28853 | 34 | |
6006 | 253478 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
14666 | 102429 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 200 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.407076563634 | (37.7795357369219, -122.407076563634) | 14 | 2 | 9 | 28853 | 34 | |
15918 | 255699 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
16780 | 85805 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627 | 2111882 | 37.7794804977568 | -122.403356401218 | (37.7794804977568, -122.403356401218) | 14 | 2 | 9 | 28856 | 34 | |
17501 | 251213 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
17700 | 260555 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 502 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2019 12:00:00 AM | 3 | 3x3 | 6011196 | 2109910 | 37.7740417608934 | -122.404708555539 | (37.7740417608934, -122.404708555539) | 14 | 2 | 9 | 28853 | 34 | ||
20988 | 201691 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009873.18605 | 2110010.6659 | 37.7742441430989 | -122.40929152101 | (37.7742441430989, -122.40929152101) | 8 | 2 | 9 | 28853 | 34 | |
21880 | 201692 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009893.13849 | 2109987.83278 | 37.7741825665069 | -122.409220890035 | (37.7741825665069, -122.409220890035) | 8 | 2 | 9 | 28853 | 34 | |
22638 | 113651 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
23724 | 15248 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007914.86722 | 2110337.26914 | 37.7750310067149 | -122.41608885424 | (37.7750310067149, -122.41608885424) | 8 | 2 | 9 | 28853 | 34 | |
26508 | 113650 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
27322 | 201695 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009961.08769 | 2109918.57103 | 37.7739961964126 | -122.408980952704 | (37.7739961964126, -122.408980952704) | 8 | 2 | 9 | 28853 | 34 | |
33336 | 192346 | Planning Code 138.1 required 2 | Fraxinus spp :: Ash Spp 121 | 118 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.54528 | 37.7750719195804 | -122.415815392882 | (37.7750719195804, -122.415815392882) | 8 | 2 | 9 | 28853 | 34 | |
34271 | 251211 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
34716 | 255695 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
34894 | 253483 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
35262 | 253489 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
35619 | 85803 | Planning Code 138.1 required 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 923 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011427.0378 | 2111936.1074 | 37.779617893816 | -122.40405196806 | (37.779617893816, -122.40405196806) | 14 | 2 | 9 | 28856 | 34 | |
36333 | 253491 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
36458 | 113646 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
39373 | 251291 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
42190 | 253480 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
47024 | 120519 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 520 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010156 | 2108818 | 37.7709851997146 | -122.408229076629 | (37.7709851997146, -122.408229076629) | 8 | 2 | 9 | 28853 | 34 | ||||
50722 | 253485 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
52682 | 192595 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1995 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008285.14461 | 2110684.68439 | 37.7760057386966 | -122.414832573262 | (37.7760057386966, -122.414832573262) | 8 | 2 | 9 | 28853 | 34 | |
52945 | 117454 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 236 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776408 | 6011519 | 2111785 | 37.7792081256956 | -122.403723194086 | (37.7792081256956, -122.403723194086) | 14 | 2 | 9 | 28856 | 34 | |
57131 | 192563 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008747.97709 | 2111280.89227 | 37.7776687794229 | -122.413273679445 | (37.7776687794229, -122.413273679445) | 8 | 2 | 9 | 28853 | 34 | |
57149 | 115098 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010148.06204 | 2111925.42664 | 37.7795170247346 | -122.408475763058 | (37.7795170247346, -122.408475763058) | 14 | 2 | 9 | 28853 | 34 | |
57241 | 253248 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
61025 | 253495 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
61214 | 15236 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008261.49106 | 2110663.48431 | 37.7759461992201 | -122.414912896556 | (37.7759461992201, -122.414912896556) | 8 | 2 | 9 | 28853 | 34 | |
61672 | 15237 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | 8 | 2 | 9 | 28853 | 34 | |
71488 | 190612 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008236.46776 | 2110619.04505 | 37.7758227734432 | -122.414996312823 | (37.7758227734432, -122.414996312823) | 8 | 2 | 9 | 28853 | 34 | |
74052 | 201694 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009941.3987 | 2109939.6045 | 37.7740528464887 | -122.409050544971 | (37.7740528464887, -122.409050544971) | 8 | 2 | 9 | 28853 | 34 | |
74410 | 201698 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6010000.12901 | 2109874.7171 | 37.7738779706193 | -122.408842806955 | (37.7738779706193, -122.408842806955) | 8 | 2 | 9 | 28853 | 34 | |
79696 | 253247 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
84600 | 117455 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 236 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776408 | 6011503.45491 | 2111758.78759 | 37.7791352841027 | -122.403775126323 | (37.7791352841027, -122.403775126323) | 14 | 2 | 9 | 28856 | 34 | ||
84993 | 253492 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
85377 | 253490 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
85953 | 201697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009987.20299 | 2109888.7351 | 37.7739157367544 | -122.408888509595 | (37.7739157367544, -122.408888509595) | 8 | 2 | 9 | 28853 | 34 | |
88035 | 113653 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
88090 | 85806 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627 | 2111882 | 37.7794804977568 | -122.403356401218 | (37.7794804977568, -122.403356401218) | 14 | 2 | 9 | 28856 | 34 | |
90566 | 120518 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 520 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010156 | 2108818 | 37.7709851997146 | -122.408229076629 | (37.7709851997146, -122.408229076629) | 8 | 2 | 9 | 28853 | 34 | ||||
91455 | 85807 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
93105 | 253487 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
94254 | 121506 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Folsom St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012227.3168 | 2112699.1751 | 37.7817577819585 | -122.401337080379 | (37.7817577819585, -122.401337080379) | 6 | 2 | 9 | 28856 | 34 | |||
95654 | 253488 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
96128 | 73589 | Planning Code 138.1 required 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 468 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1995 12:00:00 AM | 12 | 3x3 | Permit Number 770905 | 6010928.13640467 | 2111848.51157587 | 37.7793494887795 | -122.405771720076 | (37.7793494887795, -122.405771720076) | 14 | 2 | 9 | 28853 | 34 | |
98758 | 101942 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010108.29372 | 2111885.47528 | 37.7794051005107 | -122.408610520167 | (37.7794051005107, -122.408610520167) | 14 | 2 | 9 | 28853 | 34 | |
98874 | 255694 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
99698 | 113643 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
105665 | 253493 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
105773 | 255696 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
106809 | 29017 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 120 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | 6 | 3x3 | Permit Number 770901 | 6008044.5664857 | 2110308.5131992 | 37.7749593412658 | -122.415638158484 | (37.7749593412658, -122.415638158484) | 8 | 2 | 9 | 28853 | 34 | |
107192 | 201696 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009973.11931 | 2109904.86997 | 37.773959250457 | -122.408938366227 | (37.773959250457, -122.408938366227) | 8 | 2 | 9 | 28853 | 34 | |
108346 | 255693 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
109444 | 255700 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 510 Townsend St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
115603 | 251289 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
117291 | 113647 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
121557 | 113652 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
121637 | 253479 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
122740 | 115096 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 537 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010119.08101 | 2111896.4319 | 37.7794357889593 | -122.408573975335 | (37.7794357889593, -122.408573975335) | 14 | 2 | 9 | 28853 | 34 | |
123746 | 117456 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 236 SHIPLEY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776408 | 6011519 | 2111785 | 37.7792081256956 | -122.403723194086 | (37.7792081256956, -122.403723194086) | 14 | 2 | 9 | 28856 | 34 | ||
124736 | 251212 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 210X Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604 | 2111950 | 37.7796659253507 | -122.403440753721 | (37.7796659253507, -122.403440753721) | 14 | 2 | 9 | 28856 | 34 | |
124821 | 113644 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
126119 | 85804 | Planning Code 138.1 required 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 923 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011441.4589 | 2111949.4191 | 37.7796552503769 | -122.404003016031 | (37.7796552503769, -122.404003016031) | 14 | 2 | 9 | 28856 | 34 | |
128069 | 104819 | Planning Code 138.1 required 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 468 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770905 | 6011018.41682 | 2111922.08536 | 37.7795565535331 | -122.405464583724 | (37.7795565535331, -122.405464583724) | 14 | 2 | 9 | 28853 | 34 | |
128513 | 199503 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.98308 | 2111924.50305 | 37.7795342467397 | -122.407254787701 | (37.7795342467397, -122.407254787701) | 14 | 2 | 9 | 28853 | 34 | |
128863 | 253475 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
130377 | 113654 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
132587 | 199504 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | 14 | 2 | 9 | 28853 | 34 | |
134197 | 201699 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6010014.86815 | 2109861.25987 | 37.7738418457656 | -122.408790872027 | (37.7738418457656, -122.408790872027) | 8 | 2 | 9 | 28853 | 34 | |
134827 | 255697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
135281 | 253476 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
137539 | 113649 | Planning Code 138.1 required 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 98X 10TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |||
139476 | 113655 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 901X JESSIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 3x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
152719 | 113648 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
154892 | 113645 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947 | 2110424 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | 8 | 2 | 9 | 28853 | 34 | |
158086 | 15247 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007902.55668 | 2110326.57547 | 37.7750009522643 | -122.416130681693 | (37.7750009522643, -122.416130681693) | 8 | 2 | 9 | 28853 | 34 | |
158927 | 251290 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
159122 | 253486 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
159283 | 192594 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/1995 12:00:00 AM | 2 | Width 4ft | Permit Number 770747 | 6008274.3646 | 2110675.08431 | 37.7759787734355 | -122.414869184668 | (37.7759787734355, -122.414869184668) | 8 | 2 | 9 | 28853 | 34 | |
160441 | 117453 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 236 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776408 | 6011539.59396 | 2111788.0027 | 37.779217520823 | -122.403652162024 | (37.779217520823, -122.403652162024) | 14 | 2 | 9 | 28856 | 34 | ||
160922 | 121508 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Folsom St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012258.9126 | 2112729.3972 | 37.7818425275943 | -122.401229897449 | (37.7818425275943, -122.401229897449) | 6 | 2 | 9 | 28856 | 34 | |||
161626 | 255692 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
162521 | 192596 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1335 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1995 12:00:00 AM | 3 | Width 4ft | Permit Number 770747 | 6008295.90964 | 2110693.56586 | 37.7760307299718 | -122.414795962779 | (37.7760307299718, -122.414795962779) | 8 | 2 | 9 | 28853 | 34 | |
164004 | 201690 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009863.47645 | 2110020.43216 | 37.7742704149776 | -122.409325797764 | (37.7742704149776, -122.409325797764) | 8 | 2 | 9 | 28853 | 34 | |
168133 | 121551 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778243 | 6009293.51408 | 2111653.12836 | 37.7787214646499 | -122.411412777974 | (37.7787214646499, -122.411412777974) | 8 | 2 | 9 | 28853 | 34 | |
169960 | 192564 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008734.11613 | 2111298.92197 | 37.7777175065003 | -122.413322904728 | (37.7777175065003, -122.413322904728) | 8 | 2 | 9 | 28853 | 34 | |
169973 | 253496 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
171171 | 253477 | Planning Code 138.1 required 2 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1222 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984 | 2109753 | 37.7735428603255 | -122.408890010762 | (37.7735428603255, -122.408890010762) | 8 | 2 | 9 | 28853 | 34 | |
175654 | 201688 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009806.99553 | 2110077.79875 | 37.7744247656342 | -122.409525226004 | (37.7744247656342, -122.409525226004) | 8 | 2 | 9 | 28853 | 34 | |
176162 | 121550 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778243 | 6009252.51421 | 2111618.01515 | 37.7786227523886 | -122.411552131552 | (37.7786227523886, -122.411552131552) | 8 | 2 | 9 | 28853 | 34 | |
176904 | 190611 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008250.0486 | 2110605.54207 | 37.7757864606069 | -122.41494837717 | (37.7757864606069, -122.41494837717) | 8 | 2 | 9 | 28853 | 34 | |
177182 | 15246 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770901 | 6007883.54199 | 2110310.54573 | 37.7749558692557 | -122.416195322271 | (37.7749558692557, -122.416195322271) | 8 | 2 | 9 | 28853 | 34 | |
178528 | 121507 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012241.512 | 2112714.7441 | 37.7818013227969 | -122.401289065763 | (37.7818013227969, -122.401289065763) | 6 | 2 | 9 | 28856 | 34 | |||
180989 | 255698 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 3x3 | 6012573 | 2109637 | 37.773369031352 | -122.399926071367 | (37.773369031352, -122.399926071367) | 14 | 2 | 9 | 28853 | 34 | ||
181014 | 253484 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
182348 | 173697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007975.5805432 | 2110395.7628537 | 37.775195030009 | -122.415882976003 | (37.775195030009, -122.415882976003) | 8 | 2 | 9 | 28853 | 34 |
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) );