trees
736 rows where DBH = 3 and qLegalStatus_id = 2 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
161064 | 114972 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1431 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777191 | 6000962.5 | 2110659.8 | 37.7755232425188 | -122.440161680014 | (37.7755232425188, -122.440161680014) | 15 | 5 | 11 | 29492 | 10 | |
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 | |
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 | |
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 | |
190069 | 15235 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | 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 | |
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 | |
105455 | 256779 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1231 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 782672 | 6001926.50082 | 2110819.32275 | 37.7760160870933 | -122.436838397294 | (37.7760160870933, -122.436838397294) | 15 | 5 | 11 | 29492 | 10 | ||
153036 | 256778 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1231 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 782672 | 6001926.50082 | 2110819.32275 | 37.7760160870933 | -122.436838397294 | (37.7760160870933, -122.436838397294) | 15 | 5 | 11 | 29492 | 10 | ||
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 | |
139523 | 254363 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 634 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 772779 | 5981973.79907 | 2111426.3014 | 37.7765284742444 | -122.505903875162 | (37.7765284742444, -122.505903875162) | 11 | 6 | 2 | 55 | 26 | |
78499 | 255416 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
126056 | 255417 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 99x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6007395 | 2111066 | 37.7770026839515 | -122.417938862064 | (37.7770026839515, -122.417938862064) | 7 | 9 | 9 | 28852 | 36 | ||
64870 | 255402 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
72419 | 255414 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
87472 | 255403 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
108535 | 255409 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
109022 | 255406 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
124352 | 255410 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
130074 | 255415 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
139116 | 255407 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
149074 | 255412 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
164769 | 255405 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
165740 | 255404 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 150 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
167550 | 255408 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
178102 | 255413 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
179705 | 255411 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 199x Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | 6006976 | 2111107 | 37.7770916699959 | -122.419391225109 | (37.7770916699959, -122.419391225109) | 7 | 9 | 9 | 28852 | 36 | ||
184734 | 115535 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.7775281488378 | -122.418497266559 | (37.7775281488378, -122.418497266559) | 7 | 9 | 9 | 28852 | 36 | ||
93518 | 115534 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.7775284833993 | -122.418420222514 | (37.7775284833993, -122.418420222514) | 7 | 9 | 9 | 28852 | 36 | ||
115681 | 115533 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | 7 | 9 | 9 | 28852 | 36 | ||
34272 | 115532 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.7775456658356 | -122.418304279225 | (37.7775456658356, -122.418304279225) | 7 | 9 | 9 | 28852 | 36 | ||
168962 | 115531 | Planning Code 138.1 required 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 100X Hayes St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007312.73746 | 2111269.98589 | 37.7775581502144 | -122.41823790028 | (37.7775581502144, -122.41823790028) | 7 | 9 | 9 | 28852 | 36 | ||
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 | |
167439 | 115530 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007332.44961 | 2111311.79762 | 37.7776740647351 | -122.418172674243 | (37.7776740647351, -122.418172674243) | 7 | 9 | 9 | 28852 | 36 | |
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 | |
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 | |
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 | |
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 | |
135842 | 115529 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007327.31765 | 2111347.52577 | 37.777771876795 | -122.418192961161 | (37.777771876795, -122.418192961161) | 7 | 9 | 9 | 28852 | 36 | |
171393 | 115528 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007325.8351 | 2111377.63368 | 37.7778544624367 | -122.418200224953 | (37.7778544624367, -122.418200224953) | 7 | 9 | 9 | 28852 | 36 | |
29612 | 119287 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 400 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873 | 2111410 | 37.7778614491402 | -122.423228396467 | (37.7778614491402, -122.423228396467) | 7 | 9 | 11 | 28852 | 10 | ||
34845 | 119285 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873 | 2111410 | 37.7778614491402 | -122.423228396467 | (37.7778614491402, -122.423228396467) | 7 | 9 | 11 | 28852 | 10 | ||
97781 | 119286 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 400 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873 | 2111410 | 37.7778614491402 | -122.423228396467 | (37.7778614491402, -122.423228396467) | 7 | 9 | 11 | 28852 | 10 | ||
12720 | 115537 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
40425 | 115540 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x5 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
75364 | 115539 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
164265 | 115538 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
185440 | 115536 | Planning Code 138.1 required 2 | Crataegus laevigata :: English Hawthorn 133 | 99X Lech Walesa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.50228 | 2111387.72892 | 37.7778703965252 | -122.418925098047 | (37.7778703965252, -122.418925098047) | 7 | 9 | 9 | 28852 | 36 | |
16386 | 262532 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 815 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781917 | 5999987.51846 | 2111668.14853 | 37.7782363548085 | -122.443606817465 | (37.7782363548085, -122.443606817465) | 15 | 5 | 11 | 29490 | 16 | |
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 | |
47139 | 257910 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
121157 | 257909 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
193393 | 257908 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 199x Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | 3x3 | 6014800 | 2111540 | 37.778718149686 | -122.392355631341 | (37.778718149686, -122.392355631341) | 6 | 2 | 9 | 28856 | 20 | ||
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 | |
162442 | 255923 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 539 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2018 12:00:00 AM | 3 | Permit Number 774708 | 5984698.21016 | 2112191.31166 | 37.7787889555839 | -122.496535962511 | (37.7787889555839, -122.496535962511) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
178223 | 256896 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 470 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780643 | 5985651.17942 | 2112710.44444 | 37.7802701294342 | -122.493277571063 | (37.7802701294342, -122.493277571063) | 11 | 6 | 2 | 55 | 26 | |
164491 | 251061 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 5418 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 777516 | 5990182.6788 | 2112719.9143 | 37.7805601365444 | -122.477601885097 | (37.7805601365444, -122.477601885097) | 11 | 6 | 2 | 55 | 26 | ||
16618 | 251060 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5418 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 777516 | 5990225.155 | 2112720.9896 | 37.7805655538274 | -122.477455019941 | (37.7805655538274, -122.477455019941) | 11 | 6 | 2 | 55 | 26 | ||
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 | |
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 | |
187618 | 253249 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 3 | 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 | |
102133 | 113329 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 329 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770912 | 6014656.6559 | 2112395.64308 | 37.7810595913673 | -122.392911397837 | (37.7810595913673, -122.392911397837) | 6 | 2 | 9 | 28856 | 6 | |
5543 | 121277 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
36998 | 121281 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
62537 | 121276 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
77980 | 121283 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
80724 | 121284 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
93654 | 121280 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
128498 | 121278 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
149736 | 121282 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
152002 | 121279 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
116306 | 147588 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990252.64201 | 2112933.29364 | 37.7811500766647 | -122.477375451022 | (37.7811500766647, -122.477375451022) | 11 | 6 | 2 | 55 | 26 | |
1962 | 122597 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
19209 | 122592 | Planning Code 138.1 required 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
27168 | 75842 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 6 | |
34241 | 122599 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 42X Colin P Kelly Jr St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480 | 2112413 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | 6 | 2 | 9 | 28856 | 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) );