Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 36363 | 36363 | 207082 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1963 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992234.50744 | 2102126.7079 | 37.7515928656239 | -122.46973226583799 | (37.7515928656239, -122.469732265838) | |||
| 183459 | 183459 | 207081 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1967 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992237.024130001 | 2102091.85973 | 37.751497327037605 | -122.46972102612601 | (37.7514973270376, -122.469721026126) | |||
| 167362 | 167362 | 207055 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1950 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5992276.06738 | 2102166.8288 | 37.751705429283206 | -122.469591467999 | (37.7517054292832, -122.469591467999) | |||
| 135774 | 135774 | 39858 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 514 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 5 | Permit Number 41164 | 5992538.39814 | 2111929.42262 | 37.7785260826754 | -122.469394849438 | (37.7785260826754, -122.469394849438) | |
| 159965 | 159965 | 176962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 121 Saint Charles Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 5992069.06615 | 2087619.0428799998 | 37.71174887986621 | -122.46924855110301 | (37.7117488798662, -122.469248551103) | |||
| 184598 | 184598 | 207080 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1648 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992494.37113 | 2104224.8500200002 | 37.75736883521821 | -122.46898630879299 | (37.7573688352182, -122.468986308793) | |||
| 188401 | 188401 | 207079 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992173.18035 | 2088300.4585900002 | 37.7136258989769 | -122.46893826428699 | (37.7136258989769, -122.468938264287) | ||||
| 34205 | 34205 | 207067 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 319 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992889.43355 | 2094705.1306900003 | 37.731252923187796 | -122.466927982745 | (37.7312529231878, -122.466927982745) | |||
| 178142 | 178142 | 207065 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993024.9505900005 | 2099189.6741400003 | 37.743574176615894 | -122.46678535477301 | (37.7435741766159, -122.466785354773) | |||
| 67199 | 67199 | 207064 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993028.0499599995 | 2099189.22218 | 37.743573114522206 | -122.466774605159 | (37.7435731145222, -122.466774605159) | |||
| 186485 | 186485 | 207063 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993031.18209 | 2099190.3171200003 | 37.7435763017135 | -122.46676385469401 | (37.7435763017135, -122.466763854694) | |||
| 52098 | 52098 | 207062 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993034.65386 | 2099189.08337 | 37.7435731145127 | -122.46675176060499 | (37.7435731145127, -122.466751760605) | |||
| 183793 | 183793 | 207061 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993037.74509 | 2099188.24411 | 37.7435709885186 | -122.466741010989 | (37.7435709885186, -122.466741010989) | |||
| 113645 | 113645 | 97286 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768450 | 5993053.0 | 2098535.0 | 37.7417782258334 | -122.466640790543 | (37.7417782258334, -122.466640790543) | |||
| 69772 | 69772 | 207085 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2091 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993168.90781 | 2101284.1521799997 | 37.749333387335895 | -122.466439786693 | (37.7493333873359, -122.466439786693) | |||
| 155887 | 155887 | 207084 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2093 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993169.3721900005 | 2101262.29203 | 37.7492733917544 | -122.46643659227101 | (37.7492733917544, -122.466436592271) | |||
| 25932 | 25932 | 207066 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993124.54928 | 2098622.04482 | 37.7420213577054 | -122.46639972369101 | (37.7420213577054, -122.466399723691) | |||
| 126804 | 126804 | 44213 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1601 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2006 12:00:00 AM | Permit Number 43660 | 5993363.56248215 | 2104576.56937915 | 37.7583847466967 | -122.466005883185 | (37.7583847466967, -122.466005883185) | ||
| 90993 | 90993 | 108995 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772985 | 5993924.20809 | 2115202.12337 | 37.787592019403704 | -122.46483857455401 | (37.7875920194037, -122.464838574554) |
| 171953 | 171953 | 207069 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 5993748.4844 | 2102370.47272 | 37.752349572298606 | -122.46451448116999 | (37.7523495722986, -122.46451448117) | |||
| 33222 | 33222 | 207070 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5993749.21516 | 2102356.41341 | 37.752311011160295 | -122.464510933358 | (37.7523110111603, -122.464510933358) | |||
| 23452 | 23452 | 207071 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5993749.481269999 | 2102344.6615 | 37.752278758765605 | -122.464509159894 | (37.7522787587656, -122.464509159894) | |||
| 93936 | 93936 | 32892 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) |
| 31453 | 31453 | 207072 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 245 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994440.698340001 | 2100406.16627 | 37.7469959638947 | -122.46197828057899 | (37.7469959638947, -122.461978280579) | |||
| 42271 | 42271 | 207076 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994497.66006 | 2100431.13069 | 37.7470677891411 | -122.461783123205 | (37.7470677891411, -122.461783123205) | |||
| 182340 | 182340 | 207075 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5994498.162330001 | 2100407.0553599996 | 37.7470017132656 | -122.461779641027 | (37.7470017132656, -122.461779641027) | |||
| 46195 | 46195 | 207077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994500.88494 | 2100452.87217 | 37.74712767141 | -122.461773548104 | (37.74712767141, -122.461773548104) | |||
| 45787 | 45787 | 207074 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994502.2451599995 | 2100385.66213 | 37.7469432078786 | -122.46176397213301 | (37.7469432078786, -122.461763972133) | |||
| 175597 | 175597 | 207073 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994505.45248 | 2100370.5542599997 | 37.746901910105 | -122.46175178633601 | (37.746901910105, -122.461751786336) | |||
| 46688 | 46688 | 207094 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Kenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994559.61163 | 2093655.1393099998 | 37.728466159762505 | -122.46107783977101 | (37.7284661597625, -122.461077839771) | |||
| 182969 | 182969 | 48451 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5995956.24653 | 2113838.6701 | 37.783965291128204 | -122.457709472605 | (37.7839652911282, -122.457709472605) | ||
| 125055 | 125055 | 48453 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 5 | Permit Number 45822 | 5996008.37556 | 2113838.92432 | 37.7839689836389 | -122.45752914479601 | (37.7839689836389, -122.457529144796) | ||
| 146723 | 146723 | 48452 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5996026.36682 | 2113840.43033 | 37.7839741521628 | -122.457467011011 | (37.7839741521628, -122.457467011011) | ||
| 183467 | 183467 | 207095 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1565 Plymouth Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995634.15192 | 2094407.3594099998 | 37.730593351393296 | -122.457417521726 | (37.7305933513933, -122.457417521726) | |||
| 65837 | 65837 | 124124 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 61 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996360.44357 | 2112557.14678 | 37.7804697796635 | -122.45621841836599 | (37.7804697796635, -122.456218418366) | |||
| 52608 | 52608 | 207096 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 447 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996040.3151 | 2096410.52388 | 37.7361168767915 | -122.456158138087 | (37.7361168767915, -122.456158138087) | |||
| 26269 | 26269 | 207097 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 451 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996075.95126 | 2096408.69413 | 37.7361138982453 | -122.45603479789301 | (37.7361138982453, -122.456034797893) | |||
| 44196 | 44196 | 129400 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3766 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5996779.47393 | 2115339.45033 | 37.7881332907605 | -122.454969901653 | (37.7881332907605, -122.454969901653) | |||
| 157086 | 157086 | 129399 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3766 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5996788.91292 | 2115340.40834 | 37.788136462672604 | -122.454937313809 | (37.7881364626726, -122.454937313809) | |||
| 162331 | 162331 | 129397 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3729 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997011.377730001 | 2114998.8497200003 | 37.7872113930486 | -122.45414294896099 | (37.7872113930486, -122.454142948961) | |||
| 165795 | 165795 | 129398 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3729 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997021.62902 | 2114999.75252 | 37.787214459718705 | -122.454107547129 | (37.7872144597187, -122.454107547129) | |||
| 111098 | 111098 | 50485 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47121 | 5996542.39678919 | 2090678.14826944 | 37.720405949717104 | -122.45400837564699 | (37.7204059497171, -122.454008375647) | ||
| 161158 | 161158 | 129394 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3700 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5997109.1846199995 | 2115060.1871599997 | 37.7873854172521 | -122.45380899111099 | (37.7873854172521, -122.453808991111) | |||
| 70657 | 70657 | 129393 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3700 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997126.155040001 | 2115061.06795 | 37.7873888086001 | -122.45375034092 | (37.7873888086001, -122.45375034092) | |||
| 93338 | 93338 | 42428 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 769 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42578 | 5997011.02141138 | 2094977.36766372 | 37.7322374467316 | -122.45269862641099 | (37.7322374467316, -122.452698626411) | ||
| 60052 | 60052 | 207078 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 769 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5997019.6459099995 | 2094987.9782900002 | 37.73226707514829 | -122.452669575238 | (37.7322670751483, -122.452669575238) | |||
| 162702 | 162702 | 129396 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3570 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997759.42615 | 2115150.05593 | 37.7876694312425 | -122.451565786028 | (37.7876694312425, -122.451565786028) | |||
| 76698 | 76698 | 227631 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997896.0946 | 2104612.71078 | 37.758744422037395 | -122.450333060142 | (37.7587444220374, -122.450333060142) | |||
| 56432 | 56432 | 227632 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997905.871119999 | 2104612.50701 | 37.758744422044295 | -122.450299233916 | (37.7587444220443, -122.450299233916) | |||
| 168398 | 168398 | 129401 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5 Dicha Aly | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5998309.94171 | 2113772.92465 | 37.7839197016653 | -122.449561847418 | (37.7839197016653, -122.449561847418) | |||
| 53050 | 53050 | 245954 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 189 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998286.3355 | 2107663.1593 | 37.7671425117336 | -122.44920319850401 | (37.7671425117336, -122.449203198504) | |||
| 133580 | 133580 | 129395 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3383 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998662.1100699995 | 2115556.58452 | 37.7888373034598 | -122.44847197610399 | (37.7888373034598, -122.448471976104) | |||
| 132763 | 132763 | 48667 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3362 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2012 12:00:00 AM | 1 | Permit Number 768676 | 5998753.52645 | 2115612.95888 | 37.788997318923705 | -122.44815975037599 | (37.7889973189237, -122.448159750376) | ||
| 172614 | 172614 | 244059 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998660.6331 | 2109020.8428 | 37.7708917674934 | -122.44800632768299 | (37.7708917674934, -122.448006327683) | |||
| 58140 | 58140 | 141665 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5 MASONIC AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998794.5569 | 2112395.1526 | 37.7801644097761 | -122.44778604353901 | (37.7801644097761, -122.447786043539) | |||
| 47568 | 47568 | 54838 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.773438741186204 | -122.44770637361201 | (37.7734387411862, -122.447706373612) | ||
| 27723 | 27723 | 129402 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3000 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999090.32735 | 2119096.86414 | 37.7985824452762 | -122.44724531075 | (37.7985824452762, -122.44724531075) | |||
| 170548 | 170548 | 103458 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 212 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769919 | 5999039.39992 | 2115859.35215 | 37.789690188098504 | -122.447188409728 | (37.7896901880985, -122.447188409728) | |
| 65976 | 65976 | 129416 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 218 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999044.58564 | 2115840.24858 | 37.789638031029206 | -122.44716909230301 | (37.7896380310292, -122.447169092303) | |||
| 157758 | 157758 | 34595 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 224 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38290 | 5999049.11331 | 2115811.8927599997 | 37.7895604321171 | -122.447151385541 | (37.7895604321171, -122.447151385541) | |
| 31281 | 31281 | 227616 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 246 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999006.659659999 | 2106731.5709599997 | 37.764625778676 | -122.44664468051 | (37.764625778676, -122.44664468051) | |||
| 152769 | 152769 | 129415 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1914 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999481.122280001 | 2115602.98861 | 37.7890115102163 | -122.44564165674 | (37.7890115102163, -122.44564165674) | |||
| 184585 | 184585 | 56604 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1914 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5999483.43623 | 2115589.8774599996 | 37.788975642546 | -122.445632707581 | (37.788975642546, -122.445632707581) | ||||
| 37316 | 37316 | 35009 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 4 | Permit Number 38581 | 5999618.3524 | 2114616.3026 | 37.7863101621151 | -122.445095896882 | (37.7863101621151, -122.445095896882) | ||
| 167301 | 167301 | 35008 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50542 | 5999619.6658 | 2114602.5127 | 37.7862723736076 | -122.445090361129 | (37.7862723736076, -122.445090361129) | |
| 17457 | 17457 | 25179 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999420.685330001 | 2104753.2461200003 | 37.7592174321694 | -122.445070446966 | (37.7592174321694, -122.445070446966) | ||
| 17244 | 17244 | 25180 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999422.34121 | 2104738.79635 | 37.7591778511874 | -122.445063681349 | (37.7591778511874, -122.445063681349) | ||
| 20331 | 20331 | 25181 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 6 | 3X3 | 5999423.66493 | 2104708.37976 | 37.7590944103092 | -122.44505691664101 | (37.7590944103092, -122.445056916641) | ||
| 22166 | 22166 | 25182 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3226 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/1996 12:00:00 AM | 3 | 3X3 | 5999429.9273 | 2104670.84771 | 37.7589917140099 | -122.4450325603 | (37.7589917140099, -122.4450325603) | ||
| 98803 | 98803 | 104725 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2013 12:00:00 AM | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | ||
| 118595 | 118595 | 104724 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | |||
| 146952 | 146952 | 129404 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2844 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000064.89028 | 2118400.48534 | 37.7967260116595 | -122.44382296947799 | (37.7967260116595, -122.443822969478) | |||
| 31094 | 31094 | 87873 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2341 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50845 | 6000097.31037 | 2119864.70248 | 37.8007482115146 | -122.443816038389 | (37.8007482115146, -122.443816038389) | |
| 44629 | 44629 | 129403 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | |||
| 111844 | 111844 | 37577 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40010 | 5999933.60679892 | 2105019.65180732 | 37.759978178597 | -122.443315658152 | (37.759978178597, -122.443315658152) | ||
| 186402 | 186402 | 227647 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999980.75729 | 2104959.09552 | 37.7598145945821 | -122.44314823869499 | (37.7598145945821, -122.443148238695) | |||
| 70505 | 70505 | 227648 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999992.54639 | 2104934.00184 | 37.7597463657249 | -122.443105663906 | (37.7597463657249, -122.443105663906) | |||
| 76313 | 76313 | 227649 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999999.59495 | 2104920.93401 | 37.7597108865789 | -122.44308034798901 | (37.7597108865789, -122.443080347989) | |||
| 74636 | 74636 | 227650 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 154 Danvers St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000006.33119 | 2104908.8667200003 | 37.759678136855996 | -122.443056184107 | (37.759678136856, -122.443056184107) | |||
| 130376 | 130376 | 84614 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2034 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50834 | 6000478.89565 | 2121006.72285 | 37.8039056520943 | -122.442577640443 | (37.8039056520943, -122.442577640443) | |
| 189123 | 189123 | 84613 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.3597800005 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | |
| 75243 | 75243 | 129405 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3545 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000706.97602 | 2120551.39476 | 37.8026684412687 | -122.44175565829399 | (37.8026684412687, -122.441755658294) | |||
| 28468 | 28468 | 129406 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3545 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000708.230719999 | 2120533.5731200003 | 37.8026195792908 | -122.44175003663099 | (37.8026195792908, -122.441750036631) | |||
| 71525 | 71525 | 97676 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6000785.23545 | 2117926.05562 | 37.7954644138979 | -122.441296359259 | (37.7954644138979, -122.441296359259) | ||||
| 30187 | 30187 | 97675 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000810.80569 | 2117928.4487099997 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | ||||
| 81513 | 81513 | 102256 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1933 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.787654962994104 | -122.440900572101 | (37.7876549629941, -122.440900572101) | |
| 109705 | 109705 | 102257 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1933 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | 2 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.787654962994104 | -122.440900572101 | (37.7876549629941, -122.440900572101) | |
| 182154 | 182154 | 207098 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6000468.8354 | 2095254.59465 | 37.733196173744105 | -122.440764091915 | (37.7331961737441, -122.440764091915) | ||||
| 130451 | 130451 | 176925 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 17 Curtis St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 6000534.5551 | 2088493.30994 | 37.7146349724878 | -122.440052229032 | (37.7146349724878, -122.440052229032) | |||
| 168888 | 168888 | 176927 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200 Morse St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 10ft | 6000575.21017 | 2087869.90013 | 37.7129255429455 | -122.43986703794201 | (37.7129255429455, -122.439867037942) | |||
| 160010 | 160010 | 176926 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200 Morse St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6000586.22066 | 2087873.8924099999 | 37.712937131606395 | -122.439829268227 | (37.7129371316064, -122.439829268227) | |||
| 105851 | 105851 | 55533 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000967.89961965 | 2104951.08442142 | 37.759848834973795 | -122.439733631625 | (37.7598488349738, -122.439733631625) | ||
| 111896 | 111896 | 63101 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 18 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000981.26282803 | 2104951.87977531 | 37.759851779436495 | -122.439687471955 | (37.7598517794365, -122.439687471955) | ||
| 2850 | 2850 | 27607 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001133.4058 | 2111053.0447 | 37.7766127217509 | -122.439598674592 | (37.7766127217509, -122.439598674592) | |||
| 6797 | 6797 | 27608 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001149.4313 | 2111053.53 | 37.776614966343296 | -122.439543272646 | (37.7766149663433, -122.439543272646) |
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");