trees
158 rows where qSpecies_id = 202 sorted by Fire Prevention 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
53421 | 115385 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 375 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776680 | 6007256.8 | 2096298.8 | 37.7364475687434 | -122.417370175703 | (37.7364475687434, -122.417370175703) | 2 | 7 | 7 | 28859 | 2 | ||
53602 | 117377 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 3783 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 775394 | 6003225.8 | 2102971.4 | 37.7545413531892 | -122.43178331278 | (37.7545413531892, -122.43178331278) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
62425 | 221952 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1636 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6002001.1942 | 2099218.33488 | 37.7441668325278 | -122.435749813916 | (37.7441668325278, -122.435749813916) | 2 | 7 | 5 | 63 | 22 | |||
70180 | 221941 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 6 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007387.61833 | 2099831.21968 | 37.7461541678748 | -122.417168110835 | (37.7461541678748, -122.417168110835) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | |||
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 | |||
120297 | 36540 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 3780 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 768357 | 6008402.05844785 | 2097287.64414787 | 37.7392270883895 | -122.413480433949 | (37.7392270883895, -122.413480433949) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |
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 | |||
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 | |||
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 | |||
168492 | 221953 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 828 Alvarado St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6000888.70768 | 2102618.36956 | 37.753439259225 | -122.439840265136 | (37.753439259225, -122.439840265136) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | |||
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 |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
70475 | 115759 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1718 Cayuga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998106.99194 | 2088701.93877 | 37.7150693216746 | -122.448457855865 | (37.7150693216746, -122.448457855865) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
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 | |||
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 | |||
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 | |||
112583 | 175217 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1601 San Jose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6001607.87231 | 2094169.86531 | 37.7302825582951 | -122.436748518241 | (37.7302825582951, -122.436748518241) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );