trees
39,840 rows where qLegalStatus_id = 7 sorted by Zip Codes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
226 | 56655 | Permitted Site 7 | Tree(s) :: 17 | 491 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993749.22353597 | 2090472.28724098 | 37.7196801529508 | -122.463648462413 | (37.7196801529508, -122.463648462413) | 9 | 8 | 6 | 64 | 24 | |||||
294 | 53493 | Permitted Site 7 | Tree(s) :: 17 | 262 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | Permit Number 6403 | 5992228.28376051 | 2089608.56362168 | 37.717220822263 | -122.468842940668 | (37.717220822263, -122.468842940668) | 9 | 8 | 6 | 64 | 24 | |||
1257 | 260668 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
1663 | 27797 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
1702 | 46741 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 21 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44848 | 5993934.28224784 | 2089153.42556477 | 37.7160695363268 | -122.462913152344 | (37.7160695363268, -122.462913152344) | 9 | 8 | 6 | 64 | 24 | ||
1812 | 52955 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 516 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48942 | 5993282.16384919 | 2090617.22186434 | 37.7200511847077 | -122.465273429637 | (37.7200511847077, -122.465273429637) | 9 | 8 | 6 | 64 | 24 | ||
2210 | 53264 | Permitted Site 7 | Tree(s) :: 17 | 523 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | Permit Number 6154 | 5993474.77624345 | 2089341.33970508 | 37.7165590253308 | -122.464515046881 | (37.7165590253308, -122.464515046881) | 9 | 8 | 6 | 64 | 24 | |||
2263 | 31189 | Permitted Site 7 | :: 45 | 744 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
2885 | 102680 | Permitted Site 7 | Pyrus calleryana :: Ornamental Pear 44 | 333 Eucalyptus Dr | 6 | Front Yard : Yard | Tree | Private 2 | 12/01/2006 12:00:00 AM | Permit Number 58781 | 5990098.7 | 2094672.6 | 37.731002133155 | -122.476573573496 | (37.731002133155, -122.476573573496) | 1 | 8 | 4 | 64 | 14 | |||
3112 | 44154 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
3325 | 11719 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
3811 | 32184 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 191 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35516 | 5984219.12182319 | 2094256.3665376 | 37.7295164954065 | -122.49686924842 | (37.7295164954065, -122.49686924842) | 1 | 8 | 4 | 64 | 35 | ||
4051 | 260659 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
4241 | 45501 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3070 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44273 | 5989380.64559271 | 2094892.34202186 | 37.7315638149816 | -122.479072048364 | (37.7315638149816, -122.479072048364) | 1 | 8 | 4 | 64 | 35 | ||
4333 | 260669 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
4346 | 32173 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.494326297163 | (37.7296644874619, -122.494326297163) | 1 | 8 | 4 | 64 | 35 | ||
4858 | 39677 | Permitted Site 7 | Quercus keloggii :: California Black Oak 282 | 446 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41063 | 5993017.43068395 | 2090147.12878073 | 37.7187451525026 | -122.466154370624 | (37.7187451525026, -122.466154370624) | 9 | 8 | 6 | 64 | 24 | ||
5996 | 260670 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
6162 | 46753 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.7175193444423 | -122.465247516931 | (37.7175193444423, -122.465247516931) | 9 | 8 | 6 | 64 | 24 | ||
6845 | 31172 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 100 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34871 | 5993759.19888335 | 2089860.63162869 | 37.7180012684503 | -122.463569614328 | (37.7180012684503, -122.463569614328) | 9 | 8 | 6 | 64 | 24 | |||
7625 | 31171 | Permitted Site 7 | Melaleuca nesophila :: Pink Melaleuca 304 | 100 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34871 | 5993759.19888335 | 2089860.63162869 | 37.7180012684503 | -122.463569614328 | (37.7180012684503, -122.463569614328) | 9 | 8 | 6 | 64 | 24 | |||
7937 | 47337 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779205 | 5992952.66327787 | 2090462.04360939 | 37.7196060953775 | -122.466401119038 | (37.7196060953775, -122.466401119038) | 9 | 8 | 6 | 64 | 24 | |
8045 | 260674 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
8305 | 86762 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
8550 | 260661 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
8766 | 36304 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 98 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1998 12:00:00 AM | Permit Number 39288 | 5990632.40828813 | 2094456.10044746 | 37.7304386209332 | -122.474712677246 | (37.7304386209332, -122.474712677246) | 9 | 8 | 4 | 64 | 40 | ||
8821 | 44140 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
9356 | 260660 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
9577 | 50949 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 46 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2004 12:00:00 AM | Permit Number 47444 | 5992462.89572875 | 2086742.39043465 | 37.7093645519695 | -122.467823660285 | (37.7093645519695, -122.467823660285) | 9 | 8 | 6 | 64 | 24 | |||
9828 | 372 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
10498 | 41462 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.7188806981616 | -122.466155833772 | (37.7188806981616, -122.466155833772) | 9 | 8 | 6 | 64 | 24 | |||
11783 | 31192 | Permitted Site 7 | :: 45 | 744 Shields St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
11838 | 94234 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
11990 | 53265 | Permitted Site 7 | Tree(s) :: 17 | 518 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | Permit Number 6155 | 5993526.45994687 | 2089315.57926722 | 37.7164912726104 | -122.464334534512 | (37.7164912726104, -122.464334534512) | 9 | 8 | 6 | 64 | 24 | |||
12142 | 47373 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | 9 | 8 | 6 | 64 | 24 | |||
12474 | 51019 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 251 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47497 | 5992948.45681034 | 2088862.24435583 | 37.7152131901669 | -122.466299454682 | (37.7152131901669, -122.466299454682) | 9 | 8 | 6 | 64 | 24 | |||
12841 | 260672 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
13049 | 52672 | Permitted Site 7 | Tree(s) :: 17 | 160@ WINSTON Broadmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2006 12:00:00 AM | Permit Number 48753 | 5990984.89473485 | 2092824.05440555 | 37.7259778503357 | -122.473375102844 | (37.7259778503357, -122.473375102844) | 9 | 8 | 4 | 64 | 40 | |||
13101 | 44145 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
14347 | 31175 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 230 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34873 | 5993424.36409325 | 2089864.86318911 | 37.7179935887517 | -122.464727290106 | (37.7179935887517, -122.464727290106) | 9 | 8 | 6 | 64 | 24 | ||
14561 | 378 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
16053 | 260673 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
16990 | 261324 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 434 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/09/2013 12:00:00 AM | 3x3 | Permit Number 767522 | 5993810 | 2090074 | 37.7185900537676 | -122.463409493673 | (37.7185900537676, -122.463409493673) | 9 | 8 | 6 | 64 | 24 | ||
17088 | 260671 | Permitted Site 7 | Aesculus californica :: California Buckeye 168 | 9 Cardenas Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5989909.11704 | 2090923.47277 | 37.7206969761498 | -122.47695514418 | (37.7206969761498, -122.47695514418) | 1 | 8 | 4 | 64 | 14 | ||
17272 | 11727 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
17286 | 24406 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
17511 | 260658 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
18213 | 264744 | Permitted Site 7 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 72 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2020 12:00:00 AM | 3 | 3x3 | 5992468.2343 | 2088355.61212 | 37.7137943800888 | -122.467922469466 | (37.7137943800888, -122.467922469466) | 9 | 8 | 6 | 64 | 24 | ||
18441 | 260662 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 2 Varela Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990178.30137 | 2091110.96603 | 37.7212273981358 | -122.476038353928 | (37.7212273981358, -122.476038353928) | 1 | 8 | 4 | 64 | 14 | ||
18515 | 12492 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 307 Lake Merced Blvd | 37 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
18682 | 91505 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
18723 | 95885 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
19291 | 84723 | Permitted Site 7 | Tree(s) :: 17 | 20 Broadmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2007 12:00:00 AM | Permit No. 49226 | 5991054 | 2093662 | 37.7282826409011 | -122.473197297299 | (37.7282826409011, -122.473197297299) | 9 | 8 | 4 | 64 | 40 | |||
19355 | 260675 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 1561 Holloway Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x6 | 5990104.65959 | 2090917.24159 | 37.7206912087067 | -122.476278766554 | (37.7206912087067, -122.476278766554) | 1 | 8 | 4 | 64 | 14 | ||
19401 | 45516 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2975 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | Permit Number 44280 | 5988544.38188689 | 2095413.25132317 | 37.7329454972405 | -122.482001286035 | (37.7329454972405, -122.482001286035) | 1 | 8 | 4 | 64 | 35 | ||
19601 | 95883 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
20061 | 39639 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 556 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41033 | 5992765.12816761 | 2090901.30196023 | 37.7208013690683 | -122.467081273691 | (37.7208013690683, -122.467081273691) | 9 | 8 | 6 | 64 | 24 | ||
20539 | 53338 | Permitted Site 7 | Tree(s) :: 17 | 644 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1969 12:00:00 AM | Permit Number 6230 | 5992341.09481086 | 2089224.30634232 | 37.7161722617983 | -122.468425069043 | (37.7161722617983, -122.468425069043) | 9 | 8 | 6 | 64 | 24 | |||
20795 | 254779 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 700 Brotherhood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
21006 | 31183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 627 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34881 | 5992393.27316776 | 2089825.88959744 | 37.7178270773306 | -122.468288456554 | (37.7178270773306, -122.468288456554) | 9 | 8 | 6 | 64 | 24 | ||
21262 | 45536 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 79 Melba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | Permit Number 44293 | 5989585.76469698 | 2094846.08328142 | 37.7314487101847 | -122.478359538262 | (37.7314487101847, -122.478359538262) | 1 | 8 | 4 | 64 | 35 | |||
21319 | 91088 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 132 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51983 | 5992207 | 2088751 | 37.7148649307688 | -122.468854138233 | (37.7148649307688, -122.468854138233) | 9 | 8 | 6 | 64 | 24 | ||
21864 | 47336 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 142 Garfield St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.7198387158131 | -122.463971702484 | (37.7198387158131, -122.463971702484) | 9 | 8 | 6 | 64 | 24 | |||
21901 | 12497 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 307 Lake Merced Blvd | 42 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
21962 | 45323 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 779 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44159 | 5993494.96108544 | 2091045.11909514 | 37.7212383565658 | -122.464568921888 | (37.7212383565658, -122.464568921888) | 9 | 8 | 6 | 64 | 24 | ||
21997 | 31178 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 326 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34876 | 5993174.15849792 | 2089868.02517544 | 37.7179878425238 | -122.465592364204 | (37.7179878425238, -122.465592364204) | 9 | 8 | 6 | 64 | 24 | ||
22066 | 57635 | Permitted Site 7 | Tree(s) :: 17 | 42 Beverly St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1976 12:00:00 AM | Permit Number 16533 | 5991447.90713812 | 2089494.12651365 | 37.7168614897636 | -122.471531974274 | (37.7168614897636, -122.471531974274) | 9 | 8 | 6 | 64 | 24 | |||
22224 | 47362 | Permitted Site 7 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 266 | 495 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45282 | 5992197.59018482 | 2091172.33754059 | 37.7215127906483 | -122.469062776576 | (37.7215127906483, -122.469062776576) | 9 | 8 | 6 | 64 | 24 | ||
22415 | 254782 | Permitted Site 7 | Acer japonicum :: Japanese Maple 124 | 700 Brotherhood Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
22497 | 45321 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 772 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44158 | 5993546.47195842 | 2091002.85847364 | 37.7211252885031 | -122.464387798146 | (37.7211252885031, -122.464387798146) | 9 | 8 | 6 | 64 | 24 | ||
22526 | 56650 | Permitted Site 7 | Tree(s) :: 17 | 455 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993745.91469689 | 2090225.88887329 | 37.7190034116626 | -122.463642026348 | (37.7190034116626, -122.463642026348) | 9 | 8 | 6 | 64 | 24 | |||||
22771 | 36260 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39271 | 5991253.03942343 | 2094450.93126102 | 37.730460371115 | -122.472566711187 | (37.730460371115, -122.472566711187) | 9 | 8 | 4 | 64 | 40 | ||
22831 | 11871 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
23089 | 39641 | Permitted Site 7 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 560 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41035 | 5992765.35359829 | 2090929.1002245 | 37.7208777093482 | -122.467082514469 | (37.7208777093482, -122.467082514469) | 9 | 8 | 6 | 64 | 24 | ||
23170 | 28848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
23338 | 114378 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 842X GONZALEZ DR | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988421 | 2089827 | 37.7175998975755 | -122.482018759302 | (37.7175998975755, -122.482018759302) | 1 | 8 | 4 | 64 | 14 | ||||
23382 | 11720 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
23811 | 47360 | Permitted Site 7 | Leptospermum scoparium 'Helene Strybing' :: Helene Strybing New Zealand Tea Tree 266 | 495 Ralston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45282 | 5992197.59018482 | 2091172.33754059 | 37.7215127906483 | -122.469062776576 | (37.7215127906483, -122.469062776576) | 9 | 8 | 6 | 64 | 24 | ||
24127 | 46734 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 315 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44844 | 5993734.25176167 | 2089288.64398892 | 37.7164292900251 | -122.463614355193 | (37.7164292900251, -122.463614355193) | 9 | 8 | 6 | 64 | 24 | ||
24408 | 112743 | Permitted Site 7 | Acer palmatum :: Japanese Maple 216 | 568 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2014 12:00:00 AM | Permit Number 774177 | 5992782.4 | 2090984.4 | 37.7210305330099 | -122.467027609071 | (37.7210305330099, -122.467027609071) | 9 | 8 | 6 | 64 | 24 | ||
24422 | 36279 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 50 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1998 12:00:00 AM | Permit Number 39278 | 5991022.47129898 | 2094553.69914368 | 37.7307291972141 | -122.473371303037 | (37.7307291972141, -122.473371303037) | 9 | 8 | 4 | 64 | 40 | ||
24518 | 12493 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 307 Lake Merced Blvd | 38 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
24572 | 45317 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 630 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44154 | 5993535.31460225 | 2090042.0802024 | 37.718486580043 | -122.464356645134 | (37.718486580043, -122.464356645134) | 9 | 8 | 6 | 64 | 24 | ||
24979 | 45314 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 608 Garfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2001 12:00:00 AM | Permit Number 44151 | 5992448.25522328 | 2090519.99225245 | 37.7197360899317 | -122.468148873343 | (37.7197360899317, -122.468148873343) | 9 | 8 | 6 | 64 | 24 | ||
25018 | 66661 | Permitted Site 7 | Tree(s) :: 17 | 412 Serrano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1991 12:00:00 AM | Permit Number 29879 | 5988535.3597263 | 2090383.80933916 | 37.7191354066163 | -122.481664234181 | (37.7191354066163, -122.481664234181) | 1 | 8 | 4 | 64 | 14 | |||
25431 | 44160 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
25810 | 48572 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
25943 | 32174 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 119 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.494335637657 | (37.7296472241819, -122.494335637657) | 1 | 8 | 4 | 64 | 35 | ||
26394 | 25459 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 120 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993585.96467 | 2088543.99773 | 37.7143761240245 | -122.464072878916 | (37.7143761240245, -122.464072878916) | 9 | 8 | 6 | 64 | 24 | ||
26768 | 87705 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 899X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991284.231533 | 2091244.723898 | 37.7216587293859 | -122.472225251777 | (37.7216587293859, -122.472225251777) | 9 | 8 | 4 | 64 | 40 | ||
27360 | 11818 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 5991184.5559808 | 2089595.7938425 | 37.7171254042551 | -122.472449649239 | (37.7171254042551, -122.472449649239) | 9 | 8 | 6 | 64 | 24 | |||
27501 | 1231 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3601X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1992 12:00:00 AM | 15 | 3X3 | 5993438.31243 | 2087500.59861 | 37.7115026878867 | -122.464507504506 | (37.7115026878867, -122.464507504506) | 9 | 8 | 4 | 64 | 24 | ||
28236 | 44161 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
28244 | 67466 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 549 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/2005 12:00:00 AM | Permit Number 30980 | 5994006.31002831 | 2090251.70721897 | 37.7190893034871 | -122.462743819813 | (37.7190893034871, -122.462743819813) | 9 | 8 | 6 | 64 | 24 | ||
28574 | 53636 | Permitted Site 7 | Tree(s) :: 17 | 215 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | Permit Number 6570 | 5993455.78765847 | 2089157.6301205 | 37.7160535082268 | -122.464567348549 | (37.7160535082268, -122.464567348549) | 9 | 8 | 6 | 64 | 24 | |||
28949 | 12494 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 307 Lake Merced Blvd | 39 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
29204 | 53330 | Permitted Site 7 | Tree(s) :: 17 | 218 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1969 12:00:00 AM | Permit Number 6222 | 5992225.18083556 | 2089332.58913368 | 37.7164628840377 | -122.468833594798 | (37.7164628840377, -122.468833594798) | 9 | 8 | 6 | 64 | 24 | |||
29220 | 379 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
29239 | 45719 | Permitted Site 7 | Myoporum laetum :: Myoporum 62 | 227 Sargent St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | Permit Number 44389 | 5993425.80357844 | 2089157.89359185 | 37.7160525030782 | -122.464671006022 | (37.7160525030782, -122.464671006022) | 9 | 8 | 6 | 64 | 24 |
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) );