Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, DBH, PlotSize
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 429 | 429 | 142788 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 733 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | Polk St Scape will replant | 6007029.0497 | 2113497.6534 | 37.7836588132661 | -122.419377346786 | (37.7836588132661, -122.419377346786) | ||
| 2715 | 2715 | 253166 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 2405 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778209 | 5986396.6612 | 2098868.17463 | 37.742306656921 | -122.48968039586501 | (37.742306656921, -122.489680395865) | |
| 3099 | 3099 | 197138 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 6 | Width 3ft | Permit Number 51436 | 6011420.8914 | 2093882.2827299999 | 37.7300457263229 | -122.402803173234 | (37.7300457263229, -122.402803173234) | |
| 3392 | 3392 | 7175 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 814 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 6 | 3X3 | 6003515.4229999995 | 2111193.7442 | 37.7771343327183 | -122.43136863367201 | (37.7771343327183, -122.431368633672) | ||
| 3419 | 3419 | 252969 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998180.94106 | 2087280.50358 | 37.711170613109104 | -122.448099970249 | (37.7111706131091, -122.448099970249) | |||||
| 3425 | 3425 | 159220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.71247119106079 | -122.446492798529 | (37.7124711910608, -122.446492798529) | |||
| 3814 | 3814 | 193324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | |||
| 3834 | 3834 | 244219 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 588 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998052.0 | 2108644.0 | 37.76982224415679 | -122.450084429151 | (37.7698222441568, -122.450084429151) | |||
| 3987 | 3987 | 159341 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.297780001 | 2087238.08175 | 37.7110558677139 | -122.44799199802799 | (37.7110558677139, -122.447991998028) | ||
| 4003 | 4003 | 159298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:11:00 PM | 3 | Width 0ft | 5998090.67137 | 2087368.5047400002 | 37.711407083550704 | -122.448418296488 | (37.7114070835507, -122.448418296488) | ||
| 4012 | 4012 | 252965 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:04:00 PM | 3 | ||||||||
| 4066 | 4066 | 252966 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:19:00 PM | 3 | 5998135.7809 | 2087327.97675 | 37.7112983819328 | -122.448259470506 | (37.7112983819328, -122.448259470506) | |||
| 4074 | 4074 | 252967 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:55:00 PM | 3 | 5998144.81293 | 2087318.48212 | 37.7112728281964 | -122.448227570418 | (37.7112728281964, -122.448227570418) | |||
| 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) | |||
| 4925 | 4925 | 253721 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 260 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2017 12:00:00 AM | 3 | 3.5x9 | Permit Number 780843 | 5994045.0 | 2113761.0 | 37.7836420503516 | -122.464315992766 | (37.7836420503516, -122.464315992766) | |
| 5178 | 5178 | 104043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1405 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006090.81059 | 2119657.4034599997 | 37.800519058872396 | -122.42306126657199 | (37.8005190588724, -122.423061266572) | |||
| 5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 6305 | 6305 | 52146 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2005 12:00:00 AM | Permit Number 48337 | ||||||||
| 6678 | 6678 | 48693 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 722 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2003 12:00:00 AM | 4 | 3x3 | Permit Number 45971 | 6001051.9149 | 2111314.295 | 37.7773254106094 | -122.43989931071 | (37.7773254106094, -122.43989931071) | |
| 6697 | 6697 | 7312 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1940 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002968.6362 | 2115073.8773 | 37.7877571983499 | -122.433537500112 | (37.7877571983499, -122.433537500112) | |||
| 6813 | 6813 | 52112 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48303 | 6005739.8209 | 2111002.5816 | 37.776735260452 | -122.423660135383 | (37.776735260452, -122.423660135383) | |
| 7656 | 7656 | 7301 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1996 12:00:00 AM | 3 | 3X3 | 6002935.9259 | 2114953.2976 | 37.787424261211704 | -122.43364205043699 | (37.7874242612117, -122.433642050437) | ||
| 7823 | 7823 | 7319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2011 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002893.06 | 2115234.5275 | 37.7881940146245 | -122.433810466039 | (37.7881940146245, -122.433810466039) | |||
| 8286 | 8286 | 7311 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1932 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | 6002980.7419 | 2115020.0739 | 37.787610154730004 | -122.433491770285 | (37.78761015473, -122.433491770285) | |||
| 9083 | 9083 | 10613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.501807599 | 2095595.9312573997 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | ||
| 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) | ||
| 9215 | 9215 | 10617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 74 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1992 12:00:00 AM | 6 | 3X3 | 6016731.0735863 | 2095616.8317798001 | 37.7351035225916 | -122.38456580983299 | (37.7351035225916, -122.384565809833) | ||
| 9296 | 9296 | 11461 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 41X HAWKINS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/1992 12:00:00 AM | 12 | 3X3 | 6016935.0 | 2095578.0 | 37.7350081734808 | -122.38385805308201 | (37.7350081734808, -122.383858053082) | ||
| 9522 | 9522 | 7294 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003037.0806 | 2114087.5866 | 37.7850529772079 | -122.43323019463499 | (37.7850529772079, -122.433230194635) | |||
| 9726 | 9726 | 173663 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 3878 17th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003109.0 | 2105964.0 | 37.7627516946294 | -122.432400964417 | (37.7627516946294, -122.432400964417) | ||||
| 10316 | 10316 | 110495 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003598.79471 | 2092490.0157299999 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | |||
| 11111 | 11111 | 110496 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003585.89382 | 2092469.97138 | 37.7257272466074 | -122.429789031845 | (37.7257272466074, -122.429789031845) | |||
| 11507 | 11507 | 30593 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 13377 | 13377 | 10610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6016939.384330001 | 2095525.0457799998 | 37.7348630141201 | -122.38383920883801 | (37.7348630141201, -122.383839208838) | ||
| 13543 | 13543 | 13319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 14 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1992 12:00:00 AM | 7 | 3X3 | 6016463.59576 | 2095940.9292900001 | 37.7359786339072 | -122.385513164614 | (37.7359786339072, -122.385513164614) | ||
| 13999 | 13999 | 10614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2001 12:00:00 AM | 3 | 3X3 | 6016916.49156 | 2095577.9947400002 | 37.7350071358711 | -122.383922043589 | (37.7350071358711, -122.383922043589) | ||
| 14099 | 14099 | 11466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.967569999 | 2095560.66167 | 37.73495227093311 | -122.384375566285 | (37.7349522709331, -122.384375566285) | ||
| 14406 | 14406 | 120561 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 245 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6014054.5814 | 2105863.37396 | 37.7630899785332 | -122.394536741704 | (37.7630899785332, -122.394536741704) | |||
| 15012 | 15012 | 85551 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 288 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 3 | 6008109.65239 | 2108844.36385 | 37.7709427912139 | -122.41530934075199 | (37.7709427912139, -122.415309340752) | |||
| 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) |
| 16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
| 16412 | 16412 | 30636 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47466 | 6008078.6625 | 2108652.1603 | 37.770413303673394 | -122.4154029268 | (37.7704133036734, -122.4154029268) |
| 17233 | 17233 | 16673 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 244 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002873.2969 | 2106860.8212200003 | 37.7652007800214 | -122.43328026297701 | (37.7652007800214, -122.433280262977) | |||
| 17348 | 17348 | 4322 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 752 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002136.242880001 | 2095781.1252 | 37.7347367232032 | -122.435037065224 | (37.7347367232032, -122.435037065224) | |||
| 17939 | 17939 | 26869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 6001564.842 | 2095930.60071 | 37.7351146866797 | -122.437023288105 | (37.7351146866797, -122.437023288105) | ||
| 18016 | 18016 | 49368 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.40492785111799 | (37.7149060701976, -122.404927851118) | |||
| 18483 | 18483 | 66408 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 632 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1991 12:00:00 AM | Permit Number 29535 | 6007948.77791486 | 2095967.06920677 | 37.7355756171998 | -122.414954236685 | (37.7355756171998, -122.414954236685) | ||
| 18926 | 18926 | 15619 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005685.7885 | 2097881.8817 | 37.7407058402708 | -122.422914311238 | (37.7407058402708, -122.422914311238) | ||
| 19622 | 19622 | 63665 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.747527435901496 | -122.428684519984 | (37.7475274359015, -122.428684519984) | ||
| 19876 | 19876 | 10381 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1324 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X3 | 5999783.9663 | 2108832.8405 | 37.770439708466604 | -122.44410719203998 | (37.7704397084666, -122.44410719204) | |||
| 20207 | 20207 | 4337 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 906 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2001 12:00:00 AM | 6 | 3X3 | 6001499.188490001 | 2095960.05903 | 37.735191840439896 | -122.437252384095 | (37.7351918404399, -122.437252384095) | ||
| 20299 | 20299 | 63295 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23861 | 6008153.74699222 | 2100060.03492719 | 37.746825514117205 | -122.41453511521401 | (37.7468255141172, -122.414535115214) | ||
| 20482 | 20482 | 15620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3529 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6005636.1083 | 2097793.1908 | 37.740459511674 | -122.423079784271 | (37.740459511674, -122.423079784271) | ||
| 20547 | 20547 | 15616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3461 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6005827.515 | 2098142.9917 | 37.741430785549205 | -122.422442822684 | (37.7414307855492, -122.422442822684) | ||
| 20573 | 20573 | 15605 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3349 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2000 12:00:00 AM | 6 | 3X3 | 6006192.9166 | 2098824.6926 | 37.743323189063 | -122.42122778433998 | (37.743323189063, -122.42122778434) | ||
| 21028 | 21028 | 15622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3535 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005607.2671 | 2097740.6765 | 37.7403136916677 | -122.423175774097 | (37.7403136916677, -122.423175774097) | ||
| 21266 | 21266 | 15611 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3361 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2001 12:00:00 AM | 7 | 3X3 | 6006103.7046 | 2098658.8645 | 37.7428628326579 | -122.421524482148 | (37.7428628326579, -122.421524482148) | ||
| 21620 | 21620 | 16672 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002863.164369999 | 2106910.32472 | 37.765336129770105 | -122.43331884658001 | (37.7653361297701, -122.43331884658) | |||
| 21828 | 21828 | 15579 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3X3 | 6006811.7424 | 2099968.3124 | 37.7464981794513 | -122.419169144026 | (37.7464981794513, -122.419169144026) | ||
| 21886 | 21886 | 15583 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3177 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1999 12:00:00 AM | 3 | 3X3 | 6006726.259 | 2099810.7255 | 37.7460606669612 | -122.419453558792 | (37.7460606669612, -122.419453558792) | ||
| 21940 | 21940 | 10478 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998139.6149 | 2108553.6282 | 37.7695791194599 | -122.44977485921801 | (37.7695791194599, -122.449774859218) | |||
| 21988 | 21988 | 15585 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3181 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6006711.3923 | 2099783.2222 | 37.7459843117401 | -122.419503015091 | (37.7459843117401, -122.419503015091) | ||
| 22361 | 22361 | 213977 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994717.86147 | 2090376.1855099997 | 37.719472047173205 | -122.460293291905 | (37.7194720471732, -122.460293291905) | |||
| 22370 | 22370 | 244046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998376.5126 | 2109253.6935 | 37.771514871030995 | -122.44900587960699 | (37.771514871031, -122.449005879607) | |||
| 22963 | 22963 | 108630 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1469-1471 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772871 | 6002136.635290001 | 2111543.9635799997 | 37.778017709796295 | -122.436163356374 | (37.7780177097963, -122.436163356374) |
| 23538 | 23538 | 213933 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | |||
| 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) | |||
| 23795 | 23795 | 239276 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 313 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007404.6677 | 2107881.43658 | 37.768259172860105 | -122.41767964611 | (37.7682591728601, -122.41767964611) | |||
| 23815 | 23815 | 239298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1475 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 10ft | 6010135.52625 | 2100699.74587 | 37.7486931572616 | -122.407727378721 | (37.7486931572616, -122.407727378721) | |||
| 23839 | 23839 | 239303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 827 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009943.30832 | 2104181.7840400003 | 37.7582432964097 | -122.408637674287 | (37.7582432964097, -122.408637674287) | |||
| 23855 | 23855 | 213936 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992721.86042 | 2099019.1696099997 | 37.7430885175375 | -122.46782095827801 | (37.7430885175375, -122.467820958278) | |||
| 23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
| 24092 | 24092 | 40635 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2577 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | 1 | Permit Number 41635 | 5999855.0848 | 2113645.9018 | 37.7836592022764 | -122.44420710871401 | (37.7836592022764, -122.444207108714) | ||
| 24603 | 24603 | 239251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3741 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005376.329919999 | 2100765.1364700003 | 37.748605134322794 | -122.42418930690901 | (37.7486051343228, -122.424189306909) | |||
| 24671 | 24671 | 58732 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2385 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | ||
| 24904 | 24904 | 136239 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | |||
| 25009 | 25009 | 197076 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014915.77906 | 2102946.7050400004 | 37.7551292724085 | -122.39135422264098 | (37.7551292724085, -122.391354222641) | |||
| 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) | |||
| 25291 | 25291 | 179283 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 126 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004517.28509 | 2090394.86473 | 37.7200821580385 | -122.426421596896 | (37.7200821580385, -122.426421596896) | |||
| 25584 | 25584 | 123293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 566 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994099.84027 | 2111646.79244 | 37.7778401670229 | -122.46397274776301 | (37.7778401670229, -122.463972747763) | |||
| 25779 | 25779 | 32030 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3321 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 13 | Permit Number 35417 | 6004551.31558 | 2106568.33958 | 37.764492746462395 | -122.42745555912701 | (37.7644927464624, -122.427455559127) | ||
| 25963 | 25963 | 179311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | |||
| 26041 | 26041 | 239277 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006452.39888 | 2105218.17632 | 37.760892854741996 | -122.420784359417 | (37.760892854742, -122.420784359417) | |||
| 26335 | 26335 | 239363 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3995 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003937.45795 | 2100690.36733 | 37.748318487114894 | -122.429159577477 | (37.7483184871149, -122.429159577477) | |||
| 26386 | 26386 | 136222 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999346.78651 | 2119715.31037 | 37.8002951834309 | -122.446402399571 | (37.8002951834309, -122.446402399571) | |||
| 26447 | 26447 | 213937 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 155 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992856.26396 | 2098093.99646 | 37.740555986160494 | -122.467288974202 | (37.7405559861605, -122.467288974202) | |||
| 26489 | 26489 | 139379 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1409 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999686.4389 | 2113792.3684 | 37.7840517388464 | -122.44480108896799 | (37.7840517388464, -122.444801088968) | |||
| 26493 | 26493 | 239366 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3544 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004780.37134 | 2103118.67558 | 37.7550337374315 | -122.426417677652 | (37.7550337374315, -122.426417677652) | |||
| 26558 | 26558 | 136248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.800892734360296 | -122.414423864695 | (37.8008927343603, -122.414423864695) | |||
| 26777 | 26777 | 138037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1928 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002982.5354 | 2114995.4141 | 37.7875425469434 | -122.433483802199 | (37.7875425469434, -122.433483802199) | |||
| 26848 | 26848 | 239353 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 333 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003763.4516900005 | 2098632.19433 | 37.7426573690441 | -122.429614519315 | (37.7426573690441, -122.429614519315) | |||
| 26988 | 26988 | 248441 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 739 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998553.128 | 2108007.4759 | 37.7681031739849 | -122.44830520423099 | (37.7681031739849, -122.448305204231) | |||
| 27085 | 27085 | 87158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50139 | 6011083.99361 | 2095446.91838 | 37.7343230701451 | -122.404077946949 | (37.7343230701451, -122.404077946949) | |
| 27228 | 27228 | 239271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 400 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007373.17462 | 2107313.6356599997 | 37.7666983526646 | -122.417748326439 | (37.7666983526646, -122.417748326439) | |||
| 27611 | 27611 | 239367 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 17 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004711.71138 | 2103517.26847 | 37.756124298509896 | -122.42668350644101 | (37.7561242985099, -122.426683506441) | |||
| 27678 | 27678 | 68339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32156 | 5991257.09324 | 2112608.74204 | 37.7803171779643 | -122.47387689925101 | (37.7803171779643, -122.473876899251) | |
| 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) | |||
| 27916 | 27916 | 197079 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 690 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015561.72583 | 2105828.91514 | 37.763079033783605 | -122.389321587544 | (37.7630790337836, -122.389321587544) | |||
| 28029 | 28029 | 124413 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3900 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5996133.62205 | 2115253.7929599998 | 37.787861027515895 | -122.45719822521299 | (37.7878610275159, -122.457198225213) |
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");