Street_Tree_List

Data source: data.sfgov.org

2,323 rows where qSpecies = 46 sorted by TreeID

View and edit SQL

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
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)
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)
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)
11281 1166 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2900 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 25 3X3   5997012.91474 2087625.1618700002 37.7120501257788 -122.45216178836 (37.7120501257788, -122.45216178836)
78358 1208 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 3141 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3x3   5995992.87885 2086942.4061599998 37.7101169521706 -122.455637985173 (37.7101169521706, -122.455637985173)
85950 1325 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 4051X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   5991764.76245 2086963.37686 37.709930989883496 -122.47025258193399 (37.7099309898835, -122.470252581934)
93043 2242 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2799X PINE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6000783.0 2114845.0 37.7870045110932 -122.441082939895 (37.7870045110932, -122.441082939895)
125035 2598 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1738 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005142.528530001 2115146.44686 37.788079556998504 -122.42602140794901 (37.7880795569985, -122.426021407949)
23302 2630 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1884 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004516.4784 2115043.5247 37.7877615564114 -122.428180094678 (37.7877615564114, -122.428180094678)
6566 2631 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1884 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004489.1648 2115039.2121 37.787748169652204 -122.428274287097 (37.7877481696522, -122.428274287097)
145764 2632 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1884 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004471.16425 2115036.06465 37.7877385090069 -122.42833634117399 (37.7877385090069, -122.428336341174)
83814 2633 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1884 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6004452.48891 2115034.49338 37.7877331379393 -122.428400842266 (37.7877331379393, -122.428400842266)
120892 3749 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 934 Carolina St 3 Median : Cutout 11 Tree 1 DPW 2     3 18   6012421.507139799 2103592.6632765 37.756764184951 -122.40002555654199 (37.756764184951, -122.400025556542)
17624 4231 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 3992 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/27/2003 12:00:00 AM 3 3X3   6003972.48487 2100441.01893 37.7476358171535 -122.429020679863 (37.7476358171535, -122.429020679863)
20526 4476 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1524 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/16/2003 12:00:00 AM 6 3X3   6004536.76102 2099988.71011 37.7464258062985 -122.427037234079 (37.7464258062985, -122.427037234079)
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)
20914 4566 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 106X Virginia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2016 12:00:00 AM 12 3X3   6006479.71302 2098542.22808 37.742563769401606 -122.42021607152901 (37.7425637694016, -122.420216071529)
106351 5322 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2689X Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6001088.8002445 2114863.0175008997 37.78707139571671 -122.44002623476001 (37.7870713957167, -122.44002623476)
104484 5323 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2689X Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6001088.8002445 2114863.0175008997 37.78707139571671 -122.44002623476001 (37.7870713957167, -122.44002623476)
111620 5924 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1303X Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6004204.78385 2112867.75704 37.781769802163794 -122.429103304637 (37.7817698021638, -122.429103304637)
96498 5928 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1335 Eddy St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6004029.334559999 2112693.29822 37.781280848415 -122.42969783017901 (37.781280848415, -122.429697830179)
8667 6037 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1822 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2008 12:00:00 AM 3 3x3 Permit Number 51912 6001625.9468 2112554.8978 37.7807644518495 -122.43800243798 (37.7807644518495, -122.43800243798)
19037 7013 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1031 Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/02/1997 12:00:00 AM 8 3X3   6002426.7807 2110189.6116 37.774315477420295 -122.435062751747 (37.7743154774203, -122.435062751747)
15989 7405 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1065 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/1998 12:00:00 AM 6 3X3   6010535.4473 2111084.5056 37.7772297388865 -122.407076335552 (37.7772297388865, -122.407076335552)
108984 7426 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2502 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6008150.242000001 2103802.5561599997 37.7571014359411 -122.414812060086 (37.7571014359411, -122.414812060086)
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)
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)
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)
18353 7435 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2520 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/02/1999 12:00:00 AM 18 3X3   6008207.33227 2103733.52781 37.756915107460706 -122.414609734768 (37.7569151074607, -122.414609734768)
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)
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)
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)
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)
17556 7440 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2528 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6008209.2972 2103689.6592099997 37.7567947646774 -122.414599835016 (37.7567947646774, -122.414599835016)
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)
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)
18725 7443 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2534 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6008210.94059 2103665.03858 37.7567272543663 -122.414592409333 (37.7567272543663, -122.414592409333)
21173 7444 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2542 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 3x3   6008213.31422 2103623.65609 37.7566137608307 -122.41458127211901 (37.7566137608307, -122.414581272119)
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)
21934 7448 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2555 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 3X3   6008276.19632 2103531.50525 37.7563642681995 -122.41435728246401 (37.7563642681995, -122.414357282464)
20839 7449 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2560 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6008221.10246 2103514.06218 37.756313278459395 -122.414546582563 (37.7563132784594, -122.414546582563)
22268 7450 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2561 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6008277.67861 2103516.50911 37.75632317547829 -122.41435109514799 (37.7563231754783, -122.414351095148)
19008 7451 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2550 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4 3X3   6008217.64578 2103538.04814 37.756378944247 -122.414560234263 (37.756378944247, -122.414560234263)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
18904 7466 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2601 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X3   6008295.31777 2103224.31145 37.7555218579731 -122.41426941961001 (37.7555218579731, -122.41426941961)
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)
17934 7468 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2612 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6008237.96607 2103167.04597 37.7553613982341 -122.41446370825899 (37.7553613982341, -122.414463708259)
18255 7469 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2623 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6008298.43979 2103140.4111200003 37.7552916620849 -122.414252686824 (37.7552916620849, -122.414252686824)
19328 7470 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2629 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x3   6008300.06862 2103096.2458 37.755170485633 -122.41424392921002 (37.755170485633, -122.41424392921)
19628 7471 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2637 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 3x3   6008304.34072 2103057.49026 37.755064311682 -122.414226413135 (37.755064311682, -122.414226413135)
23179 7484 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2678 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 3X3   6008256.897969999 2102850.5873 37.754493538061205 -122.414375845389 (37.7544935380612, -122.414375845389)
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)
20521 7487 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2675X Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6008318.247830001 2102788.20898 37.7543257074831 -122.41415926793002 (37.7543257074831, -122.41415926793)
19287 7488 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2675X Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X3   6008316.60225 2102810.93946 37.7543880278024 -122.41416656683501 (37.7543880278024, -122.414166566835)
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)
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)
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)
21473 7499 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2701 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X3   6008322.359759999 2102659.08935 37.7539714051695 -122.414135913444 (37.7539714051695, -122.414135913444)
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)
18329 7501 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2712 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2004 12:00:00 AM 6 3X3   6008270.89385 2102590.17173 37.7537792820952 -122.414309019468 (37.7537792820952, -122.414309019468)
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)
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)
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)
22153 7505 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2722 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6008270.982530001 2102559.5246200003 37.7536951370472 -122.41430654453801 (37.7536951370472, -122.414306544538)
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)
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)
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)
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)
19189 7510 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2740 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6008277.62193 2102459.7127 37.7534214490446 -122.41427652245001 (37.7534214490446, -122.41427652245)
22060 7511 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2746 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3X3   6008278.19971 2102422.54069 37.7533194155643 -122.414271894535 (37.7533194155643, -122.414271894535)
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)
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)
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)
21053 7515 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2760 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 3X3   6008282.29064 2102342.6354400003 37.7531002436021 -122.41425209418301 (37.7531002436021, -122.414252094183)
20774 7516 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2764 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 5x5   6008283.77365 2102310.17771 37.753011205311395 -122.414244669368 (37.7530112053114, -122.414244669368)
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)
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)
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)
20189 7520 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2782 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/2015 12:00:00 AM 3 3X3   6008289.02576 2102217.06368 37.752755830229894 -122.41421991914 (37.7527558302299, -122.41421991914)
21297 7521 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2790X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3X3   6008290.58191 2102188.16765 37.7526765756645 -122.414212493437 (37.7526765756645, -122.414212493437)
21208 7522 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2801 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   6008356.19666 2102043.47464 37.752282966686295 -122.413975350304 (37.7522829666863, -122.413975350304)
10250 7523 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2801 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   6008355.713819999 2102061.13803 37.752331439255705 -122.413978269475 (37.7523314392557, -122.413978269475)
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)
19576 7525 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2804 Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6008301.92426 2102042.90132 37.7522783441942 -122.41416299292601 (37.7522783441942, -122.414162992926)
3363 7526 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2808 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/08/2004 12:00:00 AM 3 3x3   6008303.39209 2102027.1918 37.7522352918412 -122.414156805597 (37.7522352918412, -122.414156805597)
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)
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)
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)
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)
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)
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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 1569.351ms · Data source: data.sfgov.org