Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188738 | 188738 | 204257 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1419 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994248.63466 | 2105844.7666700003 | 37.76191790830379 | -122.463036948099 | (37.7619179083038, -122.463036948099) | |||
| 188486 | 188486 | 221147 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 67 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997069.00247 | 2106158.7586 | 37.762942108409796 | -122.453305126128 | (37.7629421084098, -122.453305126128) | |||
| 187853 | 187853 | 221145 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 116 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001236.77877 | 2096472.5135700002 | 37.7365840008603 | -122.438196326893 | (37.7365840008603, -122.438196326893) | |||
| 187529 | 187529 | 38847 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 9 | Permit Number 40676 | 5989942.9457 | 2105353.4021 | 37.7603197919591 | -122.47789255007099 | (37.7603197919591, -122.477892550071) | |
| 187366 | 187366 | 204290 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5992460.07118 | 2103823.87562 | 37.756265882372105 | -122.46907574903999 | (37.7562658823721, -122.46907574904) | |||
| 186861 | 186861 | 41550 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2271 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2000 12:00:00 AM | 5 | Permit Number 42072 | 6003891.05094 | 2116280.93986 | 37.7911237785009 | -122.430432278226 | (37.7911237785009, -122.430432278226) | ||
| 186854 | 186854 | 221121 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007223.85444 | 2099725.35755 | 37.7458542799697 | -122.417726884787 | (37.7458542799697, -122.417726884787) | |||
| 186404 | 186404 | 204301 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2587 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990774.09191 | 2097816.20452 | 37.739672821342104 | -122.47446797883002 | (37.7396728213421, -122.47446797883) | |||
| 186023 | 186023 | 72370 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 3 | 5990680.359209999 | 2111038.5537900003 | 37.7759724517855 | -122.475757373153 | (37.7759724517855, -122.475757373153) | ||
| 185944 | 185944 | 204310 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 46 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993164.0182 | 2098860.62543 | 37.7426787171462 | -122.466280588701 | (37.7426787171462, -122.466280588701) | |||
| 185871 | 185871 | 204347 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1274 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995860.94831 | 2092576.5125799999 | 37.725579309912796 | -122.45650111346201 | (37.7255793099128, -122.456501113462) | |||
| 185843 | 185843 | 205560 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 417 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995109.52867 | 2100320.3860400002 | 37.7467989161433 | -122.45965932743799 | (37.7467989161433, -122.459659327438) | |||
| 185734 | 185734 | 73761 | Private 5 | Arbutus unedo :: Strawberry Tree 61 | 794-798 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 3x3 | 5990097.66816 | 2109968.1044799997 | 37.772999492868706 | -122.47769476794599 | (37.7729994928687, -122.477694767946) | |
| 185565 | 185565 | 205565 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994158.07056 | 2104987.77665 | 37.7595596188099 | -122.463287982171 | (37.7595596188099, -122.463287982171) | |||
| 185515 | 185515 | 204279 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1983 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5991574.21623 | 2101962.22104 | 37.7511030408823 | -122.47200362687799 | (37.7511030408823, -122.472003626878) | |||
| 185444 | 185444 | 34477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1818 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 11 | Permit Number 46532 | 6008722.614159999 | 2119125.18072 | 37.7992058679054 | -122.413916459984 | (37.7992058679054, -122.413916459984) | |
| 185296 | 185296 | 221110 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 251 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004257.0536400005 | 2099537.6683099996 | 37.7451715290605 | -122.42797229518601 | (37.7451715290605, -122.427972295186) | |||
| 184672 | 184672 | 205591 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 64 Linares Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994060.21953 | 2102134.15413 | 37.7517186672821 | -122.463419311054 | (37.7517186672821, -122.463419311054) | |||
| 184170 | 184170 | 73750 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 4 | 5990680.77629 | 2111023.575 | 37.7759313483187 | -122.47575483630501 | (37.7759313483187, -122.475754836305) | ||
| 183994 | 183994 | 204276 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1739 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993085.208980001 | 2103636.9214 | 37.7557886553491 | -122.466900235077 | (37.7557886553491, -122.466900235077) | |||
| 183923 | 183923 | 221163 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 271 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006196.26724 | 2101608.29317 | 37.750966512097705 | -122.421413838995 | (37.7509665120977, -122.421413838995) | |||
| 183543 | 183543 | 247359 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 247 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002737.9071 | 2109456.3066 | 37.7723196648748 | -122.433934082382 | (37.7723196648748, -122.433934082382) | |||
| 182801 | 182801 | 204224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1749 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5993399.01633 | 2103583.1375 | 37.75565908549979 | -122.465811089536 | (37.7556590854998, -122.465811089536) | |||
| 182742 | 182742 | 204296 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2251 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5990696.60564 | 2100084.40289 | 37.745896218943294 | -122.474901410681 | (37.7458962189433, -122.474901410681) | |||
| 182633 | 182633 | 205522 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 140 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995229.17437 | 2094226.12398 | 37.7300724532686 | -122.458804464253 | (37.7300724532686, -122.458804464253) | |||
| 182495 | 182495 | 181894 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1150 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989578.6544 | 2099057.611 | 37.7430120666023 | -122.47869200875799 | (37.7430120666023, -122.478692008758) | |||
| 181814 | 181814 | 74235 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6008785.22187 | 2115933.15302 | 37.79044486048821 | -122.413473942277 | (37.7904448604882, -122.413473942277) | ||
| 181411 | 181411 | 204252 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 266 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995670.74275 | 2091750.5226599998 | 37.7233004170603 | -122.457098912605 | (37.7233004170603, -122.457098912605) | |||
| 180956 | 180956 | 183541 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1414 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988516.3068 | 2097655.13 | 37.7390994813211 | -122.48226254214501 | (37.7390994813211, -122.482262542145) | |||
| 180730 | 180730 | 52680 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984555.73131 | 2111052.6848299997 | 37.7756542662383 | -122.496944783224 | (37.7756542662383, -122.496944783224) | ||
| 180426 | 180426 | 205557 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995171.1293 | 2100080.94883 | 37.746145023587204 | -122.459428982288 | (37.7461450235872, -122.459428982288) | |||
| 180309 | 180309 | 205538 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 351 Montecito Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5995944.06447 | 2094085.5653900001 | 37.7297275785675 | -122.45632285521799 | (37.7297275785675, -122.456322855218) | |||
| 179615 | 179615 | 185804 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2616 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5986840.2263 | 2101683.0761 | 37.7500615094832 | -122.48835352551201 | (37.7500615094832, -122.488353525512) | |||
| 179197 | 179197 | 204323 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 240 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992369.60469 | 2095177.2479599998 | 37.73251922258721 | -122.468759450295 | (37.7325192225872, -122.468759450295) | |||
| 179077 | 179077 | 205587 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1951 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993445.513040001 | 2102216.3023900003 | 37.7519087902701 | -122.46555099748998 | (37.7519087902701, -122.46555099749) | |||
| 179076 | 179076 | 205533 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 521 Wildwood Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5994817.03534 | 2093312.29532 | 37.7275396035522 | -122.46016309076401 | (37.7275396035522, -122.460163090764) | |||
| 178883 | 178883 | 204268 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992330.82571 | 2104590.62293 | 37.7583637012301 | -122.469578534842 | (37.7583637012301, -122.469578534842) | |||
| 178143 | 178143 | 204351 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1262 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995874.8261400005 | 2092453.7287400002 | 37.7252429715583 | -122.456444264599 | (37.7252429715583, -122.456444264599) | |||
| 178092 | 178092 | 204291 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5992458.815230001 | 2103838.74555 | 37.7563066387524 | -122.46908117467501 | (37.7563066387524, -122.469081174675) | |||
| 178003 | 178003 | 175552 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001677.55767 | 2089258.3943 | 37.716800727959104 | -122.436156270607 | (37.7168007279591, -122.436156270607) | |||
| 177906 | 177906 | 221149 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 164 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997548.8030199995 | 2106785.1121799997 | 37.7646894057032 | -122.451690854773 | (37.7646894057032, -122.451690854773) | |||
| 177639 | 177639 | 33154 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2326 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37377 | 5986110.8462 | 2099395.3559 | 37.7437374639566 | -122.490707423066 | (37.7437374639566, -122.490707423066) | |
| 176817 | 176817 | 221151 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1103 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997674.15869 | 2106717.9873 | 37.764512276151294 | -122.451252443353 | (37.7645122761513, -122.451252443353) | |||
| 176140 | 176140 | 205544 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 170 Colon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5996146.907790001 | 2094084.3221599997 | 37.7297358073576 | -122.45562151801701 | (37.7297358073576, -122.455621518017) | |||
| 175599 | 175599 | 204349 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1270 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995862.70656 | 2092545.2519599998 | 37.7254935766644 | -122.45649277584299 | (37.7254935766644, -122.456492775843) | |||
| 175542 | 175542 | 204231 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1350 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5993984.50051 | 2106375.59757 | 37.7633602131233 | -122.463989011788 | (37.7633602131233, -122.463989011788) | |||
| 175476 | 175476 | 221128 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1179 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008087.19422 | 2101084.79616 | 37.749635539752205 | -122.414837763272 | (37.7496355397522, -122.414837763272) | |||
| 174981 | 174981 | 204305 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 50 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992596.75916 | 2098788.27183 | 37.7424473062996 | -122.468236727452 | (37.7424473062996, -122.468236727452) | |||
| 174918 | 174918 | 221168 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 223 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003681.32414 | 2101551.82693 | 37.750669350924504 | -122.43010672724701 | (37.7506693509245, -122.430106727247) | |||
| 174745 | 174745 | 221101 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6009367.670080001 | 2105435.00012 | 37.7616520866991 | -122.410716993221 | (37.7616520866991, -122.410716993221) | |||
| 174350 | 174350 | 93937 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 427 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53392 | 5990582.69863 | 2112452.2597 | 37.7798484361675 | -122.476198485506 | (37.7798484361675, -122.476198485506) | |
| 174297 | 174297 | 205545 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 216 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996085.57996 | 2094275.5517900002 | 37.7302573583846 | -122.455847352172 | (37.7302573583846, -122.455847352172) | |||
| 174279 | 174279 | 175550 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001725.18782 | 2089230.405 | 37.7167265815513 | -122.435989635215 | (37.7167265815513, -122.435989635215) | |||
| 174099 | 174099 | 33231 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2553 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 9 | Permit Number 37417 | 5989219.0688 | 2097970.1761 | 37.7400053687963 | -122.479855786116 | (37.7400053687963, -122.479855786116) | |
| 174075 | 174075 | 52673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984474.785130001 | 2110952.04196 | 37.7753731862643 | -122.497217360825 | (37.7753731862643, -122.497217360825) | ||
| 174036 | 174036 | 205595 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 600x Laguna Honda Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5995550.17234 | 2099899.0902400003 | 37.74566747188229 | -122.458105148758 | (37.7456674718823, -122.458105148758) | |||
| 173956 | 173956 | 205586 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1991 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993454.343119999 | 2101948.18333 | 37.7511731133615 | -122.46550098617901 | (37.7511731133615, -122.465500986179) | |||
| 173685 | 173685 | 221102 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6009385.9447800005 | 2105435.68423 | 37.7616549897172 | -122.41065383649901 | (37.7616549897172, -122.410653836499) | |||
| 173571 | 173571 | 204337 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 519 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994945.578980001 | 2093310.0260299998 | 37.7275407654953 | -122.45971855316999 | (37.7275407654953, -122.45971855317) | |||
| 173549 | 173549 | 205553 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 65 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996579.09999 | 2094098.7113700002 | 37.7298001088785 | -122.454128429388 | (37.7298001088785, -122.454128429388) | |||
| 173118 | 173118 | 205604 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 426 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999234.008330001 | 2095000.5896599998 | 37.732428335305 | -122.4450149543 | (37.732428335305, -122.4450149543) | ||||
| 173112 | 173112 | 31244 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2530 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34927 | 5991119.10611 | 2098174.96045 | 37.740677856906 | -122.47330123797701 | (37.740677856906, -122.473301237977) | |
| 172705 | 172705 | 204228 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1701 Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990307.20481 | 2106501.61444 | 37.7634936095645 | -122.476716651764 | (37.7634936095645, -122.476716651764) | |||
| 172627 | 172627 | 125709 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009014.12735 | 2118712.39114 | 37.798088817308 | -122.412878520028 | (37.798088817308, -122.412878520028) | ||||
| 172622 | 172622 | 140385 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1745 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002953.8498 | 2113388.1282 | 37.7831277191493 | -122.433468144329 | (37.7831277191493, -122.433468144329) | |||
| 172493 | 172493 | 221117 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 456 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008030.10895 | 2096733.8302799999 | 37.7376855453496 | -122.414727289648 | (37.7376855453496, -122.414727289648) | |||
| 172175 | 172175 | 95903 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1986 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767605 | 5989131.1765 | 2101822.5426 | 37.7505778487932 | -122.480441591554 | (37.7505778487932, -122.480441591554) |
| 172101 | 172101 | 246810 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 161 Brewster St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6010258.54095 | 2098989.94927 | 37.744005315193895 | -122.407181484852 | (37.7440053151939, -122.407181484852) | |||
| 171572 | 171572 | 32717 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008227.34815 | 2115705.62066 | 37.7897887726751 | -122.415388040436 | (37.7897887726751, -122.415388040436) |
| 171437 | 171437 | 204355 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1234 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995887.801469999 | 2092235.32572 | 37.72464403389029 | -122.456383625117 | (37.7246440338903, -122.456383625117) | |||
| 171337 | 171337 | 221107 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 70 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008195.73538 | 2108004.35672 | 37.7686411661776 | -122.41495211295401 | (37.7686411661776, -122.414952112954) | |||
| 171032 | 171032 | 204272 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 347 Parnassus Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5996361.7812 | 2106543.3975299997 | 37.763957666938 | -122.455778951549 | (37.763957666938, -122.455778951549) | |||
| 170976 | 170976 | 204295 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2241 15th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991723.82776 | 2100147.7502900003 | 37.7461296298746 | -122.471354067261 | (37.7461296298746, -122.471354067261) | |||
| 170531 | 170531 | 204259 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993347.58252 | 2104972.77487 | 37.7594717019775 | -122.46608993960699 | (37.7594717019775, -122.466089939607) | |||
| 170316 | 170316 | 34716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 870 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38371 | 5981723.61752 | 2109806.49015 | 37.772066217995 | -122.506649145791 | (37.772066217995, -122.506649145791) | |
| 170226 | 170226 | 183539 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1410 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5988555.4867 | 2097656.6869 | 37.7391060350729 | -122.48212719150601 | (37.7391060350729, -122.482127191506) | |||
| 170112 | 170112 | 204342 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 102 San Ramon Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995800.6786400005 | 2092710.3492400001 | 37.7259433330051 | -122.456719134286 | (37.7259433330051, -122.456719134286) | |||
| 170079 | 170079 | 204308 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992611.27218 | 2098826.2702099998 | 37.7425524784048 | -122.46818930979299 | (37.7425524784048, -122.468189309793) | |||
| 169736 | 169736 | 40201 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 830 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 9 | Permit Number 41383 | 5983264.50092 | 2110118.09525 | 37.7730124061407 | -122.50134224763599 | (37.7730124061407, -122.501342247636) | |
| 169519 | 169519 | 204237 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 324 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992972.45072 | 2103252.5485 | 37.7547267583567 | -122.467262239174 | (37.7547267583567, -122.467262239174) | |||
| 169483 | 169483 | 185801 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2610 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5986892.0814 | 2101684.6163 | 37.750068763852205 | -122.488174323251 | (37.7500687638522, -122.488174323251) | |||
| 169257 | 169257 | 125697 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3011 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000257.02708 | 2116105.09438 | 37.790434429256 | -122.44299320909599 | (37.790434429256, -122.442993209096) | |||
| 169215 | 169215 | 204243 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 90 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5993464.526880001 | 2093539.34009 | 37.7280851251272 | -122.46485516683201 | (37.7280851251272, -122.464855166832) | |||
| 169113 | 169113 | 205608 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 549 Joost Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998524.77669 | 2094967.4645 | 37.7322968768837 | -122.447464541153 | (37.7322968768837, -122.447464541153) | |||
| 169017 | 169017 | 221160 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 200 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006597.65711 | 2097450.79452 | 37.7395735820471 | -122.419730829709 | (37.7395735820471, -122.419730829709) | |||
| 168982 | 168982 | 204226 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1773 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993406.81618 | 2103446.35455 | 37.7552839647906 | -122.465774177756 | (37.7552839647906, -122.465774177756) | |||
| 168482 | 168482 | 204344 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 103 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995714.09375 | 2092731.36577 | 37.7259960674539 | -122.457019970111 | (37.7259960674539, -122.457019970111) | |||
| 168453 | 168453 | 248009 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 526 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009935.92156 | 2098263.7505 | 37.7419932709619 | -122.408245826194 | (37.7419932709619, -122.408245826194) | |||
| 168364 | 168364 | 38053 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 9 | Permit Number 40249 | 6000435.904 | 2114420.5238 | 37.785819233145205 | -122.442253327272 | (37.7858192331452, -122.442253327272) | |
| 168248 | 168248 | 221136 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 30 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005927.372280001 | 2103475.84509 | 37.7560792137102 | -122.42247639157301 | (37.7560792137102, -122.422476391573) | |||
| 168205 | 168205 | 204353 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1234 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995888.88324 | 2092255.60969 | 37.72469979093621 | -122.456381351632 | (37.7246997909362, -122.456381351632) | |||
| 168109 | 168109 | 221113 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 402 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008047.83195 | 2096931.9804900002 | 37.738230618159 | -122.414680031183 | (37.738230618159, -122.414680031183) | |||
| 167910 | 167910 | 204223 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1985 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991245.6421 | 2101938.33235 | 37.751018429965704 | -122.473138117152 | (37.7510184299657, -122.473138117152) | |||
| 167664 | 167664 | 205574 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993983.2221 | 2097029.04502 | 37.7376968876071 | -122.463315159687 | (37.7376968876071, -122.463315159687) | |||
| 167359 | 167359 | 221131 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3527 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006737.70581 | 2104354.43328 | 37.7585372937873 | -122.419736318288 | (37.7585372937873, -122.419736318288) | |||
| 167069 | 167069 | 187480 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1888 Geneva Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004820.44605 | 2086842.7727 | 37.710346011228104 | -122.42512105938299 | (37.7103460112281, -122.425121059383) | |||
| 166849 | 166849 | 221108 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1180 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010002.18992 | 2102348.16897 | 37.7532118971222 | -122.40830470751301 | (37.7532118971222, -122.408304707513) | |||
| 166307 | 166307 | 175553 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 410 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001661.33875 | 2089268.82238 | 37.716828439656794 | -122.43621307719299 | (37.7168284396568, -122.436213077193) | |||
| 165373 | 165373 | 204261 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992420.194 | 2104928.42371 | 37.7592963782498 | -122.46929404958401 | (37.7592963782498, -122.469294049584) | |||
| 165366 | 165366 | 205592 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 30 Vasquez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5995689.638259999 | 2100080.55801 | 37.7461737497157 | -122.457636027276 | (37.7461737497157, -122.457636027276) |
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");