trees
953 rows where qSpecies_id = 60 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
96465 | 100147 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3955 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003272 | 2105332 | 37.7610256161684 | -122.431792078279 | (37.7610256161684, -122.431792078279) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
117911 | 100285 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1426 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 10129 | 5994323.3 | 2105790 | 37.7617718339078 | -122.462774738749 | (37.7617718339078, -122.462774738749) | 1 | 5 | 11 | 56 | 12 | ||||
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 | ||||
65055 | 101156 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6013453.76144 | 2105247.59109 | 37.7613657542352 | -122.396571621485 | (37.7613657542352, -122.396571621485) | 10 | 3 | 8 | 28856 | 29 | |||
101359 | 101157 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x5 | 6013434.11839 | 2105245.81969 | 37.7613597971466 | -122.396639434871 | (37.7613597971466, -122.396639434871) | 10 | 3 | 8 | 28856 | 29 | |||
117544 | 101158 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x5 | 6013408.6905 | 2105245.25033 | 37.7613568185891 | -122.396727339995 | (37.7613568185891, -122.396727339995) | 10 | 3 | 8 | 28856 | 29 | |||
37552 | 101159 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.396801432457 | (37.7613518552239, -122.396801432457) | 10 | 3 | 8 | 28856 | 29 | |||
116031 | 101601 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180X Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | 9 | 7 | 4 | 28861 | 40 | |||
28573 | 101604 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180X Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | 9 | 7 | 4 | 28861 | 40 | |||
140939 | 101605 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180X Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | 9 | 7 | 4 | 28861 | 40 | |||
186025 | 102585 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 173 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/07/2013 12:00:00 AM | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.447738107529 | (37.7272185530423, -122.447738107529) | 9 | 7 | 4 | 28861 | 40 | |||
187776 | 102871 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 173 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.447738107529 | (37.7272185530423, -122.447738107529) | 9 | 7 | 4 | 28861 | 40 | ||||
79831 | 102872 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 173 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.447738107529 | (37.7272185530423, -122.447738107529) | 9 | 7 | 4 | 28861 | 40 | ||||
23186 | 103507 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
160338 | 103508 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
143719 | 103509 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
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 | |||
83367 | 103511 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
96967 | 10387 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1352 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5999669.18514 | 2108830.5589 | 37.7704268951205 | -122.444504055148 | (37.7704268951205, -122.444504055148) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
141711 | 104501 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 157163 ALBION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6005993 | 2106325 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | 8 | 4 | 5 | 28859 | 19 | |||
70383 | 104503 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 157 ALBION ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6005993 | 2106325 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | 8 | 4 | 5 | 28859 | 19 | ||||
156759 | 104504 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 157-163 ALBION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6005993 | 2106325 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | 8 | 4 | 5 | 28859 | 19 | |||
90955 | 104505 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 157163 ALBION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6005993 | 2106325 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | 8 | 4 | 5 | 28859 | 19 | |||
111487 | 104766 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1111 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002562.6 | 2102271.3 | 37.7525814287469 | -122.434026788658 | (37.7525814287469, -122.434026788658) | 2 | 4 | 5 | 28862 | 22 | |||
105758 | 104767 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1111 CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 6002562.6 | 2102271.3 | 37.7525814287469 | -122.434026788658 | (37.7525814287469, -122.434026788658) | 2 | 4 | 5 | 28862 | 22 | |||
72634 | 104807 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2069 GREEN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003141.4 | 2118171.7 | 37.7962728265697 | -122.433161198258 | (37.7962728265697, -122.433161198258) | 13 | 9 | 1 | 57 | 17 | ||||||
162844 | 106009 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1745 LANE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6014990.1 | 2094194.5 | 37.7311016564679 | -122.390485679987 | (37.7311016564679, -122.390485679987) | 10 | 3 | 8 | 58 | 1 | |||
65476 | 106091 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1200 HUDSON AVE | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6017390 | 2095089 | 37.7336906184027 | -122.382250932174 | (37.7336906184027, -122.382250932174) | 10 | 3 | 8 | 58 | 1 | |||
154218 | 106704 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 179 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5996189.7 | 2091071.1 | 37.7214646729593 | -122.455255909802 | (37.7214646729593, -122.455255909802) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
155842 | 107041 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1301 18TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6013691.7 | 2105657.2 | 37.7625036896712 | -122.395777387543 | (37.7625036896712, -122.395777387543) | 10 | 3 | 8 | 28856 | 29 | ||||
6168 | 107105 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 532 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6002950.4 | 2105092.9 | 37.7603508695767 | -122.432887270079 | (37.7603508695767, -122.432887270079) | 2 | 4 | 5 | 28862 | 3 | |||
158365 | 107106 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 532 NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6002950.4 | 2105092.9 | 37.7603508695767 | -122.432887270079 | (37.7603508695767, -122.432887270079) | 2 | 4 | 5 | 28862 | 3 | |||
83415 | 107235 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.7886993852058 | -122.413257820814 | (37.7886993852058, -122.413257820814) | 5 | 1 | 10 | 28858 | 21 | |||
29421 | 107444 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3333 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6x6 | 6006088.7 | 2103711.1 | 37.7567342687503 | -122.421935176249 | (37.7567342687503, -122.421935176249) | 2 | 4 | 5 | 28859 | 19 | |||
174509 | 108373 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 637 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | Permit Number 773812 | 6002662.58132 | 2089906.96275 | 37.718637468222 | -122.432797836946 | (37.718637468222, -122.432797836946) | 9 | 7 | 6 | 28861 | 5 | |
132499 | 108374 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 637 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | Permit Number 773812 | 6002670.30203 | 2089919.45736 | 37.7186722135403 | -122.432772041698 | (37.7186722135403, -122.432772041698) | 9 | 7 | 6 | 28861 | 5 | |
144380 | 10852 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299X HUDSON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2016 12:00:00 AM | 3 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
86372 | 10855 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299X HUDSON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
189422 | 10856 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299X HUDSON AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/1996 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 | |||||
82067 | 10863 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275X HUDSON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
185134 | 10864 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275X HUDSON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/1993 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
111726 | 108723 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.397959844253 | (37.7565264696642, -122.397959844253) | 10 | 3 | 8 | 28856 | 29 | |
88423 | 108730 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1822-1898X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773105 | 6013006 | 2102886 | 37.7548564119513 | -122.39795458116 | (37.7548564119513, -122.39795458116) | 10 | 3 | 8 | 28856 | 29 |
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 | |||
87411 | 10887 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1270X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
26959 | 10888 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1270X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
26153 | 108935 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12X CAMP ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005858 | 2106413 | 37.7641400388714 | -122.422925047265 | (37.7641400388714, -122.422925047265) | 8 | 4 | 5 | 28859 | 19 | ||||
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 | ||||
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 | ||||
34811 | 109380 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 725X BURNETT AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5999257.1 | 2101645.9 | 37.7506760851616 | -122.445412771855 | (37.7506760851616, -122.445412771855) | 2 | 5 | 5 | 63 | 38 | |||||
25373 | 110420 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
34147 | 110720 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
40666 | 110721 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
128 | 110722 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | 1 | 8 | 4 | 56 | 12 | |||||
181591 | 111080 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2811 14TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5992341 | 2097126 | 37.7378683540452 | -122.469000113007 | (37.7378683540452, -122.469000113007) | 1 | 8 | 4 | 59 | 40 | |||
69488 | 111230 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1113 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
139654 | 111669 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
145614 | 111670 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
89809 | 112175 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 607 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5986883.70014 | 2111802.41515 | 37.7778489521099 | -122.488946999613 | (37.7778489521099, -122.488946999613) | 11 | 6 | 2 | 55 | 26 | |||
89189 | 112176 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 607 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 5986882.73557 | 2111785.73395 | 37.7778030939685 | -122.488949109766 | (37.7778030939685, -122.488949109766) | 11 | 6 | 2 | 55 | 26 | |||
11233 | 112393 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4127 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002153 | 2105221 | 37.7606573415981 | -122.435654265974 | (37.7606573415981, -122.435654265974) | 2 | 4 | 5 | 28862 | 3 | ||||
92664 | 112551 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 26 HIDALGO TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6004993 | 2107524 | 37.7671417328885 | -122.425995926974 | (37.7671417328885, -122.425995926974) | 8 | 4 | 5 | 28853 | 19 | |||
422 | 113225 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6008828.65356 | 2115644.68399 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | 5 | 1 | 10 | 28858 | 21 | ||
74586 | 113271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1321 Revere Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260 | 37.7286210040554 | -122.385097187433 | (37.7286210040554, -122.385097187433) | 10 | 3 | 8 | 58 | 1 | ||||
96910 | 114307 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 595 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008020 | 2113749 | 37.7844047125189 | -122.415966831143 | (37.7844047125189, -122.415966831143) | 7 | 10 | 9 | 28858 | 36 | ||||
180671 | 114552 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1121 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777071 | 6011681.54455 | 2103150.14548 | 37.7555078447183 | -122.402553516927 | (37.7555078447183, -122.402553516927) | 10 | 3 | 8 | 28856 | 29 | ||
77285 | 114570 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 366 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014008 | 2105399 | 37.7618123194661 | -122.394665331171 | (37.7618123194661, -122.394665331171) | 10 | 3 | 8 | 28856 | 29 | ||||
187057 | 114669 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 176X Peralta Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774564 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | 2 | 7 | 7 | 28859 | 2 | |||
183279 | 116347 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 10 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | |||
43658 | 116348 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
32163 | 116349 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
151876 | 116351 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
100401 | 116352 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
87948 | 116353 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | ||||
162242 | 116354 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4051X 24TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 10 | 3x3 | 6002850 | 2101803 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | 2 | 4 | 5 | 28862 | 22 | |||
63443 | 116373 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 366 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6014023.28278 | 2105408.18049 | 37.7618383767519 | -122.394613116617 | (37.7618383767519, -122.394613116617) | 10 | 3 | 8 | 28856 | 29 | |||
148169 | 116626 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 5732X GEARY BLVD | 7 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
19637 | 116726 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180X PERALTA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009777 | 2100122 | 37.7470867174475 | -122.408926407614 | (37.7470867174475, -122.408926407614) | 2 | 7 | 7 | 28859 | 2 | ||||
137786 | 116874 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012413.67241 | 2104134.33813 | 37.7582510683591 | -122.400090692038 | (37.7582510683591, -122.400090692038) | 10 | 3 | 8 | 28856 | 29 | |||
17042 | 116875 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012413.40755 | 2104121.29509 | 37.7582152402716 | -122.400090692059 | (37.7582152402716, -122.400090692059) | 10 | 3 | 8 | 28856 | 29 | |||
72533 | 116876 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012412.72368 | 2104109.13047 | 37.7581818007698 | -122.400092202897 | (37.7581818007698, -122.400092202897) | 10 | 3 | 8 | 28856 | 29 | |||
169589 | 116948 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 123 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992936 | 2097647 | 37.7393332491746 | -122.466980791321 | (37.7393332491746, -122.466980791321) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||
42353 | 118039 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3501 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5984617.86672 | 2113142.5664 | 37.7813961183692 | -122.496884124491 | (37.7813961183692, -122.496884124491) | 11 | 6 | 2 | 55 | 26 | ||
103448 | 118672 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4600 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5981237.2536 | 2110989.81786 | 37.7752866381156 | -122.508419343439 | (37.7752866381156, -122.508419343439) | 11 | 6 | 2 | 55 | 26 | ||
101504 | 119916 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3801 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5986867.20951 | 2111818.56024 | 37.7778923194923 | -122.489005232889 | (37.7778923194923, -122.489005232889) | 11 | 6 | 2 | 55 | 26 | |||
135476 | 120154 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 187 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6002716.18242301 | 2104822.03495589 | 37.7595938521819 | -122.433677959685 | (37.7595938521819, -122.433677959685) | 2 | 4 | 5 | 28862 | 3 | ||||
170141 | 120155 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 187 Hartford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6002716.18242301 | 2104822.03495589 | 37.7595938521819 | -122.433677959685 | (37.7595938521819, -122.433677959685) | 2 | 4 | 5 | 28862 | 3 | ||||
69956 | 120687 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2040 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:45:00 PM | 3 | Width 3ft | 5989191.37637 | 2111280.32009 | 37.7765498370385 | -122.480925799615 | (37.7765498370385, -122.480925799615) | 11 | 6 | 2 | 55 | 26 | ||
40526 | 121353 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.7641755703197 | -122.496596073864 | (37.7641755703197, -122.496596073864) | 1 | 8 | 3 | 56 | 35 | ||
176640 | 121682 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1645 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993978 | 2104308 | 37.7576827524199 | -122.463861408714 | (37.7576827524199, -122.463861408714) | 1 | 8 | 4 | 56 | 12 | ||||
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 | ||||
1169 | 12272 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 700X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 3 | 3X3 | 6004950.3992 | 2111308.9655 | 37.7775319231116 | -122.426412801229 | (37.7775319231116, -122.426412801229) | 7 | 9 | 11 | 28852 | 10 | ||
191879 | 12283 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 803X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2000 12:00:00 AM | 3 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | 7 | 9 | 11 | 28852 | 41 | ||
156072 | 12293 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 841X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2002 12:00:00 AM | 3 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.426804270071 | (37.7787020480516, -122.426804270071) | 7 | 9 | 11 | 28852 | 41 | ||
141699 | 12297 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 861 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2004 12:00:00 AM | 3 | 4X4 | 6004837.02716 | 2111802.36626 | 37.7788802710673 | -122.426840140564 | (37.7788802710673, -122.426840140564) | 7 | 9 | 11 | 28852 | 41 |
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) );