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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125 | 125 | 119758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 151X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 1498 | 1498 | 251577 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 490X Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998892.0 | 2109203.0 | 37.7714051474644 | -122.447219139052 | (37.7714051474644, -122.447219139052) | ||||
| 1950 | 1950 | 252823 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 3852 17th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 5061 | 5061 | 253757 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 5072 | 5072 | 253758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 5078 | 5078 | 253759 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 330 Twin Peaks Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | Permit Number 780692 | 5998725.10706 | 2103975.38052 | 37.75704188115579 | -122.44742009249201 | (37.7570418811558, -122.447420092492) | |||
| 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) | ||
| 9729 | 9729 | 173667 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 37 Ford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003363.0 | 2105606.0 | 37.7617831123707 | -122.431496910184 | (37.7617831123707, -122.431496910184) | ||||
| 9733 | 9733 | 173666 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 37 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003363.0 | 2105606.0 | 37.7617831123707 | -122.431496910184 | (37.7617831123707, -122.431496910184) | ||||
| 10171 | 10171 | 173890 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989209.0 | 2097724.0 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | ||||
| 10173 | 10173 | 173893 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2593 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989209.0 | 2097724.0 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | ||||
| 10257 | 10257 | 101048 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3050 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008765.0 | 2105072.0 | 37.7606215625409 | -122.41277572810101 | (37.7606215625409, -122.412775728101) | ||||
| 10261 | 10261 | 101049 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 3050 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008765.0 | 2105072.0 | 37.7606215625409 | -122.41277572810101 | (37.7606215625409, -122.412775728101) | ||||
| 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 | |||||||
| 11810 | 11810 | 30642 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1500 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | Permit Number 34585 | ||||||||
| 15410 | 15410 | 30596 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 451 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34563 | ||||||||
| 16505 | 16505 | 30597 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 461 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34564 | ||||||||
| 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) | ||
| 18084 | 18084 | 46314 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 232 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2002 12:00:00 AM | Permit Number 44568 | 6004150.97651676 | 2096753.27523133 | 37.737520221240295 | -122.42814069810801 | (37.7375202212403, -122.428140698108) | |||
| 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) | ||
| 19558 | 19558 | 52414 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3180 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2005 12:00:00 AM | Permit Number 48533 | 6006685.96266598 | 2099861.46080956 | 37.7461977049098 | -122.41959649754601 | (37.7461977049098, -122.419596497546) | |||
| 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) | ||
| 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) | ||
| 44047 | 44047 | 64096 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1431 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1987 12:00:00 AM | Permit Number 24862 | 5992394.20542411 | 2105708.96669643 | 37.761438042217605 | -122.46944074700501 | (37.7614380422176, -122.469440747005) | ||
| 49626 | 49626 | 41923 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 695 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42283 | 5995321.61655051 | 2110837.97442111 | 37.7756897025625 | -122.459687628247 | (37.7756897025625, -122.459687628247) | ||
| 50094 | 50094 | 60166 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2059 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19698 | 5990649.13754844 | 2101383.24964177 | 37.7494597627964 | -122.475160349904 | (37.7494597627964, -122.475160349904) | ||
| 51268 | 51268 | 94478 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 102 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997316.0 | 2110188.0 | 37.774019525956895 | -122.452741674918 | (37.7740195259569, -122.452741674918) | |||||
| 51324 | 51324 | 51075 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3627 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 47537 | 6006082.78901051 | 2101388.58373898 | 37.750356841617204 | -122.42179065398001 | (37.7503568416172, -122.42179065398) | ||
| 54774 | 54774 | 61755 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1949 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/1984 12:00:00 AM | Permit Number 21767 | 6004488.8835917 | 2107164.17004253 | 37.766125222729706 | -122.427713950142 | (37.7661252227297, -122.427713950142) | ||
| 54778 | 54778 | 49103 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | Permit Number 46247 | 6008972.2148254 | 2105156.96452996 | 37.7608664841972 | -122.412065067953 | (37.7608664841972, -122.412065067953) | |||
| 56270 | 56270 | 62311 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 508 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22449 | 5994397.46208427 | 2112042.79785927 | 37.7789446394389 | -122.462971916423 | (37.7789446394389, -122.462971916423) | ||
| 56271 | 56271 | 35967 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 44A Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39125 | 6007014.15115311 | 2099319.09415295 | 37.7447269689924 | -122.418423209494 | (37.7447269689924, -122.418423209494) | ||
| 60916 | 60916 | 67121 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1207 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30541 | 5997395.85937941 | 2105798.980467 | 37.7619729779911 | -122.452148686456 | (37.7619729779911, -122.452148686456) | ||
| 63657 | 63657 | 61810 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 473 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/1985 12:00:00 AM | Permit Number 21840 | 6003450.97814623 | 2108943.61336851 | 37.7709523752315 | -122.43143089967899 | (37.7709523752315, -122.431430899679) | ||
| 65303 | 65303 | 50949 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 46 Niantic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | Permit Number 47444 | 5992462.89572875 | 2086742.39043465 | 37.7093645519695 | -122.46782366028499 | (37.7093645519695, -122.467823660285) | |||
| 65724 | 65724 | 68047 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1976 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31784 | 5993193.03759973 | 2102033.60903693 | 37.7513925960516 | -122.46641080915 | (37.7513925960516, -122.46641080915) | ||
| 66643 | 66643 | 68046 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1975 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31783 | 5993140.61312616 | 2102044.81936943 | 37.751420351602896 | -122.466592912362 | (37.7514203516029, -122.466592912362) | ||
| 66743 | 66743 | 69050 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1282 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33057 | 5992721.04505812 | 2106741.91980222 | 37.764293142202604 | -122.468385506736 | (37.7642931422026, -122.468385506736) | ||
| 69270 | 69270 | 67579 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 215 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31143 | 6013200.80660974 | 2106062.78793632 | 37.7635900242288 | -122.397503666435 | (37.7635900242288, -122.397503666435) | ||
| 69371 | 69371 | 65225 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 500 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 28012 | 6002551.42222049 | 2090262.71018244 | 37.7196079665756 | -122.43320747365401 | (37.7196079665756, -122.433207473654) | ||
| 69962 | 69962 | 99744 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 431 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Probably planted at same time as tree no. 1 w/same permit. CB | 6002387.0 | 2100900.0 | 37.7488061968535 | -122.43453600133999 | (37.7488061968535, -122.43453600134) | |||
| 76406 | 76406 | 63664 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3955 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/17/1995 12:00:00 AM | Permit Number 24313 | 6004192.39264415 | 2100406.19411579 | 37.7475526417363 | -122.42825776975799 | (37.7475526417363, -122.428257769758) | ||
| 77519 | 77519 | 61045 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 111 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1983 12:00:00 AM | Permit Number 20869 | 6001333.73272737 | 2094912.03917457 | 37.732304813248604 | -122.43774938818501 | (37.7323048132486, -122.437749388185) | ||
| 77539 | 77539 | 61063 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 121 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1983 12:00:00 AM | Permit Number 20895 | 6001270.33728628 | 2094913.02628966 | 37.7323039186847 | -122.437968630996 | (37.7323039186847, -122.437968630996) | ||
| 77668 | 77668 | 60011 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1255 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/1982 12:00:00 AM | Permit Number 19497 | 5991082.34836837 | 2106871.19693577 | 37.7645533154057 | -122.47406267204398 | (37.7645533154057, -122.474062672044) | ||
| 77697 | 77697 | 41837 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1225 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42225 | 5990765.08330187 | 2107058.41544257 | 37.7650489839866 | -122.475173663486 | (37.7650489839866, -122.475173663486) | ||
| 77752 | 77752 | 110829 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 158 SHRADER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997319.0 | 2110025.0 | 37.7735721420997 | -122.45271953078999 | (37.7735721420997, -122.45271953079) | ||||
| 77762 | 77762 | 121681 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 900 Lawton St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5991505.0 | 2104920.0 | 37.7592203205256 | -122.472458589604 | (37.7592203205256, -122.472458589604) | ||||
| 77800 | 77800 | 60710 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1027 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20360 | 6009459.57038181 | 2103192.49678142 | 37.7554998319395 | -122.410240811201 | (37.7554998319395, -122.410240811201) | ||
| 77810 | 77810 | 66756 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 117 Clifford Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30009 | 5999558.7942739995 | 2106484.77967466 | 37.7639796750059 | -122.44471726068501 | (37.7639796750059, -122.444717260685) | ||
| 77917 | 77917 | 65637 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2400 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | Permit Number 28547 | 6002014.89286601 | 2114695.91493086 | 37.78666525153189 | -122.43681019834699 | (37.7866652515319, -122.436810198347) | ||
| 77999 | 77999 | 69089 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 930 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | 3x3 | Permit Number 33101 | 5992909.31085919 | 2106648.04834797 | 37.7640462683601 | -122.46772752650699 | (37.7640462683601, -122.467727526507) | |
| 78202 | 78202 | 97308 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 834 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990649.5 | 2099079.9 | 37.743135384235394 | -122.47499098140301 | (37.7431353842354, -122.474990981403) | ||||
| 78207 | 78207 | 44323 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3101 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2001 12:00:00 AM | Permit Number 43712 | 6007112.977014599 | 2100542.34949089 | 37.7480913155606 | -122.418168196056 | (37.7480913155606, -122.418168196056) | |||
| 78289 | 78289 | 50455 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1401 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47100 | 6001099.19382733 | 2110698.32515929 | 37.77563680416 | -122.43969158686501 | (37.77563680416, -122.439691586865) | |||
| 78325 | 78325 | 115791 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 SAN ALESO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5993432.0 | 2094808.0 | 37.7315666775405 | -122.465059716371 | (37.7315666775405, -122.465059716371) | ||||
| 78363 | 78363 | 68927 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4545 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32911 | 5992970.34133889 | 2112717.28670221 | 37.7807142959171 | -122.46795792826 | (37.7807142959171, -122.46795792826) | ||
| 78521 | 78521 | 65209 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1006 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27195 | 6003121.38880969 | 2102376.35777972 | 37.7529015890661 | -122.432101903573 | (37.7529015890661, -122.432101903573) | ||
| 78554 | 78554 | 69270 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1886 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1994 12:00:00 AM | Permit Number 33341 | 5991607.61462757 | 2102584.13172694 | 37.7528125781799 | -122.47193345514799 | (37.7528125781799, -122.471933455148) | ||
| 78778 | 78778 | 32819 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 4226 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37178 | 6001698.63208525 | 2102367.69069452 | 37.7527970247899 | -122.437021433816 | (37.7527970247899, -122.437021433816) | ||
| 78893 | 78893 | 119620 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 96 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999423.0 | 2107768.0 | 37.7674953262458 | -122.445279199015 | (37.7674953262458, -122.445279199015) | ||||
| 79108 | 79108 | 61025 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 305 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1983 12:00:00 AM | Permit Number 20843 | 6006524.5640738 | 2098096.7157966997 | 37.7413430196907 | -122.42002938043998 | (37.7413430196907, -122.42002938044) | ||
| 79267 | 79267 | 83193 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 327 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50787 | 6006223.64093095 | 2101202.59276032 | 37.74985409498979 | -122.421290371422 | (37.7498540949898, -122.421290371422) | ||
| 79368 | 79368 | 69255 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1870 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/1994 12:00:00 AM | Permit Number 33322 | 5991604.75753343 | 2102676.27761459 | 37.7530654214121 | -122.471950050833 | (37.7530654214121, -122.471950050833) | ||
| 79494 | 79494 | 105555 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 410 Elizabeth St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | ||||
| 79520 | 79520 | 31984 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 120 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | Permit Number 35384 | 5994611.09448482 | 2114744.09839205 | 37.7863739861091 | -122.462428866385 | (37.7863739861091, -122.462428866385) | ||
| 79561 | 79561 | 40362 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2295 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1999 12:00:00 AM | 3x3 | Permit Number 41481 | 6002535.0 | 2114717.0 | 37.786752691416105 | -122.43501226368299 | (37.7867526914161, -122.435012263683) | ||
| 79585 | 79585 | 33565 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 312 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37678 | 6006442.25648558 | 2098054.16167525 | 37.7412215379443 | -122.42031095218 | (37.7412215379443, -122.42031095218) | |||
| 79598 | 79598 | 49427 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1396-1398X 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2006 12:00:00 AM | Permit Number 46370 | 5993243.20305227 | 2105992.08375012 | 37.7622644352537 | -122.466525019945 | (37.7622644352537, -122.466525019945) | |||
| 79848 | 79848 | 113762 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 130 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x15 | 6001382.0 | 2109326.0 | 37.7718848357935 | -122.438614940538 | (37.7718848357935, -122.438614940538) | ||||
| 79861 | 79861 | 67543 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 221 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31083 | 5999380.73268965 | 2095746.24622826 | 37.7344841059817 | -122.444561268208 | (37.7344841059817, -122.444561268208) | ||
| 79907 | 79907 | 61475 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1970 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1984 12:00:00 AM | Permit Number 21418 | 6004339.08468757 | 2107207.93872043 | 37.766236926238705 | -122.42823519476102 | (37.7662369262387, -122.428235194761) | ||
| 80169 | 80169 | 51260 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2038 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 47637 | 5990696.66965816 | 2101515.39978793 | 37.7498253673481 | -122.475005629606 | (37.7498253673481, -122.475005629606) | ||
| 80248 | 80248 | 31203 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 422 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34895 | 6001889.76810275 | 2091302.66010949 | 37.722425879300395 | -122.435568927878 | (37.7224258793004, -122.435568927878) | ||||
| 80494 | 80494 | 37626 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 675 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | Permit Number 40046 | 5990640.83768809 | 2110797.79688207 | 37.7753091079765 | -122.475876500666 | (37.7753091079765, -122.475876500666) | |||
| 80567 | 80567 | 60319 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 358 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1982 12:00:00 AM | Permit Number 19889 | 5986559.08515694 | 2113521.73516295 | 37.782550763322604 | -122.490196443461 | (37.7825507633226, -122.490196443461) | ||
| 80673 | 80673 | 92282 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 300 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52730 | 5992136.0 | 2097371.0 | 37.738529215445 | -122.469726723041 | (37.738529215445, -122.469726723041) | ||
| 80699 | 80699 | 57003 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 392 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1984 12:00:00 AM | Permit Number 21346 | 6006189.54615287 | 2100877.99447232 | 37.7489609000015 | -122.42138522421001 | (37.7489609000015, -122.42138522421) | ||
| 80902 | 80902 | 61418 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 330 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1984 12:00:00 AM | Permit Number 21344 | 6006172.31902661 | 2101188.91481146 | 37.7498136448968 | -122.421466873932 | (37.7498136448968, -122.421466873932) | ||
| 80944 | 80944 | 68116 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3250 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31862 | 6006400.90020665 | 2099333.86606999 | 37.744732987788794 | -122.42054476523701 | (37.7447329877888, -122.420544765237) | ||
| 80949 | 80949 | 32209 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3222 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | Permit Number 35531 | 6008981.90009833 | 2099917.3029488 | 37.7464800946461 | -122.411661346582 | (37.7464800946461, -122.411661346582) | ||
| 81014 | 81014 | 50583 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 542 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2005 12:00:00 AM | Permit Number 48453 | 6002971.85565811 | 2105065.21171156 | 37.760276061104605 | -122.432811086987 | (37.7602760611046, -122.432811086987) | |||
| 81082 | 81082 | 109044 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 498 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773954 | 6003354.1 | 2109027.4 | 37.7711769416863 | -122.431771986949 | (37.7711769416863, -122.431771986949) | ||||
| 81083 | 81083 | 94192 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2075 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53602 | 6002677.0 | 2114394.0 | 37.7858738773307 | -122.43449787466001 | (37.7858738773307, -122.43449787466) | ||
| 81106 | 81106 | 68595 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1786 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32497 | 5991258.48743422 | 2103253.0789389 | 37.7546291237563 | -122.47318957137199 | (37.7546291237563, -122.473189571372) | ||
| 81302 | 81302 | 60662 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 241 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20296 | 6004419.07942782 | 2096978.69853043 | 37.7381543479683 | -122.427229792133 | (37.7381543479683, -122.427229792133) | ||
| 81395 | 81395 | 33591 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 243 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 47804 | 6006767.27552728 | 2097768.04051053 | 37.7404542224366 | -122.419166858884 | (37.7404542224366, -122.419166858884) | ||
| 81432 | 81432 | 31662 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 116 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35280 | 6001959.7290679 | 2108357.31064937 | 37.769257902794706 | -122.436547191068 | (37.7692579027947, -122.436547191068) | ||
| 81658 | 81658 | 63014 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 67 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1986 12:00:00 AM | Permit Number 23429 | 6007424.54316304 | 2097904.58328941 | 37.7408661314402 | -122.41690395051 | (37.7408661314402, -122.41690395051) |
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");