trees
52 rows where qSpecies_id = 341
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10850 | 199421 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 1902 23rd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6012718.99232 | 2102873.6867 | 37.7548066136499 | -122.398946275964 | (37.7548066136499, -122.398946275964) | 10 | 3 | 8 | 28856 | 29 | |||
| 21534 | 249999 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 39 Darrell Pl | 3 | Back Yard : Yard | Tree | Private 2 | 121 | Width 0ft | 6011509.9435 | 2120224.2158 | 37.8023796968334 | -122.404348688764 | (37.8023796968334, -122.404348688764) | 3 | 1 | 10 | 308 | 23 | |||
| 24119 | 248052 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 19 Rutledge St | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 6010613.31023 | 2099368.87741 | 37.7450656176979 | -122.405981455594 | (37.7450656176979, -122.405981455594) | 2 | 7 | 7 | 28859 | 2 | ||||
| 29461 | 199423 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 1750 22nd St | 4 | Side Yard : Yard | Tree | Private 2 | 3 | 6012840.75546 | 2103801.40949 | 37.7573607224353 | -122.398590280219 | (37.7573607224353, -122.398590280219) | 10 | 3 | 8 | 28856 | 29 | ||||
| 29532 | 250220 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 312 Filbert St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011282.86826 | 2120079.66018 | 37.8019700907042 | -122.405124300067 | (37.8019700907042, -122.405124300067) | 3 | 1 | 10 | 308 | 23 | |||
| 29705 | 224472 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 3315 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007450.24001 | 2104978.31857 | 37.7602904519748 | -122.417316259756 | (37.7602904519748, -122.417316259756) | 2 | 4 | 7 | 28859 | 19 | |||
| 44345 | 253366 | Significant Tree 6 | Ficus carica :: Edible Fig 341 | 20 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004582 | 2109434 | 37.7723628942784 | -122.427553605007 | (37.7723628942784, -122.427553605007) | 7 | 9 | 11 | 28852 | 10 | ||||
| 49647 | 126613 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 680 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 6006953.42319 | 2121924.22216 | 37.8067918058547 | -122.42023724518 | (37.8067918058547, -122.42023724518) | 5 | 1 | 1 | 308 | 32 | |||
| 53706 | 14838 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 1315X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.433664099691 | (37.7783201948721, -122.433664099691) | 15 | 5 | 11 | 29492 | 41 | |||
| 62882 | 18561 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 1700X Quesada Ave | 16 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014529.14736 | 2095157.70577 | 37.7337208418243 | -122.392146622477 | (37.7337208418243, -122.392146622477) | 10 | 3 | 8 | 58 | 1 | |||
| 63624 | 199418 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 600 Illinois St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6015946.15077 | 2106178.35791 | 37.7640598335051 | -122.388016366372 | (37.7640598335051, -122.388016366372) | 14 | 3 | 8 | 28856 | 29 | |||
| 68383 | 224473 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 1637 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6002068.79375 | 2099252.08873 | 37.7442633522761 | -122.435518484014 | (37.7442633522761, -122.435518484014) | 2 | 7 | 5 | 63 | 22 | |||
| 69719 | 245116 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 114 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000340.3477 | 2109437.7149 | 37.772132265905 | -122.442226100337 | (37.772132265905, -122.442226100337) | 15 | 5 | 11 | 29492 | 9 | |||
| 71681 | 199419 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 800 19th St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6015051.02595 | 2105341.2079 | 37.7617115687578 | -122.391053849976 | (37.7617115687578, -122.391053849976) | 10 | 3 | 8 | 28856 | 29 | |||
| 74964 | 201290 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 76 Lydia Ave | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6012638.30332 | 2093004.00556 | 37.7277020579784 | -122.398532795545 | (37.7277020579784, -122.398532795545) | 10 | 3 | 8 | 58 | 1 | |||
| 76244 | 201291 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 78 Lydia Ave | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6012632.17098 | 2093009.59576 | 37.7277170658827 | -122.398554387387 | (37.7277170658827, -122.398554387387) | 10 | 3 | 8 | 58 | 1 | |||
| 77097 | 66572 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 145 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51752 | 6004706.15432 | 2094089.03232 | 37.7302362036282 | -122.426031579819 | (37.7302362036282, -122.426031579819) | 9 | 7 | 6 | 28861 | 5 | |
| 81667 | 224468 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 150 Coso Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6007429.17008 | 2099622.33879 | 37.7455829652936 | -122.417009632297 | (37.7455829652936, -122.417009632297) | 2 | 7 | 7 | 28859 | 2 | ||||
| 84784 | 224475 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 859 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6000869.49222 | 2101983.48815 | 37.7516949341823 | -122.43986119955 | (37.7516949341823, -122.43986119955) | 2 | 4 | 5 | 28862 | 22 | |||
| 85152 | 109114 | Undocumented 4 | Ficus carica :: Edible Fig 341 | 3301x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007480 | 2104949 | 37.760211624256 | -122.417211256042 | (37.760211624256, -122.417211256042) | 2 | 4 | 7 | 28859 | 19 | ||||
| 85352 | 176397 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 78 Seminole Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 5999084.20064 | 2090244.12215 | 37.7193596292322 | -122.445191027139 | (37.7193596292322, -122.445191027139) | 9 | 7 | 6 | 28861 | 25 | |||
| 85711 | 249980 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 224 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6011664.25383 | 2120117.28296 | 37.8020947070772 | -122.403807167375 | (37.8020947070772, -122.403807167375) | 3 | 1 | 10 | 308 | 23 | |||
| 89598 | 92073 | Permitted Site 7 | Ficus carica :: Edible Fig 341 | 2944 23rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2009 12:00:00 AM | 3x3 | Permit Number 52189 | 6009219 | 2102774 | 37.7543372460114 | -122.411043222573 | (37.7543372460114, -122.411043222573) | 2 | 4 | 7 | 28859 | 19 | |||
| 94746 | 100102 | Undocumented 4 | Ficus carica :: Edible Fig 341 | 495@ Beach Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
| 101835 | 255622 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 372 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006691 | 2103946 | 37.7574131994315 | -122.419868866239 | (37.7574131994315, -122.419868866239) | 2 | 4 | 7 | 28859 | 19 | ||||
| 104172 | 224471 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 627 Precita Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6009784.7997 | 2100421.88863 | 37.7479105825135 | -122.408920592022 | (37.7479105825135, -122.408920592022) | 2 | 7 | 7 | 28859 | 2 | |||
| 104506 | 199422 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 760 San Bruno Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6010966.90517 | 2104732.33039 | 37.759812249162 | -122.405136377945 | (37.759812249162, -122.405136377945) | 10 | 3 | 8 | 28856 | 29 | ||||
| 112605 | 200200 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 3125 Jennings St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6013737.6677 | 2090326.2765 | 37.7204107373071 | -122.394544822212 | (37.7204107373071, -122.394544822212) | 10 | 3 | 8 | 58 | 1 | |||
| 116163 | 199426 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 720 Mendell St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6016063.72053 | 2096868.35959 | 37.7385030371809 | -122.386960368021 | (37.7385030371809, -122.386960368021) | 10 | 3 | 8 | 58 | 1 | |||
| 117297 | 224477 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 23 Penny Ln | 1 | Back Yard : Yard | Tree | Private 2 | 7 | Width 2ft | 6002584.32363 | 2096230.79701 | 37.7359968514733 | -122.433520023145 | (37.7359968514733, -122.433520023145) | 2 | 7 | 5 | 63 | 7 | |||
| 118792 | 199420 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 800 19th St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6015014.04418 | 2105339.34196 | 37.7617043930642 | -122.391181625655 | (37.7617043930642, -122.391181625655) | 10 | 3 | 8 | 28856 | 29 | |||
| 119341 | 202067 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 1 Hwy 101 S On Ramp | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 6013024.68106 | 2090205.86512 | 37.7200404483787 | -122.397000965021 | (37.7200404483787, -122.397000965021) | 10 | 3 | 8 | 58 | 1 | |||
| 122818 | 249998 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 39 Darrell Pl | 2 | Back Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011504.54206 | 2120237.90093 | 37.8024169710215 | -122.404368344317 | (37.8024169710215, -122.404368344317) | 3 | 1 | 10 | 308 | 23 | |||
| 130984 | 224470 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 1099 Alabama St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6009222.2963 | 2102800.34882 | 37.754409778801 | -122.411033684066 | (37.754409778801, -122.411033684066) | 2 | 4 | 7 | 28859 | 19 | |||
| 131558 | 176398 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 716 Peru Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005277.37254 | 2092448.27671 | 37.7257633175172 | -122.4239401713 | (37.7257633175172, -122.4239401713) | 9 | 7 | 6 | 309 | 5 | |||
| 136706 | 224469 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 400 Prospect Ave | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6006200.61902 | 2097593.19015 | 37.7399421943761 | -122.421113726225 | (37.7399421943761, -122.421113726225) | 2 | 7 | 7 | 28859 | 2 | ||||
| 141304 | 187591 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 700 Goettingen St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6010706.42139 | 2091370.77332 | 37.7231097257218 | -122.405096421963 | (37.7231097257218, -122.405096421963) | 10 | 3 | 7 | 309 | 28 | ||||
| 157097 | 201918 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 251 Elmira St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011265.63064 | 2095268.88122 | 37.7338443646257 | -122.403437444384 | (37.7338443646257, -122.403437444384) | 10 | 3 | 8 | 58 | 1 | |||
| 165362 | 249997 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 39 Darrell Pl | 1 | Back Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 6011507.58223 | 2120247.73739 | 37.802444149427 | -122.40435851653 | (37.802444149427, -122.40435851653) | 3 | 1 | 10 | 308 | 23 | |||
| 166016 | 224474 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 338 Hoffman Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6000612.12838 | 2101784.39225 | 37.7511336115404 | -122.440736915289 | (37.7511336115404, -122.440736915289) | 2 | 4 | 5 | 28862 | 22 | |||
| 169037 | 126610 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 2843 Larkin St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6006456.53687 | 2121049.16702 | 37.8043611182251 | -122.421894621965 | (37.8043611182251, -122.421894621965) | 5 | 9 | 1 | 28858 | 32 | |||
| 170122 | 200197 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 3125 Jennings St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 6013691.9188 | 2090266.6644 | 37.7202445109013 | -122.394698790087 | (37.7202445109013, -122.394698790087) | 10 | 3 | 8 | 58 | 1 | |||
| 170539 | 199424 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 1700 Armstrong Ave | 6 | Side Yard : Yard | Tree | Private 2 | 8 | 6013888.74548 | 2092884.83346 | 37.7274444193079 | -122.394201625513 | (37.7274444193079, -122.394201625513) | 10 | 3 | 8 | 58 | 1 | ||||
| 170670 | 126611 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 45 Havens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6007634.20371 | 2119389.74396 | 37.799871105414 | -122.417701505917 | (37.799871105414, -122.417701505917) | 5 | 1 | 1 | 28858 | 32 | ||||
| 180917 | 218800 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 165 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994131.57121 | 2091005.5207 | 37.7211663078633 | -122.462365488175 | (37.7211663078633, -122.462365488175) | 9 | 8 | 6 | 28861 | 24 | |||
| 183045 | 218799 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 245 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 5993126.9598 | 2096381.93741 | 37.7358707242547 | -122.466228631255 | (37.7358707242547, -122.466228631255) | 1 | 8 | 4 | 59 | 40 | |||
| 183322 | 199425 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 981 Le Conte Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6013195.96321 | 2089497.3406 | 37.7181045146991 | -122.396359261865 | (37.7181045146991, -122.396359261865) | 10 | 3 | 8 | 58 | 1 | ||||
| 185817 | 176399 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 202 University St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008036.05207 | 2092909.69402 | 37.7271856295127 | -122.41443622767 | (37.7271856295127, -122.41443622767) | 9 | 3 | 7 | 309 | 28 | |||
| 186031 | 109254 | Undocumented 4 | Ficus carica :: Edible Fig 341 | 1533 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2015 12:00:00 AM | 3 | 3x3 | 6006572.5 | 2115603.9 | 37.78941632368 | -122.421106442083 | (37.78941632368, -122.421106442083) | 13 | 9 | 10 | 28858 | 21 | ||
| 189588 | 224476 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 3900 22nd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6002426.58546 | 2102995.56923 | 37.7545623793656 | -122.434548932106 | (37.7545623793656, -122.434548932106) | 2 | 4 | 5 | 28862 | 22 | |||
| 190219 | 126612 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 71 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6008351.9449 | 2119129.87084 | 37.7991979215137 | -122.415199439117 | (37.7991979215137, -122.415199439117) | 5 | 1 | 10 | 308 | 32 | ||||
| 191647 | 248580 | DPW Maintained 1 | Ficus carica :: Edible Fig 341 | 790 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998640.4941 | 2107685.72 | 37.7672247081746 | -122.447979846575 | (37.7672247081746, -122.447979846575) | 15 | 5 | 11 | 29492 | 9 |
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) );