Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 639 | 639 | 20004 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY46 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | ||||||||
| 3857 | 3857 | 19783 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY19 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 6884 | 6884 | 19587 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY4 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 7112 | 7112 | 19788 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY19 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 7362 | 7362 | 19927 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY37 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 9531 | 9531 | 19924 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY37 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 9569 | 9569 | 19774 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY17 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20ST | ||||||||
| 12606 | 12606 | 19931 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY37 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 12836 | 12836 | 20072 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY55 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 45X | ||||||||
| 13148 | 13148 | 19582 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY4 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14532 | 14532 | 19839 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY25 | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 16568 | 16568 | 20049 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY52 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10 | ||||||||
| 16936 | 16936 | 19796 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 188154 | 188154 | 50352 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 658 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.8145 | 2111260.62712 | 37.7760557428917 | -122.506939675333 | (37.7760557428917, -122.506939675333) | ||
| 33410 | 33410 | 50351 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 658 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.87041 | 2111242.23948 | 37.776005259128794 | -122.50693811767201 | (37.7760052591288, -122.506938117672) | |
| 188721 | 188721 | 119033 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 745 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5982267.74264 | 2110681.1609400003 | 37.7744998336605 | -122.50483182972499 | (37.7744998336605, -122.504831829725) | |||
| 184473 | 184473 | 51916 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1750 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2005 12:00:00 AM | 2 | Permit Number 48117 | 5982875.703 | 2103201.7552 | 37.753999267134105 | -122.502175211562 | (37.7539992671341, -122.502175211562) | ||
| 154601 | 154601 | 117910 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 843 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983532.20946 | 2110068.65579 | 37.77289237764771 | -122.500412569486 | (37.7728923776477, -122.500412569486) | |||
| 51635 | 51635 | 185053 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2719 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983670.2351 | 2096626.4658 | 37.735991973866 | -122.498941812175 | (37.735991973866, -122.498941812175) | |||
| 178897 | 178897 | 58883 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1831 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1980 12:00:00 AM | 3 | Permit Number 18147 | 5984400.4624 | 2102704.4443 | 37.752723252787 | -122.49686560854401 | (37.752723252787, -122.496865608544) | ||
| 132214 | 132214 | 118270 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 775 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5984752.97057 | 2110594.13751 | 37.7744067825501 | -122.49622865437999 | (37.7744067825501, -122.49622865438) | |||
| 60107 | 60107 | 60559 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 682 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 7 | Permit Number 20169 | 5985086.776269999 | 2111238.89557 | 37.7761966512901 | -122.495121529295 | (37.7761966512901, -122.495121529295) | |
| 165589 | 165589 | 118251 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 883 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5985085.519619999 | 2109878.09808 | 37.7724602164796 | -122.495025511982 | (37.7724602164796, -122.495025511982) | |||
| 183610 | 183610 | 182279 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1496 Kirkham St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5984984.0246 | 2105052.8568 | 37.7592055205034 | -122.495020725609 | (37.7592055205034, -122.495020725609) | |||
| 168736 | 168736 | 118174 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 855 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5985693.27669 | 2109963.71146 | 37.7727308467676 | -122.492929558244 | (37.7727308467676, -122.492929558244) | |||
| 40329 | 40329 | 111708 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 463 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5985915.33595 | 2112785.30995 | 37.780491135633 | -122.49236925923701 | (37.780491135633, -122.492369259237) | |||
| 35989 | 35989 | 181654 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1270 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986485.9791 | 2106605.5895 | 37.763556707763705 | -122.489940517963 | (37.7635567077637, -122.489940517963) | |||
| 76415 | 76415 | 185737 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2134 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986377.6988 | 2100714.0842 | 37.7473739221204 | -122.489881691592 | (37.7473739221204, -122.489881691592) | |||
| 179899 | 179899 | 181884 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2364 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986431.5008 | 2099166.4136 | 37.743127575482895 | -122.48958185913 | (37.7431275754829, -122.48958185913) | |||
| 187006 | 187006 | 181827 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2311 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986682.1022 | 2099505.6814 | 37.744073741666604 | -122.488740290538 | (37.7440737416666, -122.488740290538) | |||
| 44368 | 44368 | 181828 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2311 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5986682.779 | 2099487.7451 | 37.744024532877496 | -122.488736632211 | (37.7440245328775, -122.488736632211) | |||
| 72911 | 72911 | 182859 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1830 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986931.5262 | 2102786.1611 | 37.7530956091735 | -122.48811885646299 | (37.7530956091735, -122.488118856463) | |||
| 73471 | 73471 | 67971 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2643 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 2 | Permit Number 31692 | 5987328.75308 | 2111152.2075900002 | 37.7760896301586 | -122.48735965405001 | (37.7760896301586, -122.48735965405) | |
| 156015 | 156015 | 185747 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1802 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987565.4993 | 2100345.9151 | 37.746432312985895 | -122.48574739527001 | (37.7464323129859, -122.48574739527) | |||
| 73399 | 73399 | 185745 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2195 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987583.2114 | 2100377.5043 | 37.746520080568104 | -122.485688467617 | (37.7465200805681, -122.485688467617) | |||
| 50786 | 50786 | 185746 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2195 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987582.8307 | 2100358.089 | 37.746466749146705 | -122.485688359332 | (37.7464667491467, -122.485688359332) | |||
| 166277 | 166277 | 183468 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2531 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987663.5713 | 2098059.3859 | 37.740159823478706 | -122.485240531105 | (37.7401598234787, -122.485240531105) | |||
| 73862 | 73862 | 181961 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2468 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987695.3371 | 2098486.355 | 37.741334018551996 | -122.48516201907101 | (37.741334018552, -122.485162019071) | |||
| 184116 | 184116 | 182117 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2468 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987697.3676 | 2098504.9682 | 37.7413852437695 | -122.48515636376999 | (37.7413852437695, -122.48515636377) | |||
| 55844 | 55844 | 182092 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2691 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987764.3751 | 2098252.1671 | 37.7406950216778 | -122.48490613622101 | (37.7406950216778, -122.484906136221) | |||
| 147130 | 147130 | 57241 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2630 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1975 12:00:00 AM | 3 | Permit Number 14529 | 5987816.4921 | 2098311.7293 | 37.740861599204 | -122.484730305914 | (37.740861599204, -122.484730305914) | ||
| 54491 | 54491 | 182113 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2462 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5988005.6699 | 2098548.963 | 37.7415239963656 | -122.484093600478 | (37.7415239963656, -122.484093600478) | |||
| 64692 | 64692 | 120351 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2122 Lake St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988809.84875 | 2114710.37 | 37.7859456052715 | -122.482496990767 | (37.7859456052715, -122.482496990767) | |||
| 72171 | 72171 | 120349 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2122 Lake St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5988820.20378 | 2114710.2762700003 | 37.785945950300295 | -122.48246115875799 | (37.7859459503003, -122.482461158758) | |||
| 40780 | 40780 | 120407 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 647 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5988776.18848 | 2110908.47629 | 37.7755047148615 | -122.48233478645399 | (37.7755047148615, -122.482334786454) | |||
| 157060 | 157060 | 61892 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1663 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/1985 12:00:00 AM | 5 | Permit Number 21935 | 5988700.7716 | 2104003.1782 | 37.756540268902896 | -122.482089681142 | (37.7565402689029, -122.482089681142) | |
| 75037 | 75037 | 68955 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 790 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 4 | Permit Number 32944 | 5988860.14903 | 2109950.32052 | 37.7728787684605 | -122.481974145233 | (37.7728787684605, -122.481974145233) | |
| 25559 | 25559 | 60074 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1275 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 4 | Permit Number 19575 | 5988921.6846 | 2106672.1231 | 37.7638813163914 | -122.481521155686 | (37.7638813163914, -122.481521155686) | |
| 161340 | 161340 | 71817 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1271 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/1982 12:00:00 AM | 4 | 5988923.2164 | 2106695.866 | 37.763946597000206 | -122.48151759670601 | (37.7639465970002, -122.481517596706) | ||
| 32670 | 32670 | 60083 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1270 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 3 | Permit Number 19584 | 5988965.7237 | 2106688.207 | 37.763928038973106 | -122.481370017438 | (37.7639280389731, -122.481370017438) | |
| 114406 | 114406 | 423 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1901X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989520.14191 | 2114679.4353400003 | 37.785901962187 | -122.480037334344 | (37.785901962187, -122.480037334344) | |||
| 89647 | 89647 | 424 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1901X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989549.9462 | 2114680.6916799997 | 37.7859071433722 | -122.479934312872 | (37.7859071433722, -122.479934312872) | |||
| 81355 | 81355 | 85264 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3000 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.73354054474329 | -122.478606721292 | (37.7335405447433, -122.478606721292) | |||
| 107435 | 107435 | 85263 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3000 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.73354054474329 | -122.478606721292 | (37.7335405447433, -122.478606721292) | |||
| 119020 | 119020 | 85262 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3000 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.73354054474329 | -122.478606721292 | (37.7335405447433, -122.478606721292) | |||
| 145160 | 145160 | 85265 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3000 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.73354054474329 | -122.478606721292 | (37.7335405447433, -122.478606721292) | |||
| 161889 | 161889 | 70130 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2614 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 3 | 5990525.20475 | 2112006.61125 | 37.7786214745109 | -122.476364817556 | (37.7786214745109, -122.476364817556) | ||
| 98072 | 98072 | 46607 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 100822 | 100822 | 46606 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 109435 | 109435 | 46605 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 129109 | 129109 | 46608 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 65988 | 65988 | 57628 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 534 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1990 12:00:00 AM | 7 | Permit Number 28866 | 5990653.097709999 | 2111727.01603 | 37.7778611992683 | -122.475901966903 | (37.7778611992683, -122.475901966903) | ||
| 146116 | 146116 | 12714 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1501 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5990789.16326 | 2114722.34 | 37.7860934167472 | -122.47565005052401 | (37.7860934167472, -122.475650050524) | |||
| 44776 | 44776 | 122127 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990810.49016 | 2114703.81512 | 37.7860437889569 | -122.47557491276699 | (37.7860437889569, -122.475574912767) | |||
| 26103 | 26103 | 122126 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990812.19137 | 2114688.82235 | 37.786002721616796 | -122.47556793196001 | (37.7860027216168, -122.47556793196) | |||
| 75324 | 75324 | 122125 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990812.11385 | 2114674.53706 | 37.785963493705104 | -122.475567156694 | (37.7859634937051, -122.475567156694) | |||
| 61171 | 61171 | 122124 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990813.29617 | 2114656.20657 | 37.7859132318364 | -122.47556172729601 | (37.7859132318364, -122.475561727296) | |||
| 32949 | 32949 | 122123 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990814.402869999 | 2114634.30613 | 37.7858531634971 | -122.475556298764 | (37.7858531634971, -122.475556298764) | |||
| 27673 | 27673 | 65516 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 159 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1990 12:00:00 AM | 5 | Permit Number 28402 | 5990823.47806 | 2114342.11962 | 37.7850514269176 | -122.47550355958299 | (37.7850514269176, -122.475503559583) | ||
| 180414 | 180414 | 213709 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1330 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990679.02857 | 2105217.0718099996 | 37.759988159242894 | -122.47533685612301 | (37.7599881592429, -122.475336856123) | |||
| 130999 | 130999 | 213708 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1330 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990694.19648 | 2105216.19153 | 37.7599866214079 | -122.475284333917 | (37.7599866214079, -122.475284333917) | |||
| 127112 | 127112 | 67421 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 511 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 5 | Permit Number 30922 | 5991237.50588 | 2111900.6795900003 | 37.7783718985889 | -122.473892988078 | (37.7783718985889, -122.473892988078) | |
| 168107 | 168107 | 122160 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 547 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5991246.04787 | 2111677.1817900003 | 37.7777587296811 | -122.473847129053 | (37.7777587296811, -122.473847129053) | |||
| 41456 | 41456 | 218233 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 365 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5991919.11048 | 2097078.05412 | 37.737712321755 | -122.470455286603 | (37.737712321755, -122.470455286603) | |||
| 136972 | 136972 | 218234 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 363 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5991942.37249 | 2097100.2626200002 | 37.7377746456792 | -122.470376476289 | (37.7377746456792, -122.470376476289) | |||
| 183161 | 183161 | 122919 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 342 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992497.476969999 | 2113139.63077 | 37.7818466194185 | -122.469624534307 | (37.7818466194185, -122.469624534307) | |||
| 106268 | 106268 | 45342 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 466 Ralston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44172 | 5992247.31717609 | 2090977.05466926 | 37.720979464776896 | -122.46887668176001 | (37.7209794647769, -122.46887668176) | ||
| 127031 | 127031 | 47171 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 230 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45135 | 5992362.95598719 | 2095257.05561838 | 37.732737970382104 | -122.46878824157301 | (37.7327379703821, -122.468788241573) | ||
| 171308 | 171308 | 123146 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 560 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5992867.54706 | 2111680.63893 | 37.7778620058506 | -122.468238105016 | (37.7778620058506, -122.468238105016) | |||
| 174102 | 174102 | 123200 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1310 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 5993097.33077 | 2112035.35395 | 37.7788492259481 | -122.46746901060699 | (37.7788492259481, -122.467469010607) | |||
| 95806 | 95806 | 50189 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 350 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46896 | 5992966.98430504 | 2103249.49310039 | 37.7547180534592 | -122.467280921215 | (37.7547180534592, -122.467280921215) | |||
| 115204 | 115204 | 50190 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 350 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46896 | 5992966.98430504 | 2103249.49310039 | 37.7547180534592 | -122.467280921215 | (37.7547180534592, -122.467280921215) | |||
| 125108 | 125108 | 44821 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1608 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2001 12:00:00 AM | Permit Number 43913 | 5993106.95790851 | 2104515.64796333 | 37.7582026654605 | -122.466888899121 | (37.7582026654605, -122.466888899121) | |||
| 25106 | 25106 | 52648 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 542@ ANZA 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2010 12:00:00 AM | 2 | Permit Number 48732 | 5993472.644230001 | 2111791.25598 | 37.778200659528295 | -122.466152920318 | (37.7782006595283, -122.466152920318) | ||
| 147059 | 147059 | 123558 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 127 05th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 7ft | 5994253.98001 | 2114683.0877400003 | 37.7861858965782 | -122.463659952565 | (37.7861858965782, -122.463659952565) | |||
| 177425 | 177425 | 123559 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 131 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 7ft | 5994253.7419 | 2114658.86132 | 37.786119363696606 | -122.463659017412 | (37.7861193636966, -122.463659017412) | |||
| 164331 | 164331 | 123560 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 131 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 7ft | 5994254.428119999 | 2114646.46204 | 37.786085358185794 | -122.46365574305099 | (37.7860853581858, -122.463655743051) | |||
| 135378 | 135378 | 123860 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 346 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994375.95206 | 2114914.31886 | 37.7868278217721 | -122.463254749485 | (37.7868278217721, -122.463254749485) | |||
| 69911 | 69911 | 123859 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 346 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994390.43638 | 2114914.64585 | 37.7868295540161 | -122.463204661228 | (37.7868295540161, -122.463204661228) | |||
| 67945 | 67945 | 123858 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 346 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994396.826309999 | 2114914.43525 | 37.7868293438726 | -122.463182538439 | (37.7868293438726, -122.463182538439) | |||
| 95757 | 95757 | 67744 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1460 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31363 | 5994310.57601305 | 2105578.84704093 | 37.7611913298083 | -122.462803426682 | (37.7611913298083, -122.462803426682) | ||
| 70655 | 70655 | 123321 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 678 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994436.02989 | 2110905.4473599996 | 37.7758240001959 | -122.462755965315 | (37.7758240001959, -122.462755965315) | |||
| 185593 | 185593 | 84853 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1338 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 6 | Permit No. 49311 | 5994481.6608 | 2112148.58575 | 37.779239954215 | -122.462688317698 | (37.779239954215, -122.462688317698) | ||
| 173109 | 173109 | 218411 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 205 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5994290.425419999 | 2100613.6082200003 | 37.7475568944299 | -122.462512951805 | (37.7475568944299, -122.462512951805) | |||
| 39114 | 39114 | 218412 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 205 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5994303.242319999 | 2100628.09542 | 37.7475974107089 | -122.46246968273199 | (37.7475974107089, -122.462469682732) | |||
| 125587 | 125587 | 60906 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1443 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20696 | 5994564.62076665 | 2105704.92459357 | 37.7615521348608 | -122.46193394338499 | (37.7615521348608, -122.461933943385) | ||
| 112706 | 112706 | 60907 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1491 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20697 | 5994575.4199228 | 2105392.22311625 | 37.7606941592004 | -122.461873918454 | (37.7606941592004, -122.461873918454) | ||
| 53624 | 53624 | 213716 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 252 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994453.52606 | 2088731.32317 | 37.7149404380182 | -122.46108783483601 | (37.7149404380182, -122.461087834836) | |||
| 130833 | 130833 | 74773 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2650 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 4 | 5995110.10491 | 2110290.17085 | 37.774173413637904 | -122.46037959350201 | (37.7741734136379, -122.460379593502) | ||
| 134191 | 134191 | 74918 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2650 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 4 | 5995120.86057 | 2110292.38931 | 37.774180123655796 | -122.460342548793 | (37.7741801236558, -122.460342548793) |
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");