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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 47927 | 47927 | 227620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005907.97007 | 2102264.4901400004 | 37.752752018913796 | -122.422457421298 | (37.7527520189138, -122.422457421298) | |||
| 51298 | 51298 | 200113 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | |||
| 52001 | 52001 | 200104 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.39045295200899 | (37.726258938018, -122.390452952009) | |||
| 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) | |||
| 54047 | 54047 | 176922 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 298 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003957.47292 | 2089506.6993599997 | 37.7176117887305 | -122.42829341070801 | (37.7176117887305, -122.428293410708) | |||
| 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) | |||
| 56909 | 56909 | 200009 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1435 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017676.8443 | 2092268.1534 | 37.72596096442079 | -122.381063162948 | (37.7259609644208, -122.381063162948) | |||
| 62276 | 62276 | 200097 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015067.4938 | 2092354.869 | 37.7260546913573 | -122.390089647295 | (37.7260546913573, -122.390089647295) | |||
| 62411 | 62411 | 176924 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 525 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002840.55904 | 2090695.62 | 37.720813038882206 | -122.43223893347799 | (37.7208130388822, -122.432238933478) | |||
| 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) | ||
| 64273 | 64273 | 176978 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002453.716630001 | 2086834.19677 | 37.7101884805901 | -122.433300348445 | (37.7101884805901, -122.433300348445) | |||
| 64313 | 64313 | 200002 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017646.9261 | 2092314.6221 | 37.726086906985 | -122.381169818775 | (37.726086906985, -122.381169818775) | |||
| 64448 | 64448 | 200105 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014949.7328 | 2092444.2049 | 37.7262934578304 | -122.39050298275801 | (37.7262934578304, -122.390502982758) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | |||
| 73208 | 73208 | 49756 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1171 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46552 | 6011373.3818 | 2089351.75942 | 37.71760318852571 | -122.40264894398899 | (37.7176031885257, -122.402648943989) | |
| 73740 | 73740 | 200018 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1008 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6018250.1161 | 2092086.6599 | 37.7254942451327 | -122.37906877917801 | (37.7254942451327, -122.379068779178) | |||
| 77131 | 77131 | 54664 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 360 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10488 | 6012252.975769999 | 2086866.6648099998 | 37.710828684568206 | -122.399434200424 | (37.7108286845682, -122.399434200424) | ||
| 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) | |
| 98308 | 98308 | 107371 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 448 BROADWAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | ||||
| 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) | |||
| 131229 | 131229 | 200112 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1560 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014792.7183 | 2092559.9355 | 37.726602519263004 | -122.391053863847 | (37.726602519263, -122.391053863847) | |||
| 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) |
| 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) | ||
| 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) | |||
| 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) | |||
| 148096 | 148096 | 176961 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 41 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011207.15899 | 2087778.71194 | 37.7132746363936 | -122.403112916852 | (37.7132746363936, -122.403112916852) | |||
| 148569 | 148569 | 200000 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017688.3023 | 2092371.2757 | 37.726244750724 | -122.381030719301 | (37.726244750724, -122.381030719301) | |||
| 148905 | 148905 | 99379 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 152536 | 152536 | 176979 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002427.23589 | 2086817.03836 | 37.7101398650242 | -122.433390645786 | (37.7101398650242, -122.433390645786) | |||
| 156333 | 156333 | 129391 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1851 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004117.78483 | 2119036.12679 | 37.798701658520706 | -122.42984439412399 | (37.7987016585207, -122.429844394124) | |||
| 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) | |||
| 159060 | 159060 | 200098 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015053.9581 | 2092365.0208 | 37.726081815437205 | -122.39013714867201 | (37.7260818154372, -122.390137148672) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 172420 | 172420 | 200111 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1552 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014807.6076 | 2092549.7837 | 37.726575470666106 | -122.39100168241998 | (37.7265754706661, -122.39100168242) | |||
| 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) | |||
| 173778 | 173778 | 71255 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 1 | 6007494.44606 | 2117816.87319 | 37.795544530015604 | -122.418073553678 | (37.7955445300156, -122.418073553678) | ||
| 176268 | 176268 | 200103 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014982.2186 | 2092417.8102 | 37.72622278535071 | -122.390388836652 | (37.7262227853507, -122.390388836652) | |||
| 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) | |||
| 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) | |||
| 181896 | 181896 | 176977 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6002472.369080001 | 2086850.07188 | 37.710233128335396 | -122.433237015483 | (37.7102331283354, -122.433237015483) | |||
| 182025 | 182025 | 200099 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015044.482999999 | 2092374.4958 | 37.7261073063636 | -122.390170565448 | (37.7261073063636, -122.390170565448) | |||
| 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) | |||
| 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) | ||||
| 187479 | 187479 | 227589 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 23 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006036.6609 | 2100222.07218 | 37.7471512660344 | -122.42186731675 | (37.7471512660344, -122.42186731675) | |||
| 187926 | 187926 | 176923 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 298 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003940.88243 | 2089479.82592 | 37.7175370613599 | -122.42834884222201 | (37.7175370613599, -122.428348842222) | |||
| 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) | |
| 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) | ||||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 41440 | 41440 | 191311 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015151.76995 | 2107799.07376 | 37.76846592338129 | -122.39087719613501 | (37.7684659233813, -122.390877196135) | |||
| 42249 | 42249 | 105036 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6x6 | Permit Number 771181 | 6015089.32821 | 2107914.09587 | 37.7687782840212 | -122.39110121906201 | (37.7687782840212, -122.391101219062) | ||
| 43823 | 43823 | 191356 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015114.10558 | 2107443.69394 | 37.7674880383618 | -122.39098263356199 | (37.7674880383618, -122.390982633562) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 59332 | 59332 | 200004 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6017626.5562 | 2092285.3405 | 37.7260053809224 | -122.38123820192101 | (37.7260053809224, -122.381238201921) | |||
| 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) | |||
| 60304 | 60304 | 191330 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014815.79386 | 2110104.2477700002 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | |||
| 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) | ||
| 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) | |||
| 67146 | 67146 | 105243 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 616 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 770335 | 6007163.0512 | 2091665.3874599999 | 37.723719949895 | -122.417366048922 | (37.723719949895, -122.417366048922) | |
| 69047 | 69047 | 227628 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4222 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6001065.76771 | 2102912.44614 | 37.754256799634796 | -122.43924903191002 | (37.7542567996348, -122.43924903191) | |||
| 69337 | 69337 | 129433 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004155.37388 | 2116318.23991 | 37.791241164293496 | -122.429520390877 | (37.7912411642935, -122.429520390877) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 99532 | 99532 | 89079 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 522 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 2 | 3x3 | 5990340.26635 | 2111799.54514 | 37.7780422011609 | -122.476989449392 | (37.7780422011609, -122.476989449392) | ||
| 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) | |||
| 109677 | 109677 | 89070 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 610 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 2 | 3x3 | 5990363.96165 | 2111197.3405 | 37.776390087833796 | -122.476863467892 | (37.7763900878338, -122.476863467892) | ||
| 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) | |
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 156882 | 156882 | 191347 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015093.18746 | 2107823.28717 | 37.768529157422705 | -122.391081522115 | (37.7685291574227, -122.391081522115) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 159374 | 159374 | 129432 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004124.61142 | 2116315.60844 | 37.7912321971464 | -122.429626640374 | (37.7912321971464, -122.429626640374) | |||
| 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) | |||
| 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) | |||
| 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) |
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");