Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188719 | 188719 | 53084 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 737 8TH & 9TH Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2006 12:00:00 AM | 2 | Permit Number 49051 | 6009184.03674 | 2110393.9636 | 37.7752579542298 | -122.411702510768 | (37.7752579542298, -122.411702510768) | ||
| 188602 | 188602 | 204669 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997556.3797699995 | 2095278.95948 | 37.7330967797945 | -122.45083494657 | (37.7330967797945, -122.45083494657) | |||
| 187841 | 187841 | 221327 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 936 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010186.18174 | 2103764.32859 | 37.757110656958204 | -122.407768272711 | (37.7571106569582, -122.407768272711) | |||
| 187540 | 187540 | 36806 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 4 | Permit Number 39531 | 6014725.6758 | 2091211.782 | 37.722897037873395 | -122.391191434704 | (37.7228970378734, -122.391191434704) | |
| 187499 | 187499 | 204621 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1481 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993335.30038 | 2105432.94132 | 37.7607344904344 | -122.466165857685 | (37.7607344904344, -122.466165857685) | |||
| 187433 | 187433 | 139381 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1470 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000719.1776 | 2113696.7015 | 37.7838479440673 | -122.44122133052299 | (37.7838479440673, -122.441221330523) | |||
| 187374 | 187374 | 36805 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 10 | Permit Number 39531 | 6014737.8573 | 2091203.2549 | 37.7228743001584 | -122.39114872971001 | (37.7228743001584, -122.39114872971) | |
| 187337 | 187337 | 204659 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Gaviota Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998394.00648 | 2097223.48858 | 37.738483907702204 | -122.448079021847 | (37.7384839077022, -122.448079021847) | |||
| 187063 | 187063 | 204661 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 218 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001436.20899 | 2095068.9547299999 | 37.7327414936084 | -122.437406337246 | (37.7327414936084, -122.437406337246) | |||
| 186252 | 186252 | 188346 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1716 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.39222777999399 | (37.7329022519179, -122.392227779994) | |||
| 185934 | 185934 | 188326 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012985.7528099995 | 2102888.64274 | 37.7548625406828 | -122.39802478743799 | (37.7548625406828, -122.398024787438) | |||
| 185920 | 185920 | 204625 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5992281.41366 | 2095382.3817200002 | 37.733077373320896 | -122.469079268988 | (37.7330773733209, -122.469079268988) | |||
| 185696 | 185696 | 175790 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 79 Colby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6008193.10922 | 2093597.69816 | 37.7290835632519 | -122.413941929669 | (37.7290835632519, -122.413941929669) | |||
| 185574 | 185574 | 188315 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 850 Carolina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012418.401980001 | 2104012.51765 | 37.757916839799705 | -122.400065779927 | (37.7579168397997, -122.400065779927) | |||
| 185091 | 185091 | 221324 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006261.00789 | 2104075.99736 | 37.7577459083505 | -122.421365183881 | (37.7577459083505, -122.421365183881) | |||
| 185052 | 185052 | 32483 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 10 | Permit Number 36991 | 6001817.389140001 | 2106232.68155 | 37.763416104203 | -122.436887416735 | (37.763416104203, -122.436887416735) | |
| 184845 | 184845 | 222593 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 375 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003504.52441 | 2108607.38133 | 37.7700321988694 | -122.43122167795299 | (37.7700321988694, -122.431221677953) | |||
| 184805 | 184805 | 95843 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 30 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767866 | 6009338.07268 | 2109475.65364 | 37.7727451297231 | -122.411104783558 | (37.7727451297231, -122.411104783558) |
| 184588 | 184588 | 175788 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008132.91971 | 2093497.9491400002 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | |||
| 184403 | 184403 | 222584 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 374 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001130.451330001 | 2104105.9564799997 | 37.7575375705211 | -122.439110874466 | (37.7575375705211, -122.439110874466) | |||
| 183394 | 183394 | 69157 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1259 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 8 | Permit Number 33193 | 5983030.0636 | 2106498.5077 | 37.7630602867444 | -122.501885316454 | (37.7630602867444, -122.501885316454) | |
| 183090 | 183090 | 47228 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45171 | 6011142.396240001 | 2091994.05057 | 37.724845479317004 | -122.403633167442 | (37.724845479317, -122.403633167442) | |
| 182888 | 182888 | 221350 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008608.79456 | 2102405.13937 | 37.753290200197895 | -122.413127394812 | (37.7532902001979, -122.413127394812) | |||
| 182698 | 182698 | 108374 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 637 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773812 | 6002670.30203 | 2089919.45736 | 37.718672213540295 | -122.432772041698 | (37.7186722135403, -122.432772041698) | |
| 182374 | 182374 | 188342 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2335 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 21 | Width 2ft | 6013082.28487 | 2096418.14951 | 37.7371013178729 | -122.397237243906 | (37.7371013178729, -122.397237243906) | |||
| 181876 | 181876 | 204665 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 368 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999628.00963 | 2094984.6303599998 | 37.732406994366606 | -122.443651657603 | (37.7324069943666, -122.443651657603) | ||||
| 181555 | 181555 | 204650 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 254 Howth St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5997292.004269999 | 2090577.4247599998 | 37.720172339354704 | -122.451409977591 | (37.7201723393547, -122.451409977591) | |||
| 181552 | 181552 | 43891 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009112.33188 | 2110593.08814 | 37.7758006806963 | -122.41196462987499 | (37.7758006806963, -122.411964629875) | ||
| 181394 | 181394 | 125880 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Emerson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5998726.98974 | 2113474.62388 | 37.783124495049 | -122.448097535281 | (37.783124495049, -122.448097535281) | |||
| 181339 | 181339 | 124077 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 701 Funston Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991933.739630001 | 2110279.93645 | 37.7739620806591 | -122.471366355942 | (37.7739620806591, -122.471366355942) | |||
| 180920 | 180920 | 222575 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 384 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003870.03255 | 2102162.8697200003 | 37.752357817273605 | -122.429497729752 | (37.7523578172736, -122.429497729752) | |||
| 180781 | 180781 | 188349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1764 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014694.72418 | 2096821.3256 | 37.738297993561396 | -122.391690447682 | (37.7382979935614, -122.391690447682) | |||
| 180711 | 180711 | 188316 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.40005818423799 | (37.7578394396596, -122.400058184238) | |||
| 180450 | 180450 | 218271 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1456 Portola Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 5992773.33281 | 2097243.56743 | 37.738216134576795 | -122.467513887457 | (37.7382161345768, -122.467513887457) | |||
| 180340 | 180340 | 139382 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1480 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000715.5797 | 2113708.6945 | 37.7838806688155 | -122.441234638662 | (37.7838806688155, -122.441234638662) | |||
| 180337 | 180337 | 181742 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1219 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986119.9697 | 2106920.2395 | 37.7643992701936 | -122.491229569586 | (37.7643992701936, -122.491229569586) | |||
| 180214 | 180214 | 175773 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5990089.9017900005 | 2089410.48117 | 37.716553162587296 | -122.476219779021 | (37.7165531625873, -122.476219779021) | ||||
| 179966 | 179966 | 188324 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | |||
| 179938 | 179938 | 221344 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 116 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6008115.05984 | 2098024.5819 | 37.74123443831 | -122.414524882834 | (37.74123443831, -122.414524882834) | |||
| 179896 | 179896 | 56330 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2526 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1973 12:00:00 AM | 8 | Permit Number 12466 | 5987579.5629 | 2113304.9613200002 | 37.7820151066388 | -122.48665015476801 | (37.7820151066388, -122.486650154768) | ||
| 179663 | 179663 | 222506 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008600.17028 | 2103215.25622 | 37.7555141138929 | -122.413214501368 | (37.7555141138929, -122.413214501368) | |||
| 179630 | 179630 | 141961 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 861 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004842.0409 | 2111803.9569 | 37.7788849220533 | -122.426822909349 | (37.7788849220533, -122.426822909349) | |||
| 179570 | 179570 | 47485 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 165 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 7 | Permit Number 45478 | 6001374.27527 | 2093423.0179299999 | 37.7282186079017 | -122.43750263124399 | (37.7282186079017, -122.437502631244) | |
| 179145 | 179145 | 221345 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 152 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008640.31836 | 2097829.07218 | 37.740727106470004 | -122.41269490094801 | (37.74072710647, -122.412694900948) | |||
| 178908 | 178908 | 204632 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998393.17334 | 2094370.1114700001 | 37.7306491651244 | -122.447876531394 | (37.7306491651244, -122.447876531394) | |||
| 178155 | 178155 | 71997 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 362 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1989 12:00:00 AM | 6 | 5989369.28583 | 2112922.15861 | 37.7810682079879 | -122.48043057365 | (37.7810682079879, -122.48043057365) | ||
| 177802 | 177802 | 222564 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 160 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007476.41433 | 2100201.5835700002 | 37.747176098992796 | -122.41688730020701 | (37.7471760989928, -122.416887300207) | |||
| 177655 | 177655 | 175760 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 885 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011559.50494 | 2090784.62511 | 37.72154793606661 | -122.402106275984 | (37.7215479360666, -122.402106275984) | |||
| 177509 | 177509 | 181743 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1219 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986121.7407 | 2106913.1555 | 37.7643799229814 | -122.491222922878 | (37.7643799229814, -122.491222922878) | |||
| 177360 | 177360 | 95997 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 56 Neptune St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767648 | 6013070.55126 | 2094035.71681 | 37.730558997287396 | -122.39711080912501 | (37.7305589972874, -122.397110809125) |
| 177203 | 177203 | 175759 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012872.74847 | 2087577.73375 | 37.7128156646891 | -122.397341941199 | (37.7128156646891, -122.397341941199) | ||||
| 176811 | 176811 | 222500 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Albion St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005885.57234 | 2106325.1444099997 | 37.763900363939904 | -122.42282343817301 | (37.7639003639399, -122.422823438173) | |||
| 176762 | 176762 | 175785 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006201.21806 | 2093598.82119 | 37.7289745752989 | -122.420828147413 | (37.7289745752989, -122.420828147413) | |||
| 176616 | 176616 | 112176 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 607 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 5986882.73557 | 2111785.73395 | 37.7778030939685 | -122.48894910976601 | (37.7778030939685, -122.488949109766) | |||
| 176335 | 176335 | 183924 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2118 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5988539.4126 | 2100905.5456 | 37.7480256114084 | -122.482420751779 | (37.7480256114084, -122.482420751779) | |||
| 176253 | 176253 | 56136 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 755 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 17 | Permit Number 12240 | 6012456.10249 | 2104419.18715 | 37.7590355667492 | -122.3999639524 | (37.7590355667492, -122.3999639524) | ||
| 176001 | 176001 | 175793 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009507.12766 | 2093386.74095 | 37.7285780309381 | -122.409384362505 | (37.7285780309381, -122.409384362505) | |||
| 175761 | 175761 | 204654 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 222 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.46886596240299 | (37.7165410523041, -122.468865962403) | |||
| 175753 | 175753 | 204641 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995679.43604 | 2091904.4278 | 37.7237235031239 | -122.45707998907601 | (37.7237235031239, -122.457079989076) | |||
| 175592 | 175592 | 125889 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.42257363436501 | (37.781778500422, -122.422573634365) | |||
| 175531 | 175531 | 188286 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6010191.871780001 | 2110704.80693 | 37.776167942238295 | -122.408238092013 | (37.7761679422383, -122.408238092013) | |||
| 175431 | 175431 | 204612 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992412.91605 | 2102688.13741 | 37.7531447159591 | -122.469156169131 | (37.7531447159591, -122.469156169131) | |||
| 175317 | 175317 | 188295 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 3 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6008148.21893 | 2108881.79172 | 37.771047726812604 | -122.41517858743799 | (37.7710477268126, -122.415178587438) | |||
| 175314 | 175314 | 222507 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1266 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6010033.6534 | 2101840.39608 | 37.7518194273238 | -122.40816009111099 | (37.7518194273238, -122.408160091111) | |||
| 175309 | 175309 | 141965 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 803 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004856.9254 | 2111690.3911 | 37.7785739398403 | -122.426763328248 | (37.7785739398403, -122.426763328248) | |||
| 175230 | 175230 | 181661 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2706 Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5987293.6389 | 2106455.5367 | 37.7631918321241 | -122.48713609337601 | (37.7631918321241, -122.487136093376) | |||
| 175136 | 175136 | 222559 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 30 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007511.95053 | 2099199.57172 | 37.7444267977493 | -122.416693445056 | (37.7444267977493, -122.416693445056) | |||
| 175106 | 175106 | 222543 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 186 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004445.20895 | 2097256.60692 | 37.738918898988295 | -122.427159238823 | (37.7389188989883, -122.427159238823) | |||
| 175059 | 175059 | 204610 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1410 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990554.31015 | 2105766.55939 | 37.7614896754309 | -122.47580832029499 | (37.7614896754309, -122.475808320295) | |||
| 174688 | 174688 | 222578 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002709.15868 | 2104802.31344 | 37.759539303105505 | -122.433700841745 | (37.7595393031055, -122.433700841745) | |||
| 174395 | 174395 | 188293 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 5ft | 6008175.899180001 | 2108871.2472900003 | 37.771020329842294 | -122.415082093787 | (37.7710203298423, -122.415082093787) | |||
| 174190 | 174190 | 56722 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1560 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1974 12:00:00 AM | 9 | Permit Number 13995 | 6015605.7227 | 2095794.747 | 37.7355297446147 | -122.388469000899 | (37.7355297446147, -122.388469000899) | ||
| 174106 | 174106 | 47486 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 165 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | 10 | Permit Number 45383 | 6001387.26681 | 2093436.23595 | 37.7282556401779 | -122.437458665212 | (37.7282556401779, -122.437458665212) | ||
| 173962 | 173962 | 123230 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 785 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993487.30033 | 2110174.28885 | 37.7737617473343 | -122.465984694601 | (37.7737617473343, -122.465984694601) | |||
| 173961 | 173961 | 222547 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 615 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007991.011030001 | 2096013.8629400001 | 37.7357064756744 | -122.414811530923 | (37.7357064756744, -122.414811530923) | |||
| 173808 | 173808 | 204662 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000779.52136 | 2095089.88794 | 37.7327616159437 | -122.439678165028 | (37.7327616159437, -122.439678165028) | |||
| 173464 | 173464 | 34932 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2770 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 5 | Permit Number 38524 | 6000272.2691 | 2114453.3621 | 37.785900071213604 | -122.442821815392 | (37.7859000712136, -122.442821815392) | ||
| 173434 | 173434 | 47219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | |
| 173337 | 173337 | 139383 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000714.3804 | 2113723.086 | 37.7839201158586 | -122.441239820711 | (37.7839201158586, -122.441239820711) | |||
| 173059 | 173059 | 221331 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 38 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010755.04761 | 2100475.47625 | 37.7481120234562 | -122.40556927472 | (37.7481120234562, -122.40556927472) | |||
| 172887 | 172887 | 221363 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001383.2027 | 2099881.79885 | 37.745953424815504 | -122.43793420150699 | (37.7459534248155, -122.437934201507) | |||
| 172522 | 172522 | 204657 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200 Mesa Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993588.18999 | 2100755.25284 | 37.7479053493615 | -122.46495150490601 | (37.7479053493615, -122.464951504906) | |||
| 172093 | 172093 | 188352 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017123.5169400005 | 2095558.35639 | 37.7349646554818 | -122.383204909781 | (37.7349646554818, -122.383204909781) | |||
| 172086 | 172086 | 125890 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 8 Sharp Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007493.35542 | 2119123.01732 | 37.799130814105794 | -122.41816997447799 | (37.7991308141058, -122.418169974478) | |||
| 171701 | 171701 | 175770 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | ||||
| 171430 | 171430 | 30366 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694005 | -122.397947987108 | (37.756469231694, -122.397947987108) | |
| 170503 | 170503 | 204618 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1379 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994241.53027 | 2106136.0721 | 37.7627173480462 | -122.463082656152 | (37.7627173480462, -122.463082656152) | |||
| 170117 | 170117 | 204631 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998374.865180001 | 2094370.4925900002 | 37.7306491651061 | -122.447939852652 | (37.7306491651061, -122.447939852652) | |||
| 170092 | 170092 | 43890 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.77583951252829 | -122.41192485917 | (37.7758395125283, -122.41192485917) | ||
| 169971 | 169971 | 184438 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2118 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982650.6525 | 2100679.8359 | 37.7470615561433 | -122.50276680933399 | (37.7470615561433, -122.502766809334) | |||
| 169960 | 169960 | 188332 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013443.0879999995 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | |||
| 169855 | 169855 | 30511 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 440 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 7 | Permit Number 34524 | 6010611.16196 | 2106233.9432099997 | 37.763915445554105 | -122.40647253668699 | (37.7639154455541, -122.406472536687) | |
| 169508 | 169508 | 204622 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1518 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993700.04012 | 2105141.70568 | 37.7599558699739 | -122.46488324546499 | (37.7599558699739, -122.464883245465) | |||
| 169372 | 169372 | 35219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 896 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | 7 | Permit Number 38722 | 6011641.6488 | 2112229.3585 | 37.7804350816614 | -122.403330167353 | (37.7804350816614, -122.403330167353) | ||
| 169060 | 169060 | 40030 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1637 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 3 | Permit Number 41272 | 6014878.683680001 | 2095916.71611 | 37.735824330914 | -122.390991193288 | (37.735824330914, -122.390991193288) | |
| 168991 | 168991 | 222590 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4486 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999473.95393 | 2105750.34682 | 37.7619582635881 | -122.444957897684 | (37.7619582635881, -122.444957897684) | |||
| 168676 | 168676 | 185068 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989159.6219 | 2096046.6038 | 37.7347202832405 | -122.47992059791001 | (37.7347202832405, -122.47992059791) | |||
| 168361 | 168361 | 123817 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1925 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992665.27685 | 2112027.3966200002 | 37.7788024241016 | -122.468963063439 | (37.7788024241016, -122.468963063439) | |||
| 167932 | 167932 | 221364 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1243 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001375.81776 | 2100058.24789 | 37.7464374920934 | -122.437972374152 | (37.7464374920934, -122.437972374152) | |||
| 167487 | 167487 | 181677 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2704 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987307.2214 | 2106457.8989 | 37.7631991100618 | -122.48708929014799 | (37.7631991100618, -122.487089290148) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");