Street_Tree_List

Data source: data.sfgov.org

500 rows where qSiteInfo = 2 and qSpecies = 15 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 500 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
165337 165337 178601 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 654 Brotherhood Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5990455.55423 2088469.00468 37.7139892970456 -122.474887233782 (37.7139892970456, -122.474887233782)
187274 187274 178602 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 654 Brotherhood Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5990447.2893 2088474.31285 37.7140033930131 -122.47491618743601 (37.7140033930131, -122.474916187436)
159789 159789 178603 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 654 Brotherhood Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5990440.31227 2088479.59352 37.714017488102606 -122.474940687671 (37.7140174881026, -122.474940687671)
63730 63730 178606 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5989765.07873 2089203.5232 37.715966065363205 -122.47732740025499 (37.7159660653632, -122.477327400255)
139222 139222 111092 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 801 GONZALEZ DR   Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/04/2015 12:00:00 AM 2   Permit Number 775593 5988333.0 2089769.0 37.717435525652704 -122.48231868452 (37.7174355256527, -122.48231868452)
111271 111271 111095 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 841x GONZALEZ DR 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/04/2015 12:00:00 AM 3   Permit Number 775593 5988358.0 2089771.0 37.7174424713469 -122.48223241855301 (37.7174424713469, -122.482232418553)
146394 146394 178605 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988508.8443599995 2089780.72483 37.71747794624039 -122.48171173733299 (37.7174779462404, -122.481711737333)
148106 148106 178604 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5988124.07873 2089803.3530000001 37.7175176953569 -122.48304333649999 (37.7175176953569, -122.4830433365)
24035 24035 178607 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     5990327.66617 2089955.55198 37.7180635775375 -122.47543773036101 (37.7180635775375, -122.475437730361)
81509 81509 106258 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 205 GRANADA AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 4x4   5995602.7 2091290.9 37.722034494846895 -122.457300887551 (37.7220344948469, -122.457300887551)
33991 33991 211989 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 751 Junipero Serra Blvd 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5991413.9184 2093039.12628 37.7265932181855 -122.47190767821002 (37.7265932181855, -122.47190767821)
162153 162153 201632 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 451 Galvez Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6021871.21572 2093119.8757200001 37.728530265257504 -122.366622037185 (37.7285302652575, -122.366622037185)
25954 25954 201635 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 451 Galvez Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6021853.58241 2093133.73067 37.7285673424948 -122.36668395282301 (37.7285673424948, -122.366683952823)
61764 61764 201633 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 451 Galvez Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6021837.4277 2093144.7538400001 37.7285967251547 -122.36674056154699 (37.7285967251547, -122.366740561547)
186137 186137 201634 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 451 Galvez Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6021819.77945 2093157.84467 37.728631703379996 -122.366802476247 (37.72863170338, -122.366802476247)
152013 152013 201631 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 451 Galvez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6021802.56362 2093169.8437599998 37.728663707547 -122.366862820783 (37.728663707547, -122.366862820783)
147489 147489 201630 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 451 Galvez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   6021771.18031 2093196.4626099998 37.72873507866179 -122.36697315229799 (37.7287350786618, -122.366973152298)
60882 60882 201626 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 401 Galvez Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6021390.17472 2093479.1465200002 37.729490394945294 -122.36830984254298 (37.7294903949453, -122.368309842543)
162543 162543 201617 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 401 Galvez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6021188.31873 2093585.6418599999 37.729771742469794 -122.369015041404 (37.7297717424698, -122.369015041404)
67615 67615 201618 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 401 Galvez Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6021223.045080001 2093587.4702 37.7297786672424 -122.36889511322701 (37.7297786672424, -122.368895113227)
171364 171364 178593 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2981 19th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5990533.36315 2095360.02657 37.732914833452504 -122.475121049402 (37.7329148334525, -122.475121049402)
66238 66238 211956 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 285 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5993339.338880001 2095410.4143599998 37.733215414742 -122.46542380638901 (37.733215414742, -122.465423806389)
33263 33263 211957 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 285 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5993368.76024 2095426.56277 37.7332614510564 -122.465323262185 (37.7332614510564, -122.465323262185)
57187 57187 211955 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 290 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 4ft   5993309.844769999 2095438.0104200002 37.733289485612396 -122.46552777877899 (37.7332894856124, -122.465527778779)
41220 41220 211958 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 285 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 4ft   5993403.4688 2095447.0539400002 37.7333197163251 -122.46520475402201 (37.7333197163251, -122.465204754022)
148074 148074 211954 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 290 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993350.166619999 2095459.25682 37.7333501484938 -122.46538991902901 (37.7333501484938, -122.465389919029)
66287 66287 211959 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 285 San Anselmo Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5993435.0459 2095467.08654 37.733376541783294 -122.46509703862301 (37.7333765417833, -122.465097038623)
76004 76004 211953 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 270 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993388.72204 2095482.03326 37.7334149104567 -122.46525827714899 (37.7334149104567, -122.465258277149)
65738 65738 211952 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 270 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 4ft   5993426.46575 2095509.00645 37.733491148700296 -122.46512974604299 (37.7334911487003, -122.465129746043)
47067 47067 211960 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 265 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5993488.382619999 2095510.5494799998 37.73349895569989 -122.464915795553 (37.7334989556999, -122.464915795553)
177261 177261 211951 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 270 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5993457.58521 2095534.6262299998 37.73356328871179 -122.465024018166 (37.7335632887118, -122.465024018166)
76091 76091 211961 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 265 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5993510.68843 2095534.08723 37.733564870623205 -122.464840387393 (37.7335648706232, -122.464840387393)
31366 31366 211962 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 251 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5993535.73552 2095560.6161 37.733639156417496 -122.46475571890801 (37.7336391564175, -122.464755718908)
132123 132123 211963 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 251 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993558.89416 2095588.3274 37.733716579938296 -122.464677664965 (37.7337165799383, -122.464677664965)
152467 152467 211950 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 260 San Anselmo Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5993530.62108 2095614.59892 37.7337870850001 -122.46477731972601 (37.7337870850001, -122.464777319726)
134408 134408 211964 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 235 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5993592.0867099995 2095638.31019 37.7338557338432 -122.464566537527 (37.7338557338432, -122.464566537527)
65749 65749 211949 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 260 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5993555.39136 2095651.99557 37.733891195019005 -122.464694396842 (37.733891195019, -122.464694396842)
169824 169824 211965 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 235 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5993609.58782 2095669.95083 37.7339436200957 -122.46450832802 (37.7339436200957, -122.46450832802)
160798 160798 211948 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 260 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5993578.5017099995 2095695.99509 37.7340133391286 -122.464617691865 (37.7340133391286, -122.464617691865)
137803 137803 211947 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 260 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5993589.28619 2095724.1316400003 37.734091216839 -122.46458244924801 (37.734091216839, -122.464582449248)
164551 164551 211966 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 225 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993629.46531 2095723.64247 37.7340921898878 -122.464443503075 (37.7340921898878, -122.464443503075)
157521 157521 211967 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 225 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5993642.2418 2095767.1947700002 37.734212510202 -122.46440249217599 (37.734212510202, -122.464402492176)
55510 55510 211946 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 230 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 4ft   5993605.73542 2095779.3177099999 37.7342436923742 -122.464529585292 (37.7342436923742, -122.464529585292)
60800 60800 211968 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 201 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993650.102080001 2095813.5177 37.734340154581105 -122.464378679032 (37.7343401545811, -122.464378679032)
29977 29977 211945 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 230 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5993614.12325 2095821.8351 37.7343609181201 -122.464503672234 (37.7343609181201, -122.464503672234)
170625 170625 211969 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 201 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 4ft   5993654.5678 2095862.1977400002 37.734474075323 -122.46436677290701 (37.734474075323, -122.464366772907)
72329 72329 211944 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 220 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993616.150119999 2095875.53238 37.7345084743812 -122.46450056235099 (37.7345084743812, -122.464500562351)
167991 167991 211943 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 220 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 4ft   5993616.026959999 2095898.22508 37.7345707758092 -122.46450263530501 (37.7345707758092, -122.464502635305)
51893 51893 211942 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 210 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   5993613.96365 2095942.7531599998 37.7346929199321 -122.46451300089599 (37.7346929199321, -122.464513000896)
37684 37684 211970 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 191 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5993649.31716 2095976.62159 37.7347879521877 -122.46439323095899 (37.7347879521877, -122.464393230959)
32260 32260 212779 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 191 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5993643.90362 2096193.01161 37.735381793433596 -122.46442765343399 (37.7353817934336, -122.464427653434)
160699 160699 212774 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 266 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993765.239080001 2096323.8291200001 37.7357479793805 -122.464017648017 (37.7357479793805, -122.464017648017)
70373 70373 211915 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 170 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 8ft   5993555.44783 2096336.63357 37.7357710442905 -122.464743901813 (37.7357710442905, -122.464743901813)
50658 50658 212775 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 272 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5993713.17033 2096341.04582 37.735792251198795 -122.46419891805 (37.7357922511988, -122.46419891805)
62434 62434 212776 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 199 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5993673.47282 2096359.92225 37.7358417930475 -122.464337536855 (37.7358417930475, -122.464337536855)
165560 165560 211914 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 170 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993524.60983 2096380.31294 37.735889199014004 -122.46485369105801 (37.735889199014, -122.464853691058)
180311 180311 212777 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 199 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5993638.02225 2096379.09378 37.73589238982 -122.464461494027 (37.73589238982, -122.464461494027)
178084 178084 212778 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 199 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5993612.45397 2096391.53113 37.7359250657735 -122.464550795802 (37.7359250657735, -122.464550795802)
69435 69435 211913 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 170 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5993507.71848 2096402.1835599998 37.735948276383205 -122.46491367851802 (37.7359482763832, -122.464913678518)
68126 68126 211916 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 175 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   5993576.99611 2096411.8129 37.7359787103437 -122.464674859058 (37.7359787103437, -122.464674859058)
31603 31603 211912 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 160 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993474.36419 2096435.15771 37.73603689198271 -122.465031390792 (37.7360368919827, -122.465031390792)
188837 188837 211917 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 175 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5993542.1892099995 2096437.97139 37.7360485283247 -122.464797098516 (37.7360485283247, -122.464797098516)
161233 161233 211918 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 165 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993507.60683 2096459.2354700002 37.736104920292 -122.464918206608 (37.736104920292, -122.464918206608)
78133 78133 211911 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 160 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5993445.46093 2096461.8444599998 37.736108500497295 -122.46513325792 (37.7361085004973, -122.46513325792)
171517 171517 211919 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 165 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993483.83 2096480.59858 37.7361622071096 -122.465001963172 (37.7361622071096, -122.465001963172)
63098 63098 211910 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 160 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 8ft   5993413.89239 2096486.3053099997 37.7361738434551 -122.465244178503 (37.7361738434551, -122.465244178503)
38047 38047 211920 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 155 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993463.1611 2096494.07268 37.7361980118237 -122.465074401756 (37.7361980118237, -122.465074401756)
134452 134452 211921 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 155 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993447.08738 2096508.1020799999 37.736235606189105 -122.465130993427 (37.7362356061891, -122.465130993427)
30873 30873 211922 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 155 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993428.13683 2096525.45183 37.736282151484296 -122.465197772566 (37.7362821514843, -122.465197772566)
152332 152332 211909 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 140 San Anselmo Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5993350.12818 2096536.54419 37.736308109533795 -122.46546828414199 (37.7363081095338, -122.465468284142)
45462 45462 211908 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 140 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 8ft   5993318.47057 2096556.76908 37.7363618161472 -122.46557920562401 (37.7363618161472, -122.465579205624)
43749 43749 211923 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 135 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993369.75745 2096567.1017 37.736393144928 -122.465402637242 (37.736393144928, -122.465402637242)
52496 52496 211907 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 140 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 8ft   5993271.966130001 2096587.08569 37.736442375607794 -122.465742191567 (37.7364423756078, -122.465742191567)
159843 159843 211924 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 125 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   5993331.74703 2096596.5876799999 37.736471913839296 -122.46553619555701 (37.7364719138393, -122.465536195557)
177657 177657 211906 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 8ft   5993235.809830001 2096611.3169099998 37.736506822832204 -122.465868958209 (37.7365068228322, -122.465868958209)
58372 58372 211925 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 115 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5993291.36421 2096622.2118400002 37.73653994216279 -122.465677676 (37.7365399421628, -122.465677676)
34872 34872 211905 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 8ft   5993202.216519999 2096632.8865099999 37.7365641096345 -122.465986670445 (37.7365641096345, -122.465986670445)
186423 186423 211926 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 115 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 8ft   5993257.7161 2096641.17439 37.7365900676864 -122.465795388244 (37.7365900676864, -122.465795388244)
41907 41907 211927 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 145 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993219.3101 2096667.4089099998 37.736659885632704 -122.46593007882299 (37.7366598856327, -122.465930078823)
39021 39021 211904 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 80 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 8ft   5993117.507999999 2096685.0409 37.7367024253714 -122.466283330728 (37.7367024253714, -122.466283330728)
157458 157458 211903 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 80 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 8ft   5993075.96143 2096709.0282700001 37.7367658914278 -122.466428716926 (37.7367658914278, -122.466428716926)
59427 59427 211882 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 99 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   5993133.46797 2096720.62207 37.7368010432217 -122.466230735658 (37.7368010432217, -122.466230735658)
41734 41734 211902 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 60 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 8ft   5993032.3976 2096733.05843 37.7368293583846 -122.466581080979 (37.7368293583846, -122.466581080979)
166996 166996 211883 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 99 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 8ft   5993091.26879 2096743.1724900003 37.73686052618039 -122.466378273942 (37.7368605261804, -122.466378273942)
162957 162957 211901 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 60 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 8ft   5992985.1351 2096757.1660799999 37.736892824454706 -122.466746238754 (37.7368928244547, -122.466746238754)
132455 132455 211884 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 75 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 8ft   5993049.1481800005 2096769.47059 37.736930303678996 -122.466525813128 (37.736930303679, -122.466525813128)
175727 175727 211900 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 50 San Anselmo Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5992945.19275 2096777.43519 37.736946173117104 -122.466885809037 (37.7369461731171, -122.466885809037)
42580 42580 211899 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 50 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   5992903.15569 2096794.06334 37.7369894035426 -122.46703235718 (37.7369894035426, -122.46703235718)
71774 71774 211885 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 69 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 8ft   5993003.60348 2096792.0914599998 37.7369897866347 -122.466684923885 (37.7369897866347, -122.466684923885)
35875 35875 211898 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 50 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   5992872.84504 2096808.4352799999 37.7370271156957 -122.46713819838001 (37.7370271156957, -122.46713819838)
46669 46669 211886 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 63 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5992960.04473 2096809.6715400002 37.7370355432472 -122.4668368023 (37.7370355432472, -122.4668368023)
174624 174624 211887 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 55 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5992915.72841 2096831.01688 37.737091594397604 -122.46699157379801 (37.7370915943976, -122.466991573798)
184144 184144 211897 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 44 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 8ft   5992779.12527 2096846.9196799998 37.737127373917 -122.46746502461201 (37.737127373917, -122.467465024612)
173842 173842 211888 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 45 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   5992853.918769999 2096856.0627 37.737156796137704 -122.46720709635001 (37.7371567961377, -122.46720709635)
173755 173755 211896 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 44 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 8ft   5992722.6294 2096863.85213 37.7371706043268 -122.467661585835 (37.7371706043268, -122.467661585835)
48496 48496 211895 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 42 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   5992673.51698 2096879.9592900001 37.737211994721704 -122.46783255953599 (37.7372119947217, -122.467832559536)
165735 165735 211889 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 39 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   5992793.76457 2096880.24095 37.737219710925004 -122.467416832647 (37.737219710925, -122.467416832647)
25890 25890 211894 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 42 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 8ft   5992633.05576 2096891.53005 37.73724142864779 -122.467973292645 (37.7372414286478, -122.467973292645)
42112 42112 211890 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 33 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   5992746.48615 2096899.9823599998 37.737271186301705 -122.467581729613 (37.7372711863017, -122.467581729613)
55526 55526 211891 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 25 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 8ft   5992707.7708 2096909.12858 37.73729406415679 -122.467716250229 (37.7372940641568, -122.467716250229)

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