Street_Tree_List

Data source: data.sfgov.org

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

✎ 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
55279 55279 250816 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 66 Sea View Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5986143.35026 2114166.31593 37.7842963089792 -122.491682151215 (37.7842963089792, -122.491682151215)
34041 34041 250815 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 66 Sea View Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5986156.52823 2114164.57331 37.784292294401 -122.491636432381 (37.784292294401, -122.491636432381)
73953 73953 250814 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 66 Sea View Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5986166.78643 2114163.6239 37.7842902870978 -122.491600873197 (37.7842902870978, -122.491600873197)
76263 76263 119383 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 340 31st Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5986240.80118 2113637.97739 37.7828513382696 -122.491306111206 (37.7828513382696, -122.491306111206)
29612 29612 119384 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 340 31st Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5986242.52312 2113595.8501 37.78273576945529 -122.491297052566 (37.7827357694553, -122.491297052566)
31024 31024 119385 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 340 31st Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5986245.2794 2113549.60335 37.7826089502225 -122.491284112348 (37.7826089502225, -122.491284112348)
179695 179695 250968 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6542 California St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5986266.0021 2113938.0378400004 37.783676690482004 -122.49124101845699 (37.783676690482, -122.491241018457)
134246 134246 250967 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6542 California St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5986305.7572 2113938.87572 37.78368131388 -122.491103544499 (37.78368131388, -122.491103544499)
42642 42642 250966 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6542 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5986349.34208 2113940.89483 37.7836894041789 -122.490952908074 (37.7836894041789, -122.490952908074)
46424 46424 250965 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6540 California St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5986394.617190001 2113942.87838 37.7836974953865 -122.490796421524 (37.7836974953865, -122.490796421524)
176105 176105 250964 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6540 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5986452.15501 2113945.02201 37.7837067422095 -122.490597522969 (37.7837067422095, -122.490597522969)
177211 177211 119571 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 341 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5986507.8802 2113640.35291 37.7828734631545 -122.49038231698 (37.7828734631545, -122.49038231698)
153513 153513 119572 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 341 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   5986508.67785 2113597.38194 37.7827555237835 -122.490376395298 (37.7827555237835, -122.490376395298)
42376 42376 119573 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 341 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5986510.27034 2113543.4852 37.782607631800396 -122.49036691985901 (37.7826076318004, -122.490366919859)
186717 186717 250963 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6538 California St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5986577.80338 2113949.50565 37.7837263914907 -122.490163163006 (37.7837263914907, -122.490163163006)
28618 28618 250962 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6538 California St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5986619.26657 2113951.14977 37.78373332707871 -122.490019838944 (37.7837333270787, -122.490019838944)
54635 54635 250961 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6538 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5986661.98827 2113952.34597 37.783739106117295 -122.489872127989 (37.7837391061173, -122.489872127989)
151747 151747 250960 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6536 California St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5986717.82713 2113954.10541 37.7837471973129 -122.489679078628 (37.7837471973129, -122.489679078628)
46812 46812 182458 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1500 31st Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5986548.9803 2104767.4719 37.758513422441204 -122.489587443554 (37.7585134224412, -122.489587443554)
171365 171365 250959 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6536 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5986752.106919999 2113955.90215 37.783754131992104 -122.489560617232 (37.7837541319921, -122.489560617232)
177485 177485 250958 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6534 California St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5986885.78325 2113960.21653 37.7837737812885 -122.489098470914 (37.7837737812885, -122.489098470914)
34856 34856 250957 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6534 California St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5986936.54247 2113961.66352 37.7837807168614 -122.488922971817 (37.7837807168614, -122.488922971817)
150117 150117 250956 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6534 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5986981.781690001 2113961.9646099997 37.7837841837271 -122.488766485305 (37.7837841837271, -122.488766485305)
173122 173122 250955 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6532 California St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5987034.671490001 2113964.2082700003 37.7837934305581 -122.488583673816 (37.7837934305581, -122.488583673816)
60783 60783 250954 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6532 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5987082.436980001 2113964.03529 37.7837957427146 -122.48841841257601 (37.7837957427146, -122.488418412576)
160139 160139 120037 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 854 28th Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   5987294.40591 2110207.04941 37.7734924883925 -122.487409025464 (37.7734924883925, -122.487409025464)
136723 136723 120036 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 854 28th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5987295.49688 2110185.40666 37.773433127092794 -122.487403661604 (37.7734331270928, -122.487403661604)
161768 161768 120035 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 854 28th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5987295.863059999 2110158.83782 37.773360197862104 -122.48740044295201 (37.7733601978621, -122.487400442952)
77128 77128 120034 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 854 28th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 2ft   5987296.86905 2110133.18169 37.7732898119884 -122.487395078202 (37.7732898119884, -122.487395078202)
28770 28770 120033 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 854 28th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5987298.51459 2110108.4388099997 37.7732219709389 -122.48738756829799 (37.7732219709389, -122.487387568298)
53487 53487 120032 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 854 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5987298.75417 2110090.52019 37.773172785402004 -122.487385423111 (37.773172785402, -122.487385423111)
160030 160030 120045 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 2ft   5987560.38952 2110240.5290900003 37.7735999222489 -122.48649141976401 (37.7735999222489, -122.486491419764)
70705 70705 120044 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5987560.8192300005 2110219.65608 37.77354263585371 -122.486488400522 (37.7735426358537, -122.486488400522)
58338 58338 120043 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 2ft   5987561.7468 2110191.3833 37.7734650607809 -122.48648311573 (37.7734650607809, -122.48648311573)
36515 36515 120042 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5987562.19522 2110171.37929 37.7734101615057 -122.48648009559601 (37.7734101615057, -122.486480095596)
177553 177553 120041 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5987564.26402 2110145.4730599998 37.7733391508378 -122.486471036988 (37.7733391508378, -122.486471036988)
154392 154392 120040 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 2ft   5987564.80136 2110119.38183 37.7732675429408 -122.486467262272 (37.7732675429408, -122.486467262272)
48425 48425 120039 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 2ft   5987565.05941 2110100.68571 37.7732162236667 -122.486464996708 (37.7732162236667, -122.486464996708)
24473 24473 250486 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 220 El Camino Del Mar 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5987923.25995 2115358.25633 37.7876728999176 -122.485611871313 (37.7876728999176, -122.485611871313)
27716 27716 250485 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 220 El Camino Del Mar 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5987961.74395 2115359.72592 37.7876791771886 -122.485478833689 (37.7876791771886, -122.485478833689)
155951 155951 250484 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 220 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5987976.085519999 2115359.42161 37.7876791771865 -122.485429192915 (37.7876791771865, -122.485429192915)
38373 38373 182584 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2445 26th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5988262.1936 2098677.2249 37.7418911015612 -122.483216039459 (37.7418911015612, -122.483216039459)
171551 171551 182583 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2445 26th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   5988262.8704 2098685.6854 37.7419143712566 -122.483214319349 (37.7419143712566, -122.483214319349)
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)
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)
189021 189021 182962 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2050 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5989686.5492 2098375.4265 37.741145229321496 -122.47826907299999 (37.7411452293215, -122.478269073)
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)
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)
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)
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)
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)
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)
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)
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)
147106 147106 211893 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 15 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5992652.52095 2096927.7879400002 37.7373421077603 -122.467908629578 (37.7373421077603, -122.467908629578)
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)
30878 30878 211892 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 15 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5992677.8722 2096919.75593 37.7373215177838 -122.46782039530399 (37.7373215177838, -122.467820395304)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
68811 68811 218165 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1414 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   5993003.55349 2097501.2373599997 37.7389369204953 -122.46673663039 (37.7389369204953, -122.46673663039)
164103 164103 218164 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1414 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   5993012.94318 2097510.0032599997 37.73896153134479 -122.466704802481 (37.7389615313448, -122.466704802481)
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)
43865 43865 218163 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1410 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 5ft   5993032.60064 2097530.3684400003 37.7390185834404 -122.466638316523 (37.7390185834404, -122.466638316523)
165078 165078 218162 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1410 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 5ft   5993045.99519 2097544.75383 37.739058855082 -122.466593050038 (37.739058855082, -122.466593050038)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
172919 172919 211931 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1960 09th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5993490.2742 2102262.7771900003 37.752038979730294 -122.465399584039 (37.7520389797303, -122.465399584039)
46338 46338 211930 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1960 09th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5993491.51146 2102216.31715 37.751911483734006 -122.46539193081699 (37.751911483734, -122.465391930817)
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)
57782 57782 211929 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1960 09th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993493.17539 2102180.3885 37.75181292883779 -122.46538356709401 (37.7518129288378, -122.465383567094)
37596 37596 211928 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1960 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5993496.8465599995 2102079.53468 37.7515362218261 -122.46536354639099 (37.7515362218261, -122.465363546391)
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)

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