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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157041 | 157041 | 199935 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1310 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017874.9241 | 2092620.1152 | 37.726938315047896 | -122.380402857754 | (37.7269383150479, -122.380402857754) | |||
| 29311 | 29311 | 199962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1265 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018011.0370000005 | 2092725.2017 | 37.7272343718441 | -122.379939611903 | (37.7272343718441, -122.379939611903) | |||
| 173580 | 173580 | 176972 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 161 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008005.59306 | 2093164.83572 | 37.7278844827614 | -122.41455957148399 | (37.7278844827614, -122.414559571484) | |||
| 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) | |||
| 52869 | 52869 | 176964 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 329 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 6004071.94661 | 2093622.05007 | 37.728918110483 | -122.42819085295099 | (37.728918110483, -122.428190852951) | |||
| 169077 | 169077 | 176965 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 327 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 6004071.24912 | 2093653.41815 | 37.7290042007626 | -122.428195498837 | (37.7290042007626, -122.428195498837) | |||
| 174066 | 174066 | 176973 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 82 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008143.29471 | 2093583.4510299999 | 37.729041645841896 | -122.414113135409 | (37.7290416458419, -122.414113135409) | |||
| 136471 | 136471 | 176966 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 327 Craut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 7ft | 6004069.61366 | 2093704.49695 | 37.7291443592041 | -122.42820479154301 | (37.7291443592041, -122.428204791543) | |||
| 162168 | 162168 | 176971 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Tulane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007468.11752 | 2093808.15267 | 37.7296206815304 | -122.416463191631 | (37.7296206815304, -122.416463191631) | |||
| 59805 | 59805 | 176969 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004020.786 | 2094067.71187 | 37.7301389032718 | -122.428399470475 | (37.7301389032718, -122.428399470475) | |||
| 28952 | 28952 | 176968 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004019.9865 | 2094083.3714700001 | 37.7301818557853 | -122.428403350153 | (37.7301818557853, -122.428403350153) | |||
| 150746 | 150746 | 176967 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004019.42662 | 2094104.5358400003 | 37.7302399367234 | -122.428406793639 | (37.7302399367234, -122.428406793639) | |||
| 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) | |||
| 187273 | 187273 | 176963 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 83 Badger St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6002428.97482 | 2094295.2581 | 37.7306734890866 | -122.43391881851299 | (37.7306734890866, -122.433918818513) | |||
| 171684 | 171684 | 176974 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 15 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009262.49228 | 2094178.39386 | 37.730738031628704 | -122.410285956242 | (37.7307380316287, -122.410285956242) | |||
| 157316 | 157316 | 176970 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 146 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004341.61716 | 2094290.0126599998 | 37.7307674412459 | -122.42730614487301 | (37.7307674412459, -122.427306144873) | |||
| 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) | |||
| 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) | |||
| 156796 | 156796 | 191266 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1721 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 9ft | 6014437.69224 | 2094855.17275 | 37.7328850694924 | -122.39244165855499 | (37.7328850694924, -122.392441658555) | |||
| 33924 | 33924 | 38574 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | |
| 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) | ||||
| 94438 | 94438 | 41525 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.733693765900604 | -122.37859297315 | (37.7336937659006, -122.37859297315) | |||
| 71664 | 71664 | 227629 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 62 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003056.07384 | 2095532.6693400003 | 37.7341067067448 | -122.431839162348 | (37.7341067067448, -122.431839162348) | |||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 166791 | 166791 | 191265 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2100 Thomas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6012134.75084 | 2095927.2478099999 | 37.735700607590296 | -122.400478845738 | (37.7357006075903, -122.400478845738) | ||||
| 26504 | 26504 | 227603 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.07862 | 2096101.1879099999 | 37.735749708773795 | -122.42687342978998 | (37.7357497087738, -122.42687342979) | ||||
| 184269 | 184269 | 227602 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657887994 | -122.426906353066 | (37.735757657888, -122.426906353066) | ||||
| 166757 | 166757 | 227604 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004502.9106 | 2096117.99556 | 37.7357957927473 | -122.426878664735 | (37.7357957927473, -122.426878664735) | ||||
| 165842 | 165842 | 227605 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.61589 | 2096121.06345 | 37.735804312902204 | -122.426872987299 | (37.7358043129022, -122.426872987299) | ||||
| 184382 | 184382 | 227607 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004513.177130001 | 2096122.0643 | 37.735807545078295 | -122.426843458979 | (37.7358075450783, -122.426843458979) | ||||
| 54300 | 54300 | 227606 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | ||||
| 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) | |||
| 44798 | 44798 | 227608 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 161451 | 161451 | 227601 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1100 San Jose Ave | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004769.19859 | 2096667.0685 | 37.7373184762576 | -122.425997076417 | (37.7373184762576, -122.425997076417) | ||||
| 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) | |||
| 55800 | 55800 | 227661 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003680.16981 | 2096890.8857099998 | 37.7378714190205 | -122.42977831104099 | (37.7378714190205, -122.429778311041) | |||
| 184634 | 184634 | 227630 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 10 Arbor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002176.820309999 | 2096986.40745 | 37.7380484541639 | -122.43498294671998 | (37.7380484541639, -122.43498294672) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 61708 | 61708 | 227660 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 195 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6003113.10037 | 2097586.0775 | 37.73974812787179 | -122.43178856828101 | (37.7397481278718, -122.431788568281) | |||
| 162520 | 162520 | 227662 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 32 Harry St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6003182.99622 | 2097643.55659 | 37.7399099141156 | -122.43155100069099 | (37.7399099141156, -122.431551000691) | |||
| 168581 | 168581 | 227609 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6006260.1728300005 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | ||||
| 62886 | 62886 | 227610 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6006250.04952 | 2097648.9456700003 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | ||||
| 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) | |||
| 87075 | 87075 | 52479 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) | ||
| 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) | ||
| 184290 | 184290 | 227618 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 119 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009077.3937800005 | 2097965.31988 | 37.7411257345706 | -122.411193275964 | (37.7411257345706, -122.411193275964) | |||
| 116693 | 116693 | 37466 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39937 | 6009086.92753477 | 2097969.49395992 | 37.7411377303504 | -122.411160606325 | (37.7411377303504, -122.411160606325) | ||
| 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) | |
| 69654 | 69654 | 227617 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) |
| 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) | |||
| 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) | |||
| 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) | |||
| 78213 | 78213 | 37034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 266 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48449 | 6004870.65820445 | 2098448.14678483 | 37.7422146471398 | -122.42577301954901 | (37.7422146471398, -122.425773019549) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 171630 | 171630 | 227590 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 33 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6005514.0143099995 | 2098729.37498 | 37.743023170990604 | -122.423568480604 | (37.7430231709906, -122.423568480604) | |||
| 174716 | 174716 | 227591 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 27 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6005552.79952 | 2098729.9467700003 | 37.743026930158294 | -122.423434412384 | (37.7430269301583, -122.423434412384) | |||
| 118583 | 118583 | 26205 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 750 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/20/2007 12:00:00 AM | 12 | 3X3 | 6005640.0872799 | 2098758.1364942 | 37.743109258996206 | -122.423134597972 | (37.7431092589962, -122.423134597972) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");