Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128840 | 128840 | 94065 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 5 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 105829 | 105829 | 94064 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 4 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 145528 | 145528 | 94063 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 3 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 142740 | 142740 | 94062 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 121161 | 121161 | 94061 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 1 on Craut. | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
| 75794 | 75794 | 54149 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 34 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 22 | Permit Number 9884 | 6013977.76426 | 2095493.9516 | 37.7346134738323 | -122.394076462386 | (37.7346134738323, -122.394076462386) | ||
| 166688 | 166688 | 54138 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2460 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 12 | Permit Number 9871 | 6001817.46051 | 2117723.34964 | 37.794966582505204 | -122.43771016780899 | (37.7949665825052, -122.437710167809) | ||
| 140075 | 140075 | 53958 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 198 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | Permit Number 9673 | 6009460.95133411 | 2095046.30574205 | 37.733132255152505 | -122.40966108533001 | (37.7331322551525, -122.40966108533) | |||
| 54445 | 54445 | 53953 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 166 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 7 | Permit Number 9668 | 6009649.77155 | 2095111.3186599999 | 37.7333213458895 | -122.40901286606501 | (37.7333213458895, -122.409012866065) | ||
| 41822 | 41822 | 53952 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 162 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | 11 | Permit Number 9667 | 6009674.27519 | 2095120.19458 | 37.7333470898892 | -122.408928775863 | (37.7333470898892, -122.408928775863) | ||
| 150206 | 150206 | 53793 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 258 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1972 12:00:00 AM | 5 | Permit Number 9485 | 5987461.74395 | 2114234.65378 | 37.784560908121 | -122.487126051666 | (37.784560908121, -122.487126051666) | ||
| 130645 | 130645 | 53732 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 145 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9411 | 6012636.58641 | 2095202.58654 | 37.7337388121015 | -122.398692955821 | (37.7337388121015, -122.398692955821) | |
| 171964 | 171964 | 53731 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 137 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9410 | 6012616.20175 | 2095211.8932 | 37.73376323049521 | -122.398764085002 | (37.7337632304952, -122.398764085002) | |
| 152218 | 152218 | 53730 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 131 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9409 | 6012588.702330001 | 2095226.85555 | 37.733802781761 | -122.39886020903799 | (37.733802781761, -122.398860209038) | |
| 40433 | 40433 | 53729 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 125 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 12 | Permit Number 9408 | 6012570.8653 | 2095236.57105 | 37.7338284646029 | -122.39892255904199 | (37.7338284646029, -122.398922559042) | ||
| 79126 | 79126 | 53727 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9406 | 6012545.2759300005 | 2095206.78524 | 37.733745253033796 | -122.399008939832 | (37.7337452530338, -122.399008939832) | |
| 4369 | 4369 | 222216 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | ||
| 1503 | 1503 | 220995 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 610 Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001157.49823 | 2100904.8155400003 | 37.748749547471206 | -122.438787950406 | (37.7487495474712, -122.438787950406) | |
| 63 | 63 | 222541 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Newburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | Permit Number 779491 | 6002580.9472199995 | 2099999.66602 | 37.7463450993615 | -122.433800991143 | (37.7463450993615, -122.433800991143) | ||
| 13667 | 13667 | 109904 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 224 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | |
| 1994 | 1994 | 42166 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 354 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011846.02554 | 2111882.36991 | 37.77949374398221 | -122.402598720465 | (37.7794937439822, -122.402598720465) | ||
| 2014 | 2014 | 42165 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 354 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011856.41574 | 2111871.95313 | 37.7794657219919 | -122.40256204342501 | (37.7794657219919, -122.402562043425) | ||
| 81 | 81 | 221366 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778991 | 6000992.93047 | 2101385.53728 | 37.750060130381605 | -122.439391477336 | (37.7500601303816, -122.439391477336) | |
| 12766 | 12766 | 31651 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.50480501648701 | (37.736233320022, -122.504805016487) | |
| 107009 | 107009 | 56162 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 547 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 778533 | 5990919.363 | 2111652.3047 | 37.7776714970248 | -122.474975416646 | (37.7776714970248, -122.474975416646) | ||
| 167533 | 167533 | 116687 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777961 | 6002117.845 | 2092646.4352900002 | 37.7261285348836 | -122.43487657130301 | (37.7261285348836, -122.434876571303) | ||
| 127619 | 127619 | 31933 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1282 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776912 | 5981529.52333604 | 2106358.00177396 | 37.76258623775 | -122.507064660839 | (37.76258623775, -122.507064660839) | |
| 137376 | 137376 | 52565 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1490 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2016 12:00:00 AM | 3 | Permit Number 776032 | 5983749.00829455 | 2105020.42381918 | 37.759044091677204 | -122.49928954186399 | (37.7590440916772, -122.499289541864) | |
| 168415 | 168415 | 114958 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 66 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 1 | Permit Number 775977 | 5999698.38088 | 2087820.43772 | 37.7127397789845 | -122.44289408849 | (37.7127397789845, -122.44289408849) | ||
| 123349 | 123349 | 114804 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2427 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 775689 | 5989172.0 | 2098830.2 | 37.742364035662796 | -122.480081453283 | (37.7423640356628, -122.480081453283) | |||
| 67558 | 67558 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Allston Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418.0 | 37.741524734078205 | -122.46256819082701 | (37.7415247340782, -122.462568190827) | ||
| 22972 | 22972 | 108950 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 601 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | |
| 127235 | 127235 | 110211 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 601 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | |
| 87751 | 87751 | 115170 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2483 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 775167 | 5983603.3 | 2098266.1 | 37.7404900382804 | -122.499294352828 | (37.7404900382804, -122.499294352828) | |||
| 1091 | 1091 | 110107 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4130 MORAGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | 15 | 3x3 | Permit Number 774958 | 5981430.4 | 2103553.9 | 37.7548811373619 | -122.507199448976 | (37.7548811373619, -122.507199448976) | |
| 77869 | 77869 | 88717 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 301 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | |
| 103535 | 103535 | 88718 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 301 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | |
| 117930 | 117930 | 88716 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 301 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | ||
| 108350 | 108350 | 110691 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 216 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774675 | 6005029.7 | 2100275.0 | 37.747239754431895 | -122.425353075464 | (37.7472397544319, -122.425353075464) | |
| 77897 | 77897 | 105128 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1835 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.752249639902296 | -122.506499383522 | (37.7522496399023, -122.506499383522) | |
| 99775 | 99775 | 61979 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4400 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001287.16223059 | 2101175.19968833 | 37.749499333765996 | -122.438358942397 | (37.749499333766, -122.438358942397) | |||
| 127687 | 127687 | 115197 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4400 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001219.3 | 2101182.5 | 37.7495155185031 | -122.438594134479 | (37.7495155185031, -122.438594134479) | |||
| 61475 | 61475 | 114702 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 237 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774513 | 6006534.54774 | 2092840.44849 | 37.7269110313963 | -122.41962201445 | (37.7269110313963, -122.41962201445) | ||
| 97557 | 97557 | 109717 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3832 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773646 | 5982350.4 | 2103585.5 | 37.7550220459753 | -122.50402022585101 | (37.7550220459753, -122.504020225851) |
| 91653 | 91653 | 54999 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 538 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | Permit Number 773428 | 5990967.79402544 | 2111724.41194432 | 37.77787229032 | -122.47481314337799 | (37.77787229032, -122.474813143378) | |||
| 143249 | 143249 | 109192 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773182 | 5984114.7 | 2098211.0 | 37.7403687376469 | -122.497522091318 | (37.7403687376469, -122.497522091318) |
| 11666 | 11666 | 108844 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 420 Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010500.63404 | 2091864.14228 | 37.724452908148606 | -122.405842528314 | (37.7244529081486, -122.405842528314) | |
| 87035 | 87035 | 104818 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Permit Number 771234 | 5983853.47864 | 2110990.25289 | 37.7754416707598 | -122.49936939548401 | (37.7754416707598, -122.499369395484) | ||
| 157787 | 157787 | 104792 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 771234 | 5983853.47126 | 2110973.3906900003 | 37.775395371596 | -122.49936817466299 | (37.775395371596, -122.499368174663) | |||
| 3606 | 3606 | 220870 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1305 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2014 12:00:00 AM | 1 | Width 4ft | Permit Number 771153 | 5998204.3493099995 | 2105944.91927 | 37.762419969235 | -122.449362963227 | (37.762419969235, -122.449362963227) | |
| 87940 | 87940 | 41287 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80X Rosemont Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | Permit Number 771150 | 6005120.37250824 | 2107836.80061549 | 37.7680078062065 | -122.42557762883301 | (37.7680078062065, -122.425577628833) | ||
| 83433 | 83433 | 104971 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 752 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | |||
| 143246 | 143246 | 102383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 471-473 Noe St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2013 12:00:00 AM | 12 | 3x3 | Permit Number 769850 | 6002995.0 | 2105507.0 | 37.7614904180073 | -122.432762601795 | (37.7614904180073, -122.432762601795) | |
| 108073 | 108073 | 102062 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769724 | 6007185.0 | 2097679.0 | 37.740233252719705 | -122.41771621811701 | (37.7402332527197, -122.417716218117) |
| 42132 | 42132 | 55307 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | ||
| 151447 | 151447 | 56726 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1523 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 769408 | 6015773.2097 | 2095596.9346 | 37.734995871663706 | -122.387876131204 | (37.7349958716637, -122.387876131204) | |||
| 123046 | 123046 | 100255 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1456 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 769196 | 5993711.5 | 2105567.7 | 37.761126200258296 | -122.46487454888901 | (37.7611262002583, -122.464874548889) | ||
| 99942 | 99942 | 100187 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 217 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | ||
| 122591 | 122591 | 100188 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 217 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | ||
| 87654 | 87654 | 99961 | Property Tree 7 | Callistemon citrinus :: Lemon Bottlebrush 28 | 537 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459.0 | 2099152.0 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | |||
| 101427 | 101427 | 63557 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768581 | 6008414.60000343 | 2103856.53351654 | 37.75726449571211 | -122.413901624069 | (37.7572644957121, -122.413901624069) |
| 74456 | 74456 | 96644 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2215 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767989 | 5988552.97397 | 2114644.11737 | 37.785748747660705 | -122.48338083780001 | (37.7857487476607, -122.4833808378) | |
| 95877 | 95877 | 96339 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1494@ 27th St Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2011 12:00:00 AM | 3x3 | Permit Number 767722 | 6005839.0 | 2100241.0 | 37.7471920883951 | -122.422552158036 | (37.7471920883951, -122.422552158036) | ||
| 49036 | 49036 | 65607 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 182 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767458 | 6004579.16944 | 2093759.75788 | 37.7293249116129 | -122.42644714752501 | (37.7293249116129, -122.426447147525) |
| 53282 | 53282 | 53701 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2656 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1970 12:00:00 AM | 12 | Permit Number 6647 | 5999210.43552 | 2117936.02801 | 37.795401961392706 | -122.44674613035102 | (37.7954019613927, -122.446746130351) | ||
| 148445 | 148445 | 53514 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1382 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1969 12:00:00 AM | 3 | Permit Number 6426 | 6015935.5088 | 2093105.8067 | 37.7281647222543 | -122.38714130029 | (37.7281647222543, -122.38714130029) | ||
| 129894 | 129894 | 53400 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2502 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1969 12:00:00 AM | 10 | Permit Number 6299 | 5990880.06647 | 2112020.40978 | 37.7786799348836 | -122.475138234513 | (37.7786799348836, -122.475138234513) | ||
| 91384 | 91384 | 81369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 14 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2011 12:00:00 AM | Permit Number 58731 | 5992684.22042124 | 2099043.76352214 | 37.743153872635105 | -122.467952894625 | (37.7431538726351, -122.467952894625) | |||
| 161518 | 161518 | 62223 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2010 12:00:00 AM | 3 | Permit Number 53519 | 6001462.98995 | 2093679.2412299998 | 37.7289271819206 | -122.437214279825 | (37.7289271819206, -122.437214279825) | |
| 41438 | 41438 | 92558 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52904 | 5989977.22773 | 2113271.83238 | 37.7820636253324 | -122.47835299857799 | (37.7820636253324, -122.478352998578) | |
| 131048 | 131048 | 50248 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1370 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52899 | 5985267.5978 | 2105900.7074 | 37.7615500789995 | -122.49410249664 | (37.7615500789995, -122.49410249664) | |
| 122270 | 122270 | 92263 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2530 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52711 | 5992102.6 | 2098202.2 | 37.7408095493016 | -122.469902704935 | (37.7408095493016, -122.469902704935) | ||
| 148195 | 148195 | 102083 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 714 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52511 | 5991334.07902 | 2110523.03796 | 37.7745948642856 | -122.47345839749201 | (37.7745948642856, -122.473458397492) |
| 38626 | 38626 | 82895 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008648.2353300005 | 2110155.46088 | 37.7745730107591 | -122.413539104453 | (37.7745730107591, -122.413539104453) | |
| 59690 | 59690 | 82893 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008675.9193 | 2110180.49816 | 37.774643311661 | -122.413445110902 | (37.774643311661, -122.413445110902) | |
| 63914 | 63914 | 82894 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52441 | 6008668.81492 | 2110175.98825 | 37.774630529613106 | -122.413469367432 | (37.7746305296131, -122.413469367432) | |
| 73923 | 73923 | 82946 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52441 | 6008626.20144 | 2110135.25412 | 37.7745162905198 | -122.41361389477 | (37.7745162905198, -122.41361389477) | |
| 86200 | 86200 | 83449 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 94094 | 94094 | 83448 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 101201 | 101201 | 82741 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 102039 | 102039 | 83450 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 104803 | 104803 | 82892 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 107358 | 107358 | 82891 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 127636 | 127636 | 82890 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1325 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | ||
| 104179 | 104179 | 56684 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 221 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52127 | 6004114.02111143 | 2097584.45844202 | 37.7398003700762 | -122.428327693503 | (37.7398003700762, -122.428327693503) | |||
| 63237 | 63237 | 41232 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3721 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51879 | 6002533.18198 | 2121382.3124 | 37.8050538066511 | -122.4354955486 | (37.8050538066511, -122.4354955486) | |
| 13352 | 13352 | 32080 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3851 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51784 | 6003941.65438147 | 2105363.49480285 | 37.761150030842295 | -122.42947828104799 | (37.7611500308423, -122.429478281048) | |
| 90450 | 90450 | 89040 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 272 Main St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 93736 | 93736 | 89041 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 272 Main St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 107104 | 107104 | 89039 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 272 Main St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 110356 | 110356 | 89038 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 272 Main St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 122390 | 122390 | 89037 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 272 Main St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 109650 | 109650 | 83947 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 621 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50877 | 5993846.00894891 | 2107297.16077744 | 37.7658826019177 | -122.464534924027 | (37.7658826019177, -122.464534924027) | ||
| 112002 | 112002 | 83975 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 621 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50877 | 5993846.00894891 | 2107297.16077744 | 37.7658826019177 | -122.464534924027 | (37.7658826019177, -122.464534924027) | ||
| 109561 | 109561 | 87859 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.9 | 2104839.6 | 37.7595025728637 | -122.442163870481 | (37.7595025728637, -122.442163870481) | ||
| 144037 | 144037 | 87852 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1800X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50759 | 6003483.0 | 2114899.0 | 37.7873061997009 | -122.43174540917299 | (37.7873061997009, -122.431745409173) | |
| 88316 | 88316 | 49893 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6@ OCEAN Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50572 | 5993153.17842145 | 2093093.53426236 | 37.7268430955942 | -122.46589912078998 | (37.7268430955942, -122.46589912079) | ||
| 177453 | 177453 | 87177 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1572 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50147 | 6014901.6694 | 2093877.1498 | 37.7302253707536 | -122.39076923299999 | (37.7302253707536, -122.390769233) | |
| 87698 | 87698 | 56293 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 214 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2007 12:00:00 AM | 3x3 | Permit Number 50007 | 6007818.00861163 | 2100270.55026834 | 37.7473846745488 | -122.415710973202 | (37.7473846745488, -122.415710973202) | ||
| 101763 | 101763 | 65575 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 44 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2007 12:00:00 AM | 3x3 | Permit Number 49937 | 6007552.07395288 | 2099897.22885684 | 37.7463446647462 | -122.41660411777 | (37.7463446647462, -122.41660411777) |
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");