trees
953 rows where qSpecies_id = 60
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44101 | 4392 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001719.13999 | 2095716.38889 | 37.7345352795846 | -122.436474498408 | (37.7345352795846, -122.436474498408) | 2 | 7 | 5 | 63 | 7 | |||
44198 | 27203 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2001 12:00:00 AM | 6 | 3X3 | 6003520.15249 | 2093475.1012 | 37.7284833853765 | -122.430087965589 | (37.7284833853765, -122.430087965589) | 9 | 7 | 6 | 28861 | 5 | ||
44295 | 204649 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 508 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994044.08453 | 2090032.62859 | 37.7184899416364 | -122.46259736577 | (37.7184899416364, -122.46259736577) | 9 | 8 | 6 | 28861 | 24 | |||
44456 | 37238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.7557291928217 | -122.48675431687 | (37.7557291928217, -122.48675431687) | 1 | 8 | 3 | 56 | 35 | ||
44477 | 204639 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 185 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5998393.85271 | 2093179.60638 | 37.7273803570158 | -122.447788509344 | (37.7273803570158, -122.447788509344) | 9 | 7 | 4 | 28861 | 40 | ||||
44525 | 27187 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 250 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2002 12:00:00 AM | 6 | 2X3 | 6002862.24087 | 2093754.97277 | 37.7292145657007 | -122.432382378945 | (37.7292145657007, -122.432382378945) | 9 | 7 | 6 | 28861 | 25 | ||
44825 | 52659 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 501@ SCOTT Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 8 | Permit Number 48739 | 6000536.81736 | 2121641.57816 | 37.8056520959413 | -122.44242280509 | (37.8056520959413, -122.44242280509) | 13 | 9 | 1 | 57 | 17 | ||
44831 | 125887 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006289.37196 | 2113344.72886 | 37.7831972322057 | -122.421925487583 | (37.7831972322057, -122.421925487583) | 7 | 9 | 11 | 28858 | 41 | |||
44956 | 103510 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
45162 | 100793 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Recently planted by FUF. | 6008363 | 2103862 | 37.7572766073656 | -122.414080464335 | (37.7572766073656, -122.414080464335) | 2 | 4 | 7 | 28859 | 19 | ||||
45337 | 251284 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/21/1996 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
45571 | 244276 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 480 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | 7 | 9 | 11 | 28852 | 10 | |||
45604 | 204647 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5996124.76777 | 2089322.40375 | 37.7166594390698 | -122.455354045254 | (37.7166594390698, -122.455354045254) | 9 | 8 | 6 | 28861 | 24 | |||
45916 | 175782 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.7290892244848 | -122.419690364741 | (37.7290892244848, -122.419690364741) | 9 | 7 | 7 | 309 | 5 | |||
46332 | 27197 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003357.92548 | 2093496.29859 | 37.7285323993286 | -122.430650304475 | (37.7285323993286, -122.430650304475) | 9 | 7 | 6 | 28861 | 5 | ||
46413 | 218271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1456 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 5992773.33281 | 2097243.56743 | 37.7382161345768 | -122.467513887457 | (37.7382161345768, -122.467513887457) | 1 | 8 | 4 | 59 | 40 | |||
46632 | 21528 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.82958 | 2114935.40618 | 37.7875609181413 | -122.422279128893 | (37.7875609181413, -122.422279128893) | 13 | 9 | 1 | 28858 | 41 | ||
46708 | 37017 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39630 | 6008600.86286293 | 2102426.42877225 | 37.7533482108195 | -122.413156329636 | (37.7533482108195, -122.413156329636) | 2 | 4 | 7 | 28859 | 19 | ||
47063 | 124082 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3220 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993384.86337 | 2110069.41246 | 37.7734678747583 | -122.466331413768 | (37.7734678747583, -122.466331413768) | 11 | 6 | 2 | 54 | 11 | |||
47264 | 256155 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80X Peralta Ave | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 6010428 | 2100359 | 37.747773912222 | -122.406691992098 | (37.747773912222, -122.406691992098) | 2 | 7 | 7 | 28859 | 2 | ||||
47354 | 18799 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 36 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017963.3534873 | 2094445.0871971 | 37.7319542116677 | -122.380223926679 | (37.7319542116677, -122.380223926679) | 10 | 3 | 8 | 58 | 1 | |||
47358 | 27206 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/2012 12:00:00 AM | 3 | 3X3 | 6003601.03384 | 2093471.82188 | 37.7284789616114 | -122.429808120849 | (37.7284789616114, -122.429808120849) | 9 | 7 | 6 | 28861 | 5 | ||
47496 | 45707 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.0354809 | 2103995.03426473 | 37.7571302242183 | -122.445339815815 | (37.7571302242183, -122.445339815815) | 2 | 5 | 5 | 28862 | 3 | |||
47527 | 204634 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 451 Hearst Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998426.77789 | 2094369.13977 | 37.7306484177936 | -122.44776028591 | (37.7306484177936, -122.44776028591) | 9 | 7 | 4 | 28861 | 40 | |||
47848 | 175757 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003296.85898 | 2090487.74665 | 37.7202681261541 | -122.430646818702 | (37.7202681261541, -122.430646818702) | 9 | 7 | 6 | 28861 | 5 | |||
48420 | 27011 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1468 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010181.11487 | 2094586.49515 | 37.7319100425197 | -122.407138874981 | (37.7319100425197, -122.407138874981) | 10 | 3 | 7 | 309 | 28 | ||
48460 | 175792 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Holyoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009511.22188 | 2093372.0739 | 37.7285379877196 | -122.409369173844 | (37.7285379877196, -122.409369173844) | 10 | 3 | 7 | 309 | 28 | |||
48513 | 36468 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.7289687842477 | -122.456513863949 | (37.7289687842477, -122.456513863949) | 9 | 7 | 4 | 28861 | 40 | ||
49184 | 125884 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008808.31826 | 2115292.90351 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | 5 | 1 | 10 | 28858 | 21 | |||
49530 | 188327 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1810 23rd St | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6012968.79067 | 2102886.92272 | 37.7548568731497 | -122.398083326981 | (37.7548568731497, -122.398083326981) | 10 | 3 | 8 | 28856 | 29 | |||
50057 | 188346 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1716 Revere Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.392227779994 | (37.7329022519179, -122.392227779994) | 10 | 3 | 8 | 58 | 1 | |||
50195 | 96837 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009513 | 2097465 | 37.7397763850106 | -122.409651795241 | (37.7397763850106, -122.409651795241) | 10 | 7 | 7 | 28859 | 2 | |||
50910 | 222561 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008138.86201 | 2096500.51335 | 37.7370510178737 | -122.414334773354 | (37.7370510178737, -122.414334773354) | 2 | 7 | 7 | 28859 | 2 | |||
50927 | 26893 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275X HUDSON AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/1999 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
51152 | 108581 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1X GARDENSIDE DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999463 | 2102872 | 37.7540544083949 | -122.44478887768 | (37.7540544083949, -122.44478887768) | 2 | 5 | 5 | 63 | 38 | |||||
51488 | 57741 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1976 12:00:00 AM | 10 | 3x3 | Permit Number 16659 | 6001762 | 2096689 | 37.7372082800729 | -122.436395904515 | (37.7372082800729, -122.436395904515) | 2 | 7 | 5 | 63 | 7 | |
51550 | 175773 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990089.90179 | 2089410.48117 | 37.7165531625873 | -122.476219779021 | (37.7165531625873, -122.476219779021) | 1 | 8 | 4 | 64 | 14 | ||||
51674 | 221343 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 24 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998466.64161 | 2106282.9763 | 37.7633631889881 | -122.448480141942 | (37.7633631889881, -122.448480141942) | 15 | 5 | 11 | 29492 | 9 | |||
51972 | 254108 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3249 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x4 | 5985350 | 2113144 | 37.781442927388 | -122.494351441891 | (37.781442927388, -122.494351441891) | 11 | 6 | 2 | 55 | 26 | ||
52066 | 27119 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2345X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6013094.94494 | 2096422.25687 | 37.7371133006396 | -122.397193759945 | (37.7371133006396, -122.397193759945) | 10 | 3 | 8 | 58 | 1 | ||
52154 | 26999 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1200 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6008714.80501 | 2094009.36438 | 37.7302431967539 | -122.412167462084 | (37.7302431967539, -122.412167462084) | 9 | 3 | 7 | 309 | 28 | ||
52425 | 204640 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998733.11218 | 2093060.00406 | 37.7270713418516 | -122.446607092452 | (37.7270713418516, -122.446607092452) | 9 | 7 | 4 | 28861 | 40 | |||
52469 | 183924 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2118 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5988539.4126 | 2100905.5456 | 37.7480256114084 | -122.482420751779 | (37.7480256114084, -122.482420751779) | 1 | 8 | 3 | 29491 | 35 | |||
52734 | 222578 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002709.15868 | 2104802.31344 | 37.7595393031055 | -122.433700841745 | (37.7595393031055, -122.433700841745) | 2 | 4 | 5 | 28862 | 3 | |||
52807 | 123817 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1925 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992665.27685 | 2112027.39662 | 37.7788024241016 | -122.468963063439 | (37.7788024241016, -122.468963063439) | 11 | 6 | 2 | 54 | 11 | |||
52854 | 123824 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1665 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993487.5757 | 2112056.30859 | 37.7789292839599 | -122.466120533372 | (37.7789292839599, -122.466120533372) | 11 | 6 | 2 | 54 | 11 | |||
52915 | 188310 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 189 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012910.65853 | 2106249.78561 | 37.7640873186114 | -122.398520326465 | (37.7640873186114, -122.398520326465) | 14 | 3 | 8 | 28856 | 29 | |||
52992 | 4194 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3870 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004745.48765 | 2100483.94122 | 37.7477973974515 | -122.4263507348 | (37.7477973974515, -122.4263507348) | 2 | 4 | 5 | 63 | 22 | |||
53155 | 46798 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.462081536077 | (37.7338125312017, -122.462081536077) | 9 | 8 | 4 | 59 | 40 | ||
53307 | 257999 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1150 Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004329 | 2112216 | 37.7799872696874 | -122.428627101331 | (37.7799872696874, -122.428627101331) | 7 | 9 | 11 | 29490 | 41 | ||||
53393 | 188350 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Dukes Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016183.29888 | 2096350.88685 | 37.7370887822104 | -122.386510848195 | (37.7370887822104, -122.386510848195) | 10 | 3 | 8 | 58 | 1 | |||
53895 | 175785 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006201.21806 | 2093598.82119 | 37.7289745752989 | -122.420828147413 | (37.7289745752989, -122.420828147413) | 9 | 7 | 6 | 28861 | 5 | |||
53960 | 47228 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45171 | 6011142.39624 | 2091994.05057 | 37.724845479317 | -122.403633167442 | (37.724845479317, -122.403633167442) | 10 | 3 | 7 | 309 | 28 | |
53975 | 10882 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1175X Hudson Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
54152 | 48439 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
54184 | 56623 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001932.70639357 | 2100631.3679946 | 37.7480427977008 | -122.43608772435 | (37.7480427977008, -122.43608772435) | 2 | 4 | 5 | 28862 | 22 | |||||
54578 | 99239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | 1 | 8 | 4 | 59 | 40 | ||||
54841 | 27170 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2080 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6012569.10474 | 2096085.04169 | 37.7361580900166 | -122.398988178079 | (37.7361580900166, -122.398988178079) | 10 | 3 | 8 | 58 | 1 | ||
55247 | 124076 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 701 Funston Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991934.28865 | 2110305.99584 | 37.7740336644487 | -122.471366355947 | (37.7740336644487, -122.471366355947) | 11 | 6 | 2 | 54 | 11 | |||
55248 | 96934 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010990.76512 | 2094811.66283 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | 10 | 3 | 8 | 58 | 1 | |||
55938 | 175783 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.7290628338846 | -122.419916279827 | (37.7290628338846, -122.419916279827) | 9 | 7 | 7 | 309 | 5 | |||
56097 | 188358 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017132.81962 | 2095655.66164 | 37.7352323503922 | -122.383179517428 | (37.7352323503922, -122.383179517428) | 10 | 3 | 8 | 58 | 1 | |||
56102 | 52371 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.7896704425982 | -122.413210878899 | (37.7896704425982, -122.413210878899) | 5 | 1 | 10 | 28858 | 21 |
56273 | 43665 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296 | (37.7832926725519, -122.47097524296) | 11 | 6 | 2 | 54 | 11 | |
56301 | 33288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.413361726687 | (37.7925058062477, -122.413361726687) | 5 | 1 | 10 | 28857 | 21 | |
56360 | 181646 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1266 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986485.3888 | 2106651.0455 | 37.7636814828681 | -122.489945903056 | (37.7636814828681, -122.489945903056) | 1 | 8 | 3 | 56 | 35 | |||
56496 | 106706 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 199X BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5996224 | 2090880 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | 9 | 8 | 6 | 28861 | 24 | |||
57042 | 109185 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 198x JUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998796 | 2093546 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | 9 | 7 | 4 | 28861 | 40 | ||||
57614 | 25940 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2018 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2000 12:00:00 AM | 3 | 3x3 | 6012740.13667 | 2097232.43261 | 37.739318114344 | -122.398477333477 | (37.739318114344, -122.398477333477) | 10 | 3 | 8 | 58 | 1 | ||
57687 | 27191 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 270 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002970.12798 | 2093687.91706 | 37.729036562883 | -122.432004617843 | (37.729036562883, -122.432004617843) | 9 | 7 | 6 | 28861 | 25 | ||
57867 | 188291 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6009385.19996 | 2109515.63966 | 37.7728575647512 | -122.410944589137 | (37.7728575647512, -122.410944589137) | 8 | 2 | 9 | 28853 | 34 | |||
57934 | 30739 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
58302 | 188285 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 106 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010183.94442 | 2110713.51419 | 37.7761914064457 | -122.408266129292 | (37.7761914064457, -122.408266129292) | 8 | 2 | 9 | 28853 | 34 | |||
58365 | 188334 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6013355.93912 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | 10 | 3 | 8 | 28856 | 29 | |||
58433 | 27082 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 799X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
58507 | 109186 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 198x JUDSON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998796 | 2093546 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | 9 | 7 | 4 | 28861 | 40 | ||||
58533 | 222576 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 471 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003000.71138 | 2105505.41806 | 37.7614863982993 | -122.432742735495 | (37.7614863982993, -122.432742735495) | 15 | 4 | 5 | 28862 | 3 | |||
58561 | 39663 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.7199324789318 | -122.462649323963 | (37.7199324789318, -122.462649323963) | 9 | 8 | 6 | 28861 | 24 | ||
58799 | 181676 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2702 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5987326.1189 | 2106457.3084 | 37.7631985905811 | -122.487023887472 | (37.7631985905811, -122.487023887472) | 1 | 8 | 3 | 56 | 35 | |||
59817 | 221362 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1301 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001384.01408 | 2099859.31671 | 37.7458917403255 | -122.437929785824 | (37.7458917403255, -122.437929785824) | 2 | 4 | 5 | 63 | 22 | |||
60157 | 30142 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 410X Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 9 | M | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
60265 | 221323 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3517 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006097.76573 | 2104905.61236 | 37.7600146325834 | -122.421988676659 | (37.7600146325834, -122.421988676659) | 2 | 4 | 5 | 28859 | 19 | |||
60384 | 204655 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 452 Victoria St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.465299811433 | (37.7188834957636, -122.465299811433) | 9 | 8 | 6 | 64 | 24 | |||
60638 | 116949 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 123 WEST PORTAL AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992936 | 2097647 | 37.7393332491746 | -122.466980791321 | (37.7393332491746, -122.466980791321) | 1 | 8 | 4 | 59 | 40 | ||||
60641 | 204654 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 222 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.468865962403 | (37.7165410523041, -122.468865962403) | 9 | 8 | 6 | 64 | 24 | |||
60659 | 175761 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011060.579 | 2091989.46007 | 37.7248283040662 | -122.403915678669 | (37.7248283040662, -122.403915678669) | 10 | 3 | 7 | 309 | 28 | |||
60860 | 221365 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001927.1952 | 2100682.80135 | 37.748183708409 | -122.436110461831 | (37.748183708409, -122.436110461831) | 2 | 4 | 5 | 28862 | 22 | |||
60961 | 188300 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 90 Kissling St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791 | (37.7728541761188, -122.41480452791) | 8 | 2 | 9 | 28853 | 34 | |||
61208 | 188348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 135 Bridgeview Dr | 1 | : | Tree | Private 2 | 11 | Width 2ft | 6013321.68612 | 2095651.63967 | 37.7350099660289 | -122.396355810291 | (37.7350099660289, -122.396355810291) | 10 | 3 | 8 | 58 | 1 | |||
61510 | 10401 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1360 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5999635.0074 | 2108810.0697 | 37.7703686867394 | -122.44462080278 | (37.7703686867394, -122.44462080278) | 15 | 5 | 11 | 29492 | 9 | |||
61548 | 34932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2770 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1997 12:00:00 AM | 5 | Permit Number 38524 | 6000272.2691 | 2114453.3621 | 37.7859000712136 | -122.442821815392 | (37.7859000712136, -122.442821815392) | 13 | 6 | 1 | 29490 | 27 | ||
61661 | 27185 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 238 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002801.11945 | 2093793.8954 | 37.7293179724305 | -122.432596459871 | (37.7293179724305, -122.432596459871) | 9 | 7 | 6 | 28861 | 25 | ||
61720 | 100152 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002933.4 | 2105264.1 | 37.7608199793321 | -122.432958296422 | (37.7608199793321, -122.432958296422) | 2 | 4 | 5 | 28862 | 3 | |||
61923 | 95866 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 32 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767584 | 6009326.62305 | 2109462.37063 | 37.7727080155855 | -122.411143450809 | (37.7727080155855, -122.411143450809) | 8 | 2 | 9 | 28853 | 34 |
62111 | 175778 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 281 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004138.17928 | 2091770.31166 | 37.7238373950554 | -122.427829991858 | (37.7238373950554, -122.427829991858) | 9 | 7 | 6 | 28861 | 5 | |||
62112 | 188324 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 8 | : | Tree | Private 2 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | 10 | 3 | 8 | 28856 | 29 | |||
62252 | 31341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 430 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772811 | 6005729.4209 | 2111051.1148 | 37.7768679337671 | -122.423699563703 | (37.7768679337671, -122.423699563703) | 7 | 9 | 11 | 28852 | 10 | |
62751 | 121683 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1645 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993978 | 2104308 | 37.7576827524199 | -122.463861408714 | (37.7576827524199, -122.463861408714) | 1 | 8 | 4 | 56 | 12 | ||||
62828 | 39705 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | 9 | 8 | 4 | 59 | 40 | ||
63122 | 36807 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Donner Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 8 | Permit Number 39531 | 6014713.4944 | 2091220.9181 | 37.7229214477716 | -122.391234181927 | (37.7229214477716, -122.391234181927) | 10 | 3 | 8 | 58 | 1 |
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) );