Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 207 | 207 | 138805 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002622.3069 | 2115079.2676 | 37.787752342886 | -122.434736117903 | (37.787752342886, -122.434736117903) | |||
| 583 | 583 | 7548 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5x5 | 6008321.80095 | 2101666.80438 | 37.751246783135 | -122.414067651319 | (37.751246783135, -122.414067651319) | |||
| 977 | 977 | 242613 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.744403529591395 | -122.417403753004 | (37.7444035295914, -122.417403753004) | ||
| 1178 | 1178 | 251465 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1270 | 1270 | 18055 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2872 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000192.328 | 2114789.41 | 37.786818213822706 | -122.443122531996 | (37.7868182138227, -122.443122531996) | |||
| 1525 | 1525 | 251581 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 600 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5984701.0 | 2111577.0 | 37.777102396300705 | -122.496480968893 | (37.7771023963007, -122.496480968893) | ||||
| 2483 | 2483 | 201850 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 911 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6011602.0 | 2112119.0 | 37.7801298483764 | -122.403459565618 | (37.7801298483764, -122.403459565618) | |||
| 2806 | 2806 | 18057 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6000155.2064 | 2114785.6979 | 37.7868059046739 | -122.443250696948 | (37.7868059046739, -122.443250696948) | |||
| 3612 | 3612 | 18039 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2813 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000314.1463 | 2114749.1203 | 37.7867145338964 | -122.442698176369 | (37.7867145338964, -122.442698176369) | |||
| 4598 | 4598 | 18015 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2712 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000819.3499 | 2114877.5272 | 37.7870958927498 | -122.44095951208901 | (37.7870958927498, -122.440959512089) | |||
| 4811 | 4811 | 17931 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2416 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6002234.6053 | 2115077.8001 | 37.7877262951282 | -122.43607738468398 | (37.7877262951282, -122.436077384684) | |||
| 5186 | 5186 | 180527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6003103.45709 | 2090752.9991099997 | 37.720985491961 | -122.43133426946301 | (37.720985491961, -122.431334269463) | |||
| 5698 | 5698 | 17917 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2370 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002602.4145 | 2115123.2744 | 37.7878720449725 | -122.43480808996 | (37.7878720449725, -122.43480808996) | |||
| 6216 | 6216 | 18017 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2713 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000875.2767 | 2114835.3915 | 37.786983384155505 | -122.440762994582 | (37.7869833841555, -122.440762994582) | |||
| 6867 | 6867 | 18000 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2670 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001175.0601 | 2114930.6744 | 37.7872620743104 | -122.43973264788299 | (37.7872620743104, -122.439732647883) | |||
| 6994 | 6994 | 18053 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2852 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000250.2377 | 2114802.0314 | 37.7868561706627 | -122.442923085267 | (37.7868561706627, -122.442923085267) | |||
| 7448 | 7448 | 106350 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1853 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001488.8508 | 2114881.6293 | 37.7871452647326 | -122.43864348553001 | (37.7871452647326, -122.43864348553) | |||
| 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) | |||
| 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) | |||
| 8226 | 8226 | 18032 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2801 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000470.3136 | 2114777.4747 | 37.7868012889701 | -122.44215991241501 | (37.7868012889701, -122.442159912415) | |||
| 8302 | 8302 | 18045 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2821 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000216.4327 | 2114739.0872 | 37.786681414860894 | -122.44303552029801 | (37.7866814148609, -122.443035520298) | |||
| 8639 | 8639 | 18001 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2673 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001165.7528 | 2114873.8019 | 37.7871053873216 | -122.439760770078 | (37.7871053873216, -122.439760770078) | |||
| 9119 | 9119 | 18034 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2806 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000470.7399 | 2114833.2135 | 37.7869543575665 | -122.44216244014099 | (37.7869543575665, -122.442162440141) | |||
| 9245 | 9245 | 18044 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2819 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000236.9351 | 2114743.0132 | 37.7866933635797 | -122.442964869171 | (37.7866933635797, -122.442964869171) | |||
| 9284 | 9284 | 18024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2726 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000724.7507 | 2114865.5018 | 37.787057485761 | -122.441285940418 | (37.787057485761, -122.441285940418) | |||
| 9407 | 9407 | 18054 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2866 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000216.8283 | 2114794.6071 | 37.7868338806489 | -122.443038140312 | (37.7868338806489, -122.443038140312) | |||
| 9736 | 9736 | 173668 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014587.0 | 2096103.0 | 37.7363196386473 | -122.392012689283 | (37.7363196386473, -122.392012689283) | ||||
| 9754 | 9754 | 25175 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3066 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 9x9 | Permit Number 772559 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.44261677830299 | (37.7611492576992, -122.442616778303) | ||
| 10163 | 10163 | 173898 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
| 10167 | 10167 | 110034 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008245.7 | 2102789.4 | 37.754324902547204 | -122.414410241803 | (37.7543249025472, -122.414410241803) | |||||
| 10325 | 10325 | 109498 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2440 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5989239.6228 | 2098735.6386 | 37.74210832360679 | -122.479840718717 | (37.7421083236068, -122.479840718717) | |||
| 10346 | 10346 | 7524 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2804 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008300.9450199995 | 2102065.01518 | 37.7523390088635 | -122.414167943693 | (37.7523390088635, -122.414167943693) | |||
| 10349 | 10349 | 17525 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6002628.09189 | 2091001.6668200002 | 37.721641326157204 | -122.43299522107401 | (37.7216413261572, -122.432995221074) | |||
| 10351 | 10351 | 17502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002131.248869999 | 2091360.1957200002 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | |||
| 10375 | 10375 | 17615 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1018 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004156.70512 | 2090037.9094200002 | 37.7190816469907 | -122.427642581247 | (37.7190816469907, -122.427642581247) | |||
| 10537 | 10537 | 17602 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | |||
| 10722 | 10722 | 17551 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003191.74591 | 2090695.7695400002 | 37.720833355450104 | -122.43102499890699 | (37.7208333554501, -122.431024998907) | |||
| 10763 | 10763 | 17492 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 43 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 6001974.03166 | 2091459.77916 | 37.722862078497705 | -122.435288881679 | (37.7228620784977, -122.435288881679) | |||
| 10792 | 10792 | 17605 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 937 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003999.6997 | 2090190.6100400002 | 37.7194920472054 | -122.428196165219 | (37.7194920472054, -122.428196165219) | |||
| 10866 | 10866 | 17524 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 311 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002598.14463 | 2091067.38518 | 37.7218200754046 | -122.433103433796 | (37.7218200754046, -122.433103433796) | |||
| 10894 | 10894 | 17530 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 418 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6002769.64699 | 2090910.4417700002 | 37.72139887074 | -122.432499390644 | (37.72139887074, -122.432499390644) | |||
| 10940 | 10940 | 17528 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002717.3851 | 2090942.2754900001 | 37.7214833152726 | -122.432682318148 | (37.7214833152726, -122.432682318148) | |||
| 10968 | 10968 | 17595 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003715.34966 | 2090318.2223099999 | 37.719826349498895 | -122.42918815340401 | (37.7198263494989, -122.429188153404) | |||
| 11027 | 11027 | 17557 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 631 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003296.79143 | 2090629.3686 | 37.7206569849073 | -122.430657152829 | (37.7206569849073, -122.430657152829) | |||
| 11164 | 11164 | 17617 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | |||
| 11202 | 11202 | 17556 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 626 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003246.79786 | 2090613.7194400001 | 37.7206111833437 | -122.430828848684 | (37.7206111833437, -122.430828848684) | |||
| 11476 | 11476 | 17503 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 131 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002145.061290001 | 2091350.8283900002 | 37.7225726352947 | -122.434689881929 | (37.7225726352947, -122.434689881929) | |||
| 11491 | 11491 | 17552 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 611 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003214.50174 | 2090682.11363 | 37.72079714875721 | -122.430945364856 | (37.7207971487572, -122.430945364856) | |||
| 11534 | 11534 | 17549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 600 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6003191.593230001 | 2090648.1169 | 37.7207025031963 | -122.431022127369 | (37.7207025031963, -122.431022127369) | |||
| 11558 | 11558 | 17522 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 307 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002546.66743 | 2091098.28956 | 37.7219020117492 | -122.433283584179 | (37.7219020117492, -122.433283584179) | |||
| 11611 | 11611 | 17597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 844 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003772.37846 | 2090279.5258799999 | 37.71972332585371 | -122.428988267402 | (37.7197233258537, -122.428988267402) | |||
| 11883 | 11883 | 17495 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002027.05349 | 2091378.7208900002 | 37.722642521627996 | -122.43509980193001 | (37.722642521628, -122.43509980193) | |||
| 11929 | 11929 | 17621 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1100 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004336.281690001 | 2089926.3148400001 | 37.7187853887157 | -122.42701391015899 | (37.7187853887157, -122.427013910159) | |||
| 12017 | 12017 | 17554 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 620 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003227.93089 | 2090625.05216 | 37.7206412314956 | -122.43089487419901 | (37.7206412314956, -122.430894874199) | |||
| 12027 | 12027 | 17535 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003034.530590001 | 2090798.32089 | 37.721106028988295 | -122.431575761713 | (37.7211060289883, -122.431575761713) | |||
| 12028 | 12028 | 17573 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 750 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6003469.3677199995 | 2090473.15538 | 37.720237833385404 | -122.430049472832 | (37.7202378333854, -122.430049472832) | |||
| 12044 | 12044 | 17598 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003858.866640001 | 2090228.3157 | 37.719587609170006 | -122.42868565992399 | (37.71958760917, -122.428685659924) | |||
| 12133 | 12133 | 17594 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 808 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6003660.5889 | 2090352.7029799998 | 37.719917925661 | -122.42937989966002 | (37.719917925661, -122.42937989966) | |||
| 12168 | 12168 | 17555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 625 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003276.00472 | 2090644.70105 | 37.7206979067656 | -122.430730099534 | (37.7206979067656, -122.430730099534) | |||
| 12233 | 12233 | 17490 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 11 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 6001895.26392 | 2091509.73666 | 37.7229947770751 | -122.435564737019 | (37.7229947770751, -122.435564737019) | |||
| 12432 | 12432 | 17625 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1132 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6004425.094930001 | 2089870.4961599999 | 37.7186371444562 | -122.426702945308 | (37.7186371444562, -122.426702945308) | |||
| 12453 | 12453 | 17491 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 33 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001944.766 | 2091477.8994200001 | 37.722910170637896 | -122.435391342346 | (37.7229101706379, -122.435391342346) | |||
| 12487 | 12487 | 17616 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1030 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004194.38835 | 2090014.0443400003 | 37.719018250172 | -122.42751062553499 | (37.719018250172, -122.427510625535) | |||
| 12598 | 12598 | 17596 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 822 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6003747.6295300005 | 2090297.4937 | 37.719771260609996 | -122.429075096066 | (37.71977126061, -122.429075096066) | |||
| 12659 | 12659 | 17567 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | 6003448.03192 | 2090486.73855 | 37.7202739213865 | -122.430124192087 | (37.7202739213865, -122.430124192087) | |||
| 12701 | 12701 | 17544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 537 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003083.60804 | 2090766.94886 | 37.7210226699524 | -122.431403876997 | (37.7210226699524, -122.431403876997) | |||
| 12788 | 12788 | 17558 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 632 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003270.54295 | 2090597.85658 | 37.7205689727677 | -122.430745637999 | (37.7205689727677, -122.430745637999) | |||
| 12801 | 12801 | 17521 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 301X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002512.93657 | 2091121.04264 | 37.7219625730029 | -122.433401808174 | (37.7219625730029, -122.433401808174) | |||
| 12833 | 12833 | 17553 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 615 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 2X2 | 6003240.95528 | 2090665.71698 | 37.720753626054204 | -122.430852753549 | (37.7207536260542, -122.430852753549) | |||
| 12929 | 12929 | 17531 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 444 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002851.30461 | 2090860.81338 | 37.72126723246829 | -122.43221358070299 | (37.7212672324683, -122.432213580703) | |||
| 13029 | 13029 | 17562 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 645 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003332.52001 | 2090606.8773 | 37.72059725284729 | -122.43053204633001 | (37.7205972528473, -122.43053204633) | |||
| 13058 | 13058 | 17513 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002376.23219 | 2091204.63173 | 37.7221843332317 | -122.433880332025 | (37.7221843332317, -122.433880332025) | |||
| 13109 | 13109 | 17606 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 945X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004029.89293 | 2090169.1541 | 37.7194348422149 | -122.428090270065 | (37.7194348422149, -122.428090270065) | |||
| 13153 | 13153 | 17626 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004454.014359999 | 2089904.4684 | 37.718732059816205 | -122.42660540034099 | (37.7187320598162, -122.426605400341) | |||
| 13231 | 13231 | 17623 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1101 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6004371.84322 | 2089954.8563599999 | 37.718865768324 | -122.426893019707 | (37.718865768324, -122.426893019707) | |||
| 14290 | 14290 | 111683 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 915 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6x7 | 6015271.38469 | 2104348.4426599997 | 37.758997874376796 | -122.390222350301 | (37.7589978743768, -122.390222350301) | |||
| 14529 | 14529 | 102719 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1681 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6008087.4331 | 2108473.4904 | 37.7699232110184 | -122.41535993867 | (37.7699232110184, -122.41535993867) | |||
| 14561 | 14561 | 7568 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2941 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008397.77442 | 2101269.6431 | 37.7501605343002 | -122.413776835747 | (37.7501605343002, -122.413776835747) | |||
| 15023 | 15023 | 97221 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 15x200 | 6016689.53805 | 2094986.8063299998 | 37.733371301443 | -122.38466554190701 | (37.733371301443, -122.384665541907) | |||
| 15108 | 15108 | 117609 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1227 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6009518.3962 | 2110117.1687 | 37.774516691037505 | -122.41052633045099 | (37.7745166910375, -122.410526330451) | |||
| 15274 | 15274 | 110633 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 631 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013429.5241 | 2113847.0849 | 37.7849766786955 | -122.397258498892 | (37.7849766786955, -122.397258498892) | |||
| 15718 | 15718 | 98858 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008557.54308 | 2110566.5981 | 37.775696803594606 | -122.413881917042 | (37.7756968035946, -122.413881917042) | |||
| 16550 | 16550 | 112173 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 190 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010499.33864 | 2111330.08185 | 37.7779020131996 | -122.407218562985 | (37.7779020131996, -122.407218562985) | |||
| 16739 | 16739 | 98855 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008612.6243900005 | 2110507.04759 | 37.775536385219105 | -122.41368716343399 | (37.7755363852191, -122.413687163434) | |||
| 17012 | 17012 | 7531 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2829 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008362.05512 | 2101958.45001 | 37.752049837241 | -122.41394907658702 | (37.752049837241, -122.413949076587) | |||
| 17189 | 17189 | 7579 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2995 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4x4 | 6008416.03486 | 2101001.24422 | 37.7494245965646 | -122.41369470787 | (37.7494245965646, -122.41369470787) | |||
| 17190 | 17190 | 7561 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2921 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6008393.481319999 | 2101389.9459599997 | 37.750490617869296 | -122.41380019023899 | (37.7504906178693, -122.413800190239) | |||
| 17202 | 17202 | 7497 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008270.16145 | 2102659.31707 | 37.753969098407005 | -122.41431644427401 | (37.753969098407, -122.414316444274) | |||
| 17226 | 17226 | 7461 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2590 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008225.965890001 | 2103367.55132 | 37.7559112662001 | -122.41451939607599 | (37.7559112662001, -122.414519396076) | |||
| 17228 | 17228 | 23635 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 108 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6006522.04559 | 2098512.21616 | 37.742483748623 | -122.420067568263 | (37.742483748623, -122.420067568263) | |||
| 17234 | 17234 | 7547 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2880 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008318.28918 | 2101705.8135599997 | 37.7513536963225 | -122.414082554892 | (37.7513536963225, -122.414082554892) | |||
| 17323 | 17323 | 7553 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2896 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6008325.6957 | 2101595.54831 | 37.751051348745996 | -122.41404914235001 | (37.751051348746, -122.41404914235) | |||
| 17325 | 17325 | 7646 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3301 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6008513.44624 | 2099397.67081 | 37.745027010685 | -122.413244473962 | (37.745027010685, -122.413244473962) | |||
| 17333 | 17333 | 7543 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2872 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6008316.06064 | 2101754.32335 | 37.7514867681181 | -122.41409369299299 | (37.7514867681181, -122.414093692993) | |||
| 17345 | 17345 | 7572 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2966 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6008349.712309999 | 2101178.7554599997 | 37.7499082780476 | -122.413936609292 | (37.7499082780476, -122.413936609292) | |||
| 17364 | 17364 | 7595 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3079 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008433.91036 | 2100662.40633 | 37.7484952272826 | -122.413608931409 | (37.7484952272826, -122.413608931409) | |||
| 17373 | 17373 | 4565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106X Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006455.63138 | 2098554.07674 | 37.742594946206296 | -122.420300179707 | (37.7425949462063, -122.420300179707) |
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");