Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5340 | 5340 | 30595 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34562 | ||||||||
| 8932 | 8932 | 19577 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 15903 | 15903 | 20055 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 109990 | 109990 | 35000 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8028 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | Permit Number 38578 | 5982135.81465862 | 2112401.83483279 | 37.7792165374199 | -122.50541575084101 | (37.7792165374199, -122.505415750841) | |||
| 135969 | 135969 | 32347 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 10 | Permit Number 37068 | 5985187.3443 | 2106976.3651 | 37.764498837803394 | -122.494459352499 | (37.7644988378034, -122.494459352499) | |
| 74936 | 74936 | 42897 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 7 | Permit Number 42813 | 5986657.8903 | 2096958.6583 | 37.737078880033 | -122.488636837876 | (37.737078880033, -122.488636837876) | |
| 103259 | 103259 | 33256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2669 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1996 12:00:00 AM | Permit Number 37434 | 5986956.33101058 | 2097199.71207947 | 37.7377581609646 | -122.48762271062598 | (37.7377581609646, -122.487622710626) | |||
| 65658 | 65658 | 183506 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2542 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988021.6131 | 2097993.9577 | 37.7400010259161 | -122.483997786352 | (37.7400010259161, -122.483997786352) | |||
| 75611 | 75611 | 182146 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5989681.6149 | 2103872.2722 | 37.756237834999 | -122.478688039412 | (37.756237834999, -122.478688039412) | |||
| 32938 | 32938 | 203645 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991098.28096 | 2098726.3101 | 37.7421905156936 | -122.473413447294 | (37.7421905156936, -122.473413447294) | |||
| 55462 | 55462 | 113717 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991400.52029 | 2110673.00421 | 37.775010478076794 | -122.47323950591299 | (37.7750104780768, -122.473239505913) | |||
| 103976 | 103976 | 98341 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 790X 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | |||
| 98067 | 98067 | 98339 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3434 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992637.0 | 2110058.2 | 37.77339390860929 | -122.468917542393 | (37.7733939086093, -122.468917542393) | ||||
| 162565 | 162565 | 203221 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2398 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5992664.0139 | 2099193.92326 | 37.7435650062179 | -122.468033683007 | (37.7435650062179, -122.468033683007) | |||
| 179662 | 179662 | 203222 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 120 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993081.79545 | 2099194.6713799997 | 37.7435911783029 | -122.466589164064 | (37.7435911783029, -122.466589164064) | |||
| 158134 | 158134 | 203631 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5993837.01835 | 2094842.09298 | 37.7316836345786 | -122.46366197331801 | (37.7316836345786, -122.463661973318) | |||
| 157925 | 157925 | 203650 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5993848.38247 | 2094813.0241599998 | 37.7316044735649 | -122.46362057664699 | (37.7316044735649, -122.463620576647) | |||
| 62900 | 62900 | 203646 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 45 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994072.18954 | 2100047.28757 | 37.745989350944 | -122.463226505408 | (37.745989350944, -122.463226505408) | |||
| 133071 | 133071 | 203620 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 358 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994207.97815 | 2101247.70705 | 37.7492932209146 | -122.46284404261101 | (37.7492932209146, -122.462844042611) | |||
| 64167 | 64167 | 203628 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 133 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994258.53071 | 2095683.80268 | 37.734019041749 | -122.46226575516701 | (37.734019041749, -122.462265755167) | |||
| 128285 | 128285 | 32890 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
| 156503 | 156503 | 174960 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994409.5991400005 | 2086788.1181299998 | 37.709602327657706 | -122.461098897396 | (37.7096023276577, -122.461098897396) | |||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 77653 | 77653 | 109672 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 173115 | 173115 | 203638 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994537.11563 | 2090599.0913099998 | 37.720073694513104 | -122.46093420637101 | (37.7200736945131, -122.460934206371) | |||
| 144602 | 144602 | 43706 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 503 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43349 | 5995017.92037976 | 2088722.8136211003 | 37.7149495354327 | -122.459136447344 | (37.7149495354327, -122.459136447344) | ||
| 123758 | 123758 | 33190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 76 Hernandez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37397 | 5996015.45875929 | 2099706.92373099 | 37.7451665539633 | -122.456482373988 | (37.7451665539633, -122.456482373988) | ||
| 93809 | 93809 | 203623 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997330.81089 | 2099592.0734900003 | 37.744926631064 | -122.45192585212 | (37.744926631064, -122.45192585212) | |||
| 154005 | 154005 | 248396 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997671.1383 | 2108143.749 | 37.768426881635605 | -122.45136572862499 | (37.7684268816356, -122.451365728625) | |||
| 109830 | 109830 | 39623 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41021 | 5997705.33041065 | 2106460.2771729 | 37.7638064542355 | -122.451126043319 | (37.7638064542355, -122.451126043319) | ||
| 93386 | 93386 | 41149 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1653 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | Permit Number 41881 | 5997742.91613306 | 2108148.62427098 | 37.7684443776569 | -122.45111780839 | (37.7684443776569, -122.45111780839) | |||
| 54361 | 54361 | 203635 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997950.41926 | 2094116.13567 | 37.7299264906077 | -122.44938890058201 | (37.7299264906077, -122.449388900582) | |||
| 116996 | 116996 | 42372 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 53649 | 53649 | 219989 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998793.85425 | 2106724.38466 | 37.7645938887298 | -122.447380197361 | (37.7645938887298, -122.447380197361) | |||
| 140403 | 140403 | 1378 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 65 Amethyst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1998 12:00:00 AM | 7 | 1X1 | 5998886.878159099 | 2099985.9166978 | 37.746097033504896 | -122.44657360851801 | (37.7460970335049, -122.446573608518) | ||
| 145663 | 145663 | 50449 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1418 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47096 | 5998923.01373461 | 2108365.57348999 | 37.7691075589972 | -122.44705158673901 | (37.7691075589972, -122.447051586739) | |||
| 20126 | 20126 | 22809 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 19 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3 | 3x3 | 5998930.058209999 | 2099793.7189700003 | 37.745571771416294 | -122.446410473673 | (37.7455717714163, -122.446410473673) | ||
| 67963 | 67963 | 220015 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998973.5201 | 2099794.49518 | 37.745576384946 | -122.44626024553601 | (37.745576384946, -122.446260245536) | |||
| 95424 | 95424 | 42113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 136 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42412 | 5999169.44681663 | 2093518.27568943 | 37.7283545633122 | -122.445131627679 | (37.7283545633122, -122.445131627679) | ||
| 122677 | 122677 | 50470 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3010X Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 3x3 | Permit Number 47106 | 5999184.20401146 | 2119093.85477845 | 37.798579545974704 | -122.446920252577 | (37.7985795459747, -122.446920252577) | ||
| 75622 | 75622 | 203667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999360.3584 | 2093511.22392 | 37.7283460957947 | -122.444471133337 | (37.7283460957947, -122.444471133337) | |||
| 91322 | 91322 | 42334 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 207 Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42540 | 5999365.95160297 | 2094049.74226531 | 37.7298250607238 | -122.444490484515 | (37.7298250607238, -122.444490484515) | ||
| 7598 | 7598 | 103885 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999418.3529 | 2110865.7399 | 37.7760006689038 | -122.445518048679 | (37.7760006689038, -122.445518048679) | ||||
| 156262 | 156262 | 140103 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1720 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999438.9967 | 2110868.4473 | 37.776009281241 | -122.44544683133002 | (37.776009281241, -122.44544683133) | |||
| 98224 | 98224 | 40633 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | Permit Number 41908 | 5999539.52102625 | 2107847.36223217 | 37.7677198855431 | -122.44488187524901 | (37.7677198855431, -122.444881875249) | |||
| 35471 | 35471 | 140101 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 771 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999584.517999999 | 2111094.1746 | 37.7766373769699 | -122.44495966716002 | (37.7766373769699, -122.44495966716) | |||
| 157543 | 157543 | 139098 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2600 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999639.9141 | 2113670.3506 | 37.7837140544374 | -122.44495327295601 | (37.7837140544374, -122.444953272956) | |||
| 22329 | 22329 | 248977 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 748 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999650.0 | 2111146.0 | 37.7767834132689 | -122.444736872581 | (37.7767834132689, -122.444736872581) | ||||
| 41593 | 41593 | 220031 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 541 Grand View Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6000040.44223 | 2101732.89415 | 37.7509596367958 | -122.44271016275101 | (37.7509596367958, -122.442710162751) | |||
| 30607 | 30607 | 38043 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8 | Permit Number 40245 | 6000097.0958 | 2114311.3232 | 37.7855000811005 | -122.44341765838199 | (37.7855000811005, -122.443417658382) | |
| 69451 | 69451 | 38054 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/01/1999 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | |
| 54226 | 54226 | 137665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000382.7272 | 2111637.7254 | 37.778175352566 | -122.44223746490101 | (37.778175352566, -122.442237464901) | |||
| 42577 | 42577 | 139655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 848 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000491.15 | 2111934.8144 | 37.7789972619427 | -122.441883720544 | (37.7789972619427, -122.441883720544) | |||
| 168067 | 168067 | 38049 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.78601418351771 | -122.44200495026199 | (37.7860141835177, -122.442004950262) | |
| 41760 | 41760 | 203657 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 226 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6000556.64604 | 2094979.3129099999 | 37.7324453144793 | -122.440440771241 | (37.7324453144793, -122.440440771241) | |||
| 125571 | 125571 | 220042 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 890 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6000646.62015 | 2102597.34113 | 37.7533677370469 | -122.440675944861 | (37.7533677370469, -122.440675944861) | |||
| 25732 | 25732 | 220090 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Ord Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000882.83826 | 2105748.10477 | 37.7620324153945 | -122.44008496885401 | (37.7620324153945, -122.440084968854) | |||
| 124870 | 124870 | 98708 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 105X Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | |||||
| 88925 | 88925 | 50661 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 114454 | 114454 | 108678 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773206 | 6000980.19802 | 2092997.8380200001 | 37.727028748485395 | -122.43883451276501 | (37.7270287484854, -122.438834512765) |
| 185200 | 185200 | 220017 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001185.230140001 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | |||
| 168971 | 168971 | 220018 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1129 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6001364.34858 | 2100418.37342 | 37.7474256590636 | -122.43803782498999 | (37.7474256590636, -122.43803782499) | |||
| 180473 | 180473 | 40818 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 9 | Permit Number 41760 | 6001596.2583 | 2114468.8718 | 37.786018048063 | -122.438242299207 | (37.786018048063, -122.438242299207) | ||
| 86900 | 86900 | 19282 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.43816511087601 | (37.786078645055, -122.438165110876) | |||
| 84208 | 84208 | 38069 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1654X SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |||
| 98941 | 98941 | 117044 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2297 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001629.48989293 | 2114242.74964382 | 37.785399064529294 | -122.438111123258 | (37.7853990645293, -122.438111123258) | |||
| 164961 | 164961 | 138533 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2299 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001645.5525 | 2114240.3384 | 37.7853933573613 | -122.438055378776 | (37.7853933573613, -122.438055378776) | |||
| 129296 | 129296 | 117035 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 149037 | 149037 | 70299 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 9 | 6001826.3531599995 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | ||
| 96769 | 96769 | 36919 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 699 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900.0 | 2102596.0 | 37.7534353511669 | -122.43634140628299 | (37.7534353511669, -122.436341406283) | ||
| 130349 | 130349 | 220027 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001922.66093 | 2102622.7782400004 | 37.7535101653675 | -122.43626495635701 | (37.7535101653675, -122.436264956357) | |||
| 159913 | 159913 | 138338 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001931.2408 | 2114335.4048 | 37.7856706283151 | -122.437073793387 | (37.7856706283151, -122.437073793387) | |||
| 129666 | 129666 | 38525 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3031 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/1998 12:00:00 AM | 11 | Permit Number 40508 | 6001946.95136 | 2118602.5164799998 | 37.7973879072825 | -122.437325094293 | (37.7973879072825, -122.437325094293) | ||
| 33357 | 33357 | 220021 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001964.613530001 | 2100084.23013 | 37.7465422991033 | -122.435938247064 | (37.7465422991033, -122.435938247064) | |||
| 119240 | 119240 | 31447 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 237 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35021 | 6002092.35921293 | 2104483.01837557 | 37.7586275781293 | -122.435811191936 | (37.7586275781293, -122.435811191936) | ||
| 45153 | 45153 | 140717 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002162.097 | 2110427.6982 | 37.774954171002 | -122.43599537996201 | (37.774954171002, -122.435995379962) | |||
| 109113 | 109113 | 99760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4247 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Most likely planted/permitted with tree no. 1 on same day/permit. | 6002269.0 | 2101186.0 | 37.7495847859814 | -122.434964495609 | (37.7495847859814, -122.434964495609) | |||
| 159982 | 159982 | 220096 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002436.28409 | 2096397.8300700001 | 37.736447085360105 | -122.43404379100402 | (37.7364470853601, -122.434043791004) | |||
| 92933 | 92933 | 120549 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4098 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6002569.0 | 2102434.0 | 37.7530285274797 | -122.434016285558 | (37.7530285274797, -122.434016285558) | |||
| 120080 | 120080 | 44452 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 81 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002608.3273599995 | 2086901.1112400002 | 37.710380983162395 | -122.43277076016399 | (37.7103809831624, -122.432770760164) | ||
| 185093 | 185093 | 220033 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 502 28th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6002622.25428 | 2099488.24408 | 37.7449431983695 | -122.433621612357 | (37.7449431983695, -122.433621612357) | ||||
| 49170 | 49170 | 220036 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002636.29383 | 2100481.40221 | 37.747670974341396 | -122.43364403244 | (37.7476709743414, -122.43364403244) | |||
| 124166 | 124166 | 35786 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 580 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39038 | 6002648.18507624 | 2102127.11023082 | 37.752190374612205 | -122.433720516444 | (37.7521903746122, -122.433720516444) | |||
| 133605 | 133605 | 220082 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 780 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003052.51993 | 2103630.15774 | 37.7563403210743 | -122.43242960863701 | (37.7563403210743, -122.432429608637) | |||
| 52495 | 52495 | 220079 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4021 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003566.56829 | 2104171.42308 | 37.7578556427516 | -122.43069047448799 | (37.7578556427516, -122.430690474488) | |||
| 122534 | 122534 | 39505 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 216 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.42999018002399 | (37.7508086831914, -122.429990180024) | ||
| 80404 | 80404 | 37853 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 639 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40143 | 6003947.74961722 | 2091786.98448726 | 37.723872400431496 | -122.428489463759 | (37.7238724004315, -122.428489463759) | ||
| 12958 | 12958 | 37815 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003965.721940001 | 2090553.1315400002 | 37.7204855291627 | -122.42833943800899 | (37.7204855291627, -122.428339438009) |
| 132605 | 132605 | 142261 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 575 LINDEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004683.1776 | 2110693.6136 | 37.775827208405104 | -122.427293365492 | (37.7758272084051, -122.427293365492) | |||
| 152034 | 152034 | 124751 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 566 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004689.62752 | 2110692.77739 | 37.775825277144705 | -122.427270993988 | (37.7758252771447, -122.427270993988) | |||
| 185398 | 185398 | 220685 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 452 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004772.24556 | 2110355.93232 | 37.774905054848396 | -122.426961200922 | (37.7749050548484, -122.426961200922) | |||
| 53685 | 53685 | 220687 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004894.475319999 | 2110399.44382 | 37.775031437471704 | -122.426541481018 | (37.7750314374717, -122.426541481018) | |||
| 173572 | 173572 | 245839 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005015.8911 | 2110507.8578 | 37.775335978986796 | -122.4261291969 | (37.7753359789868, -122.4261291969) | |||
| 144563 | 144563 | 35559 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 801 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38931 | 6005679.14966284 | 2104317.39620731 | 37.7583759105796 | -122.423394653078 | (37.7583759105796, -122.423394653078) | ||
| 187340 | 187340 | 220676 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005782.66085 | 2104298.9799099998 | 37.7583311853523 | -122.423035356192 | (37.7583311853523, -122.423035356192) | |||
| 5055 | 5055 | 253765 | Significant Tree 6 | Acacia baileyana :: Bailey's Acacia 42 | 1366 Guerrero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | ||||
| 125085 | 125085 | 39221 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1143 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.752900946135604 | -122.422831161336 | (37.7529009461356, -122.422831161336) | ||
| 162065 | 162065 | 220000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 62 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006013.90538 | 2097631.08265 | 37.7400357112669 | -122.421761996217 | (37.7400357112669, -122.421761996217) | |||
| 111352 | 111352 | 43148 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Gambier St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42961 | 6006052.5972483 | 2092387.2151737 | 37.7256393916299 | -122.421255939073 | (37.7256393916299, -122.421255939073) | |||
| 32463 | 32463 | 174965 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1645 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006090.3331 | 2092391.29935 | 37.725652733270294 | -122.42112577893101 | (37.7256527332703, -122.421125778931) |
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");