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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97695 | 97695 | 117445 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 403 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778578 | 6009365.1 | 2121160.8 | 37.8048312347901 | -122.411837150077 | (37.8048312347901, -122.411837150077) | ||
| 865 | 865 | 142552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009334.5084 | 2121154.0569 | 37.804811003675105 | -122.411942539139 | (37.8048110036751, -122.411942539139) | |||
| 849 | 849 | 93578 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 401X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53401 | 6009309.6837 | 2121148.6264 | 37.8047947000965 | -122.41202806393 | (37.8047947000965, -122.41202806393) | |
| 132643 | 132643 | 45690 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1932 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2001 12:00:00 AM | 7 | Permit Number 44375 | 5999944.86656 | 2121277.56514 | 37.8046188567315 | -122.44444515193999 | (37.8046188567315, -122.44444515194) | ||
| 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) | ||
| 146841 | 146841 | 83229 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1169 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52333 | 6005183.33361 | 2120915.83626 | 37.8039231412044 | -122.426291152916 | (37.8039231412044, -122.426291152916) | |
| 115943 | 115943 | 41185 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3440 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 2 | Permit Number 41903 | 6001280.224090001 | 2120345.1134900004 | 37.8021346936235 | -122.439757137177 | (37.8021346936235, -122.439757137177) | |
| 136992 | 136992 | 143075 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1631 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010479.3216 | 2120110.2272 | 37.8020090664108 | -122.40790712086799 | (37.8020090664108, -122.407907120868) | |||
| 136202 | 136202 | 111919 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 48 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6001642.842069999 | 2120043.1400599997 | 37.8013261877997 | -122.43848065927 | (37.8013261877997, -122.43848065927) | |||
| 146461 | 146461 | 31614 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2146 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35135 | 6001571.0697 | 2119772.3198 | 37.800578504065896 | -122.43870960598998 | (37.8005785040659, -122.43870960599) | ||
| 162592 | 162592 | 48353 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2085 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 45762 | 6001879.23455 | 2119763.86307 | 37.8005728104329 | -122.437642626012 | (37.8005728104329, -122.437642626012) | |||
| 161630 | 161630 | 136974 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001080.18174 | 2119739.07113 | 37.800459273745105 | -122.440405888327 | (37.8004592737451, -122.440405888327) | |||
| 28851 | 28851 | 136992 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2299 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000906.27756 | 2119628.7307700003 | 37.8001464049771 | -122.44099974484699 | (37.8001464049771, -122.440999744847) | |||
| 184854 | 184854 | 136970 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2414 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000268.16935 | 2119589.8327200003 | 37.80000323650739 | -122.44320504437201 | (37.8000032365074, -122.443205044372) | |||
| 36294 | 36294 | 136971 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2416 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6000253.905669999 | 2119587.5912099998 | 37.799996268582 | -122.4432542409 | (37.799996268582, -122.4432542409) | |||
| 59640 | 59640 | 136972 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2418 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000240.12941 | 2119585.20528 | 37.7999889318918 | -122.443301740387 | (37.7999889318918, -122.443301740387) | |||
| 72562 | 72562 | 136973 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2430 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6000191.50201 | 2119579.32161 | 37.799970003873504 | -122.443469586277 | (37.7999700038735, -122.443469586277) | |||
| 73350 | 73350 | 136990 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2423 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000237.89939 | 2119535.3298 | 37.799851859945505 | -122.443305872762 | (37.7998518599455, -122.443305872762) | |||
| 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) | |||
| 130522 | 130522 | 136968 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 77 Pixley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003015.29864 | 2119068.1170799998 | 37.79872700141421 | -122.433661633074 | (37.7987270014142, -122.433661633074) | |||
| 63260 | 63260 | 136967 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 77 Pixley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002998.66634 | 2119066.93448 | 37.7987228105586 | -122.43371910155199 | (37.7987228105586, -122.433719101552) | |||
| 28795 | 28795 | 33125 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2380 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 13 | 6x7 | Permit Number 37358 | 6001538.52427 | 2119069.35252 | 37.7986464896046 | -122.43877182467699 | (37.7986464896046, -122.438771824677) |
| 181708 | 181708 | 33124 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2380 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 12 | 6x6 | Permit Number 37358 | 6001499.40758 | 2119065.9057400003 | 37.7986348002003 | -122.438906933417 | (37.7986348002003, -122.438906933417) |
| 36271 | 36271 | 136969 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2640 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000252.03874 | 2118890.8974200003 | 37.7980832262203 | -122.443210635483 | (37.7980832262203, -122.443210635483) | |||
| 7771 | 7771 | 96366 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1326 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6006664.3237 | 2118739.81484 | 37.7980319387709 | -122.421011488604 | (37.7980319387709, -122.421011488604) | |||
| 152496 | 152496 | 104802 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2670 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6x9 | 6000116.7720800005 | 2118873.41414 | 37.7980275078187 | -122.443677439384 | (37.7980275078187, -122.443677439384) | |||
| 160318 | 160318 | 66277 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2750 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | 6 | Permit No. 49271 | 5999752.728130001 | 2118820.1000599996 | 37.797860351718704 | -122.444933297631 | (37.7978603517187, -122.444933297631) | ||
| 7715 | 7715 | 101523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2326 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001809.9749300005 | 2118762.85825 | 37.7978203759732 | -122.43781055733801 | (37.7978203759732, -122.437810557338) | |||
| 8832 | 8832 | 101524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2326 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001795.96309 | 2118760.54126 | 37.7978132173675 | -122.437858876082 | (37.7978132173675, -122.437858876082) | |||
| 155595 | 155595 | 136987 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1508 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005725.54512 | 2118613.25141 | 37.797631464383294 | -122.42425093115101 | (37.7976314643833, -122.424250931151) | |||
| 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) | |
| 164735 | 164735 | 137059 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 39 Osgood Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6011878.58523 | 2118466.36717 | 37.7975736631502 | -122.40294929057899 | (37.7975736631502, -122.402949290579) | |||
| 126618 | 126618 | 110786 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 410 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012080.0 | 2118442.0 | 37.7975180016372 | -122.402250623365 | (37.7975180016372, -122.402250623365) | ||||
| 52460 | 52460 | 137055 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012022.18721 | 2118437.4644299997 | 37.7975023208205 | -122.40245035302 | (37.7975023208205, -122.40245035302) | |||
| 187299 | 187299 | 137056 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012005.941869999 | 2118434.64519 | 37.7974936729554 | -122.402506368172 | (37.7974936729554, -122.402506368172) | |||
| 34072 | 34072 | 137057 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011992.2179 | 2118432.8922200003 | 37.797488093548104 | -122.402553733674 | (37.7974880935481, -122.402553733674) | |||
| 133104 | 133104 | 137058 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 440 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011933.40589 | 2118423.08303 | 37.797457876336296 | -122.40275654969801 | (37.7974578763363, -122.402756549698) | |||
| 147738 | 147738 | 33318 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2604 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | Permit Number 37462 | 6004913.93801 | 2118560.0081599997 | 37.7974394114518 | -122.42705551819401 | (37.7974394114518, -122.427055518194) | |
| 160114 | 160114 | 55641 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 450 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/1973 12:00:00 AM | 12 | Permit Number 11624 | 6011869.72365 | 2118415.97295 | 37.7974347979269 | -122.40297640786001 | (37.7974347979269, -122.40297640786) | ||
| 151870 | 151870 | 137060 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 462 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011807.58318 | 2118407.27 | 37.7974074315733 | -122.403190818824 | (37.7974074315733, -122.403190818824) | |||
| 159229 | 159229 | 137061 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 462 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011779.14715 | 2118403.24493 | 37.7973947915995 | -122.40328893213699 | (37.7973947915995, -122.403288932137) | |||
| 84727 | 84727 | 35673 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.797386378640496 | -122.403547515196 | (37.7973863786405, -122.403547515196) | |
| 108438 | 108438 | 35674 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.797386378640496 | -122.403547515196 | (37.7973863786405, -122.403547515196) | |
| 138839 | 138839 | 35676 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.797386378640496 | -122.403547515196 | (37.7973863786405, -122.403547515196) | |
| 142917 | 142917 | 35675 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.797386378640496 | -122.403547515196 | (37.7973863786405, -122.403547515196) | |
| 34125 | 34125 | 137062 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 462 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011753.78546 | 2118398.85013 | 37.7973813080638 | -122.40337638132 | (37.7973813080638, -122.40337638132) | |||
| 57539 | 57539 | 137063 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 462 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011730.01399 | 2118396.8785 | 37.797374566725104 | -122.403458498435 | (37.7973745667251, -122.403458498435) | |||
| 135487 | 135487 | 110674 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 34 Bonita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2.5x3 | 6006186.90221 | 2118494.2130299998 | 37.7973306546326 | -122.42264604510099 | (37.7973306546326, -122.422646045101) | |||
| 42722 | 42722 | 110675 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 34 Bonita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 2.5x3 | 6006170.0244 | 2118492.14329 | 37.7973240194296 | -122.422704299571 | (37.7973240194296, -122.422704299571) | |||
| 157560 | 157560 | 136989 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2781 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999666.44189 | 2118415.79962 | 37.7967453254804 | -122.445202788494 | (37.7967453254804, -122.445202788494) | |||
| 71319 | 71319 | 106762 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900x Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6003492.6204699995 | 2118318.25536 | 37.796695146921 | -122.431956373706 | (37.796695146921, -122.431956373706) | ||||
| 26146 | 26146 | 136958 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Divisadero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6000568.04629 | 2118355.71273 | 37.7966317645105 | -122.44207872445801 | (37.7966317645105, -122.442078724458) | |||
| 40339 | 40339 | 48429 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2460 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 10 | Permit Number 45807 | 6001230.18864 | 2118334.23878 | 37.7966105144187 | -122.439786028808 | (37.7966105144187, -122.439786028808) | |
| 33682 | 33682 | 136962 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2460 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001208.87225 | 2118332.01325 | 37.7966031903358 | -122.43985962844299 | (37.7966031903358, -122.439859628443) | |||
| 154736 | 154736 | 136988 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2855 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999300.726369999 | 2118363.97788 | 37.796582155192496 | -122.446464513021 | (37.7965821551925, -122.446464513021) | |||
| 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) | |||
| 67203 | 67203 | 136960 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000577.855330001 | 2118280.57754 | 37.796426022096206 | -122.442039387228 | (37.7964260220962, -122.442039387228) | |||
| 159849 | 159849 | 137028 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2057 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003223.22919 | 2118218.7365599996 | 37.7964066183283 | -122.432881414555 | (37.7964066183283, -122.432881414555) | |||
| 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) | |||
| 35859 | 35859 | 137027 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2057 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003211.766559999 | 2118215.6872 | 37.7963975954305 | -122.432920859704 | (37.7963975954305, -122.432920859704) | |||
| 160211 | 160211 | 136963 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2590 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000644.64668 | 2118255.6964 | 37.796361511030604 | -122.441806488875 | (37.7963615110306, -122.441806488875) | |||
| 171766 | 171766 | 136964 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2590 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000622.04414 | 2118252.24291 | 37.7963507407448 | -122.441884450223 | (37.7963507407448, -122.441884450223) | |||
| 8472 | 8472 | 46875 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) |
| 39087 | 39087 | 55752 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2224 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1973 12:00:00 AM | 19 | Permit Number 11785 | 6002371.1638 | 2118147.1071 | 37.7961615782478 | -122.435824610533 | (37.7961615782478, -122.435824610533) | ||
| 183548 | 183548 | 136965 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2762 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5999775.07561 | 2118126.74108 | 37.795957847619796 | -122.44480610383002 | (37.7959578476198, -122.44480610383) | |||
| 63198 | 63198 | 136966 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2774 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5999732.29105 | 2118122.60926 | 37.7959440610266 | -122.444953848948 | (37.7959440610266, -122.444953848948) | |||
| 46651 | 46651 | 55949 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2814 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1989 12:00:00 AM | 3 | Permit Number 28156 | 5999490.08281 | 2118090.45953 | 37.7958419601055 | -122.44578961952101 | (37.7958419601055, -122.445789619521) | ||
| 47772 | 47772 | 69334 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2059 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1994 12:00:00 AM | 12 | Permit Number 33419 | 6003702.41325 | 2117935.1422599996 | 37.795655107937705 | -122.43120308357 | (37.7956551079377, -122.43120308357) | ||
| 27718 | 27718 | 137031 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1752 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005234.06309 | 2117850.62901 | 37.795509733448604 | -122.42589727954599 | (37.7955097334486, -122.425897279546) | |||
| 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) | |||
| 162066 | 162066 | 137033 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1756 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005192.45176 | 2117848.2792700003 | 37.79550092999 | -122.42604109462499 | (37.79550092999, -122.426041094625) | |||
| 68043 | 68043 | 137034 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1756 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6005175.40466 | 2117844.84093 | 37.7954905257115 | -122.426099835651 | (37.7954905257115, -122.426099835651) | |||
| 156334 | 156334 | 30288 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1365 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 14 | Permit Number 132 | 6008888.5982099995 | 2117621.05322 | 37.795085225551 | -122.413235675009 | (37.795085225551, -122.413235675009) | ||
| 51305 | 51305 | 30285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 8 | Permit Number 132 | 6008895.30173 | 2117592.00623 | 37.7950058459972 | -122.41321042471901 | (37.7950058459972, -122.413210424719) | ||
| 40554 | 40554 | 137016 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2741 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6000594.28905 | 2117750.14892 | 37.7949705413204 | -122.441944432297 | (37.7949705413204, -122.441944432297) | |||
| 3831 | 3831 | 30286 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 10 | Permit Number 132 | 6008896.76565 | 2117570.49119 | 37.794946853168604 | -122.41320383718599 | (37.7949468531686, -122.413203837186) | ||
| 137312 | 137312 | 137022 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003025.71137 | 2117483.5061 | 37.794376660507396 | -122.433512298867 | (37.7943766605074, -122.433512298867) | |||
| 182552 | 182552 | 137023 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003036.9655 | 2117481.25366 | 37.7943711144001 | -122.433473197238 | (37.7943711144001, -122.433473197238) | |||
| 64644 | 64644 | 137021 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6003013.18529 | 2117480.30225 | 37.7943671528679 | -122.43355541147498 | (37.7943671528679, -122.433555411475) | |||
| 25433 | 25433 | 137020 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6002995.15639 | 2117477.21245 | 37.7943576461387 | -122.433617572612 | (37.7943576461387, -122.433617572612) | |||
| 185553 | 185553 | 53481 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1969 12:00:00 AM | 8 | Permit Number 6390 | 6002979.07126 | 2117470.0427 | 37.794337047177294 | -122.433672716337 | (37.7943370471773, -122.433672716337) | ||
| 41863 | 41863 | 137025 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2257 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6003076.305869999 | 2117463.99371 | 37.79432595493 | -122.43333584109 | (37.79432595493, -122.43333584109) | |||
| 163439 | 163439 | 137026 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2257 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003079.39439 | 2117445.17436 | 37.794274457055394 | -122.433323809051 | (37.7942744570554, -122.433323809051) | |||
| 55305 | 55305 | 137015 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2795 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000234.59127 | 2117454.54255 | 37.7941383806269 | -122.44316779448201 | (37.7941383806269, -122.443167794482) | |||
| 137296 | 137296 | 137014 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2795 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000218.16422 | 2117453.42518 | 37.7941343759438 | -122.44322455337401 | (37.7941343759438, -122.443224553374) | |||
| 126297 | 126297 | 39478 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2856 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 777203 | 5999897.32915775 | 2117456.37972289 | 37.7941241886563 | -122.44433488583 | (37.7941241886563, -122.44433488583) | |||
| 186318 | 186318 | 137043 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1228 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008992.0949 | 2117188.5729 | 37.793903550565794 | -122.41284696823799 | (37.7939035505658, -122.412846968238) | |||
| 69166 | 69166 | 137042 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1228 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008994.192969999 | 2117174.51361 | 37.7938650649634 | -122.41283871423201 | (37.7938650649634, -122.412838714232) | |||
| 37105 | 37105 | 51255 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2485 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | 8 | Permit Number 49056 | 6001759.16032 | 2117307.5117200003 | 37.7938214847188 | -122.437882095676 | (37.7938214847188, -122.437882095676) | ||
| 80552 | 80552 | 46874 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1360 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44937 | 6008040.39641169 | 2117081.79459414 | 37.793556898770795 | -122.416132380604 | (37.7935568987708, -122.416132380604) | ||
| 107374 | 107374 | 103379 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 2712 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770136 | 6000520.0 | 2117210.0 | 37.793483200790895 | -122.44216269001001 | (37.7934832007909, -122.44216269001) | |
| 133150 | 133150 | 137046 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1149 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008987.23365 | 2116902.13898 | 37.79311680025621 | -122.412843528313 | (37.7931168002562, -122.412843528313) | |||
| 3289 | 3289 | 253392 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3293 | 3293 | 253393 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3316 | 3316 | 253394 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 66975 | 66975 | 137011 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2920 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 5999664.756569999 | 2117066.45447 | 37.7930402850302 | -122.44511156307101 | (37.7930402850302, -122.445111563071) | |||
| 185342 | 185342 | 137012 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2920 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 5999646.08574 | 2117066.27924 | 37.793038738206796 | -122.44517615236299 | (37.7930387382068, -122.445176152363) | |||
| 184479 | 184479 | 137013 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2920 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5999627.956569999 | 2117064.96637 | 37.79303409860729 | -122.445238785654 | (37.7930340986073, -122.445238785654) | |||
| 63412 | 63412 | 66733 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1133 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1991 12:00:00 AM | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | |||
| 187118 | 187118 | 137037 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1034 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009816.75031 | 2116820.89237 | 37.792940242650296 | -122.409967600744 | (37.7929402426503, -122.409967600744) |
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");