Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 121101 | 121101 | 110540 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | City College 13 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |||
| 144922 | 144922 | 110534 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | City College 13 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |||
| 13261 | 13261 | 144 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 18 | 3x3 | 6002159.27678 | 2107619.02908 | 37.7672421007673 | -122.435804136578 | (37.7672421007673, -122.435804136578) | ||
| 47263 | 47263 | 100971 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Permit Number 37341 | 6009642.5454 | 2120895.3461 | 37.8041179253888 | -122.410858257388 | (37.8041179253888, -122.410858257388) | ||
| 55605 | 55605 | 100978 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 5 | Permit Number 37341 | 6009524.0508 | 2120877.4907 | 37.8040622540071 | -122.41126705605801 | (37.8040622540071, -122.411267056058) | ||
| 57285 | 57285 | 100977 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | Permit Number 37341 | 6009542.7178 | 2120879.1139 | 37.8040677578058 | -122.411202572075 | (37.8040677578058, -122.411202572075) | ||
| 147766 | 147766 | 100979 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | Permit Number 37341 | 6009507.0071 | 2120874.2443 | 37.8040523843138 | -122.411325807727 | (37.8040523843138, -122.411325807727) | ||
| 177834 | 177834 | 100976 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 5 | Permit Number 37341 | 6009558.1383 | 2120880.7372 | 37.8040730797801 | -122.411149322876 | (37.8040730797801, -122.411149322876) | ||
| 1491 | 1491 | 110535 | Private 5 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | Private 3 | 04/21/2015 04:52:00 PM | 3 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |
| 79581 | 79581 | 117011 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 457X CASTRO ST | 1 | Back Yard : Cutout 16 | Tree 1 | MTA 6 | Private 3 | 27 | 3x6 | 6002348.0 | 2105584.0 | 37.7616651256499 | -122.435005811888 | (37.7616651256499, -122.435005811888) | ||
| 130 | 130 | 66855 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2041 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 8 | Permit Number 30161 | 5998071.2779 | 2109932.9259 | 37.7733624072524 | -122.450110663343 | (37.7733624072524, -122.450110663343) | |
| 3735 | 3735 | 63212 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 450 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 10 | Permit Number 23755 | 5984123.0 | 2112760.0 | 37.7803166927985 | -122.498567828267 | (37.7803166927985, -122.498567828267) | |
| 9674 | 9674 | 61426 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3501X 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1984 12:00:00 AM | Permit Number 21355 | 6006351.47468928 | 2100870.60661273 | 37.7489497429973 | -122.420824749243 | (37.7489497429973, -122.420824749243) | ||
| 10074 | 10074 | 60000 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1227 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 19486 | 5991400.84514705 | 2107067.03072332 | 37.76510946688521 | -122.472975370228 | (37.7651094668852, -122.472975370228) | |
| 10356 | 10356 | 75141 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 5 | 4x4 | 6005823.096940001 | 2092308.52948 | 37.7254103965462 | -122.422043716969 | (37.7254103965462, -122.422043716969) | |
| 10568 | 10568 | 75056 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 12 | 4x4 | 6005836.26564 | 2092311.52216 | 37.7254193565072 | -122.421998406407 | (37.7254193565072, -122.421998406407) | |
| 10885 | 10885 | 75223 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 5 | 3x3 | 6005812.42229 | 2092304.2308200002 | 37.7253979913003 | -122.42208031306801 | (37.7253979913003, -122.422080313068) | |
| 11652 | 11652 | 75299 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 3x3 | 6005800.51839 | 2092301.4633900002 | 37.7253897211337 | -122.422121267299 | (37.7253897211337, -122.422121267299) | |
| 11717 | 11717 | 61760 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3739 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21774 | |||||||
| 12317 | 12317 | 75378 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 3x3 | 6005787.8485 | 2092298.2096 | 37.7253800723092 | -122.422164834944 | (37.7253800723092, -122.422164834944) | |
| 12389 | 12389 | 44404 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1171 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | 5x5 | Permit Number 43757 | 6001253.36024 | 2087074.10385 | 37.710779041984296 | -122.437466181726 | (37.7107790419843, -122.437466181726) |
| 13258 | 13258 | 60325 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 335 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/2017 12:00:00 AM | 3 | Permit Number 779431 | 5986505.891009999 | 2113659.48607 | 37.7829258811438 | -122.49039060665001 | (37.7829258811438, -122.49039060665) | |
| 16871 | 16871 | 61522 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1177 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | 4x4 | Permit Number 772962 | 6012251.69921 | 2102932.86135 | 37.754943044411796 | -122.40056647116 | (37.7549430444118, -122.40056647116) |
| 17866 | 17866 | 52082 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 138 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/17/2005 12:00:00 AM | Permit Number 48280 | 6004279.40612984 | 2097417.63926751 | 37.7393516795249 | -122.427743978882 | (37.7393516795249, -122.427743978882) | ||
| 18038 | 18038 | 69250 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1838 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/1994 12:00:00 AM | Permit Number 33318 | 5991599.04334449 | 2102860.56941142 | 37.75357110789611 | -122.471983242544 | (37.7535711078961, -122.471983242544) | ||
| 18073 | 18073 | 34608 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3201 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38293 | 5999396.5502932 | 2115980.32977494 | 37.7900427611316 | -122.445961414408 | (37.7900427611316, -122.445961414408) | ||
| 18566 | 18566 | 60665 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 252 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20299 | 6004348.3258315995 | 2096924.2789461997 | 37.738000922583396 | -122.427470547071 | (37.7380009225834, -122.427470547071) | ||
| 18685 | 18685 | 63020 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 114 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1986 12:00:00 AM | Permit Number 23436 | 6007353.07984272 | 2097681.79796769 | 37.740250392327496 | -122.41713526229499 | (37.7402503923275, -122.417135262295) | ||
| 18787 | 18787 | 52295 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 170 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48456 | 6001395.21232185 | 2104838.80194346 | 37.7595648477135 | -122.438247725187 | (37.7595648477135, -122.438247725187) | ||
| 18884 | 18884 | 61111 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2916 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1983 12:00:00 AM | Permit Number 20958 | 6008785.97486998 | 2103345.01468126 | 37.755880830837604 | -122.41258110159201 | (37.7558808308376, -122.412581101592) | ||
| 19351 | 19351 | 67808 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31459 | 6000553.20461336 | 2102855.81352911 | 37.754072119422 | -122.44101753615801 | (37.754072119422, -122.441017536158) | ||
| 19359 | 19359 | 38905 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 617 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40718 | 5997126.04960675 | 2113686.45872815 | 37.783614490579296 | -122.453651409956 | (37.7836144905793, -122.453651409956) | ||
| 19846 | 19846 | 52323 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4437EUREKA 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48476 | 6001658.45435831 | 2104067.04414381 | 37.7574607564447 | -122.43728204425699 | (37.7574607564447, -122.437282044257) | ||
| 20074 | 20074 | 54875 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 300 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2004 12:00:00 AM | Permit Number 25697 | 6005109.34291576 | 2109921.18465674 | 37.7737303986235 | -122.42576415810301 | (37.7737303986235, -122.425764158103) | ||
| 20262 | 20262 | 68645 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1922 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32550 | 5990669.94043667 | 2102299.92572181 | 37.751977920883604 | -122.475155324919 | (37.7519779208836, -122.475155324919) | ||
| 20394 | 20394 | 63280 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 363 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23841 | 6006563.98546453 | 2103999.80423144 | 37.7575537770148 | -122.420311952542 | (37.7575537770148, -122.420311952542) | ||
| 20469 | 20469 | 69095 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1643 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33110 | 5992753.45517617 | 2104281.67357461 | 37.757539823727704 | -122.468094434883 | (37.7575398237277, -122.468094434883) | ||
| 22287 | 22287 | 60883 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 770 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1983 12:00:00 AM | 12 | Permit Number 20667 | 6009158.5873 | 2119786.8398 | 37.8010470949934 | -122.41245463263901 | (37.8010470949934, -122.412454632639) | |
| 23470 | 23470 | 71021 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 511 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 6 | 5990601.64729 | 2111881.43393 | 37.7782822050168 | -122.476091231143 | (37.7782822050168, -122.476091231143) | ||
| 23568 | 23568 | 32213 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 16 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35534 | 6009218.36931 | 2099496.57161 | 37.7453381212708 | -122.410813950014 | (37.7453381212708, -122.410813950014) | |
| 23744 | 23744 | 32591 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1367 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 5 | Permit Number 37060 | 5985531.9989 | 2105934.1277 | 37.7616573095776 | -122.493190516924 | (37.7616573095776, -122.493190516924) | |
| 25441 | 25441 | 61533 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 342 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21490 | 5991238.8038099995 | 2113097.3629099997 | 37.78165773678771 | -122.47397582980899 | (37.7816577367877, -122.473975829809) | |
| 25531 | 25531 | 70321 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 148 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 11 | 7x6 | 5997828.6446 | 2110019.5409 | 37.7735863423596 | -122.45095620867501 | (37.7735863423596, -122.450956208675) | |
| 25965 | 25965 | 61548 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 218 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/1984 12:00:00 AM | 8 | Permit Number 21506 | 5991210.3094 | 2113903.7549799997 | 37.7838702157395 | -122.474133262259 | (37.7838702157395, -122.474133262259) | |
| 25997 | 25997 | 66081 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 963 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 8 | Permit Number 29125 | 6008260.3123 | 2119964.4945799997 | 37.801484439724 | -122.41557564442199 | (37.801484439724, -122.415575644422) | |
| 26981 | 26981 | 36169 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 6453 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 3 | Permit Number 39247 | 5996287.8666 | 2113794.1884 | 37.7838622010514 | -122.45655897784201 | (37.7838622010514, -122.456558977842) | |
| 27233 | 27233 | 36171 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 6453 Euclid Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 4 | Permit Number 39247 | 5996326.4467 | 2113794.1884 | 37.7838644159639 | -122.456425505824 | (37.7838644159639, -122.456425505824) | |
| 28108 | 28108 | 33660 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 511 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 12 | Permit Number 37748 | 6004957.21005 | 2110733.7746099997 | 37.7759529745959 | -122.42634827696699 | (37.7759529745959, -122.426348276967) | |
| 28540 | 28540 | 68532 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 704 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32414 | 5994135.037269999 | 2110647.755 | 37.7750991055642 | -122.463778459231 | (37.7750991055642, -122.463778459231) | |
| 28929 | 28929 | 32396 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 224 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36937 | 6005825.6534 | 2096103.36545 | 37.7358303239982 | -122.422304379146 | (37.7358303239982, -122.422304379146) | |
| 28970 | 28970 | 84365 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 129 Escolta Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5986616.9958 | 2097211.3869 | 37.7377704195158 | -122.488796798517 | (37.7377704195158, -122.488796798517) | |||
| 29423 | 29423 | 61606 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 29 Tamalpais Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1984 12:00:00 AM | 6 | Permit Number 21579 | 5998469.3177 | 2111579.0405 | 37.7779049830772 | -122.44885238767799 | (37.7779049830772, -122.448852387678) | |
| 29494 | 29494 | 84619 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 895 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767653 | 6019276.35845 | 2094378.9880400002 | 37.7318450718732 | -122.37567995576799 | (37.7318450718732, -122.375679955768) |
| 29786 | 29786 | 62315 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 626 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1990 12:00:00 AM | 8 | Permit Number 29075 | 5994423.38031 | 2111229.7723 | 37.7767137814792 | -122.46282325722099 | (37.7767137814792, -122.462823257221) | |
| 29966 | 29966 | 61554 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1254 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 13 | Permit Number 21513 | 6012216.8343400005 | 2102544.44226 | 37.753874585952 | -122.40065975964501 | (37.753874585952, -122.400659759645) | |
| 30324 | 30324 | 75688 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1345 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 4 | 5988707.2425 | 2097607.0331 | 37.738978524128704 | -122.481598859375 | (37.7389785241287, -122.481598859375) | ||
| 30386 | 30386 | 41949 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 431 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 6 | Permit Number 42306 | 5993092.7149 | 2112519.1712700003 | 37.7801773906958 | -122.467520171446 | (37.7801773906958, -122.467520171446) | |
| 30535 | 30535 | 32878 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1483 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37223 | 5994573.62006414 | 2105444.34000884 | 37.760837155099104 | -122.461883922509 | (37.7608371550991, -122.461883922509) | ||
| 31302 | 31302 | 70578 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 201 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 7 | 5989595.95127 | 2113926.1891900003 | 37.7838381644508 | -122.479719921835 | (37.7838381644508, -122.479719921835) | ||
| 31426 | 31426 | 61537 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 246 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | 14 | Permit Number 21495 | 5991216.38557 | 2113770.28494 | 37.7835040959825 | -122.474102499434 | (37.7835040959825, -122.474102499434) | |
| 31772 | 31772 | 71295 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1830 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/1987 12:00:00 AM | 15 | 3x4 | 6000828.9333 | 2111756.2383 | 37.7785261792165 | -122.44070238260599 | (37.7785261792165, -122.440702382606) | |
| 31812 | 31812 | 61502 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 166 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1984 12:00:00 AM | 8 | Permit Number 21455 | 5989632.87408 | 2114250.53827 | 37.784730880786704 | -122.479615923855 | (37.7847308807867, -122.479615923855) | |
| 31861 | 31861 | 43778 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 160 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43408 | 5989627.89982 | 2114300.0227099997 | 37.784866462195296 | -122.479636754902 | (37.7848664621953, -122.479636754902) | |
| 32441 | 32441 | 61535 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 312 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21493 | 5991235.06362 | 2113291.98998 | 37.7821919123157 | -122.47400297330799 | (37.7821919123157, -122.474002973308) | |
| 33041 | 33041 | 64506 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 854 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 6 | Permit Number 25387 | 6000491.15 | 2111950.3818 | 37.779040006052206 | -122.441884838167 | (37.7790400060522, -122.441884838167) | |
| 33493 | 33493 | 68522 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 730 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 9 | Permit Number 32402 | 5995377.49487 | 2110568.06849 | 37.7749518252414 | -122.459474780725 | (37.7749518252414, -122.459474780725) | |
| 33618 | 33618 | 61138 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 142 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 13 | 3x33x3 | Permit Number 20990 | 5997342.1336 | 2110018.8543 | 37.773556593131104 | -122.452639064998 | (37.7735565931311, -122.452639064998) |
| 34086 | 34086 | 47421 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 866 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45332 | 5984821.2395 | 2109952.74159 | 37.7726496913879 | -122.49594517660299 | (37.7726496913879, -122.495945176603) | |
| 34254 | 34254 | 73145 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 560 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 8 | 5991294.46609 | 2111590.92928 | 37.777524708179 | -122.473673341879 | (37.777524708179, -122.473673341879) | ||
| 34941 | 34941 | 47437 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 719 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45348 | 5982882.50188 | 2110871.8928099996 | 37.7750596744967 | -122.50271941529101 | (37.7750596744967, -122.502719415291) | |
| 35295 | 35295 | 51372 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 668 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2004 12:00:00 AM | 4 | Permit Number 47706 | 5990371.65679 | 2110906.02605 | 37.775590664864396 | -122.47681555893 | (37.7755906648644, -122.47681555893) | |
| 36404 | 36404 | 47204 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 325 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 6 | Permit Number 45158 | 5986194.00617 | 2113731.94668 | 37.7831066164686 | -122.491474919013 | (37.7831066164686, -122.491474919013) | |
| 36725 | 36725 | 66568 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 38 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 11 | Permit Number 29757 | 6005049.36388 | 2093286.73989 | 37.7280526775706 | -122.42478800357401 | (37.7280526775706, -122.424788003574) | |
| 36808 | 36808 | 32071 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3685 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 5 | Permit Number 35445 | 6004358.206259999 | 2105972.09439 | 37.7628446758751 | -122.428080978282 | (37.7628446758751, -122.428080978282) | |
| 36953 | 36953 | 73444 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1353 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 10 | 6006988.50126 | 2115333.88055 | 37.7886983590984 | -122.419647955393 | (37.7886983590984, -122.419647955393) | ||
| 37731 | 37731 | 60807 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2023 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/1983 12:00:00 AM | 8 | Permit Number 20484 | 5989711.5047 | 2101567.8863 | 37.749912337728404 | -122.47841617358401 | (37.7499123377284, -122.478416173584) | |
| 37770 | 37770 | 31798 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 39 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35268 | 6001935.84631 | 2107865.07775 | 37.7679049955509 | -122.436594562416 | (37.7679049955509, -122.436594562416) | |
| 37990 | 37990 | 62323 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 737 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | 12 | Permit Number 22465 | 5994405.29719 | 2110517.95963 | 37.7747582919092 | -122.46283415917 | (37.7747582919092, -122.46283415917) | |
| 38162 | 38162 | 70662 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 472 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 7 | 6010616.59856 | 2106126.86555 | 37.7636217386735 | -122.40644618745701 | (37.7636217386735, -122.406446187457) | ||
| 38491 | 38491 | 60086 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1267 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 8 | Permit Number 19587 | 5988920.1528 | 2106715.7793 | 37.764001095368 | -122.48152965117201 | (37.764001095368, -122.481529651172) | |
| 38952 | 38952 | 31604 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1824 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35130 | 5989288.7965 | 2101763.3696 | 37.7504245340331 | -122.47989220563299 | (37.7504245340331, -122.479892205633) | |
| 39048 | 39048 | 33235 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2512 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 2 | Permit Number 37421 | 5988636.4412 | 2098175.1069 | 37.7405341892879 | -122.48188525576799 | (37.7405341892879, -122.481885255768) | |
| 39224 | 39224 | 44403 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1171 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43757 | 6001229.01614 | 2087080.5529 | 37.7107953655799 | -122.437550781868 | (37.7107953655799, -122.437550781868) | |
| 39585 | 39585 | 41925 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 554 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | Permit Number 42285 | 5995024.62934 | 2111767.48043 | 37.778224796578606 | -122.460782351365 | (37.7782247965786, -122.460782351365) | |
| 39810 | 39810 | 30874 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 101 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/16/1995 12:00:00 AM | 8 | Permit Number 34708 | 6001364.285619999 | 2094914.2380400002 | 37.7323125880576 | -122.437643917455 | (37.7323125880576, -122.437643917455) | |
| 39982 | 39982 | 75846 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 668 18th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 2 | 5990378.249 | 2110732.47104 | 37.775114512879895 | -122.476780071876 | (37.7751145128799, -122.476780071876) | ||
| 40812 | 40812 | 68673 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 271 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 5 | Permit Number 32581 | 5993048.53014 | 2113683.30999 | 37.7833712475909 | -122.46775771656601 | (37.7833712475909, -122.467757716566) | |
| 40826 | 40826 | 67943 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2101 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 7 | Permit Number 31657 | 5989059.79452 | 2110534.5985 | 37.7744946431679 | -122.48132635121401 | (37.7744946431679, -122.481326351214) | |
| 40871 | 40871 | 43243 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 136 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43032 | 6011117.222159999 | 2092533.22585 | 37.7263245367233 | -122.40375811295 | (37.7263245367233, -122.40375811295) | |
| 40914 | 40914 | 38561 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1567 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40526 | 6015551.0172 | 2095760.2661 | 37.7354320353665 | -122.388655734 | (37.7354320353665, -122.388655734) | |
| 41227 | 41227 | 31099 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 640 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 1 | Permit Number 34829 | 5998970.7952 | 2093046.30495 | 37.7270473011827 | -122.44578444392201 | (37.7270473011827, -122.445784443922) | |
| 41328 | 41328 | 60891 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 935 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1983 12:00:00 AM | 11 | Permit Number 20676 | 6008432.098130001 | 2119639.75593 | 37.8006024431139 | -122.41495818879 | (37.8006024431139, -122.41495818879) | |
| 41348 | 41348 | 41938 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 556 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | Permit Number 42297 | 5994404.74118 | 2111735.9434599997 | 37.7781025186899 | -122.462924466831 | (37.7781025186899, -122.462924466831) | |
| 41502 | 41502 | 48591 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2949 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 5 | Permit Number 45903 | 6006416.959980001 | 2121367.79971 | 37.805233769992206 | -122.422054230926 | (37.8052337699922, -122.422054230926) | |
| 41528 | 41528 | 47420 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 793 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45331 | 5984756.86965 | 2110493.8221 | 37.7741315735488 | -122.496207764056 | (37.7741315735488, -122.496207764056) | |
| 41656 | 41656 | 60806 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2019 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/1983 12:00:00 AM | 8 | Permit Number 20483 | 5989711.17 | 2101593.3234 | 37.749982161868296 | -122.478419190797 | (37.7499821618683, -122.478419190797) | |
| 41708 | 41708 | 31804 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 66 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 10 | Permit Number 35274 | 6001963.376 | 2108028.17278 | 37.7683543786925 | -122.436511015378 | (37.7683543786925, -122.436511015378) | |
| 41898 | 41898 | 75361 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 668 18th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/1997 12:00:00 AM | 14 | 5990381.90106 | 2110674.67356 | 37.7749560287096 | -122.476763215004 | (37.7749560287096, -122.476763215004) | ||
| 42653 | 42653 | 72326 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1226 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 1 | 5994837.87053 | 2112161.8700599996 | 37.7792969379819 | -122.461457013109 | (37.7792969379819, -122.461457013109) | ||
| 42820 | 42820 | 32279 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2880 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2006 12:00:00 AM | 7 | Permit Number 46513 | 5995819.19367 | 2111055.46126 | 37.7763154645284 | -122.45798213914401 | (37.7763154645284, -122.457982139144) |
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");