Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10780 | 10780 | 26783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010951.9721 | 2087077.0783 | 37.711333837408205 | -122.40394559103301 | (37.7113338374082, -122.403945591033) | |||
73533 | 73533 | 196401 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 403 06th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011437.38165 | 2110998.36777 | 37.7770436561708 | -122.40395017576701 | (37.7770436561708, -122.403950175767) | |||
13116 | 13116 | 26784 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665236999 | (37.7113704740421, -122.40402665237) | |||
10565 | 10565 | 94985 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010907.8555 | 2087101.5876 | 37.7113986701374 | -122.40409979381799 | (37.7113986701374, -122.404099793818) | |||
109105 | 109105 | 111662 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011203.0 | 2102078.0 | 37.752537241421706 | -122.404133028772 | (37.7525372414217, -122.404133028772) | ||||
176610 | 176610 | 135908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | |||
47397 | 47397 | 135909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011530.70294 | 2119058.88107 | 37.79918113116 | -122.40419478595501 | (37.79918113116, -122.404194785955) | ||||
11522 | 11522 | 94986 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010873.097 | 2087120.3037 | 37.711448118617 | -122.404221245197 | (37.711448118617, -122.404221245197) | |||
11772 | 11772 | 95029 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 13 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010870.6461 | 2087075.073 | 37.71132378726 | -122.40422653482 | (37.71132378726, -122.40422653482) | |||
76848 | 76848 | 135910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6011521.095380001 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | ||||
57598 | 57598 | 43283 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.3857900002 | 37.72114734204379 | -122.404247572584 | (37.7211473420438, -122.404247572584) | |
65666 | 65666 | 135911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6011511.78534 | 2119057.5389799997 | 37.7991763890443 | -122.404260153176 | (37.7991763890443, -122.404260153176) | ||||
12055 | 12055 | 95028 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 21 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010854.6037 | 2087083.0942 | 37.711344915432 | -122.404282545919 | (37.711344915432, -122.404282545919) | |||
11422 | 11422 | 26785 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.40431164223101 | (37.7114882765061, -122.404311642231) | ||
131299 | 131299 | 135912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011493.6768 | 2119059.8121 | 37.7991816185927 | -122.40432297534402 | (37.7991816185927, -122.404322975344) | ||||
11844 | 11844 | 95027 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 29 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010839.0069 | 2087091.1154 | 37.711366068478 | -122.404337016935 | (37.711366068478, -122.404337016935) | |||
146957 | 146957 | 135913 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011476.8778099995 | 2119044.52353 | 37.7991387011458 | -122.404380029217 | (37.7991387011458, -122.404380029217) | ||||
143612 | 143612 | 94987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 36 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2015 03:25:00 PM | 3 | 3x3 | 6010827.4 | 2087210.2 | 37.711692402207106 | -122.40438551024401 | (37.7116924022071, -122.404385510244) | ||
187101 | 187101 | 196396 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011313.59863 | 2111303.12635 | 37.7778735361758 | -122.404399838608 | (37.7778735361758, -122.404399838608) | |||
35260 | 35260 | 135914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 6011471.49553 | 2119063.8107 | 37.7991913582649 | -122.404400012157 | (37.7991913582649, -122.404400012157) | |||
11927 | 11927 | 52333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2005 12:00:00 AM | 3 | Permit Number 48484 | 6010821.8504 | 2087147.4867 | 37.7115198939825 | -122.40440027981701 | (37.7115198939825, -122.404400279817) | ||
3617 | 3617 | 196400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380x Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011308.09655 | 2111275.91215 | 37.7777985048225 | -122.404416956276 | (37.7777985048225, -122.404416956276) | |||
11754 | 11754 | 95026 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 33 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010809.5958 | 2087105.821 | 37.7114048035242 | -122.404439704211 | (37.7114048035242, -122.404439704211) | |||
133839 | 133839 | 196397 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011301.22079 | 2111291.73097 | 37.7778415553936 | -122.404441855801 | (37.7778415553936, -122.404441855801) | |||
169098 | 169098 | 196399 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011297.10381 | 2111266.2805 | 37.7777714442324 | -122.404454306035 | (37.7777714442324, -122.404454306035) | |||
179102 | 179102 | 196398 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Clara St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011290.67787 | 2111282.0901599997 | 37.7778144947827 | -122.404477648835 | (37.7778144947827, -122.404477648835) | |||
12802 | 12802 | 26786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 34 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6010794.6675 | 2087161.3009 | 37.7115563058928 | -122.404495203342 | (37.7115563058928, -122.404495203342) | |||
12814 | 12814 | 95025 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 37 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010791.7709 | 2087116.9615 | 37.7114343969477 | -122.40450209567699 | (37.7114343969477, -122.404502095677) | |||
11853 | 11853 | 94988 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 38 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010771.4951 | 2087173.3327 | 37.711588047755605 | -122.40457614013901 | (37.7115880477556, -122.404576140139) | |||
12283 | 12283 | 95024 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | |||
10438 | 10438 | 95023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 45 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010750.3281 | 2087136.1233 | 37.711484695229295 | -122.404646681546 | (37.7114846952293, -122.404646681546) | |||
78401 | 78401 | 49775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
92628 | 92628 | 49774 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 996@ ORDWAY Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46561 | 6010806.40404101 | 2090031.53281179 | 37.7194380356715 | -122.404656566431 | (37.7194380356715, -122.404656566431) | ||
57208 | 57208 | 52827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 750WASHINGTON Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | 3x3 | Permit Number 48852 | 6011323.0636 | 2117546.9613 | 37.7950181606921 | -122.40480679182501 | (37.7950181606921, -122.404806791825) | |
176061 | 176061 | 52828 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 750WASHINGTON Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | Permit Number 48852 | 6011319.3348 | 2117592.1734 | 37.79514209381671 | -122.404822878731 | (37.7951420938167, -122.404822878731) | ||
11741 | 11741 | 94992 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010640.4822 | 2087242.4042 | 37.7117703812114 | -122.40503381823 | (37.7117703812114, -122.40503381823) | |||
11288 | 11288 | 95020 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 57 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010631.1241 | 2087198.2876 | 37.711648722790706 | -122.40506305817699 | (37.7116487227907, -122.405063058177) | |||
11451 | 11451 | 94993 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010619.538 | 2087251.7622 | 37.711794905553106 | -122.405106866024 | (37.7117949055531, -122.405106866024) | |||
11165 | 11165 | 95019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010608.3974 | 2087210.3194 | 37.7116804891797 | -122.40514245485001 | (37.7116804891797, -122.40514245485) | |||
86294 | 86294 | 45257 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 7 Wright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44104 | 6010859.79719356 | 2100178.97510993 | 37.7473037526941 | -122.405186176837 | (37.7473037526941, -122.405186176837) | ||
10592 | 10592 | 26788 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 78 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3X3 | 6010596.3656 | 2087261.1203 | 37.711819305554 | -122.40518761518801 | (37.711819305554, -122.405187615188) | ||
11845 | 11845 | 95018 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010587.8988 | 2087221.4599 | 37.7117099327517 | -122.40521408790899 | (37.7117099327517, -122.405214087909) | |||
10400 | 10400 | 94994 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 82 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010574.5301 | 2087274.9346 | 37.7118560160688 | -122.405264057289 | (37.7118560160688, -122.405264057289) | |||
11612 | 11612 | 95017 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010561.1615 | 2087236.1655 | 37.7117488165229 | -122.40530753468501 | (37.7117488165229, -122.405307534685) | |||
10788 | 10788 | 94995 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010547.3472 | 2087288.7489 | 37.711892427555796 | -122.40535898167299 | (37.7118924275558, -122.405358981673) | |||
10403 | 10403 | 95015 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010521.9467 | 2087254.8816 | 37.711798014587295 | -122.40544438972 | (37.7117980145873, -122.40544438972) | ||||
12328 | 12328 | 26789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2010 12:00:00 AM | 3 | 3X3 | 6010520.1642 | 2087302.5632 | 37.7119288389604 | -122.40545390649599 | (37.7119288389604, -122.405453906496) | ||
11545 | 11545 | 26790 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | ||
181207 | 181207 | 92543 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 137 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52887 | 6010552.68366 | 2094065.4210599998 | 37.7305000701252 | -122.40581758561001 | (37.7305000701252, -122.40581758561) | |
10354 | 10354 | 95012 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | 6010407.8674 | 2087313.2581 | 37.7119519253908 | -122.40584279071301 | (37.7119519253908, -122.405842790713) | ||
34554 | 34554 | 92542 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 129 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52886 | 6010542.11041 | 2094099.98718 | 37.730594390103505 | -122.40585657301901 | (37.7305943901035, -122.405856573019) | |
157170 | 157170 | 178964 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 129 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010537.280619999 | 2094115.27956 | 37.7306361096482 | -122.40587434723 | (37.7306361096482, -122.40587434723) | |||
12918 | 12918 | 26791 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.712098157972605 | -122.40588352001801 | (37.7120981579726, -122.405883520018) | ||
50603 | 50603 | 43244 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 148 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52907 | 6010526.7074 | 2094001.3390799998 | 37.7303226617554 | -122.405902877341 | (37.7303226617554, -122.405902877341) | |
11042 | 11042 | 26800 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 5 | 3x3 | 6010377.1195 | 2087327.5180000002 | 37.7119893605537 | -122.40595006858901 | (37.7119893605537, -122.405950068589) | ||
11078 | 11078 | 94996 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 116 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010370.4352 | 2087379.2102 | 37.7121309230244 | -122.405976810763 | (37.7121309230244, -122.405976810763) | |||
80652 | 80652 | 33821 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 56 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/1985 12:00:00 AM | Permit Number 37837 | 6010417.94927739 | 2089844.96936421 | 37.7189040522027 | -122.40598618211901 | (37.7189040522027, -122.405986182119) | |||
182711 | 182711 | 91520 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 520 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52125 | 6011001.0511 | 2118999.3767 | 37.7989881374692 | -122.406023377789 | (37.7989881374692, -122.406023377789) | |
89041 | 89041 | 84214 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
112903 | 112903 | 84224 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
13045 | 13045 | 26792 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 128 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2002 12:00:00 AM | 3 | 3x3 | 6010340.5785 | 2087395.6982 | 37.7121745258223 | -122.40608116557199 | (37.7121745258223, -122.406081165572) | ||
11181 | 11181 | 95011 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010324.7589 | 2087356.7063 | 37.7120665771229 | -122.406133097694 | (37.7120665771229, -122.406133097694) | |||
97005 | 97005 | 42206 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Decatur St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42477 | 6010764.11568001 | 2109415.80056324 | 37.772660655142005 | -122.40616769997101 | (37.772660655142, -122.406167699971) | |||
108658 | 108658 | 42207 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Decatur St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42477 | 6010764.11568001 | 2109415.80056324 | 37.772660655142005 | -122.40616769997101 | (37.772660655142, -122.406167699971) | ||
12239 | 12239 | 95010 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010304.2603 | 2087368.7381 | 37.7120984674199 | -122.406204794273 | (37.7120984674199, -122.406204794273) | |||
12999 | 12999 | 94997 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010302.5304 | 2087413.7951 | 37.7122220880479 | -122.40621394582399 | (37.7122220880479, -122.406213945824) | |||
12450 | 12450 | 26799 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010285.5441 | 2087377.2049 | 37.7121206686095 | -122.40627007937 | (37.7121206686095, -122.40627007937) | |||
12883 | 12883 | 26798 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010259.698 | 2087389.6823 | 37.71215348320929 | -122.406360290051 | (37.7121534832093, -122.406360290051) | |||
46224 | 46224 | 91571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 511 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52143 | 6010245.730359999 | 2088527.6355299999 | 37.71527728989071 | -122.40648870199 | (37.7152772898907, -122.40648870199) | |
147146 | 147146 | 142758 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6010864.8123 | 2120023.3634 | 37.80179213390711 | -122.406567008949 | (37.8017921339071, -122.406567008949) | |||
184779 | 184779 | 142759 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010846.8046 | 2120020.1312 | 37.801782251607 | -122.406629096352 | (37.801782251607, -122.406629096352) | |||
149261 | 149261 | 142760 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010826.0266 | 2120017.8226 | 37.8017747502564 | -122.406700835434 | (37.8017747502564, -122.406700835434) | |||
10735 | 10735 | 95001 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 166 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010153.2106 | 2087493.0431 | 37.712431333442 | -122.40673562308099 | (37.712431333442, -122.406735623081) | |||
170230 | 170230 | 142761 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010807.5572 | 2120014.5904 | 37.8017648420531 | -122.406764520508 | (37.8017648420531, -122.406764520508) | |||
12910 | 12910 | 26795 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 159 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2010 12:00:00 AM | 3 | 3x3 | 6010135.8151 | 2087452.9607 | 37.712320301990204 | -122.40679292443501 | (37.7123203019902, -122.406792924435) | ||
11856 | 11856 | 95002 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 170 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010131.1046 | 2087504.7217 | 37.712462163614795 | -122.406812851088 | (37.7124621636148, -122.406812851088) | |||
12204 | 12204 | 95003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 176 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010111.9182 | 2087516.8174 | 37.7124943023778 | -122.406880017452 | (37.7124943023778, -122.406880017452) | |||
185222 | 185222 | 142763 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010767.3863 | 2120009.5113 | 37.8017486483835 | -122.406903172911 | (37.8017486483835, -122.406903172911) | |||
100802 | 100802 | 36655 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1385 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39463 | 6010371.65338703 | 2101276.07690264 | 37.7502888512105 | -122.406951464573 | (37.7502888512105, -122.406951464573) | ||
23661 | 23661 | 142764 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010752.149 | 2120007.2027 | 37.801741456909596 | -122.40695573845899 | (37.8017414569096, -122.406955738459) | |||
94578 | 94578 | 48931 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1359 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46119 | 6010365.55599318 | 2101386.49662509 | 37.7505916982414 | -122.40698033169399 | (37.7505916982414, -122.406980331694) | ||
12621 | 12621 | 95008 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 167 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010080.5579 | 2087480.5892 | 37.712393072261705 | -122.40698585693501 | (37.7123930722617, -122.406985856935) | |||
87258 | 87258 | 47279 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2725 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 45226 | 6010374.46685774 | 2102794.62950622 | 37.7544586181093 | -122.40704875919701 | (37.7544586181093, -122.407048759197) | ||
10559 | 10559 | 26794 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 186 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 2 | 3x3 | 6010044.3489 | 2087538.0893 | 37.7125489295627 | -122.407115057358 | (37.7125489295627, -122.407115057358) | ||
121332 | 121332 | 36654 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1374 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39462 | 6010323.053984901 | 2101213.05971978 | 37.7501131002852 | -122.40711508386002 | (37.7501131002852, -122.40711508386) | ||
108700 | 108700 | 34300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1247 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 10x6 | Permit Number 38088 | 6010333.98586121 | 2101958.21119992 | 37.7521597335331 | -122.40712979916401 | (37.7521597335331, -122.407129799164) | |
11134 | 11134 | 95007 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 185 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010037.7782 | 2087495.7404 | 37.712432280377705 | -122.40713478458 | (37.7124322803777, -122.40713478458) | |||
86444 | 86444 | 50722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 495 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.717715618678206 | -122.40716682601999 | (37.7177156186782, -122.40716682602) | |||
88383 | 88383 | 50723 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 495 Wilde Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | Permit Number 47274 | 6010067.71310756 | 2089419.28604179 | 37.717715618678206 | -122.40716682601999 | (37.7177156186782, -122.40716682602) | |||
118507 | 118507 | 73592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586.0 | 2116213.0 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | |
128608 | 128608 | 73572 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52275 | 6010586.0 | 2116213.0 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | |
142619 | 142619 | 82029 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586.0 | 2116213.0 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | |
78741 | 78741 | 47278 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2627 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 3x3 | Permit Number 45225 | 6010323.37047205 | 2103961.60067533 | 37.7576600010286 | -122.40730772564699 | (37.7576600010286, -122.407307725647) | |
75758 | 75758 | 47310 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1107 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45241 | 6010288.16181634 | 2102764.77938432 | 37.7543718262723 | -122.407345121668 | (37.7543718262723, -122.407345121668) | ||
132838 | 132838 | 178906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009976.781880001 | 2089389.92306 | 37.7176299046612 | -122.40747906690399 | (37.7176299046612, -122.407479066904) | |||
119912 | 119912 | 34291 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2755 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 38082 | 6010200.77645809 | 2102785.10584633 | 37.7544227469466 | -122.407648757096 | (37.7544227469466, -122.407648757096) | ||
63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
179405 | 179405 | 95827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 144A Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767562 | 6010353.30698 | 2110532.02613 | 37.7757025646591 | -122.407667456007 | (37.7757025646591, -122.407667456007) |
121025 | 121025 | 111845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1550 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
104672 | 104672 | 64402 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 05/14/1988 12:00:00 AM | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) |
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");