Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26842 | 26842 | 249462 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6006460.85988 | 2113718.34687 | 37.784232765583 | -122.42135874831499 | (37.784232765583, -122.421358748315) | |||
27885 | 27885 | 210725 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 20 Edgar Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997113.75654 | 2090895.52443 | 37.7210355581178 | -122.452049055632 | (37.7210355581178, -122.452049055632) | |||
29418 | 29418 | 247623 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 261 Bradford St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6009541.508359999 | 2097060.7150400002 | 37.738667903594205 | -122.409524699022 | (37.7386679035942, -122.409524699022) | |||
29734 | 29734 | 249449 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 250 Olive St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6006158.32839 | 2113696.95162 | 37.7841569581316 | -122.422403881033 | (37.7841569581316, -122.422403881033) | |||
30805 | 30805 | 194120 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 75 Oak Grove St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012056.17784 | 2111087.81775 | 37.7773238174893 | -122.401815843529 | (37.7773238174893, -122.401815843529) | |||
31843 | 31843 | 247696 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 66 Central Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 5999969.16959 | 2108614.08966 | 37.769849637370896 | -122.443450859673 | (37.7698496373709, -122.443450859673) | |||
32045 | 32045 | 210733 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 239 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992956.15258 | 2088805.3429599998 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | |||
33233 | 33233 | 249455 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 251 Olive St | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6006189.184780001 | 2113676.83316 | 37.7841034583637 | -122.42229569890699 | (37.7841034583637, -122.422295698907) | |||
33560 | 33560 | 249460 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6006400.35451 | 2113710.6450799997 | 37.7842082068819 | -122.421567528645 | (37.7842082068819, -122.421567528645) | |||
34756 | 34756 | 210594 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1598 10th Ave | 8 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5993107.5867 | 2104697.22808 | 37.758701273452 | -122.46689992480499 | (37.758701273452, -122.466899924805) | |||
37969 | 37969 | 194119 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 75 Oak Grove St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012059.36571 | 2111084.5117200003 | 37.7773149177954 | -122.401804583142 | (37.7773149177954, -122.401804583142) | |||
38107 | 38107 | 210738 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 291 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5992961.95972 | 2089127.5323299998 | 37.7159423862175 | -122.46627205143999 | (37.7159423862175, -122.46627205144) | |||
40108 | 40108 | 232434 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Church St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004077.27006 | 2108309.3730900004 | 37.7692463811546 | -122.429219306844 | (37.7692463811546, -122.429219306844) | |||
41569 | 41569 | 249457 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6006319.82833 | 2113698.46294 | 37.784170216831896 | -122.42184525546101 | (37.7841702168319, -122.421845255461) | |||
41979 | 41979 | 210728 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 113 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997053.85221 | 2089279.44742 | 37.716594756218 | -122.45213958229999 | (37.716594756218, -122.4521395823) | |||
42546 | 42546 | 194178 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 198 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013413.48709 | 2106240.0372599997 | 37.7640885515801 | -122.396780493551 | (37.7640885515801, -122.396780493551) | |||
44677 | 44677 | 232436 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 98 Laussat St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004291.459919999 | 2109275.43151 | 37.7719110660771 | -122.428547305538 | (37.7719110660771, -122.428547305538) | |||
46225 | 46225 | 233148 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3980 22nd St | 10 | : 4 | Tree 1 | Private 1 | 6 | 6001886.52284 | 2102943.06219 | 37.7543875349734 | -122.4364128508 | (37.7543875349734, -122.4364128508) | ||||
49065 | 49065 | 249452 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 251 Olive St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006131.50296 | 2113669.15355 | 37.7840791181899 | -122.42249471166299 | (37.7840791181899, -122.422494711663) | |||
49893 | 49893 | 210597 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1598 10th Ave | 16 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5993106.74835 | 2104720.89396 | 37.7587662054039 | -122.466904544628 | (37.7587662054039, -122.466904544628) | |||
50682 | 50682 | 249451 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 251 Olive St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6006114.5159 | 2113666.03761 | 37.7840696042744 | -122.422553259352 | (37.7840696042744, -122.422553259352) | |||
54728 | 54728 | 250097 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1701 Pine St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6005753.0625599995 | 2115514.84991 | 37.789125586518395 | -122.423935271799 | (37.7891255865184, -122.423935271799) | |||
58614 | 58614 | 233147 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3978 22nd St | 3 | : 4 | Tree 1 | Private 1 | 2 | 6001977.86453 | 2102958.17095 | 37.7544342097936 | -122.43609804939899 | (37.7544342097936, -122.436098049399) | ||||
60030 | 60030 | 250487 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 222 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5987893.38095 | 2115356.6041900003 | 37.7876666226671 | -122.485715124257 | (37.7876666226671, -122.485715124257) | |||
60152 | 60152 | 194121 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 174 Langton St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6010449.01935 | 2110432.74871 | 37.775435329303896 | -122.407329361273 | (37.7754353293039, -122.407329361273) | |||
62642 | 62642 | 249450 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 250 Olive St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006131.652509999 | 2113691.8301 | 37.7841413908581 | -122.42249580613701 | (37.7841413908581, -122.422495806137) | |||
63272 | 63272 | 210731 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 555 Arch St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992721.77233 | 2090849.6653200001 | 37.7206570847417 | -122.46722738773 | (37.7206570847417, -122.46722738773) | |||
63808 | 63808 | 210595 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1598 10th Ave | 11 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5993107.35573 | 2104707.43103 | 37.7587292747629 | -122.466901465326 | (37.7587292747629, -122.466901465326) | |||
68746 | 68746 | 247778 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 250 30th St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004957.69836 | 2098452.79483 | 37.7422323278575 | -122.42547239214 | (37.7422323278575, -122.42547239214) | |||
72457 | 72457 | 194194 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1888 Illinois St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6016264.99223 | 2100427.37243 | 37.7482865000228 | -122.38651255153499 | (37.7482865000228, -122.386512551535) | |||
75119 | 75119 | 249453 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 251 Olive St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006151.02275 | 2113672.37502 | 37.784089064710706 | -122.422427409114 | (37.7840890647107, -122.422427409114) | |||
75787 | 75787 | 232433 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Church St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004078.2597199995 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | |||
76083 | 76083 | 210736 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 279 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992958.0876400005 | 2089050.23377 | 37.715729919564794 | -122.466279820655 | (37.7157299195648, -122.466279820655) | |||
76502 | 76502 | 246528 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 7ft | 6005204.62433 | 2109172.65839 | 37.7716805104709 | -122.425381286315 | (37.7716805104709, -122.425381286315) | |||
76701 | 76701 | 233160 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 130 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997752.886419999 | 2104152.69917 | 37.75747314847929 | -122.45079516956801 | (37.7574731484793, -122.450795169568) | |||
77279 | 77279 | 246979 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 16 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6005040.7561800005 | 2101085.41279 | 37.7494655858732 | -122.425372506247 | (37.7494655858732, -122.425372506247) | |||
109903 | 109903 | 247670 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 170 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6001927.47375 | 2108582.2733299998 | 37.7698737616969 | -122.43667486556801 | (37.7698737616969, -122.436674865568) | |||
129559 | 129559 | 249448 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 238 Olive St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006176.73504 | 2113699.88088 | 37.7841660394729 | -122.42234040870599 | (37.7841660394729, -122.422340408706) | |||
131266 | 131266 | 250766 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 242 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5985905.94434 | 2114279.52557 | 37.7845932723154 | -122.49251182078699 | (37.7845932723154, -122.492511820787) | |||
135596 | 135596 | 210726 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997442.65634 | 2089908.8671900001 | 37.7183452613979 | -122.450841045792 | (37.7183452613979, -122.450841045792) | |||
146951 | 146951 | 194174 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 638 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012975.69145 | 2104038.69902 | 37.7580197843001 | -122.398140262177 | (37.7580197843001, -122.398140262177) | |||
152568 | 152568 | 210596 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1598 10th Ave | 13 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 5993107.01633 | 2104712.4635099997 | 37.758743073052294 | -122.466903004965 | (37.7587430730523, -122.466903004965) | |||
153062 | 153062 | 194172 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 664 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012676.7573 | 2104370.99604 | 37.758915544131206 | -122.39919743593599 | (37.7589155441312, -122.399197435936) | |||
153731 | 153731 | 249447 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 238 Olive St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006223.8532 | 2113706.94532 | 37.7841880944532 | -122.422177898507 | (37.7841880944532, -122.422177898507) | |||
156149 | 156149 | 210737 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 283 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992959.06004 | 2089081.2292400002 | 37.7158150817716 | -122.466278710897 | (37.7158150817716, -122.466278710897) | |||
156935 | 156935 | 210734 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 270 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992990.46687 | 2089001.9103599999 | 37.7155991032881 | -122.466164394482 | (37.7155991032881, -122.466164394482) | |||
161527 | 161527 | 250126 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1730 Pine St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005603.2664 | 2115542.36715 | 37.7891926840386 | -122.424455506243 | (37.7891926840386, -122.424455506243) | |||
162609 | 162609 | 249459 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6006372.75274 | 2113706.04085 | 37.784194008402 | -122.42166269399598 | (37.784194008402, -122.421662693996) | |||
162713 | 162713 | 249454 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 251 Olive St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006170.8585 | 2113675.59 | 37.784099011196204 | -122.422359012976 | (37.7840990111962, -122.422359012976) | |||
163050 | 163050 | 250096 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1701 Pine St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6005700.6097099995 | 2115508.13842 | 37.789104197049 | -122.42411627476002 | (37.789104197049, -122.42411627476) | |||
163484 | 163484 | 249461 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6006433.55883 | 2113714.71473 | 37.784221253347894 | -122.42145294241001 | (37.7842212533479, -122.42145294241) | |||
164138 | 164138 | 194195 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 9 Pomona St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 6ft | 6014203.67115 | 2094680.19203 | 37.732391609687205 | -122.393238495663 | (37.7323916096872, -122.393238495663) | |||
165423 | 165423 | 210735 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 274 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992991.6057 | 2089025.5479400002 | 37.7156640721019 | -122.466162174951 | (37.7156640721019, -122.466162174951) | |||
169004 | 169004 | 210729 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2950 San Jose Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5996042.96304 | 2087509.5172700002 | 37.711676981779 | -122.455505847225 | (37.711676981779, -122.455505847225) | |||
171513 | 171513 | 249456 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6006295.7266 | 2113694.91688 | 37.784159120994 | -122.421928386997 | (37.784159120994, -122.421928386997) | |||
172626 | 172626 | 210727 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 20 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997384.6848 | 2089822.80773 | 37.71810564333521 | -122.451035225606 | (37.7181056433352, -122.451035225606) | |||
173781 | 173781 | 246530 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Laguna St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 7ft | 6005220.62037 | 2109069.23024 | 37.7713974254703 | -122.42531859367901 | (37.7713974254703, -122.425318593679) | |||
176809 | 176809 | 249458 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Olive St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6006350.21001 | 2113701.7523 | 37.7841809619115 | -122.421740379236 | (37.7841809619115, -122.421740379236) | |||
178078 | 178078 | 232431 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 340 Church St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6004146.9562099995 | 2106961.5973900002 | 37.765549659406794 | -122.428882166285 | (37.7655496594068, -122.428882166285) | |||
179908 | 179908 | 210739 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 378 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993261.2949 | 2089711.8184099998 | 37.717563961885396 | -122.465279833897 | (37.7175639618854, -122.465279833897) | |||
181773 | 181773 | 246529 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 95 Laguna St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6005210.23202 | 2109136.89842 | 37.77158263905 | -122.425359343752 | (37.77158263905, -122.425359343752) | |||
185707 | 185707 | 232432 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Church St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6004078.65513 | 2108269.95494 | 37.7691382268875 | -122.429211704867 | (37.7691382268875, -122.429211704867) | |||
187483 | 187483 | 194179 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 198 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013413.98851 | 2106222.8030000003 | 37.7640412580141 | -122.39677755096201 | (37.7640412580141, -122.396777550962) |
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");