Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50490 | 50490 | 2506 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 1501 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/16/1999 12:00:00 AM | 3 | 3x3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | ||
| 16443 | 16443 | 2539 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 1575 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/05/1999 12:00:00 AM | 3 | 3X3 | 6016305.53274 | 2099035.35536 | 37.7444665522926 | -122.386275327464 | (37.7444665522926, -122.386275327464) | ||
| 8153 | 8153 | 14638 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 600X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 4x4 | 6006218.484130001 | 2112159.25458 | 37.7799382114304 | -122.42208648601601 | (37.7799382114304, -122.422086486016) | |||
| 21674 | 21674 | 16056 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 219 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000606.99528 | 2094621.48132 | 37.73146565869779 | -122.440241050681 | (37.7314656586978, -122.440241050681) | |||
| 17191 | 17191 | 16057 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 223 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000584.1346 | 2094621.9553599998 | 37.731465658714704 | -122.440320118183 | (37.7314656587147, -122.440320118183) | |||
| 21129 | 21129 | 16061 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 234 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000514.97584 | 2094701.7216599998 | 37.7316807405534 | -122.440564931622 | (37.7316807405534, -122.440564931622) | |||
| 18327 | 18327 | 16062 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 234 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000489.610780001 | 2094702.95289 | 37.731682676805605 | -122.44065271176399 | (37.7316826768056, -122.440652711764) | |||
| 21884 | 21884 | 16063 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 235 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000510.81653 | 2094624.7410400002 | 37.73146913277839 | -122.44057379176701 | (37.7314691327784, -122.440573791767) | |||
| 21004 | 21004 | 16064 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 239 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000482.86247 | 2094624.68801 | 37.7314673953084 | -122.440670430219 | (37.7314673953084, -122.440670430219) | |||
| 19001 | 19001 | 16065 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 236 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000470.32804 | 2094701.9984799998 | 37.7316789581131 | -122.440719307449 | (37.7316789581131, -122.440719307449) | |||
| 17437 | 17437 | 16066 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 236 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000441.13466 | 2094703.95832 | 37.731682676816604 | -122.44082037507401 | (37.7316826768166, -122.440820375074) | |||
| 23363 | 23363 | 16067 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 236 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6000426.63236 | 2094704.03312 | 37.7316820562622 | -122.44087051766 | (37.7316820562622, -122.44087051766) | |||
| 21795 | 21795 | 16068 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 241 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000456.47013 | 2094623.3376799999 | 37.731462184614 | -122.44076157649499 | (37.731462184614, -122.440761576495) | |||
| 21537 | 21537 | 16070 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 251 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000403.76361 | 2094624.4309200002 | 37.731462184634 | -122.440943870862 | (37.731462184634, -122.440943870862) | |||
| 107706 | 107706 | 16072 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 258 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
| 21977 | 21977 | 16078 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 259 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000361.52828 | 2094624.9906400002 | 37.7314613158879 | -122.44108992616998 | (37.7314613158879, -122.44108992617) | |||
| 18508 | 18508 | 16079 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 262 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000336.4713 | 2094705.6777299999 | 37.731681436630396 | -122.441182339604 | (37.7316814366304, -122.441182339604) | |||
| 9757 | 9757 | 16080 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 266 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000320.86003 | 2094706.9046 | 37.7316839160675 | -122.44123639873699 | (37.7316839160675, -122.441236398737) | |||
| 18515 | 18515 | 16081 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 270 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000295.71125 | 2094707.20068 | 37.7316832964356 | -122.441323364105 | (37.7316832964356, -122.441323364105) | |||
| 18649 | 18649 | 16082 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 271 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000311.38839 | 2094627.2960599998 | 37.7314647899717 | -122.441263434174 | (37.7314647899717, -122.441263434174) | |||
| 18342 | 18342 | 16083 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 263 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6000325.98058 | 2094626.3605400003 | 37.7314630524765 | -122.441212919239 | (37.7314630524765, -122.441212919239) | |||
| 21789 | 21789 | 16084 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 273 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000289.1561199995 | 2094627.44091 | 37.731463921221795 | -122.441340305536 | (37.7314639212218, -122.441340305536) | |||
| 20336 | 20336 | 16086 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 279 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000243.09762 | 2094627.4476700001 | 37.731461315874206 | -122.44149953856702 | (37.7314613158742, -122.441499538567) | |||
| 20872 | 20872 | 16089 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 281 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000204.672619999 | 2094627.9285799998 | 37.7314604471408 | -122.441632415216 | (37.7314604471408, -122.441632415216) | |||
| 17401 | 17401 | 16090 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 282 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000233.37509 | 2094706.4626900002 | 37.7316777188345 | -122.44153881915399 | (37.7316777188345, -122.441538819154) | |||
| 123033 | 123033 | 16091 | DPW Maintained 3 | Cupaniopsis anacardioides :: Carrotwood 118 | 284 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000198.548030901 | 2094712.9146897998 | 37.7316934502774 | -122.44165968578001 | (37.7316934502774, -122.44165968578) | |||
| 7998 | 7998 | 18857 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2205 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004122.834530001 | 2115986.40617 | 37.7903281905406 | -122.429609299623 | (37.7903281905406, -122.429609299623) | |||
| 7979 | 7979 | 18858 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2205 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 3 | 3X3 | 6004161.3463 | 2115991.64976 | 37.7903447686476 | -122.429476425706 | (37.7903447686476, -122.429476425706) | ||
| 5991 | 5991 | 18923 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2671 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2000 12:00:00 AM | 6 | 4X4 | 6002050.10915 | 2115698.07724 | 37.7894189336721 | -122.436760123981 | (37.7894189336721, -122.436760123981) | ||
| 174410 | 174410 | 32057 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3525 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | 4 | Permit Number 46894 | 6005365.81768 | 2106030.42117 | 37.7630617839077 | -122.424600148687 | (37.7630617839077, -122.424600148687) | ||
| 81595 | 81595 | 32527 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 6 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37029 | 6007006.64286664 | 2095736.82242552 | 37.734890424251496 | -122.41819524564899 | (37.7348904242515, -122.418195245649) | ||
| 118866 | 118866 | 32528 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 17 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37030 | 6007054.5480271 | 2095691.64868794 | 37.734769083447205 | -122.418026418979 | (37.7347690834472, -122.418026418979) | ||
| 57033 | 57033 | 32623 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 39 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37079 | 6011706.3965300005 | 2110130.09648 | 37.7746746089772 | -122.402958479854 | (37.7746746089772, -122.402958479854) | |
| 100833 | 100833 | 32757 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 145468 | 145468 | 32758 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 124807 | 124807 | 32759 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) | ||
| 108363 | 108363 | 32760 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 100x THRIFT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37135 | 5995486.0 | 2089629.0 | 37.7174646081384 | -122.45758410365801 | (37.7174646081384, -122.457584103658) |
| 121590 | 121590 | 33418 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 498X KENWOOD WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | 2 | Permit Number 37528 | 5993404.0 | 2093661.0 | 37.7284156834141 | -122.46507324106301 | (37.7284156834141, -122.465073241063) | |
| 114283 | 114283 | 33419 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 498X KENWOOD WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | 2 | Permit Number 37528 | 5993404.0 | 2093661.0 | 37.7284156834141 | -122.46507324106301 | (37.7284156834141, -122.465073241063) | |
| 19838 | 19838 | 33420 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 498X KENWOOD WAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | 2 | Permit Number 37528 | 5993404.0 | 2093661.0 | 37.7284156834141 | -122.46507324106301 | (37.7284156834141, -122.465073241063) | |
| 122851 | 122851 | 33431 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 127 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37535 | 5999930.67607914 | 2095733.95298446 | 37.7344817167018 | -122.44265905551799 | (37.7344817167018, -122.442659055518) | ||
| 103570 | 103570 | 33814 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 543 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37829 | 5988747.93564593 | 2111618.41829501 | 37.7774523741972 | -122.482484550136 | (37.7774523741972, -122.482484550136) | |||
| 145322 | 145322 | 33995 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38457 | 6010502.26399862 | 2099074.74698805 | 37.7442517881202 | -122.40634471521003 | (37.7442517881202, -122.40634471521) | ||
| 91336 | 91336 | 34210 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38026 | 6010548.985067501 | 2099059.00866257 | 37.7442111875512 | -122.406182054391 | (37.7442111875512, -122.406182054391) | ||
| 107956 | 107956 | 34211 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 132 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38027 | 6010446.19872622 | 2099093.63297516 | 37.7443005084973 | -122.406539908391 | (37.7443005084973, -122.406539908391) | ||
| 122799 | 122799 | 34212 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 146 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38028 | 6010380.78922037 | 2099115.666634 | 37.74435734854671 | -122.40676763416599 | (37.7443573485467, -122.406767634166) | ||
| 123357 | 123357 | 34213 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 137 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38029 | 6010403.59737914 | 2099053.11250995 | 37.7441868646564 | -122.40668436049499 | (37.7441868646564, -122.406684360495) | ||
| 109736 | 109736 | 34214 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 135 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38030 | 6010413.34787543 | 2099049.82798569 | 37.744178391599704 | -122.40665041382299 | (37.7441783915997, -122.406650413823) | ||
| 83132 | 83132 | 34215 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 123 Faith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1997 12:00:00 AM | Permit Number 38031 | 6010471.85076762 | 2099030.12086895 | 37.7441275531286 | -122.40644673425 | (37.7441275531286, -122.40644673425) | ||
| 95636 | 95636 | 34306 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38094 | 6010824.33318422 | 2102458.44647529 | 37.7535606982702 | -122.405469321452 | (37.7535606982702, -122.405469321452) | ||
| 79932 | 79932 | 34810 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 101 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38445 | 5999074.40253363 | 2089202.20922089 | 37.7164982153246 | -122.44515002823799 | (37.7164982153246, -122.445150028238) | ||
| 26963 | 26963 | 35238 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1240 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 6 | Permit Number 38734 | 6006976.68497 | 2119487.9073799998 | 37.8001036152424 | -122.419983741574 | (37.8001036152424, -122.419983741574) | |
| 117952 | 117952 | 35259 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | Permit Number 38745 | 6006261.16028369 | 2120974.78404058 | 37.8041458613164 | -122.422565451189 | (37.8041458613164, -122.422565451189) | ||
| 40845 | 40845 | 36941 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 152 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 5 | Permit Number 39580 | 5994928.17811 | 2114463.2730099997 | 37.7856211696771 | -122.46131148063401 | (37.7856211696771, -122.461311480634) | |
| 135441 | 135441 | 36943 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 152 03rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39580 | 5994926.19435 | 2114520.7878400004 | 37.7857789756862 | -122.46132251465099 | (37.7857789756862, -122.461322514651) | |
| 59130 | 59130 | 36944 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 152 03rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39580 | 5994925.42579 | 2114533.20025 | 37.785813012576206 | -122.46132607375401 | (37.7858130125762, -122.461326073754) | |
| 31916 | 31916 | 36945 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 165 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 8 | Permit Number 39581 | 5994878.4768199995 | 2114483.13102 | 37.7856728338639 | -122.461484871659 | (37.7856728338639, -122.461484871659) | |
| 161404 | 161404 | 36946 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 165 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39581 | 5994879.55101 | 2114458.4572900003 | 37.7856051482988 | -122.461479365875 | (37.7856051482988, -122.461479365875) | |
| 93015 | 93015 | 38002 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2468 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40214 | 5992067.43945644 | 2098644.28132388 | 37.742021359605104 | -122.47005645773599 | (37.7420213596051, -122.470056457736) | ||
| 128365 | 128365 | 39517 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3964 25TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40967 | 6004074.0 | 2101323.0 | 37.750063277719704 | -122.42873251065399 | (37.7500632777197, -122.428732510654) | |
| 80981 | 80981 | 39518 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3964 25TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40967 | 6004074.0 | 2101323.0 | 37.750063277719704 | -122.42873251065399 | (37.7500632777197, -122.428732510654) | |
| 73336 | 73336 | 40136 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2760 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1999 12:00:00 AM | 11 | Permit Number 41340 | 6000331.47905 | 2117521.66329 | 37.7943282005485 | -122.442837375469 | (37.7943282005485, -122.442837375469) | ||
| 123965 | 123965 | 41097 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | ||
| 125526 | 125526 | 41098 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | |||
| 85599 | 85599 | 41099 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.741600645555295 | -122.41705911631 | (37.7416006455553, -122.41705911631) | |||
| 122324 | 122324 | 42048 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 214 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42365 | 6005128.75403076 | 2099926.75275442 | 37.746289143211 | -122.424985780451 | (37.746289143211, -122.424985780451) | |||
| 141602 | 141602 | 42744 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 94957 | 94957 | 42745 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 104865 | 104865 | 42746 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 144135 | 144135 | 42747 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 104272 | 104272 | 42748 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 144300 | 144300 | 42749 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 123346 | 123346 | 42750 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 120556 | 120556 | 42751 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 121918 | 121918 | 42752 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 117521 | 117521 | 42753 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 333 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.40111229342399 | (37.7105480846287, -122.401112293424) | ||
| 188183 | 188183 | 45080 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2131 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 2 | Permit Number 43963 | 5987257.3685 | 2100779.0687 | 37.747603677476796 | -122.486844665894 | (37.7476036774768, -122.486844665894) | |
| 117542 | 117542 | 45418 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3690 Washington St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | Permit Number 44217 | 5997130.30152423 | 2115717.50370466 | 37.7891914436893 | -122.45378341626301 | (37.7891914436893, -122.453783416263) | |||
| 114050 | 114050 | 45419 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3690 Washington St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | Permit Number 44217 | 5997130.30152423 | 2115717.50370466 | 37.7891914436893 | -122.45378341626301 | (37.7891914436893, -122.453783416263) | |||
| 103388 | 103388 | 45564 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 3500 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | Permit Number 44308 | 5998062.56908828 | 2115523.19421657 | 37.788711325308 | -122.45054388629801 | (37.788711325308, -122.450543886298) | ||
| 126803 | 126803 | 45808 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 151 Charles St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2001 12:00:00 AM | Permit Number 44436 | 6004877.73984335 | 2097041.07807041 | 37.7383515558837 | -122.42564841052 | (37.7383515558837, -122.42564841052) | |||
| 141044 | 141044 | 46131 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 137 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44481 | 5997450.10216271 | 2107762.76782376 | 37.7673681457069 | -122.452102777266 | (37.7673681457069, -122.452102777266) | ||
| 86117 | 86117 | 46711 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1337 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44841 | 5996760.70858802 | 2106869.35577873 | 37.7648755513325 | -122.454422736012 | (37.7648755513325, -122.454422736012) | ||
| 65480 | 65480 | 49145 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1010 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2003 12:00:00 AM | 4 | Permit Number 46270 | 6013902.9734 | 2089731.1325 | 37.718785778664206 | -122.393931770521 | (37.7187857786642, -122.393931770521) | ||
| 101511 | 101511 | 51444 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 336 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2004 12:00:00 AM | Permit Number 47763 | 6008602.30832967 | 2097174.95707039 | 37.7389289161491 | -122.412780092695 | (37.7389289161491, -122.412780092695) | ||
| 108856 | 108856 | 52142 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2005 12:00:00 AM | Permit Number 48323 | 6005795.19032335 | 2097640.79736733 | 37.7400500494445 | -122.42251891414101 | (37.7400500494445, -122.422518914141) | ||
| 78651 | 78651 | 52377 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 8TA MARINA Gladeview Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2005 12:00:00 AM | Permit Number 48506 | 5997748.93752219 | 2101838.53853326 | 37.751118812629 | -122.450641986228 | (37.751118812629, -122.450641986228) | |||
| 102765 | 102765 | 52378 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 8TA MARINA Gladeview Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2005 12:00:00 AM | Permit Number 48506 | 5997748.93752219 | 2101838.53853326 | 37.751118812629 | -122.450641986228 | (37.751118812629, -122.450641986228) | |||
| 96045 | 96045 | 52379 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 8TA MARINA Gladeview Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2005 12:00:00 AM | Permit Number 48506 | 5997748.93752219 | 2101838.53853326 | 37.751118812629 | -122.450641986228 | (37.751118812629, -122.450641986228) | |||
| 185821 | 185821 | 57816 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 953 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | 3 | Permit Number 48159 | 6012187.5358 | 2104146.00992 | 37.7582705054092 | -122.400873595956 | (37.7582705054092, -122.400873595956) | ||
| 91947 | 91947 | 63833 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 91 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24521 | 6009354.9233329 | 2096920.48394154 | 37.738272402670106 | -122.41015992638799 | (37.7382724026701, -122.410159926388) | ||
| 171264 | 171264 | 67387 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 772 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | 6 | Permit Number 30884 | 5990710.6374699995 | 2110145.5351 | 37.77352222225821 | -122.475587411896 | (37.7735222222582, -122.475587411896) | |
| 107600 | 107600 | 67504 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 477 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1992 12:00:00 AM | Permit Number 31033 | 5997603.60235184 | 2094078.4650036998 | 37.729803210873 | -122.450585167202 | (37.729803210873, -122.450585167202) | ||
| 180539 | 180539 | 67529 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 662 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 13 | Permit Number 31067 | 6013257.86111 | 2104004.0948 | 37.757940481179205 | -122.397161966172 | (37.7579404811792, -122.397161966172) | |
| 171518 | 171518 | 68911 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 1037 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32888 | 6008631.3882 | 2118270.06785 | 37.7968528160714 | -122.414171603039 | (37.7968528160714, -122.414171603039) | |
| 172917 | 172917 | 70102 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 3016 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 5 | 5989286.3225 | 2111962.37495 | 37.778428088511795 | -122.48064729942301 | (37.7784280885118, -122.480647299423) | ||
| 61202 | 61202 | 74227 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 796 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 14 | 6011650.432519999 | 2109615.42877 | 37.773258324233495 | -122.40311586211399 | (37.7732583242335, -122.403115862114) | ||
| 92629 | 92629 | 84195 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 455 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2008 12:00:00 AM | 3x3 | Permit Number 50117 | 5999074.87038552 | 2094946.18270708 | 37.732269862610295 | -122.445561218581 | (37.7322698626103, -122.445561218581) | ||
| 27328 | 27328 | 87375 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2260 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50354 | 6002754.86508 | 2117851.80472 | 37.7953725427601 | -122.434475803729 | (37.7953725427601, -122.434475803729) | |
| 185454 | 185454 | 88660 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 601 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016339.82415 | 2102089.15306 | 37.7528535460529 | -122.38636962767299 | (37.7528535460529, -122.386369627673) |
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");