trees
44 rows where qSpecies_id = 164
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1050 | 59568 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 636 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1981 12:00:00 AM | Permit Number 18958 | 6007406.54160631 | 2096049.3151302 | 37.7357709619243 | -122.416834784421 | (37.7357709619243, -122.416834784421) | 2 | 7 | 7 | 28859 | 2 | ||
7895 | 154106 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 1734 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6014683.17412 | 2096477.94063 | 37.7373544878265 | -122.391706380051 | (37.7373544878265, -122.391706380051) | 10 | 3 | 8 | 58 | 1 | |||
8018 | 129362 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 267 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2019 12:00:00 AM | 3 | Width 3ft | 5998049.17758 | 2115549.71385 | 37.7887833747005 | -122.450592131447 | (37.7887833747005, -122.450592131447) | 11 | 6 | 1 | 54 | 31 | ||
8448 | 240709 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 2147 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6008788.38266 | 2105728.6282 | 37.7624258256133 | -122.412741279898 | (37.7624258256133, -122.412741279898) | 8 | 4 | 7 | 28859 | 19 | |||
16206 | 109465 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013321.87847 | 2109385.26551 | 37.7727195476045 | -122.397317921189 | (37.7727195476045, -122.397317921189) | 14 | 2 | 9 | 310 | 20 | ||
16211 | 63678 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 346 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | Permit Number 24331 | 6004255.25564967 | 2100168.95434569 | 37.7469047930092 | -122.428023489983 | (37.7469047930092, -122.428023489983) | 2 | 7 | 5 | 63 | 22 | ||
16815 | 109466 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2017 12:00:00 AM | 3 | 4x4 | Permit Number 773752 | 6013302.89282 | 2109368.02055 | 37.7726711397891 | -122.397382385507 | (37.7726711397891, -122.397382385507) | 14 | 2 | 9 | 310 | 20 | |
18967 | 73241 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 917 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6x15 | 6015272.44641 | 2104314.96126 | 37.7589060005196 | -122.390216339206 | (37.7589060005196, -122.390216339206) | 10 | 3 | 8 | 28856 | 29 | ||
23359 | 59565 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 619 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1981 12:00:00 AM | Permit Number 18954 | 6007460.34323928 | 2096066.59710548 | 37.7358214405074 | -122.416649994553 | (37.7358214405074, -122.416649994553) | 2 | 7 | 7 | 28859 | 2 | ||
26235 | 63673 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 350 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | Permit Number 24325 | 6004230.54074643 | 2100167.59605013 | 37.7468996651462 | -122.428108855089 | (37.7468996651462, -122.428108855089) | 2 | 7 | 5 | 63 | 22 | ||
27368 | 109463 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2017 12:00:00 AM | 3 | 4x4 | Permit Number 773752 | 6013357.96458 | 2109418.68041 | 37.7728133064148 | -122.397195438039 | (37.7728133064148, -122.397195438039) | 14 | 2 | 9 | 310 | 20 | |
30906 | 35374 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 703 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38832 | 6011634.9714901 | 2091590.10867273 | 37.7237638410136 | -122.401902000455 | (37.7237638410136, -122.401902000455) | 10 | 3 | 7 | 309 | 28 | ||
32728 | 59564 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 615 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1981 12:00:00 AM | Permit Number 18953 | 6007462.07348331 | 2096085.477762 | 37.7358733799602 | -122.416645349501 | (37.7358733799602, -122.416645349501) | 2 | 7 | 7 | 28859 | 2 | ||
45708 | 190831 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 1410 Indiana St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 7ft | 6015067.38634 | 2101784.33816 | 37.7519460725775 | -122.390748690225 | (37.7519460725775, -122.390748690225) | 10 | 3 | 8 | 28856 | 1 | |||
48798 | 109467 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | Permit Number 773752 | 6013285.76594 | 2109350.55221 | 37.7726222220803 | -122.397440404346 | (37.7726222220803, -122.397440404346) | 14 | 2 | 9 | 310 | 20 | ||
52142 | 181756 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 1247 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989227.6607 | 2106830.281 | 37.7643333613497 | -122.480474466571 | (37.7643333613497, -122.480474466571) | 1 | 8 | 3 | 56 | 35 | |||
79782 | 34428 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 53 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38172 | 6002586.49779789 | 2096027.74981591 | 37.7354394538405 | -122.433498000263 | (37.7354394538405, -122.433498000263) | 2 | 7 | 5 | 63 | 7 | ||
84149 | 59562 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 331 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1989 12:00:00 AM | Permit Number 25871 | 6006941.40355964 | 2096316.28945654 | 37.736477840612 | -122.418461876521 | (37.736477840612, -122.418461876521) | 2 | 7 | 7 | 28859 | 2 | ||
84511 | 109468 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | Permit Number 773752 | 6013267.70036 | 2109332.73182 | 37.7725722854256 | -122.397501645497 | (37.7725722854256, -122.397501645497) | 14 | 2 | 9 | 310 | 20 | ||
101333 | 37580 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 284 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40012 | 6001093.39628653 | 2104733.48364298 | 37.759258498739 | -122.439284003873 | (37.759258498739, -122.439284003873) | 2 | 4 | 5 | 28862 | 3 | ||
108262 | 63677 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 342 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | Permit Number 24330 | 6004279.97052982 | 2100170.31263998 | 37.7469099208057 | -122.427938124946 | (37.7469099208057, -122.427938124946) | 2 | 7 | 5 | 63 | 22 | ||
115539 | 109460 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 4x4 | Permit Number 773752 | 6013412.32492 | 2109471.0252 | 37.7729600595772 | -122.397011068921 | (37.7729600595772, -122.397011068921) | 14 | 2 | 9 | 310 | 20 | ||
121152 | 59563 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 327 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1981 12:00:00 AM | Permit Number 18951 | 6006912.63442419 | 2096318.7151912 | 37.7364828815312 | -122.418561515786 | (37.7364828815312, -122.418561515786) | 2 | 7 | 7 | 28859 | 2 | ||
126344 | 109462 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 773752 | 6013376.015 | 2109435.75899 | 37.7728612052211 | -122.3971341969 | (37.7728612052211, -122.3971341969) | 14 | 2 | 9 | 310 | 20 | ||
127231 | 109459 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 773752 | 6013430.92674 | 2109487.72122 | 37.7730069385559 | -122.396947893341 | (37.7730069385559, -122.396947893341) | 14 | 2 | 9 | 310 | 20 | ||
129361 | 190832 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 1410 Indiana St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 7ft | 6015072.34284 | 2101690.18284 | 37.7516878169606 | -122.390724970608 | (37.7516878169606, -122.390724970608) | 10 | 3 | 8 | 28856 | 1 | |||
150292 | 109461 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | Permit Number 773752 | 6013397.07251 | 2109454.07559 | 37.7729126707161 | -122.397062640549 | (37.7729126707161, -122.397062640549) | 14 | 2 | 9 | 310 | 20 | ||
152102 | 109458 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | Permit Number 773752 | 6013450.12112 | 2109506.07563 | 37.7730584040491 | -122.396882784219 | (37.7730584040491, -122.396882784219) | 14 | 2 | 9 | 310 | 20 | ||
154592 | 109464 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013338.99753 | 2109402.36294 | 37.7727674463814 | -122.39725990323 | (37.7727674463814, -122.39725990323) | 14 | 2 | 9 | 310 | 20 | ||
155909 | 107772 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 235 Berry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772845 | 6014269.44498 | 2110088.45107 | 37.7747030477472 | -122.394089396335 | (37.7747030477472, -122.394089396335) | 6 | 2 | 9 | 310 | 20 | |
156957 | 59576 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 537 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1981 12:00:00 AM | Permit Number 18966 | 6007489.70731481 | 2096387.01987807 | 37.7367029025496 | -122.416571162069 | (37.7367029025496, -122.416571162069) | 2 | 7 | 7 | 28859 | 2 | ||
157401 | 227024 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 2 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008432.71528 | 2108016.47273 | 37.7686877474713 | -122.414133273031 | (37.7686877474713, -122.414133273031) | 8 | 4 | 7 | 28853 | 19 | |||
162061 | 107771 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 235 Berry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772845 | 6014269.44498 | 2110088.45107 | 37.7747030477472 | -122.394089396335 | (37.7747030477472, -122.394089396335) | 6 | 2 | 9 | 310 | 20 | |
168906 | 109469 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013484.3589 | 2109540.27035 | 37.7731542007368 | -122.3967667483 | (37.7731542007368, -122.3967667483) | 14 | 2 | 9 | 310 | 20 | ||
171073 | 227023 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 2 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008473.60073 | 2108019.87759 | 37.7686993927964 | -122.413992093871 | (37.7686993927964, -122.413992093871) | 8 | 4 | 7 | 28853 | 19 | |||
172904 | 47289 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 822 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | Permit Number 45231 | 6009081.20267252 | 2104363.20589097 | 37.7586931180178 | -122.411632041149 | (37.7586931180178, -122.411632041149) | 2 | 4 | 7 | 28859 | 19 | ||
178049 | 35373 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 703 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38832 | 6011634.9714901 | 2091590.10867273 | 37.7237638410136 | -122.401902000455 | (37.7237638410136, -122.401902000455) | 10 | 3 | 7 | 309 | 28 | ||
181245 | 223194 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 1062 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009425.47555 | 2102994.63334 | 37.7549546321578 | -122.41034475212 | (37.7549546321578, -122.41034475212) | 2 | 4 | 7 | 28859 | 19 | |||
184990 | 57070 | DPW Maintained 1 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 924 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 12 | 7x10 | Permit Number 14336 | 6015213.6937 | 2104283.49754 | 37.7588163489102 | -122.390417336814 | (37.7588163489102, -122.390417336814) | 10 | 3 | 8 | 28856 | 29 | |
186346 | 34427 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 53 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38172 | 6002586.49779789 | 2096027.74981591 | 37.7354394538405 | -122.433498000263 | (37.7354394538405, -122.433498000263) | 2 | 7 | 5 | 63 | 7 | ||
186881 | 35971 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 319 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39129 | 6006855.09615329 | 2096323.56666054 | 37.7364929631168 | -122.418760794357 | (37.7364929631168, -122.418760794357) | 2 | 7 | 7 | 28859 | 2 | ||
187366 | 57778 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 772 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2004 12:00:00 AM | Permit Number 16703 | 6001537.00426065 | 2100020.12529342 | 37.7463419814677 | -122.437412281127 | (37.7463419814677, -122.437412281127) | 2 | 7 | 5 | 63 | 22 | ||
191534 | 67085 | Permitted Site 7 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 203 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30483 | 6007143.61942231 | 2097006.56462463 | 37.7383845655461 | -122.417811643303 | (37.7383845655461, -122.417811643303) | 2 | 7 | 7 | 28859 | 2 | ||
193110 | 109470 | Planning Code 138.1 required 2 | Koelreuteria bipinnata :: Chinese Flame Tree 164 | 360 Berry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | Permit Number 773752 | 6013467.61268 | 2109523.16527 | 37.7731063019529 | -122.396823476633 | (37.7731063019529, -122.396823476633) | 14 | 2 | 9 | 310 | 20 |
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) );