trees
142 rows where Fire Prevention Districts = 8 and qLegalStatus_id = 2 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6093 | 45072 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 596 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Permit Number 770844 | 6012065 | 2105633 | 37.7623466149115 | -122.401401881236 | (37.7623466149115, -122.401401881236) | 8 | 3 | 8 | 28856 | 29 | ||
7223 | 106240 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 586 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | Permit Number 770844 | 6012063 | 2105678 | 37.7624700633024 | -122.401411961161 | (37.7624700633024, -122.401411961161) | 8 | 3 | 8 | 28856 | 29 | ||
16696 | 195151 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1912 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012043 | 2105629 | 37.7623344042956 | -122.401477690357 | (37.7623344042956, -122.401477690357) | 8 | 3 | 8 | 28856 | 29 | |||
180648 | 57578 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1916 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1976 12:00:00 AM | 20 | 3x3 | Permit Number 16445 | 6012032 | 2105628 | 37.7623310447467 | -122.401515665193 | (37.7623310447467, -122.401515665193) | 8 | 3 | 8 | 28856 | 29 | |
4535 | 106245 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 566 De Haro St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Permit Number 770844 | 6012026 | 2105714 | 37.7625668468002 | -122.401542461625 | (37.7625668468002, -122.401542461625) | 8 | 3 | 8 | 28856 | 29 | |||
10557 | 106246 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 560 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 770844 | 6012026 | 2105714 | 37.7625668468002 | -122.401542461625 | (37.7625668468002, -122.401542461625) | 8 | 3 | 8 | 28856 | 29 | ||
43703 | 106256 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1928 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Permit Number 770844 | 6011999 | 2105627 | 37.7623264575812 | -122.401629730256 | (37.7623264575812, -122.401629730256) | 8 | 3 | 8 | 28856 | 29 | ||
98983 | 106257 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1938 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | Permit Number 770844 | 6011971 | 2105625 | 37.7623194035501 | -122.40172643178 | (37.7623194035501, -122.40172643178) | 8 | 3 | 8 | 28856 | 29 | ||
37766 | 150676 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 548 Rhode Island St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.98399 | 2105812.52377 | 37.7628222449765 | -122.402486741392 | (37.7628222449765, -122.402486741392) | 8 | 3 | 8 | 28856 | 29 | |
6978 | 253743 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
31968 | 253741 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
48111 | 253753 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
50738 | 253752 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
61405 | 253746 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
62404 | 253750 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
67103 | 253756 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 41x Division St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
71327 | 253751 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
73445 | 253735 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
93259 | 253749 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 2x Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
116197 | 253754 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
121031 | 253742 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
123458 | 253739 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
134719 | 253755 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 41x Division St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
139534 | 253737 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
142538 | 253747 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
163114 | 253748 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 2x Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
173158 | 253738 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
174788 | 253736 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
178080 | 253744 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
186212 | 253740 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
193569 | 253745 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517 | 2108140 | 37.7691996810398 | -122.403473604048 | (37.7691996810398, -122.403473604048) | 8 | 2 | 8 | 28853 | 20 | ||
104300 | 196537 | Planning Code 138.1 required 2 | Prunus x yedoensis :: Yoshino Cherry 77 | 526 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782869 | 6010635.96485 | 2105787.36101 | 37.7626906193079 | -122.406355282166 | (37.7626906193079, -122.406355282166) | 8 | 4 | 8 | 28859 | 19 | |
56279 | 116967 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 480 Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010335.4704597 | 2106068.8961361 | 37.7634468367565 | -122.407414438937 | (37.7634468367565, -122.407414438937) | 8 | 4 | 8 | 28859 | 19 | ||||
120199 | 116966 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6010311.67872 | 2106089.82191 | 37.7635029625087 | -122.407498202703 | (37.7635029625087, -122.407498202703) | 8 | 4 | 8 | 28859 | 19 | |||
47537 | 18353 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2013 12:00:00 AM | 3 | 3x3 | 6010310.70956 | 2106111.3358 | 37.7635619805233 | -122.407503071611 | (37.7635619805233, -122.407503071611) | 8 | 4 | 8 | 28859 | 19 | ||
8777 | 18349 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6010308 | 2106081 | 37.7634785336334 | -122.407510304274 | (37.7634785336334, -122.407510304274) | 8 | 4 | 8 | 28859 | 19 | ||
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 | ||||
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 | ||||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
190324 | 253494 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 12 | 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 | |
34711 | 44001 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
37180 | 44003 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
72715 | 44010 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405x Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
145930 | 44005 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
176140 | 44012 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 405X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
177064 | 44004 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
191118 | 44013 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
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 | |
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 | |
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 | |
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 | |
74821 | 36044 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
177206 | 36045 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
15819 | 151746 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008502.96204 | 2106251.6003 | 37.763845762487 | -122.413765441348 | (37.763845762487, -122.413765441348) | 8 | 4 | 7 | 28859 | 19 | |
124014 | 108228 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492 | 2106262 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | 8 | 4 | 7 | 28859 | 19 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |||
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 |
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) );