trees
302 rows where qSpecies_id = 167 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1067 | 238562 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 623 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002513.88087 | 2098855.53984 | 37.7431997906349 | -122.433951130242 | (37.7431997906349, -122.433951130242) | 2 | 7 | 5 | 63 | 7 | |||
1517 | 19783 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
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 | ||||
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 | |||||||||||||
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 | |||
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 | |||||||||||||
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 | |||
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 | |||
10103 | 238559 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 358 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004157.57388 | 2100161.25542 | 37.7468781266282 | -122.428360715999 | (37.7468781266282, -122.428360715999) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||||||||||||
12266 | 246192 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 755 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999893.4495 | 2108060.1682 | 37.7683243897923 | -122.443672973707 | (37.7683243897923, -122.443672973707) | 15 | 5 | 11 | 29492 | 9 | |||
13835 | 20004 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY46 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | |||||||||||||
14594 | 238571 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1474 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003271.46405 | 2099643.85136 | 37.7454072746301 | -122.431387870873 | (37.7454072746301, -122.431387870873) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
16360 | 19788 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
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 | |||
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 | |||||||||||||
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 | |||
22807 | 238573 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 414 Collingwood St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6002098.58859 | 2103426.99001 | 37.7557283324208 | -122.435714094642 | (37.7557283324208, -122.435714094642) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |||
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 | |||
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 | ||||
28650 | 238570 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1474 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003271.44835 | 2099657.02659 | 37.745443449856 | -122.431388865507 | (37.745443449856, -122.431388865507) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
31744 | 238553 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 226 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004403.59335 | 2099297.10954 | 37.7445192993223 | -122.427448451804 | (37.7445192993223, -122.427448451804) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
33119 | 213714 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999173.83796 | 2093468.34199 | 37.7282177076567 | -122.445112858974 | (37.7282177076567, -122.445112858974) | 9 | 7 | 4 | 28861 | 40 | |||
34573 | 238557 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 4014 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6003783.51976 | 2100724.3526 | 37.7484030872306 | -122.429694315247 | (37.7484030872306, -122.429694315247) | 2 | 4 | 5 | 28862 | 22 | |||
34949 | 238549 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Mullen Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009831.14885 | 2099860.0052 | 37.7463703703058 | -122.408720684427 | (37.7463703703058, -122.408720684427) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
37321 | 238556 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003884.87618 | 2100253.42684 | 37.7471157733724 | -122.429310250782 | (37.7471157733724, -122.429310250782) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
39125 | 246183 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 789 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999949.17 | 2108240.0487 | 37.7688214743495 | -122.443493165297 | (37.7688214743495, -122.443493165297) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||||
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 | |||
41106 | 238565 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 625 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002419.36541 | 2100030.86231 | 37.7464215867002 | -122.434361951369 | (37.7464215867002, -122.434361951369) | 2 | 7 | 5 | 63 | 22 | |||
42239 | 238547 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 178 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009850.79636 | 2100052.59551 | 37.7469002814368 | -122.408666329408 | (37.7469002814368, -122.408666329408) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
50588 | 238552 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 263 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004835.34917 | 2098981.16674 | 37.7436762029056 | -122.425933041078 | (37.7436762029056, -122.425933041078) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
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 | ||||
55618 | 238558 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 29 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004887.16641 | 2101620.38269 | 37.7509258105963 | -122.425941700662 | (37.7509258105963, -122.425941700662) | 2 | 4 | 5 | 28862 | 22 | |||
56706 | 238550 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 263 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004819.40708 | 2098979.89063 | 37.7436717980264 | -122.425988074184 | (37.7436717980264, -122.425988074184) | 2 | 7 | 5 | 63 | 22 | |||
57104 | 238543 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3765 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005249.86202 | 2104271.17824 | 37.7582247685753 | -122.4248760328 | (37.7582247685753, -122.4248760328) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
62703 | 238563 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 552 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002357.1288 | 2099469.61588 | 37.7448770028803 | -122.434537034955 | (37.7448770028803, -122.434537034955) | 2 | 7 | 5 | 63 | 22 | |||
66168 | 246649 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 10 | Side Yard : Yard | Tree | Private 2 | 5 | 6009030.81997 | 2099159.02309 | 37.744400769587 | -122.411438624517 | (37.744400769587, -122.411438624517) | 2 | 7 | 7 | 28859 | 2 | ||||
67328 | 196531 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014106.81933 | 2105287.87473 | 37.7615126872711 | -122.394315771076 | (37.7615126872711, -122.394315771076) | 10 | 3 | 8 | 28856 | 29 | |||
68867 | 238555 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1519 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003981.56028 | 2099428.33383 | 37.7448557321227 | -122.428917110339 | (37.7448557321227, -122.428917110339) | 2 | 7 | 5 | 63 | 22 | |||
69449 | 213711 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 38 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000905.90328 | 2094365.19154 | 37.7307789597781 | -122.439189308837 | (37.7307789597781, -122.439189308837) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
72104 | 238572 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 414 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6002097.32586 | 2103433.45375 | 37.7557460085737 | -122.435718923989 | (37.7557460085737, -122.435718923989) | 2 | 4 | 5 | 28862 | 22 | ||||
73507 | 238544 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1673 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009719.77093 | 2099951.13854 | 37.7466143635754 | -122.409112247438 | (37.7466143635754, -122.409112247438) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
76964 | 196533 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1301 19th St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6013698.90567 | 2105212.75779 | 37.7612837495574 | -122.395721323302 | (37.7612837495574, -122.395721323302) | 10 | 3 | 8 | 28856 | 29 | |||
77173 | 256161 | Undocumented 4 | Prunus blireiana :: Flowering Plum 167 | 198X Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009711 | 2099918 | 37.7465228810693 | -122.409140238555 | (37.7465228810693, -122.409140238555) | 2 | 7 | 7 | 28859 | 2 | ||||
77247 | 213710 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 38 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6000922.38678 | 2094365.15978 | 37.7307798105294 | -122.439132320623 | (37.7307798105294, -122.439132320623) | 9 | 7 | 4 | 63 | 40 | |||
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 | |||
79119 | 4209 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004325.38397 | 2100415.60352 | 37.747586001896 | -122.427798564152 | (37.747586001896, -122.427798564152) | 2 | 4 | 5 | 63 | 22 | |||
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 | |||
80138 | 238574 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 290 States St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000331.0714 | 2106844.50131 | 37.7650114214522 | -122.442072013715 | (37.7650114214522, -122.442072013715) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
81984 | 238551 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 263 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004827.45458 | 2098981.61516 | 37.7436769880021 | -122.425960370593 | (37.7436769880021, -122.425960370593) | 2 | 7 | 5 | 63 | 22 | |||
83761 | 44069 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43593 | 6002668.59972375 | 2105639.21740039 | 37.761834937896 | -122.433900935359 | (37.761834937896, -122.433900935359) | 15 | 4 | 5 | 28862 | 3 | ||||
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 | |||
86086 | 238566 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 621 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002444.33707 | 2100031.09777 | 37.7464236506235 | -122.43427561915 | (37.7464236506235, -122.43427561915) | 2 | 7 | 5 | 63 | 22 | |||
86414 | 246644 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 5 | Side Yard : Yard | Tree | Private 2 | 4 | 6009046.23893 | 2099176.02556 | 37.7444483194522 | -122.411386509679 | (37.7444483194522, -122.411386509679) | 2 | 7 | 7 | 28859 | 2 | ||||
87153 | 238548 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 76 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010523.51123 | 2100011.17861 | 37.7468242140742 | -122.406337213897 | (37.7468242140742, -122.406337213897) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
90863 | 213712 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 611 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5998085.35885 | 2094959.97852 | 37.7322512012233 | -122.448983163356 | (37.7322512012233, -122.448983163356) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
99034 | 246645 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 6 | Side Yard : Yard | Tree | Private 2 | 5 | 6009048.82114 | 2099170.00785 | 37.7444319409756 | -122.411377155852 | (37.7444319409756, -122.411377155852) | 2 | 7 | 7 | 28859 | 2 | ||||
100481 | 196532 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1317 19th St | 1 | : | Tree | Private 2 | 5 | Width 6ft | 6013654.12142 | 2105210.03972 | 37.761273794973 | -122.395876023757 | (37.761273794973, -122.395876023757) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 |
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) );