Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46895 | 46895 | 88581 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 515 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.701169999 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | ||
4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
9202 | 9202 | 1709 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 7X Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2006 12:00:00 AM | 5 | 3x3 | 6016610.521033701 | 2095134.7434862 | 37.7337731370994 | -122.384949031469 | (37.7337731370994, -122.384949031469) | ||
15141 | 15141 | 81729 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015012.434719999 | 2102924.7634900003 | 37.7550743894922 | -122.391018422974 | (37.7550743894922, -122.391018422974) |
23669 | 23669 | 138324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2492 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001634.5236 | 2114647.8572 | 37.7865116723619 | -122.438122738022 | (37.7865116723619, -122.438122738022) | |||
25023 | 25023 | 213915 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1221 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993897.03256 | 2107168.07527 | 37.7655311082052 | -122.464349072465 | (37.7655311082052, -122.464349072465) | |||
25141 | 25141 | 213923 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996379.96302 | 2106767.55131 | 37.76457417918571 | -122.455732270441 | (37.7645741791857, -122.455732270441) | |||
27910 | 27910 | 183007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2440 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989549.7088 | 2098739.1145 | 37.742135877465294 | -122.478768805014 | (37.7421358774653, -122.478768805014) | |||
30825 | 30825 | 240180 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008254.09787 | 2096890.0031299999 | 37.738126944293796 | -122.413963894722 | (37.7381269442938, -122.413963894722) | |||
33654 | 33654 | 141285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 303 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5998264.5884 | 2112604.2973 | 37.780708361851396 | -122.449634513412 | (37.7807083618514, -122.449634513412) | |||
34718 | 34718 | 139271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 765 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004149.5758 | 2111471.3855 | 37.7779325866279 | -122.42919470092698 | (37.7779325866279, -122.429194700927) | |||
41799 | 41799 | 46849 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.724327847540295 | -122.42848061451201 | (37.7243278475403, -122.428480614512) | |
44291 | 44291 | 247563 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6008788.9631 | 2095462.99791 | 37.734238722726495 | -122.41201377422199 | (37.7342387227265, -122.412013774222) | |||
44512 | 44512 | 38662 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 834 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40585 | 6001015.5346 | 2111586.9168 | 37.778071890037 | -122.440044714881 | (37.778071890037, -122.440044714881) |
45316 | 45316 | 141980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 676 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004463.6367 | 2111570.2882 | 37.778221923041 | -122.42811530330299 | (37.778221923041, -122.428115303303) | |||
47148 | 47148 | 72144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 5 | 6000049.527000001 | 2091859.62504 | 37.723850484693706 | -122.441970156497 | (37.7238504846937, -122.441970156497) | ||
47669 | 47669 | 36825 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49072 | 6014545.9992 | 2090648.9983 | 37.721341772631895 | -122.39177321286199 | (37.7213417726319, -122.391773212862) | |
48657 | 48657 | 139274 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 725 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004227.9769 | 2111481.8263 | 37.7779656924567 | -122.42892422841899 | (37.7779656924567, -122.428924228419) | |||
48741 | 48741 | 71411 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | ||
52609 | 52609 | 34250 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.42276644632601 | (37.8043668775019, -122.422766446326) | |
57568 | 57568 | 213989 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992043.57751 | 2097881.5544 | 37.7399257259925 | -122.47008343851299 | (37.7399257259925, -122.470083438513) | |||
59877 | 59877 | 142215 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999732.1302 | 2109994.3314 | 37.7736259111784 | -122.444369976113 | (37.7736259111784, -122.444369976113) | |||
62088 | 62088 | 213946 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996526.79114 | 2090102.3106200001 | 37.718823939946795 | -122.454020752656 | (37.7188239399468, -122.454020752656) | |||
62957 | 62957 | 213921 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 28 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996377.267469999 | 2106728.36623 | 37.7644664323134 | -122.45573876085501 | (37.7644664323134, -122.455738760855) | |||
63638 | 63638 | 136265 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010230.84505 | 2116901.45866 | 37.7931846576946 | -122.408540490873 | (37.7931846576946, -122.408540490873) | |||
64524 | 64524 | 197071 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2300 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010571.86967 | 2106484.7733400003 | 37.7646019700183 | -122.40662611481301 | (37.7646019700183, -122.406626114813) | |||
65149 | 65149 | 197108 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012056.73956 | 2105565.85317 | 37.762161783771205 | -122.401425732033 | (37.7621617837712, -122.401425732033) | ||||
68096 | 68096 | 200038 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015316.6267 | 2094740.3159 | 37.7326184655785 | -122.38939491276501 | (37.7326184655785, -122.389394912765) | |||
68138 | 68138 | 239270 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007357.25381 | 2107576.0791 | 37.767418064810705 | -122.41782199889201 | (37.7674180648107, -122.417821998892) | |||
70939 | 70939 | 200236 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 921 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014551.0541 | 2089524.7802 | 37.718255172199896 | -122.39167717639299 | (37.7182551721999, -122.391677176393) | |||
71108 | 71108 | 31557 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 166 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2015 12:00:00 AM | 5 | Permit Number 774125 | 5998574.5828 | 2112531.8751 | 37.7805272390885 | -122.44855688064399 | (37.7805272390885, -122.448556880644) | |
71297 | 71297 | 199665 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015244.0778 | 2093456.6965 | 37.729089882168395 | -122.389556118834 | (37.7290898821684, -122.389556118834) | |||
72842 | 72842 | 69456 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 5 | Permit Number 33566 | 5985607.3929 | 2112736.22477 | 37.7803383536355 | -122.493430946652 | (37.7803383536355, -122.493430946652) | |
73788 | 73788 | 138936 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 611 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004391.0086 | 2110998.5233 | 37.776647887890896 | -122.428325789109 | (37.7766478878909, -122.428325789109) | |||
73927 | 73927 | 139494 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1282 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001605.3645 | 2111168.2484 | 37.776955892433705 | -122.437974289048 | (37.7769558924337, -122.437974289048) | |||
73982 | 73982 | 137614 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2250 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999234.5899 | 2111901.9875 | 37.7788354460524 | -122.446228288937 | (37.7788354460524, -122.446228288937) | |||
74292 | 74292 | 54817 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1414 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49953 | 6015568.3491 | 2093032.3958 | 37.7279428116622 | -122.388405474303 | (37.7279428116622, -122.388405474303) | |
76235 | 76235 | 179325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 139 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009883.98076 | 2094924.5226900002 | 37.7328215611604 | -122.408189966611 | (37.7328215611604, -122.408189966611) | |||
76800 | 76800 | 67939 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 424 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1993 12:00:00 AM | 5 | Permit Number 31653 | 5999771.9705 | 2110008.0811 | 37.7736659373793 | -122.444233151163 | (37.7736659373793, -122.444233151163) | ||
89195 | 89195 | 84586 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3280 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51600 | 6006479.54925803 | 2103214.61842513 | 37.7553930801265 | -122.420548232521 | (37.7553930801265, -122.420548232521) | |
112664 | 112664 | 32235 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35550 | 6008746.13073 | 2099389.39192 | 37.7450173393701 | -122.412439304646 | (37.7450173393701, -122.412439304646) | |
119603 | 119603 | 239286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1999 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009565.6404099995 | 2105513.83187 | 37.761879638550504 | -122.410037856662 | (37.7618796385505, -122.410037856662) | |||
126705 | 126705 | 47740 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3583 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45523 | 6005444.07123 | 2097374.1868 | 37.7392981824927 | -122.42371398959101 | (37.7392981824927, -122.423713989591) | |
130726 | 130726 | 60409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1448 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52503 | 6016089.8742 | 2094040.62 | 37.73074008090121 | -122.38667280863399 | (37.7307400809012, -122.386672808634) | |
133498 | 133498 | 239325 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009350.01559 | 2099840.2126 | 37.746289064404294 | -122.410382996672 | (37.7462890644043, -122.410382996672) | |||
135080 | 135080 | 69741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6010157.175969999 | 2089735.57492 | 37.7185890892048 | -122.40687987112601 | (37.7185890892048, -122.406879871126) | ||
136061 | 136061 | 139287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 894 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6003017.2906 | 2111263.9995 | 37.7772989926884 | -122.43309685014499 | (37.7772989926884, -122.433096850145) | |||
136232 | 136232 | 240135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 277 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004681.7574 | 2100144.35115 | 37.74686135877779 | -122.426546933603 | (37.7468613587778, -122.426546933603) | |||
137891 | 137891 | 67598 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3320 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/1992 12:00:00 AM | 5 | Permit Number 31166 | 5998906.2009 | 2115636.68755 | 37.789071198237295 | -122.44763322790199 | (37.7890711982373, -122.447633227902) | ||
147189 | 147189 | 213947 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995892.36071 | 2091233.5723299999 | 37.7218937190991 | -122.456295465473 | (37.7218937190991, -122.456295465473) | |||
148294 | 148294 | 123628 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995232.14872 | 2114600.88341 | 37.7860165001902 | -122.460269811318 | (37.7860165001902, -122.460269811318) | |||
149179 | 149179 | 85485 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010430.57281 | 2092804.2489200002 | 37.72703032647411 | -122.40615092385299 | (37.7270303264741, -122.406150923853) | ||
149670 | 149670 | 30617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1625 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34579 | 6008161.857999999 | 2108672.7086 | 37.7704744001626 | -122.41511660718399 | (37.7704744001626, -122.415116607184) | |
150051 | 150051 | 239358 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003940.0433 | 2099157.5205099997 | 37.744109791227395 | -122.42904136337098 | (37.7441097912274, -122.429041363371) | |||
150776 | 150776 | 239247 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010310.37957 | 2101498.2335 | 37.7508954153113 | -122.407179012596 | (37.7508954153113, -122.407179012596) | |||
151617 | 151617 | 48799 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014465.83632 | 2102364.69447 | 37.753506213741396 | -122.392869551502 | (37.7535062137414, -122.392869551502) | ||
156477 | 156477 | 197073 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2310 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010516.44047 | 2106481.63446 | 37.7645902500634 | -122.406817609258 | (37.7645902500634, -122.406817609258) | |||
156985 | 156985 | 65109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 5 | Permit Number 27078 | 5988958.234730001 | 2114388.99376 | 37.7850718280894 | -122.481960071321 | (37.7850718280894, -122.481960071321) | |
158710 | 158710 | 141283 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 305 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5998211.7946 | 2112594.1447 | 37.7806774650063 | -122.44981641989901 | (37.7806774650063, -122.449816419899) | |||
160765 | 160765 | 68930 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 768 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32914 | 5993218.422259999 | 2110247.19429 | 37.7739464110699 | -122.466920079783 | (37.7739464110699, -122.466920079783) | |
160986 | 160986 | 240145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.44946901220301 | (37.7629937870534, -122.449469012203) | |||
161134 | 161134 | 199943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6017830.3585 | 2092664.2977 | 37.7270571724447 | -122.380559991407 | (37.7270571724447, -122.380559991407) | |||
164209 | 164209 | 197155 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 36 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016950.769830001 | 2095599.6717299998 | 37.73506855147429 | -122.38380503909401 | (37.7350685514743, -122.383805039094) | |||
164269 | 164269 | 239282 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3562 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005817.754430001 | 2105515.28617 | 37.761672857446 | -122.42300043553499 | (37.761672857446, -122.423000435535) | |||
164333 | 164333 | 213951 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 319 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994724.0479999995 | 2090709.9007700002 | 37.7203887054465 | -122.460296073498 | (37.7203887054465, -122.460296073498) | |||
165380 | 165380 | 85614 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1200X Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 5 | 3x3 | 6017331.5604 | 2093113.8652 | 37.728264058993396 | -122.382315610259 | (37.7282640589934, -122.382315610259) | ||
166878 | 166878 | 182744 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1769 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986859.8585 | 2103239.7166 | 37.754336768117206 | -122.488400024275 | (37.7543367681172, -122.488400024275) | |||
169276 | 169276 | 136245 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1723 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006515.15933 | 2116648.60219 | 37.7922815836866 | -122.421379054996 | (37.7922815836866, -122.421379054996) | |||
170803 | 170803 | 179301 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 324 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003618.31142 | 2092719.8675400002 | 37.7264152414524 | -122.429694781997 | (37.7264152414524, -122.429694781997) | |||
171356 | 171356 | 51529 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 846 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47831 | 6013038.0341300005 | 2103130.6392200002 | 37.7555299221754 | -122.39786095703501 | (37.7555299221754, -122.397860957035) | ||
171856 | 171856 | 139399 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 896 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6003012.8594 | 2111291.1403 | 37.7773732632111 | -122.433114118747 | (37.7773732632111, -122.433114118747) | |||
173343 | 173343 | 197137 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1611 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6015105.04683 | 2096793.47619 | 37.7382442932251 | -122.39026979671699 | (37.7382442932251, -122.390269796717) | |||
175081 | 175081 | 240201 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3004 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002850.8471 | 2096117.4239599998 | 37.735700673245 | -122.432590449705 | (37.735700673245, -122.432590449705) | |||
175163 | 175163 | 142043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005850.7541 | 2111017.8349 | 37.776783403593996 | -122.42327746856199 | (37.776783403594, -122.423277468562) | |||
176550 | 176550 | 120252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988365.81555 | 2114876.44647 | 37.7863757629455 | -122.484045388081 | (37.7863757629455, -122.484045388081) | |||
176735 | 176735 | 197125 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Apparel Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6011537.38847 | 2097577.661 | 37.7401989607078 | -122.402660197209 | (37.7401989607078, -122.402660197209) | |||
177088 | 177088 | 91041 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006464.746230001 | 2121395.99646 | 37.805313886080604 | -122.421890864574 | (37.8053138860806, -122.421890864574) | |
178581 | 178581 | 32236 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1599 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35551 | 6008785.95411 | 2099394.95601 | 37.745034851884796 | -122.41230199523599 | (37.7450348518848, -122.412301995236) | |
181073 | 181073 | 78383 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | ||
182445 | 182445 | 136196 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2102 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002856.44865 | 2118905.6170900003 | 37.7982718041617 | -122.43419968126999 | (37.7982718041617, -122.43419968127) | |||
182814 | 182814 | 240185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001017.63107 | 2106166.1197099998 | 37.76318785445999 | -122.439648742804 | (37.76318785446, -122.439648742804) | |||
186113 | 186113 | 240179 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 419 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008252.0977 | 2096866.76003 | 37.7380630114909 | -122.41396916654199 | (37.7380630114909, -122.413969166542) | |||
188252 | 188252 | 213979 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 254 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994759.40129 | 2090277.98422 | 37.719204799252296 | -122.46014259431999 | (37.7192047992523, -122.46014259432) | |||
188810 | 188810 | 48419 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2002 12:00:00 AM | 5 | Permit Number 45797 | 6002578.00127 | 2118175.76067 | 37.796252000589796 | -122.435110962497 | (37.7962520005898, -122.435110962497) | ||
1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
38106 | 38106 | 142044 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005880.5674 | 2111021.3015 | 37.7767946045442 | -122.423174581774 | (37.7767946045442, -122.423174581774) | |||
53523 | 53523 | 48812 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.053730001 | 2102353.10418 | 37.753474456898104 | -122.392864530587 | (37.7534744568981, -122.392864530587) | ||
54424 | 54424 | 197151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 99 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016637.91847 | 2095129.63156 | 37.7337606161438 | -122.384853953468 | (37.7337606161438, -122.384853953468) | |||
56000 | 56000 | 30618 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34580 | 6008139.305 | 2108622.0896 | 37.7703341448356 | -122.41519103466601 | (37.7703341448356, -122.415191034666) | |
56227 | 56227 | 197135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015262.92854 | 2096819.7411099998 | 37.738325167482294 | -122.389725749154 | (37.7383251674823, -122.389725749154) | |||
60644 | 60644 | 141284 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 305 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5998229.3925 | 2112598.2057 | 37.7806896223004 | -122.44975583332199 | (37.7806896223004, -122.449755833322) | |||
70248 | 70248 | 100361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1135 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007562.69285 | 2118825.76087 | 37.7983185248271 | -122.417908959744 | (37.7983185248271, -122.417908959744) | |||
94122 | 94122 | 81726 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
118181 | 118181 | 179285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010162.36149 | 2089750.0772799999 | 37.7186291998585 | -122.40686296837099 | (37.7186291998585, -122.406862968371) | |||
119496 | 119496 | 199666 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015268.2608 | 2093490.7724 | 37.72918478862329 | -122.389474894337 | (37.7291847886233, -122.389474894337) | |||
122012 | 122012 | 197080 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015550.01358 | 2105828.2198099997 | 37.7630764752211 | -122.389362048039 | (37.7630764752211, -122.389362048039) | |||
159587 | 159587 | 213922 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 28 Hill Point Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996376.57374 | 2106740.0599 | 37.7644985003194 | -122.45574200560499 | (37.7644985003194, -122.455742005605) | |||
160235 | 160235 | 246010 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1509 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998926.3648 | 2108660.5268 | 37.7699176174446 | -122.447061224692 | (37.7699176174446, -122.447061224692) | |||
160245 | 160245 | 123627 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 142 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995231.45698 | 2114622.12535 | 37.786074785036504 | -122.46027374413099 | (37.7860747850365, -122.460273744131) | |||
162161 | 162161 | 91042 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006462.588380001 | 2121409.81945 | 37.8053517187772 | -122.421899314626 | (37.8053517187772, -122.421899314626) |
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");