trees
443 rows where qSpecies_id = 32 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
132142 | 100385 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1800 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2012 12:00:00 AM | 3x3 | Permit Number 769433 | 5990171 | 2106556 | 37.7636350362567 | -122.477191710239 | (37.7636350362567, -122.477191710239) | 1 | 8 | 3 | 56 | 35 | ||
144217 | 104308 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 652 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2013 12:00:00 AM | 3x3 | Permit Number 770798 | 5995451.6 | 2089938.7 | 37.7183129950309 | -122.457725404768 | (37.7183129950309, -122.457725404768) | 9 | 8 | 6 | 28861 | 24 | ||
23903 | 107340 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 300X EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773835 | 6006696 | 2098030 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | 2 | 7 | 7 | 28859 | 2 | |
54744 | 108430 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3025 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772569 | 6008074.01196 | 2103843.74387 | 37.7572102444691 | -122.415078608854 | (37.7572102444691, -122.415078608854) | 2 | 4 | 7 | 28859 | 19 |
177707 | 108436 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
107605 | 108437 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 200-212X Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772675 | 6006463.90093 | 2104927.47787 | 37.7600953129132 | -122.420723941274 | (37.7600953129132, -122.420723941274) | 2 | 4 | 7 | 28859 | 19 |
34823 | 108597 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
50919 | 108598 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 3103 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774586 | 6009067.61972 | 2100561.38658 | 37.7482534137383 | -122.411410431436 | (37.7482534137383, -122.411410431436) | 2 | 4 | 7 | 28859 | 2 |
182963 | 109449 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773467 | 6000399 | 2101283.9 | 37.7497472407948 | -122.441438023758 | (37.7497472407948, -122.441438023758) | 2 | 4 | 5 | 28862 | 22 |
18592 | 111041 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004870.73043 | 2118877.40927 | 37.7983084704282 | -122.427227648441 | (37.7983084704282, -122.427227648441) | 13 | 9 | 1 | 57 | 17 | |||
37811 | 111042 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004867.45543 | 2118890.27835 | 37.7983436204214 | -122.42723989811 | (37.7983436204214, -122.42723989811) | 13 | 9 | 1 | 57 | 17 | |||
182852 | 115200 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 716 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774286 | 6004934.3 | 2104152.6 | 37.7578813515637 | -122.425958943462 | (37.7578813515637, -122.425958943462) | 2 | 4 | 5 | 28862 | 3 | |||
34960 | 115370 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 481 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 773523 | 6007887 | 2096619.6 | 37.7373638523191 | -122.415214003631 | (37.7373638523191, -122.415214003631) | 2 | 7 | 7 | 28859 | 2 | ||
160348 | 117434 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 71 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775886 | 6000675.58728 | 2092024.5104 | 37.7243388786085 | -122.439817790169 | (37.7243388786085, -122.439817790169) | 9 | 7 | 6 | 28861 | 25 | ||
126321 | 118491 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981413.14873 | 2112317.48344 | 37.7789423808296 | -122.507909444403 | (37.7789423808296, -122.507909444403) | 11 | 6 | 2 | 55 | 26 | ||||
12121 | 11883 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017703.73127 | 2096843.30561 | 37.7385249167977 | -122.381288201801 | (37.7385249167977, -122.381288201801) | 10 | 3 | 8 | 58 | 1 | |||
69127 | 120436 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 235 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5988981.18981 | 2113759.01569 | 37.7833434210971 | -122.481834493116 | (37.7833434210971, -122.481834493116) | 11 | 6 | 2 | 55 | 26 | |||
132552 | 120537 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 300X EUGENIA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778832 | 6006696 | 2098030 | 37.7411694904711 | -122.419431881915 | (37.7411694904711, -122.419431881915) | 2 | 7 | 7 | 28859 | 2 | |
110100 | 12389 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1450 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
51549 | 123985 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 15 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993608.31847 | 2115347.64983 | 37.7879733773019 | -122.465942059673 | (37.7879733773019, -122.465942059673) | 11 | 6 | 1 | 54 | 11 | |||
101848 | 132211 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004866.10803 | 2118906.26122 | 37.7983874290946 | -122.427245699623 | (37.7983874290946, -122.427245699623) | 13 | 9 | 1 | 57 | 17 | |||
4937 | 132212 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2654 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000265.26964 | 2118199.18789 | 37.7961847294893 | -122.443115149071 | (37.7961847294893, -122.443115149071) | 13 | 9 | 1 | 57 | 17 | |||
69752 | 132213 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000167.6867 | 2118186.05064 | 37.7961430935947 | -122.443451860639 | (37.7961430935947, -122.443451860639) | 13 | 9 | 1 | 57 | 17 | |||
96009 | 132214 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000146.66842 | 2118183.0353 | 37.7961336156155 | -122.443524371168 | (37.7961336156155, -122.443524371168) | 13 | 9 | 1 | 57 | 17 | |||
23719 | 132215 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999237.1134 | 2118402.93591 | 37.7966854900001 | -122.446687431602 | (37.7966854900001, -122.446687431602) | 13 | 9 | 1 | 57 | 17 | |||
131234 | 132216 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999249.48209 | 2118404.06668 | 37.7966893013211 | -122.446644714701 | (37.7966893013211, -122.446644714701) | 13 | 9 | 1 | 57 | 17 | |||
14931 | 132217 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999261.04653 | 2118404.81755 | 37.7966920235835 | -122.446604753326 | (37.7966920235835, -122.446604753326) | 13 | 9 | 1 | 57 | 17 | |||
163748 | 132218 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999271.44145 | 2118406.78235 | 37.796698012158 | -122.446568926118 | (37.796698012158, -122.446568926118) | 13 | 9 | 1 | 57 | 17 | |||
72362 | 139831 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 925 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005175.7373 | 2112309.654 | 37.7802923037704 | -122.42570452289 | (37.7802923037704, -122.42570452289) | 7 | 9 | 11 | 28852 | 41 | |||
85920 | 139838 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 875 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005379.6259 | 2112337.1416 | 37.7803792970953 | -122.425001133553 | (37.7803792970953, -122.425001133553) | 7 | 9 | 11 | 28852 | 41 | |||
26805 | 139841 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 855 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005489.2243 | 2112352.6717 | 37.7804281291994 | -122.424623086227 | (37.7804281291994, -122.424623086227) | 7 | 9 | 11 | 28852 | 41 | |||
123609 | 139845 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 833 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005645.4131 | 2112373.0828 | 37.7804929927223 | -122.424084207294 | (37.7804929927223, -122.424084207294) | 7 | 9 | 11 | 28852 | 41 | |||
5052 | 139847 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 829 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005684.1962 | 2112380.729 | 37.7805161769301 | -122.423950581978 | (37.7805161769301, -122.423950581978) | 7 | 9 | 11 | 28852 | 41 | |||
92938 | 139937 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800 GOLDEN GATE AVE | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005368.7488 | 2112395.1092 | 37.7805378474705 | -122.425042888178 | (37.7805378474705, -122.425042888178) | 7 | 9 | 11 | 28852 | 41 | |||
67414 | 139945 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005081.184 | 2112356.1174 | 37.7804145374079 | -122.426034935273 | (37.7804145374079, -122.426034935273) | 7 | 9 | 11 | 28852 | 41 | |||
49344 | 139946 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005060.605 | 2112352.3265 | 37.7804029654412 | -122.426105857766 | (37.7804029654412, -122.426105857766) | 7 | 9 | 11 | 28852 | 41 | |||
180969 | 139955 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 900 GOLDEN GATE AVE | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004851.0238 | 2112323.6242 | 37.7803123083991 | -122.426828852854 | (37.7803123083991, -122.426828852854) | 7 | 9 | 11 | 28852 | 41 | |||
87307 | 141826 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1020 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004640.8141 | 2112287.0177 | 37.7801999083923 | -122.427553457164 | (37.7801999083923, -122.427553457164) | 7 | 9 | 11 | 29490 | 41 | |||
159942 | 141827 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1040 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004564.2329 | 2112276.6178 | 37.7801670209735 | -122.427817645466 | (37.7801670209735, -122.427817645466) | 7 | 9 | 11 | 29490 | 41 | |||
73390 | 14514 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 507 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5999077.3967 | 2111056.5759 | 37.7765051848822 | -122.446711235239 | (37.7765051848822, -122.446711235239) | 15 | 5 | 2 | 29492 | 16 | |||
157819 | 150468 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012105.23351 | 2104143.6419 | 37.7582594122512 | -122.401158068605 | (37.7582594122512, -122.401158068605) | 10 | 3 | 8 | 28856 | 29 | |
190411 | 150469 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 100 Southern Heights Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012042.59416 | 2104165.28662 | 37.7583153491828 | -122.401376225239 | (37.7583153491828, -122.401376225239) | 10 | 3 | 8 | 28856 | 29 | |
13489 | 160999 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 265 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6004550.61216 | 2090876.91947 | 37.7214076589281 | -122.426340700176 | (37.7214076589281, -122.426340700176) | 9 | 7 | 6 | 28861 | 5 | ||
613 | 161126 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001694.7774 | 2090903.55181 | 37.721318940793 | -122.436214417168 | (37.721318940793, -122.436214417168) | 9 | 7 | 6 | 28861 | 5 | ||
15217 | 161127 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001702.30852 | 2090917.36085 | 37.7213572852021 | -122.436189371961 | (37.7213572852021, -122.436189371961) | 9 | 7 | 6 | 28861 | 5 | ||
3506 | 161128 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001711.00806 | 2090931.14538 | 37.7213956286903 | -122.436160286079 | (37.7213956286903, -122.436160286079) | 9 | 7 | 6 | 28861 | 5 | ||
10399 | 161129 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 485 London St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001722.11588 | 2090948.37155 | 37.7214435589648 | -122.436123121581 | (37.7214435589648, -122.436123121581) | 9 | 7 | 6 | 28861 | 5 | ||
17374 | 163460 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.33981 | 2087649.24929 | 37.7120507463226 | -122.45611257216 | (37.7120507463226, -122.45611257216) | 9 | 8 | 6 | 28861 | 24 | |
19607 | 163461 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.30801 | 2087623.97935 | 37.7119813591246 | -122.456110856234 | (37.7119813591246, -122.456110856234) | 9 | 8 | 6 | 28861 | 24 | |
10091 | 163462 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995871.2375 | 2087597.30845 | 37.7119081803938 | -122.45610571662 | (37.7119081803938, -122.45610571662) | 9 | 8 | 6 | 28861 | 24 | |
9475 | 163463 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 109 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995872.36784 | 2087580.2575 | 37.7118614273349 | -122.456100577893 | (37.7118614273349, -122.456100577893) | 9 | 8 | 6 | 28861 | 24 | |
10960 | 166315 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008872.21502 | 2103120.32489 | 37.7552687230844 | -122.412266973836 | (37.7552687230844, -122.412266973836) | 2 | 4 | 7 | 28859 | 19 | |
16166 | 166316 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008870.16891 | 2103155.64589 | 37.7553655917605 | -122.412276546247 | (37.7553655917605, -122.412276546247) | 2 | 4 | 7 | 28859 | 19 | |
12003 | 166317 | Planning Code 138.1 required 2 | Pistacia chinensis :: Chinese Pistache 32 | 2600 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 10x4 | Permit Number 779829 | 6008865.69274 | 2103234.56357 | 37.755582030708 | -122.412297603862 | (37.755582030708, -122.412297603862) | 2 | 4 | 7 | 28859 | 19 | |
36402 | 16950 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 630 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003955.1515 | 2110112.5344 | 37.7741905079368 | -122.429770337641 | (37.7741905079368, -122.429770337641) | 7 | 9 | 11 | 29492 | 10 | |||
11621 | 171168 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 61 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004706.69577 | 2093156.0367 | 37.7276744353238 | -122.425963318556 | (37.7276744353238, -122.425963318556) | 9 | 7 | 6 | 28861 | 5 | |||
6345 | 175597 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 650 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6001092.21629 | 2090034.68248 | 37.7188989677059 | -122.438235084102 | (37.7188989677059, -122.438235084102) | 9 | 7 | 6 | 28861 | 5 | ||
165119 | 178355 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2 Moneta Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997930.01019 | 2088108.42362 | 37.7134295446025 | -122.449026847907 | (37.7134295446025, -122.449026847907) | 9 | 7 | 6 | 28861 | 25 | |||
83677 | 178356 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 700 Olmstead St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6009662.10656 | 2090649.30438 | 37.7210702863525 | -122.408655555513 | (37.7210702863525, -122.408655555513) | 9 | 3 | 7 | 309 | 28 | |||
136531 | 178357 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 700 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009625.93878 | 2090631.7553 | 37.7210200744845 | -122.408779340021 | (37.7210200744845, -122.408779340021) | 9 | 3 | 7 | 309 | 28 | |||
55259 | 178358 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 54 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004690.16722 | 2093211.84688 | 37.7278267435864 | -122.426024429306 | (37.7278267435864, -122.426024429306) | 9 | 7 | 6 | 28861 | 5 | |||
120408 | 178359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 235 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003629.76511 | 2092456.58351 | 37.7256929707372 | -122.429636417784 | (37.7256929707372, -122.429636417784) | 9 | 7 | 6 | 28861 | 5 | |||
98560 | 178360 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 114 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781343 | 6009991.86293 | 2095011.33058 | 37.7330659573247 | -122.40782310796 | (37.7330659573247, -122.40782310796) | 10 | 3 | 7 | 309 | 28 |
130450 | 194526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 15 | : Yard | Tree | Private 2 | 5 | 6014989.61274 | 2102184.78595 | 37.7530413020381 | -122.391045631074 | (37.7530413020381, -122.391045631074) | 10 | 3 | 8 | 28856 | 29 | ||||
144108 | 194527 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 16 | : Yard | Tree | Private 2 | 3 | 6014969.95823 | 2102191.83984 | 37.7530595798584 | -122.391114093749 | (37.7530595798584, -122.391114093749) | 10 | 3 | 8 | 28856 | 29 | ||||
125810 | 194528 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 21 | : Yard | Tree | Private 2 | 3 | 6014977.55524 | 2102273.87418 | 37.7532852503289 | -122.391093555018 | (37.7532852503289, -122.391093555018) | 10 | 3 | 8 | 28856 | 29 | ||||
181825 | 194529 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 23 | : Yard | Tree | Private 2 | 2 | 6014967.18541 | 2102296.35434 | 37.753346400626 | -122.391130987502 | (37.753346400626, -122.391130987502) | 10 | 3 | 8 | 28856 | 29 | ||||
26684 | 194530 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 616 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6012360.41946 | 2105070.75065 | 37.7608192812075 | -122.400340636111 | (37.7608192812075, -122.400340636111) | 10 | 3 | 8 | 28856 | 29 | |||
118535 | 194531 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2221 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011908.13677 | 2101346.92633 | 37.75056924647 | -122.401643151235 | (37.75056924647, -122.401643151235) | 10 | 3 | 8 | 28856 | 1 | |||
81814 | 194532 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010402.10466 | 2107886.85819 | 37.7684422757183 | -122.407312137446 | (37.7684422757183, -122.407312137446) | 8 | 4 | 8 | 28853 | 19 | |||
19586 | 194533 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010348.85424 | 2107885.73513 | 37.7684362115906 | -122.40749624758 | (37.7684362115906, -122.40749624758) | 8 | 4 | 8 | 28853 | 19 | |||
43559 | 194534 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 25 Lucy St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6014175.87087 | 2093939.45878 | 37.7303561623911 | -122.39328279268 | (37.7303561623911, -122.39328279268) | 10 | 3 | 8 | 58 | 1 | |||
52158 | 194535 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 360 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014325.43113 | 2111634.88834 | 37.7789523278141 | -122.394004006676 | (37.7789523278141, -122.394004006676) | 6 | 2 | 9 | 28856 | 34 | |||
127261 | 194536 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 150 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014975.61342 | 2110964.15152 | 37.7771467490639 | -122.391707837847 | (37.7771467490639, -122.391707837847) | 6 | 2 | 9 | 28856 | 20 | |||
75963 | 194537 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012568.21907 | 2107279.59323 | 37.7668958572755 | -122.399777047179 | (37.7668958572755, -122.399777047179) | 14 | 3 | 8 | 28856 | 20 | |||
191856 | 194538 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012547.84553 | 2107301.30971 | 37.7669543500844 | -122.399849041507 | (37.7669543500844, -122.399849041507) | 14 | 3 | 8 | 28856 | 20 | |||
73030 | 194539 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012519.55617 | 2107331.82323 | 37.767036556231 | -122.399949033536 | (37.767036556231, -122.399949033536) | 14 | 3 | 8 | 28856 | 20 | |||
68145 | 194540 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012505.10498 | 2107346.22269 | 37.7670752882293 | -122.400000029601 | (37.7670752882293, -122.400000029601) | 14 | 3 | 8 | 28856 | 20 | |||
121600 | 194541 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012465.16673 | 2107386.76068 | 37.7671843696864 | -122.40014101809 | (37.7671843696864, -122.40014101809) | 14 | 3 | 8 | 28856 | 20 | |||
125518 | 194542 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012450.21381 | 2107404.91238 | 37.7672333764343 | -122.400194013336 | (37.7672333764343, -122.400194013336) | 14 | 3 | 8 | 28856 | 20 | |||
7122 | 194543 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012559.7859 | 2107618.88108 | 37.7678269955571 | -122.399830043335 | (37.7678269955571, -122.399830043335) | 14 | 3 | 8 | 28856 | 20 | |||
21926 | 194544 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012545.36949 | 2107606.50724 | 37.7677922160651 | -122.399879039311 | (37.7677922160651, -122.399879039311) | 14 | 3 | 8 | 28856 | 20 | |||
89574 | 194545 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012495.5993 | 2107561.45835 | 37.7676657471131 | -122.400048025518 | (37.7676657471131, -122.400048025518) | 14 | 3 | 8 | 28856 | 20 | |||
119104 | 194546 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012481.42509 | 2107546.77644 | 37.7676246435913 | -122.40009602143 | (37.7676246435913, -122.40009602143) | 14 | 3 | 8 | 28856 | 20 | |||
114649 | 194547 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 590 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6017544.15385 | 2096613.95658 | 37.7378863594562 | -122.381824001685 | (37.7378863594562, -122.381824001685) | 10 | 3 | 8 | 58 | 1 | |||
40590 | 199686 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015608.757 | 2092907.6605 | 37.7276025523971 | -122.388257080086 | (37.7276025523971, -122.388257080086) | 10 | 3 | 8 | 58 | 1 | |||
171151 | 199687 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015600.4454 | 2092895.2979 | 37.7275681466115 | -122.388284951178 | (37.7275681466115, -122.388284951178) | 10 | 3 | 8 | 58 | 1 | |||
15836 | 199688 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2000 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015592.0163 | 2092881.2495 | 37.7275291054366 | -122.388313110838 | (37.7275291054366, -122.388313110838) | 10 | 3 | 8 | 58 | 1 | |||
188244 | 199695 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1350 Underwood Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 6015882.1777 | 2092801.0091 | 37.7273248550401 | -122.387304416847 | (37.7273248550401, -122.387304416847) | 10 | 3 | 8 | 58 | 1 | |||
118450 | 199989 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1054 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018046.698 | 2092242.698 | 37.7259114771391 | -122.379782821602 | (37.7259114771391, -122.379782821602) | 10 | 3 | 8 | 58 | 1 | |||
74150 | 199995 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1094 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6017857.178 | 2092387.3649 | 37.7262982485858 | -122.380448036499 | (37.7262982485858, -122.380448036499) | 10 | 3 | 8 | 58 | 1 | |||
30724 | 200624 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1382 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6016324.8756 | 2094912.2277 | 37.7331463494491 | -122.385921096754 | (37.7331463494491, -122.385921096754) | 10 | 3 | 8 | 58 | 1 | |||
6458 | 211310 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1645 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5993991.2178 | 2104316.50873 | 37.7577068768914 | -122.46381631408 | (37.7577068768914, -122.46381631408) | 1 | 5 | 4 | 56 | 12 | |||
191498 | 211311 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 652 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995443.13465 | 2089926.39084 | 37.7182787106718 | -122.457753775529 | (37.7182787106718, -122.457753775529) | 9 | 8 | 6 | 28861 | 24 | |||
126685 | 211312 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992605.95071 | 2099584.48851 | 37.7446340456409 | -122.468262856351 | (37.7446340456409, -122.468262856351) | 1 | 8 | 4 | 29491 | 40 | |||
13269 | 211313 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992606.24128 | 2099598.30232 | 37.7446719916245 | -122.468262856359 | (37.7446719916245, -122.468262856359) | 1 | 8 | 4 | 29491 | 40 | |||
2706 | 211314 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993864.84081 | 2102208.58731 | 37.7519117832189 | -122.464100354143 | (37.7519117832189, -122.464100354143) | 1 | 8 | 4 | 29491 | 12 | |||
25550 | 211315 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1950 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993849.45223 | 2102159.58974 | 37.7517763614982 | -122.464150012924 | (37.7517763614982, -122.464150012924) | 1 | 8 | 4 | 29491 | 12 | |||
98544 | 211316 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993952.85587 | 2102199.15235 | 37.7518909495221 | -122.463795303226 | (37.7518909495221, -122.463795303226) | 1 | 8 | 4 | 29491 | 40 | |||
16610 | 211317 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993928.12229 | 2102221.55917 | 37.7519510476114 | -122.463882461023 | (37.7519510476114, -122.463882461023) | 1 | 8 | 4 | 29491 | 12 |
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) );