trees

302 rows where qSpecies_id = 167 sorted by TreeID

✎ 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)
89330 10116 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 842 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6005634.91055 2104075.87142 37.7577102430435 -122.423530480645 (37.7577102430435, -122.423530480645) 2 4 5 28859 19
111333 109267 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 900 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2015 12:00:00 AM 3 3x3 Permit Number 774687 6009897 2103882.5 37.7574189360449 -122.40877671519 (37.7574189360449, -122.40877671519) 2 4 7 28859 19
96098 109293 Permitted Site 7 Prunus blireiana :: Flowering Plum 167 370 27th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6004104.9 2100171.3 37.7469027259862 -122.428543573264 (37.7469027259862, -122.428543573264) 2 7 5 63 22
73664 110661 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 650 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003108.683 2110599.6041 37.7754799116102 -122.432733221791 (37.7754799116102, -122.432733221791) 15 9 11 29492 10
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
29782 115782 Undocumented 4 Prunus blireiana :: Flowering Plum 167 437 MISSISSIPPI ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2016 12:00:00 AM 3 3x3   6014121 2105062 37.7608932727115 -122.394250910939 (37.7608932727115, -122.394250910939) 10 3 8 28856 29
27952 117633 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2018 12:00:00 AM 3 3x3   5997552.92531 2115962.18049 37.7898874813666 -122.452338860365 (37.7898874813666, -122.452338860365) 11 6 1 54 31
158692 117634 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2018 12:00:00 AM 3 3x3   5997551.04889 2115977.76508 37.7899301649938 -122.452346477623 (37.7899301649938, -122.452346477623) 11 6 1 54 31
182253 117637 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 Locust St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5997541.40632 2116024.00549 37.7900565763988 -122.452383178041 (37.7900565763988, -122.452383178041) 11 6 1 54 31
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
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
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
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
116152 118369 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 55 Vandewater St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 2x2   6009060.6253 2121300.7581 37.8051984388103 -122.412900722184 (37.8051984388103, -122.412900722184) 3 1 10 308 23
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
22520 12417 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1691 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM 6 4X4   6004447.0274 2114613.1852 37.7865760223406 -122.428389697922 (37.7865760223406, -122.428389697922) 13 9 11 29490 13
106985 12418 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1691 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM 6 4X4   6004450.1666 2114579.9986 37.7864850778881 -122.428376470838 (37.7864850778881, -122.428376470838) 13 9 11 29490 13
53759 124233 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1 Paramount Ter 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5996645.22941 2111016.06725 37.7762547237702 -122.455121821521 (37.7762547237702, -122.455121821521) 11 6 2 54 16
45196 124234 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1 Paramount Ter 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5996623.51945 2111013.40479 37.7762461678144 -122.455196729351 (37.7762461678144, -122.455196729351) 11 6 2 54 16
50258 124235 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1 Paramount Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5996597.66018 2111009.83191 37.7762348739685 -122.455285924869 (37.7762348739685, -122.455285924869) 11 6 2 54 16
168954 124302 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 183 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5996217.53414 2113089.73746 37.7819239279859 -122.456751335801 (37.7819239279859, -122.456751335801) 11 6 1 54 31
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
48436 13239 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2335X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6001220.66377 2119285.57244 37.7992220840374 -122.439887231455 (37.7992220840374, -122.439887231455) 13 9 1 57 17
164404 136031 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1635 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6004020.9595 2120061.85215 37.8015125516123 -122.430252658446 (37.8015125516123, -122.430252658446) 13 9 1 57 17
122693 136032 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 100 Locust St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5997540.73441 2116039.76442 37.7900998077197 -122.452386640442 (37.7900998077197, -122.452386640442) 11 6 1 54 31
116017 136033 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1798 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002299.69392 2120568.99271 37.8028073820088 -122.436245318762 (37.8028073820088, -122.436245318762) 13 9 1 57 17
42336 136034 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1798 Bay St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002280.33301 2120565.85402 37.8027976639548 -122.436312092548 (37.8027976639548, -122.436312092548) 13 9 1 57 17
192734 136035 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1798 Bay St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002262.26199 2120563.69941 37.8027907211793 -122.436374473117 (37.8027907211793, -122.436374473117) 13 9 1 57 17
170313 137918 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1914 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6003425.977 2115322.684 37.7884662960967 -122.431972962095 (37.7884662960967, -122.431972962095) 13 9 1 29490 27
117990 138729 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1615 BAKER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6000051.0937 2114639.9425 37.7863997609352 -122.443600426882 (37.7863997609352, -122.443600426882) 15 6 1 29490 31
53680 138762 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1508 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2018 12:00:00 AM 3 Width 0ft Permit Number 782176 6000175.6546 2114135.1395 37.7850208059477 -122.443133211033 (37.7850208059477, -122.443133211033) 15 6 1 29490 27
147981 138763 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1508 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft Permit Number 782176 6000172.4842 2114147.0286 37.7850532695664 -122.443145033749 (37.7850532695664, -122.443145033749) 15 6 1 29490 27
106343 138764 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1508 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2018 12:00:00 AM 3 Width 0ft Permit Number 782176 6000169.3138 2114165.2585 37.7851031433792 -122.443157312033 (37.7851031433792, -122.443157312033) 15 6 1 29490 27
39527 139116 Undocumented 4 Prunus blireiana :: Flowering Plum 167 1501 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6004490.8408 2114272.6601 37.7856435047825 -122.428213836711 (37.7856435047825, -122.428213836711) 13 9 11 29490 13
153765 139117 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1501 LAGUNA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004494.7186 2114242.7456 37.785561586454 -122.428198287945 (37.785561586454, -122.428198287945) 13 9 11 29490 13
154216 139122 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1501 LAGUNA ST 7 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 0ft   6004515.7696 2114102.0367 37.7851764260276 -122.428115426505 (37.7851764260276, -122.428115426505) 13 9 11 29490 13
15806 139513 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1422 Fulton St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6000956.086 2111077.9238 37.7766709396845 -122.440213858451 (37.7766709396845, -122.440213858451) 15 5 11 29492 41
169133 140279 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2099 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5997824 2110223 37.774144722636 -122.450986949191 (37.774144722636, -122.450986949191) 15 5 11 29492 16
16161 140280 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2099 Grove St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3 Width 0ft   5997824 2110223 37.774144722636 -122.450986949191 (37.774144722636, -122.450986949191) 15 5 11 29492 16
45629 140281 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 2099 Grove St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997824 2110223 37.774144722636 -122.450986949191 (37.774144722636, -122.450986949191) 15 5 11 29492 16
31945 141596 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1457 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6000792.6568 2111003.6819 37.7764577843183 -122.440773879837 (37.7764577843183, -122.440773879837) 15 5 11 29492 10
144154 142051 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 32 ATALAYA TER 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998845.9761 2110971.5149 37.7762584069 -122.447505657858 (37.7762584069, -122.447505657858) 15 6 2 29492 16
6825 142622 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 651 GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6009763.2288 2120171.9265 37.8021383608566 -122.410389510852 (37.8021383608566, -122.410389510852) 3 1 10 308 23
172046 1641 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 859 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X3   5995651.21865 2110512.9681 37.774816268938 -122.458523928345 (37.774816268938, -122.458523928345) 11 6 2 54 11
96789 179167 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 111 Brunswick St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 1ft   6000723.35107 2087387.59269 37.7116096657128 -122.439320465973 (37.7116096657128, -122.439320465973) 9 7 6 28861 5
175231 179168 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 200x Mansell St 21 Median : Cutout Tree DPW 1     9 Width 0ft   6011032.14311 2090534.05643 37.7208304767293 -122.40391160924 (37.7208304767293, -122.40391160924) 10 3 7 309 28
42783 179169 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 7 Teddy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6011399.30958 2087676.99992 37.7130060844452 -122.402441626885 (37.7130060844452, -122.402441626885) 9 7 8 309 39
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
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
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
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
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
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
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
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
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
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
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
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
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
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
131218 187550 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 15 Chicago Way 2 : Tree Private 2     6 Width 3ft   6003854.31887 2086791.04585 37.7101493555763 -122.428456511776 (37.7101493555763, -122.428456511776) 9 7 6 309 5
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                      
38410 196516 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 948 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6015218.63504 2104201.55531 37.7585916272177 -122.390394521914 (37.7585916272177, -122.390394521914) 10 3 8 28856 29
102825 196517 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1     6014492.80276 2101818.43499 37.7520077993331 -122.392738083189 (37.7520077993331, -122.392738083189) 10 3 8 28856 1
54150 196518 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1     6014492.91389 2101810.69981 37.7519865663454 -122.392737157804 (37.7519865663454, -122.392737157804) 10 3 8 28856 1
1951 196519 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1     6014493.82827 2101802.94838 37.7519653333515 -122.392733453506 (37.7519653333515, -122.392733453506) 10 3 8 28856 1
128132 196520 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 6 Sidewalk: Curb side : Yard Tree Private 2     1     6014495.9358 2101776.59314 37.7518930845169 -122.392724321763 (37.7518930845169, -122.392724321763) 10 3 8 28856 1
27193 196521 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1100 Pennsylvania Ave 7 Sidewalk: Curb side : Yard Tree Private 2     1     6014496.49753 2101766.20536 37.7518645930792 -122.392721652585 (37.7518645930792, -122.392721652585) 10 3 8 28856 1
107498 196522 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1801 Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011980.51858 2106049.29218 37.7634849464005 -122.401723334779 (37.7634849464005, -122.401723334779) 8 3 8 28856 29
91244 196523 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1801 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011996.40725 2106050.20307 37.7634883341404 -122.401668444652 (37.7634883341404, -122.401668444652) 8 3 8 28856 29
76925 196524 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 500 De Haro St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6012039.23838 2106001.02013 37.7633556787538 -122.401516847728 (37.7633556787538, -122.401516847728) 8 3 8 28856 29
36460 196525 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 777 Rhode Island St 2 : Tree Private 2     5 Width 3ft   6011871.67435 2104748.04731 37.7599059432265 -122.402008311954 (37.7599059432265, -122.402008311954) 10 3 8 28856 29
174135 196526 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1327 Rhode Island St 1 : Tree Private 2     7 Width 3ft   6012008.29844 2102189.51462 37.752888399289 -122.401355988709 (37.752888399289, -122.401355988709) 10 3 8 28856 29
163456 196527 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 333 Texas St 1 : Tree Private 2     1 Width 3ft   6013792.65149 2105531.32389 37.7621636768226 -122.395419411895 (37.7621636768226, -122.395419411895) 10 3 8 28856 29
140595 196528 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 400 Texas St 1 : Tree Private 2     5 Width 3ft   6013752.07769 2105195.94744 37.7612405497197 -122.395536244627 (37.7612405497197, -122.395536244627) 10 3 8 28856 29
109538 196529 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1150 19th St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6014166.99848 2105290.36806 37.7615228783907 -122.394107809149 (37.7615228783907, -122.394107809149) 10 3 8 28856 29
183391 196530 DPW Maintained 1 Prunus blireiana :: Flowering Plum 167 1150 19th St 5 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6014129.09689 2105289.45573 37.7615182666641 -122.394238832278 (37.7615182666641, -122.394238832278) 10 3 8 28856 29

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