Street_Tree_List

Data source: data.sfgov.org

430 rows where qSpecies = 53 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189005 189005 105881 Undocumented 2 Ulmus pumila :: Siberian Elm 53 250 Locust St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30     5997617.52659 2115483.20836 37.788576052199396 -122.452080774722 (37.7885760521994, -122.452080774722)
188100 188100 215642 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 85 : 4 Tree 1 Private 1     3 Width 0ft   5991146.327190001 2090562.0053700001 37.7197761709066 -122.47265219363999 (37.7197761709066, -122.47265219364)
187609 187609 215640 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 83 : 4 Tree 1 Private 1     5 Width 0ft   5991139.98278 2090571.01197 37.71980053355961 -122.472674780143 (37.7198005335596, -122.472674780143)
187353 187353 142975 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2000 Stockton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6009927.4614 2120951.259 37.804287419917294 -122.40987623003299 (37.8042874199173, -122.409876230033)
186517 186517 199851 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1603 Armstrong Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 0ft   6014366.3226 2092462.8184 37.7263121847089 -122.392521119846 (37.7263121847089, -122.392521119846)
185313 185313 215647 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 90 : 4 Tree 1 Private 1     5 Width 0ft   5991141.92136 2090550.26747 37.719743686490396 -122.472666567521 (37.7197436864904, -122.472666567521)
184481 184481 185713 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984850.6272 2100403.3767 37.746431518886105 -122.49513921196301 (37.7464315188861, -122.495139211963)
184419 184419 142972 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2010 Stockton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   6009915.1882 2121025.8734 37.804491604686206 -122.409923973004 (37.8044916046862, -122.409923973004)
184159 184159 215648 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 92 : 4 Tree 1 Private 1     3 Width 0ft   5991148.46508 2090549.7895400003 37.7197427529995 -122.472643913597 (37.7197427529995, -122.472643913597)
184155 184155 185728 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 0ft   5984906.201 2100307.5936 37.7461717779802 -122.494939985658 (37.7461717779802, -122.494939985658)
183478 183478 215589 Undocumented 2 Ulmus pumila :: Siberian Elm 53 551 Junipero Serra Blvd 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991458.35334 2093660.05844 37.7283007142025 -122.47179930268999 (37.7283007142025, -122.47179930269)
183192 183192 215611 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 51 : 4 Tree 1 Private 1     3 Width 0ft   5991153.406 2090660.89558 37.720048108812705 -122.472634931171 (37.7200481088127, -122.472634931171)
183011 183011 124687 Undocumented 2 Ulmus pumila :: Siberian Elm 53 460 Arguello Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   5995608.47806 2113376.19737 37.782675480559504 -122.45887912132 (37.7826754805595, -122.45887912132)
181588 181588 137074 Undocumented 2 Ulmus pumila :: Siberian Elm 53 3598 Clay St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 4ft   5997641.85824 2115456.61364 37.7885044238892 -122.45199467183998 (37.7885044238892, -122.45199467184)
181118 181118 123469 Undocumented 2 Ulmus pumila :: Siberian Elm 53 772 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 5ft   5995383.36925 2110442.32995 37.7746069181393 -122.459445351917 (37.7746069181393, -122.459445351917)
180677 180677 102615 Undocumented 2 Ulmus pumila :: Siberian Elm 53 392 Chestnut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3x3   6009946.866 2120935.8276 37.804246136595296 -122.409807988636 (37.8042461365953, -122.409807988636)
179478 179478 215604 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 38 : 4 Tree 1 Private 1     3 Width 0ft   5991153.81619 2090748.1801 37.7202877943298 -122.472639873854 (37.7202877943298, -122.472639873854)
179443 179443 137080 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1639 Taylor St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008758.62885 2118554.07509 37.79763977591279 -122.41375141818999 (37.7976397759128, -122.41375141819)
179042 179042 215595 Undocumented 2 Ulmus pumila :: Siberian Elm 53 400 Junipero Serra Blvd 11 : 4 Tree 1 Private 1     6 Width 0ft   5991368.98283 2094166.96047 37.7296873689589 -122.47214519097 (37.7296873689589, -122.47214519097)
178804 178804 215588 Undocumented 2 Ulmus pumila :: Siberian Elm 53 551 Junipero Serra Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991446.82162 2093469.8712 37.7277778402634 -122.47182531290899 (37.7277778402634, -122.471825312909)
177920 177920 182454 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1500 31st Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 0ft   5986553.619 2104615.5531 37.7580965659316 -122.489560229786 (37.7580965659316, -122.489560229786)
177374 177374 123487 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     5995668.73883 2111844.87781 37.778474348143895 -122.45855975947599 (37.7784743481439, -122.458559759476)
176952 176952 215598 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 48 : 4 Tree 1 Private 1     13 Width 0ft   5991274.418330001 2092469.9979599998 37.725022460494706 -122.472348449422 (37.7250224604947, -122.472348449422)
176243 176243 215636 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 79 : 4 Tree 1 Private 1     4 Width 0ft   5991147.9135 2090580.90098 37.7198281454204 -122.472648087333 (37.7198281454204, -122.472648087333)
175894 175894 137070 Undocumented 2 Ulmus pumila :: Siberian Elm 53 7 Laurel St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   5997942.37701 2116329.50618 37.7909183634316 -122.451017898383 (37.7909183634316, -122.451017898383)
175491 175491 137081 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1627 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008775.75798 2118410.46159 37.7972464106437 -122.413681983361 (37.7972464106437, -122.413681983361)
175424 175424 215628 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 71 : 4 Tree 1 Private 1     11 Width 0ft   5991139.39343 2090599.4181400002 37.7198784957874 -122.47267888733299 (37.7198784957874, -122.472678887333)
175293 175293 199849 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1607 Armstrong Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 0ft   6014322.4694 2092498.1446 37.7264067479006 -122.392675189528 (37.7264067479006, -122.392675189528)
173805 173805 123488 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     5995672.61976 2111816.69318 37.7783971836602 -122.458544293173 (37.7783971836602, -122.458544293173)
172911 172911 105883 Undocumented 2 Ulmus pumila :: Siberian Elm 53 250 Locust St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15     5997608.20664 2115530.35123 37.7887049601136 -122.452116422945 (37.7887049601136, -122.452116422945)
172059 172059 182465 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2400 Lawton St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 0ft   5986689.3022 2104396.9525 37.7575042689843 -122.489074914666 (37.7575042689843, -122.489074914666)
171899 171899 123484 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33     5995663.25844 2111930.13675 37.778708131625294 -122.458584891633 (37.7787081316253, -122.458584891633)
171488 171488 215651 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2105 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5993642.48221 2101265.6792599997 37.749309980671796 -122.46480082800501 (37.7493099806718, -122.464800828005)
171388 171388 137079 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1639 Taylor St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008755.558119999 2118570.22529 37.7976839479247 -122.413763186745 (37.7976839479247, -122.413763186745)
170878 170878 185719 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984913.7198 2100361.206 37.7463194231796 -122.49491793929899 (37.7463194231796, -122.494917939299)
170582 170582 242796 Undocumented 2 Ulmus pumila :: Siberian Elm 53 140 Belgrave Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 2ft   5997883.8658300005 2104916.82278 37.7595787374877 -122.450397275322 (37.7595787374877, -122.450397275322)
170489 170489 215610 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 50 : 4 Tree 1 Private 1     6 Width 0ft   5991146.77446 2090663.32778 37.7200544031655 -122.472658031161 (37.7200544031655, -122.472658031161)
170241 170241 180589 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1241 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   6003010.99045 2094126.1928400001 37.7302422857354 -122.431894635246 (37.7302422857354, -122.431894635246)
166993 166993 107483 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1306x Montgomery St 6 Median : Cutout 11 Tree 1 DPW 2     17     6011458.52251 2119859.64432 37.8013757989196 -122.404500953851 (37.8013757989196, -122.404500953851)
166700 166700 180582 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1110 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 4ft   6003793.49913 2094480.4258 37.7312592588934 -122.429214647441 (37.7312592588934, -122.429214647441)
166173 166173 124694 Undocumented 2 Ulmus pumila :: Siberian Elm 53 460 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5995618.45318 2113098.44712 37.78191342592 -122.45882449658501 (37.78191342592, -122.458824496585)
165950 165950 215586 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5991393.3825900005 2092629.9672299998 37.725468580903 -122.471948860848 (37.725468580903, -122.471948860848)
165193 165193 215592 Undocumented 2 Ulmus pumila :: Siberian Elm 53 177 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5995226.8577 2087383.90223 37.7112852083174 -122.458317422904 (37.7112852083174, -122.458317422904)
163752 163752 182456 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1500 31st Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 0ft   5986548.9803 2104699.0505 37.758325556062104 -122.489582412162 (37.7583255560621, -122.489582412162)
163579 163579 215612 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 53 : 4 Tree 1 Private 1     1 Width 0ft   5991154.50456 2090649.59615 37.720017146953 -122.472630310457 (37.720017146953, -122.472630310457)
162620 162620 123479 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39     5995657.67406 2112077.16899 37.7791115222078 -122.458614856747 (37.7791115222078, -122.458614856747)
161666 161666 215607 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 47 : 4 Tree 1 Private 1     2 Width 0ft   5991157.54734 2090681.2167900002 37.7201041455671 -122.47262209693301 (37.7201041455671, -122.472622096933)
160644 160644 215625 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 67 : 4 Tree 1 Private 1     7 Width 0ft   5991149.7740400005 2090612.8046400002 37.719915852707295 -122.472643981029 (37.7199158527073, -122.472643981029)
159718 159718 215608 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 48 : 4 Tree 1 Private 1     2 Width 0ft   5991156.01629 2090675.51857 37.720088411035206 -122.47262697396799 (37.7200884110352, -122.472626973968)
158658 158658 215606 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 40 : 4 Tree 1 Private 1     11 Width 0ft   5991163.46661 2090729.52448 37.7202371292081 -122.47260515641399 (37.7202371292081, -122.472605156414)
158560 158560 123481 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34     5995659.669480001 2112025.6512 37.7789701827075 -122.458604223385 (37.7789701827075, -122.458604223385)
157916 157916 215630 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 73 : 4 Tree 1 Private 1     9 Width 0ft   5991138.04395 2090591.7564599998 37.7198573805858 -122.47268299363998 (37.7198573805858, -122.47268299364)
157547 157547 215619 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 61 : 4 Tree 1 Private 1     10 Width 0ft   5991156.50194 2090623.6682099998 37.719946070837395 -122.472621516875 (37.7199460708374, -122.472621516875)
156335 156335 142234 Undocumented 2 Ulmus pumila :: Siberian Elm 53 689 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 0ft   6004609.2702 2110836.2012 37.77621453898529 -122.427559190874 (37.7762145389853, -122.427559190874)
155297 155297 215637 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 80 : 4 Tree 1 Private 1     4 Width 0ft   5991151.99496 2090577.2658 37.7198184003677 -122.47263371439699 (37.7198184003677, -122.472633714397)
155249 155249 215634 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 77 : 4 Tree 1 Private 1     4 Width 0ft   5991150.9321800005 2090583.20344 37.7198346421452 -122.47263782070101 (37.7198346421452, -122.472637820701)
153233 153233 185963 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2001 Sunset Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984881.7314 2101336.1941 37.7489946017929 -122.495100432866 (37.7489946017929, -122.495100432866)
152798 152798 123480 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34     5995658.308019999 2112054.06112 37.7790481105637 -122.458610990374 (37.7790481105637, -122.458610990374)
152540 152540 180586 Undocumented 2 Ulmus pumila :: Siberian Elm 53 177 Santa Rosa Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6001346.13618 2093162.98872 37.7275030272355 -122.437581294937 (37.7275030272355, -122.437581294937)
150428 150428 242795 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1671 Peralta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009731.24755 2099988.4352599997 37.7467174150944 -122.409075193563 (37.7467174150944, -122.409075193563)
149713 149713 137067 Undocumented 2 Ulmus pumila :: Siberian Elm 53 7 Laurel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5997931.48984 2116393.73013 37.791094081978 -122.45106020067 (37.791094081978, -122.45106020067)
149316 149316 137071 Undocumented 2 Ulmus pumila :: Siberian Elm 53 7 Laurel St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   5997945.511630001 2116314.45646 37.7908772203684 -122.451005967078 (37.7908772203684, -122.451005967078)
149241 149241 215584 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5991387.10122 2092540.18841 37.7252217070935 -122.471964034223 (37.7252217070935, -122.471964034223)
147734 147734 180580 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1282 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 5ft   6002752.91911 2094123.24132 37.7302195481937 -122.432786610727 (37.7302195481937, -122.432786610727)
147002 147002 83273 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1639X Taylor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/21/2006 12:00:00 AM 3     6008750.425980001 2118601.9970299997 37.797770897055294 -122.413783193943 (37.7977708970553, -122.413783193943)
145740 145740 123490 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     5995673.905040001 2111757.95548 37.7782359793629 -122.45853559389299 (37.7782359793629, -122.458535593893)
145404 145404 1420 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 50 Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     50 3x3   5995529.5957 2115606.06371 37.7887935591586 -122.45931355109501 (37.7887935591586, -122.459313551095)
145390 145390 6278 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1475 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
145198 145198 1432 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 75X Arguello Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 5   5995472.27833 2115471.9588 37.7884220478225 -122.45950214341002 (37.7884220478225, -122.45950214341)
144992 144992 93023 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 394 Fair Oaks St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Tree 2 on 25th St 6005476.0 2101410.0 37.750381408432204 -122.42389049729601 (37.7503814084322, -122.423890497296)
144278 144278 2933 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1834 California St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/29/1997 12:00:00 AM 7 3X3   6005503.04257 2115905.51621 37.7901841403418 -122.424828114668 (37.7901841403418, -122.424828114668)
144014 144014 1218 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 3575X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X3   5993629.70146 2087487.1964900002 37.711476919919 -122.463845046869 (37.711476919919, -122.463845046869)
143670 143670 19065 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 179 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   5995218.7218404 2087397.9242615001 37.711323242006294 -122.45834655658399 (37.7113232420063, -122.458346556584)
143144 143144 105784 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1570 31ST AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
142032 142032 1248 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3731 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3x3   5993002.942009999 2087547.889 37.711607428767294 -122.466015680425 (37.7116074287673, -122.466015680425)
141240 141240 11874 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1499X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     30 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
141047 141047 917 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1245 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   6003003.64796 2094102.5381599998 37.730176919086496 -122.43191833078899 (37.7301769190865, -122.431918330789)
141037 141037 26779 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 800X Junipero Serra Blvd 34 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
140740 140740 1474 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 234 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3x5   5995562.8915 2114652.7171099996 37.7861778408698 -122.459129293157 (37.7861778408698, -122.459129293157)
140555 140555 22541 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1396X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     26 3X3   6002380.38751 2093819.80205 37.7293652374447 -122.434052817677 (37.7293652374447, -122.434052817677)
140037 140037 19107 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3155X Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   5995592.56281 2086919.9321700002 37.7100322629968 -122.457019923286 (37.7100322629968, -122.457019923286)
140006 140006 1051 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 2035X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6000572.81835 2090254.9074400002 37.7194741008396 -122.44004621634599 (37.7194741008396, -122.440046216346)
139773 139773 97504 Undocumented 2 Ulmus pumila :: Siberian Elm 53 20X 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/18/2011 12:00:00 AM 12 3x3 Permit Number 768079 6007672.0 2110712.0 37.7760462700595 -122.416955543158 (37.7760462700595, -122.416955543158)
139352 139352 1510 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 369 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3x3   5995536.869969999 2113765.1567 37.7837393424086 -122.45915502719102 (37.7837393424086, -122.459155027191)
139259 139259 29914 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 810 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12     5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
138620 138620 1526 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 440 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3x3   5995608.48873 2113422.41383 37.782802379218296 -122.458882431606 (37.7828023792183, -122.458882431606)
138406 138406 1052 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2039X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6000548.43841 2090229.36669 37.719402583767 -122.44012865812 (37.719402583767, -122.44012865812)
138392 138392 1014 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1852X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   6001135.54804 2091400.8212599999 37.7226525409555 -122.438183116075 (37.7226525409555, -122.438183116075)
138110 138110 215582 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991378.73804 2092411.11653 37.7248668238178 -122.47198354142999 (37.7248668238178, -122.47198354143)
136479 136479 215618 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 60 : 4 Tree 1 Private 1     8 Width 0ft   5991156.49559 2090631.32735 37.719967100580796 -122.472622096952 (37.7199671005808, -122.472622096952)
136462 136462 215621 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 63 : 4 Tree 1 Private 1     3 Width 0ft   5991148.3674800005 2090618.2199 37.7199306402575 -122.47264923758999 (37.7199306402575, -122.47264923759)
136173 136173 185691 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984865.9917 2100533.4848 37.746789659782 -122.49509567655001 (37.746789659782, -122.49509567655)
136034 136034 137077 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2955 Steiner St 1 Front Yard : Yard 7 Tree 1 Private 1     5 Width 5ft   6001974.0393199995 2118352.39854 37.796702688621004 -122.437213445266 (37.796702688621, -122.437213445266)
135449 135449 123482 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35     5995660.39644 2111993.63742 37.7788823231397 -122.458599390427 (37.7788823231397, -122.458599390427)
134549 134549 215585 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   5991388.97305 2092569.49487 37.725302283667396 -122.471959698575 (37.7253022836674, -122.471959698575)
133735 133735 215638 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 81 : 4 Tree 1 Private 1     17 Width 0ft   5991161.28352 2090567.01377 37.7197907884826 -122.47260086035801 (37.7197907884826, -122.472600860358)
133658 133658 180592 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1804 Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     33 Width 4ft   6001143.73267 2091406.4041400002 37.72266833577 -122.438155223402 (37.72266833577, -122.438155223402)
133362 133362 185690 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984904.8934 2100540.6767 37.7468116841536 -122.494961690438 (37.7468116841536, -122.494961690438)
131994 131994 199846 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1613 Armstrong Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 0ft   6014210.3999 2092579.1513 37.726622951149395 -122.393068277245 (37.7266229511494, -122.393068277245)
130396 130396 215622 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 64 : 4 Tree 1 Private 1     3 Width 0ft   5991146.64961 2090624.8002099998 37.7199486087273 -122.472655655135 (37.7199486087273, -122.472655655135)

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 88.29ms · Data source: data.sfgov.org