Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16950 | 16950 | 25174 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3062 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6000130.8652 | 2105433.23803 | 37.761125030928895 | -122.44266313540199 | (37.7611250309289, -122.442663135402) | |||
| 18446 | 18446 | 25173 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3062 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6000161.42067 | 2105438.6168299997 | 37.761141541560505 | -122.44255784368 | (37.7611415415605, -122.44255784368) | |||
| 94472 | 94472 | 18524 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3104X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 6x9 | 6008391.22062 | 2100547.0534 | 37.748176096662604 | -122.413748394121 | (37.7481760966626, -122.413748394121) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17046 | 17046 | 7442 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2533 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008266.30803 | 2103660.34256 | 37.7567174706459 | -122.414400595608 | (37.7567174706459, -122.414400595608) | |||
| 17137 | 17137 | 608 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008346.158869999 | 2102213.06871 | 37.7527480699909 | -122.41402205928101 | (37.7527480699909, -122.414022059281) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17404 | 17404 | 7550 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2888 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008324.12517 | 2101635.93861 | 37.75116216321621 | -122.414057430518 | (37.7511621632162, -122.414057430518) | |||
| 17419 | 17419 | 7534 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2834 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008307.18508 | 2101915.21999 | 37.7519280555366 | -122.41413576777398 | (37.7519280555366, -122.414135767774) | |||
| 17428 | 17428 | 7555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2906 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.30695 | 2101471.08552 | 37.750709860893394 | -122.41402439212601 | (37.7507098608934, -122.414024392126) | |||
| 17555 | 17555 | 7607 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3167 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008461.5790099995 | 2100237.0852799998 | 37.7473289441915 | -122.413483177404 | (37.7473289441915, -122.413483177404) | |||
| 17627 | 17627 | 7541 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2862 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008316.9211099995 | 2101778.89436 | 37.7515542829106 | -122.414092455501 | (37.7515542829106, -122.414092455501) | |||
| 17713 | 17713 | 7452 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2567 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008279.6651800005 | 2103491.16877 | 37.756253708264104 | -122.414342431978 | (37.7562537082641, -122.414342431978) | |||
| 17777 | 17777 | 7574 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2970 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008349.21001 | 2101154.19809 | 37.749840820806 | -122.413936609291 | (37.749840820806, -122.413936609291) | |||
| 17816 | 17816 | 7436 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2521 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008264.24768 | 2103717.0411400003 | 37.756873036289605 | -122.414411732822 | (37.7568730362896, -122.414411732822) | |||
| 17947 | 17947 | 7528 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2815 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008357.33424 | 2102016.55073 | 37.7522091035878 | -122.41396951189199 | (37.7522091035878, -122.413969511892) | |||
| 17997 | 17997 | 7485 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2676 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008262.291898999 | 2102845.0627354 | 37.754478671863495 | -122.414356800841 | (37.7544786718635, -122.414356800841) | |||
| 18009 | 18009 | 7663 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3343 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008519.81594 | 2099195.42015 | 37.744472032765 | -122.41320814945801 | (37.744472032765, -122.413208149458) | |||
| 18040 | 18040 | 7529 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2819 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008358.68667 | 2102000.1305400003 | 37.752164093403294 | -122.413963673484 | (37.7521640934033, -122.413963673484) | |||
| 18068 | 18068 | 7513 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2756 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008281.04145 | 2102369.03072 | 37.7531726489075 | -122.414258281518 | (37.7531726489075, -122.414258281518) | |||
| 18174 | 18174 | 7503 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2721 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008331.5003 | 2102528.18533 | 37.753612485742295 | -122.41409504285 | (37.7536124857423, -122.41409504285) | |||
| 18234 | 18234 | 7509 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2737 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008336.68586 | 2102472.1775 | 37.753458992157704 | -122.414073147974 | (37.7534589921577, -122.414073147974) | |||
| 18282 | 18282 | 7659 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3339 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008524.12376 | 2099222.60541 | 37.7445469193178 | -122.413195175821 | (37.7445469193178, -122.413195175821) | |||
| 18443 | 18443 | 7462 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2595 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008288.941269999 | 2103332.41139 | 37.7558183176666 | -122.414299119707 | (37.7558183176666, -122.414299119707) | |||
| 18470 | 18470 | 7438 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2525 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008265.55566 | 2103676.03648 | 37.7567605203109 | -122.41440430801599 | (37.7567605203109, -122.414404308016) | |||
| 18720 | 18720 | 7427 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2507 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008260.8074199995 | 2103776.2617599997 | 37.7570354493563 | -122.414427820801 | (37.7570354493563, -122.414427820801) | |||
| 18924 | 18924 | 7460 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2585 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008283.172069999 | 2103400.23243 | 37.7560042147509 | -122.414323869978 | (37.7560042147509, -122.414323869978) | |||
| 18939 | 18939 | 7554 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2906 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.04331 | 2101493.18506 | 37.7507705264571 | -122.414026867047 | (37.7507705264571, -122.414026867047) | |||
| 19010 | 19010 | 7597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3106 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008396.4425 | 2100409.14848 | 37.747797733781795 | -122.41372058405099 | (37.7477977337818, -122.413720584051) | |||
| 19140 | 19140 | 7569 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2951 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5x5 | 6008400.77269 | 2101230.49082 | 37.750053199295 | -122.413763698449 | (37.750053199295, -122.413763698449) | |||
| 19200 | 19200 | 7570 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2960 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008348.00397 | 2101217.6000099997 | 37.7500148405247 | -122.413945264386 | (37.7500148405247, -122.413945264386) | |||
| 19591 | 19591 | 7508 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2733 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008332.697980001 | 2102504.20303 | 37.753546703038296 | -122.41408920446699 | (37.7535467030383, -122.414089204467) | |||
| 19630 | 19630 | 7453 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2570 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008223.86046 | 2103457.0339200003 | 37.7561568467812 | -122.414533009104 | (37.7561568467812, -122.414533009104) | |||
| 19825 | 19825 | 7539 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2857 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008370.65475 | 2101801.07309 | 37.7516181986274 | -122.41390820600701 | (37.7516181986274, -122.413908206007) | |||
| 19913 | 19913 | 7629 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008486.89529 | 2099750.51965 | 37.7459943646489 | -122.413361231161 | (37.7459943646489, -122.413361231161) | |||
| 19953 | 19953 | 7576 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2978 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6008351.0872599995 | 2101088.6463 | 37.749660935717 | -122.413925481097 | (37.749660935717, -122.413925481097) | |||
| 20038 | 20038 | 7605 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3161 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008457.15281 | 2100295.8297099997 | 37.747489994777105 | -122.413502636944 | (37.7474899947771, -122.413502636944) | |||
| 20066 | 20066 | 7641 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3289 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4x4 | 6008504.24968 | 2099498.35818 | 37.7453029595644 | -122.41328339301901 | (37.7453029595644, -122.413283393019) | |||
| 20069 | 20069 | 7575 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2970 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4x4 | 6008351.10034 | 2101124.2510900004 | 37.749758699223705 | -122.413927954233 | (37.7497586992237, -122.413927954233) | |||
| 20136 | 20136 | 7611 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3202 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008410.88803 | 2100143.2291900003 | 37.74706838989189 | -122.41365182637699 | (37.7470683898919, -122.413651826377) | |||
| 20308 | 20308 | 7459 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2584 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008225.5922300005 | 2103401.76682 | 37.7560051931888 | -122.41452310937599 | (37.7560051931888, -122.414523109376) | |||
| 20361 | 20361 | 7642 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3293 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008503.393730001 | 2099474.8384700003 | 37.745238331599396 | -122.41328468984301 | (37.7452383315994, -122.413284689843) | |||
| 20464 | 20464 | 7530 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2824 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008306.16811 | 2101970.47536 | 37.7520797172086 | -122.41414319344601 | (37.7520797172086, -122.414143193446) | |||
| 20550 | 20550 | 7661 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3340 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008464.3828 | 2099163.3028700002 | 37.7443807335859 | -122.413397555653 | (37.7443807335859, -122.413397555653) | |||
| 20687 | 20687 | 7517 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2771 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008345.2937199995 | 2102315.22385 | 37.753028516357006 | -122.41403227737801 | (37.753028516357, -122.414032277378) | |||
| 20695 | 20695 | 7467 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2608 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008233.92033 | 2103214.16495 | 37.755490548966996 | -122.414481033691 | (37.755490548967, -122.414481033691) | |||
| 20811 | 20811 | 7600 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3106 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008389.36019 | 2100484.75835 | 37.748004943889605 | -122.413750421747 | (37.7480049438896, -122.413750421747) | |||
| 20891 | 20891 | 607 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008349.31996 | 2102181.9005400003 | 37.7526626667701 | -122.414008922882 | (37.7526626667701, -122.414008922882) | |||
| 21079 | 21079 | 7447 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2553 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008274.59683 | 2103558.26276 | 37.7564376483819 | -122.414364707267 | (37.7564376483819, -122.414364707267) | |||
| 21092 | 21092 | 7500 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2709 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008323.747269999 | 2102623.75492 | 37.753874462753295 | -122.414128615438 | (37.7538744627533, -122.414128615438) | |||
| 21111 | 21111 | 7518 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2773 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008341.70972 | 2102366.99606 | 37.7531704698575 | -122.41404833388701 | (37.7531704698575, -122.414048333887) | |||
| 21142 | 21142 | 7514 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2757 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008339.77996 | 2102396.4575099996 | 37.753251255958 | -122.414057091485 | (37.753251255958, -122.414057091485) | |||
| 21218 | 21218 | 7609 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3201X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008465.56489 | 2100101.76306 | 37.7469576033137 | -122.413459825618 | (37.7469576033137, -122.413459825618) | |||
| 21254 | 21254 | 7533 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2828 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008307.50976 | 2101942.03769 | 37.7520017091344 | -122.414136542092 | (37.7520017091344, -122.414136542092) | |||
| 21274 | 21274 | 7489 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2675X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008322.6919 | 2102757.85565 | 37.754242613729794 | -122.41414175185801 | (37.7542426137298, -122.414141751858) | |||
| 21359 | 21359 | 7512 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2749 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008338.58227 | 2102420.44014 | 37.753317039572394 | -122.41406292987499 | (37.7533170395724, -122.414062929875) | |||
| 21393 | 21393 | 7546 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2877 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008375.68859 | 2101675.71306 | 37.751274270892 | -122.413881931411 | (37.751274270892, -122.413881931411) | |||
| 21407 | 21407 | 7606 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3165 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008459.42733 | 2100260.29181 | 37.747392543336794 | -122.413492258783 | (37.7473925433368, -122.413492258783) | |||
| 21409 | 21409 | 7441 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2533 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008268.72512 | 2103638.5572599997 | 37.7566577889552 | -122.414390694984 | (37.7566577889552, -122.414390694984) | |||
| 21417 | 21417 | 7439 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2530 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008208.94625 | 2103707.4827 | 37.7568436842019 | -122.414602309975 | (37.7568436842019, -122.414602309975) | |||
| 21542 | 21542 | 7565 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2933 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6008395.085519999 | 2101323.9209 | 37.7503094179601 | -122.413789973034 | (37.7503094179601, -122.413789973034) | |||
| 21564 | 21564 | 7560 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2918 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008338.44221 | 2101396.4402400004 | 37.7505053586356 | -122.41399097961599 | (37.7505053586356, -122.413990979616) | |||
| 21569 | 21569 | 7502 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2715 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008326.89994 | 2102592.16702 | 37.7537879066042 | -122.414115478143 | (37.7537879066042, -122.414115478143) | |||
| 21643 | 21643 | 606 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008351.06015 | 2102163.79121 | 37.75261304037179 | -122.41400162398399 | (37.7526130403718, -122.414001623984) | |||
| 21656 | 21656 | 7544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2872 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008318.08385 | 2101730.76273 | 37.751422189596 | -122.414085029817 | (37.751422189596, -122.414085029817) | |||
| 21665 | 21665 | 7644 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3297 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008507.0455599995 | 2099451.60062 | 37.745174730640294 | -122.413270419413 | (37.7451747306403, -122.413270419413) | |||
| 21762 | 21762 | 7538 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2850 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008311.6922 | 2101838.15576 | 37.751716707677005 | -122.414114729924 | (37.751716707677, -122.414114729924) | |||
| 21796 | 21796 | 7506 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2728 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008274.4224 | 2102517.7620200003 | 37.753580659623395 | -122.41429169402001 | (37.7535806596234, -122.41429169402) | |||
| 21798 | 21798 | 7504 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2721 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.67294 | 2102549.63808 | 37.75367134367279 | -122.414099421647 | (37.7536713436728, -122.414099421647) | |||
| 21857 | 21857 | 7627 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3254 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008428.98919 | 2099762.5381099996 | 37.746024113322 | -122.41356231324801 | (37.746024113322, -122.413562313248) | |||
| 21975 | 21975 | 7428 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2507 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008259.11324 | 2103798.38895 | 37.757096110403 | -122.414435245589 | (37.757096110403, -122.414435245589) | |||
| 22081 | 22081 | 7458 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2576 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008224.65711 | 2103426.0166 | 37.7560717250334 | -122.41452805924 | (37.7560717250334, -122.41452805924) | |||
| 22094 | 22094 | 7457 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2577 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008281.25133 | 2103428.77827 | 37.7560824872415 | -122.414332532234 | (37.7560824872415, -122.414332532234) | |||
| 22126 | 22126 | 7507 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2732 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008276.1167 | 2102495.63386 | 37.7535199958745 | -122.41428426921699 | (37.7535199958745, -122.414284269217) | |||
| 22130 | 22130 | 7455 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2573 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008281.50576 | 2103458.70502 | 37.7561646735838 | -122.41433376971202 | (37.7561646735838, -122.414333769712) | |||
| 22148 | 22148 | 7498 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008269.84083 | 2102643.6447900003 | 37.7539260478636 | -122.414316444251 | (37.7539260478636, -122.414316444251) | |||
| 22184 | 22184 | 7519 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2779 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008346.733630001 | 2102261.81397 | 37.752881945755895 | -122.41402351977399 | (37.7528819457559, -122.414023519774) | |||
| 22223 | 22223 | 7630 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008486.33548 | 2099778.1775 | 37.7460702755308 | -122.41336512251499 | (37.7460702755308, -122.413365122515) | |||
| 22278 | 22278 | 7433 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2515 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008263.61131 | 2103755.8939400003 | 37.7569796814773 | -122.41441668270399 | (37.7569796814773, -122.414416682704) | |||
| 85712 | 85712 | 7527 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2808 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008275.78702 | 2102017.83073 | 37.7522080378675 | -122.41425160630101 | (37.7522080378675, -122.414251606301) | |||
| 88731 | 88731 | 7571 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2961 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008420.23555 | 2101188.1699900003 | 37.749938088747605 | -122.41369340153601 | (37.7499380887476, -122.413693401536) | |||
| 92873 | 92873 | 7632 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.746018935721104 | -122.413278959756 | (37.7460189357211, -122.413278959756) | |||
| 98874 | 98874 | 7585 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3000X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.41382093686701 | (37.7492862752884, -122.413820936867) | |||
| 101710 | 101710 | 7631 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008510.8607 | 2099758.97829 | 37.746018935721104 | -122.413278959756 | (37.7460189357211, -122.413278959756) | |||
| 101737 | 101737 | 18526 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3104X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.748176096662604 | -122.413748394121 | (37.7481760966626, -122.413748394121) | |||
| 102350 | 102350 | 7633 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.746018935721104 | -122.413278959756 | (37.7460189357211, -122.413278959756) | |||
| 103654 | 103654 | 18528 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3104X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.748176096662604 | -122.413748394121 | (37.7481760966626, -122.413748394121) | |||
| 104381 | 104381 | 7463 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2598 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008200.03258 | 2103349.78607 | 37.7558610299084 | -122.41460782513 | (37.7558610299084, -122.41460782513) | |||
| 105222 | 105222 | 18529 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3104X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.748176096662604 | -122.413748394121 | (37.7481760966626, -122.413748394121) | |||
| 109710 | 109710 | 7588 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3000X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.41382093686701 | (37.7492862752884, -122.413820936867) | |||
| 110373 | 110373 | 7437 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2522 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008197.54046 | 2103734.7935 | 37.7569180326266 | -122.414643688184 | (37.7569180326266, -122.414643688184) | |||
| 111374 | 111374 | 7602 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3129 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008475.0 | 2100384.0 | 37.7477330928409 | -122.413447156935 | (37.7477330928409, -122.413447156935) |
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");