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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63220 | 63220 | 135844 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1155 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6007360.5897 | 2119841.38777 | 37.801095804879395 | -122.418680361323 | (37.8010958048794, -122.418680361323) | |||
| 32114 | 32114 | 49856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 76@ LAGUNA Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 4 | Permit Number 46629 | 6003390.669840001 | 2119840.41127 | 37.80086881239821 | -122.432417918359 | (37.8008688123982, -122.432417918359) | ||
| 69090 | 69090 | 135843 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1175 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 6007285.978759999 | 2119831.2458099998 | 37.8010637566478 | -122.418937828239 | (37.8010637566478, -122.418937828239) | |||
| 155473 | 155473 | 135842 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1177 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6007263.48219 | 2119827.6474 | 37.801052609542396 | -122.419015420851 | (37.8010526095424, -122.419015420851) | ||||
| 58342 | 58342 | 135841 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1177 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6007250.45092 | 2119825.88461 | 37.801047035553005 | -122.41906038964 | (37.801047035553, -122.41906038964) | ||||
| 136919 | 136919 | 135840 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1177 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6007238.199519999 | 2119824.8673400003 | 37.8010435524736 | -122.419102712642 | (37.8010435524736, -122.419102712642) | ||||
| 165955 | 165955 | 135839 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1177 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6007217.01278 | 2119823.01799 | 37.8010372815012 | -122.419175896763 | (37.8010372815012, -122.419175896763) | ||||
| 71521 | 71521 | 135838 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1177 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6007200.951230001 | 2119822.58623 | 37.801035191466205 | -122.41923144609301 | (37.8010351914662, -122.419231446093) | ||||
| 163944 | 163944 | 135713 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3352 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6001841.02535 | 2119707.89268 | 37.8004169579239 | -122.43777083424999 | (37.8004169579239, -122.43777083425) | |||
| 53194 | 53194 | 55403 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1254 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/1973 12:00:00 AM | 7 | Permit Number 11342 | 6011509.51714 | 2119661.57098 | 37.8008347874628 | -122.404310539521 | (37.8008347874628, -122.404310539521) | ||
| 178181 | 178181 | 84230 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3340 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50110 | 6001852.41598 | 2119628.79841 | 37.8002004335541 | -122.437725750338 | (37.8002004335541, -122.437725750338) | |
| 186504 | 186504 | 143143 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2004 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002763.9046 | 2119588.4077 | 37.8001413162664 | -122.434568758341 | (37.8001413162664, -122.434568758341) | |||
| 185177 | 185177 | 135806 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Aladdin Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008809.714930001 | 2119549.2222700003 | 37.8003750720026 | -122.41364506887399 | (37.8003750720026, -122.413645068874) | |||
| 35890 | 35890 | 135711 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3213 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001339.31122 | 2119500.01762 | 37.799817647023204 | -122.439492052127 | (37.7998176470232, -122.439492052127) | |||
| 69143 | 69143 | 42839 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1167 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | 5 | Permit Number 42770 | 6007346.6476 | 2119488.5768 | 37.8001262898408 | -122.418703572815 | (37.8001262898408, -122.418703572815) | |
| 67626 | 67626 | 135712 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3213 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001342.317980001 | 2119480.82403 | 37.7997651176115 | -122.43948027100599 | (37.7997651176115, -122.439480271006) | |||
| 171583 | 171583 | 51940 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2630 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | 6 | Permit Number 48165 | 5999253.2670599995 | 2119447.9051599996 | 37.799555618746204 | -122.44670676162599 | (37.7995556187462, -122.446706761626) | ||
| 53990 | 53990 | 55104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3050 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 11 | Permit Number 11002 | 5999072.14016 | 2119290.80376 | 37.7991139122229 | -122.447322209969 | (37.7991139122229, -122.447322209969) | ||
| 70666 | 70666 | 55103 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3044 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 10 | Permit Number 11001 | 5999074.183780001 | 2119269.48917 | 37.7990555048549 | -122.447313603458 | (37.7990555048549, -122.447313603458) | ||
| 64977 | 64977 | 41637 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2129 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 10 | Permit Number 42115 | 6002696.74237 | 2119185.54816 | 37.7990313562755 | -122.43477234079701 | (37.7990313562755, -122.434772340797) | ||
| 33574 | 33574 | 53443 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 5 | Permit Number 23058 | 6007695.329609999 | 2119167.05545 | 37.7992630980807 | -122.41747419599899 | (37.7992630980807, -122.417474195999) | |
| 133944 | 133944 | 62976 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1950 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 7 | Permit Number 23365 | 6007747.12203 | 2119162.34513 | 37.7992530787278 | -122.417294641847 | (37.7992530787278, -122.417294641847) | |
| 177395 | 177395 | 135852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 13 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008609.879 | 2119160.01046 | 37.7992951697024 | -122.414309029333 | (37.7992951697024, -122.414309029333) | ||||
| 42353 | 42353 | 135819 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1955 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007698.59451 | 2119147.16202 | 37.799208659404705 | -122.417461487661 | (37.7992086594047, -122.417461487661) | |||
| 74744 | 74744 | 135820 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1955 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007700.92901 | 2119129.01998 | 37.7991589772563 | -122.417452123041 | (37.7991589772563, -122.417452123041) | |||
| 31396 | 31396 | 62715 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1941 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 6 | Permit Number 23057 | 6007704.91578 | 2119106.60942 | 37.7990976677838 | -122.417436738332 | (37.7990976677838, -122.417436738332) | |
| 185910 | 185910 | 80235 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1820 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2005 12:00:00 AM | 6 | 6004189.43733 | 2119092.90581 | 37.7988616164221 | -122.429600505158 | (37.7988616164221, -122.429600505158) | ||
| 142433 | 142433 | 65763 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3108 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1990 12:00:00 AM | Permit Number 28726 | 6003386.91158121 | 2119092.42392123 | 37.7988148202908 | -122.432377470763 | (37.7988148202908, -122.432377470763) | ||
| 109775 | 109775 | 65760 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3006 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | Permit Number 28723 | 6003874.32023721 | 2119083.36959063 | 37.7988175849493 | -122.43069023230301 | (37.7988175849493, -122.430690232303) | ||
| 93286 | 93286 | 62714 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1932 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 3 | Permit Number 23056 | 6007759.09173 | 2119080.02811 | 37.799027730202205 | -122.417247386069 | (37.7990277302022, -122.417247386069) | |
| 106570 | 106570 | 135821 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1941 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007709.39539 | 2119079.95376 | 37.7990247300556 | -122.417419347243 | (37.7990247300556, -122.417419347243) | |||
| 68847 | 68847 | 65773 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3000 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1990 12:00:00 AM | 10 | Permit Number 28738 | 6003871.55067 | 2119078.87066 | 37.7988050751409 | -122.43069949468901 | (37.7988050751409, -122.430699494689) | |
| 109665 | 109665 | 65761 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3004 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | Permit Number 28724 | 6003876.81074104 | 2119065.47051137 | 37.7987685797937 | -122.43068033640499 | (37.7987685797937, -122.430680336405) | ||
| 137494 | 137494 | 135822 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1941 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007711.58797 | 2119054.8847 | 37.7989560200535 | -122.41740998259199 | (37.7989560200535, -122.417409982592) | |||
| 42317 | 42317 | 135828 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008658.00325 | 2119030.21476 | 37.798941486106294 | -122.414133314422 | (37.7989414861063, -122.414133314422) | |||
| 53464 | 53464 | 65039 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1989 12:00:00 AM | 6 | Permit Number 26091 | 6008677.06955 | 2119030.1621 | 37.79894241240879 | -122.41406733476101 | (37.7989424124088, -122.414067334761) | ||
| 155763 | 155763 | 135834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008624.12392 | 2119028.66096 | 37.7989353167715 | -122.414250438519 | (37.7989353167715, -122.414250438519) | |||
| 51638 | 51638 | 135831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008642.5114400005 | 2119028.50949 | 37.7989359337052 | -122.41418680068199 | (37.7989359337052, -122.414186800682) | |||
| 57508 | 57508 | 135835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008609.072240001 | 2119027.30535 | 37.7989307491201 | -122.41430242651899 | (37.7989307491201, -122.414302426519) | |||
| 62925 | 62925 | 135836 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008591.776769999 | 2119025.88036 | 37.7989258649019 | -122.41436217388001 | (37.7989258649019, -122.41436217388) | |||
| 30016 | 30016 | 135826 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008677.52116 | 2119019.1422200003 | 37.798912179918396 | -122.414064992014 | (37.7989121799184, -122.414064992014) | ||||
| 63126 | 63126 | 135827 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008668.93858 | 2119018.75606 | 37.7989106375677 | -122.414094663337 | (37.7989106375677, -122.414094663337) | ||||
| 177555 | 177555 | 135829 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008653.20032 | 2119016.0444 | 37.798902308044205 | -122.414148931139 | (37.7989023080442, -122.414148931139) | ||||
| 170177 | 170177 | 135830 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008645.65329 | 2119014.61059 | 37.7988979472514 | -122.41417494494101 | (37.7988979472514, -122.414174944941) | ||||
| 156622 | 156622 | 135832 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6008638.145690001 | 2119013.6558 | 37.7988949039377 | -122.414200856206 | (37.7988949039377, -122.414200856206) | ||||
| 164608 | 164608 | 135833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008637.50385 | 2119009.84925 | 37.798884416044295 | -122.414202807733 | (37.7988844160443, -122.414202807733) | ||||
| 58123 | 58123 | 135674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2607 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005294.42245 | 2118983.21819 | 37.798622946255996 | -122.425769080284 | (37.798622946256, -122.425769080284) | |||
| 37959 | 37959 | 135675 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2607 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005294.83081 | 2118969.02728 | 37.79858400471289 | -122.42576665661501 | (37.7985840047129, -122.425766656615) | |||
| 161873 | 161873 | 135676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2607 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005296.87749 | 2118955.0352 | 37.798545701685796 | -122.425758578004 | (37.7985457016858, -122.425758578004) | |||
| 156672 | 156672 | 135677 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2607 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005298.2290900005 | 2118941.2899700003 | 37.7985080371669 | -122.425752922177 | (37.7985080371669, -122.425752922177) | |||
| 59030 | 59030 | 135678 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2607 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005300.04249 | 2118927.3026900003 | 37.7984697341355 | -122.42574565114501 | (37.7984697341355, -122.425745651145) | |||
| 79582 | 79582 | 42708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1600 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42723 | 6005315.92998199 | 2118904.40480493 | 37.7984077601464 | -122.42568904485 | (37.7984077601464, -122.42568904485) | |||
| 103465 | 103465 | 42706 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1600 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42723 | 6005315.92998199 | 2118904.40480493 | 37.7984077601464 | -122.42568904485 | (37.7984077601464, -122.42568904485) | |||
| 133766 | 133766 | 71441 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6012101.83844 | 2118902.5962 | 37.7987839069199 | -122.40220745600901 | (37.7987839069199, -122.402207456009) | ||
| 38064 | 38064 | 34679 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2069 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 4 | Permit Number 41918 | 6003062.63239 | 2118890.11528 | 37.7982409403347 | -122.43348511594 | (37.7982409403347, -122.43348511594) | |
| 20911 | 20911 | 50946 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1134 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | Permit Number 773916 | 6007565.24376916 | 2118876.40998362 | 37.7984577381814 | -122.417903725033 | (37.7984577381814, -122.417903725033) | ||
| 62244 | 62244 | 135810 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1170 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007401.7243099995 | 2118852.7144 | 37.7983834720705 | -122.41846787309099 | (37.7983834720705, -122.418467873091) | |||
| 133021 | 133021 | 135811 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1188 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007357.99127 | 2118847.16 | 37.7983657590324 | -122.418618809023 | (37.7983657590324, -122.418618809023) | |||
| 8653 | 8653 | 115708 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 778 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2016 12:00:00 AM | 3 | 3x3 | 6009816.75461 | 2118837.78852 | 37.798478147295 | -122.410110041641 | (37.798478147295, -122.410110041641) | ||
| 30497 | 30497 | 48978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2801 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2002 12:00:00 AM | 4 | Permit Number 46165 | 6004347.6822 | 2118813.41296 | 37.7981031596905 | -122.429032988006 | (37.7981031596905, -122.429032988006) | ||
| 159820 | 159820 | 135680 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2965 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999969.89702 | 2118779.79959 | 37.7977620890959 | -122.44417893732799 | (37.7977620890959, -122.444178937328) | |||
| 166741 | 166741 | 64612 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2319 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1988 12:00:00 AM | 7 | Permit Number 25517 | 6001847.87679 | 2118721.17617 | 37.797708083017795 | -122.437676419837 | (37.7977080830178, -122.437676419837) | ||
| 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) | ||||
| 175895 | 175895 | 135688 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2462 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001183.7049 | 2118673.4906200003 | 37.7975393647972 | -122.43997121002701 | (37.7975393647972, -122.439971210027) | |||
| 171682 | 171682 | 135825 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 941 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6008892.44244 | 2118672.21795 | 37.7979716806151 | -122.413296744356 | (37.7979716806151, -122.413296744356) | ||||
| 172165 | 172165 | 135823 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1015 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008630.162959999 | 2118635.32656 | 37.7978556572789 | -122.414201697946 | (37.7978556572789, -122.414201697946) | ||||
| 32547 | 32547 | 135824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1013 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6008637.906 | 2118634.49639 | 37.7978538127598 | -122.41417484600099 | (37.7978538127598, -122.414174846001) | ||||
| 41552 | 41552 | 113954 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1441 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009714.20821 | 2118628.8977900003 | 37.797898836429 | -122.41045012747601 | (37.797898836429, -122.410450127476) | |||
| 159532 | 159532 | 113955 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1441 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009717.4606099995 | 2118594.91218 | 37.7978057026147 | -122.41043647219101 | (37.7978057026147, -122.410436472191) | |||
| 3324 | 3324 | 113956 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1441 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2016 12:00:00 AM | 3 | 3x3 | 6009720.54591 | 2118583.26701 | 37.7977739007953 | -122.410424973449 | (37.7977739007953, -122.410424973449) | ||
| 168953 | 168953 | 38240 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2739 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 8 | Permit Number 40354 | 6004380.57558 | 2118579.5492599998 | 37.7974628918428 | -122.428902485571 | (37.7974628918428, -122.428902485571) | ||
| 184214 | 184214 | 58703 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2071 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/1979 12:00:00 AM | 9 | Permit Number 17934 | 6003107.4061 | 2118547.8738 | 37.7973037741068 | -122.433305717496 | (37.7973037741068, -122.433305717496) | ||
| 148943 | 148943 | 135709 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2071 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003106.8337900005 | 2118545.24301 | 37.79729651817139 | -122.43330750975001 | (37.7972965181714, -122.43330750975) | |||
| 145465 | 145465 | 64562 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1419 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/1988 12:00:00 AM | Permit Number 25454 | 6009728.96259143 | 2118520.44874424 | 37.797601889078 | -122.410391411409 | (37.797601889078, -122.410391411409) | ||
| 103282 | 103282 | 32265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2710 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36852 | 5999966.30908918 | 2118506.93389513 | 37.7970126676885 | -122.444171734786 | (37.7970126676885, -122.444171734786) | |||
| 65770 | 65770 | 32266 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2710 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 5 | Permit Number 36852 | 5999941.61226 | 2118499.92135 | 37.7969920041375 | -122.44425668730699 | (37.7969920041375, -122.444256687307) | ||
| 52615 | 52615 | 104476 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 350X Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2013 12:00:00 AM | 3 | 3x3 | Permit Number 767241 | 6012304.0596 | 2118478.64735 | 37.7976311307414 | -122.401477889986 | (37.7976311307414, -122.401477889986) | |
| 154755 | 154755 | 104477 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 350X Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2013 12:00:00 AM | 3 | 3x3 | Permit Number 767241 | 6012286.1108800005 | 2118476.9378299997 | 37.7976254353175 | -122.401539877573 | (37.7976254353175, -122.401539877573) | |
| 70278 | 70278 | 135710 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2729 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999774.17665 | 2118431.02433 | 37.796793277334 | -122.444831097785 | (37.796793277334, -122.444831097785) | |||
| 135457 | 135457 | 143551 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2265 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002172.1058 | 2118420.6348 | 37.7969013046984 | -122.436532977913 | (37.7969013046984, -122.436532977913) | |||
| 48276 | 48276 | 135684 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2265 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002168.82585 | 2118416.67733 | 37.7968902521339 | -122.436544043893 | (37.7968902521339, -122.436544043893) | |||
| 176499 | 176499 | 143550 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2265 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002152.3331 | 2118416.2408 | 37.796888116316296 | -122.436601081341 | (37.7968881163163, -122.436601081341) | |||
| 160626 | 160626 | 135683 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2265 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002155.230330001 | 2118414.35252 | 37.79688309623229 | -122.436590921031 | (37.7968830962323, -122.436590921031) | |||
| 187031 | 187031 | 48598 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1444 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45908 | 6006635.91115 | 2118390.9929400003 | 37.79707255999389 | -122.42108502346501 | (37.7970725599939, -122.421085023465) | |
| 34823 | 34823 | 135708 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2832 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000069.241909999 | 2118372.45038 | 37.7966492833012 | -122.443805896723 | (37.7966492833012, -122.443805896723) | |||
| 162823 | 162823 | 135707 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2832 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000071.16802 | 2118353.83197 | 37.796598271943395 | -122.443797893675 | (37.7965982719434, -122.443797893675) | |||
| 95885 | 95885 | 48597 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1441 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45907 | 6006664.55838561 | 2118346.44234334 | 37.7969518501088 | -122.420982732108 | (37.7969518501088, -122.420982732108) | ||
| 38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
| 135998 | 135998 | 135808 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1441 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006638.1665900005 | 2118343.33159 | 37.7969418210534 | -122.42107383319099 | (37.7969418210534, -122.421073833191) | |||
| 136772 | 136772 | 48430 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2460 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 6 | Permit Number 45807 | 6001222.52532 | 2118333.42094 | 37.7966078326421 | -122.439812486873 | (37.7966078326421, -122.439812486873) | |
| 62649 | 62649 | 135706 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2826 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000079.299380001 | 2118302.15962 | 37.7964568571549 | -122.443766043293 | (37.7964568571549, -122.443766043293) | |||
| 148727 | 148727 | 102782 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2485 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6001163.50399 | 2118281.2047900003 | 37.7964611010649 | -122.44001296732 | (37.7964611010649, -122.44001296732) | |||
| 155088 | 155088 | 135685 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2518 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000841.30899 | 2118279.85758 | 37.7964390550758 | -122.44112773188401 | (37.7964390550758, -122.441127731884) | |||
| 69229 | 69229 | 135686 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2518 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000832.47655 | 2118279.41325 | 37.7964373319644 | -122.44115826204701 | (37.7964373319644, -122.441158262047) | |||
| 176237 | 176237 | 135687 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2518 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000822.19713 | 2118277.58695 | 37.796431731896895 | -122.441193699853 | (37.7964317318969, -122.441193699853) | |||
| 146838 | 146838 | 54043 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2501 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52401 | 6000964.14248 | 2118251.24357 | 37.7963674843395 | -122.44070064921499 | (37.7963674843395, -122.440700649215) | |
| 77211 | 77211 | 135682 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2525 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000942.20858 | 2118246.4923400003 | 37.796353189610706 | -122.440776203963 | (37.7963531896107, -122.440776203963) | |||
| 116441 | 116441 | 135681 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2525 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000927.41477 | 2118244.96171 | 37.7963481443919 | -122.440827283678 | (37.7963481443919, -122.440827283678) | |||
| 148522 | 148522 | 66588 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2525 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1991 12:00:00 AM | 5 | Permit Number 29780 | 6000908.00991 | 2118243.52674 | 37.7963430991961 | -122.440894325413 | (37.7963430991961, -122.440894325413) | ||
| 29036 | 29036 | 68188 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2503 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1993 12:00:00 AM | 7 | Permit Number 31964 | 6004910.12814 | 2118236.0530000003 | 37.7965496977651 | -122.427045615765 | (37.7965496977651, -122.427045615765) |
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");