trees
302 rows where qSpecies_id = 167 sorted by XCoord
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1517 | 19783 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
2582 | 19774 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY17 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
3812 | 19927 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
3853 | 19924 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
6216 | 19931 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
7721 | 19582 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY4 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
8077 | 19587 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY4 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
10276 | 20049 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY52 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | |||||||||||||
10775 | 19839 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY25 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
13835 | 20004 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY46 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | |||||||||||||
16360 | 19788 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
18770 | 19796 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY21 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
19416 | 20072 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY55 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 45X | |||||||||||||
53071 | 50352 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 658 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.8145 | 2111260.62712 | 37.7760557428917 | -122.506939675333 | (37.7760557428917, -122.506939675333) | 11 | 6 | 2 | 55 | 26 | ||
158248 | 50351 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 658 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.87041 | 2111242.23948 | 37.7760052591288 | -122.506938117672 | (37.7760052591288, -122.506938117672) | 11 | 6 | 2 | 55 | 26 | |
104075 | 119033 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 745 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5982267.74264 | 2110681.16094 | 37.7744998336605 | -122.504831829725 | (37.7744998336605, -122.504831829725) | 11 | 6 | 2 | 55 | 26 | |||
162518 | 51916 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1750 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2005 12:00:00 AM | 2 | Permit Number 48117 | 5982875.703 | 2103201.7552 | 37.7539992671341 | -122.502175211562 | (37.7539992671341, -122.502175211562) | 1 | 8 | 3 | 56 | 35 | ||
144382 | 117910 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 843 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5983532.20946 | 2110068.65579 | 37.7728923776477 | -122.500412569486 | (37.7728923776477, -122.500412569486) | 11 | 6 | 2 | 55 | 26 | |||
80699 | 185053 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2719 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983670.2351 | 2096626.4658 | 37.735991973866 | -122.498941812175 | (37.735991973866, -122.498941812175) | 1 | 8 | 3 | 29491 | 35 | |||
99655 | 58883 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1831 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1980 12:00:00 AM | 3 | Permit Number 18147 | 5984400.4624 | 2102704.4443 | 37.752723252787 | -122.496865608544 | (37.752723252787, -122.496865608544) | 1 | 8 | 3 | 56 | 35 | ||
189718 | 118270 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 775 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5984752.97057 | 2110594.13751 | 37.7744067825501 | -122.49622865438 | (37.7744067825501, -122.49622865438) | 11 | 6 | 2 | 55 | 26 | |||
135358 | 182279 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1496 Kirkham St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984984.0246 | 2105052.8568 | 37.7592055205034 | -122.495020725609 | (37.7592055205034, -122.495020725609) | 1 | 8 | 3 | 56 | 35 | |||
156886 | 118251 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 883 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5985085.51962 | 2109878.09808 | 37.7724602164796 | -122.495025511982 | (37.7724602164796, -122.495025511982) | 11 | 6 | 2 | 55 | 26 | |||
5094 | 60559 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 682 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 7 | Permit Number 20169 | 5985086.77627 | 2111238.89557 | 37.7761966512901 | -122.495121529295 | (37.7761966512901, -122.495121529295) | 11 | 6 | 2 | 55 | 26 | |
96292 | 118174 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 855 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5985693.27669 | 2109963.71146 | 37.7727308467676 | -122.492929558244 | (37.7727308467676, -122.492929558244) | 11 | 6 | 2 | 55 | 26 | |||
142059 | 111708 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 463 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5985915.33595 | 2112785.30995 | 37.780491135633 | -122.492369259237 | (37.780491135633, -122.492369259237) | 11 | 6 | 2 | 55 | 26 | |||
69673 | 185737 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2134 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986377.6988 | 2100714.0842 | 37.7473739221204 | -122.489881691592 | (37.7473739221204, -122.489881691592) | 1 | 8 | 3 | 29491 | 35 | |||
183518 | 181884 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2364 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986431.5008 | 2099166.4136 | 37.7431275754829 | -122.48958185913 | (37.7431275754829, -122.48958185913) | 1 | 8 | 3 | 29491 | 35 | |||
134630 | 181654 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1270 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5986485.9791 | 2106605.5895 | 37.7635567077637 | -122.489940517963 | (37.7635567077637, -122.489940517963) | 1 | 8 | 3 | 56 | 35 | |||
183117 | 181827 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2311 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986682.1022 | 2099505.6814 | 37.7440737416666 | -122.488740290538 | (37.7440737416666, -122.488740290538) | 1 | 8 | 3 | 29491 | 35 | |||
22590 | 181828 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2311 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5986682.779 | 2099487.7451 | 37.7440245328775 | -122.488736632211 | (37.7440245328775, -122.488736632211) | 1 | 8 | 3 | 29491 | 35 | |||
89413 | 182859 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1830 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986931.5262 | 2102786.1611 | 37.7530956091735 | -122.488118856463 | (37.7530956091735, -122.488118856463) | 1 | 8 | 3 | 56 | 35 | |||
70523 | 67971 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2643 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 2 | Permit Number 31692 | 5987328.75308 | 2111152.20759 | 37.7760896301586 | -122.48735965405 | (37.7760896301586, -122.48735965405) | 11 | 6 | 2 | 55 | 26 | |
192532 | 185747 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1802 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987565.4993 | 2100345.9151 | 37.7464323129859 | -122.48574739527 | (37.7464323129859, -122.48574739527) | 1 | 8 | 3 | 29491 | 35 | |||
62414 | 185746 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2195 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987582.8307 | 2100358.089 | 37.7464667491467 | -122.485688359332 | (37.7464667491467, -122.485688359332) | 1 | 8 | 3 | 29491 | 35 | |||
126638 | 185745 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2195 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987583.2114 | 2100377.5043 | 37.7465200805681 | -122.485688467617 | (37.7465200805681, -122.485688467617) | 1 | 8 | 3 | 29491 | 35 | |||
42259 | 183468 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2531 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987663.5713 | 2098059.3859 | 37.7401598234787 | -122.485240531105 | (37.7401598234787, -122.485240531105) | 1 | 8 | 3 | 29491 | 35 | |||
78638 | 181961 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2468 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987695.3371 | 2098486.355 | 37.741334018552 | -122.485162019071 | (37.741334018552, -122.485162019071) | 1 | 8 | 3 | 29491 | 35 | |||
98385 | 182117 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2468 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987697.3676 | 2098504.9682 | 37.7413852437695 | -122.48515636377 | (37.7413852437695, -122.48515636377) | 1 | 8 | 3 | 29491 | 35 | |||
185215 | 182092 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2691 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987764.3751 | 2098252.1671 | 37.7406950216778 | -122.484906136221 | (37.7406950216778, -122.484906136221) | 1 | 8 | 3 | 29491 | 35 | |||
114334 | 57241 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2630 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | 3 | Permit Number 14529 | 5987816.4921 | 2098311.7293 | 37.740861599204 | -122.484730305914 | (37.740861599204, -122.484730305914) | 1 | 8 | 3 | 29491 | 35 | ||
130298 | 182113 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2462 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5988005.6699 | 2098548.963 | 37.7415239963656 | -122.484093600478 | (37.7415239963656, -122.484093600478) | 1 | 8 | 3 | 29491 | 35 | |||
125996 | 61892 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1663 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/1985 12:00:00 AM | 5 | Permit Number 21935 | 5988700.7716 | 2104003.1782 | 37.7565402689029 | -122.482089681142 | (37.7565402689029, -122.482089681142) | 1 | 8 | 3 | 56 | 35 | |
24410 | 120407 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 647 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5988776.18848 | 2110908.47629 | 37.7755047148615 | -122.482334786454 | (37.7755047148615, -122.482334786454) | 11 | 6 | 2 | 55 | 26 | |||
125346 | 120351 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2122 Lake St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5988809.84875 | 2114710.37 | 37.7859456052715 | -122.482496990767 | (37.7859456052715, -122.482496990767) | 11 | 6 | 1 | 55 | 33 | |||
140530 | 120349 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2122 Lake St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5988820.20378 | 2114710.27627 | 37.7859459503003 | -122.482461158758 | (37.7859459503003, -122.482461158758) | 11 | 6 | 1 | 55 | 33 | |||
180995 | 68955 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 790 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 4 | Permit Number 32944 | 5988860.14903 | 2109950.32052 | 37.7728787684605 | -122.481974145233 | (37.7728787684605, -122.481974145233) | 11 | 6 | 2 | 55 | 26 | |
181274 | 60074 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1275 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1982 12:00:00 AM | 4 | Permit Number 19575 | 5988921.6846 | 2106672.1231 | 37.7638813163914 | -122.481521155686 | (37.7638813163914, -122.481521155686) | 1 | 8 | 3 | 56 | 35 | |
16791 | 71817 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1271 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988923.2164 | 2106695.866 | 37.7639465970002 | -122.481517596706 | (37.7639465970002, -122.481517596706) | 1 | 8 | 3 | 56 | 35 | |||
48565 | 60083 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1270 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1982 12:00:00 AM | 3 | Permit Number 19584 | 5988965.7237 | 2106688.207 | 37.7639280389731 | -122.481370017438 | (37.7639280389731, -122.481370017438) | 1 | 8 | 3 | 56 | 35 | |
141391 | 423 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1901X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5989520.14191 | 2114679.43534 | 37.785901962187 | -122.480037334344 | (37.785901962187, -122.480037334344) | 11 | 6 | 2 | 55 | 26 | |||
51250 | 85264 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
123284 | 85263 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
160965 | 85262 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
190777 | 85265 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
142626 | 424 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1901X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5989549.9462 | 2114680.69168 | 37.7859071433722 | -122.479934312872 | (37.7859071433722, -122.479934312872) | 11 | 6 | 2 | 55 | 26 | |||
28226 | 46608 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
110536 | 46606 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
113099 | 46607 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
121892 | 46605 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
9460 | 70130 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2614 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5990525.20475 | 2112006.61125 | 37.7786214745109 | -122.476364817556 | (37.7786214745109, -122.476364817556) | 11 | 6 | 2 | 55 | 26 | |||
68303 | 57628 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 534 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1990 12:00:00 AM | 7 | Permit Number 28866 | 5990653.09771 | 2111727.01603 | 37.7778611992683 | -122.475901966903 | (37.7778611992683, -122.475901966903) | 11 | 6 | 2 | 54 | 26 | ||
101584 | 213709 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1330 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990679.02857 | 2105217.07181 | 37.7599881592429 | -122.475336856123 | (37.7599881592429, -122.475336856123) | 1 | 8 | 4 | 56 | 12 | |||
98612 | 213708 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1330 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990694.19648 | 2105216.19153 | 37.7599866214079 | -122.475284333917 | (37.7599866214079, -122.475284333917) | 1 | 8 | 4 | 56 | 12 | |||
154831 | 12714 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1501 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5990789.16326 | 2114722.34 | 37.7860934167472 | -122.475650050524 | (37.7860934167472, -122.475650050524) | 11 | 6 | 2 | 54 | 26 | |||
46275 | 122127 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990810.49016 | 2114703.81512 | 37.7860437889569 | -122.475574912767 | (37.7860437889569, -122.475574912767) | 11 | 6 | 2 | 54 | 26 | |||
123954 | 122125 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990812.11385 | 2114674.53706 | 37.7859634937051 | -122.475567156694 | (37.7859634937051, -122.475567156694) | 11 | 6 | 2 | 54 | 26 | |||
26241 | 122126 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990812.19137 | 2114688.82235 | 37.7860027216168 | -122.47556793196 | (37.7860027216168, -122.47556793196) | 11 | 6 | 2 | 54 | 26 | |||
96337 | 122124 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990813.29617 | 2114656.20657 | 37.7859132318364 | -122.475561727296 | (37.7859132318364, -122.475561727296) | 11 | 6 | 2 | 54 | 26 | |||
142615 | 122123 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990814.40287 | 2114634.30613 | 37.7858531634971 | -122.475556298764 | (37.7858531634971, -122.475556298764) | 11 | 6 | 2 | 54 | 26 | |||
127515 | 65516 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 159 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1990 12:00:00 AM | 5 | Permit Number 28402 | 5990823.47806 | 2114342.11962 | 37.7850514269176 | -122.475503559583 | (37.7850514269176, -122.475503559583) | 11 | 6 | 2 | 54 | 26 | ||
163202 | 67421 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 511 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 5 | Permit Number 30922 | 5991237.50588 | 2111900.67959 | 37.7783718985889 | -122.473892988078 | (37.7783718985889, -122.473892988078) | 11 | 6 | 2 | 54 | 26 | |
106916 | 122160 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 547 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5991246.04787 | 2111677.18179 | 37.7777587296811 | -122.473847129053 | (37.7777587296811, -122.473847129053) | 11 | 6 | 2 | 54 | 26 | |||
152640 | 218233 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 365 Wawona St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 5991919.11048 | 2097078.05412 | 37.737712321755 | -122.470455286603 | (37.737712321755, -122.470455286603) | 1 | 8 | 4 | 59 | 40 | |||
138858 | 218234 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 363 Wawona St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 5991942.37249 | 2097100.26262 | 37.7377746456792 | -122.470376476289 | (37.7377746456792, -122.470376476289) | 1 | 8 | 4 | 59 | 40 | |||
127426 | 45342 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 466 Ralston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44172 | 5992247.31717609 | 2090977.05466926 | 37.7209794647769 | -122.46887668176 | (37.7209794647769, -122.46887668176) | 9 | 8 | 6 | 64 | 24 | ||
33084 | 47171 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 230 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | Permit Number 45135 | 5992362.95598719 | 2095257.05561838 | 37.7327379703821 | -122.468788241573 | (37.7327379703821, -122.468788241573) | 9 | 8 | 4 | 59 | 40 | ||
123721 | 122919 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 342 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992497.47697 | 2113139.63077 | 37.7818466194185 | -122.469624534307 | (37.7818466194185, -122.469624534307) | 11 | 6 | 2 | 54 | 11 | |||
156175 | 123146 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 560 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5992867.54706 | 2111680.63893 | 37.7778620058506 | -122.468238105016 | (37.7778620058506, -122.468238105016) | 11 | 6 | 2 | 54 | 11 | |||
78768 | 50189 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 350 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | Permit Number 46896 | 5992966.98430504 | 2103249.49310039 | 37.7547180534592 | -122.467280921215 | (37.7547180534592, -122.467280921215) | 1 | 8 | 4 | 56 | 12 | |||
133366 | 50190 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 350 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | Permit Number 46896 | 5992966.98430504 | 2103249.49310039 | 37.7547180534592 | -122.467280921215 | (37.7547180534592, -122.467280921215) | 1 | 8 | 4 | 56 | 12 | |||
85134 | 123200 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1310 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 5993097.33077 | 2112035.35395 | 37.7788492259481 | -122.467469010607 | (37.7788492259481, -122.467469010607) | 11 | 6 | 2 | 54 | 11 | |||
31006 | 44821 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1608 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2001 12:00:00 AM | Permit Number 43913 | 5993106.95790851 | 2104515.64796333 | 37.7582026654605 | -122.466888899121 | (37.7582026654605, -122.466888899121) | 1 | 8 | 4 | 56 | 12 | |||
62720 | 52648 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 542@ ANZA 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2010 12:00:00 AM | 2 | Permit Number 48732 | 5993472.64423 | 2111791.25598 | 37.7782006595283 | -122.466152920318 | (37.7782006595283, -122.466152920318) | 11 | 6 | 2 | 54 | 11 | ||
38211 | 123559 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 131 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 7ft | 5994253.7419 | 2114658.86132 | 37.7861193636966 | -122.463659017412 | (37.7861193636966, -122.463659017412) | 11 | 6 | 1 | 54 | 11 | |||
123939 | 123558 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 127 05th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 7ft | 5994253.98001 | 2114683.08774 | 37.7861858965782 | -122.463659952565 | (37.7861858965782, -122.463659952565) | 11 | 6 | 1 | 54 | 11 | |||
97673 | 123560 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 131 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 7ft | 5994254.42812 | 2114646.46204 | 37.7860853581858 | -122.463655743051 | (37.7860853581858, -122.463655743051) | 11 | 6 | 1 | 54 | 11 | |||
135657 | 218411 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 205 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5994290.42542 | 2100613.60822 | 37.7475568944299 | -122.462512951805 | (37.7475568944299, -122.462512951805) | 1 | 8 | 4 | 29491 | 40 | |||
79882 | 218412 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 205 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5994303.24232 | 2100628.09542 | 37.7475974107089 | -122.462469682732 | (37.7475974107089, -122.462469682732) | 1 | 8 | 4 | 29491 | 40 | |||
89930 | 67744 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1460 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31363 | 5994310.57601305 | 2105578.84704093 | 37.7611913298083 | -122.462803426682 | (37.7611913298083, -122.462803426682) | 1 | 5 | 11 | 56 | 12 | ||
164715 | 123860 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 346 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994375.95206 | 2114914.31886 | 37.7868278217721 | -122.463254749485 | (37.7868278217721, -122.463254749485) | 11 | 6 | 1 | 54 | 11 | |||
129448 | 123859 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 346 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994390.43638 | 2114914.64585 | 37.7868295540161 | -122.463204661228 | (37.7868295540161, -122.463204661228) | 11 | 6 | 1 | 54 | 11 | |||
41074 | 123858 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 346 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994396.82631 | 2114914.43525 | 37.7868293438726 | -122.463182538439 | (37.7868293438726, -122.463182538439) | 11 | 6 | 1 | 54 | 11 | |||
30195 | 123321 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 678 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994436.02989 | 2110905.44736 | 37.7758240001959 | -122.462755965315 | (37.7758240001959, -122.462755965315) | 11 | 6 | 2 | 54 | 11 | |||
53390 | 213716 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 252 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994453.52606 | 2088731.32317 | 37.7149404380182 | -122.461087834836 | (37.7149404380182, -122.461087834836) | 9 | 8 | 6 | 28861 | 24 | |||
192207 | 84853 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1338 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 6 | Permit No. 49311 | 5994481.6608 | 2112148.58575 | 37.779239954215 | -122.462688317698 | (37.779239954215, -122.462688317698) | 11 | 6 | 2 | 54 | 11 | ||
23016 | 60906 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1443 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20696 | 5994564.62076665 | 2105704.92459357 | 37.7615521348608 | -122.461933943385 | (37.7615521348608, -122.461933943385) | 1 | 5 | 11 | 56 | 12 | ||
140030 | 60907 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1491 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20697 | 5994575.4199228 | 2105392.22311625 | 37.7606941592004 | -122.461873918454 | (37.7606941592004, -122.461873918454) | 1 | 5 | 11 | 56 | 12 | ||
9760 | 74773 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2650 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5995110.10491 | 2110290.17085 | 37.7741734136379 | -122.460379593502 | (37.7741734136379, -122.460379593502) | 11 | 6 | 2 | 54 | 11 | |||
15367 | 74918 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2650 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5995120.86057 | 2110292.38931 | 37.7741801236558 | -122.460342548793 | (37.7741801236558, -122.460342548793) | 11 | 6 | 2 | 54 | 11 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );