trees
1,977 rows where qSpecies_id = 41 sorted by PlantDate descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 184795 | 29598 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.64652 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | 9 | 8 | 4 | 64 | 40 | |||
| 194384 | 254279 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80X Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 12/24/2020 01:32:00 PM | 3 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||
| 47091 | 19431 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1200X Sloat Blvd | 4 | Median : Cutout | Tree | DPW 1 | 11/13/2007 12:00:00 AM | 6 | 20 | 5987714.9376 | 2095926.0092 | 37.7343051218756 | -122.484906458155 | (37.7343051218756, -122.484906458155) | 1 | 8 | 4 | 64 | 35 | ||
| 87265 | 86903 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 233 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2007 12:00:00 AM | 3x3 | Permit Number 49863 | 6001780 | 2086418 | 37.7090074518569 | -122.435599089406 | (37.7090074518569, -122.435599089406) | 9 | 7 | 6 | 28861 | 5 | ||
| 175426 | 13284 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2576 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6000068.81033 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | 13 | 9 | 1 | 57 | 17 | ||
| 14608 | 259056 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99 Cedro Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784357 | 5992279 | 2093128 | 37.7268872622364 | -122.468923614031 | (37.7268872622364, -122.468923614031) | 9 | 8 | 4 | 59 | 40 | |
| 58461 | 750 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301X 36th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 01:42:00 PM | 3 | 6 | 5985126.5669837 | 2099532.1780828 | 37.7440555948275 | -122.494120857895 | (37.7440555948275, -122.494120857895) | 1 | 8 | 3 | 29491 | 35 | ||
| 2599 | 122257 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Clement St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/16/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784386 | 5991472.52373 | 2113448.553 | 37.7826355430647 | -122.473192897736 | (37.7826355430647, -122.473192897736) | 11 | 6 | 2 | 54 | 26 | |
| 9662 | 113066 | - 12 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 7 | : | Tree | DPW 1 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 116862 | 2287 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989126.18342 | 2088688.61813 | 37.7145151729252 | -122.47949804711 | (37.7145151729252, -122.47949804711) | 1 | 8 | 4 | 64 | 14 | |
| 127159 | 115835 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X LAKE MERCED BLVD | 3 | Median : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 10x100 | 5987646 | 2090104 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | 1 | 8 | 4 | 64 | 14 | ||
| 139557 | 2290 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Brotherhood Way | 5 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |
| 147978 | 115833 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X LAKE MERCED BLVD | 1 | Median : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 10x100 | 5987646 | 2090104 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | 1 | 8 | 4 | 64 | 14 | ||
| 151272 | 2289 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Brotherhood Way | 4 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |
| 129825 | 113062 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 3 | : Yard | Tree | DPW 1 | 08/18/2016 09:59:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 161019 | 113063 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 4 | : Yard | Tree | DPW 1 | 08/18/2016 09:56:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 162401 | 113064 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 5 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:54:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 3666 | 113065 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:51:00 AM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 21932 | 85238 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 200 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49542 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | |||
| 48834 | 85239 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 200 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49542 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | |||
| 32630 | 85060 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070 California St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/03/2007 12:00:00 AM | Permit Number 49405 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
| 13332 | 8534 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2100 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001381.7916 | 2113512.283 | 37.7833793 | -122.438915716928 | (37.7833793, -122.438915716928) | 15 | 5 | 11 | 29490 | 41 | ||
| 151719 | 22878 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 951X Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 3 | 3X100 | 6009106.075934 | 2090003.4402519 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | 9 | 3 | 7 | 309 | 28 | ||
| 100264 | 8396 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1500 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004125.3824 | 2113965.9717 | 37.7847807304874 | -122.429456338379 | (37.7847807304874, -122.429456338379) | 13 | 9 | 11 | 29490 | 41 | ||
| 191814 | 106757 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/02/2014 12:00:00 AM | 36 | 6013321.20233 | 2089752.82506 | 37.7188129925151 | -122.395944254446 | (37.7188129925151, -122.395944254446) | 10 | 3 | 8 | 58 | 1 | |||
| 22973 | 8585 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000465.007 | 2113386.3901 | 37.7829814273003 | -122.442078382069 | (37.7829814273003, -122.442078382069) | 15 | 5 | 1 | 29490 | 41 | ||
| 30557 | 8580 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2200 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 06/01/1994 12:00:00 AM | 6 | 6 | 6000778.3855 | 2113430.8926 | 37.7831214735368 | -122.44099741813 | (37.7831214735368, -122.44099741813) | 15 | 5 | 11 | 29490 | 41 | ||
| 49363 | 87064 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 101 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2007 12:00:00 AM | Permit Number 50006 | 6001805 | 2096722 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | 2 | 7 | 5 | 63 | 7 | |||
| 101121 | 98820 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 302X Pacheco St | 28 | Median : Cutout | Tree | Private 2 | 05/09/2010 12:00:00 AM | Permit Number 768820 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | |||
| 23219 | 110906 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2891 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775210 | 5999784.05969 | 2117390.40958 | 37.7939365889551 | -122.444722064898 | (37.7939365889551, -122.444722064898) | 13 | 9 | 1 | 57 | 27 | |
| 37660 | 90814 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 3101X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985939.53004 | 2110416.22532 | 37.7739877194341 | -122.492111077157 | (37.7739877194341, -122.492111077157) | 11 | 6 | 2 | 55 | 26 | ||
| 140758 | 29578 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 400X Junipero Serra Blvd | 8 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991374.03241 | 2094196.50916 | 37.729768794481 | -122.472129887178 | (37.729768794481, -122.472129887178) | 9 | 8 | 4 | 64 | 40 | ||
| 51599 | 11703 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 20 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991288.65534 | 2092789.2072 | 37.7258997536651 | -122.472322493193 | (37.7258997536651, -122.472322493193) | 9 | 8 | 4 | 64 | 40 | ||
| 120009 | 11702 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991290.07475 | 2092800.94551 | 37.7259320662922 | -122.472318441755 | (37.7259320662922, -122.472318441755) | 9 | 8 | 4 | 64 | 40 | ||
| 123003 | 29609 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991172.14351 | 2091025.81173 | 37.7210511631493 | -122.472596754032 | (37.7210511631493, -122.472596754032) | 9 | 8 | 4 | 64 | 40 | ||
| 128711 | 29611 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 21 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991160.04623 | 2090951.20244 | 37.7208456042137 | -122.472633133415 | (37.7208456042137, -122.472633133415) | 9 | 8 | 4 | 64 | 40 | ||
| 190154 | 29593 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991180.05944 | 2091153.12589 | 37.7214011945921 | -122.472578668672 | (37.7214011945921, -122.472578668672) | 9 | 8 | 4 | 64 | 40 | ||
| 16237 | 261035 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1601 Sunset Blvd | 78 | Median : Yard | Tree | Private 2 | 03/25/2020 12:00:00 AM | 3 | 3x3 | 5984861 | 2104296 | 37.7571201993916 | -122.495390378798 | (37.7571201993916, -122.495390378798) | 1 | 8 | 3 | 56 | 35 | ||
| 82162 | 109453 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 951 GILMAN AVE | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934 | 2089205 | 37.7174537876507 | -122.386874585955 | (37.7174537876507, -122.386874585955) | 10 | 3 | 8 | 58 | 1 | ||
| 125129 | 105889 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 2150X 09TH AVE | 11 | Median : Cutout | Tree | Private 2 | 03/21/2014 12:00:00 AM | 40 | 5993666 | 2101247 | 37.7492600480712 | -122.464718147401 | (37.7492600480712, -122.464718147401) | 1 | 8 | 4 | 29491 | 40 | |||
| 145768 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070@ 32nd Ave California St | 4 | Front Yard : | Tree | Private 2 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
| 24133 | 11748 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 31 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991276.77165 | 2092652.88165 | 37.7255247498407 | -122.472353640304 | (37.7255247498407, -122.472353640304) | 9 | 8 | 4 | 64 | 40 | ||
| 48223 | 11710 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991285.51963 | 2092735.44075 | 37.7257519428913 | -122.472329415287 | (37.7257519428913, -122.472329415287) | 9 | 8 | 4 | 64 | 40 | ||
| 61732 | 29625 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 34 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991156.8644 | 2090780.05839 | 37.7203755006984 | -122.472631660317 | (37.7203755006984, -122.472631660317) | 9 | 8 | 4 | 64 | 40 | ||
| 113291 | 29624 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 33 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991155.39463 | 2090794.87778 | 37.7204161060108 | -122.472637820699 | (37.7204161060108, -122.472637820699) | 9 | 8 | 4 | 64 | 40 | ||
| 179327 | 29618 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 27 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991164.47662 | 2090887.55637 | 37.720671104264 | -122.472613181078 | (37.720671104264, -122.472613181078) | 9 | 8 | 4 | 64 | 40 | ||
| 13755 | 11746 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 700X Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 03/03/2006 12:00:00 AM | 3 | 6X6 | 5991277.67104 | 2092671.80389 | 37.7255767576586 | -122.472351910013 | (37.7255767576586, -122.472351910013) | 9 | 8 | 4 | 64 | 40 | ||
| 95002 | 109656 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 8 | Median : Cutout | Tree | DPW 1 | 02/27/2015 10:16:00 AM | 3 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||
| 37603 | 93205 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 3 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
| 98332 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
| 158156 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 4 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
| 180298 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
| 144924 | 20881 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1892X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:23:00 AM | 3 | 60 | 5984852.8466778 | 2102317.5089788 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | 1 | 8 | 3 | 56 | 35 | ||
| 174059 | 20799 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1792X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:19:00 AM | 3 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | |||
| 191023 | 20803 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1792X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2017 10:15:00 AM | 3 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | ||
| 179968 | 21456 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2701X Sunset Blvd | 9 | Median : Cutout | Tree | DPW 1 | 02/11/2016 05:16:00 AM | 3 | 40 | 5985119.0068215 | 2096832.7848434 | 37.7366433445438 | -122.493948101207 | (37.7366433445438, -122.493948101207) | 1 | 8 | 3 | 29491 | 35 | ||
| 63133 | 21516 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2801X Sunset Blvd | 6 | Median : Cutout | Tree | DPW 1 | 02/11/2016 05:13:00 AM | 3 | 5985158.4919923 | 2096224.0649069 | 37.7349742721437 | -122.493766742569 | (37.7349742721437, -122.493766742569) | 1 | 8 | 3 | 29491 | 35 | |||
| 24231 | 93107 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 15 Mesa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 3x3 | Permit Number 53163 | 5993680.1 | 2100698.2 | 37.7477539957997 | -122.464629544553 | (37.7477539957997, -122.464629544553) | 1 | 8 | 4 | 29491 | 40 | ||
| 94784 | 253250 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99X Lopez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
| 144280 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 270 Castenada Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
| 49827 | 53726 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 8 | Permit Number 9405 | 6012451.87174 | 2095251.14558 | 37.7338618519323 | -122.399334980939 | (37.7338618519323, -122.399334980939) | 10 | 3 | 8 | 58 | 1 | ||
| 37713 | 87116 | Permitted Site 7 | Cupressus macrocarpa :: Monterey Cypress 41 | 470 West Portal Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
| 80 | 260998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | 10x10 | ||||||||||||||
| 106 | 251438 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Santiago St | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 172 | 176155 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 25 | 10x10 | 5988860 | 2088745 | 37.7146545182747 | -122.480422197946 | (37.7146545182747, -122.480422197946) | 1 | 8 | 4 | 64 | 14 | |||
| 190 | 21328 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
| 251 | 187669 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 554 Valley St | 1 | Median : Yard | Tree | Private 2 | 6002324 | 2099197 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | 2 | 7 | 5 | 63 | 22 | |||||
| 394 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x Avalon Ave | 1 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
| 464 | 173918 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2160X 09th Ave | 6 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
| 509 | 19905 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
| 537 | 261951 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 595 | 261954 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 612 | 223703 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1100 San Jose Ave | 77 | Front Yard : Yard | Tree | Private 2 | 18 | 6004573.37155 | 2096423.41392 | 37.7366383864359 | -122.426656795699 | (37.7366383864359, -122.426656795699) | 2 | 7 | 5 | 63 | 7 | ||||
| 657 | 20296 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 20X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | |||||||||||||
| 703 | 262210 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2011 Bay Shore Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6012422 | 2088364 | 37.7149494891568 | -122.398955034798 | (37.7149494891568, -122.398955034798) | 10 | 3 | 8 | 309 | 1 | ||||
| 720 | 19950 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
| 795 | 19570 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
| 838 | 264883 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 1624 48th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5981321 | 2103997 | 37.7560913197894 | -122.50761065519 | (37.7560913197894, -122.50761065519) | 1 | 8 | 3 | 56 | 35 | ||||
| 945 | 217846 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Woodacre Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 54 | 5991427.31798 | 2095733.50913 | 37.7339920935414 | -122.472057659936 | (37.7339920935414, -122.472057659936) | 1 | 8 | 4 | 64 | 40 | ||||
| 1051 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
| 1127 | 263624 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 980 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008397 | 2119007 | 37.7988630807128 | -122.415034830901 | (37.7988630807128, -122.415034830901) | 5 | 1 | 10 | 308 | 32 | ||||
| 1336 | 185523 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2201 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 60 | Width 0ft | 5984870.0228 | 2100148.4874 | 37.7457327977456 | -122.495053353322 | (37.7457327977456, -122.495053353322) | 1 | 8 | 3 | 29491 | 35 | |||
| 1728 | 262141 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 420X Portola Dr | 2 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
| 1873 | 20545 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1303X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.495741360313 | (37.7626943540195, -122.495741360313) | 1 | 8 | 3 | 56 | 35 | |||
| 2175 | 121189 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000x Duncan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999834 | 2099740 | 37.7454758595085 | -122.443280934089 | (37.7454758595085, -122.443280934089) | 2 | 7 | 5 | 63 | 22 | |||
| 2239 | 253844 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 150 Junipero Serra Blvd | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5991384 | 2095197 | 37.7325164679088 | -122.472168327848 | (37.7325164679088, -122.472168327848) | 1 | 8 | 4 | 64 | 40 | ||||
| 2282 | 19424 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | 1 | 8 | 3 | 64 | 35 | |||
| 2302 | 19935 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY38 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
| 2418 | 20917 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1901X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984934.4009631 | 2102260.4913733 | 37.7515355521167 | -122.494986448304 | (37.7515355521167, -122.494986448304) | 1 | 8 | 3 | 29491 | 35 | |||
| 2644 | 113698 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80 LINARES AVE | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 5994154.8 | 2102090.7 | 37.7516048020548 | -122.463089089164 | (37.7516048020548, -122.463089089164) | 1 | 8 | 4 | 29491 | 40 | |||||
| 2657 | 260570 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
| 2744 | 261957 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 11 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 2750 | 206896 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Pizarro Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5995094.72754 | 2093951.90742 | 37.7293117922974 | -122.459249411033 | (37.7293117922974, -122.459249411033) | 9 | 7 | 4 | 28861 | 40 | |||
| 2858 | 261960 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 14 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 3011 | 19948 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY39 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 25ST | |||||||||||||
| 3028 | 19906 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
| 3038 | 248184 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 216 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 28 | 6007432.52043 | 2098714.89498 | 37.7430915158666 | -122.416933765486 | (37.7430915158666, -122.416933765486) | 2 | 7 | 7 | 28859 | 2 | ||||
| 3052 | 19908 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 120ST | |||||||||||||
| 3078 | 19568 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY1 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 100ST | |||||||||||||
| 3098 | 20419 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 453X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 |
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) );