trees
4,014 rows where qSpecies_id = 40
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6141 | 69800 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 367 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5999779.7835 | 2091764.72169 | 37.7235745268131 | -122.442895800812 | (37.7235745268131, -122.442895800812) | 9 | 7 | 6 | 28861 | 25 | ||
6211 | 44491 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 55 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 9 | Permit Number 45395 | 6005461.21441 | 2093276.54578 | 37.728047939957 | -122.423363497235 | (37.728047939957, -122.423363497235) | 9 | 7 | 7 | 309 | 5 | |
6325 | 213549 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 167 Valdez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996164.20068 | 2094572.39502 | 37.7310769303549 | -122.455596998927 | (37.7310769303549, -122.455596998927) | 9 | 7 | 4 | 28861 | 40 | |||
6337 | 55153 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3933 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2009 12:00:00 AM | 3x3 | Permit Number 52132 | 6003602.67369464 | 2101839.43403285 | 37.7514545976895 | -122.430399225072 | (37.7514545976895, -122.430399225072) | 2 | 4 | 5 | 28862 | 22 | ||
6401 | 70501 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 75 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004654.40413 | 2093072.16776 | 37.7274411943513 | -122.42613812337 | (37.7274411943513, -122.42613812337) | 9 | 7 | 6 | 28861 | 5 | |||
6437 | 238199 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3980 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003307.88707 | 2101869.812 | 37.7515213056834 | -122.431420800429 | (37.7515213056834, -122.431420800429) | 2 | 4 | 5 | 28862 | 22 | |||
6493 | 214723 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 591 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995322.28894 | 2093286.27731 | 37.7274972131074 | -122.458414554203 | (37.7274972131074, -122.458414554203) | 9 | 7 | 4 | 28861 | 40 | |||
6547 | 238340 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 227 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787829 | 6002088.29914 | 2104514.86028 | 37.7587147776761 | -122.435827511746 | (37.7587147776761, -122.435827511746) | 2 | 4 | 5 | 28862 | 3 | |
6552 | 119000 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 623 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5982547.10807 | 2111503.78055 | 37.776774937935 | -122.503926407866 | (37.776774937935, -122.503926407866) | 11 | 6 | 2 | 55 | 26 | |||
6581 | 214481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1623 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5990862.01954 | 2104342.15602 | 37.7575964779098 | -122.474640129733 | (37.7575964779098, -122.474640129733) | 1 | 8 | 4 | 56 | 12 | |||
6608 | 47030 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.7722281991235 | -122.424230399247 | (37.7722281991235, -122.424230399247) | 7 | 9 | 11 | 28852 | 10 | ||
6690 | 79764 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 26 Wanda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000559.45557 | 2091550.49268 | 37.7230307229714 | -122.440185263946 | (37.7230307229714, -122.440185263946) | 9 | 7 | 6 | 28861 | 25 | |||
6764 | 95833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 520 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767565 | 6010212.70231 | 2112022.42286 | 37.7797869733249 | -122.408258986859 | (37.7797869733249, -122.408258986859) | 14 | 2 | 9 | 28853 | 34 |
6813 | 256911 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
6873 | 238355 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 677 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003708.60882 | 2104373.36592 | 37.7584181758823 | -122.43021364585 | (37.7584181758823, -122.43021364585) | 2 | 4 | 5 | 28862 | 3 | |||
6937 | 68735 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3968 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 3 | Permit Number 32653 | 5995812.60766 | 2114880.06908 | 37.7868164408107 | -122.458281808143 | (37.7868164408107, -122.458281808143) | 11 | 6 | 1 | 54 | 31 | ||
6973 | 214477 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1587 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990545.71643 | 2104592.61626 | 37.758265842404 | -122.475752312336 | (37.758265842404, -122.475752312336) | 1 | 8 | 4 | 56 | 12 | |||
7018 | 213561 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 130 Montecito Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996368.30466 | 2094246.96905 | 37.7301950992263 | -122.454867876251 | (37.7301950992263, -122.454867876251) | 9 | 7 | 4 | 28861 | 40 | |||
7072 | 179119 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 621 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008944.10696 | 2093176.6835 | 37.7279696962286 | -122.411315930896 | (37.7279696962286, -122.411315930896) | 9 | 3 | 7 | 309 | 28 | |||
7115 | 4034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2150 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/1995 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
7312 | 254991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1508 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2020 12:00:00 PM | 3 | 4x4 | 6002019 | 2093366 | 37.7280986838153 | -122.435269719024 | (37.7280986838153, -122.435269719024) | 9 | 7 | 6 | 28861 | 25 | ||
7345 | 124346 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 804 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993044.54414 | 2111416.29684 | 37.7771464148252 | -122.467606586696 | (37.7771464148252, -122.467606586696) | 11 | 6 | 2 | 54 | 11 | |||
7371 | 213371 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1695 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992456.73021 | 2103998.57674 | 37.7567453730203 | -122.46910001725 | (37.7567453730203, -122.46910001725) | 1 | 8 | 4 | 56 | 12 | |||
7449 | 238083 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 690X Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008630.1472 | 2098081.04423 | 37.7414183955492 | -122.412747878228 | (37.7414183955492, -122.412747878228) | 10 | 7 | 7 | 28859 | 2 | |||
7488 | 21658 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1745 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004251.7833336 | 2114607.9002324 | 37.7865504610901 | -122.42906481766 | (37.7865504610901, -122.42906481766) | 13 | 9 | 11 | 29490 | 13 | |||
7565 | 121637 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 298x Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000311 | 2091736 | 37.7235259352509 | -122.441057424661 | (37.7235259352509, -122.441057424661) | 9 | 7 | 6 | 28861 | 25 | ||||
7591 | 213529 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1301 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5995838.74514 | 2092736.52805 | 37.7260173993826 | -122.456589434062 | (37.7260173993826, -122.456589434062) | 9 | 7 | 4 | 28861 | 40 | |||
7667 | 238373 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 587 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002476.35848 | 2103824.63673 | 37.7568416256553 | -122.434436077082 | (37.7568416256553, -122.434436077082) | 2 | 4 | 5 | 28862 | 3 | |||
7738 | 73633 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 782 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5983562.48746 | 2110479.0519 | 37.7740209842304 | -122.500338183608 | (37.7740209842304, -122.500338183608) | 11 | 6 | 2 | 55 | 26 | |||
7761 | 238135 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 60 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006116.90537 | 2099100.80672 | 37.7440770505137 | -122.421510217522 | (37.7440770505137, -122.421510217522) | 2 | 7 | 7 | 28859 | 2 | |||
7852 | 238334 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 286 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002701.12407 | 2104251.52183 | 37.7580265058249 | -122.433689263855 | (37.7580265058249, -122.433689263855) | 2 | 4 | 5 | 28862 | 3 | |||
7876 | 196488 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014277.71699 | 2112657.65169 | 37.7817579518025 | -122.394240695653 | (37.7817579518025, -122.394240695653) | 6 | 2 | 9 | 28856 | 6 | |||
7882 | 68956 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 874 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 7 | Permit Number 32945 | 5988542.5052 | 2110035.33246 | 37.7730937088544 | -122.483079131422 | (37.7730937088544, -122.483079131422) | 11 | 6 | 2 | 55 | 26 | |
7896 | 4158 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3739-3737 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1989 12:00:00 AM | 12 | 3X3 | 6005577.78119 | 2100485.82594 | 37.7478495841857 | -122.423472835916 | (37.7478495841857, -122.423472835916) | 2 | 4 | 5 | 28859 | 22 | ||
7901 | 70504 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 437 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6004727.68791 | 2092850.78229 | 37.7268374605684 | -122.425869029139 | (37.7268374605684, -122.425869029139) | 9 | 7 | 6 | 28861 | 5 | |||
7935 | 213699 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 62 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 8 | Width 3ft | Permit Number 42424 | 5999655.47058 | 2093801.73285 | 37.7291606000606 | -122.443471779698 | (37.7291606000606, -122.443471779698) | 9 | 7 | 4 | 63 | 40 | |
8095 | 67626 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1334 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 7 | Permit Number 31212 | 6007155.75192 | 2118470.9352 | 37.7973213520513 | -122.419291917399 | (37.7973213520513, -122.419291917399) | 5 | 1 | 10 | 28858 | 32 | |
8150 | 179100 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 135 Craut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004051.95756 | 2094086.86306 | 37.7301932520093 | -122.428293070766 | (37.7301932520093, -122.428293070766) | 9 | 7 | 6 | 28861 | 5 | |||
8166 | 135996 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009314.46183 | 2117374.97438 | 37.7944334526921 | -122.411744720456 | (37.7944334526921, -122.411744720456) | 3 | 1 | 10 | 28857 | 21 | |||
8215 | 78428 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1000 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6003760.55793 | 2089507.02649 | 37.7176015427445 | -122.428974079707 | (37.7176015427445, -122.428974079707) | 9 | 7 | 6 | 28861 | 5 | |||
8306 | 179066 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 252 Otsego Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000335.97419 | 2091752.60204 | 37.723572943118 | -122.440972284042 | (37.723572943118, -122.440972284042) | 9 | 7 | 6 | 28861 | 25 | |||
8324 | 78480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001855.96209 | 2090141.35003 | 37.719235261989 | -122.435602746878 | (37.719235261989, -122.435602746878) | 9 | 7 | 6 | 28861 | 5 | |||
8326 | 72143 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 12 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6000249.61025 | 2091756.38076 | 37.7235783992966 | -122.441271099083 | (37.7235783992966, -122.441271099083) | 9 | 7 | 6 | 28861 | 25 | |||
8391 | 238054 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 432 Lily St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004439.8336 | 2109989.04683 | 37.7738788753301 | -122.428084933487 | (37.7738788753301, -122.428084933487) | 7 | 9 | 11 | 28852 | 10 | |||
8455 | 79359 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 567 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5985009.75382 | 2112015.61326 | 37.7783247854299 | -122.495445265062 | (37.7783247854299, -122.495445265062) | 11 | 6 | 2 | 55 | 26 | |||
8641 | 41286 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 494 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52403 | 6005499.65147882 | 2107857.73967205 | 37.7680867232876 | -122.424267232407 | (37.7680867232876, -122.424267232407) | 8 | 4 | 5 | 28853 | 19 | ||
8680 | 179049 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 179 Santa Rosa Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001280.87762 | 2093214.71451 | 37.7276413438501 | -122.437810596884 | (37.7276413438501, -122.437810596884) | 9 | 7 | 6 | 28861 | 25 | |||
8799 | 28348 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3136 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008810.2764485 | 2100618.7635013 | 37.748396520659 | -122.412304375108 | (37.748396520659, -122.412304375108) | 2 | 4 | 7 | 28859 | 19 | ||
8800 | 53644 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4051 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52604 | 6002653.10802153 | 2105292.31520624 | 37.7608815491861 | -122.433929717717 | (37.7608815491861, -122.433929717717) | 2 | 4 | 5 | 28862 | 3 | |
9027 | 238423 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4328 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000572.71339 | 2105813.81036 | 37.7621951665895 | -122.441162282037 | (37.7621951665895, -122.441162282037) | 15 | 5 | 5 | 28862 | 3 | |||
9062 | 68953 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 750 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 3 | 3x3 | Permit Number 32942 | 5988850.38114 | 2110206.21118 | 37.7735808052559 | -122.482026682299 | (37.7735808052559, -122.482026682299) | 11 | 6 | 2 | 55 | 26 |
9128 | 238117 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3017 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009237.77363 | 2104492.70808 | 37.7590574832375 | -122.411099692516 | (37.7590574832375, -122.411099692516) | 2 | 4 | 7 | 28859 | 19 | |||
9167 | 213451 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4 Cortes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5993177.52134 | 2099659.66969 | 37.7448734694269 | -122.466291957027 | (37.7448734694269, -122.466291957027) | 1 | 8 | 4 | 29491 | 40 | |||
9279 | 196461 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 615 Mississippi St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542099 | (37.7587393543665, -122.39411542099) | 10 | 3 | 8 | 28856 | 29 | |||
9283 | 94134 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 18 Nebraska St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53498 | 6009291 | 2097948 | 37.7410901551317 | -122.410453476975 | (37.7410901551317, -122.410453476975) | 10 | 7 | 7 | 28859 | 2 | |||
9300 | 34481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 839 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 9 | Permit Number 38208 | 6008950.87239 | 2119364.89119 | 37.7998768700862 | -122.413143564642 | (37.7998768700862, -122.413143564642) | 3 | 1 | 10 | 308 | 32 | |
9328 | 47482 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1809 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45377 | 5999495.90716 | 2115146.40334 | 37.7877586907628 | -122.445557657368 | (37.7877586907628, -122.445557657368) | 13 | 6 | 1 | 29490 | 31 | |
9518 | 65278 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205634 | (37.7806943784819, -122.40481205634) | 14 | 2 | 9 | 28853 | 34 | |
9573 | 108831 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 774658 | 6003763.1265 | 2093992.42876 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | 9 | 7 | 6 | 28861 | 5 | |||
9707 | 213504 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 435 Montecito Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995680.74302 | 2093936.83291 | 37.7293040752209 | -122.457222425468 | (37.7293040752209, -122.457222425468) | 9 | 7 | 4 | 28861 | 40 | |||
9716 | 91569 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 301 Girard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2009 12:00:00 AM | 3x3 | Permit Number 52142 | 6010768 | 2093361 | 37.7285779166605 | -122.405023621917 | (37.7285779166605, -122.405023621917) | 10 | 3 | 7 | 309 | 28 | ||
9801 | 72374 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 766 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990089.45799 | 2110137.86742 | 37.7734651388758 | -122.477735579303 | (37.7734651388758, -122.477735579303) | 11 | 6 | 2 | 55 | 26 | |||
9950 | 78381 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 631 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6003379.38532 | 2089522.9059 | 37.7176235608499 | -122.430292752023 | (37.7176235608499, -122.430292752023) | 9 | 7 | 6 | 28861 | 5 | |||
9953 | 73879 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6004728.86924 | 2093550.80398 | 37.7287596319363 | -122.425914753389 | (37.7287596319363, -122.425914753389) | 9 | 7 | 6 | 28861 | 5 | |||
10066 | 91129 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2100X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52620 | 5989031.08283 | 2111274.17492 | 37.776523645314 | -122.481479844539 | (37.776523645314, -122.481479844539) | 11 | 6 | 2 | 55 | 26 | |
10161 | 214669 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2222 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991758.11686 | 2100299.12618 | 37.7465472525561 | -122.471246528119 | (37.7465472525561, -122.471246528119) | 1 | 8 | 4 | 29491 | 40 | |||
10193 | 124493 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3148 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995905.24735 | 2111438.77615 | 37.7773728899422 | -122.45771219988 | (37.7773728899422, -122.45771219988) | 11 | 6 | 2 | 54 | 16 | |||
10261 | 89402 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1914 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992725.99788 | 2112086.29643 | 37.7789676550624 | -122.468757294436 | (37.7789676550624, -122.468757294436) | 11 | 6 | 2 | 54 | 11 | ||
10348 | 91136 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 480 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2009 12:00:00 AM | 3x3 | Permit Number 52024 | 6005604 | 2107874.4 | 37.7681383601012 | -122.423907486341 | (37.7681383601012, -122.423907486341) | 8 | 4 | 5 | 28853 | 19 | ||
10361 | 70279 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90 Arago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5999591.10411 | 2092976.06015 | 37.7268898235963 | -122.443635008456 | (37.7268898235963, -122.443635008456) | 9 | 7 | 6 | 28861 | 25 | |||
10377 | 91396 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2009 12:00:00 AM | 3x3 | Permit Number 52091 | 5996731.3 | 2091236.4 | 37.7219496073249 | -122.453395686079 | (37.7219496073249, -122.453395686079) | 9 | 8 | 4 | 28861 | 24 | ||
10385 | 239400 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 338 Hoffman Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6000612.89044 | 2101776.73481 | 37.7511126294541 | -122.440733730797 | (37.7511126294541, -122.440733730797) | 2 | 4 | 5 | 28862 | 22 | |||
10496 | 68949 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 726 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 4 | Permit Number 32938 | 5988844.72891 | 2110346.33242 | 37.7739652106004 | -122.482056500957 | (37.7739652106004, -122.482056500957) | 11 | 6 | 2 | 55 | 26 | |
10577 | 76677 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010109 | 2093148 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | 10 | 3 | 7 | 309 | 28 | |||
10579 | 237349 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1103X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008183.53987 | 2097707.79876 | 37.7403684685413 | -122.414265694627 | (37.7403684685413, -122.414265694627) | 2 | 7 | 7 | 28859 | 2 | |||
10601 | 78363 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001858.24783 | 2090145.25438 | 37.7192461122881 | -122.435595125122 | (37.7192461122881, -122.435595125122) | 9 | 7 | 6 | 28861 | 5 | |||
10602 | 104255 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
10728 | 237359 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1398 Treat Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008689.76614 | 2100834.9062 | 37.7489832371873 | -122.412736376802 | (37.7489832371873, -122.412736376802) | 2 | 4 | 7 | 28859 | 19 | |||
10833 | 135992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009196.7187 | 2117357.70571 | 37.7943794313202 | -122.412150906452 | (37.7943794313202, -122.412150906452) | 3 | 1 | 10 | 28857 | 21 | |||
10881 | 50928 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2261 Cecelia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47425 | 5991475.24491559 | 2099916.59093812 | 37.7454805429508 | -122.472196779655 | (37.7454805429508, -122.472196779655) | 1 | 8 | 4 | 29491 | 40 | ||
10901 | 4185 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3836 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004920.4543 | 2100493.66271 | 37.7478339791697 | -122.425746400299 | (37.7478339791697, -122.425746400299) | 2 | 4 | 5 | 63 | 22 | |||
11026 | 53052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.25817 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | 13 | 9 | 1 | 29490 | 27 | |
11099 | 45514 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 2 | Permit Number 44278 | 5988535.25971 | 2095760.72309 | 37.7338990344167 | -122.482058269478 | (37.7338990344167, -122.482058269478) | 1 | 8 | 4 | 64 | 35 | |
11117 | 12763 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1806 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 5989830.30372 | 2114748.73304 | 37.7861102501687 | -122.478969342589 | (37.7861102501687, -122.478969342589) | 11 | 6 | 1 | 55 | 33 | |||
11139 | 57395 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1415 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1994 12:00:00 AM | 4 | Permit Number 33423 | 6007958.46126 | 2117300.9237 | 37.7941539658926 | -122.416431412305 | (37.7941539658926, -122.416431412305) | 5 | 1 | 10 | 28858 | 32 | ||
11209 | 27513 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1212 Guerrero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2001 12:00:00 AM | 8 | 3X3 | 6005754.33518 | 2101803.91881 | 37.7514787281818 | -122.422955987444 | (37.7514787281818, -122.422955987444) | 2 | 4 | 5 | 28859 | 19 | ||
11336 | 213698 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 9 | Width 2ft | Permit Number 42422 | 5999705.61228 | 2093800.4183 | 37.7291598500291 | -122.443298341854 | (37.7291598500291, -122.443298341854) | 9 | 7 | 4 | 63 | 40 | |
11361 | 78243 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 30 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000646.02726 | 2093117.37413 | 37.7273379494759 | -122.439998300301 | (37.7273379494759, -122.439998300301) | 9 | 7 | 6 | 28861 | 25 | |||
11396 | 237049 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1420 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010399.81858 | 2100970.62017 | 37.7494517102366 | -122.406832541612 | (37.7494517102366, -122.406832541612) | 2 | 4 | 7 | 28859 | 19 | |||
11529 | 179062 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 18 Colonial Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000439.3413 | 2093583.91766 | 37.7286072022493 | -122.440746262842 | (37.7286072022493, -122.440746262842) | 9 | 7 | 6 | 28861 | 25 | |||
11603 | 238318 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 23 Clover Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6000458.56738 | 2105088.99316 | 37.7601984944918 | -122.441505054123 | (37.7601984944918, -122.441505054123) | 2 | 4 | 5 | 28862 | 3 | |||
11648 | 238436 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 404 Loma Vista Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999965.40666 | 2106753.04147 | 37.7647394502792 | -122.443330183252 | (37.7647394502792, -122.443330183252) | 15 | 5 | 5 | 29492 | 3 | |||
11713 | 214758 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 47 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5995620 | 2092942 | 37.7265690145806 | -122.457360475692 | (37.7265690145806, -122.457360475692) | 9 | 7 | 4 | 28861 | 40 | |||
11716 | 31909 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2227 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 14 | Permit Number 35333 | 5991726.96722 | 2100261.52129 | 37.7464421973476 | -122.471351499672 | (37.7464421973476, -122.471351499672) | 1 | 8 | 4 | 29491 | 40 | |
11717 | 78354 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1125 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000366.91048 | 2090562.17909 | 37.7203060748337 | -122.440779991907 | (37.7203060748337, -122.440779991907) | 9 | 7 | 6 | 28861 | 25 | |||
11733 | 135934 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997041.86737 | 2116129.80097 | 37.7903184311097 | -122.454119176269 | (37.7903184311097, -122.454119176269) | 11 | 6 | 1 | 54 | 31 | |||
11785 | 72266 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325117 | (37.7230023412585, -122.43384325117) | 9 | 7 | 6 | 28861 | 5 | |||
11792 | 135925 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2725 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999832.27617 | 2118786.40209 | 37.7977723656638 | -122.444655616678 | (37.7977723656638, -122.444655616678) | 13 | 9 | 1 | 57 | 17 | |||
11848 | 238215 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 164 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004052.17675 | 2101028.41452 | 37.7492531795117 | -122.428786978444 | (37.7492531795117, -122.428786978444) | 2 | 4 | 5 | 28862 | 22 | |||
11855 | 237398 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1345 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005860.83532 | 2101136.51471 | 37.7496521987857 | -122.422540276735 | (37.7496521987857, -122.422540276735) | 2 | 4 | 5 | 28859 | 19 |
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) );