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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1663 | 1663 | 251645 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 1670 | 1670 | 251646 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 1677 | 1677 | 251644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3541 | 3541 | 253472 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3548 | 3548 | 253473 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 4158 | 4158 | 253614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1959x Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006418.0 | 2117595.0 | 37.794874677003605 | -122.421782481899 | (37.7948746770036, -122.421782481899) | ||||
| 4351 | 4351 | 36746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39516 | ||||||||
| 5254 | 5254 | 253839 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006239.0 | 2097690.0 | 37.740210176126794 | -122.42098789234 | (37.7402101761268, -122.42098789234) | ||||
| 5302 | 5302 | 35167 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 240 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | Permit Number 38700 | ||||||||
| 5746 | 5746 | 31847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 6090 | 6090 | 105252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770851 | 6004061.8803 | 2118683.0933 | 37.7977291534815 | -122.43001264475201 | (37.7977291534815, -122.430012644752) | ||||
| 7293 | 7293 | 31848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 9510 | 9510 | 46857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44926 | |||||||||
| 9777 | 9777 | 88104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1247 46th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 4x10 | Permit Number 51108 | 5981754.7 | 2106590.8 | 37.763238693975296 | -122.50630313344999 | (37.7632386939753, -122.50630313345) | |||
| 9952 | 9952 | 39131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 774 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 2.5x3 | Permit Number 40811 | 6007313.40469967 | 2102804.1822591 | 37.7543130741871 | -122.417635411147 | (37.7543130741871, -122.417635411147) | |
| 10122 | 10122 | 173861 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4618 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000547.0 | 2104681.0 | 37.7590832830794 | -122.441169935678 | (37.7590832830794, -122.441169935678) | ||||
| 10952 | 10952 | 43297 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2000 12:00:00 AM | Permit Number 43066 | ||||||||
| 11795 | 11795 | 31846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 13223 | 13223 | 33083 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 13630 | 13630 | 49513 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1648@3rd ST Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2003 12:00:00 AM | Permit Number 46418 | 6014785.81315318 | 2094304.60337815 | 37.731392643231295 | -122.391199634158 | (37.7313926432313, -122.391199634158) | |||
| 14881 | 14881 | 33084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 17839 | 17839 | 45141 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | ||
| 17861 | 17861 | 36571 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 193 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39434 | 6006550.67564365 | 2097394.54535781 | 37.739416487692 | -122.41988928119801 | (37.739416487692, -122.419889281198) | ||
| 17879 | 17879 | 68381 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 42 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32206 | 5999268.74613245 | 2105519.44927205 | 37.76131256253829 | -122.445651023552 | (37.7613125625383, -122.445651023552) | ||
| 18482 | 18482 | 50084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 163 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46816 | 5992385.51984068 | 2098065.73695017 | 37.7404512063716 | -122.468914554715 | (37.7404512063716, -122.468914554715) | ||
| 18838 | 18838 | 43257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.728118638728105 | -122.407120168437 | (37.7281186387281, -122.407120168437) | ||
| 19102 | 19102 | 48673 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2002 12:00:00 AM | Permit Number 45956 | 6002102.91710872 | 2103385.70582138 | 37.7556152218159 | -122.43569617174101 | (37.7556152218159, -122.435696171741) | |||
| 19412 | 19412 | 68594 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1776 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32496 | 5991255.24615708 | 2103348.30667764 | 37.754890406441895 | -122.47320772508499 | (37.7548904064419, -122.473207725085) | ||
| 19495 | 19495 | 40538 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 384 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | Permit Number 41587 | 5992631.08642927 | 2094049.19194754 | 37.7294369636011 | -122.46777343904101 | (37.7294369636011, -122.467773439041) | |||
| 19736 | 19736 | 121676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993867.0 | 2101351.0 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | ||||
| 19737 | 19737 | 43124 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 306 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42942 | 6006590.61283403 | 2097446.1617064998 | 37.7395604645493 | -122.41975485718001 | (37.7395604645493, -122.41975485718) | |||
| 19803 | 19803 | 40552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 380 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41594 | 5992231.83033974 | 2094391.07598337 | 37.7303526300924 | -122.46917856626301 | (37.7303526300924, -122.469178566263) | ||
| 19839 | 19839 | 46807 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 San Felipe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.46294824520201 | (37.7322740285646, -122.462948245202) | ||
| 20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
| 20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
| 20490 | 20490 | 68099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31844 | 6006420.25408514 | 2099944.49896622 | 37.7464107382986 | -122.42052117977501 | (37.7464107382986, -122.420521179775) | ||
| 20623 | 20623 | 39050 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009499.38 | 2105599.429 | 37.762110954787005 | -122.410273070025 | (37.762110954787, -122.410273070025) | ||
| 20981 | 20981 | 40426 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 572 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.46145953493901 | (37.7276267513816, -122.461459534939) | ||
| 21203 | 21203 | 47373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | |||
| 21241 | 21241 | 41670 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
| 25402 | 25402 | 52514 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 37394 | 37394 | 39047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009496.342 | 2105638.057 | 37.762216848178504 | -122.410286304804 | (37.7622168481785, -122.410286304804) | ||
| 40014 | 40014 | 97950 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | |||||
| 44568 | 44568 | 47936 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 235 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45671 | 5996315.56567541 | 2094902.75702129 | 37.7319927097789 | -122.45509757060199 | (37.7319927097789, -122.455097570602) | ||
| 44839 | 44839 | 84348 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3332-3334 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50580 | 6007340.92664153 | 2105019.75450207 | 37.760398074706 | -122.417697261406 | (37.760398074706, -122.417697261406) | ||
| 46255 | 46255 | 46806 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 San Felipe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.46294824520201 | (37.7322740285646, -122.462948245202) | |||
| 47996 | 47996 | 36107 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1342 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39204 | 5992735.49126181 | 2106322.00548974 | 37.7631410027064 | -122.46830499108499 | (37.7631410027064, -122.468304991085) | ||
| 49108 | 49108 | 45296 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 586 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44763 | 6008684.90239462 | 2096105.66029686 | 37.7359974954785 | -122.412418957568 | (37.7359974954785, -122.412418957568) | ||
| 49625 | 49625 | 39053 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009484.188999999 | 2105497.432 | 37.7618300427155 | -122.410318408111 | (37.7618300427155, -122.410318408111) | ||
| 49635 | 49635 | 35149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.771962024845294 | -122.427256837171 | (37.7719620248453, -122.427256837171) | ||
| 50089 | 50089 | 64596 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3339 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1988 12:00:00 AM | Permit Number 25497 | 6006072.66920916 | 2103140.85266196 | 37.7551675977095 | -122.42195010954501 | (37.7551675977095, -122.421950109545) | ||
| 50096 | 50096 | 31268 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991067.840009999 | 2098080.24601 | 37.7404148266578 | -122.47347158803001 | (37.7404148266578, -122.47347158803) | ||
| 50098 | 50098 | 49044 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 79 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46218 | 5995600.89018522 | 2093144.22655709 | 37.7271231825202 | -122.45744116150101 | (37.7271231825202, -122.457441161501) | ||
| 50492 | 50492 | 68045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1972 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31782 | 5993192.12493699 | 2102059.66959025 | 37.75146409897361 | -122.466415859099 | (37.7514640989736, -122.466415859099) | ||
| 51129 | 51129 | 45410 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 71 De Soto St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44213 | 5993067.86469343 | 2091642.16884569 | 37.7228530792724 | -122.46608862413 | (37.7228530792724, -122.46608862413) | ||
| 51322 | 51322 | 32829 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4255 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37187 | 6001551.51110422 | 2101720.28734658 | 37.7510110467741 | -122.437483847043 | (37.7510110467741, -122.437483847043) | ||
| 51518 | 51518 | 82782 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 285 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50432 | 6003797.68520335 | 2104478.00644987 | 37.758710538762 | -122.429913044242 | (37.758710538762, -122.429913044242) | ||
| 53239 | 53239 | 40427 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 572 Wildwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.46145953493901 | (37.7276267513816, -122.461459534939) | ||
| 53240 | 53240 | 32846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4290x 23RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit Number 37198 | 6001397.0 | 2102325.0 | 37.7526626570726 | -122.438061472785 | (37.7526626570726, -122.438061472785) | |
| 54626 | 54626 | 45131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43990 | 6000310.782626901 | 2109305.17604742 | 37.7717666625759 | -122.442318851526 | (37.7717666625759, -122.442318851526) | ||
| 54654 | 54654 | 47931 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 421 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45666 | 6000072.19761127 | 2095017.15680877 | 37.732521628448296 | -122.442118334295 | (37.7325216284483, -122.442118334295) | ||
| 55720 | 55720 | 67194 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 351 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30644 | 6007123.27859933 | 2096564.8875319 | 37.7371706731445 | -122.417850672524 | (37.7371706731445, -122.417850672524) | ||
| 58956 | 58956 | 42053 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 470 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42368 | 6003495.60283243 | 2099833.79882234 | 37.7459415266501 | -122.43062638702601 | (37.7459415266501, -122.430626387026) | ||
| 61492 | 61492 | 40445 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 201 Ellsworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/1999 12:00:00 AM | Permit Number 41532 | 6008126.9485778 | 2097682.94540443 | 37.7402970476748 | -122.41445960736799 | (37.7402970476748, -122.414459607368) | ||
| 62731 | 62731 | 43404 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43147 | 6000608.85784108 | 2102791.78597094 | 37.753899484954 | -122.440820481699 | (37.753899484954, -122.440820481699) | ||
| 62739 | 62739 | 38779 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 534 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.779032729498894 | -122.397541189965 | (37.7790327294989, -122.397541189965) | ||
| 65798 | 65798 | 49135 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46262 | 5996344.49436596 | 2094285.70346417 | 37.730300088752706 | -122.45495298879601 | (37.7303000887527, -122.454952988796) | ||
| 66036 | 66036 | 88055 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 52 Robblee Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3x3 | Permit Number 51065 | 6012498.0 | 2095923.9 | 37.735711666118604 | -122.39922270968201 | (37.7357116661186, -122.399222709682) | |||
| 67570 | 67570 | 52458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 557@ ANZA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | Permit Number 48569 | 5992189.638752901 | 2111651.23752465 | 37.777742101383794 | -122.470581063094 | (37.7777421013838, -122.470581063094) | ||
| 69276 | 69276 | 39031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009344.866 | 2105909.325 | 37.7629531959614 | -122.410829364237 | (37.7629531959614, -122.410829364237) | ||
| 71185 | 71185 | 64744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1988 12:00:00 AM | Permit Number 25706 | 6001496.66932698 | 2109419.88262313 | 37.7721491365124 | -122.43822501871 | (37.7721491365124, -122.43822501871) | ||
| 72159 | 72159 | 50345 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 Irving St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47028 | 5994078.33928892 | 2106636.06198176 | 37.7640807879805 | -122.463683361812 | (37.7640807879805, -122.463683361812) | |||
| 72473 | 72473 | 39099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3353 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40788 | 6005993.50178043 | 2103136.86299129 | 37.7551521778285 | -122.42222361067101 | (37.7551521778285, -122.422223610671) | ||
| 76169 | 76169 | 51818 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2005 12:00:00 AM | Permit Number 48061 | 6009275.17221026 | 2105665.92876427 | 37.7622809774576 | -122.411053219069 | (37.7622809774576, -122.411053219069) | ||
| 76346 | 76346 | 51950 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 505 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | Permit Number 48174 | 5993345.13352476 | 2105251.56144285 | 37.760237035945295 | -122.466118668568 | (37.7602370359453, -122.466118668568) | ||
| 76404 | 76404 | 47983 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1915 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | Permit Number 45717 | 5990305.10689708 | 2102341.79372017 | 37.7520717273737 | -122.47642001679701 | (37.7520717273737, -122.476420016797) | |||
| 76411 | 76411 | 49539 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 270 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46434 | 6008335.40255887 | 2109294.70940542 | 37.7721920194728 | -122.414560335389 | (37.7721920194728, -122.414560335389) | ||
| 76822 | 76822 | 51819 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | Permit Number 48061 | 6009275.17221026 | 2105665.92876427 | 37.7622809774576 | -122.411053219069 | (37.7622809774576, -122.411053219069) | |||
| 77300 | 77300 | 36709 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 31 Elgin Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | Permit Number 39497 | 6005838.81314888 | 2108913.44338097 | 37.7710045783198 | -122.42316915675501 | (37.7710045783198, -122.423169156755) | |||
| 77355 | 77355 | 97949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 Mendosa Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||||
| 77567 | 77567 | 31547 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 230 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45060 | 5998353.30570755 | 2112667.00543316 | 37.7808856171306 | -122.449332118202 | (37.7808856171306, -122.449332118202) | ||
| 77579 | 77579 | 31254 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991075.91901 | 2097809.61001 | 37.7396721973209 | -122.47342391940201 | (37.7396721973209, -122.473423919402) | ||
| 77601 | 77601 | 35956 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 338 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2000 12:00:00 AM | Permit Number 39114 | 6007098.24292142 | 2096514.81395524 | 37.7370317731807 | -122.41793368389999 | (37.7370317731807, -122.4179336839) | ||
| 77604 | 77604 | 47167 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 220 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45132 | 5992111.12252735 | 2095318.35041834 | 37.7328917184148 | -122.469663345403 | (37.7328917184148, -122.469663345403) | ||
| 77654 | 77654 | 114537 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 1624 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | 3x4 | 6009248.6 | 2099914.9 | 37.74648845381439 | -122.41073895467 | (37.7464884538144, -122.41073895467) | |||
| 77665 | 77665 | 39143 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3330 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40820 | 6007564.50118808 | 2100613.04522011 | 37.7483108345809 | -122.416611844962 | (37.7483108345809, -122.416611844962) | |||
| 77721 | 77721 | 88965 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Buena Vista East Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/2008 12:00:00 AM | 3x3 | Permit Number 51729 | 6001457.0 | 2108463.0 | 37.7695195187535 | -122.438293674292 | (37.7695195187535, -122.438293674292) | ||
| 77750 | 77750 | 48650 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 426 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45943 | 5993014.50141682 | 2103930.95922511 | 37.7565919256494 | -122.467166140324 | (37.7565919256494, -122.467166140324) | ||
| 77923 | 77923 | 46809 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 90 San Jacinto Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44892 | 5993785.91066901 | 2095094.03244535 | 37.732372453232 | -122.463856941781 | (37.732372453232, -122.463856941781) | ||
| 78054 | 78054 | 47993 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2582 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45725 | 5991769.8321385 | 2097864.05184963 | 37.739861839435 | -122.471028652434 | (37.739861839435, -122.471028652434) | ||
| 78060 | 78060 | 31092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 78092 | 78092 | 81703 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 728 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50044 | 6015682.09798099 | 2104903.80699852 | 37.7605455583769 | -122.388840669387 | (37.7605455583769, -122.388840669387) | ||
| 78135 | 78135 | 41141 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1901 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41876 | 5997475.24774631 | 2108806.66286617 | 37.7702358542847 | -122.452091128514 | (37.7702358542847, -122.452091128514) | ||
| 78359 | 78359 | 46917 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1221 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44973 | 5995133.00137739 | 2107226.62921874 | 37.7657630476681 | -122.460078405891 | (37.7657630476681, -122.460078405891) | ||
| 78409 | 78409 | 42377 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 601 Foerster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42549 | 5998097.42751354 | 2095265.42548706 | 37.733090576245104 | -122.448963434318 | (37.7330905762451, -122.448963434318) | |||
| 78524 | 78524 | 47338 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399X Vernon St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 78536 | 78536 | 38657 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1455 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1998 12:00:00 AM | Permit Number 40579 | 5994256.81380309 | 2105629.17606289 | 37.7613264236034 | -122.46299301746001 | (37.7613264236034, -122.46299301746) | |||
| 78540 | 78540 | 67176 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 320 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30622 | 6006979.64844614 | 2096524.9264163002 | 37.7370528645637 | -122.418344436004 | (37.7370528645637, -122.418344436004) | ||
| 78557 | 78557 | 35097 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 706 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38639 | 6002155.75551452 | 2089694.71254743 | 37.7180259181087 | -122.43453455761801 | (37.7180259181087, -122.434534557618) |
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");