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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53893 | 53893 | 205569 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 100 Santa Monica Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5993966.5050099995 | 2097132.29462 | 37.737979422216604 | -122.46338044867201 | (37.7379794222166, -122.463380448672) | |||
| 162700 | 162700 | 204343 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 101 San Ramon Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995730.23226 | 2092715.80427 | 37.725954266071 | -122.456963055597 | (37.725954266071, -122.456963055597) | |||
| 24410 | 24410 | 204341 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 102 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995790.71137 | 2092717.35001 | 37.725961983138596 | -122.45675409635 | (37.7259619831386, -122.45675409635) | |||
| 31995 | 31995 | 204340 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 102 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995780.03889 | 2092724.36521 | 37.7259806323898 | -122.456791497325 | (37.7259806323898, -122.456791497325) | |||
| 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) | |||
| 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) | |||
| 61422 | 61422 | 175560 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 105 Burrows St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6011176.06814 | 2093472.4733799999 | 37.728906802388394 | -122.403620739722 | (37.7289068023884, -122.403620739722) | ||||
| 6505 | 6505 | 20152 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1057 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1997 12:00:00 AM | 12 | 3X3 | 6002876.4729 | 2111952.9425 | 37.7791826693541 | -122.433633233262 | (37.7791826693541, -122.433633233262) | ||
| 50526 | 50526 | 72443 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 11 | 6008813.774540001 | 2115937.32557 | 37.790457920444005 | -122.413375446746 | (37.790457920444, -122.413375446746) | ||
| 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) | ||
| 81742 | 81742 | 52727 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 10@ MARKET Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2006 12:00:00 AM | Permit Number 48783 | 5999674.65009068 | 2101508.9182706 | 37.7503237940053 | -122.443959012396 | (37.7503237940053, -122.443959012396) | |||
| 47076 | 47076 | 221171 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 11 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000910.085469999 | 2105681.05677 | 37.761849869193 | -122.43998592380501 | (37.761849869193, -122.439985923805) | |||
| 131982 | 131982 | 221172 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 11 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000923.42132 | 2105688.65448 | 37.7618714897953 | -122.43994034528 | (37.7618714897953, -122.43994034528) | |||
| 163991 | 163991 | 204318 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 110 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994644.68067 | 2099578.49879 | 37.7447351384188 | -122.461212946744 | (37.7447351384188, -122.461212946744) | |||
| 55729 | 55729 | 221138 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 110 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003494.94443 | 2095122.0497700002 | 37.733004107356294 | -122.430292564064 | (37.7330041073563, -122.430292564064) | |||
| 89002 | 89002 | 119272 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1101 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | 3x3 | 6009465.43944441 | 2117056.87897214 | 37.793568508665295 | -122.41119983681601 | (37.7935685086653, -122.411199836816) | ||
| 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) | |||
| 23602 | 23602 | 221152 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1107 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997675.68991 | 2106703.68443 | 37.7644730917729 | -122.45124611571899 | (37.7644730917729, -122.451246115719) | |||
| 146670 | 146670 | 221162 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 112 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007705.04092 | 2107226.74413 | 37.7664784387541 | -122.416594298407 | (37.7664784387541, -122.416594298407) | |||
| 147953 | 147953 | 33095 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1127 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37338 | 6011115.1734 | 2118807.4721 | 37.798467596260096 | -122.405614950876 | (37.7984675962601, -122.405614950876) | |
| 91737 | 91737 | 40467 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 113 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41552 | 6007405.69792358 | 2097686.69945555 | 37.7402668106935 | -122.416953676795 | (37.7402668106935, -122.416953676795) | ||
| 110504 | 110504 | 63153 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1135 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1996 12:00:00 AM | Permit Number 23689 | 6001346.37062481 | 2112270.98254885 | 37.7799689896828 | -122.438949272681 | (37.7799689896828, -122.438949272681) | ||
| 55600 | 55600 | 205571 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 114 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993972.11 | 2097104.0492 | 37.7379021902407 | -122.463359020507 | (37.7379021902407, -122.463359020507) | |||
| 74800 | 74800 | 205572 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 114 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993972.50918 | 2097090.3840400001 | 37.737864692108396 | -122.46335664900299 | (37.7378646921084, -122.463356649003) | |||
| 161057 | 161057 | 205573 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 114 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993978.105 | 2097062.9530599997 | 37.7377896958481 | -122.46333531168399 | (37.7377896958481, -122.463335311684) | |||
| 62765 | 62765 | 204356 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 115 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993540.12543 | 2093746.7635599999 | 37.72865901758121 | -122.46460887759501 | (37.7286590175812, -122.464608877595) | |||
| 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) | |||
| 108912 | 108912 | 53551 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 116 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49757 | 5997037.05674347 | 2089332.93754069 | 37.7167406655365 | -122.452201492855 | (37.7167406655365, -122.452201492855) | ||
| 34588 | 34588 | 175559 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 116 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009960.74638 | 2095001.17625 | 37.7330363336401 | -122.407929970784 | (37.7330363336401, -122.407929970784) | |||
| 77765 | 77765 | 53374 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 116 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28184 | 6001229.12577462 | 2096449.65021028 | 37.736520788133795 | -122.438221149135 | (37.7365207881338, -122.438221149135) | ||
| 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) | |||
| 53433 | 53433 | 125701 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009113.9445 | 2117050.28629 | 37.7935306880345 | -122.412415576041 | (37.7935306880345, -122.412415576041) | |||
| 130310 | 130310 | 125702 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009077.34196 | 2117044.73858 | 37.7935134012698 | -122.41254183184799 | (37.7935134012698, -122.412541831848) | |||
| 98918 | 98918 | 69214 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1179 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33265 | 6008096.22978477 | 2101070.94205252 | 37.7495980071801 | -122.41480553750601 | (37.7495980071801, -122.414805537506) | ||
| 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) | |||
| 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) | |||
| 33880 | 33880 | 221109 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 119 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010247.14882 | 2100206.80415 | 37.7473458954989 | -122.407306641714 | (37.7473458954989, -122.407306641714) | |||
| 73363 | 73363 | 221175 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 12 Harper St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003647.35411 | 2098226.9504 | 37.741538088122 | -122.429987049969 | (37.741538088122, -122.429987049969) | |||
| 68108 | 68108 | 204309 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 12 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992950.0965599995 | 2099014.34812 | 37.7430884554677 | -122.467031435369 | (37.7430884554677, -122.467031435369) | |||
| 160448 | 160448 | 32341 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 120 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 6 | Permit Number 47986 | 6010882.28946 | 2093426.3819099998 | 37.728763829978796 | -122.404633115548 | (37.7287638299788, -122.404633115548) | ||
| 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) | |||
| 33243 | 33243 | 204317 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Merced Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994559.82289 | 2099500.03958 | 37.7445148251981 | -122.461500679435 | (37.7445148251981, -122.461500679435) | |||
| 31054 | 31054 | 205576 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993987.58227 | 2096991.7389900002 | 37.737594705717896 | -122.463297378285 | (37.7375947057179, -122.463297378285) | |||
| 137831 | 137831 | 205575 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993984.55624 | 2097010.92185 | 37.7376472027498 | -122.46330923223101 | (37.7376472027498, -122.463309232231) | |||
| 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) | |||
| 57442 | 57442 | 221174 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1200 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002497.99199 | 2102014.4417 | 37.751872490040896 | -122.43423185273899 | (37.7518724900409, -122.434231852739) | |||
| 106575 | 106575 | 32837 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1200-1204 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37192 | 6002497.0 | 2102089.0 | 37.7520771531238 | -122.434240612887 | (37.7520771531238, -122.434240612887) | |||
| 46333 | 46333 | 204239 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 121 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993619.97762 | 2103217.3793599997 | 37.7546675514915 | -122.4650203786 | (37.7546675514915, -122.4650203786) | |||
| 111221 | 111221 | 68066 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 121 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31803 | 5993676.81439849 | 2103217.1644166 | 37.7546702384285 | -122.464823807653 | (37.7546702384285, -122.464823807653) | ||
| 30971 | 30971 | 188230 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012869.68369 | 2113682.0678 | 37.784492396237 | -122.39918379321001 | (37.784492396237, -122.39918379321) | |||
| 148224 | 148224 | 188231 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012859.425559999 | 2113671.68237 | 37.7844633085723 | -122.399218553795 | (37.7844633085723, -122.399218553795) | |||
| 71310 | 71310 | 204354 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1234 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995888.21691 | 2092244.70603 | 37.72466981383379 | -122.456382866969 | (37.7246698138338, -122.456382866969) | |||
| 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) | |||
| 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) | |||
| 98761 | 98761 | 204293 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 124 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 5993603.8127 | 2103274.64542 | 37.754823857236204 | -122.46508043981599 | (37.7548238572362, -122.465080439816) | |||
| 108890 | 108890 | 68067 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 124 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 11 | Permit Number 31804 | 5993663.47634058 | 2103268.81441412 | 37.754811287000706 | -122.464873684633 | (37.7548112870007, -122.464873684633) | |
| 50056 | 50056 | 204352 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1246 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995887.56291 | 2092328.7848 | 37.7249006365325 | -122.456391204617 | (37.7249006365325, -122.456391204617) | |||
| 119584 | 119584 | 40760 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 125 De Soto St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2000 12:00:00 AM | Permit Number 41726 | 5993244.02089224 | 2091981.15429222 | 37.723794012147 | -122.46550430814301 | (37.723794012147, -122.465504308143) | ||
| 73395 | 73395 | 205551 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 125 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996483.1105 | 2094435.6321900003 | 37.7307197079512 | -122.45448460318501 | (37.7307197079512, -122.454484603185) | |||
| 75669 | 75669 | 221143 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1260 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003205.08154 | 2100879.73263 | 37.748796953421 | -122.431705632822 | (37.748796953421, -122.431705632822) | |||
| 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) | |||
| 158369 | 158369 | 175548 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 127 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 5999115.8036400005 | 2089145.41882 | 37.7163446448588 | -122.44500284583 | (37.7163446448588, -122.44500284583) | |||
| 53732 | 53732 | 204350 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1270 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995864.13601 | 2092529.71937 | 37.725451009950206 | -122.456486711691 | (37.7254510099502, -122.456486711691) | |||
| 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) | |||
| 28051 | 28051 | 204348 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1274 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995861.784 | 2092564.0492599998 | 37.7255451365929 | -122.456497323712 | (37.7255451365929, -122.456497323712) | |||
| 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) | |||
| 32233 | 32233 | 204292 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 128 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5993577.25837 | 2103274.10161 | 37.7548208328355 | -122.465172231806 | (37.7548208328355, -122.465172231806) | |||
| 110975 | 110975 | 68068 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 128 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 10 | Permit Number 31805 | 5993651.58024335 | 2103268.48440829 | 37.754809694989795 | -122.46491480033 | (37.7548096949898, -122.46491480033) | |
| 32431 | 32431 | 204346 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1280 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995860.5873 | 2092590.7127099999 | 37.7256182793497 | -122.45650338783399 | (37.7256182793497, -122.456503387834) | |||
| 2752 | 2752 | 204285 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 130 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 0 | Width 4ft | Permit Number 778704 | 5994440.258090001 | 2105345.9021900003 | 37.7605591918785 | -122.462338019278 | (37.7605591918785, -122.462338019278) | |
| 71040 | 71040 | 204320 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 130 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991863.51785 | 2095292.0788 | 37.732805269054 | -122.47051745762501 | (37.732805269054, -122.470517457625) | |||
| 131301 | 131301 | 204319 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 130 San Rafael Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991864.608469999 | 2095274.6324099998 | 37.7327574287062 | -122.47051241691901 | (37.7327574287062, -122.470512416919) | |||
| 39876 | 39876 | 204232 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1315 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993914.77387 | 2106543.85445 | 37.7638181838945 | -122.46424238769801 | (37.7638181838945, -122.464242387698) | |||
| 44247 | 44247 | 204234 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1315 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993917.53437 | 2106478.71882 | 37.7636394975886 | -122.464228110963 | (37.7636394975886, -122.464228110963) | |||
| 56413 | 56413 | 204233 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1315 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993916.4357199995 | 2106511.98623 | 37.7637307778784 | -122.464234326155 | (37.7637307778784, -122.464234326155) | |||
| 151222 | 151222 | 204235 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1327 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993916.536730001 | 2106469.2082 | 37.7636133264094 | -122.464230870957 | (37.7636133264094, -122.464230870957) | |||
| 156838 | 156838 | 204236 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1330 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5993657.9849 | 2106425.1721 | 37.7634775090049 | -122.46512191475 | (37.7634775090049, -122.46512191475) | |||
| 158878 | 158878 | 205542 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 135 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996129.13326 | 2093930.4300400002 | 37.72931223654879 | -122.455671846797 | (37.7293122365488, -122.455671846797) | |||
| 41778 | 41778 | 204230 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1350 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5993989.00187 | 2106288.62445 | 37.7631216670493 | -122.463967129489 | (37.7631216670493, -122.463967129489) | |||
| 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) | |||
| 3364 | 3364 | 188226 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 3 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013575.41694 | 2105253.06849 | 37.7613875637091 | -122.396151246903 | (37.7613875637091, -122.396151246903) | |
| 3371 | 3371 | 188225 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 2 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013591.2999599995 | 2105254.0413599997 | 37.7613911187249 | -122.396096381957 | (37.7613911187249, -122.396096381957) | |
| 3379 | 3379 | 188227 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 4 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 5 | Width 3ft | Permit Number 37286 | 6013561.10942 | 2105252.84027 | 37.7613861409778 | -122.39620071499901 | (37.7613861409778, -122.396200714999) | |
| 19510 | 19510 | 122456 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1355x 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013550.0 | 2105274.0 | 37.7614436228031 | -122.39624062117399 | (37.7614436228031, -122.396240621174) | ||||
| 80760 | 80760 | 122457 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1355x 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013550.0 | 2105274.0 | 37.7614436228031 | -122.39624062117399 | (37.7614436228031, -122.396240621174) | ||||
| 103420 | 103420 | 122458 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1355x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013550.0 | 2105274.0 | 37.7614436228031 | -122.39624062117399 | (37.7614436228031, -122.396240621174) | ||||
| 159373 | 159373 | 38691 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 13904 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40604 | 6001240.455 | 2110421.1619 | 37.7748838228637 | -122.439183061176 | (37.7748838228637, -122.439183061176) | |
| 32074 | 32074 | 204315 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 140 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992371.69102 | 2098164.25102 | 37.740720902060204 | -122.468969536415 | (37.7407209020602, -122.468969536415) | |||
| 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) | |||
| 22943 | 22943 | 115613 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 22952 | 22952 | 115614 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 83020 | 83020 | 115619 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 114945 | 114945 | 115618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 6578 | 6578 | 9618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2000 12:00:00 AM | 7 | 3X3 | 6002831.8444 | 2112032.7875 | 37.7793993714118 | -122.43379332982599 | (37.7793993714118, -122.433793329826) | ||
| 74896 | 74896 | 183537 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1406 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5988583.1202 | 2097657.595 | 37.739110135695796 | -122.482031715061 | (37.7391101356958, -122.482031715061) | |||
| 52040 | 52040 | 48559 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1407 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | 5 | Permit Number 45875 | 5999686.8778 | 2113772.6173 | 37.7839975324947 | -122.444798150334 | (37.7839975324947, -122.444798150334) | ||
| 136087 | 136087 | 183538 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1408 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5988570.9251 | 2097656.2977 | 37.7391058643676 | -122.482073784664 | (37.7391058643676, -122.482073784664) | |||
| 40423 | 40423 | 205523 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996002.48703 | 2093720.2917099998 | 37.7287279785 | -122.456094484996 | (37.7287279785, -122.456094484996) | |||
| 65595 | 65595 | 205524 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995982.8575 | 2093718.26393 | 37.7287212839559 | -122.456162198553 | (37.7287212839559, -122.456162198553) | |||
| 157656 | 157656 | 205526 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995945.00881 | 2093703.6137400002 | 37.7286788854057 | -122.456291984186 | (37.7286788854057, -122.456291984186) |
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");