trees
3,267 rows where qSpecies_id = 67 sorted by PermitNotes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26052 | 94065 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 5 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
| 114729 | 94064 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 4 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
| 192464 | 94063 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
| 173743 | 94062 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
| 166934 | 94061 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 1 on Craut. | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
| 131166 | 54149 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 34 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 22 | Permit Number 9884 | 6013977.76426 | 2095493.9516 | 37.7346134738323 | -122.394076462386 | (37.7346134738323, -122.394076462386) | 10 | 3 | 8 | 58 | 1 | ||
| 86872 | 54138 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2460 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 12 | Permit Number 9871 | 6001817.46051 | 2117723.34964 | 37.7949665825052 | -122.437710167809 | (37.7949665825052, -122.437710167809) | 13 | 9 | 1 | 57 | 27 | ||
| 175117 | 53958 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 198 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | Permit Number 9673 | 6009460.95133411 | 2095046.30574205 | 37.7331322551525 | -122.40966108533 | (37.7331322551525, -122.40966108533) | 10 | 3 | 7 | 309 | 28 | |||
| 152228 | 53953 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 166 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | 7 | Permit Number 9668 | 6009649.77155 | 2095111.31866 | 37.7333213458895 | -122.409012866065 | (37.7333213458895, -122.409012866065) | 10 | 3 | 7 | 309 | 28 | ||
| 61759 | 53952 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 162 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1972 12:00:00 AM | 11 | Permit Number 9667 | 6009674.27519 | 2095120.19458 | 37.7333470898892 | -122.408928775863 | (37.7333470898892, -122.408928775863) | 10 | 3 | 7 | 309 | 28 | ||
| 45242 | 53793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 258 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1972 12:00:00 AM | 5 | Permit Number 9485 | 5987461.74395 | 2114234.65378 | 37.784560908121 | -122.487126051666 | (37.784560908121, -122.487126051666) | 11 | 6 | 1 | 55 | 26 | ||
| 9642 | 53732 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9411 | 6012636.58641 | 2095202.58654 | 37.7337388121015 | -122.398692955821 | (37.7337388121015, -122.398692955821) | 10 | 3 | 8 | 58 | 1 | |
| 110029 | 53731 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 137 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9410 | 6012616.20175 | 2095211.8932 | 37.7337632304952 | -122.398764085002 | (37.7337632304952, -122.398764085002) | 10 | 3 | 8 | 58 | 1 | |
| 43649 | 53730 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 131 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9409 | 6012588.70233 | 2095226.85555 | 37.733802781761 | -122.398860209038 | (37.733802781761, -122.398860209038) | 10 | 3 | 8 | 58 | 1 | |
| 70232 | 53729 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 12 | Permit Number 9408 | 6012570.8653 | 2095236.57105 | 37.7338284646029 | -122.398922559042 | (37.7338284646029, -122.398922559042) | 10 | 3 | 8 | 58 | 1 | ||
| 146950 | 53727 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9406 | 6012545.27593 | 2095206.78524 | 37.7337452530338 | -122.399008939832 | (37.7337452530338, -122.399008939832) | 10 | 3 | 8 | 58 | 1 | |
| 18558 | 220932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 56 Mirabel Ave | 1 | Front Yard : Cutout | Tree | DPW 1 | 3 | 3x3 | Permit Number 785183 | 6007687.03242 | 2099968.45973 | 37.7465478380206 | -122.416142489803 | (37.7465478380206, -122.416142489803) | 2 | 7 | 7 | 28859 | 2 | ||
| 81070 | 256613 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2214 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781468 | 5985177 | 2100108 | 37.745639596763 | -122.493988903155 | (37.745639596763, -122.493988903155) | 1 | 8 | 3 | 29491 | 35 | |
| 90355 | 222216 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | 2 | 7 | 5 | 63 | 7 | ||
| 1528 | 70442 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | 1 | 8 | 3 | 29491 | 35 | |
| 194439 | 62177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780357 | 6000151.49887 | 2091775.04378 | 37.7236240542963 | -122.441611590516 | (37.7236240542963, -122.441611590516) | 9 | 7 | 6 | 28861 | 25 |
| 166284 | 220995 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 610 Clipper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001157.49823 | 2100904.81554 | 37.7487495474712 | -122.438787950406 | (37.7487495474712, -122.438787950406) | 2 | 4 | 5 | 28862 | 22 | |
| 62700 | 222541 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Newburg St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 779491 | 6002580.94722 | 2099999.66602 | 37.7463450993615 | -122.433800991143 | (37.7463450993615, -122.433800991143) | 2 | 7 | 5 | 63 | 22 | ||
| 40381 | 42165 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 354 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011856.41574 | 2111871.95313 | 37.7794657219919 | -122.402562043425 | (37.7794657219919, -122.402562043425) | 14 | 2 | 9 | 28856 | 34 | ||
| 190348 | 42166 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 354 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011846.02554 | 2111882.36991 | 37.7794937439822 | -122.402598720465 | (37.7794937439822, -122.402598720465) | 14 | 2 | 9 | 28856 | 34 | ||
| 122615 | 31651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.504805016487 | (37.736233320022, -122.504805016487) | 1 | 8 | 3 | 29491 | 35 | |
| 194424 | 62181 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 18 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2017 12:00:00 AM | 3 | Permit Number 778619 | 6000227.93753 | 2091768.58709 | 37.7236106804803 | -122.441346893068 | (37.7236106804803, -122.441346893068) | 9 | 7 | 6 | 28861 | 25 | |
| 129858 | 56162 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 547 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | Permit Number 778533 | 5990919.363 | 2111652.3047 | 37.7776714970248 | -122.474975416646 | (37.7776714970248, -122.474975416646) | 11 | 6 | 2 | 54 | 26 | ||
| 25231 | 116687 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777961 | 6002117.845 | 2092646.43529 | 37.7261285348836 | -122.434876571303 | (37.7261285348836, -122.434876571303) | 9 | 7 | 6 | 28861 | 25 | ||
| 107773 | 31933 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1282 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776912 | 5981529.52333604 | 2106358.00177396 | 37.76258623775 | -122.507064660839 | (37.76258623775, -122.507064660839) | 1 | 8 | 3 | 56 | 35 | |
| 169323 | 52565 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1490 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2016 12:00:00 AM | 3 | Permit Number 776032 | 5983749.00829455 | 2105020.42381918 | 37.7590440916772 | -122.499289541864 | (37.7590440916772, -122.499289541864) | 1 | 8 | 3 | 56 | 35 | |
| 181812 | 114958 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 66 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | 1 | Permit Number 775977 | 5999698.38088 | 2087820.43772 | 37.7127397789845 | -122.44289408849 | (37.7127397789845, -122.44289408849) | 9 | 7 | 6 | 28861 | 5 | ||
| 87728 | 114804 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2427 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 775689 | 5989172 | 2098830.2 | 37.7423640356628 | -122.480081453283 | (37.7423640356628, -122.480081453283) | 1 | 8 | 3 | 29491 | 35 | |||
| 12868 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Allston Way | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418 | 37.7415247340782 | -122.462568190827 | (37.7415247340782, -122.462568190827) | 1 | 8 | 4 | 59 | 40 | ||
| 79667 | 110211 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 601 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | |
| 111849 | 108950 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 601 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.7748766027312 | -122.433005738531 | (37.7748766027312, -122.433005738531) | 15 | 5 | 11 | 29492 | 10 | |
| 38082 | 115170 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2483 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775167 | 5983603.3 | 2098266.1 | 37.7404900382804 | -122.499294352828 | (37.7404900382804, -122.499294352828) | 1 | 8 | 3 | 29491 | 35 | |||
| 38114 | 88717 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | |
| 112909 | 88718 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | |
| 156478 | 88716 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | ||
| 124940 | 110691 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 216 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774675 | 6005029.7 | 2100275 | 37.7472397544319 | -122.425353075464 | (37.7472397544319, -122.425353075464) | 2 | 7 | 5 | 63 | 22 | |
| 170081 | 105128 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1835 47TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.7522496399023 | -122.506499383522 | (37.7522496399023, -122.506499383522) | 1 | 8 | 3 | 56 | 35 | |
| 19893 | 115197 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001219.3 | 2101182.5 | 37.7495155185031 | -122.438594134479 | (37.7495155185031, -122.438594134479) | 2 | 4 | 5 | 28862 | 22 | |||
| 112639 | 61979 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001287.16223059 | 2101175.19968833 | 37.749499333766 | -122.438358942397 | (37.749499333766, -122.438358942397) | 2 | 4 | 5 | 28862 | 22 | |||
| 110050 | 114702 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 237 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774513 | 6006534.54774 | 2092840.44849 | 37.7269110313963 | -122.41962201445 | (37.7269110313963, -122.41962201445) | 9 | 7 | 7 | 309 | 5 | ||
| 105935 | 109717 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3832 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773646 | 5982350.4 | 2103585.5 | 37.7550220459753 | -122.504020225851 | (37.7550220459753, -122.504020225851) | 1 | 8 | 3 | 56 | 35 |
| 87891 | 54999 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | Permit Number 773428 | 5990967.79402544 | 2111724.41194432 | 37.77787229032 | -122.474813143378 | (37.77787229032, -122.474813143378) | 11 | 6 | 2 | 54 | 26 | |||
| 152564 | 109192 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773182 | 5984114.7 | 2098211 | 37.7403687376469 | -122.497522091318 | (37.7403687376469, -122.497522091318) | 1 | 8 | 3 | 29491 | 35 |
| 78278 | 108844 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 420 Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010500.63404 | 2091864.14228 | 37.7244529081486 | -122.405842528314 | (37.7244529081486, -122.405842528314) | 10 | 3 | 7 | 309 | 28 | |
| 130941 | 104818 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 771234 | 5983853.47864 | 2110990.25289 | 37.7754416707598 | -122.499369395484 | (37.7754416707598, -122.499369395484) | 11 | 6 | 2 | 55 | 26 | ||
| 133138 | 104792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 771234 | 5983853.47126 | 2110973.39069 | 37.775395371596 | -122.499368174663 | (37.775395371596, -122.499368174663) | 11 | 6 | 2 | 55 | 26 | |||
| 163735 | 220870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1305 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2014 12:00:00 AM | 1 | Width 4ft | Permit Number 771153 | 5998204.34931 | 2105944.91927 | 37.762419969235 | -122.449362963227 | (37.762419969235, -122.449362963227) | 15 | 5 | 11 | 29492 | 9 | |
| 58928 | 41287 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80X Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 771150 | 6005120.37250824 | 2107836.80061549 | 37.7680078062065 | -122.425577628833 | (37.7680078062065, -122.425577628833) | 8 | 4 | 5 | 28853 | 19 | ||
| 40812 | 104971 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 752 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770765 | 6012376.8 | 2104435.9 | 37.7590770349231 | -122.400239393453 | (37.7590770349231, -122.400239393453) | 10 | 3 | 8 | 28856 | 29 | |||
| 186753 | 102383 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 471-473 Noe St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2013 12:00:00 AM | 12 | 3x3 | Permit Number 769850 | 6002995 | 2105507 | 37.7614904180073 | -122.432762601795 | (37.7614904180073, -122.432762601795) | 15 | 4 | 5 | 28862 | 3 | |
| 121970 | 102062 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769724 | 6007185 | 2097679 | 37.7402332527197 | -122.417716218117 | (37.7402332527197, -122.417716218117) | 2 | 7 | 7 | 28859 | 2 |
| 16874 | 55307 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | 13 | 9 | 1 | 57 | 17 | ||
| 8896 | 56726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1523 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 769408 | 6015773.2097 | 2095596.9346 | 37.7349958716637 | -122.387876131204 | (37.7349958716637, -122.387876131204) | 10 | 3 | 8 | 58 | 1 | |||
| 160805 | 100255 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1456 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 769196 | 5993711.5 | 2105567.7 | 37.7611262002583 | -122.464874548889 | (37.7611262002583, -122.464874548889) | 1 | 8 | 11 | 56 | 12 | ||
| 111037 | 100187 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
| 168610 | 100188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
| 44455 | 99400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2201X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014717 | 2092863 | 37.7274304716685 | -122.391336797962 | (37.7274304716685, -122.391336797962) | 10 | 3 | 8 | 58 | 1 | |
| 68497 | 99961 | Property Tree 8 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459 | 2099152 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | 2 | 7 | 5 | 63 | 22 | |||
| 97011 | 63557 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/20/2011 12:00:00 AM | 4 | 3x3 | Permit Number 768581 | 6008414.60000343 | 2103856.53351654 | 37.7572644957121 | -122.413901624069 | (37.7572644957121, -122.413901624069) | 2 | 4 | 7 | 28859 | 19 |
| 51011 | 96644 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2215 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767989 | 5988552.97397 | 2114644.11737 | 37.7857487476607 | -122.4833808378 | (37.7857487476607, -122.4833808378) | 11 | 6 | 2 | 55 | 26 | |
| 79976 | 96339 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1494@ 27th St Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2011 12:00:00 AM | 3x3 | Permit Number 767722 | 6005839 | 2100241 | 37.7471920883951 | -122.422552158036 | (37.7471920883951, -122.422552158036) | 2 | 7 | 5 | 28859 | 22 | ||
| 12374 | 65607 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 182 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767458 | 6004579.16944 | 2093759.75788 | 37.7293249116129 | -122.426447147525 | (37.7293249116129, -122.426447147525) | 9 | 7 | 6 | 28861 | 5 |
| 18867 | 53701 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2656 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/1970 12:00:00 AM | 12 | Permit Number 6647 | 5999210.43552 | 2117936.02801 | 37.7954019613927 | -122.446746130351 | (37.7954019613927, -122.446746130351) | 13 | 9 | 1 | 57 | 17 | ||
| 146423 | 53514 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1382 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1969 12:00:00 AM | 3 | Permit Number 6426 | 6015935.5088 | 2093105.8067 | 37.7281647222543 | -122.38714130029 | (37.7281647222543, -122.38714130029) | 10 | 3 | 8 | 58 | 1 | ||
| 9444 | 205868 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 312 Lakeview Ave | 1 | : | Tree | Private 2 | 11/04/1969 12:00:00 AM | 13 | Width 3ft | Permit Number 6398 | 5996845.79725 | 2089640.92362 | 37.7175753652817 | -122.452884796511 | (37.7175753652817, -122.452884796511) | 9 | 8 | 6 | 28861 | 24 | |
| 27771 | 53400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2502 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1969 12:00:00 AM | 10 | Permit Number 6299 | 5990880.06647 | 2112020.40978 | 37.7786799348836 | -122.475138234513 | (37.7786799348836, -122.475138234513) | 11 | 6 | 2 | 54 | 26 | ||
| 76760 | 81369 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2011 12:00:00 AM | Permit Number 58731 | 5992684.22042124 | 2099043.76352214 | 37.7431538726351 | -122.467952894625 | (37.7431538726351, -122.467952894625) | 1 | 8 | 4 | 29491 | 40 | |||
| 32059 | 62223 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2010 12:00:00 AM | 3 | Permit Number 53519 | 6001462.98995 | 2093679.24123 | 37.7289271819206 | -122.437214279825 | (37.7289271819206, -122.437214279825) | 9 | 7 | 6 | 28861 | 25 | |
| 27779 | 92558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52904 | 5989977.22773 | 2113271.83238 | 37.7820636253324 | -122.478352998578 | (37.7820636253324, -122.478352998578) | 11 | 6 | 2 | 55 | 26 | |
| 153126 | 50248 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1370 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52899 | 5985267.5978 | 2105900.7074 | 37.7615500789995 | -122.49410249664 | (37.7615500789995, -122.49410249664) | 1 | 8 | 3 | 56 | 35 | |
| 156779 | 92263 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2530 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52711 | 5992102.6 | 2098202.2 | 37.7408095493016 | -122.469902704935 | (37.7408095493016, -122.469902704935) | 1 | 8 | 4 | 59 | 40 | ||
| 95186 | 102083 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 714 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52511 | 5991334.07902 | 2110523.03796 | 37.7745948642856 | -122.473458397492 | (37.7745948642856, -122.473458397492) | 11 | 6 | 2 | 54 | 26 |
| 26334 | 82890 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
| 65906 | 83449 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
| 78230 | 83448 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
| 96914 | 83450 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
| 99179 | 82893 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008675.9193 | 2110180.49816 | 37.774643311661 | -122.413445110902 | (37.774643311661, -122.413445110902) | 8 | 2 | 9 | 28853 | 34 | |
| 112588 | 82741 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
| 118309 | 82892 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
| 128802 | 82891 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
| 150453 | 82895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008648.23533 | 2110155.46088 | 37.7745730107591 | -122.413539104453 | (37.7745730107591, -122.413539104453) | 8 | 2 | 9 | 28853 | 34 | |
| 155201 | 82946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52441 | 6008626.20144 | 2110135.25412 | 37.7745162905198 | -122.41361389477 | (37.7745162905198, -122.41361389477) | 8 | 2 | 9 | 28853 | 34 | |
| 185378 | 82894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52441 | 6008668.81492 | 2110175.98825 | 37.7746305296131 | -122.413469367432 | (37.7746305296131, -122.413469367432) | 8 | 2 | 9 | 28853 | 34 | |
| 120466 | 56684 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 221 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52127 | 6004114.02111143 | 2097584.45844202 | 37.7398003700762 | -122.428327693503 | (37.7398003700762, -122.428327693503) | 2 | 7 | 5 | 63 | 7 | |||
| 133779 | 41232 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3721 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51879 | 6002533.18198 | 2121382.3124 | 37.8050538066511 | -122.4354955486 | (37.8050538066511, -122.4354955486) | 13 | 9 | 1 | 57 | 17 | |
| 185790 | 32080 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3851 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51784 | 6003941.65438147 | 2105363.49480285 | 37.7611500308423 | -122.429478281048 | (37.7611500308423, -122.429478281048) | 2 | 4 | 5 | 28862 | 3 | |
| 60912 | 89040 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 87196 | 89041 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 128724 | 89039 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 146725 | 89038 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 152630 | 89037 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
| 115200 | 83947 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 621 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50877 | 5993846.00894891 | 2107297.16077744 | 37.7658826019177 | -122.464534924027 | (37.7658826019177, -122.464534924027) | 11 | 8 | 11 | 56 | 12 | ||
| 147594 | 83975 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 621 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50877 | 5993846.00894891 | 2107297.16077744 | 37.7658826019177 | -122.464534924027 | (37.7658826019177, -122.464534924027) | 11 | 8 | 11 | 56 | 12 | ||
| 132836 | 87859 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 159 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50800 | 6000262.9 | 2104839.6 | 37.7595025728637 | -122.442163870481 | (37.7595025728637, -122.442163870481) | 2 | 4 | 5 | 28862 | 3 | ||
| 184175 | 87852 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1800X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50759 | 6003483 | 2114899 | 37.7873061997009 | -122.431745409173 | (37.7873061997009, -122.431745409173) | 13 | 9 | 11 | 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) );