trees
665 rows where qSpecies_id = 89 sorted by Location descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46336 | 125437 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.444069220022 | (37.8045448847905, -122.444069220022) | 13 | 9 | 1 | 57 | 17 | |||
183777 | 125442 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3719 Scott St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6000612.64349 | 2121133.322 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | 13 | 9 | 1 | 57 | 17 | |||
159536 | 125444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3676 Fillmore St | 3 | : | Tree | Private 2 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | 13 | 9 | 1 | 57 | 17 | |||
161911 | 41212 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691 | (37.804135222937, -122.43679910691) | 13 | 9 | 1 | 57 | 17 | |
64506 | 125523 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 6011207.16585 | 2120734.52957 | 37.8037639692824 | -122.405432414094 | (37.8037639692824, -122.405432414094) | 3 | 1 | 10 | 308 | 23 | |||
144847 | 125525 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | 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 | |||
105236 | 249818 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 7 | Front Yard : Yard | Tree | Private 2 | 24 | Width 0ft | 6010887.46579 | 2120660.30432 | 37.803542284602 | -122.406533525994 | (37.803542284602, -122.406533525994) | 3 | 1 | 10 | 308 | 23 | |||
106507 | 249823 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 5 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010881.14413 | 2120640.5408 | 37.8034876651725 | -122.406554008974 | (37.8034876651725, -122.406554008974) | 3 | 1 | 10 | 308 | 23 | |||
161804 | 249822 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 4 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6010893.58143 | 2120633.65684 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | 3 | 1 | 10 | 308 | 23 | |||
170059 | 125445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003103.29494 | 2120784.42 | 37.8034445139256 | -122.433479854917 | (37.8034445139256, -122.433479854917) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
54016 | 249820 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1690 Kearny St | 2 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6010902.80513 | 2120614.31353 | 37.8034168633488 | -122.406477200573 | (37.8034168633488, -122.406477200573) | 3 | 1 | 10 | 308 | 23 | |||
74610 | 125446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003103.60158 | 2120772.63456 | 37.8034121715947 | -122.433477951057 | (37.8034121715947, -122.433477951057) | 13 | 9 | 1 | 57 | 17 | |||
64715 | 125443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2298 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | 13 | 9 | 1 | 57 | 17 | |||
145970 | 125447 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3057 Franklin St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6005068.76254 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | 13 | 9 | 1 | 57 | 17 | |||
116562 | 125448 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3057 Franklin St | 2 | : | Tree | Private 2 | 5 | Width 2ft | 6005070.86935 | 2120497.70862 | 37.8027687129688 | -122.426650549882 | (37.8027687129688, -122.426650549882) | 13 | 9 | 1 | 57 | 17 | |||
113174 | 125497 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6006282.86688 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | 5 | 9 | 1 | 28858 | 32 | |||
194134 | 125498 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | 5 | 9 | 1 | 28858 | 32 | |||
97400 | 97940 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
144868 | 97942 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 491 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010516 | 2120277 | 37.8024690368502 | -122.407791962119 | (37.8024690368502, -122.407791962119) | 3 | 1 | 10 | 308 | 23 | |||||
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 | |||||
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 | |||||
73410 | 125496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6006063.84143 | 2120339.68716 | 37.8023909140602 | -122.423203116649 | (37.8023909140602, -122.423203116649) | 5 | 9 | 1 | 28858 | 32 | |||
87363 | 125495 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.8023826214287 | -122.423246597049 | (37.8023826214287, -122.423246597049) | 5 | 9 | 1 | 28858 | 32 | |||
121196 | 125494 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | 5 | 9 | 1 | 28858 | 32 | |||
51637 | 125493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006021.47381 | 2120333.65457 | 37.8023719590496 | -122.423349300554 | (37.8023719590496, -122.423349300554) | 5 | 9 | 1 | 28858 | 32 | |||
149402 | 125492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.423388283439 | (37.8023660361287, -122.423388283439) | 5 | 9 | 1 | 28858 | 32 | |||
34992 | 125491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005994.09185 | 2120329.47146 | 37.8023589278732 | -122.423443758146 | (37.8023589278732, -122.423443758146) | 5 | 9 | 1 | 28858 | 32 | |||
115971 | 66783 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 5 | Permit Number 30054 | 6005979.75561 | 2120327.60903 | 37.8023530049553 | -122.423493236148 | (37.8023530049553, -122.423493236148) | 5 | 9 | 1 | 28858 | 32 | |
128968 | 92753 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.78777 | 37.8021663758311 | -122.446615526285 | (37.8021663758311, -122.446615526285) | 13 | 9 | 1 | 57 | 17 | |
40160 | 125440 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.443425105788 | (37.8021484793247, -122.443425105788) | 13 | 9 | 1 | 57 | 17 | |||
82326 | 125441 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 2 | : | Tree | Private 2 | 4 | Width 2ft | 6000221.62171 | 2120363.59067 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | 13 | 9 | 1 | 57 | 17 | |||
14262 | 92752 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | 13 | 9 | 1 | 57 | 17 | |
31461 | 249983 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 226 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011603.53088 | 2120119.93244 | 37.8020985894405 | -122.404017485543 | (37.8020985894405, -122.404017485543) | 3 | 1 | 10 | 308 | 23 | |||
84618 | 125504 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6007489.69173 | 2120199.07294 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
1616 | 249984 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 226 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011604.5053 | 2120111.99388 | 37.8020768465317 | -122.404013554575 | (37.8020768465317, -122.404013554575) | 3 | 1 | 10 | 308 | 23 | |||
64447 | 125502 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6007468.42884 | 2120195.87716 | 37.8020752142594 | -122.418332338987 | (37.8020752142594, -122.418332338987) | 5 | 1 | 1 | 28858 | 32 | |||
67291 | 249985 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011591.62105 | 2120106.88257 | 37.802062092258 | -122.404057780558 | (37.802062092258, -122.404057780558) | 3 | 1 | 10 | 308 | 23 | |||
133816 | 249986 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011589.33259 | 2120106.08083 | 37.802059763014 | -122.404065643309 | (37.802059763014, -122.404065643309) | 3 | 1 | 10 | 308 | 23 | |||
125066 | 249987 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011587.32256 | 2120104.99043 | 37.802056656736 | -122.404072522227 | (37.802056656736, -122.404072522227) | 3 | 1 | 10 | 308 | 23 | |||
34762 | 249988 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011583.89861 | 2120104.21147 | 37.8020543265962 | -122.404084315938 | (37.8020543265962, -122.404084315938) | 3 | 1 | 10 | 308 | 23 | |||
64944 | 249989 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 5 | Front Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011581.89407 | 2120103.40396 | 37.8020519973709 | -122.404091195777 | (37.8020519973709, -122.404091195777) | 3 | 1 | 10 | 308 | 23 | |||
116144 | 249990 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011580.18498 | 2120103.15607 | 37.802051221233 | -122.404097092619 | (37.802051221233, -122.404097092619) | 3 | 1 | 10 | 308 | 23 | |||
150432 | 249991 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 228 Filbert St | 7 | Front Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011578.47013 | 2120102.62532 | 37.8020496681084 | -122.404102989475 | (37.8020496681084, -122.404102989475) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
127021 | 249949 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 303 Filbert St | 6 | Side Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011354.62644 | 2120055.4997 | 37.801907763195 | -122.404874279527 | (37.801907763195, -122.404874279527) | 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 | |||
70085 | 249947 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 305 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011342.9125 | 2120054.18632 | 37.8019035022036 | -122.40491472295 | (37.8019035022036, -122.40491472295) | 3 | 1 | 10 | 308 | 23 | |||
121322 | 249948 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 305 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011338.9869 | 2120052.71472 | 37.8018992421182 | -122.40492820377 | (37.8018992421182, -122.40492820377) | 3 | 1 | 10 | 308 | 23 | |||
54339 | 249939 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 331 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | Width 0ft | 6011281.55151 | 2120038.154 | 37.8018560512652 | -122.40512593233 | (37.8018560512652, -122.40512593233) | 3 | 1 | 10 | 308 | 23 | |||
88253 | 125522 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | 5 | 1 | 1 | 308 | 32 | |||
23673 | 125501 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6007553.74728 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | 5 | 1 | 1 | 28858 | 32 | |||
35518 | 125505 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 45 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6007613.99229 | 2119386.63886 | 37.7998614422209 | -122.41777122496 | (37.7998614422209, -122.41777122496) | 5 | 1 | 1 | 28858 | 32 | ||||
1264 | 125499 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007355.47144 | 2119286.08851 | 37.7995708047014 | -122.418658671469 | (37.7995708047014, -122.418658671469) | 5 | 1 | 1 | 28858 | 32 | ||||
6257 | 125500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.418954327193 | (37.7995302219096, -122.418954327193) | 5 | 1 | 1 | 28858 | 32 | ||||
80070 | 107943 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 44x MacOndray Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008438.53642 | 2119159.8208 | 37.7992850226339 | -122.41490192268 | (37.7992850226339, -122.41490192268) | 5 | 1 | 10 | 308 | 32 | |||
64387 | 104356 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004967.00865 | 2119154.82266 | 37.7990756208885 | -122.426914264396 | (37.7990756208885, -122.426914264396) | 13 | 9 | 1 | 57 | 17 | ||
36154 | 64967 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004948.17442 | 2119151.63157 | 37.7990657940144 | -122.426979209822 | (37.7990657940144, -122.426979209822) | 13 | 9 | 1 | 57 | 17 | |
51514 | 125509 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6008633.29576 | 2119030.27082 | 37.7989402522368 | -122.414218814773 | (37.7989402522368, -122.414218814773) | 5 | 1 | 10 | 308 | 32 | |||
71615 | 125510 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008630.57528 | 2119029.65242 | 37.7989384014533 | -122.414228184789 | (37.7989384014533, -122.414228184789) | 5 | 1 | 10 | 308 | 32 | |||
55814 | 125511 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008625.76186 | 2119029.22421 | 37.7989369553212 | -122.414244810558 | (37.7989369553212, -122.414244810558) | 5 | 1 | 10 | 308 | 32 | |||
64779 | 125512 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | 5 | 1 | 10 | 308 | 32 | |||
24813 | 125514 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008590.31929 | 2119027.39259 | 37.7989299352366 | -122.414367324317 | (37.7989299352366, -122.414367324317) | 5 | 1 | 10 | 308 | 32 | |||
72741 | 125513 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008593.29487 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | 5 | 1 | 10 | 308 | 32 | |||
159811 | 125516 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008584.50737 | 2119027.0667 | 37.7989287139392 | -122.414387412476 | (37.7989287139392, -122.414387412476) | 5 | 1 | 10 | 308 | 32 | |||
77941 | 125515 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | 5 | 1 | 10 | 308 | 32 | |||
95831 | 125519 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008571.89831 | 2119026.74658 | 37.7989271266439 | -122.414431021472 | (37.7989271266439, -122.414431021472) | 5 | 1 | 10 | 308 | 32 | |||
146670 | 125518 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008573.08581 | 2119026.43144 | 37.7989263280573 | -122.414426890005 | (37.7989263280573, -122.414426890005) | 5 | 1 | 10 | 308 | 32 | |||
50122 | 125517 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008575.41519 | 2119026.37821 | 37.7989263127569 | -122.414418825785 | (37.7989263127569, -122.414418825785) | 5 | 1 | 10 | 308 | 32 | |||
24223 | 125520 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.7989262722777 | -122.414435828363 | (37.7989262722777, -122.414435828363) | 5 | 1 | 10 | 308 | 32 | |||
10180 | 125521 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 900 Green St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008568.41134 | 2119026.06198 | 37.7989250510158 | -122.414443039112 | (37.7989250510158, -122.414443039112) | 5 | 1 | 10 | 308 | 32 | |||
129795 | 125436 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3157 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001892.57083 | 2119015.7946 | 37.798519569189 | -122.437542875929 | (37.798519569189, -122.437542875929) | 13 | 9 | 1 | 57 | 17 | |||
164297 | 34667 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3065 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38339 | 6003364.40129 | 2118901.01049 | 37.7982879721724 | -122.432441684758 | (37.7982879721724, -122.432441684758) | 13 | 9 | 1 | 57 | 17 | ||
80095 | 125508 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6008930.42147 | 2118571.4914 | 37.7976972425915 | -122.413158199313 | (37.7976972425915, -122.413158199313) | 3 | 1 | 10 | 308 | 21 | |||
3711 | 125506 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | 3 | 1 | 10 | 308 | 21 | |||
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 | |||
125349 | 113957 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1644 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 1 | 3x3 | 6008801.14182 | 2118530.39041 | 37.7975771309301 | -122.413602635263 | (37.7975771309301, -122.413602635263) | 3 | 1 | 10 | 308 | 21 | ||
141457 | 33132 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) | 13 | 9 | 1 | 57 | 17 |
162245 | 125461 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1845 Green St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6004195.45414 | 2118342.02418 | 37.7968002290978 | -122.429526106064 | (37.7968002290978, -122.429526106064) | 13 | 9 | 1 | 57 | 17 | |||
51653 | 125485 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 3 | Median : Yard | Tree | DPW 1 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | 5 | 1 | 10 | 28858 | 32 | ||||
169681 | 125486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 4 | Median : Yard | Tree | DPW 1 | 6 | 6007645.27033 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | 5 | 1 | 10 | 28858 | 32 | ||||
142938 | 125484 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1237x Robert C Levy Tunl | 1 | Median : Yard | Tree | DPW 1 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.417561030927 | (37.796373807471, -122.417561030927) | 5 | 1 | 10 | 28858 | 32 | ||||
44498 | 32128 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Ross Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35490 | 6010568.1937078 | 2117713.19841403 | 37.7954323857446 | -122.407430491589 | (37.7954323857446, -122.407430491589) | 3 | 1 | 10 | 28857 | 4 | ||
51778 | 102757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002051.95846 | 2117801.73169 | 37.7951951298959 | -122.436904386043 | (37.7951951298959, -122.436904386043) | 13 | 9 | 1 | 57 | 27 | |||
90579 | 125457 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.7951716162211 | -122.436898435221 | (37.7951716162211, -122.436898435221) | 13 | 9 | 1 | 57 | 27 | |||
90963 | 32134 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 842 Washington St | 2 | 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 | ||
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 | ||
55080 | 32135 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 858 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | 3 | 1 | 10 | 28857 | 4 | ||
129704 | 32136 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 858 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | 3 | 1 | 10 | 28857 | 4 | ||
21355 | 125539 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 31 Spofford St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6010570.5264 | 2117382.56278 | 37.7945246709392 | -122.407399099212 | (37.7945246709392, -122.407399099212) | 3 | 1 | 10 | 28857 | 4 | |||
143706 | 125451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001095.19419 | 2117566.78183 | 37.7944955940578 | -122.440198075675 | (37.7944955940578, -122.440198075675) | 13 | 9 | 1 | 57 | 27 | |||
174368 | 32129 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | 3 | 1 | 10 | 28857 | 4 | ||
132440 | 125450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.7940985496517 | -122.44069290605 | (37.7940985496517, -122.44069290605) | 13 | 9 | 1 | 57 | 27 | |||
182415 | 125459 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002302.24315 | 2117372.64149 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | 13 | 9 | 1 | 29490 | 27 | |||
76702 | 125458 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2371 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002284.26434 | 2117368.32549 | 37.7940183094364 | -122.436069543591 | (37.7940183094364, -122.436069543591) | 13 | 9 | 1 | 29490 | 27 | |||
97812 | 125456 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.7939566501408 | -122.436691221543 | (37.7939566501408, -122.436691221543) | 13 | 9 | 1 | 29490 | 27 | |||
130988 | 125455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002099.50591 | 2117347.8348 | 37.7939515491883 | -122.436707358076 | (37.7939515491883, -122.436707358076) | 13 | 9 | 1 | 29490 | 27 | |||
70682 | 125454 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2401 Broadway | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002093.86703 | 2117345.78422 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) | 13 | 9 | 1 | 29490 | 27 |
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) );