trees
1,011 rows where 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
194194 | 255691 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 510 Townsend St | 1 | 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 | ||
145785 | 253796 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.7331586170673 | -122.400946899168 | (37.7331586170673, -122.400946899168) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
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 | |||
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 | |||
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 | ||
163344 | 115976 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | 10 | 3 | 7 | 309 | 28 | |||
188951 | 115977 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011639.0005 | 2091249.90123 | 37.7228299259539 | -122.40186416949 | (37.7228299259539, -122.40186416949) | 10 | 3 | 7 | 309 | 28 | |||
158751 | 115978 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011623.9012 | 2091244.95295 | 37.7228154963084 | -122.40191601721 | (37.7228154963084, -122.40191601721) | 10 | 3 | 7 | 309 | 28 | |||
156122 | 115979 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011610.19593 | 2091240.25279 | 37.7228018257296 | -122.401963063449 | (37.7228018257296, -122.401963063449) | 10 | 3 | 7 | 309 | 28 | |||
13984 | 115980 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.7227881560287 | -122.402019710862 | (37.7227881560287, -122.402019710862) | 10 | 3 | 7 | 309 | 28 | |||
8011 | 260843 | Planning Code 138.1 required 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1015 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2019 12:00:00 AM | 3 | 3x3 | Permit Number 779771 | 6011450.48648 | 2090129.50026 | 37.719743011404 | -122.402437083292 | (37.719743011404, -122.402437083292) | 10 | 7 | 8 | 309 | 28 | |
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 | |
35834 | 122701 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.76794 | 37.7253343641976 | -122.402569107292 | (37.7253343641976, -122.402569107292) | 10 | 3 | 7 | 309 | 28 | ||
191014 | 122700 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.76794 | 37.7253343641976 | -122.402569107292 | (37.7253343641976, -122.402569107292) | 10 | 3 | 7 | 309 | 28 | ||
81706 | 122697 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
101909 | 122699 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
183675 | 122698 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.99272 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | 10 | 3 | 7 | 309 | 28 | ||
142797 | 115805 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 872 Kansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.7585117443173 | -122.403098033012 | (37.7585117443173, -122.403098033012) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
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 | |
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 | ||
95475 | 46434 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | 10 | 7 | 8 | 309 | 28 | |
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 | ||
129107 | 46432 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2St. Ankeny St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2002 12:00:00 AM | 3 | 3x3 | Permit Number 44652 | 6011085.82067 | 2089727.08588 | 37.7186176993268 | -122.403669311209 | (37.7186176993268, -122.403669311209) | 10 | 7 | 8 | 309 | 28 | |
46971 | 110398 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2St. Ankeny St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011080.03742 | 2089739.99739 | 37.7186528286367 | -122.403690209641 | (37.7186528286367, -122.403690209641) | 10 | 7 | 8 | 309 | 28 | |||
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 | ||
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 | ||
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 | |
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 | |
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 | ||
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 | |
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 | |
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 | |
37358 | 247943 | Planning Code 138.1 required 2 | Maytenus boaria :: Mayten 58 | 29 Joy St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
7505 | 247942 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.407057283984 | (37.7437730949632, -122.407057283984) | 2 | 7 | 7 | 28859 | 2 | |||
126738 | 247941 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.407074570729 | (37.743786764646, -122.407074570729) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
114599 | 240686 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.7497675773096 | -122.407098537685 | (37.7497675773096, -122.407098537685) | 2 | 4 | 7 | 28859 | 19 | |
128791 | 247940 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.28814 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | 2 | 7 | 7 | 28859 | 2 | |||
120065 | 258340 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 121 Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2019 12:00:00 AM | 3 | 3x3 | 6010033.53413 | 2086907.42536 | 37.7108166491636 | -122.407108010284 | (37.7108166491636, -122.407108010284) | 9 | 7 | 8 | 309 | 39 | ||
70866 | 224462 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2810 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010311.37562 | 2101086.64633 | 37.7497653433983 | -122.407146558773 | (37.7497653433983, -122.407146558773) | 2 | 4 | 7 | 28859 | 19 | |
60942 | 247939 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 29 Joy St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 12 | Permit Number 775404 | 6010258.29977 | 2098917.51569 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | 2 | 7 | 7 | 28859 | 2 | |||
162044 | 247938 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 29 Joy St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
22723 | 119256 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 195 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2016 12:00:00 AM | 3 | 3x3 | 6010242 | 2098801 | 37.7434855758555 | -122.407225363197 | (37.7434855758555, -122.407225363197) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |
78754 | 119257 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 191 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2016 12:00:00 AM | 3 | 3x3 | 6010220 | 2098811 | 37.743511802413 | -122.407302138847 | (37.743511802413, -122.407302138847) | 2 | 7 | 7 | 28859 | 2 | ||
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 | ||
161840 | 148099 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 509 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782106 | 6009909.13224 | 2092063.05855 | 37.7249659929773 | -122.40790129952 | (37.7249659929773, -122.40790129952) | 10 | 3 | 7 | 309 | 28 | |
53742 | 82615 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.7511727251881 | -122.408119020981 | (37.7511727251881, -122.408119020981) | 2 | 4 | 7 | 28859 | 19 | |
131633 | 115503 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2901 25th St | 72 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.7511727251881 | -122.408119020981 | (37.7511727251881, -122.408119020981) | 2 | 4 | 7 | 28859 | 19 | |
163013 | 115504 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2901 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.7511727251881 | -122.408119020981 | (37.7511727251881, -122.408119020981) | 2 | 4 | 7 | 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 | ||||
46028 | 152812 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 2901 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6010002.42353 | 2101608.75594 | 37.7511816461268 | -122.408251752714 | (37.7511816461268, -122.408251752714) | 2 | 4 | 7 | 28859 | 19 |
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) );