Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 140157 | 140157 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 82032 | 82032 | 39247 | Significant Tree 6 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3524 Jackson St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 5x10 | Permit Number 772836 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||
| 18402 | 18402 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | |||
| 103692 | 103692 | 57910 | Significant Tree 6 | Tree(s) :: 17 | 446 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1977 12:00:00 AM | Permit Number 16868 | 6003019.35193275 | 2099229.53580249 | 37.7442553690473 | -122.432230049776 | (37.7442553690473, -122.432230049776) | |||
| 101276 | 101276 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | ||
| 81071 | 81071 | 78107 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 970 GUERRERO ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005649.9 | 2103318.5 | 37.755631523761394 | -122.42342479955799 | (37.7556315237614, -122.423424799558) | ||||
| 119438 | 119438 | 78519 | Significant Tree 6 | Tree(s) :: 17 | 12 Sumner St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 3x3 | 6009421.0 | 2110873.0 | 37.776586565695894 | -122.41091663866501 | (37.7765865656959, -122.410916638665) | |||
| 10790 | 10790 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.49125558617901 | (37.735588983385, -122.491255586179) | ||
| 18877 | 18877 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | |||
| 84800 | 84800 | 84935 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | |||
| 142739 | 142739 | 84936 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | |||||
| 140164 | 140164 | 84937 | Significant Tree 6 | Tree(s) :: 17 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770120 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
| 46601 | 46601 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
| 9148 | 9148 | 85030 | Significant Tree 6 | Tree(s) :: 17 | 411 Panama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2007 12:00:00 AM | Permit Number 49384 | ||||||||
| 115908 | 115908 | 85032 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Panorama Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997300.0 | 2101977.0 | 37.7514732863106 | -122.452204440653 | (37.7514732863106, -122.452204440653) | |||||
| 125647 | 125647 | 85060 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070 California St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/03/2007 12:00:00 AM | Permit Number 49405 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 96134 | 96134 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 146084 | 146084 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 49233 | 49233 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 610 Brannan St | 1 | unknown : Cutout 12 | Tree 1 | Private 1 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.39955535858401 | (37.7766267904106, -122.399555358584) | ||||
| 119856 | 119856 | 85365 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 66 Clarendon Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49641 | 5997837.8 | 2104660.2 | 37.758871479144396 | -122.45053809231199 | (37.7588714791444, -122.450538092312) | |||
| 119287 | 119287 | 85367 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1990 09th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49643 | 5993523.3 | 2101996.8 | 37.7513105791605 | -122.46526605884199 | (37.7513105791605, -122.465266058842) | |||
| 97229 | 97229 | 85428 | Significant Tree 6 | Tree(s) :: 17 | 43 Ora Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/23/2007 12:00:00 AM | Permit Number 49665 | 6001553.3 | 2098294.6 | 37.741605021987205 | -122.437232403771 | (37.7416050219872, -122.437232403771) | |||
| 84949 | 84949 | 86910 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 1 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49875 | 5993901.0 | 2092133.0 | 37.7242488135215 | -122.463244271267 | (37.7242488135215, -122.463244271267) | |||
| 126839 | 126839 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 89763 | 89763 | 87191 | Significant Tree 6 | Tree(s) :: 17 | 640 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | Permit Number 50212 | 5995439.0 | 2093622.0 | 37.7284257331327 | -122.458035371987 | (37.7284257331327, -122.458035371987) | |||
| 83923 | 83923 | 87197 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 617 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50213 | 6003760.0 | 2104634.0 | 37.7591367256626 | -122.43005450480699 | (37.7591367256626, -122.430054504807) | ||||
| 87738 | 87738 | 87239 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330.0 | 2096776.0 | 37.737422605415205 | -122.43789575270901 | (37.7374226054152, -122.437895752709) | |||
| 122346 | 122346 | 87242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 4131 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 50271 | 5994116.9 | 2112250.5 | 37.779498769084604 | -122.46395756623998 | (37.7794987690846, -122.46395756624) | ||||
| 81076 | 81076 | 88608 | Significant Tree 6 | Tree(s) :: 17 | 350 Urbano Dr | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | Permit Number 51562 | 5991996.0 | 2092560.0 | 37.72531132011171 | -122.46986059313801 | (37.7253113201117, -122.469860593138) | |||
| 2184 | 2184 | 89309 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 117541 | 117541 | 91106 | Significant Tree 6 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | On campus | Permit Number 51996 | 5995208.0 | 2110277.0 | 37.774142880877704 | -122.46004000497801 | (37.7741428808777, -122.460040004978) | ||
| 110474 | 110474 | 91110 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2650 Turk Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | On Campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 83580 | 83580 | 92310 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2591 26th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3x3 | 5988279.0 | 2097698.2 | 37.7392039339278 | -122.48308618722099 | (37.7392039339278, -122.483086187221) | ||
| 108780 | 108780 | 92311 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2211 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5986022.3 | 2100155.2 | 37.7458186185696 | -122.491069496457 | (37.7458186185696, -122.491069496457) | |
| 12363 | 12363 | 92312 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2711 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985822.132 | 2096946.3119 | 37.7369961745626 | -122.49152548244 | (37.7369961745626, -122.49152548244) | |
| 10899 | 10899 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | |
| 13114 | 13114 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511002 | (37.7355642757438, -122.49142378511) | |
| 80217 | 80217 | 92320 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2733 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5984522.0 | 2096783.0 | 37.736471699686206 | -122.49600850837099 | (37.7364716996862, -122.496008508371) | |
| 125036 | 125036 | 92852 | Significant Tree 6 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 3794 16th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901.0 | 2106436.0 | 37.76397911869721 | -122.436612788339 | (37.7639791186972, -122.436612788339) | |||
| 119166 | 119166 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 144783 | 144783 | 92909 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | 11 | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | ||
| 121713 | 121713 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | ||||
| 103620 | 103620 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 86337 | 86337 | 93221 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788.0 | 2100441.0 | 37.7470540096767 | -122.46423776520399 | (37.7470540096767, -122.464237765204) | |||
| 103966 | 103966 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 145389 | 145389 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 744 Carolina St | 1 | : 4 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.759318660176504 | -122.40041614875601 | (37.7593186601765, -122.400416148756) | |||
| 91679 | 91679 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 265 Dorland St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003831.0 | 2105693.0 | 37.7620485075454 | -122.42988449123301 | (37.7620485075454, -122.429884491233) | |||||
| 53190 | 53190 | 94850 | Significant Tree 6 | Tree(s) :: 17 | 1107 Bowdoin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | Permit Number 53929 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | |||
| 123752 | 123752 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Vasquez Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | |||||
| 129210 | 129210 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 577 Sanchez St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6003673.0 | 2104901.0 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | |||||
| 93937 | 93937 | 96184 | Significant Tree 6 | Tree(s) :: 17 | 333 Harrison St | 1 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | Permit Number 767224 | 6015127.7 | 2114620.1 | 37.7871935976335 | -122.39143736362 | (37.7871935976335, -122.39143736362) | ||||
| 145258 | 145258 | 96222 | Significant Tree 6 | Tree(s) :: 17 | 176 Holladay Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767739 | 6010842.9 | 2100101.6 | 37.7470903528282 | -122.405239158587 | (37.7470903528282, -122.405239158587) | |
| 143568 | 143568 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||||
| 18031 | 18031 | 96327 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 296 Randall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 767829 | 6003708.0 | 2097940.0 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | ||||
| 123568 | 123568 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 184 Edgewood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632.0 | 2105999.0 | 37.76247839448661 | -122.45480501488301 | (37.7624783944866, -122.454805014883) | |||
| 93681 | 93681 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 768245 | 6003236.0 | 2116309.0 | 37.7911636966224 | -122.43270073645701 | (37.7911636966224, -122.432700736457) | |||
| 141687 | 141687 | 96779 | Significant Tree 6 | Tree(s) :: 17 | 555 Melrose Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/18/2011 12:00:00 AM | Permit Number 767966 | 5996882.6 | 2095364.1 | 37.7332919614683 | -122.45317051411999 | (37.7332919614683, -122.45317051412) | |||
| 95902 | 95902 | 96835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 6001 Geary Blvd | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5988352.4 | 2112527.1 | 37.779924341439 | -122.483919468894 | (37.779924341439, -122.483919468894) | |||||
| 88420 | 88420 | 96906 | Significant Tree 6 | Ulmus 'Frontier' :: Frontier Elm 464 | 1155@Sansome Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | ||
| 103074 | 103074 | 97264 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | Permit Number 768179 | 6016549.1 | 2098591.6 | 37.743261569489704 | -122.38540219642401 | (37.7432615694897, -122.385402196424) | |||
| 75150 | 75150 | 97534 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 203 Surrey St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768282 | 6002070.0 | 2096079.6 | 37.73555250464221 | -122.435287431957 | (37.7355525046422, -122.435287431957) | ||||
| 82219 | 82219 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||||
| 124878 | 124878 | 97955 | Significant Tree 6 | Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 530 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | |||
| 92420 | 92420 | 98038 | Significant Tree 6 | Tree(s) :: 17 | 147 Lake St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/09/2011 12:00:00 AM | Permit Number 768423 | 5994977.2 | 2114852.5 | 37.7866927029397 | -122.461170103848 | (37.7866927029397, -122.461170103848) | |||
| 83253 | 83253 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878001 | (37.7199132334677, -122.45865940878) | |||||
| 95713 | 95713 | 98156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 149x Chaves Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | |||||
| 151501 | 151501 | 98241 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3760 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/10/2012 12:00:00 AM | 9 | Permit Number 768462 | 5996814.4677800005 | 2115674.0493799997 | 37.7890540175629 | -122.45487301496999 | (37.7890540175629, -122.45487301497) | ||
| 59539 | 59539 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 241 | 901 Bay St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | ||||
| 142723 | 142723 | 98301 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 126156 | 126156 | 98308 | Significant Tree 6 | Tree(s) :: 17 | 1490 Fairfax Ave | 1 | Front Yard : 25 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3x3 | Permit Number 768575 | 6016246.6 | 2097899.9 | 37.7413455620636 | -122.386399955147 | (37.7413455620636, -122.386399955147) | ||
| 66105 | 66105 | 98309 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 401X Newhall St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 6 | 3x3 | 6016081.14502 | 2097910.9401599998 | 37.741366715992896 | -122.386972815546 | (37.7413667159929, -122.386972815546) | |||
| 82114 | 82114 | 98455 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 189 | 2200 22nd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6011565.2 | 2103754.7 | 37.7571613219705 | -122.402998394603 | (37.7571613219705, -122.402998394603) | |||||
| 142025 | 142025 | 98491 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 169 | 55X Perine Pl | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | Permit Number 768655 | 6002130.5 | 2115544.8 | 37.7890026421633 | -122.436471006098 | (37.7890026421633, -122.436471006098) | ||||
| 95709 | 95709 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004211.7 | 2116183.0 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | |||||
| 105359 | 105359 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 81929 | 81929 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 98982 | 98982 | 98757 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 340 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993579.1 | 2100062.8 | 37.7460035255592 | -122.464932655613 | (37.7460035255592, -122.464932655613) | |||||
| 85680 | 85680 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | |||||
| 112243 | 112243 | 99098 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 66 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2012 12:00:00 AM | Permit Number 768466 | 5993736.6 | 2097303.5 | 37.7384362612216 | -122.464187762983 | (37.7384362612216, -122.464187762983) | |||
| 138786 | 138786 | 99099 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 65X Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2012 12:00:00 AM | Permit Number 768467 | 5993743.4 | 2097365.9 | 37.7386079879791 | -122.464168780849 | (37.7386079879791, -122.464168780849) | |||
| 85026 | 85026 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993700.7 | 2097327.0 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | |||||
| 116375 | 116375 | 99101 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 55x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | 04/07/2012 12:00:00 AM | Permit Number 768464 | 5993693.6 | 2097654.3 | 37.739396991894104 | -122.464361897304 | (37.7393969918941, -122.464361897304) | |||
| 126121 | 126121 | 99105 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400@ Mendell Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404.0 | 2098045.1 | 37.741752963260105 | -122.38586583443899 | (37.7417529632601, -122.385865834439) | |||
| 47419 | 47419 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 845 Marina Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | ||
| 89463 | 89463 | 99299 | Significant Tree 6 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 1457 Willard St | 1 | Front Yard : 25 | Tree 1 | Private 1 | 05/02/2012 12:00:00 AM | Permit Number 768720 | 5996809.7 | 2106270.3 | 37.763233506694 | -122.454210015753 | (37.763233506694, -122.454210015753) | |||
| 145280 | 145280 | 99376 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 1088 Ashbury St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 768767 | 5998994.0 | 2106195.0 | 37.7631517661679 | -122.44664985791401 | (37.7631517661679, -122.446649857914) | ||||
| 80154 | 80154 | 99623 | Significant Tree 6 | Tree(s) :: 17 | 380 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/23/2012 12:00:00 AM | Permit Number 768850 | 6013171.4 | 2105301.7 | 37.7614986071193 | -122.39755199325701 | (37.7614986071193, -122.397551993257) | |||
| 96590 | 96590 | 99643 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 1268 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6006289.0 | 2120073.0 | 37.8016713630652 | -122.42240499597 | (37.8016713630652, -122.42240499597) | ||||
| 144598 | 144598 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1337 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.46483277796801 | (37.7396363671104, -122.464832777968) | |||||
| 124001 | 124001 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 118375 | 118375 | 99733 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 145 Irving St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | |||
| 139692 | 139692 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Cascade Walk | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | |||||
| 143868 | 143868 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 92947 | 92947 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398@Steiner Broadway | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 99634 | 99634 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991942.0 | 2105939.0 | 37.7620435090796 | -122.47102148161501 | (37.7620435090796, -122.471021481615) | |||||
| 89880 | 89880 | 99852 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 86 Nordhoff St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000395.0 | 2095652.0 | 37.734283150969794 | -122.44104786104499 | (37.7342831509698, -122.441047861045) | |||||
| 81326 | 81326 | 99859 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4443 19th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.43893032447399 | (37.7589248414166, -122.438930324474) | ||||
| 119155 | 119155 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 1636 Bush St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665.0 | 2115204.0 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | |||
| 166020 | 166020 | 99921 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1740 Jones St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");