trees

302 rows where qSpecies_id = 167 sorted by XCoord

✎ View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);