trees
50 rows where PlotSize = "Width 3ft" and qSpecies_id = 202 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
110052 | 189232 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012390.79704 | 2103733.87239 | 37.7571502019395 | -122.400141680908 | (37.7571502019395, -122.400141680908) | 10 | 3 | 8 | 28856 | 29 | |||
133070 | 189234 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012405.15003 | 2103734.72302 | 37.7571533378622 | -122.400092102164 | (37.7571533378622, -122.400092102164) | 10 | 3 | 8 | 28856 | 29 | |||
160605 | 189231 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 6012362.34011 | 2103730.31063 | 37.7571388353939 | -122.4002398464 | (37.7571388353939, -122.4002398464) | 10 | 3 | 8 | 28856 | 29 | |||
173458 | 189230 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6012335.96177 | 2103730.27512 | 37.7571372669841 | -122.400331070924 | (37.7571372669841, -122.400331070924) | 10 | 3 | 8 | 28856 | 29 | |||
185073 | 189233 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1919 22nd St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6012396.53776 | 2103734.18422 | 37.7571513782439 | -122.400121849061 | (37.7571513782439, -122.400121849061) | 10 | 3 | 8 | 28856 | 29 | |||
1685 | 221956 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 126 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009115.60345 | 2096745.48812 | 37.7377784848985 | -122.410975023096 | (37.7377784848985, -122.410975023096) | 10 | 7 | 7 | 28859 | 2 | |||
5535 | 221960 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 75 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006819.46923 | 2099263.44478 | 37.7445632069438 | -122.419092436978 | (37.7445632069438, -122.419092436978) | 2 | 7 | 7 | 28859 | 2 | |||
23381 | 221957 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 132 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009113.07033 | 2096713.66347 | 37.7376909592647 | -122.410981534183 | (37.7376909592647, -122.410981534183) | 10 | 7 | 7 | 28859 | 2 | |||
28899 | 221958 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 779 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008100.58194 | 2095693.3071 | 37.7348324551576 | -122.414410025905 | (37.7348324551576, -122.414410025905) | 2 | 7 | 7 | 28859 | 2 | |||
55128 | 221948 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 633 Capp St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6007312.78593 | 2103619.12061 | 37.7565506733878 | -122.417695309584 | (37.7565506733878, -122.417695309584) | 2 | 4 | 7 | 28859 | 19 | |||
81646 | 221949 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 130 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005733.16344 | 2096370.93476 | 37.7365597919858 | -122.422643161851 | (37.7365597919858, -122.422643161851) | 2 | 7 | 7 | 28859 | 2 | |||
110813 | 221961 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007321.68387 | 2099648.65051 | 37.745649164396 | -122.417383168412 | (37.745649164396, -122.417383168412) | 2 | 7 | 7 | 28859 | 2 | |||
111830 | 221962 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 28 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005742.72785 | 2097519.53479 | 37.7397141298992 | -122.422691692893 | (37.7397141298992, -122.422691692893) | 2 | 7 | 7 | 28859 | 2 | |||
155229 | 221943 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 237 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006873.22599 | 2096639.71242 | 37.7373620502264 | -122.418720525044 | (37.7373620502264, -122.418720525044) | 2 | 7 | 7 | 28859 | 2 | |||
179457 | 221959 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 40 Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006917.95307 | 2099525.21762 | 37.7452875218149 | -122.418770459905 | (37.7452875218149, -122.418770459905) | 2 | 7 | 7 | 28859 | 2 | |||
38481 | 203600 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 Minerva St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994977.66041 | 2089033.88982 | 37.7158013626108 | -122.459298115614 | (37.7158013626108, -122.459298115614) | 9 | 8 | 6 | 28861 | 24 | |||
41452 | 203615 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 240 Colon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5996037.38323 | 2094398.48179 | 37.7305921283128 | -122.456022857589 | (37.7305921283128, -122.456022857589) | 9 | 7 | 4 | 28861 | 40 | |||
79067 | 175225 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 762 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002385.00148 | 2087111.82933 | 37.7109469004454 | -122.433557669663 | (37.7109469004454, -122.433557669663) | 9 | 7 | 6 | 28861 | 5 | |||
95445 | 203599 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 Minerva St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994990.66494 | 2089034.05641 | 37.7158025676981 | -122.459253178313 | (37.7158025676981, -122.459253178313) | 9 | 8 | 6 | 28861 | 24 | |||
116243 | 203604 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 349 Howth St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5997115.15384 | 2090174.96464 | 37.7190571494366 | -122.451992266143 | (37.7190571494366, -122.451992266143) | 9 | 8 | 6 | 28861 | 24 | |||
131041 | 203603 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 533 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995027.64484 | 2088883.389 | 37.7153909965718 | -122.459114456087 | (37.7153909965718, -122.459114456087) | 9 | 8 | 6 | 28861 | 24 | |||
144618 | 175221 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 127 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001956.44701 | 2093481.30015 | 37.728411719314 | -122.435494211294 | (37.728411719314, -122.435494211294) | 9 | 7 | 6 | 28861 | 25 | |||
177274 | 203598 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995008.49221 | 2089033.02481 | 37.715800760085 | -122.459191484793 | (37.715800760085, -122.459191484793) | 9 | 8 | 6 | 28861 | 24 | |||
180191 | 175224 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 762 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002402.88459 | 2087125.99028 | 37.710986797965 | -122.433496872809 | (37.710986797965, -122.433496872809) | 9 | 7 | 6 | 28861 | 5 | |||
190155 | 203597 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 50 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995113.88228 | 2091909.79504 | 37.7237057451058 | -122.45903538769 | (37.7237057451058, -122.45903538769) | 9 | 8 | 4 | 28861 | 24 | |||
28532 | 221966 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 190 Storrie St | 7 | Front Yard : Yard | Tree | Private 2 | 2 | Width 3ft | 6000752.80061 | 2105288.06191 | 37.7607618468996 | -122.440501720974 | (37.7607618468996, -122.440501720974) | 15 | 4 | 5 | 28862 | 3 | |||
73808 | 221963 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 4086 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002569.41757 | 2102410.84038 | 37.7529649603686 | -122.434013186153 | (37.7529649603686, -122.434013186153) | 2 | 4 | 5 | 28862 | 22 | |||
99800 | 221964 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 3783 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003249.85667 | 2102987.38047 | 37.7545865954194 | -122.431701259406 | (37.7545865954194, -122.431701259406) | 2 | 4 | 5 | 28862 | 22 | |||
133708 | 221965 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 4001 20th St | 5 | : Yard | Tree | Private 2 | 4 | Width 3ft | 6003646.65326 | 2104187.92713 | 37.7579054957544 | -122.430414684807 | (37.7579054957544, -122.430414684807) | 2 | 4 | 5 | 28862 | 3 | |||
18595 | 203611 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 146 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992953.88881 | 2101207.94105 | 37.7491117215315 | -122.467177780245 | (37.7491117215315, -122.467177780245) | 1 | 8 | 4 | 29491 | 12 | |||
20819 | 203614 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2555 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991713.86449 | 2098047.40615 | 37.7403620464585 | -122.47123551863 | (37.7403620464585, -122.47123551863) | 1 | 8 | 4 | 29491 | 40 | |||
39893 | 203608 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2007 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991583.6607 | 2101714.46197 | 37.7504233054064 | -122.471952911395 | (37.7504233054064, -122.471952911395) | 1 | 8 | 4 | 29491 | 12 | |||
71411 | 203618 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 185 Castenada Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994486.24709 | 2100807.40007 | 37.7481002729224 | -122.461849867291 | (37.7481002729224, -122.461849867291) | 1 | 8 | 4 | 29491 | 40 | |||
76777 | 203616 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 185 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994461.21943 | 2100782.80797 | 37.7480313083953 | -122.461934628392 | (37.7480313083953, -122.461934628392) | 1 | 8 | 4 | 29491 | 40 | |||
99215 | 203610 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992962.70532 | 2101209.82571 | 37.7491174052506 | -122.467147429924 | (37.7491174052506, -122.467147429924) | 1 | 8 | 4 | 29491 | 12 | |||
159601 | 203607 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2007 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991582.5756 | 2101730.87003 | 37.7504682948863 | -122.471957859468 | (37.7504682948863, -122.471957859468) | 1 | 8 | 4 | 29491 | 12 | |||
171239 | 203609 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 120 Quintara St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993075.95674 | 2101213.42516 | 37.7491338250612 | -122.466756070139 | (37.7491338250612, -122.466756070139) | 1 | 8 | 4 | 29491 | 12 | |||
184066 | 203617 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 185 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994473.17466 | 2100793.87749 | 37.7480623907666 | -122.461894090539 | (37.7480623907666, -122.461894090539) | 1 | 8 | 4 | 29491 | 40 | |||
8692 | 247232 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 760 Duboce Ave | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6002013.60886 | 2108293.7767 | 37.7690865158689 | -122.436356276247 | (37.7690865158689, -122.436356276247) | 15 | 5 | 5 | 29492 | 9 | |||
113305 | 118234 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 590 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5984132.17313 | 2111832.67046 | 37.7777710528241 | -122.498467578545 | (37.7777710528241, -122.498467578545) | 11 | 6 | 2 | 55 | 26 | |||
20692 | 203613 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1762 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991879.53156 | 2103437.46302 | 37.755171333717 | -122.471055286375 | (37.755171333717, -122.471055286375) | 1 | 8 | 4 | 56 | 12 | |||
70533 | 203606 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992477.77859 | 2104773.12978 | 37.7588733092773 | -122.469083593842 | (37.7588733092773, -122.469083593842) | 1 | 8 | 4 | 56 | 12 | |||
77859 | 203612 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1675 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991397.55944 | 2103884.03923 | 37.7563696263767 | -122.472754630933 | (37.7563696263767, -122.472754630933) | 1 | 8 | 4 | 56 | 12 | |||
147338 | 203591 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1677 18th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990564.22398 | 2103984.5948 | 37.7565974498416 | -122.475643908062 | (37.7565974498416, -122.475643908062) | 1 | 8 | 4 | 56 | 12 | |||
73720 | 125559 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 20 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001981.60949 | 2119919.32974 | 37.8010055012508 | -122.437299505878 | (37.8010055012508, -122.437299505878) | 13 | 9 | 1 | 57 | 17 | |||
148377 | 125560 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 20 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001979.15463 | 2119935.63772 | 37.8010501391173 | -122.437309169106 | (37.8010501391173, -122.437309169106) | 13 | 9 | 1 | 57 | 17 | |||
15125 | 221968 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 155 Farnum St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6002473.47377 | 2097229.09787 | 37.7387316655458 | -122.433974612434 | (37.7387316655458, -122.433974612434) | 2 | 7 | 5 | 63 | 7 | |||
41523 | 221967 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 448 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003863.12438 | 2096025.37276 | 37.7355052757557 | -122.429084054179 | (37.7355052757557, -122.429084054179) | 2 | 7 | 5 | 63 | 7 | |||
129751 | 169719 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 163 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 779875 | 6004059.21605 | 2097368.19833 | 37.7392034678777 | -122.428501775552 | (37.7392034678777, -122.428501775552) | 2 | 7 | 5 | 63 | 7 | |
33050 | 203605 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 556 Victoria St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993274.01352 | 2090867.72296 | 37.7207385300422 | -122.46531978899 | (37.7207385300422, -122.46531978899) | 9 | 8 | 6 | 64 | 24 |
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) );