sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
18 96369 2 11 168 Cervantes Blvd 1 1 1 1   08/09/2011 12:00:00 AM 24 3x3 Permit Number 767919 6001162.44444 2121276.45677 37.8046852096195 -122.44023153767799 (37.8046852096195, -122.440231537678)
19 182260 2 12 1471 28th Ave 1 1 1 1     5 3x3   5987398.0 2105276.0 37.759959232607606 -122.486688530832 (37.7599592326076, -122.486688530832)
49 251186 2 19 3042 Steiner St 1 5 1 1       3x3   6002010.0 2118654.0 37.7975328515761 -122.437110618013 (37.7975328515761, -122.437110618013)
53 251187 2 25 1 Baker St 2 1 1 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
68 251188 2 25 1 Baker St 5 1 1 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
71 251206 2 18 270 Trumbull St 1 1 1 1       3x3   6005145.0 2094297.0 37.7308320294825 -122.424529217878 (37.7308320294825, -122.424529217878)
88 251208 2 2 4115 Kirkham St 1 1 1 1       3x3   5982071.0 2104840.0 37.758450113202294 -122.505079418654 (37.7584501132023, -122.505079418654)
145 111561 2 49 1498x Kansas St 2 1 1 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 779654 6011715.78319 2101470.3886700002 37.7508975116216 -122.40231700873699 (37.7508975116216, -122.402317008737)
162 251231 2 3 164 Serrano Dr 1 1 1 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
166 251230 2 55 99x Ogden Ave 2 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
167 251232 2 55 99x Ogden Ave 1 1 1 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
185 251243 2 58 299x Chapman St 1 1 1 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
208 100305 2 61 3701 Buchanan St 2 1 1 1     6 3x3   6003064.411830001 2121045.8637900003 37.804160163827206 -122.433633107497 (37.8041601638272, -122.433633107497)
241 251257 2 65 1748x Eucalyptus Dr 1 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
245 251255 2 17 4089x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
249 251254 2 66 330 09th Ave 1 12 1 6       3x3   5993109.0 2113253.0 37.782193225103605 -122.467517213871 (37.7821932251036, -122.467517213871)
251 251258 2 65 1748x Eucalyptus Dr 2 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
253 251256 2 67 4091x Alemany Blvd 1 1 1 1       3x3   5991686.0 2086783.0 37.70943116445179 -122.470511668938 (37.7094311644518, -122.470511668938)
258 251259 2 69 1050x Sacramento St 2 1 1 1       3x3   6009753.0 2116795.0 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148)
266 173827 2 17 1200 04th St 12 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
274 173825 2 17 1200 04th St 10 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
276 173808 2 17 1201 04th St 3 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
282 173829 2 17 1200 04th St 14 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
283 173821 2 17 1200 04th St 6 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
287 173824 2 17 1200 04th St 9 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
289 173826 2 17 1200 04th St 11 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
290 173809 2 17 1201 04th St 4 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
298 173822 2 17 1200 04th St 7 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
301 173819 2 17 1200 04th St 4 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
302 187663 2 17 1155 04th St 5 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779411 6015039.0 2109715.0 37.77372037595529 -122.391401215397 (37.7737203759553, -122.391401215397)
304 173811 2 17 1201 04th St 6 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
306 173816 2 17 1200 04th St 1 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
307 173828 2 17 1200 04th St 13 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
311 173810 2 17 1201 04th St 5 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
314 173820 2 17 1200 04th St 5 1 1 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
328 251272 2 74 1301X 07th Ave 1 1 1 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
339 251273 2 74 1301X 07th Ave 2 1 1 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
379 122497 2 11 31X 08th St 1 1 1 1     4 3x3   6008445.21835 2111601.2724900004 37.7785314648928 -122.414343702699 (37.7785314648928, -122.414343702699)
423 109554 2 15 300x Van Ness Ave 10 1 1 1     4 3x3   6006839.87541 2111919.81075 37.7793157843461 -122.41991981597201 (37.7793157843461, -122.419919815972)
427 251307 2 17 200 Cashmere St 1 13 1 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
433 251301 2 36 100 Whitney Young Cir 2 13 1 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
443 251293 2 54 3789 Market St 1 5 2 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
448 224849 2 32 4 Rotteck St 1 1 1 1     18 3x3 Permit Number 779889 6003244.1353400005 2095137.54828 37.733032453088704 -122.431160782146 (37.7330324530887, -122.431160782146)
454 251309 2 44 2111 15th Ave 2 1 1 1       3x3   5991606.081259999 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742)
462 187628 2 32 2 Rotteck St 1 1 1 1       3x3 Permit Number 779889 6003236.0 2095183.0 37.7331567921798 -122.431192151262 (37.7331567921798, -122.431192151262)
474 251300 2 36 100 Whitney Young Cir 1 13 1 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
486 98534 2 32 1805X Baker St 3 1 1 1     10 3x3 Permit Number 779899 5999986.755609999 2115164.0145 37.787835056676705 -122.443860686142 (37.7878350566767, -122.443860686142)
511 251164 2 90 1215 Fairfax Ave 10 1 1 1   04/10/2017 01:46:00 PM 3 3x3   6017471.0 2096747.0 37.738247630240295 -122.382086185189 (37.7382476302403, -122.382086185189)
514 251312 2 54 1499 Noe St 1 1 1 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
541 251317 2 49 399X 12th St 3 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
566 243384 2 21 88 Montcalm St 1 1 1 1   04/11/2017 12:00:00 AM 3 3x3   6010512.94245 2100000.19671 37.746793468955204 -122.406372986245 (37.7467934689552, -122.406372986245)
588 251328 2 17 95x Tompkins Ave 2 1 1 1       3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
592 251331 2 32 2232 Webster St 2 1 1 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
599 251330 2 32 2232 Webster St 1 1 1 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
635 251315 2 49 399X 12th St 5 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
640 251141 2 101 450 10th St 11 1 1 1   04/13/2017 12:00:00 AM 3 3x3 Permit Number 779594 6009467.0 2108781.0 37.7708450017609 -122.410609744119 (37.7708450017609, -122.410609744119)
644 251319 2 49 399X 12th St 1 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
645 251316 2 49 399X 12th St 4 1 1 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
651 251359 2 2 4050 Geary Blvd 2 1 1 1       3x3   5994421.0 2112898.0 37.7812941506761 -122.462952553035 (37.7812941506761, -122.462952553035)
654 122328 2 1 3015 Turk Blvd 1 1 1 1   04/14/2017 12:00:00 AM 3 3x3 Permit Number 779630 5996535.0 2111432.0 37.7773904414434 -122.455533202662 (37.7773904414434, -122.455533202662)
667 251356 2 54 519 22nd Ave 1 1 1 1       3x3   5989039.0 2111772.0 37.777890994652296 -122.481488924787 (37.7778909946523, -122.481488924787)
697 251362 2 105 1300X Stanyan St 1 14 1 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
717 106656 2 1 700X 20TH AVE 2 1 1 1   04/17/2017 12:00:00 AM 3 3x3 Permit Number 779658 5989753.9107099995 2110247.9151 37.773747820615704 -122.47890432357 (37.7737478206157, -122.47890432357)
720 104746 2 1 700X 20th Ave 3 1 1 1   04/17/2017 12:00:00 AM 3 3x3 Permit Number 779658 5989767.16587 2110527.4876599996 37.774516219561704 -122.478878924469 (37.7745162195617, -122.478878924469)
769 110848 2 5 2668 Vallejo St 2 1 1 1     3 3x3 Permit Number 778643 6000804.34505 2117582.1485 37.7945212238167 -122.441205550194 (37.7945212238167, -122.441205550194)
780 251383 2 113 49x Milan Ter 1 13 1 1       3x3   5997587.0 2087495.0 37.711725600519706 -122.450168218052 (37.7117256005197, -122.450168218052)
782 251385 2 47 138x Gladeview Way 2 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
784 251384 2 47 138x Gladeview Way 1 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
818 251389 2 3 202x Mangels Ave 1 9 1 1       3x3   5999774.0 2095231.0 37.7330917931436 -122.44316462438499 (37.7330917931436, -122.443164624385)
855 251398 2 94 299 Townsend St 3 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
858 251395 2 118 2101 26th St   1 1 1       3x3   6012226.0 2101445.0 37.750856267744496 -122.400550836744 (37.7508562677445, -122.400550836744)
859 251396 2 94 299 Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
861 109545 2 15 300x Van Ness Ave 1 1 1 1     4 3x3   6006870.4118800005 2111707.44564 37.778734401395205 -122.419799104459 (37.7787344013952, -122.419799104459)
882 187661 2 17 1155 04th St 3 1 1 1   04/21/2017 12:00:00 AM 3 3x3 Permit Number 779411 6015039.0 2109715.0 37.77372037595529 -122.391401215397 (37.7737203759553, -122.391401215397)
883 251306 2 1 1 Cashmere St 5 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
885 251305 2 1 1 Cashmere St 4 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
887 251303 2 103 1 Cashmere St 2 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
896 251302 2 103 1 Cashmere St 1 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
913 107355 2 26 2001 Grant Ave 3 1 1 1     14 3x3   6010310.1611 2121354.7321 37.8054166971664 -122.40858034027201 (37.8054166971664, -122.408580340272)
934 251409 2 3 95x Andover St 1 14 1 1       3x3   6007642.0 2098274.0 37.741892697320296 -122.41617822056101 (37.7418926973203, -122.416178220561)
938 251414 2 29 10x Jones St 2 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
947 251413 2 29 10x Jones St 1 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
955 251402 2 106 190 University St 1 1 1 1       3x3   6007981.0 2093052.0 37.7275732783897 -122.41463660892599 (37.7275732783897, -122.414636608926)
961 251408 2 47 75 Christmas Tree Point Rd 1 1 1 1       3x3   5998776.0 2103023.0 37.75442978774979 -122.447175546291 (37.7544297877498, -122.447175546291)
963 251419 2 50 39 Jones St 2 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
967 251416 2 29 10x Jones St 4 1 1 1       3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
970 251418 2 50 39 Jones St 1 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
971 251415 2 29 10x Jones St 3 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
999 251422 2 47 480x De Long St   7 1 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
1029 251428 2 47 5030 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1034 251427 2 3 5028 Diamond Heights Blvd 1 9 1 1       3x3   5999606.0 2100130.0 37.7465337016449 -122.44409733772801 (37.7465337016449, -122.444097337728)
1091 110107 2 28 4130 MORAGA ST 1 1 1 1   01/15/2016 12:00:00 AM 15 3x3 Permit Number 774958 5981430.4 2103553.9 37.7548811373619 -122.507199448976 (37.7548811373619, -122.507199448976)
1148 251463 2 136 3440 16th St 2 5 1 1       3x3   6003947.0 2106622.0 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663)
1156 251462 2 136 3440 16th St 1 5 1 1       3x3   6003947.0 2106622.0 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663)
1157 251464 2 136 3440 16th St 3 5 1 1       3x3   6003947.0 2106622.0 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663)
1162 251437 2 28 3377 Market St 1 5 1 1       3x3   5999965.0 2104239.0 37.7578364910366 -122.443151017453 (37.7578364910366, -122.443151017453)
1166 251466 2 46 129 Hyde St 2 1 1 1       3x3   6008072.0 2112894.0 37.782060012266896 -122.415726368353 (37.7820600122669, -122.415726368353)
1178 251465 2 46 129 Hyde St 1 1 1 1       3x3   6008072.0 2112894.0 37.782060012266896 -122.415726368353 (37.7820600122669, -122.415726368353)
1188 251477 2 110 1590 Lyon St 1 1 1 1       3x3   5999686.0 2114300.0 37.785445538345996 -122.444839109459 (37.785445538346, -122.444839109459)
1217 113450 2 32 21X Leroy Pl 1 1 1 1     6 3x3   6008324.74095 2116562.6798400003 37.7921475208351 -122.415111760598 (37.7921475208351, -122.415111760598)
Powered by Datasette · Query took 2.498ms · Data source: data.sfgov.org