Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31416 | 31416 | 198059 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6016002.244 | 2105125.97833 | 37.7611733325983 | -122.387748922377 | (37.7611733325983, -122.387748922377) | |||
| 33100 | 33100 | 198058 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6016003.50284 | 2105138.76714 | 37.7612085176665 | -122.387745460881 | (37.7612085176665, -122.387745460881) | |||
| 72093 | 72093 | 198060 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6016003.71174 | 2105110.97053 | 37.761132205694295 | -122.387742798886 | (37.7611322056943, -122.387742798886) | |||
| 133930 | 133930 | 198057 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015999.46733 | 2105182.54146 | 37.7613284890375 | -122.38776247247499 | (37.7613284890375, -122.387762472475) | |||
| 156731 | 156731 | 198053 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6015994.50717 | 2105252.5943299998 | 37.761520564453896 | -122.387784515751 | (37.7615205644539, -122.387784515751) | |||
| 159393 | 159393 | 198054 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015996.1825 | 2105236.6253 | 37.7614768097219 | -122.387777607167 | (37.7614768097219, -122.387777607167) | |||
| 161939 | 161939 | 198055 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015997.74921 | 2105213.0549 | 37.7614121772375 | -122.387770543876 | (37.7614121772375, -122.387770543876) | |||
| 180161 | 180161 | 198056 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 9ft | 6015997.12564 | 2105199.4171 | 37.761374696215704 | -122.38777174897699 | (37.7613746962157, -122.387771748977) | |||
| 2953 | 2953 | 192045 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013178.04643 | 2110099.77457 | 37.7746734191738 | -122.39786558493401 | (37.7746734191738, -122.397865584934) | |
| 2963 | 2963 | 192048 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013251.73009 | 2110171.5616599997 | 37.7748746334969 | -122.39761573260401 | (37.7748746334969, -122.397615732604) | |
| 2964 | 2964 | 192047 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013240.399669999 | 2110155.0455099996 | 37.7748286529654 | -122.397653768512 | (37.7748286529654, -122.397653768512) | |
| 2979 | 2979 | 192049 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013269.505969999 | 2110186.9808900002 | 37.77491796101779 | -122.397555323332 | (37.7749179610178, -122.397555323332) | |
| 2980 | 2980 | 192046 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013200.03931 | 2110117.49199 | 37.774723291973096 | -122.39779074965 | (37.7747232919731, -122.39779074965) | |
| 3009 | 3009 | 192050 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Townsend St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013285.99525 | 2110202.74852 | 37.774962173497 | -122.39749938908501 | (37.774962173497, -122.397499389085) | |
| 4433 | 4433 | 180628 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 339 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:40:00 AM | 3 | Width 8ft | 6001976.18123 | 2086917.49182 | 37.710390087913794 | -122.43495675757299 | (37.7103900879138, -122.434956757573) | ||
| 24059 | 24059 | 180255 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003484.65095 | 2094730.37892 | 37.73192808471529 | -122.4303002173 | (37.7319280847153, -122.4303002173) | |||
| 25789 | 25789 | 180259 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003405.48601 | 2094728.1839700001 | 37.7319175734374 | -122.430573750589 | (37.7319175734374, -122.430573750589) | |||
| 32316 | 32316 | 180260 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003350.60066 | 2094725.0139900001 | 37.731905759936204 | -122.43076327462299 | (37.7319057599362, -122.430763274623) | |||
| 37137 | 37137 | 180253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003528.91801 | 2094729.13365 | 37.7319271727957 | -122.430147087941 | (37.7319271727957, -122.430147087941) | |||
| 40388 | 40388 | 180264 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 Still St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003250.762019999 | 2094715.77972 | 37.731874747719296 | -122.43110777880699 | (37.7318747477193, -122.431107778807) | |||
| 52006 | 52006 | 180261 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 81 Rotteck St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003329.74924 | 2094722.2171 | 37.7318968989209 | -122.43083516281601 | (37.7318968989209, -122.430835162816) | |||
| 52806 | 52806 | 180320 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 817 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6001210.40568 | 2092189.73212 | 37.7248229683925 | -122.43798083136801 | (37.7248229683925, -122.437980831368) | |||
| 53016 | 53016 | 180001 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 62 Tomaso Ct | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6009181.15123 | 2086279.38185 | 37.709044431429604 | -122.41000974567899 | (37.7090444314296, -122.410009745679) | |||
| 59741 | 59741 | 180263 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 Still St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003281.3255900005 | 2094718.1068900002 | 37.7318828694844 | -122.431002280233 | (37.7318828694844, -122.431002280233) | |||
| 74370 | 74370 | 180257 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003441.65592 | 2094728.25721 | 37.7319198235266 | -122.430448708839 | (37.7319198235266, -122.430448708839) | |||
| 136973 | 136973 | 180258 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003421.15336 | 2094728.39885 | 37.7319190510051 | -122.43051960059799 | (37.7319190510051, -122.430519600598) | |||
| 148487 | 148487 | 180262 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 76 Rotteck St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003305.93949 | 2094720.0194 | 37.7318895154806 | -122.43091732130199 | (37.7318895154806, -122.430917321302) | |||
| 153804 | 153804 | 180256 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003464.1171 | 2094730.21395 | 37.7319264686289 | -122.430371195377 | (37.7319264686289, -122.430371195377) | |||
| 166436 | 166436 | 241422 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 687 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6001495.68949 | 2099380.02037 | 37.7445820558098 | -122.437509311417 | (37.7445820558098, -122.437509311417) | |||
| 179681 | 179681 | 180254 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003505.97344 | 2094729.60695 | 37.7319271728025 | -122.43022644590599 | (37.7319271728025, -122.430226445906) | |||
| 181102 | 181102 | 180251 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003572.96144 | 2094730.3764 | 37.7319330795535 | -122.42999490913799 | (37.7319330795535, -122.429994909138) | |||
| 184848 | 184848 | 180252 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003553.26198 | 2094731.05162 | 37.7319338178795 | -122.43006306247801 | (37.7319338178795, -122.430063062478) | |||
| 187661 | 187661 | 242298 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 297 Addison St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6002506.63703 | 2097692.2502 | 37.740005256637204 | -122.433893045753 | (37.7400052566372, -122.433893045753) | |||
| 28793 | 28793 | 198050 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 6015069.990669999 | 2101754.6780000003 | 37.7518647765405 | -122.39073761146001 | (37.7518647765405, -122.39073761146) | |||
| 43636 | 43636 | 198046 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6015063.38208 | 2101850.3789 | 37.7521271843206 | -122.39076715240299 | (37.7521271843206, -122.390767152403) | |||
| 49735 | 49735 | 198045 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 7ft | 6015062.9459 | 2101861.12211 | 37.752156658702795 | -122.39076941150299 | (37.7521566587028, -122.390769411503) | |||
| 55861 | 55861 | 198051 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6015071.52893 | 2101713.75148 | 37.75175248631 | -122.390729432117 | (37.75175248631, -122.390729432117) | |||
| 56508 | 56508 | 198049 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6015069.63855 | 2101758.53914 | 37.751875358878706 | -122.39073909895201 | (37.7518753588787, -122.390739098952) | |||
| 60681 | 60681 | 198052 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6015072.05685 | 2101707.95994 | 37.7517366132545 | -122.390727201795 | (37.7517366132545, -122.390727201795) | |||
| 153806 | 153806 | 198047 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6015066.24104 | 2101813.8486200003 | 37.75202703851829 | -122.390754712971 | (37.7520270385183, -122.390754712971) | |||
| 156215 | 156215 | 202208 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1978 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6012988.24456 | 2093553.53748 | 37.7292304495144 | -122.397361556292 | (37.7292304495144, -122.397361556292) | |||
| 157246 | 157246 | 198048 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1410 Indiana St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 6015066.1545400005 | 2101809.56795 | 37.7520152799043 | -122.390754712983 | (37.7520152799043, -122.390754712983) | |||
| 182094 | 182094 | 202209 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1988 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6012983.51399 | 2093557.8365599997 | 37.7292419905249 | -122.39737821176 | (37.7292419905249, -122.39737821176) | |||
| 3423 | 3423 | 251752 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
| 3432 | 3432 | 180655 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | |||
| 3488 | 3488 | 251753 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
| 28332 | 28332 | 120358 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2350 Lake St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988092.81378 | 2114686.07827 | 37.785837168438604 | -122.48497592142598 | (37.7858371684386, -122.484975921426) | |||
| 30355 | 30355 | 180399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 349 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002410.48398 | 2086459.29818 | 37.7091566380421 | -122.433422996175 | (37.7091566380421, -122.433422996175) | |||
| 58332 | 58332 | 241490 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2115 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 6ft | 6002706.79399 | 2099384.51572 | 37.744663180953495 | -122.433321879096 | (37.7446631809535, -122.433321879096) | |||
| 136105 | 136105 | 241643 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 599 Buchanan St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6004545.6184 | 2110424.56888 | 37.7750806969521 | -122.42775004393499 | (37.7750806969521, -122.427750043935) | |||
| 156844 | 156844 | 214904 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 556 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 5994175.9863599995 | 2099523.30765 | 37.744556613096 | -122.462829586019 | (37.744556613096, -122.462829586019) | |||
| 158849 | 158849 | 214903 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 556 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 5994195.751619999 | 2099539.59753 | 37.744602479411604 | -122.46276242374901 | (37.7446024794116, -122.462762423749) | |||
| 161813 | 161813 | 241662 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 176 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6005437.24469 | 2099940.9896 | 37.7463456551373 | -122.42392006786801 | (37.7463456551373, -122.423920067868) | |||
| 164072 | 164072 | 180400 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6002102.27199 | 2086536.9163099998 | 37.709352269366995 | -122.434493768575 | (37.709352269367, -122.434493768575) | |||
| 168833 | 168833 | 241663 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 176 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6005417.963819999 | 2099937.74161 | 37.74633564837 | -122.42398650799 | (37.74633564837, -122.42398650799) | |||
| 177841 | 177841 | 241660 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 82 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6006235.840480001 | 2099584.03625 | 37.7454105949184 | -122.421133271198 | (37.7454105949184, -122.421133271198) | |||
| 182096 | 182096 | 118080 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 7230 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5984526.23316 | 2112508.36467 | 37.77964941454 | -122.49715429910201 | (37.77964941454, -122.497154299102) | |||
| 22983 | 22983 | 241570 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 172 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5997494.28086 | 2107124.8182599996 | 37.765619029516294 | -122.451903941019 | (37.7656190295163, -122.451903941019) | |||
| 24003 | 24003 | 180323 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1682 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6001502.91955 | 2092324.6782 | 37.7252101301195 | -122.436979304073 | (37.7252101301195, -122.436979304073) | |||
| 24030 | 24030 | 136773 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3700 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 5997087.63405 | 2115382.9814299997 | 37.7882704886466 | -122.453906871501 | (37.7882704886466, -122.453906871501) | |||
| 24590 | 24590 | 180142 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1118 Russia Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6004028.1507 | 2089329.0394599999 | 37.7171279723626 | -122.42803645642599 | (37.7171279723626, -122.428036456426) | |||
| 25905 | 25905 | 242135 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 134 Collingwood St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6002035.55784 | 2104758.56511 | 37.7593809360961 | -122.43602735368201 | (37.7593809360961, -122.436027353682) | |||
| 28033 | 28033 | 242140 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 570 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6002975.949630001 | 2104907.04383 | 37.7598420023198 | -122.432785628653 | (37.7598420023198, -122.432785628653) | |||
| 29196 | 29196 | 242139 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 570 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6002975.33839 | 2104919.63759 | 37.7598765470916 | -122.432788642302 | (37.7598765470916, -122.432788642302) | |||
| 29425 | 29425 | 218603 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1355 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 5994857.52335 | 2106307.45764 | 37.7632233929651 | -122.460964592666 | (37.7632233929651, -122.460964592666) | |||
| 33619 | 33619 | 242117 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3862 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004018.60502 | 2102491.85861 | 37.7532695544679 | -122.429007395984 | (37.7532695544679, -122.429007395984) | |||
| 33930 | 33930 | 179988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 5998318.043769999 | 2087022.65362 | 37.7104704522241 | -122.447607562158 | (37.7104704522241, -122.447607562158) | |||
| 33953 | 33953 | 247763 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6001651.1462 | 2108480.6901700003 | 37.769579132108205 | -122.43762339851101 | (37.7695791321082, -122.437623398511) | |||
| 41263 | 41263 | 218719 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | |||
| 43977 | 43977 | 179983 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998155.09065 | 2086884.2051799998 | 37.710080990013296 | -122.448160798105 | (37.7100809900133, -122.448160798105) | |||
| 45268 | 45268 | 136830 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2333 Buchanan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6003766.78319 | 2116019.8084299997 | 37.7903997379064 | -122.430843596649 | (37.7903997379064, -122.430843596649) | |||
| 52249 | 52249 | 242116 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6004100.79809 | 2102964.07193 | 37.7545707934166 | -122.428756816079 | (37.7545707934166, -122.428756816079) | |||
| 55160 | 55160 | 241567 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 184 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5997406.333880001 | 2107112.14294 | 37.7655791886465 | -122.45220721399299 | (37.7655791886465, -122.452207213993) | |||
| 55189 | 55189 | 136906 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 471 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6011241.0783400005 | 2118988.5084700002 | 37.7989717177149 | -122.405192033407 | (37.7989717177149, -122.405192033407) | |||
| 58030 | 58030 | 241836 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 585 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 5999889.428069999 | 2107459.27885 | 37.76667426883821 | -122.443643711196 | (37.7666742688382, -122.443643711196) | |||
| 58259 | 58259 | 241644 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 415 Oak St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 5ft | 6004982.83626 | 2110199.4621900003 | 37.774487331444895 | -122.426221580476 | (37.7744873314449, -122.426221580476) | |||
| 60120 | 60120 | 241884 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 387x Holly Park Cir | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6006329.1092300005 | 2096869.11862 | 37.737961298159796 | -122.420618072992 | (37.7379612981598, -122.420618072992) | |||
| 60449 | 60449 | 241783 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 209 Day St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004329.75023 | 2098662.66645 | 37.7427730875169 | -122.427658592787 | (37.7427730875169, -122.427658592787) | |||
| 65467 | 65467 | 242169 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 495 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6001204.17131 | 2103411.5478 | 37.7556350870992 | -122.438806161672 | (37.7556350870992, -122.438806161672) | |||
| 67528 | 67528 | 241654 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 141 Albion St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6005916.78459 | 2106427.17738 | 37.7641822834171 | -122.42272273568899 | (37.7641822834171, -122.422722735689) | |||
| 68479 | 68479 | 179981 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998169.97204 | 2086845.49283 | 37.7099755454025 | -122.448106579751 | (37.7099755454025, -122.448106579751) | |||
| 69338 | 69338 | 179989 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 5998350.145880001 | 2087034.76993 | 37.7105055554714 | -122.447497482426 | (37.7105055554714, -122.447497482426) | |||
| 69697 | 69697 | 242136 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4244 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002010.12095 | 2104720.80627 | 37.759275814344896 | -122.43611262471701 | (37.7592758143449, -122.436112624717) | |||
| 70711 | 70711 | 241571 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 170 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5997509.15419 | 2107127.05359 | 37.7656260190416 | -122.45185265898701 | (37.7656260190416, -122.451852658987) | |||
| 72783 | 72783 | 179985 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 23 Whittier St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5998139.51533 | 2086920.9795799998 | 37.7101810737559 | -122.448217275509 | (37.7101810737559, -122.448217275509) | |||
| 74481 | 74481 | 218721 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.746656630797794 | -122.464476068412 | (37.7466566307978, -122.464476068412) | |||
| 130312 | 130312 | 198009 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 275 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011338.42729 | 2111564.35079 | 37.778592185327604 | -122.404332338179 | (37.7785921853276, -122.404332338179) | |||
| 132703 | 132703 | 136829 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2333 Buchanan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6003763.28449 | 2116038.9116 | 37.7904519921279 | -122.430857065799 | (37.7904519921279, -122.430857065799) | |||
| 147824 | 147824 | 218720 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.746655614559295 | -122.464499198102 | (37.7466556145593, -122.464499198102) | |||
| 149191 | 149191 | 136901 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2333 Leavenworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6007536.47447 | 2120305.57509 | 37.8023802472184 | -122.41810464953001 | (37.8023802472184, -122.41810464953) | |||
| 149766 | 149766 | 241883 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 387x Holly Park Cir | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6006344.8052900005 | 2096881.18885 | 37.7379953249194 | -122.420564660452 | (37.7379953249194, -122.420564660452) | |||
| 150104 | 150104 | 180141 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1118 Russia Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6004021.0387699995 | 2089333.04789 | 37.717138576267 | -122.42806132447201 | (37.717138576267, -122.428061324472) | |||
| 151362 | 151362 | 198044 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 551 Utah St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6010697.74849 | 2105726.3577 | 37.7625265739605 | -122.406137295513 | (37.7625265739605, -122.406137295513) | |||
| 152094 | 152094 | 241568 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 180 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 5997429.42135 | 2107115.9889700003 | 37.7655910714086 | -122.452127637501 | (37.7655910714086, -122.452127637501) | |||
| 155724 | 155724 | 241572 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 160 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 5997589.92507 | 2107138.86061 | 37.765663063919604 | -122.45157414343399 | (37.7656630639196, -122.451574143434) | |||
| 156486 | 156486 | 242290 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 411 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6003806.71849 | 2098340.54293 | 37.7418590111824 | -122.429444121165 | (37.7418590111824, -122.429444121165) | |||
| 159416 | 159416 | 241569 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 176 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 5997468.43063 | 2107123.32124 | 37.7656134384409 | -122.451993242792 | (37.7656134384409, -122.451993242792) | |||
| 163828 | 163828 | 241574 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 243 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5997516.68274 | 2106421.75232 | 37.7636898722165 | -122.451775735471 | (37.7636898722165, -122.451775735471) | |||
| 164477 | 164477 | 180380 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4208 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6003442.645819999 | 2093953.48682 | 37.729792534794 | -122.430390028073 | (37.729792534794, -122.430390028073) | |||
| 168162 | 168162 | 241782 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 209 Day St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6004251.25881 | 2098661.7812200002 | 37.7427662166839 | -122.42792993083201 | (37.7427662166839, -122.427929930832) |
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");