trees
194,517 rows 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4132 | 78489 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3345 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988664.39778 | 2095197.91873 | 37.7323612287764 | -122.481570599508 | (37.7323612287764, -122.481570599508) | 1 | 8 | 4 | 64 | 35 | |||
4140 | 260407 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Brotherhood Way | 5 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
4153 | 19360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992081.20032 | 2089838.16122 | 37.7178427427344 | -122.469368036824 | (37.7178427427344, -122.469368036824) | 9 | 8 | 6 | 64 | 24 | |||
4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
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 | ||
4254 | 254282 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80X Junipero Serra Blvd | 6 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
4289 | 78450 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2930 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5990007.36558 | 2095749.13449 | 37.7339527248253 | -122.476967960997 | (37.7339527248253, -122.476967960997) | 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 | ||
4542 | 31195 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 260 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1995 12:00:00 AM | 6 | Permit Number 34888 | 5992024.42182 | 2086737.21442 | 37.7093250109181 | -122.469338707216 | (37.7093250109181, -122.469338707216) | 9 | 8 | 4 | 64 | 24 | ||
4543 | 206871 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 167 | : | Tree | Private 2 | 28 | Width 0ft | 5991178.39011 | 2091334.01969 | 37.7218977876304 | -122.472597620991 | (37.7218977876304, -122.472597620991) | 9 | 8 | 4 | 64 | 40 | |||
4569 | 104897 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 303 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
4676 | 204157 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900 Junipero Serra Blvd | 109 | : | Tree | Private 2 | 2 | Width 0ft | 5991141.76494 | 2090345.59901 | 37.7191817082419 | -122.472652193669 | (37.7191817082419, -122.472652193669) | 9 | 8 | 4 | 64 | 40 | |||
4684 | 219541 | DPW Maintained 1 | Ulmus americana :: American Elm 74 | 300 Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5991386.1412 | 2094492.53294 | 37.7305823023089 | -122.472109594875 | (37.7305823023089, -122.472109594875) | 9 | 8 | 4 | 64 | 40 | |||
4735 | 262469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 35 Broadmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2x6 | 5991096 | 2093545 | 37.7279638199594 | -122.4730435743 | (37.7279638199594, -122.4730435743) | 9 | 8 | 4 | 64 | 40 | ||||
4737 | 261021 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
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 | ||
4912 | 261377 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 4x10 | Permit Number 784883 | 5988814.87181 | 2095155.07295 | 37.7322523337557 | -122.481047245899 | (37.7322523337557, -122.481047245899) | 1 | 8 | 4 | 64 | 35 | |
4918 | 104883 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990322.1 | 2090011.1 | 37.7182157760013 | -122.475461023549 | (37.7182157760013, -122.475461023549) | 1 | 8 | 4 | 64 | 14 | |||||
4970 | 43860 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 2 | Permit Number 43480 | 5986156.5709 | 2096489.2942 | 37.7357608636081 | -122.490335583477 | (37.7357608636081, -122.490335583477) | 1 | 8 | 3 | 64 | 35 | |
4977 | 11672 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 710X Junipero Serra Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991310.6193982 | 2092985.752428 | 37.7264406890913 | -122.472260886614 | (37.7264406890913, -122.472260886614) | 9 | 8 | 4 | 64 | 40 | ||
5037 | 215607 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 47 | : | Tree | Private 2 | 2 | Width 0ft | 5991157.54734 | 2090681.21679 | 37.7201041455671 | -122.472622096933 | (37.7201041455671, -122.472622096933) | 9 | 8 | 4 | 64 | 40 | |||
5273 | 218292 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Woodacre Dr | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 5991223.38049 | 2095418.74528 | 37.7331160279643 | -122.472739784911 | (37.7331160279643, -122.472739784911) | 1 | 8 | 4 | 64 | 40 | ||||
5288 | 260453 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 4 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
5486 | 203905 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5000 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 8ft | 5990628.48581 | 2093315.14661 | 37.7273056215527 | -122.474642998573 | (37.7273056215527, -122.474642998573) | 9 | 8 | 4 | 64 | 40 | |||
5522 | 185128 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200x Sloat Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5987683.0779 | 2095922.3154 | 37.7342931239465 | -122.48501633511 | (37.7342931239465, -122.48501633511) | 1 | 8 | 4 | 64 | 35 | |||
5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
5750 | 177827 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 10 Brotherhood Way | 5 | : | Tree | Private 2 | 22 | Width 0ft | 5993584.63921 | 2087685.05468 | 37.7120175945993 | -122.46401514608 | (37.7120175945993, -122.46401514608) | 9 | 8 | 4 | 64 | 24 | |||
5781 | 207615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | 9 | 8 | 6 | 64 | 24 | |||
5826 | 78490 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3345 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988631.47552 | 2095196.82107 | 37.7323563004975 | -122.481684337683 | (37.7323563004975, -122.481684337683) | 1 | 8 | 4 | 64 | 35 | |||
5880 | 45506 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2951 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 8 | Permit Number 44275 | 5989055.4293 | 2095588.48174 | 37.7334563440261 | -122.48024730379 | (37.7334563440261, -122.48024730379) | 1 | 8 | 4 | 64 | 35 | |
5991 | 217563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4050 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5991900.5999 | 2088650.2079 | 37.714570473344 | -122.469905841257 | (37.714570473344, -122.469905841257) | 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 | ||
6030 | 19323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5993467.32802 | 2089853.93143 | 37.7179660496774 | -122.4645779904 | (37.7179660496774, -122.4645779904) | 9 | 8 | 6 | 64 | 24 | |||
6044 | 259265 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
6047 | 204081 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 681 Head St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5993497.95379 | 2090430.17226 | 37.7195500336733 | -122.464513948782 | (37.7195500336733, -122.464513948782) | 9 | 8 | 6 | 64 | 24 | |||
6145 | 117568 | Undocumented 4 | Tree(s) :: 17 | 2636 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990923 | 2095039.4 | 37.7320570487265 | -122.473750606168 | (37.7320570487265, -122.473750606168) | 1 | 8 | 4 | 64 | 40 | |||||
6148 | 78981 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3010 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988598.26688 | 2095139.6319 | 37.7321973426185 | -122.481794958792 | (37.7321973426185, -122.481794958792) | 1 | 8 | 4 | 64 | 35 | |||
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 | ||
6176 | 217849 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Woodacre Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | 5991387.06493 | 2095679.62189 | 37.7338418033391 | -122.47219289908 | (37.7338418033391, -122.47219289908) | 1 | 8 | 4 | 64 | 40 | ||||
6226 | 261544 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Sloat Blvd | 1 | Median : Cutout | Tree | Private 2 | 10x10 | 5989247 | 2095899 | 37.7343200773404 | -122.47960770916 | (37.7343200773404, -122.47960770916) | 1 | 8 | 4 | 64 | 35 | ||||
6249 | 211394 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 37 | : | Tree | Private 2 | 7 | Width 0ft | 5991385.47593 | 2094405.95622 | 37.7303445458499 | -122.472105586627 | (37.7303445458499, -122.472105586627) | 9 | 8 | 4 | 64 | 40 | |||
6364 | 264920 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
6387 | 114260 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
6438 | 29970 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991349.07674 | 2093718.94394 | 37.7284560756763 | -122.472181363504 | (37.7284560756763, -122.472181363504) | 9 | 8 | 4 | 64 | 40 | ||
6439 | 185119 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200x Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 5987585.1902 | 2095924.1623 | 37.7342924927912 | -122.485354895586 | (37.7342924927912, -122.485354895586) | 1 | 8 | 4 | 64 | 35 | |||
6522 | 78477 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3070 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989117.06351 | 2094903.92163 | 37.7315802988954 | -122.479984139656 | (37.7315802988954, -122.479984139656) | 1 | 8 | 4 | 64 | 35 | |||
6523 | 43820 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2820 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 6 | Permit Number 43449 | 5985887.7993 | 2096200.3581 | 37.7349518205684 | -122.491243560491 | (37.7349518205684, -122.491243560491) | 1 | 8 | 3 | 64 | 35 | |
6656 | 258684 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/06/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782190 | 5990522.43491 | 2094710.12159 | 37.7311297256611 | -122.475111403646 | (37.7311297256611, -122.475111403646) | 1 | 8 | 4 | 64 | 35 | |
6706 | 255369 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Brotherhood Way | 4 | Median : Cutout | Tree | DPW 1 | 14x10 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
6708 | 256455 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2901 Sunset Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
6733 | 208696 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993735.7088 | 2088773.52296 | 37.7150149747485 | -122.463571955684 | (37.7150149747485, -122.463571955684) | 9 | 8 | 6 | 64 | 24 | |||
6775 | 256471 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
6794 | 213749 | DPW Maintained 1 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 | 300 Junipero Serra Blvd | 35 | : | Tree | Private 2 | 3 | Width 0ft | 5991393.22767 | 2094416.18381 | 37.730373076833 | -122.472079533242 | (37.730373076833, -122.472079533242) | 9 | 8 | 4 | 64 | 40 | |||
6823 | 11708 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991296.5308 | 2092759.13423 | 37.7258176365683 | -122.472293077282 | (37.7258176365683, -122.472293077282) | 9 | 8 | 4 | 64 | 40 | ||
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 | |||
6915 | 116579 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | |||
7147 | 260402 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Arch St | 1 | Median : Yard | Tree | DPW 1 | 3X5 | 5992587 | 2087523 | 37.7115150847083 | -122.467451465905 | (37.7115150847083, -122.467451465905) | 9 | 8 | 4 | 64 | 24 | ||||
7171 | 203639 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5992221.12373 | 2089294.63928 | 37.7163584485498 | -122.468844858017 | (37.7163584485498, -122.468844858017) | 9 | 8 | 6 | 64 | 24 | |||
7206 | 264879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 94 Stratford Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x6 | 5990921 | 2091777 | 37.7230991995598 | -122.473519640019 | (37.7230991995598, -122.473519640019) | 9 | 8 | 4 | 64 | 40 | ||||
7283 | 176114 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 10 Zoo Rd | 1 | Front Yard : Yard | Tree | Private 2 | 24 | Width 10ft | 5982696.49512 | 2094384.4536 | 37.7297788507039 | -122.502142508582 | (37.7297788507039, -122.502142508582) | 1 | 8 | 4 | 64 | 14 | |||
7373 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
7404 | 210734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 270 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992990.46687 | 2089001.91036 | 37.7155991032881 | -122.466164394482 | (37.7155991032881, -122.466164394482) | 9 | 8 | 6 | 64 | 24 | |||
7457 | 2165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.7142100327703 | -122.463817234952 | (37.7142100327703, -122.463817234952) | 9 | 8 | 6 | 64 | 24 | ||
7536 | 262249 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 4210 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | ||||
7557 | 206861 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 89 | : | Tree | Private 2 | 15 | Width 0ft | 5991235.10134 | 2092148.32282 | 37.7241369448505 | -122.47246092223 | (37.7241369448505, -122.47246092223) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
7646 | 78478 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2987 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988808.95801 | 2095345.98814 | 37.7327761939684 | -122.481081665112 | (37.7327761939684, -122.481081665112) | 1 | 8 | 4 | 64 | 35 | |||
7676 | 78416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2959 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5990231.30854 | 2095554.29925 | 37.7334307457305 | -122.47617950378 | (37.7334307457305, -122.47617950378) | 1 | 8 | 4 | 64 | 35 | |||
7796 | 264921 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
7850 | 204156 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 900 Junipero Serra Blvd | 106 | : | Tree | Private 2 | 3 | Width 0ft | 5991140.12525 | 2090380.53407 | 37.7192775364035 | -122.472660407165 | (37.7192775364035, -122.472660407165) | 9 | 8 | 4 | 64 | 40 | |||
7863 | 260451 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 2 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
7881 | 260404 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Brotherhood Way | 2 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
7929 | 212670 | DPW Maintained 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 215 Garfield St | 1 | : | Tree | Private 2 | 04/09/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785243 | 5993431.79105 | 2090458.25949 | 37.7196233401385 | -122.464744686025 | (37.7196233401385, -122.464744686025) | 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 | |
7938 | 369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3690X 19th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 25 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
7959 | 205335 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 134 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5991702.38493 | 2089452.42364 | 37.7167617027762 | -122.470649341406 | (37.7167617027762, -122.470649341406) | 9 | 8 | 6 | 64 | 24 | |||
8004 | 176122 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3500 Great Hwy | 9 | Median : | Tree | Private 2 | 3 | Width 0ft | 5982330.17471 | 2092783.08412 | 37.7253603924579 | -122.503290375351 | (37.7253603924579, -122.503290375351) | 1 | 8 | 4 | 64 | 14 | |||
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 | ||
8115 | 204074 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 216 Arch St | 3 | : | Tree | Private 2 | 3 | Width 3ft | Permit Number 767875 | 5992726.806 | 2088618.30959 | 37.7145306124731 | -122.467047845297 | (37.7145306124731, -122.467047845297) | 9 | 8 | 6 | 64 | 24 | ||
8278 | 258683 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/06/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782190 | 5990522.43491 | 2094710.12159 | 37.7311297256611 | -122.475111403646 | (37.7311297256611, -122.475111403646) | 1 | 8 | 4 | 64 | 35 | |
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 | ||||
8370 | 264916 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 744 Junipero Serra Blvd | 1 | Median : Yard | Tree | Private 2 | 10x10 | 5991301 | 2092678 | 37.7255951208098 | -122.472271716 | (37.7255951208098, -122.472271716) | 9 | 8 | 4 | 64 | 40 | ||||
8394 | 206864 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700 Junipero Serra Blvd | 108 | : | Tree | Private 2 | 16 | Width 0ft | 5991230.74264 | 2091941.55129 | 37.7235689492395 | -122.472460922234 | (37.7235689492395, -122.472460922234) | 9 | 8 | 4 | 64 | 40 | |||
8398 | 43819 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2820 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 4 | Permit Number 43449 | 5985888.33 | 2096214.1549 | 37.7349897339382 | -122.491242740777 | (37.7349897339382, -122.491242740777) | 1 | 8 | 3 | 64 | 35 | |
8504 | 109669 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 200X GELLERT DR | 33 | Median : Cutout | Tree | DPW 1 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||
8537 | 78846 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 259 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992056.72748 | 2086721.95578 | 37.7092849811889 | -122.469225944831 | (37.7092849811889, -122.469225944831) | 9 | 8 | 4 | 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 | ||
8587 | 260455 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 6 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
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 | |||
8634 | 176044 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5990534.22824 | 2089263.30634 | 37.7161748133009 | -122.474673246391 | (37.7161748133009, -122.474673246391) | 1 | 8 | 4 | 64 | 14 | ||||
8736 | 256444 | Undocumented 4 | Alnus rubra :: Red Alder 325 | 3001 Sunset Blvd | 28 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
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 | ||
8816 | 177939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | 1 | 8 | 4 | 64 | 14 | ||||
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 | |||
8847 | 110165 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 129x GARCES DR | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||||
8859 | 118364 | Undocumented 4 | Magnolia x soulangiana :: Saucer Magnolia 147 | 226 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5991730 | 2090049 | 37.7184013526744 | -122.470597317131 | (37.7184013526744, -122.470597317131) | 9 | 8 | 6 | 64 | 24 | |||
8932 | 254133 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100X Lake Merced Blvd | 7 | Median : Yard | Tree | DPW 1 | 10x10 | 5983894 | 2095251 | 37.7322284370415 | -122.498066633405 | (37.7322284370415, -122.498066633405) | 1 | 8 | 4 | 64 | 35 | ||||
8965 | 261020 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
9033 | 254440 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501X Brotherhood Way | 20 | Median : Yard | Tree | DPW 1 | 10x10 | 5992686 | 2087818 | 37.7123307991194 | -122.467130733446 | (37.7123307991194, -122.467130733446) | 9 | 8 | 4 | 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) );