trees
158 rows where qSpecies_id = 202 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162253 | 108566 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 627 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772549 | 6010648.77476 | 2091709.27229 | 37.7240359509768 | -122.405319522179 | (37.7240359509768, -122.405319522179) | 10 | 3 | 7 | 309 | 28 |
190673 | 175222 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 300 Gaven St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008975.92118 | 2094875.47718 | 37.7326360049484 | -122.411325907078 | (37.7326360049484, -122.411325907078) | 9 | 3 | 7 | 309 | 28 | |||
7320 | 189222 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 101 Pennsylvania Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6014335.23001 | 2106254.12043 | 37.7641784810862 | -122.393593414898 | (37.7641784810862, -122.393593414898) | 14 | 3 | 8 | 310 | 29 | ||||
41702 | 189228 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1300x De Haro St | 16 | Median : Yard | Tree | DPW 1 | 1 | 6012274.47933 | 2102155.74686 | 37.752810527903 | -122.40043310802 | (37.752810527903, -122.40043310802) | 10 | 3 | 8 | 28856 | 29 | ||||
41840 | 108726 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 460 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773097 | 6011176.24234 | 2106141.01313 | 37.7636918767911 | -122.404511540684 | (37.7636918767911, -122.404511540684) | 8 | 3 | 8 | 28856 | 29 |
55921 | 189223 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 101 Pennsylvania Ave | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6014330.31355 | 2106344.51761 | 37.7644264187655 | -122.393616746937 | (37.7644264187655, -122.393616746937) | 14 | 3 | 8 | 310 | 29 | ||||
81425 | 189225 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 101 Pennsylvania Ave | 28 | Front Yard : Yard | Tree | Private 2 | 1 | 6014307.08555 | 2106575.78079 | 37.7650601260485 | -122.393713274773 | (37.7650601260485, -122.393713274773) | 14 | 3 | 8 | 310 | 29 | ||||
84172 | 189224 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 101 Pennsylvania Ave | 15 | Front Yard : Yard | Tree | Private 2 | 1 | 6014323.89166 | 2106455.06011 | 37.7647295874116 | -122.393646696144 | (37.7647295874116, -122.393646696144) | 14 | 3 | 8 | 310 | 29 | ||||
87270 | 189221 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1310 Indiana St | 14 | : Yard | Tree | Private 2 | 1 | 6015010.96324 | 2102373.36426 | 37.7535602828051 | -122.390984975379 | (37.7535602828051, -122.390984975379) | 10 | 3 | 8 | 28856 | 29 | ||||
87275 | 189229 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1459 Rhode Island St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6012049.05152 | 2101579.41636 | 37.7512154759161 | -122.401172188849 | (37.7512154759161, -122.401172188849) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||
166041 | 189227 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1766 18th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 1ft | 6012472.41099 | 2105663.34278 | 37.7624526523798 | -122.399994920552 | (37.7624526523798, -122.399994920552) | 14 | 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 | |||
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 | |||
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 | |||
144484 | 120754 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 25 20th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5989551.60902 | 2114996.46131 | 37.7867742543083 | -122.479951676413 | (37.7867742543083, -122.479951676413) | 11 | 6 | 1 | 55 | 33 | ||||
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 | ||||
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 | ||||
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 |
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 |
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 | ||||
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 | |||
27858 | 203619 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 624 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6000138.38202 | 2095835.33472 | 37.7347719253748 | -122.441948223841 | (37.7347719253748, -122.441948223841) | 9 | 7 | 5 | 63 | 40 | |||
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 | |||
42639 | 255491 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 139 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781962 | 5999277.13576 | 2095481.56921 | 37.7337514533765 | -122.444900415841 | (37.7337514533765, -122.444900415841) | 9 | 7 | 4 | 59 | 40 |
47616 | 203594 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 362 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5997974.50347 | 2098199.84414 | 37.7411407550534 | -122.449599788915 | (37.7411407550534, -122.449599788915) | 9 | 7 | 4 | 59 | 40 | |||
51205 | 203592 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1485x Northwood Dr | 1 | Median : Yard | Tree | DPW 1 | 2 | 5995892.33391 | 2093907.44512 | 37.7292355333897 | -122.456488817009 | (37.7292355333897, -122.456488817009) | 9 | 7 | 4 | 28861 | 40 | ||||
59906 | 121643 | Undocumented 4 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 362 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x4 | 5997955 | 2098188 | 37.741107118117 | -122.449666371295 | (37.741107118117, -122.449666371295) | 9 | 7 | 4 | 59 | 40 | ||||
71295 | 204746 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 624 Congo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6000138.08456 | 2095837.9726 | 37.7347791514248 | -122.441949441533 | (37.7347791514248, -122.441949441533) | 9 | 7 | 5 | 63 | 40 | |||
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 | |||
81720 | 204747 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 624 Congo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6000136.90983 | 2095840.80392 | 37.7347868586248 | -122.441953706121 | (37.7347868586248, -122.441953706121) | 9 | 7 | 5 | 63 | 40 | |||
128898 | 203595 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 423 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5997934.90621 | 2094082.1225 | 37.729832211087 | -122.44944008102 | (37.729832211087, -122.44944008102) | 9 | 7 | 4 | 28861 | 40 | |||
141556 | 203593 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 362 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5997967.66384 | 2098207.91651 | 37.7411625285389 | -122.449624019335 | (37.7411625285389, -122.449624019335) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | |||
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 | |||
148068 | 115208 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1014 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774282 | 6001957.4 | 2112096.8 | 37.7795254745958 | -122.436822979652 | (37.7795254745958, -122.436822979652) | 15 | 5 | 11 | 29490 | 41 | |||
156394 | 115207 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1014 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774282 | 6001957.4 | 2112096.8 | 37.7795254745958 | -122.436822979652 | (37.7795254745958, -122.436822979652) | 15 | 5 | 11 | 29490 | 41 | |||
11882 | 81047 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 961 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001634.70169 | 2086773.55642 | 37.7099754779527 | -122.436126687404 | (37.7099754779527, -122.436126687404) | 9 | 7 | 6 | 28861 | 5 | |||
37514 | 175226 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1150 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6001420.49828 | 2087082.59126 | 37.7108118474628 | -122.43688912274 | (37.7108118474628, -122.43688912274) | 9 | 7 | 6 | 28861 | 5 | |||
44573 | 175223 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 39 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002350.25908 | 2087113.68805 | 37.7109500327891 | -122.433677880228 | (37.7109500327891, -122.433677880228) | 9 | 7 | 6 | 28861 | 5 | |||
78033 | 175218 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 93 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001014.57653 | 2087970.42853 | 37.7132265721263 | -122.438355644521 | (37.7132265721263, -122.438355644521) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 |
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) );