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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180179 | 180179 | 215526 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 478 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994752.10675 | 2100066.65325 | 37.7460816699447 | -122.460876862898 | (37.7460816699447, -122.460876862898) | |||
180043 | 180043 | 198467 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 707 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015376.19959 | 2105766.90453 | 37.7628984786941 | -122.389958933463 | (37.7628984786941, -122.389958933463) | |||
179962 | 179962 | 215540 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993944.908340001 | 2097392.63187 | 37.7386929991944 | -122.46347400603001 | (37.7386929991944, -122.46347400603) | |||
179957 | 179957 | 123533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3 05th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5994221.757259999 | 2115563.2113799998 | 37.7886006193808 | -122.46383534054199 | (37.7886006193808, -122.463835340542) | |||
179887 | 179887 | 98993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1919 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768862 | 6003810.0 | 2118645.0 | 37.7976102909597 | -122.430881499482 | (37.7976102909597, -122.430881499482) | |
179766 | 179766 | 123693 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 9 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995461.176580001 | 2113536.44974 | 37.7831070225625 | -122.45940032745101 | (37.7831070225625, -122.459400327451) | |||
179616 | 179616 | 198546 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1759 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6014355.59614 | 2096302.28152 | 37.7368539746257 | -122.39282669249901 | (37.7368539746257, -122.392826692499) | |||
179556 | 179556 | 242473 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2869 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6008372.54081 | 2101739.95978 | 37.751450501152505 | -122.413897361091 | (37.7514505011525, -122.413897361091) | |||
179497 | 179497 | 242503 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2618 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008245.42572 | 2102971.97718 | 37.754826202679205 | -122.414424108384 | (37.7548262026792, -122.414424108384) | |||
179025 | 179025 | 143455 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 717 CALIFORNIA ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 6010922.8711 | 2116581.0775 | 37.7923436997898 | -122.406123443239 | (37.7923436997898, -122.406123443239) | |||
178955 | 178955 | 180555 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 201 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002345.73736 | 2091226.34505 | 37.72224222258421 | -122.43398729649799 | (37.7222422225842, -122.433987296498) | |||
178916 | 178916 | 198666 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013864.8595 | 2107478.20715 | 37.7675134055349 | -122.39530605864901 | (37.7675134055349, -122.395306058649) | |||
178810 | 178810 | 242549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2498 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008194.176969999 | 2103947.9032 | 37.757502994275704 | -122.41467040123699 | (37.7575029942757, -122.414670401237) | |||
178732 | 178732 | 198681 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010294.844330001 | 2111624.8311799997 | 37.778699879144796 | -122.40794677462401 | (37.7786998791448, -122.407946774624) | |||
178706 | 178706 | 242577 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1811 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008043.01248 | 2107858.0308 | 37.7682308064267 | -122.41547001004999 | (37.7682308064267, -122.41547001005) | |||
178687 | 178687 | 110079 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2751x Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5990053.539580001 | 2111933.09723 | 37.7783922604051 | -122.477991095219 | (37.7783922604051, -122.477991095219) | |||
178605 | 178605 | 242749 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 77 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001068.1061 | 2105939.1101900004 | 37.762567414863604 | -122.43945789317499 | (37.7625674148636, -122.439457893175) | |||
178300 | 178300 | 246552 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) | |||
178294 | 178294 | 137036 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 128 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008091.14561 | 2112874.2674 | 37.7820069075434 | -122.415658735479 | (37.7820069075434, -122.415658735479) | |||
178128 | 178128 | 201910 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013794.8405 | 2093225.07 | 37.728373419872604 | -122.39455007233101 | (37.7283734198726, -122.394550072331) | |||
178117 | 178117 | 215490 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 45 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994002.63682 | 2097564.4991099997 | 37.739168229725706 | -122.46328687779601 | (37.7391682297257, -122.463286877796) | |||
178101 | 178101 | 242420 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 287 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005472.13068 | 2102064.63416 | 37.7521786642319 | -122.42395042359101 | (37.7521786642319, -122.423950423591) | |||
178006 | 178006 | 242444 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 209 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004775.72746 | 2102364.1571 | 37.7529617434884 | -122.426380018538 | (37.7529617434884, -122.426380018538) | |||
177831 | 177831 | 198507 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 701 Rhode Island St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6011858.82974 | 2105091.4042599997 | 37.7608480082603 | -122.40207687446501 | (37.7608480082603, -122.402076874465) | |||
177758 | 177758 | 180558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 391 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002652.4584800005 | 2091031.88145 | 37.7217256708875 | -122.432913149844 | (37.7217256708875, -122.432913149844) | |||
177693 | 177693 | 242439 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 229 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004390.15569 | 2099542.0601 | 37.7451911171707 | -122.427512363901 | (37.7451911171707, -122.427512363901) | |||
177660 | 177660 | 136991 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2423 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000225.01908 | 2119533.2007299997 | 37.799845279595 | -122.443350290299 | (37.799845279595, -122.443350290299) | |||
177606 | 177606 | 180528 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 403 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002884.7745199995 | 2090891.4425599999 | 37.7213532310447 | -122.43210007098301 | (37.7213532310447, -122.432100070983) | |||
177478 | 177478 | 198624 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015725.44924 | 2108619.45871 | 37.7707503353808 | -122.38895015673701 | (37.7707503353808, -122.388950156737) | ||||
177354 | 177354 | 242665 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1110 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003796.20784 | 2101754.26295 | 37.7512316988054 | -122.42972388675899 | (37.7512316988054, -122.429723886759) | |||
177135 | 177135 | 180539 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2063 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000471.84431 | 2090162.7563 | 37.7192153258175 | -122.440388640236 | (37.7192153258175, -122.440388640236) | |||
177068 | 177068 | 215505 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 245 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994112.73436 | 2096460.53675 | 37.7361433654214 | -122.462826145227 | (37.7361433654214, -122.462826145227) | |||
176966 | 176966 | 141800 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1491 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003793.7912 | 2113158.171 | 37.7825439326613 | -122.430545874753 | (37.7825439326613, -122.430545874753) | |||
176942 | 176942 | 51159 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2004 12:00:00 AM | 4 | Permit Number 47564 | 6000498.9523 | 2114920.078 | 37.7871944727635 | -122.44207106941002 | (37.7871944727635, -122.44207106941) | ||
176925 | 176925 | 180548 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002299.71139 | 2091209.35662 | 37.722192964028295 | -122.434145183247 | (37.7221929640283, -122.434145183247) | |||
176924 | 176924 | 138050 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1800 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003471.3179 | 2114983.7695 | 37.78753829309029 | -122.431791881618 | (37.7875382930903, -122.431791881618) | |||
176821 | 176821 | 244373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.0227 | 2109867.6455 | 37.7736117862994 | -122.424021499783 | (37.7736117862994, -122.424021499783) | |||
176784 | 176784 | 198471 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 704 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6015348.95336 | 2105815.2595900004 | 37.7630297401524 | -122.390056547668 | (37.7630297401524, -122.390056547668) | |||
176776 | 176776 | 105953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | ||
176765 | 176765 | 215495 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 69 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993977.518540001 | 2097401.11032 | 37.7387181577226 | -122.46336187135401 | (37.7387181577226, -122.463361871354) | |||
176688 | 176688 | 136995 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2311 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003187.89855 | 2116665.35815 | 37.7921394368434 | -122.43289263540301 | (37.7921394368434, -122.432892635403) | |||
176640 | 176640 | 242645 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3226 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008172.83241 | 2101552.12353 | 37.7509235272008 | -122.41457468818899 | (37.7509235272008, -122.414574688189) | |||
176552 | 176552 | 198683 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009066.22564 | 2110952.30823 | 37.7767844274995 | -122.412149517004 | (37.7767844274995, -122.412149517004) | |||
176511 | 176511 | 242400 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 San Jose Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004412.57648 | 2096019.13863 | 37.7355192458083 | -122.427183945908 | (37.7355192458083, -122.427183945908) | ||||
176276 | 176276 | 183730 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2259 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5985737.4508 | 2099845.7715 | 37.7449523648453 | -122.492031672537 | (37.7449523648453, -122.492031672537) | |||
176187 | 176187 | 242545 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2460 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008186.74637 | 2104114.44399 | 37.75795985976529 | -122.41470788497699 | (37.7579598597653, -122.414707884977) | |||
176128 | 176128 | 246976 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 221 Noe St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 6ft | 6002925.65155 | 2106953.9304400003 | 37.765459405239504 | -122.43310583406799 | (37.7654594052395, -122.433105834068) | |||
176060 | 176060 | 242468 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2973 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008409.81 | 2101115.13424 | 37.749736963489106 | -122.41372428835399 | (37.7497369634891, -122.413724288354) | |||
176026 | 176026 | 198512 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 681 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6013048.29942 | 2103920.61394 | 37.7576995923826 | -122.397880868001 | (37.7576995923826, -122.397880868001) | |||
176025 | 176025 | 244355 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005591.5984 | 2110402.9339 | 37.7750804055544 | -122.42413022622601 | (37.7750804055544, -122.424130226226) | |||
175937 | 175937 | 242533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2200 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008112.4090599995 | 2105462.60197 | 37.7616574151672 | -122.41506039942 | (37.7616574151672, -122.41506039942) | |||
175935 | 175935 | 242721 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 291 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004399.96765 | 2103934.30493 | 37.757251752489296 | -122.427791335409 | (37.7572517524893, -122.427791335409) | |||
175825 | 175825 | 242729 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 169 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6001388.03068 | 2107326.35786 | 37.766394657906396 | -122.438450788282 | (37.7663946579064, -122.438450788282) | |||
175661 | 175661 | 242689 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3863 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003186.86324 | 2105910.04094 | 37.762607950928505 | -122.432127809674 | (37.7626079509285, -122.432127809674) | |||
175570 | 175570 | 180543 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 790 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1997 12:00:00 AM | 15 | Width 3ft | 6003544.6260400005 | 2090426.4873900001 | 37.720113955375794 | -122.42978600294799 | (37.7201139553758, -122.429786002948) | ||
175466 | 175466 | 110635 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 631 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013464.4845 | 2113882.0453 | 37.7850746181572 | -122.397139998491 | (37.7850746181572, -122.397139998491) | |||
175445 | 175445 | 242723 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 291 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004435.5728 | 2103937.2017599996 | 37.7572617205823 | -122.42766840527 | (37.7572617205823, -122.42766840527) | |||
175443 | 175443 | 246555 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005721.04041 | 2109575.32182 | 37.772815290316295 | -122.423623602744 | (37.7728152903163, -122.423623602744) | |||
175423 | 175423 | 180545 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 590 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003050.747769999 | 2090737.10045 | 37.720938850417 | -122.43151533538601 | (37.720938850417, -122.431515335386) | |||
175420 | 175420 | 198685 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009031.355330001 | 2110985.92555 | 37.776874776094104 | -122.41227252088699 | (37.7768747760941, -122.412272520887) | |||
175408 | 175408 | 242685 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 415 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002981.98467 | 2105833.43743 | 37.7623859982461 | -122.43283093742 | (37.7623859982461, -122.43283093742) | |||
175396 | 175396 | 55984 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1260 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1974 12:00:00 AM | 8 | Permit Number 12058 | 6008765.405 | 2116672.96891 | 37.7924751016038 | -122.41359485523998 | (37.7924751016038, -122.41359485524) | ||
175303 | 175303 | 198618 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015853.85549 | 2108626.75005 | 37.770777472424996 | -122.38850650226802 | (37.770777472425, -122.388506502268) | ||||
175108 | 175108 | 215542 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993945.302519999 | 2097292.64109 | 37.7384184721345 | -122.463465388735 | (37.7384184721345, -122.463465388735) | |||
175060 | 175060 | 242394 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1768 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005673.23429 | 2107276.13145 | 37.766499565627605 | -122.42362547063499 | (37.7664995656276, -122.423625470635) | |||
174936 | 174936 | 242467 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3023 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008424.300319999 | 2100880.90797 | 37.7490946442994 | -122.413657615312 | (37.7490946442994, -122.413657615312) | |||
174908 | 174908 | 137019 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2716 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000999.544869999 | 2116909.52007 | 37.7926854790936 | -122.440481871155 | (37.7926854790936, -122.440481871155) | |||
174653 | 174653 | 64959 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 12 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1989 12:00:00 AM | 11 | Permit Number 25993 | 6001806.8392 | 2121193.6655099997 | 37.804494553342096 | -122.437995616222 | (37.8044945533421, -122.437995616222) | ||
174601 | 174601 | 31036 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 300 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | 2 | Permit Number 771782 | 6007053.24421 | 2096706.03657 | 37.737554295604895 | -122.41810281760901 | (37.7375542956049, -122.418102817609) | ||
174581 | 174581 | 198578 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6014761.290709999 | 2114189.1211599996 | 37.7859898852611 | -122.39267491031299 | (37.7859898852611, -122.392674910313) | |||
174425 | 174425 | 201913 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013833.24742 | 2093196.5259999998 | 37.728297178952204 | -122.394415299033 | (37.7282971789522, -122.394415299033) | |||
174423 | 174423 | 215537 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 66 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993955.64334 | 2097496.99749 | 37.7389801796769 | -122.463444461504 | (37.7389801796769, -122.463444461504) | |||
174399 | 174399 | 242573 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2055 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008115.256990001 | 2106522.9775400003 | 37.7645691213862 | -122.415125610158 | (37.7645691213862, -122.415125610158) | |||
174369 | 174369 | 180519 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 919 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6003897.75198 | 2090254.30542 | 37.719661171900796 | -122.42855309895701 | (37.7196611719008, -122.428553098957) | |||
174364 | 174364 | 244465 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005629.1512 | 2109732.6732 | 37.773242151986 | -122.423952649806 | (37.773242151986, -122.423952649806) | |||
174348 | 174348 | 198615 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015921.38849 | 2108631.4690400003 | 37.7707941719296 | -122.388273231625 | (37.7707941719296, -122.388273231625) | ||||
174322 | 174322 | 137044 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008949.11114 | 2116700.62228 | 37.7925613447696 | -122.41296118031099 | (37.7925613447696, -122.412961180311) | |||
174248 | 174248 | 137032 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1756 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005211.20032 | 2117849.05905 | 37.7955041306666 | -122.425976276892 | (37.7955041306666, -122.425976276892) | |||
174240 | 174240 | 244360 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005525.0257 | 2110428.4298 | 37.7751466521023 | -122.424362329876 | (37.7751466521023, -122.424362329876) | |||
174150 | 174150 | 242755 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001027.89312 | 2105941.34523 | 37.7625712630837 | -122.439597135198 | (37.7625712630837, -122.439597135198) | |||
174086 | 174086 | 136961 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000580.09999 | 2118271.36688 | 37.796400859969104 | -122.442030958785 | (37.7964008599691, -122.442030958785) | |||
174060 | 174060 | 136993 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2140 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6002411.09612 | 2115635.3533799998 | 37.7892672189415 | -122.435506662423 | (37.7892672189415, -122.435506662423) | |||
173974 | 173974 | 215508 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 261 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994073.52001 | 2096368.39822 | 37.7358881171279 | -122.462955041436 | (37.7358881171279, -122.462955041436) | |||
173973 | 173973 | 242746 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4076 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001825.83019 | 2105882.55558 | 37.762455223551605 | -122.436833156142 | (37.7624552235516, -122.436833156142) | |||
173944 | 173944 | 102277 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 316 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 1 | 3x3 | Permit Number 776676 | 5998600.56179 | 2115376.04421 | 37.7883380681833 | -122.448671915192 | (37.7883380681833, -122.448671915192) | |
173939 | 173939 | 242686 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3883 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003089.74874 | 2105903.4621200003 | 37.762584380582794 | -122.432463223521 | (37.7625843805828, -122.432463223521) | |||
173849 | 173849 | 200942 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1595 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008302.9396 | 2108913.0233 | 37.771142175293896 | -122.414645612489 | (37.7711421752939, -122.414645612489) | |||
173743 | 173743 | 200597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016514.3807 | 2094844.0461 | 37.732969621897794 | -122.38526117126301 | (37.7329696218978, -122.385261171263) | |||
173527 | 173527 | 244256 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005639.4577 | 2110060.8783 | 37.7741439057581 | -122.423940341347 | (37.7741439057581, -122.423940341347) | |||
173525 | 173525 | 136959 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000575.50747 | 2118297.87683 | 37.796473387585294 | -122.442048753659 | (37.7964733875853, -122.442048753659) | |||
173523 | 173523 | 137051 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008522.47154 | 2116730.9321 | 37.79262061009871 | -122.414439518287 | (37.7926206100987, -122.414439518287) | |||
173390 | 173390 | 242428 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 300 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6005059.642519999 | 2109908.9479400003 | 37.773693990910395 | -122.425935208466 | (37.7736939909104, -122.425935208466) | |||
173324 | 173324 | 242568 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2121 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008133.25009 | 2106138.4736900004 | 37.7635143740114 | -122.41503615908701 | (37.7635143740114, -122.415036159087) | |||
173274 | 173274 | 198647 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6016245.346419999 | 2108770.39329 | 37.7711935725654 | -122.387162335966 | (37.7711935725654, -122.387162335966) | ||||
173184 | 173184 | 242556 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2405 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008229.8333 | 2104396.3928900003 | 37.75873644773829 | -122.414578823255 | (37.7587364477383, -122.414578823255) | |||
173144 | 173144 | 180516 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1023 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004155.91588 | 2090090.6053799998 | 37.7192262939354 | -122.427649061763 | (37.7192262939354, -122.427649061763) | |||
173024 | 173024 | 198692 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016712.13371 | 2094960.30012 | 37.733299770270904 | -122.38458557598601 | (37.7332997702709, -122.384585575986) | |||
172924 | 172924 | 242623 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 295 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008399.41744 | 2100279.45159 | 37.747441782112496 | -122.413701124532 | (37.7474417821125, -122.413701124532) | |||
172839 | 172839 | 242469 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2973 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008406.38146 | 2101153.87542 | 37.7498431455534 | -122.413738884363 | (37.7498431455534, -122.413738884363) | |||
172783 | 172783 | 198461 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6014835.64644 | 2106275.86157 | 37.764265970711 | -122.39186412474702 | (37.764265970711, -122.391864124747) |
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");