sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1271 19821 3 140 100 STAIRWAY25 5 1 1 2     24 10ST            
6661 19920 3 140 100 STAIRWAY36 -2 1 1 2     6 3X3            
8239 19878 3 140 100 STAIRWAY33 10 1 1 2     12 25ST            
9803 19944 3 140 100 STAIRWAY39 1 1 1 2     6 25ST            
10529 20302 3 140 50X Sunset Blvd 4 1 1 2     12 60            
11072 19946 3 140 100 STAIRWAY39 3 1 1 2     6 25ST            
11626 19961 3 140 100 STAIRWAY41 19 1 1 2     12 25ST            
12402 19975 3 140 100 STAIRWAY45 2 1 1 2     3 30ST            
12733 19954 3 140 100 STAIRWAY39 11 1 1 2     6 25ST            
12756 19777 3 140 100 STAIRWAY18 3 1 1 2     6 50ST            
13663 19874 3 140 100 STAIRWAY33 6 1 1 2     12 25ST            
14132 19895 3 140 100 STAIRWAY33 27 1 1 2     6 25ST            
15605 19771 3 140 100 STAIRWAY17 1 1 1 2     12 50ST            
15986 19773 3 140 100 STAIRWAY17 3 1 1 2     12 20ST            
115717 30311 1 140 860 41st Ave 1 1 1 1         Permit Number 9 5983275.48572939 2109941.19024403 37.7725273211727 -122.50129116256599 (37.7725273211727, -122.501291162566)
121565 63206 1 140 3641 Clement St 1 1 1 1 1 12/18/1986 12:00:00 AM     Permit Number 23748 5984253.92200128 2113128.61080648 37.7813364679992 -122.498142145884 (37.7813364679992, -122.498142145884)
120126 63217 1 140 3621 Clement St 1 1 1 1 1 12/18/1986 12:00:00 AM     Permit Number 23761 5984312.74399006 2113130.81658791 37.78134597315321 -122.497938816629 (37.7813459731532, -122.497938816629)
82454 63210 1 140 3601 Clement St 1 1 1 1 1 12/18/1986 12:00:00 AM     Permit Number 23753 5984371.56597884 2113133.02236934 37.7813554779566 -122.497735487323 (37.7813554779566, -122.497735487323)
57978 71993 2 140 3449 Clement St 1 1 1 1 1 11/22/1986 12:00:00 AM 20     5984766.04316 2113148.2827 37.7814204950816 -122.496371935666 (37.7814204950816, -122.496371935666)
69730 186367 2 140 1801 Sunset Blvd 34 9 1 1     5 Width 0ft   5984825.2316 2102541.2113 37.7522999403759 -122.49538466495501 (37.7522999403759, -122.495384664955)
41839 186118 2 140 1700 Sunset Blvd 3 9 1 1     5 Width 0ft   5984966.576 2103035.9667 37.753666677492106 -122.49493235748999 (37.7536666774921, -122.49493235749)
137682 186270 2 140 1800 Sunset Blvd 8 9 1 1     10 Width 0ft   5984992.9477 2102426.3669 37.7519944279313 -122.49479621795 (37.7519944279313, -122.49479621795)
163249 185019 2 140 2701 Sunset Blvd 45 9 1 1     7 Width 0ft   5985029.339 2096373.5559999999 37.735377177897504 -122.494224278603 (37.7353771778975, -122.494224278603)
111114 21436 3 140 2692X Sunset Blvd 33 1 1 2     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054)
114506 21403 3 140 2692X Sunset Blvd 5 1 1 2     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054)
124593 21441 3 140 2692X Sunset Blvd 36 1 1 2     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054)
141252 21440 3 140 2692X Sunset Blvd 35 1 1 2     3 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054)
133168 185643 2 140 2100 Sunset Blvd 23 9 1 1     4 Width 0ft   5985040.1399 2100443.7841 37.7465535598153 -122.494486886414 (37.7465535598153, -122.494486886414)
72017 185642 2 140 2100 Sunset Blvd 22 9 1 1     4 Width 0ft   5985069.1522 2100447.6812 37.7465659581193 -122.494386853704 (37.7465659581193, -122.494386853704)
147482 120027 2 140 5250 Fulton St 2 1 1 1     12 Width 2ft   5987077.12189 2109838.60933 37.7724681813772 -122.488133553564 (37.7724681813772, -122.488133553564)
141918 97334 2 140 211 27th Ave 1 1 1 1       3x3   5987387.3 2114536.2 37.785384526712896 -122.48740575699101 (37.7853845267129, -122.487405756991)
93125 12858 1 140 2455 Lake St 1 1 1 1     16 3X3   5987787.46088 2114620.72752 37.7856399434951 -122.486027545007 (37.7856399434951, -122.486027545007)
62078 120360 2 140 2420 Lake St 2 9 1 1     9 Width 8ft   5987898.73747 2114688.5608599996 37.785832678759796 -122.48564754506 (37.7858326787598, -122.48564754506)
119393 12836 3 140 2255 Lake St 1 1 1 2     60 3x3   5988409.73159 2114642.3017599997 37.7857354248176 -122.483876276617 (37.7857354248176, -122.483876276617)
188788 120393 2 140 735 24th Ave 6 9 1 1     15     5988458.36945 2110846.11582 37.7753149980476 -122.48342961272499 (37.7753149980476, -122.483429612725)
32363 120392 2 140 735 24th Ave 5 9 1 1     11     5988458.4501 2110868.62788 37.775376814580895 -122.48343098442899 (37.7753768145809, -122.483430984429)
33575 120395 2 140 735 24th Ave 8 9 1 1     10     5988459.668880001 2110795.1356099998 37.7751750962322 -122.48342137966499 (37.7751750962322, -122.483421379665)
118783 12824 1 140 2201 Lake St 2 1 1 1     18 5   5988584.5219 2114647.3917900003 37.785759574315705 -122.48327193233 (37.7857595743157, -122.48327193233)
46202 182140 2 140 1414 24th Ave 1 1 1 1     24 Width 0ft   5988688.757999999 2105677.7715 37.7611375509737 -122.482253913011 (37.7611375509737, -122.482253913011)
141389 61500 1 140 155 20th Ave 1 1 1 1 1 08/27/1984 12:00:00 AM     Permit Number 21453 5989580.98367675 2114335.37160458 37.784960794856 -122.47980165523799 (37.784960794856, -122.479801655238)
121421 61492 1 140 171 20th Ave 1 1 1 1 1 07/19/1984 12:00:00 AM     Permit Number 21441 5989584.76357215 2114231.48161607 37.7846757617561 -122.479780973493 (37.7846757617561, -122.479780973493)
95854 106400 2 140 100 20th Ave 1 1 1 1     18 4x4   5989617.86074 2114578.87225 37.7856315213945 -122.479691897092 (37.7856315213945, -122.479691897092)
137956 72077 2 140 140 20th Ave 3 1 1 1 1 07/14/1984 12:00:00 AM 12     5989623.30395 2114484.58501 37.785372951377894 -122.479666163956 (37.7853729513779, -122.479666163956)
180699 74002 2 140 140 20th Ave 2 1 1 1 1 07/14/1984 12:00:00 AM 7     5989624.30976 2114465.1650799997 37.785319688143396 -122.47966126275 (37.7853196881434, -122.47966126275)
83780 74217 2 140 140 20th Ave 1 1 1 1 1 07/14/1984 12:00:00 AM 10     5989626.45991 2114449.60046 37.785277076979796 -122.47965268471701 (37.7852770769798, -122.479652684717)
109387 65122 1 140 328 20th Ave 1 1 1 1 1 07/24/1989 12:00:00 AM     Permit Number 27092 5989675.82756959 2113141.97698014 37.7816895771658 -122.47938619127399 (37.7816895771658, -122.479386191274)
180800 181699 2 140 1807 Lincoln Way 2 1 1 1     12 Width 0ft   5990039.1294 2107177.6156 37.765334173056104 -122.477693245166 (37.7653341730561, -122.477693245166)
123928 181700 2 140 1805 Lincoln Way 3 1 1 1     9 Width 0ft   5990060.5745 2107178.3815 37.765337520509895 -122.477619128372 (37.7653375205099, -122.477619128372)
138019 181321 2 140 1831 Lincoln Way 4 1 1 1     10 Width 0ft   5990078.1902 2107177.6156 37.7653364397928 -122.47755814445699 (37.7653364397928, -122.477558144457)
49231 114226 6 140 99x FONT BLVD 2 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
80545 114228 6 140 99x FONT BLVD 4 2 1 1     7     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
86013 114235 6 140 99x FONT BLVD 11 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105010 114230 6 140 99x FONT BLVD 6 2 1 1     30     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105541 114227 6 140 99x FONT BLVD 3 2 1 1     16     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
112189 114231 6 140 99x FONT BLVD 7 2 1 1     10     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
117729 114237 6 140 99x FONT BLVD 13 2 1 1     14     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
125709 114234 6 140 99x FONT BLVD 10 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128194 114232 6 140 99x FONT BLVD 8 2 1 1     15     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128290 114229 6 140 99x FONT BLVD 5 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
138891 114238 6 140 99x FONT BLVD 14 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
139193 114233 6 140 99x FONT BLVD 9 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
139478 114236 6 140 99x FONT BLVD 12 2 1 1     22     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
10024 173625 2 140 1200X Junipero Serra Blvd 47 9 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
89097 114144 6 140 1200x JUNIPERO SERRA BLVD 1 7 1 1     10     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
118401 114145 6 140 1200x JUNIPERO SERRA BLVD 2 7 1 1     6     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
140509 114146 6 140 1200x JUNIPERO SERRA BLVD 3 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
125954 114239 6 140 1300x JUNIPERO SERRA BLVD 1 2 1 1     28     5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
90632 19347 3 140 600 Shields St 1 1 1 2     12 3X3   5992459.1729484005 2089876.0608299 37.7179686413438 -122.46806431972901 (37.7179686413438, -122.468064319729)
137750 53938 1 140 178 09th Ave 1 1 1 1   03/27/1972 12:00:00 AM 13   Permit Number 9652 5993071.23757 2114298.66075 37.7850621436327 -122.467723926434 (37.7850621436327, -122.467723926434)
163265 122957 2 140 178 09th Ave 2 1 1 1     7 Width 3ft   5993071.353730001 2114313.86484 37.7851038966064 -122.46772463071301 (37.7851038966064, -122.467724630713)
88830 56310 1 140 178 09th Ave 1 1 1 1 1 11/21/1984 12:00:00 AM     Permit Number 21650 5993077.11990526 2114307.36148956 37.7850863731263 -122.467704208587 (37.7850863731263, -122.467704208587)
109120 30340 1 140 175 Granville Way 1 1 1 1   02/15/1956 12:00:00 AM     Permit Number 26 5994414.04695782 2098601.44324242 37.7420391129783 -122.461939590962 (37.7420391129783, -122.461939590962)
125223 65914 1 140 431 Hugo St 1 1 1 1 1 06/04/1990 12:00:00 AM     Permit Number 28924 5994447.75768828 2106990.5338514 37.7650753550186 -122.462431373492 (37.7650753550186, -122.462431373492)
95422 65918 1 140 1346 05th Ave 1 1 1 1 1 06/04/1990 12:00:00 AM     Permit Number 28933 5994594.09113824 2106359.56698751 37.763351309716604 -122.46187948930901 (37.7633513097166, -122.461879489309)
104931 98197 2 140 830 Joost Ave 1 5 1 1       6x24   5996641.8 2095053.2 37.732424500806204 -122.45398057585 (37.7324245008062, -122.45398057585)
156487 124766 2 140 138 Locust St 5 1 1 1     8 Width 3ft   5997561.1508599995 2115901.7779200003 37.7897221032522 -122.452306040493 (37.7897221032522, -122.452306040493)
76647 124765 2 140 138 Locust St 4 1 1 1     13 Width 3ft   5997565.1935 2115884.13609 37.7896738950858 -122.45229077990601 (37.7896738950858, -122.452290779906)
187436 124764 2 140 138 Locust St 3 1 1 1     16 Width 3ft   5997570.27212 2115851.1781 37.7895836921739 -122.45227082935 (37.7895836921739, -122.45227082935)
138273 34992 1 140 829 Clayton St 1 1 1 1 1 06/17/2000 12:00:00 AM     Permit Number 38570 5998631.01806421 2107405.55103252 37.7664548933778 -122.447992448577 (37.7664548933778, -122.447992448577)
59119 124763 2 140 55 Presidio Ave 1 1 1 1     10 Width 3ft   5998922.83859 2116354.0427200003 37.7910418169751 -122.447627323869 (37.7910418169751, -122.447627323869)
158344 116890 2 140 799X Marina Blvd 3 1 1 1     10 3x3   5999183.52163 2121463.27937 37.8050853080999 -122.447093221893 (37.8050853080999, -122.447093221893)
153965 250152 2 140 2501 Lyon St 7 7 1 1     9     5999205.942969999 2117400.85973 37.7939322749156 -122.44672314997 (37.7939322749156, -122.44672314997)
116604 40632 1 140 1385 Masonic Ave 1 1 1 1   11/24/1999 12:00:00 AM     Permit Number 41908 5999539.52102625 2107847.36223217 37.7677198855431 -122.44488187524901 (37.7677198855431, -122.444881875249)
125901 96094 2 140 1524 Masonic Ave 1 1 1 1       3x3   5999743.8 2107236.2 37.766053443333796 -122.444131380779 (37.7660534433338, -122.444131380779)
174983 142164 2 140 490 Baker St 6 1 1 1     22 Width 0ft   6000672.4904 2110619.9435 37.775397291640104 -122.44116203008998 (37.7753972916401, -122.44116203009)
2932 142166 1 140 1477 GROVE ST 2 1 1 1     12 Width 0ft   6000715.4928 2110652.1954 37.7754882965725 -122.44101558938699 (37.7754882965725, -122.441015589387)
104319 100365 1 140 450X Baker St 6 1 1 1         Permit Number 769344 6000745.0 2110655.0 37.7754976778855 -122.44091371844 (37.7754976778855, -122.44091371844)
82102 101131 1 140 1477 Grove St 2 1 1 1       3x3   6000788.3 2110635.6 37.775446876390205 -122.44076254186001 (37.7754468763902, -122.44076254186)
139830 101135 1 140 1477 Grove St 6 1 1 1       3x3   6000788.3 2110635.6 37.775446876390205 -122.44076254186001 (37.7754468763902, -122.44076254186)
169053 99111 2 140 2105 Divisadero St 1 1 1 1     32     6000887.0683699995 2115666.65288 37.7892664842201 -122.44078184902399 (37.7892664842201, -122.440781849024)
170285 99113 2 140 2105 Divisadero St 2 1 1 1     31     6000888.787269999 2115636.76287 37.7891845118984 -122.440773756903 (37.7891845118984, -122.440773756903)
130381 244488 2 140 1192 Page St 3 1 1 1     19 Width 0ft   6000913.4497 2109333.087 37.7718776296576 -122.44023619364401 (37.7718776296576, -122.440236193644)
113489 34853 1 140 85 Capistrano Ave 1 1 1 1 1 08/01/1997 12:00:00 AM     Permit Number 38476 6001445.41488356 2093713.29123004 37.7290196763486 -122.437277475077 (37.7290196763486, -122.437277475077)
85992 62564 1 140 401 Divisadero St 1 1 1 1 1 02/08/1986 12:00:00 AM     Permit Number 22765 6001708.19271751 2109769.06982879 37.7731199456311 -122.437518353384 (37.7731199456311, -122.437518353384)
121534 62547 1 140 339 Divisadero St 1 1 1 1 1 02/08/1986 12:00:00 AM     Permit Number 22742 6001725.06048849 2109561.60697562 37.772551263359 -122.43744514665 (37.772551263359, -122.43744514665)
108904 62556 1 140 1009 Page St 4 1 1 1 1 02/08/1986 12:00:00 AM     Permit Number 22755 6001742.0 2109408.0 37.7721304598957 -122.437375549988 (37.7721304598957, -122.437375549988)
89303 64732 1 140 259 Divisadero St 1 1 1 1 1 11/28/1988 12:00:00 AM     Permit Number 25691 6001783.83117373 2109148.55885484 37.77142047705029 -122.43721227336701 (37.7714204770503, -122.437212273367)
104951 62548 1 140 364 Divisadero St 1 1 1 1 1 02/08/1986 12:00:00 AM     Permit Number 22743 6001791.89658849 2109658.78296356 37.7728218839519 -122.437220913321 (37.7728218839519, -122.437220913321)
91149 62544 1 140 251 Divisadero St 1 1 1 1 1 02/08/1986 12:00:00 AM     Permit Number 22739 6001803.31467833 2109086.42479932 37.771250979895704 -122.43714042967301 (37.7712509798957, -122.437140429673)
100519 62546 1 140 324 Divisadero St 1 1 1 1 1 02/08/1986 12:00:00 AM     Permit Number 22741 6001810.43023006 2109526.13327918 37.7724587144958 -122.43714730421101 (37.7724587144958, -122.437147304211)
76761 247415 2 140 995 Page St 1 1 1 1     10 Width 0ft   6001860.534 2109422.6502 37.772177423645296 -122.436966580829 (37.7721774236453, -122.436966580829)
Powered by Datasette · Query took 4.107ms · Data source: data.sfgov.org