trees
665 rows where qSpecies_id = 89 sorted by Police Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▼ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
175348 | 97941 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
178236 | 249821 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 3 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010901.87597 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) | 3 | 1 | 10 | 308 | 23 | |||
178268 | 125503 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6007472.5485 | 2120196.70062 | 37.8020777071716 | -122.418318141382 | (37.8020777071716, -122.418318141382) | 5 | 1 | 1 | 28858 | 32 | |||
182154 | 125467 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008702.23207 | 2116269.4831 | 37.7913636807268 | -122.413784882888 | (37.7913636807268, -122.413784882888) | 5 | 1 | 10 | 28857 | 21 | |||
182215 | 249950 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 303 Filbert St | 5 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.8019120241928 | -122.404858102512 | (37.8019120241928, -122.404858102512) | 3 | 1 | 10 | 308 | 23 | |||
186226 | 32707 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.417306405748 | (37.7900973284958, -122.417306405748) | 13 | 1 | 10 | 28858 | 21 | ||
186427 | 32706 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | 13 | 1 | 10 | 28858 | 21 | |
187380 | 125532 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 11 Miller Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010078.47215 | 2116887.6611 | 37.7931382383022 | -122.409066739034 | (37.7931382383022, -122.409066739034) | 3 | 1 | 10 | 28857 | 4 | |||
187634 | 32133 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.7951238190257 | -122.407204773258 | (37.7951238190257, -122.407204773258) | 3 | 1 | 10 | 28857 | 4 | ||
188461 | 97939 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
189345 | 125524 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011207.68462 | 2120726.93894 | 37.8037431562814 | -122.405430083952 | (37.8037431562814, -122.405430083952) | 3 | 1 | 10 | 308 | 23 | |||
190022 | 249946 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 305 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011346.83837 | 2120055.65824 | 37.8019077631812 | -122.404901241218 | (37.8019077631812, -122.404901241218) | 3 | 1 | 10 | 308 | 23 | |||
190539 | 125507 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008925.22265 | 2118571.08085 | 37.7976958234636 | -122.413176159668 | (37.7976958234636, -122.413176159668) | 3 | 1 | 10 | 308 | 21 | |||
191914 | 125472 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6010077.81978 | 2116010.1713 | 37.7907288268122 | -122.409007053754 | (37.7907288268122, -122.409007053754) | 5 | 1 | 10 | 28857 | 21 | |||
193513 | 125465 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1177 California St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6008661.04402 | 2116264.72933 | 37.7913483149251 | -122.413927056694 | (37.7913483149251, -122.413927056694) | 5 | 1 | 10 | 28857 | 21 | |||
21935 | 91500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009901.41754 | 2113830.53604 | 37.784734187987 | -122.40946350554 | (37.784734187987, -122.40946350554) | 14 | 10 | 9 | 28852 | 36 | |
51367 | 65437 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 175 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28311 | 6009164.55626174 | 2113209.72407625 | 37.7829882723647 | -122.411968925085 | (37.7829882723647, -122.411968925085) | 14 | 10 | 9 | 28852 | 36 | ||
90041 | 125462 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.409488968035 | (37.7849005400769, -122.409488968035) | 14 | 10 | 9 | 28852 | 36 | |
131175 | 91501 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 52121 | 6009912 | 2113772 | 37.7845740549071 | -122.409422761042 | (37.7845740549071, -122.409422761042) | 14 | 10 | 9 | 28852 | 36 | ||
133287 | 92978 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 147 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009889.178 | 2113928.01502 | 37.7850011562254 | -122.409512732628 | (37.7850011562254, -122.409512732628) | 14 | 10 | 9 | 28852 | 36 | ||
135153 | 57875 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 411 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1997 12:00:00 AM | Permit Number 16823 | 6009320.51611206 | 2114267.52405605 | 37.7859014867053 | -122.411504124328 | (37.7859014867053, -122.411504124328) | 14 | 10 | 9 | 28852 | 36 | ||
173885 | 92979 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 147 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009891.19153 | 2113906.4761 | 37.78494212831 | -122.40950424575 | (37.78494212831, -122.40950424575) | 14 | 10 | 9 | 28852 | 36 | ||
178191 | 91499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009892.98607 | 2113874.19242 | 37.7848535855735 | -122.409495757934 | (37.7848535855735, -122.409495757934) | 14 | 10 | 9 | 28852 | 36 | |
317 | 189161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.415210253457 | (37.7724477670719, -122.415210253457) | 8 | 2 | 9 | 28853 | 19 | |||
13876 | 189183 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6013471.29582 | 2110911.40867 | 37.7769183095594 | -122.396908085761 | (37.7769183095594, -122.396908085761) | 6 | 2 | 9 | 28856 | 34 | |||
22266 | 189179 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012646.32236 | 2115321.24239 | 37.7889807363318 | -122.400071707361 | (37.7889807363318, -122.400071707361) | 12 | 2 | 9 | 28855 | 6 | |||
23055 | 189156 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012246.95244 | 2112466.10025 | 37.7811189079475 | -122.401252766302 | (37.7811189079475, -122.401252766302) | 6 | 2 | 9 | 28856 | 34 | |||
31263 | 30606 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | ||
43617 | 189198 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 450 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010926.82993 | 2112099.93954 | 37.7800397781655 | -122.405793955035 | (37.7800397781655, -122.405793955035) | 14 | 2 | 9 | 28853 | 34 | |||
46462 | 189178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012651.66778 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | 12 | 2 | 9 | 28855 | 6 | |||
49713 | 189182 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013480.92655 | 2110921.93119 | 37.7769477380782 | -122.3968755078 | (37.7769477380782, -122.3968755078) | 6 | 2 | 9 | 28856 | 34 | |||
57639 | 189157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.7810840205508 | -122.401309519845 | (37.7810840205508, -122.401309519845) | 6 | 2 | 9 | 28856 | 34 | |||
57858 | 189153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012332.53447 | 2112551.48713 | 37.7813581348078 | -122.400962694499 | (37.7813581348078, -122.400962694499) | 6 | 2 | 9 | 28856 | 34 | |||
58880 | 33006 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 | ||
63523 | 189189 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013286.37012 | 2110737.42351 | 37.776430290657 | -122.397535599396 | (37.776430290657, -122.397535599396) | 6 | 2 | 9 | 28856 | 34 | |||
67570 | 189177 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012656.64503 | 2115309.49846 | 37.7889490657959 | -122.400035166996 | (37.7889490657959, -122.400035166996) | 12 | 2 | 9 | 28855 | 6 | |||
77561 | 30608 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | ||
77564 | 33004 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 | ||
77696 | 220591 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 45 Pearl St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6005640.71146 | 2108782.82006 | 37.7706347365469 | -122.423845107576 | (37.7706347365469, -122.423845107576) | 8 | 2 | 5 | 28853 | 19 | |||
86176 | 189188 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6013301.8737 | 2110750.05964 | 37.7764658498439 | -122.397482854168 | (37.7764658498439, -122.397482854168) | 6 | 2 | 9 | 28856 | 34 | |||
86693 | 189186 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6013353.39902 | 2110803.04971 | 37.7766142173155 | -122.397308329042 | (37.7766142173155, -122.397308329042) | 6 | 2 | 9 | 28856 | 34 | |||
88873 | 189160 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6008158.83722 | 2109400.58141 | 37.772472797918 | -122.415178587445 | (37.772472797918, -122.415178587445) | 8 | 2 | 9 | 28853 | 19 | |||
93816 | 189197 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 453 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014136.4691 | 2112772.98188 | 37.7820667700107 | -122.394737429894 | (37.7820667700107, -122.394737429894) | 6 | 2 | 9 | 28856 | 6 | |||
100444 | 189158 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6008181.20874 | 2109420.17856 | 37.7725278642987 | -122.415102589323 | (37.7725278642987, -122.415102589323) | 8 | 2 | 9 | 28853 | 19 | |||
104873 | 189187 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6013322.92845 | 2110771.0682 | 37.7765247068749 | -122.397411492965 | (37.7765247068749, -122.397411492965) | 6 | 2 | 9 | 28856 | 34 | |||
108852 | 189154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012314.00092 | 2112536.43535 | 37.7813157722581 | -122.401025754031 | (37.7813157722581, -122.401025754031) | 6 | 2 | 9 | 28856 | 34 | |||
112328 | 31087 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 61 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 10 | Permit Number 34823 | 6005643.97957 | 2108712.30745 | 37.7704413103375 | -122.42382878848 | (37.7704413103375, -122.42382878848) | 8 | 2 | 5 | 28853 | 19 | |
115495 | 59475 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Pearl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30019 | 6005649.89083993 | 2108784.60921416 | 37.7706401673343 | -122.423813483184 | (37.7706401673343, -122.423813483184) | 8 | 2 | 5 | 28853 | 19 | ||
117987 | 92782 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 527 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52999 | 6013573 | 2112256 | 37.7806159117786 | -122.396650538079 | (37.7806159117786, -122.396650538079) | 6 | 2 | 9 | 28856 | 34 | |||
118456 | 62043 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 453 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1993 12:00:00 AM | 3 | Permit Number 31992 | 6014123.24012 | 2112760.57959 | 37.7820319806273 | -122.394782327659 | (37.7820319806273, -122.394782327659) | 6 | 2 | 9 | 28856 | 6 | ||
119465 | 189175 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012666.59913 | 2115298.53532 | 37.7889195185657 | -122.399999956726 | (37.7889195185657, -122.399999956726) | 12 | 2 | 9 | 28855 | 6 | |||
121744 | 189191 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6013220.72643 | 2110673.77845 | 37.7762518804538 | -122.397758215766 | (37.7762518804538, -122.397758215766) | 6 | 2 | 9 | 28856 | 34 | |||
121797 | 189162 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6008137.74771 | 2109383.99653 | 37.7724260745213 | -122.41525036412 | (37.7724260745213, -122.41525036412) | 8 | 2 | 9 | 28853 | 19 | |||
123590 | 189184 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6013459.66135 | 2110901.5969 | 37.776890721054 | -122.396947645136 | (37.776890721054, -122.396947645136) | 6 | 2 | 9 | 28856 | 34 | |||
131146 | 189190 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6013250.96845 | 2110705.54176 | 37.7763407793478 | -122.397655827955 | (37.7763407793478, -122.397655827955) | 6 | 2 | 9 | 28856 | 34 | |||
133628 | 52182 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 626 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | 7 | Permit Number 48372 | 6009510.44618 | 2111352.38647 | 37.7779078632967 | -122.410641078729 | (37.7779078632967, -122.410641078729) | 8 | 2 | 9 | 28853 | 34 | |
139089 | 189159 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6008170.01676 | 2109410.076 | 37.7724994960939 | -122.415140588393 | (37.7724994960939, -122.415140588393) | 8 | 2 | 9 | 28853 | 19 | |||
144036 | 189155 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.401205471869 | (37.7811537953404, -122.401205471869) | 6 | 2 | 9 | 28856 | 34 | |||
158434 | 92783 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 527 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3x3 | Permit Number 52999 | 6013573 | 2112256 | 37.7806159117786 | -122.396650538079 | (37.7806159117786, -122.396650538079) | 6 | 2 | 9 | 28856 | 34 | ||
162391 | 189180 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 123 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012900.45208 | 2113712.93045 | 37.7845788525671 | -122.399079511431 | (37.7845788525671, -122.399079511431) | 6 | 2 | 9 | 28853 | 6 | |||
164019 | 189199 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011498.9088 | 2112374.96394 | 37.7808269070747 | -122.403834223497 | (37.7808269070747, -122.403834223497) | 6 | 2 | 9 | 28853 | 34 | |||
167693 | 189185 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6013378.56954 | 2110827.99397 | 37.7766841099114 | -122.397223005848 | (37.7766841099114, -122.397223005848) | 6 | 2 | 9 | 28856 | 34 | |||
176265 | 189176 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012661.31608 | 2115304.65409 | 37.7889360247231 | -122.400018665349 | (37.7889360247231, -122.400018665349) | 12 | 2 | 9 | 28855 | 6 | |||
178492 | 189181 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6013494.87898 | 2110935.49205 | 37.7769857497279 | -122.396828192679 | (37.7769857497279, -122.396828192679) | 6 | 2 | 9 | 28856 | 34 | |||
180103 | 95587 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767377 | 6012153 | 2112651 | 37.7816213577124 | -122.401590796207 | (37.7816213577124, -122.401590796207) | 6 | 2 | 9 | 28856 | 34 | |
189305 | 30607 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 3x3 | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | |
191382 | 33001 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 | ||
420 | 35740 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 9 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | 12 | Permit Number 39014 | 6007525.01662 | 2093953.73286 | 37.7300236128799 | -122.416276791867 | (37.7300236128799, -122.416276791867) | 9 | 3 | 7 | 309 | 28 | |
1455 | 176735 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007785.06482 | 2091940.88647 | 37.7245113883837 | -122.415235340041 | (37.7245113883837, -122.415235340041) | 9 | 3 | 7 | 309 | 28 | ||
1725 | 261074 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 545 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012421 | 2094417 | 37.7315697407484 | -122.399383175238 | (37.7315697407484, -122.399383175238) | 10 | 3 | 8 | 58 | 1 | |
6336 | 261055 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1948 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780729 | 6013389.35902 | 2096036.97619 | 37.7360717858924 | -122.396148836191 | (37.7360717858924, -122.396148836191) | 10 | 3 | 8 | 58 | 1 |
8425 | 175169 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 728 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009133.75655 | 2092888.51191 | 37.7271890729929 | -122.41063996266 | (37.7271890729929, -122.41063996266) | 9 | 3 | 7 | 309 | 28 | |||
8824 | 261056 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1952 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780727 | 6013369.93114 | 2096051.4395 | 37.7361104181421 | -122.396217020065 | (37.7361104181421, -122.396217020065) | 10 | 3 | 8 | 58 | 1 |
9227 | 249036 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013092.81558 | 2091032.06192 | 37.7223128112827 | -122.396823338154 | (37.7223128112827, -122.396823338154) | 10 | 3 | 8 | 58 | 1 | |
13613 | 261072 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1301 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2020 04:47:00 PM | 3 | 4x6 | 6014770 | 2090698 | 37.7214887539174 | -122.391002321697 | (37.7214887539174, -122.391002321697) | 10 | 3 | 8 | 58 | 1 | |
13926 | 176734 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007778.84426 | 2091938.91597 | 37.7245056282085 | -122.415256704327 | (37.7245056282085, -122.415256704327) | 9 | 3 | 7 | 309 | 28 | ||
20384 | 189165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | 10 | 3 | 8 | 28856 | 29 | |||
29617 | 50533 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47172 | 6014106.88689945 | 2104884.78697192 | 37.760405899811 | -122.394287314563 | (37.760405899811, -122.394287314563) | 10 | 3 | 8 | 28856 | 29 | |||
32468 | 189167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1300x De Haro St | 18 | Median : Yard | Tree | DPW 1 | 1 | 6012264.80612 | 2102152.75254 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | 10 | 3 | 8 | 28856 | 29 | ||||
32554 | 99407 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
37305 | 189152 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1665 Hudson Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6015368.44602 | 2097645.03721 | 37.7405971121722 | -122.389418536259 | (37.7405971121722, -122.389418536259) | 10 | 3 | 8 | 58 | 1 | |||
43231 | 99401 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2201X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | |
45527 | 189170 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 360 Texas St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6013732.7365 | 2105419.19303 | 37.7618524574395 | -122.395618779897 | (37.7618524574395, -122.395618779897) | 10 | 3 | 8 | 28856 | 29 | |||
47611 | 189171 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 672 Missouri St | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013547.27138 | 2103937.27162 | 37.7577731065529 | -122.396156373043 | (37.7577731065529, -122.396156373043) | 10 | 3 | 8 | 28856 | 29 | |||
50975 | 189168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 606 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011490.76938 | 2105489.27118 | 37.7619199120061 | -122.40337783013 | (37.7619199120061, -122.40337783013) | 10 | 3 | 8 | 28856 | 29 | |||
53345 | 79776 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2331 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | 1 | Permit Number 774959 | 6011828.97856 | 2101840.08638 | 37.7519189391152 | -122.401951552136 | (37.7519189391152, -122.401951552136) | 10 | 3 | 8 | 28856 | 29 | |
55420 | 189193 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012073.86009 | 2107513.44954 | 37.7675104026963 | -122.401503402873 | (37.7675104026963, -122.401503402873) | 14 | 3 | 8 | 28856 | 20 | |||
58064 | 189174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Waterville St | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6011435.76202 | 2096086.73565 | 37.7360995216629 | -122.402906748143 | (37.7360995216629, -122.402906748143) | 10 | 3 | 8 | 58 | 1 | |||
62150 | 67492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1119 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2015 12:00:00 AM | 3 | Permit Number 774343 | 6011679.29477 | 2103189.50582 | 37.7556157939465 | -122.402564065097 | (37.7556157939465, -122.402564065097) | 10 | 3 | 8 | 28856 | 29 | |
72478 | 189173 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1960 Quesada Ave | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.7361619750843 | -122.396301660307 | (37.7361619750843, -122.396301660307) | 10 | 3 | 8 | 58 | 1 | |||
73766 | 189195 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012037.52857 | 2107512.72185 | 37.7675063773463 | -122.401629018386 | (37.7675063773463, -122.401629018386) | 14 | 3 | 8 | 28856 | 20 | |||
79287 | 189192 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012099.20346 | 2107516.84427 | 37.7675211379264 | -122.401415981588 | (37.7675211379264, -122.401415981588) | 14 | 3 | 8 | 28856 | 20 | |||
79988 | 201923 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Elmira St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.7358650396404 | -122.403662651736 | (37.7358650396404, -122.403662651736) | 10 | 3 | 8 | 58 | 1 | |||
89640 | 116047 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 5x12 | 6011496.1211 | 2105415.82819 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | 10 | 3 | 8 | 28856 | 29 | ||
94900 | 34852 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1997 12:00:00 AM | 9 | Permit Number 38475 | 6014107.65557 | 2104887.53933 | 37.760413499915 | -122.394284848775 | (37.760413499915, -122.394284848775) | 10 | 3 | 8 | 28856 | 29 | ||
103501 | 99402 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2201X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | |
111073 | 51699 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 270 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | 4 | Permit Number 47975 | 6009229.91351 | 2094736.03223 | 37.7322673611424 | -122.410437947053 | (37.7322673611424, -122.410437947053) | 10 | 3 | 7 | 309 | 28 | ||
111284 | 189200 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 625 Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6016323.4017 | 2097117.36023 | 37.7392011179238 | -122.386079860717 | (37.7392011179238, -122.386079860717) | 10 | 3 | 8 | 58 | 1 | |||
114783 | 99408 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
120168 | 35721 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 556 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1998 12:00:00 AM | 10 | Permit Number 39004 | 6008810.28905 | 2093458.06001 | 37.7287347899617 | -122.411798418969 | (37.7287347899617, -122.411798418969) | 9 | 3 | 7 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );