Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 144733 | 144733 | 96627 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 24787 | 24787 | 56080 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 723 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2011 12:00:00 AM | 2 | 3x3 | Permit Number 51743 | 5981333.03596 | 2110794.79787 | 37.774756814986794 | -122.50807353876199 | (37.7747568149868, -122.508073538762) | |
| 188601 | 188601 | 37092 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1422 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39692 | 5981562.80857566 | 2105390.4854708 | 37.7599316756927 | -122.506877772277 | (37.7599316756927, -122.506877772277) | |
| 156648 | 156648 | 182931 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2639 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982106.6394 | 2097122.6843 | 37.7372626147396 | -122.50438444730699 | (37.7372626147396, -122.504384447307) | |||
| 51341 | 51341 | 117943 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983766.08421 | 2109717.4045599997 | 37.7719416683068 | -122.499577617773 | (37.7719416683068, -122.499577617773) | |||
| 131020 | 131020 | 117942 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983781.64788 | 2109717.73118 | 37.7719434782971 | -122.499523806885 | (37.7719434782971, -122.499523806885) | |||
| 54202 | 54202 | 117939 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983833.6821099995 | 2109720.9042700003 | 37.7719552435785 | -122.49934405400101 | (37.7719552435785, -122.499344054001) | |||
| 62772 | 62772 | 185051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983667.0512 | 2096660.9577 | 37.736086492552 | -122.49895536756901 | (37.736086492552, -122.498955367569) | |||
| 51023 | 51023 | 185052 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983668.1125 | 2096649.8142 | 37.7360559577629 | -122.498950875232 | (37.7360559577629, -122.498950875232) | |||
| 164170 | 164170 | 62984 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 7 | Permit Number 33034 | 5984571.8482 | 2106766.3839 | 37.7638862475145 | -122.496572656852 | (37.7638862475145, -122.496572656852) | |
| 74356 | 74356 | 186817 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1200 Sunset Blvd | 110 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984826.8059 | 2106810.865 | 37.7640233139964 | -122.49569412937599 | (37.7640233139964, -122.495694129376) | |||
| 71134 | 71134 | 187130 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985156.874 | 2097417.7557 | 37.73825173359629 | -122.49386027578899 | (37.7382517335963, -122.493860275789) | |||
| 157008 | 157008 | 187077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985155.4633 | 2096938.6014 | 37.736936021545 | -122.493829852855 | (37.736936021545, -122.493829852855) | |||
| 159621 | 159621 | 186908 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985188.8014 | 2096694.9245 | 37.736268900285 | -122.493696639188 | (37.736268900285, -122.493696639188) | |||
| 36009 | 36009 | 186909 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985192.0104 | 2096702.7177 | 37.7362904860675 | -122.49368611859501 | (37.7362904860675, -122.493686118595) | |||
| 164682 | 164682 | 37224 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1340 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39788 | 5985571.0917 | 2106094.9849 | 37.7621012650414 | -122.49306716261101 | (37.7621012650414, -122.493067162611) | |
| 136118 | 136118 | 250773 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 259 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | |||
| 45384 | 45384 | 119342 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985959.22989 | 2112860.79415 | 37.78070095968079 | -122.492222971302 | (37.7807009596808, -122.492222971302) | |||
| 57672 | 57672 | 119485 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5526 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5986205.51331 | 2109807.2757599996 | 37.772331260735605 | -122.49114618500799 | (37.7723312607356, -122.491146185008) | |||
| 154293 | 154293 | 46268 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2436 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2002 12:00:00 AM | 3 | Permit Number 44552 | 5986405.9288 | 2102348.8049 | 37.7518640711658 | -122.489904286753 | (37.7518640711658, -122.489904286753) | ||
| 178480 | 178480 | 119541 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 823 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986627.47166 | 2110288.5169900004 | 37.773677258601 | -122.48972200943399 | (37.773677258601, -122.489722009434) | |||
| 60958 | 60958 | 48733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2002 12:00:00 AM | 2 | Permit Number 46013 | 5986739.234 | 2106838.4777 | 37.764210939174106 | -122.489081723593 | (37.7642109391741, -122.489081723593) | ||
| 62217 | 62217 | 250619 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987113.722030001 | 2115192.60557 | 37.7871708695801 | -122.48840049988002 | (37.7871708695801, -122.48840049988) | |||
| 154559 | 154559 | 250620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987116.07946 | 2115204.5954 | 37.7872039277514 | -122.48839322528099 | (37.7872039277514, -122.488393225281) | |||
| 102904 | 102904 | 34272 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 143244 | 143244 | 34271 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 102328 | 102328 | 34270 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.48837297696699 | (37.7872778329962, -122.488372976967) | ||
| 106270 | 106270 | 34269 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.48837297696699 | (37.7872778329962, -122.488372976967) | ||
| 134902 | 134902 | 181607 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1255 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5987053.8771 | 2106742.5422 | 37.7639658865787 | -122.487986427971 | (37.7639658865787, -122.487986427971) | |||
| 55812 | 55812 | 50231 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1255 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 8 | Permit Number 46939 | 5987056.8298 | 2106727.188 | 37.7639239004312 | -122.487975087347 | (37.7639239004312, -122.487975087347) | |
| 33248 | 33248 | 94086 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1727 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53469 | 5987161.9603 | 2103493.9012 | 37.7550523122054 | -122.48737396285101 | (37.7550523122054, -122.487373962851) | |
| 133413 | 133413 | 250533 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 69 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5987683.92995 | 2115503.12844 | 37.7880567296852 | -122.48645053678601 | (37.7880567296852, -122.486450536786) | |||
| 136250 | 136250 | 250532 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.787997784513294 | -122.486444423174 | (37.7879977845133, -122.486444423174) | |||
| 162509 | 162509 | 120374 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 433 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5988073.52579 | 2113031.79545 | 37.7812938539051 | -122.484921243675 | (37.7812938539051, -122.484921243675) | |||
| 56357 | 56357 | 43807 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 530 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 3 | Permit Number 43437 | 5988458.677999999 | 2112363.29745 | 37.7794807721264 | -122.48353979825899 | (37.7794807721264, -122.483539798259) | |
| 175752 | 175752 | 183581 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988348.717 | 2097504.9177 | 37.738677287922 | -122.48283097892299 | (37.738677287922, -122.482830978923) | |||
| 163085 | 163085 | 183580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988349.2799 | 2097484.0905 | 37.7386201346216 | -122.482827506776 | (37.7386201346216, -122.482827506776) | |||
| 68229 | 68229 | 101282 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2001 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5989468.7375 | 2106475.7724 | 37.7633739839128 | -122.479614718585 | (37.7633739839128, -122.479614718585) | |||
| 45357 | 45357 | 120682 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2917 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989597.69972 | 2111917.78775 | 37.7783237566214 | -122.479566877639 | (37.7783237566214, -122.479566877639) | |||
| 66258 | 66258 | 101283 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2001 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989499.782000001 | 2106476.1919 | 37.7633769390525 | -122.479507377657 | (37.7633769390525, -122.479507377657) | |||
| 150887 | 150887 | 183441 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098772.4148 | 37.742227304861395 | -122.47877163063801 | (37.7422273048614, -122.478771630638) | |||
| 34489 | 34489 | 183440 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2434 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989549.5958 | 2098754.1113 | 37.7421770482141 | -122.47877029228998 | (37.7421770482141, -122.47877029229) | |||
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 47584 | 47584 | 97338 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1917 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989797.6411 | 2106487.0994 | 37.763424185107496 | -122.478477988866 | (37.7634241851075, -122.478477988866) | |||
| 49002 | 49002 | 97113 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1345 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Permit Number 18860 | 5989785.9448 | 2103084.5073 | 37.7540808992005 | -122.478269637351 | (37.7540808992005, -122.478269637351) | |||
| 95142 | 95142 | 12754 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1730 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 2 | 3X4 | 5990033.131630001 | 2114754.17722 | 37.786136974525 | -122.478268017968 | (37.786136974525, -122.478268017968) | ||
| 30701 | 30701 | 71808 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2487 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 4 | 5989823.9383 | 2098417.3202 | 37.741268233056395 | -122.477797097779 | (37.7412682330564, -122.477797097779) | ||
| 136981 | 136981 | 37644 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990120.460530001 | 2111993.16181 | 37.7785610650821 | -122.47776398494499 | (37.7785610650821, -122.477763984945) | |
| 77958 | 77958 | 31771 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 99320 | 99320 | 31776 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 105593 | 105593 | 31773 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 117577 | 117577 | 31772 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 145061 | 145061 | 31775 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 174307 | 174307 | 31774 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 0 | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | |
| 49423 | 49423 | 37645 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990141.86983 | 2111994.48348 | 37.7785659364855 | -122.477690019436 | (37.7785659364855, -122.477690019436) | |
| 82228 | 82228 | 31734 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
| 98035 | 98035 | 31731 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005.0 | 2098357.0 | 37.741113115877795 | -122.47716665025699 | (37.7411131158778, -122.477166650257) | ||
| 54938 | 54938 | 182961 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5990015.6611 | 2098388.4154 | 37.7411999929644 | -122.47713208357 | (37.7411999929644, -122.47713208357) | |||
| 137045 | 137045 | 57079 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 2 | Permit Number 14346 | 5990318.78395 | 2111097.03664 | 37.7761120602541 | -122.477012417523 | (37.7761120602541, -122.477012417523) | ||
| 143981 | 143981 | 116237 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 639 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5990321.779490001 | 2111019.87703 | 37.775900374977 | -122.47699641585 | (37.775900374977, -122.47699641585) | |||
| 188902 | 188902 | 182960 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5990064.3236 | 2098390.6107 | 37.741208843809794 | -122.47696398819299 | (37.7412088438098, -122.476963988193) | |||
| 175622 | 175622 | 37630 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 546 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40048 | 5990347.694519999 | 2111641.30179 | 37.777608139525 | -122.476952187306 | (37.777608139525, -122.476952187306) | |
| 74868 | 74868 | 121865 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 574 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990352.3789099995 | 2111462.4285 | 37.7771172745488 | -122.476922909403 | (37.7771172745488, -122.476922909403) | |||
| 187174 | 187174 | 122008 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2650 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990390.42893 | 2112003.07059 | 37.7786039357458 | -122.476830795247 | (37.7786039357458, -122.476830795247) | |||
| 147585 | 147585 | 31733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2495 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | 3x3 | Permit Number 35227 | 5990132.7438 | 2098427.0161 | 37.7413127725673 | -122.476730077237 | (37.7413127725673, -122.476730077237) |
| 67213 | 67213 | 51275 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 3 | Permit Number 47650 | 5990394.326 | 2110291.56377 | 37.7739048349937 | -122.476692239116 | (37.7739048349937, -122.476692239116) | |
| 109199 | 109199 | 122009 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2629 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990447.70869 | 2111948.34575 | 37.77845699894 | -122.476628645569 | (37.77845699894, -122.476628645569) | |||
| 70774 | 70774 | 31727 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990175.918 | 2098661.7302 | 37.7419597410001 | -122.476597940821 | (37.7419597410001, -122.476597940821) |
| 131574 | 131574 | 31728 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990177.7474 | 2098625.5077 | 37.7418603894955 | -122.476588969759 | (37.7418603894955, -122.476588969759) |
| 66250 | 66250 | 31765 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990223.0095 | 2098395.3195 | 37.7412309773369 | -122.47641565864299 | (37.7412309773369, -122.476415658643) | ||
| 45843 | 45843 | 31770 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990241.9611 | 2098396.6732 | 37.7412357933409 | -122.47635023030199 | (37.7412357933409, -122.476350230302) | ||
| 184877 | 184877 | 31769 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990271.0654 | 2098396.6732 | 37.7412374811669 | -122.476249599037 | (37.7412374811669, -122.476249599037) | ||
| 76229 | 76229 | 31768 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990284.9407 | 2098399.3806 | 37.741245719618895 | -122.47620182139 | (37.7412457196189, -122.47620182139) | ||
| 57239 | 57239 | 31767 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990299.8313 | 2098399.3806 | 37.741246583105294 | -122.47615033552201 | (37.7412465831053, -122.476150335522) | ||
| 176799 | 176799 | 182968 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2501 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5990431.4773 | 2098333.0499 | 37.7410720891089 | -122.475690312642 | (37.7410720891089, -122.475690312642) | |||
| 120563 | 120563 | 34888 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 252 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774542 | 5990895.02345 | 2113704.92636 | 37.7833060185493 | -122.475209503253 | (37.7833060185493, -122.475209503253) | |
| 145313 | 145313 | 64085 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | |||
| 49816 | 49816 | 207050 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | |||
| 77081 | 77081 | 207086 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2167 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990677.28316 | 2100628.1103 | 37.747387978366106 | -122.475007906598 | (37.7473879783661, -122.475007906598) | |||
| 59281 | 59281 | 54994 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 685 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10872 | 5990951.59437 | 2110751.2702900004 | 37.77519937131321 | -122.47479813592301 | (37.7751993713132, -122.474798135923) | ||
| 111793 | 111793 | 93854 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875.0 | 2103807.0 | 37.7561278331456 | -122.47455618324601 | (37.7561278331456, -122.474556183246) | ||
| 63865 | 63865 | 98154 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | Permit Number 768787 | 5991271.26635 | 2112266.2977400003 | 37.779377741026394 | -122.473802878969 | (37.7793777410264, -122.473802878969) | ||
| 164481 | 164481 | 31363 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2295 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 2 | Permit Number 34969 | 5991013.007780001 | 2099881.4668 | 37.7453573397732 | -122.47379254479799 | (37.7453573397732, -122.473792544798) | ||
| 100674 | 100674 | 98153 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | Permit Number 768787 | 5991293.7 | 2112258.0 | 37.7793562570144 | -122.473724666839 | (37.7793562570144, -122.473724666839) | |||
| 147671 | 147671 | 207068 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 539 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991225.79939 | 2097692.69128 | 37.739359846476205 | -122.472897178881 | (37.7393598464762, -122.472897178881) | |||
| 175198 | 175198 | 207091 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 520 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991320.331130001 | 2097065.30066 | 37.7376426638631 | -122.47252460501998 | (37.7376426638631, -122.47252460502) | |||
| 170832 | 170832 | 207092 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991411.795390001 | 2097355.25398 | 37.738444095618 | -122.4722295024 | (37.738444095618, -122.4722295024) | |||
| 59171 | 59171 | 207090 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991605.432 | 2098443.60055 | 37.741443622419894 | -122.47163929621 | (37.7414436224199, -122.47163929621) | |||
| 59463 | 59463 | 207089 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991620.77866 | 2098444.2951599997 | 37.7414464175195 | -122.471586283874 | (37.7414464175195, -122.471586283874) | |||
| 164375 | 164375 | 207088 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991634.58199 | 2098444.51298 | 37.7414478141662 | -122.47153857305 | (37.7414478141662, -122.47153857305) | |||
| 62582 | 62582 | 207087 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991668.56365 | 2098444.306 | 37.7414492117217 | -122.471421062245 | (37.7414492117217, -122.471421062245) | |||
| 156929 | 156929 | 217749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 445 West Portal Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991783.05973 | 2096405.3403 | 37.7358573522267 | -122.470876685538 | (37.7358573522267, -122.470876685538) | |||
| 168739 | 168739 | 207051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992092.816880001 | 2106815.43538 | 37.764458690039 | -122.47056370526899 | (37.764458690039, -122.470563705269) | |||
| 138266 | 138266 | 109806 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.47047998805401 | (37.764483341532, -122.470479988054) |
| 168777 | 168777 | 207093 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2469 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992014.45058 | 2098646.31177 | 37.742023871309 | -122.47023982251801 | (37.742023871309, -122.470239822518) | |||
| 165313 | 165313 | 207060 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2454 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5992058.22745 | 2098746.77263 | 37.7423022420675 | -122.470095770898 | (37.7423022420675, -122.470095770898) | |||
| 147095 | 147095 | 207059 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2454 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5992059.72364 | 2098724.92514 | 37.7422423409243 | -122.470089007101 | (37.7422423409243, -122.470089007101) | |||
| 51890 | 51890 | 207058 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2480 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992066.66369 | 2098534.27865 | 37.7417192754352 | -122.470051132153 | (37.7417192754352, -122.470051132153) | |||
| 41237 | 41237 | 207083 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992235.15443 | 2102157.44312 | 37.7516772939722 | -122.469732265856 | (37.7516772939722, -122.469732265856) |
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");