trees
158 rows where qSpecies_id = 202 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143401 | 221955 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 271 Bemis St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6002975.66032 | 2096224.16146 | 37.7360008273625 | -122.432166542558 | (37.7360008273625, -122.432166542558) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
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 | |||
168365 | 114971 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 431 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 771835 | 5997422.4 | 2094904.1 | 37.7320598346121 | -122.45127112252 | (37.7320598346121, -122.45127112252) | 9 | 7 | 4 | 59 | 40 | |||
169515 | 175220 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 178 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000035.73488 | 2087742.43428 | 37.7125448266481 | -122.441722494022 | (37.7125448266481, -122.441722494022) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
179588 | 221951 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1636 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6002000.14888 | 2099232.59033 | 37.7442059152698 | -122.435754448124 | (37.7442059152698, -122.435754448124) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
186533 | 221954 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 10 Mateo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003651.78928 | 2096634.42206 | 37.7371656211922 | -122.429858148341 | (37.7371656211922, -122.429858148341) | 2 | 7 | 5 | 63 | 7 | |||
186582 | 175227 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 225 Naylor St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002635.08266 | 2086756.92621 | 37.709986599863 | -122.432667995542 | (37.709986599863, -122.432667995542) | 9 | 7 | 6 | 28861 | 5 | |||
187038 | 203596 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 431 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5997432.94788 | 2094904.04016 | 37.7320602742514 | -122.451234652068 | (37.7320602742514, -122.451234652068) | 9 | 7 | 4 | 59 | 40 | |||
188343 | 175219 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 100 Morse St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 1ft | 6000840.49126 | 2087951.89335 | 37.7131657752649 | -122.438956013912 | (37.7131657752649, -122.438956013912) | 9 | 7 | 6 | 28861 | 5 | |||
7590 | 109072 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769406 | 5992498.7 | 2104770.7 | 37.7588678465638 | -122.469011061686 | (37.7588678465638, -122.469011061686) | 1 | 8 | 4 | 56 | 12 |
8257 | 261815 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1601 Quintara St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5988457 | 2100975 | 37.7482115203177 | -122.482710816875 | (37.7482115203177, -122.482710816875) | 1 | 8 | 3 | 29491 | 35 | ||||
9220 | 261816 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1601 Quintara St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5988457 | 2100975 | 37.7482115203177 | -122.482710816875 | (37.7482115203177, -122.482710816875) | 1 | 8 | 3 | 29491 | 35 | ||||
9429 | 259571 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 298 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
12158 | 261817 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1601 Quintara St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5988457 | 2100975 | 37.7482115203177 | -122.482710816875 | (37.7482115203177, -122.482710816875) | 1 | 8 | 3 | 29491 | 35 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
47258 | 109897 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1734 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775111 | 5987546.7 | 2103468.6 | 37.7550052713528 | -122.486041582178 | (37.7550052713528, -122.486041582178) | 1 | 8 | 3 | 56 | 35 |
55725 | 203601 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 601 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5995029.86532 | 2089100.67816 | 37.7159877489258 | -122.459122505898 | (37.7159877489258, -122.459122505898) | 9 | 8 | 6 | 28861 | 24 | |||
64600 | 203602 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 601 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5995030.39824 | 2089062.56731 | 37.7158831361758 | -122.459117905878 | (37.7158831361758, -122.459117905878) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
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 | |||
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 | |||
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 | |||
96705 | 114970 | Undocumented 4 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200X MINERVA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5994532 | 2089023 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
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 | |||
116404 | 114968 | Undocumented 4 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200X MINERVA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5994532 | 2089023 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | 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 | |||
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 | |||
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 | |||
173788 | 69064 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1359 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | Permit Number 773642 | 5992377.26935607 | 2106205.46978928 | 37.7628003299421 | -122.469535465436 | (37.7628003299421, -122.469535465436) | 1 | 8 | 11 | 56 | 12 | |
173878 | 108526 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1677 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773677 | 5990566.26137 | 2103985.48594 | 37.7566000147891 | -122.475636927177 | (37.7566000147891, -122.475636927177) | 1 | 8 | 4 | 56 | 12 |
175831 | 114969 | Undocumented 4 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200X MINERVA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5994532 | 2089023 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
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 | |||
186577 | 109033 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2120 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772816 | 5987671.1 | 2103767.6 | 37.7558334934217 | -122.48563331933 | (37.7558334934217, -122.48563331933) | 1 | 8 | 3 | 56 | 35 |
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 | |||
15374 | 125563 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 627 Marina Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999907.90369 | 2121547.81116 | 37.8053587703434 | -122.44459250045 | (37.8053587703434, -122.44459250045) | 13 | 9 | 1 | 57 | 17 | |||
15744 | 125562 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 627 Marina Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5999907.00069 | 2121550.96509 | 37.8053673786573 | -122.444595852214 | (37.8053673786573, -122.444595852214) | 13 | 9 | 1 | 57 | 17 | |||
50429 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | 13 | 9 | 1 | 57 | 17 | ||
53582 | 125566 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2809 Buchanan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6003481.18787 | 2118079.55095 | 37.7960390779962 | -122.431978879228 | (37.7960390779962, -122.431978879228) | 13 | 9 | 1 | 57 | 17 | |||
54080 | 125567 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2809 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003482.8439 | 2118067.55033 | 37.7960062212666 | -122.431972291689 | (37.7960062212666, -122.431972291689) | 13 | 9 | 1 | 57 | 17 | |||
69401 | 125564 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 165 Marina Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6002712.8181 | 2121563.83713 | 37.805562426341 | -122.434886887435 | (37.805562426341, -122.434886887435) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
89333 | 101004 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2801X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||
115799 | 125561 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 627 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999906.36456 | 2121555.3188 | 37.8053792964712 | -122.444598366729 | (37.8053792964712, -122.444598366729) | 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 | |||
173627 | 101003 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2801X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||
176820 | 99289 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998887.79124 | 2121333.18312 | 37.8047111982366 | -122.448107254257 | (37.8047111982366, -122.448107254257) | 13 | 9 | 1 | 57 | 17 |
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) );