sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
170029 197583 2 116 851 Indiana St 5 9 1 1     26 Width 8ft   6014993.182580001 2104474.00413 37.7593272043051 -122.39119328893801 (37.7593272043051, -122.391193288938)
169341 197582 2 116 851 Indiana St 3 1 1 1     31 Width 10ft   6014984.28202 2104444.32589 37.7592452203005 -122.39122199711399 (37.7592452203005, -122.391221997114)
149631 197584 2 116 851 Indiana St 6 1 1 1     29 Width 10ft   6014983.28625 2104495.6281 37.7593860298711 -122.391229027092 (37.7593860298711, -122.391229027092)
106132 97857 1 116 895 Indiana St 5 1 1 1           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978)
121387 97856 1 116 895 Indiana St 4 5 1 1           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978)
123802 97853 1 116 895 Indiana St 1 1 1 1           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978)
139938 97854 1 116 895 Indiana St 2 1 1 1           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978)
38099 200496 2 116 3239 Jennings St 3 1 1 1     7 Width 0ft   6013542.8885 2090062.874 37.7196766561509 -122.39519967454399 (37.7196766561509, -122.395199674544)
48209 136445 2 116 3 Broadway 11 9 1 1     20     6013392.00591 2118921.55061 37.79890788115829 -122.397744358119 (37.7989078811583, -122.397744358119)
131451 136444 2 116 3 Broadway 10 9 1 1     19     6013387.59339 2118931.12048 37.798933912018704 -122.397760298614 (37.7989339120187, -122.397760298614)
36375 136443 2 116 3 Broadway 9 9 1 1     18     6013384.0493 2118922.9353099996 37.7989112401317 -122.39777198798201 (37.7989112401317, -122.397771987982)
77228 136442 2 116 3 Broadway 8 9 1 1     16     6013378.377640001 2118933.3014 37.7989393870992 -122.397792341438 (37.7989393870992, -122.397792341438)
43998 136441 2 116 3 Broadway 7 9 1 1     14     6013371.772919999 2118938.4754 37.798953225861 -122.397815559237 (37.798953225861, -122.397815559237)
153291 136440 2 116 3 Broadway 6 9 1 1     19     6013367.06255 2118933.3720400003 37.7989389509345 -122.397831500623 (37.7989389509345, -122.397831500623)
50578 136439 2 116 3 Broadway 5 9 1 1     18     6013363.76971 2118922.4292 37.7989087211284 -122.397842127014 (37.7989087211284, -122.397842127014)
53755 136438 2 116 3 Broadway 4 9 1 1     16     6013355.98644 2118932.3733599996 37.798935591968004 -122.39786975780301 (37.798935591968, -122.397869757803)
183846 136437 2 116 3 Broadway 3 9 1 1     19     6013352.957 2118919.28443 37.798899484176204 -122.397879322098 (37.7988994841762, -122.397879322098)
152027 136436 2 116 3 Broadway 2 9 1 1     15     6013350.43599 2118931.2626099996 37.7989322330038 -122.397888886371 (37.7989322330038, -122.397888886371)
47961 136435 2 116 3 Broadway 1 9 1 1     18     6013344.909530001 2118921.0971 37.7989040131614 -122.39790729640801 (37.7989040131614, -122.397907296408)
76485 197585 3 116 900x Carolina St 75 3 1 2     27     6012517.30691 2102783.51804 37.7545477896502 -122.399637433715 (37.7545477896502, -122.399637433715)
88274 3774 3 116 1098 Carolina St 7 11 1 2     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.39983195341699 (37.754754478768, -122.399831953417)
157277 197589 2 116 1 Jack Balestreri Way 5 7 1 1     3     6012441.30894 2104748.70907 37.7599395365119 -122.40003825707 (37.7599395365119, -122.40003825707)
169778 197588 2 116 1 Jack Balestreri Way 4 7 1 1     9     6012433.89716 2104751.224 37.7599460287107 -122.400064067605 (37.7599460287107, -122.400064067605)
174597 197587 2 116 1 Jack Balestreri Way 3 7 1 1     12     6012433.76366 2104761.3607799998 37.7599738546281 -122.400065241211 (37.7599738546281, -122.400065241211)
57311 197586 2 116 1 Jack Balestreri Way 1 7 1 1     45 Width 10ft   6012374.628719999 2104733.59825 37.7598943275787 -122.400267811735 (37.7598943275787, -122.400267811735)
166697 136434 2 116 12 Greenwich St 5 2 1 1     18     6012298.4076 2120549.33954 37.8033164360554 -122.401643063984 (37.8033164360554, -122.401643063984)
60533 250200 2 116 203 Union St 1 17 1 1     33 Width 0ft   6011776.4013 2119745.07747 37.8010789857668 -122.403392881194 (37.8010789857668, -122.403392881194)
65961 250201 2 116 203 Union St 2 17 1 1     29 Width 0ft   6011763.02504 2119743.5219400004 37.8010739675505 -122.40343905958099 (37.8010739675505, -122.403439059581)
77818 108026 6 116 862 Kansas St   7 1 1         Permit Number 774734 6011570.0 2104296.0 37.758647879927395 -122.403019866682 (37.7586478799274, -122.403019866682)
29908 249959 2 116 273 Filbert St 1 7 1 1     23 Width 0ft   6011558.5565599995 2120064.53903 37.801943979781896 -122.40416921824301 (37.8019439797819, -122.404169218243)
187854 197590 2 116 200 Kansas St 9 9 1 1     33 Width 4ft   6011401.81383 2107103.92491 37.7663484192558 -122.403799114839 (37.7663484192558, -122.403799114839)
105545 54448 1 116 425 Vermont St 1 1 1 1   12/16/2015 12:00:00 AM   3x5 Permit Number 10233 6011220.56042251 2106374.73270267 37.764336094761 -122.40437470921499 (37.764336094761, -122.404374709215)
104001 197581 2 116 2101 17th St 1 7 1 1     35     6011118.65336 2106461.14792 37.7645676761706 -122.40473326313601 (37.7645676761706, -122.404733263136)
51336 197580 2 116 2151 17th St 1 7 1 1     23     6010976.50521 2106453.15639 37.764537787215 -122.405224355037 (37.764537787215, -122.405224355037)
183468 187562 2 116 136 Alpha St 4 1 1 1     5 Width 2ft   6010924.81275 2088138.49847 37.714246765754105 -122.40411411319401 (37.7142467657541, -122.404114113194)
123320 109532   116 818 Goettingen St 1 13 1 1           6010847.3 2090865.3 37.7217296747854 -122.404573864697 (37.7217296747854, -122.404573864697)
73308 187590 2 116 700 Goettingen St 1 7 1 1     4     6010709.76883 2091388.9815099998 37.7231599087791 -122.40508613194599 (37.7231599087791, -122.405086131946)
46422 248058 2 116 17 Rutledge St 4 17 1 1     5     6010687.47782 2099346.1468700003 37.7450073524216 -122.405723395139 (37.7450073524216, -122.405723395139)
172692 248065 2 116 18 Rutledge St 7 17 1 1     8     6010648.08166 2099392.5913299997 37.7451326756473 -122.405862891685 (37.7451326756473, -122.405862891685)
65505 248066 2 116 18 Rutledge St 8 17 1 1     7     6010646.65948 2099397.14706 37.7451451051559 -122.405868130216 (37.7451451051559, -122.405868130216)
166588 248068 2 116 20 Rutledge St 2 17 1 1     6     6010623.83336 2099392.33092 37.7451306044855 -122.40594672016701 (37.7451306044855, -122.405946720167)
146584 248054 2 116 19 Rutledge St 3 7 1 1     10     6010623.789469999 2099366.66931 37.7450601408245 -122.405945064536 (37.7450601408245, -122.405945064536)
70280 248053 2 116 19 Rutledge St 2 7 1 1     18     6010622.547590001 2099378.6850900003 37.7450930640901 -122.405950205054 (37.7450930640901, -122.405950205054)
64361 248069 2 116 20 Rutledge St 3 17 1 1     8     6010620.265980001 2099403.1540599996 37.7451601229588 -122.405959817907 (37.7451601229588, -122.405959817907)
114761 112559 6 116 1735x GRANT AVE 1 13 1 1           6010373.0 2120454.0 37.8029470287696 -122.40829930674299 (37.8029470287696, -122.408299306743)
178655 197579 2 116 428 08th St 1 4 1 1     3 Width 3ft   6010214.98706 2109650.78059 37.773275125388 -122.408083778259 (37.773275125388, -122.408083778259)
102307 99256 7 116 1466 York St   13 1 1           6010099.0 2100741.0 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429)
86911 87150 6 116 4 Bellair Pl 2 13 1 1         Permit Number 50135 6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
125077 87149 6 116 4 Bellair Pl 2 13 1 1           6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
165286 247908 2 116 582 Esmeralda Ave 6 17 1 1     12     6009856.31482 2098721.18962 37.7432448412741 -122.408553343056 (37.7432448412741, -122.408553343056)
165892 247905 2 116 582 Esmeralda Ave 3 17 1 1     4     6009839.52244 2098719.28889 37.7432386818184 -122.40861127291099 (37.7432386818184, -122.408611272911)
70736 247974 2 116 346 Peralta Ave 4 9 1 1     20     6009790.92788 2099185.07173 37.7445148980554 -122.408812155357 (37.7445148980554, -122.408812155357)
89351 116234 6 116 450 PERALTA AVE 1 7 1 1       3x3   6009750.0 2099218.0 37.744603019334 -122.408955999129 (37.744603019334, -122.408955999129)
20116 2370 3 116 2516 Bryant St 1 1 1 2     12 4X4PL   6009703.1421 2102664.68486 37.7540642287015 -122.40936121487499 (37.7540642287015, -122.409361214875)
154175 246775 2 116 925 Esmeralda Ave 1 2 1 1     7     6009505.54739 2098718.43829 37.743217635879205 -122.409766015896 (37.7432176358792, -122.409766015896)
117092 113150 6 116 45 BRONTE ST 1 1 1 1     15 3x3   6009384.0 2097185.0 37.7390003361927 -122.410078062228 (37.7390003361927, -122.410078062228)
37950 247598 2 116 900 Tompkins Ave 3 9 1 1     13 Width 10ft   6009167.823059999 2096407.9062599998 37.7368544863348 -122.410770639572 (37.7368544863348, -122.410770639572)
187074 247597 2 116 900 Tompkins Ave 2 9 1 1     12 Width 8ft   6009155.970980001 2096407.45458 37.7368525815689 -122.41081158571001 (37.7368525815689, -122.41081158571)
65616 247596 2 116 900 Tompkins Ave 1 9 1 1     13 Width 8ft   6009145.02453 2096408.71868 37.73685543873 -122.410849521814 (37.73685543873, -122.410849521814)
161479 136432 2 116 13 MacOndray Ln 3 9 1 1     15     6008638.14667 2119166.05389 37.799313351297606 -122.414211640849 (37.7993133512976, -122.414211640849)
24557 136431 2 116 13 MacOndray Ln 2 9 1 1     23     6008632.90068 2119166.6230200003 37.799314619318 -122.414229834152 (37.799314619318, -122.414229834152)
39748 240597 2 116 523 Powhattan Ave 1 2 1 1     29     6008567.55649 2098119.2319799997 37.741519737445294 -122.412966995358 (37.7415197374453, -122.412966995358)
54165 240598 2 116 2106 Folsom St 3 10 1 1     5 Width 2ft   6008077.42241 2106097.35182 37.763398325498 -122.415226338718 (37.763398325498, -122.415226338718)
69856 136428 2 116 7 Kimball Pl 1 2 1 1     15 Width 0ft   6007991.83691 2116437.43612 37.791784918695 -122.41625474228901 (37.791784918695, -122.416254742289)
38586 246713 2 116 1 Bonview St 19 2 1 1     20     6007763.89494 2099225.75212 37.7445128502976 -122.415824124379 (37.7445128502976, -122.415824124379)
99767 122496 2 116 69x Bonview St 12 1 1 2       3x3   6007716.0 2099172.0 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063)
176998 136430 2 116 1101 Greenwich St 15 7 1 1     20     6007579.05475 2119893.16835 37.8012502787406 -122.417928048762 (37.8012502787406, -122.417928048762)
61564 136429 2 116 1101 Greenwich St 11 7 1 1     14     6007562.303180001 2119880.18015 37.801213673635004 -122.41798509543301 (37.801213673635, -122.417985095433)
153412 179499 2 116 1151 Felton St 3 9 1 1     6 Width 2ft   6007548.787880001 2092831.16716 37.7269426263769 -122.416115141404 (37.7269426263769, -122.416115141404)
41820 136433 2 116 2671 Leavenworth St 6 9 1 1     32     6007318.566930001 2121838.23641 37.8065762788357 -122.418967487863 (37.8065762788357, -122.418967487863)
93306 116660 3 116 199x Esmeralda Ave 13 14 1 2     8     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
147227 240599 2 116 3229 21st St 1 1 1 1     21 Width 3ft   6006780.56286 2103771.69804 37.75693965177221 -122.41954675558 (37.7569396517722, -122.41954675558)
111685 107343 6 116 110 JULIAN AVE 2 13 1 1     15     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366)
172592 240600 2 116 237 Murray St 3 9 1 1     10 Width 10ft   6005707.57123 2095372.66085 37.7338173103055 -122.422660726511 (37.7338173103055, -122.422660726511)
72190 179498 2 116 892 Peru Ave 1 9 1 1     35     6005545.45161 2091807.84398 37.7240199601485 -122.422967943043 (37.7240199601485, -122.422967943043)
22599 2580 1 116 1668 Bush St 4 1 1 1     12 4X4   6005450.60125 2115176.6463599997 37.7881798837348 -122.424957678647 (37.7881798837348, -122.424957678647)
63075 179496 2 116 653 Peru Ave 8 17 1 1     6     6005058.40423 2092646.41058 37.726294985004294 -122.424711217658 (37.7262949850043, -122.424711217658)
131189 179497 2 116 653 Peru Ave 9 17 1 1     8     6005046.66321 2092646.92983 37.7262957476241 -122.424751842734 (37.7262957476241, -122.424751842734)
91222 98597 1 116 400X Steiner St 3 5 1 1         Permit Number 768529 6004639.0 2109849.0 37.7735056071657 -122.42738600543899 (37.7735056071657, -122.427386005439)
143568 96273 6 116 55@ Alemany Trumbull St 1 13 1 1           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208)
12707 107222 2 116 327 Vienna St 1 1 1 1   09/29/2014 12:00:00 AM 3 6x5 Permit Number 773943 6003989.6035400005 2091508.12122 37.7231090719178 -122.42832491578301 (37.7231090719178, -122.428324915783)
149664 240613 2 116 3637 22nd St 2 2 1 1     5 Width 3ft   6003938.94874 2103022.28304 37.754721465836894 -122.42932068472 (37.7547214658369, -122.42932068472)
33291 240614 2 116 3637 22nd St 3 2 1 1     3 Width 3ft   6003933.5831699995 2103025.57629 37.7547302045579 -122.429339475147 (37.7547302045579, -122.429339475147)
164767 240612 2 116 3637 22nd St 1 2 1 1     4 Width 3ft   6003932.88521 2103022.72642 37.7547223399723 -122.429341685671 (37.7547223399723, -122.429341685671)
91679 94535 6 116 265 Dorland St 1 13 1 1           6003831.0 2105693.0 37.7620485075454 -122.42988449123301 (37.7620485075454, -122.429884491233)
186205 240616 2 116 685 Sanchez St 1 2 1 1     14 Width 5ft   6003715.87711 2104249.40994 37.758078233932096 -122.430179665856 (37.7580782339321, -122.430179665856)
74195 240615 2 116 297 Cumberland St 1 9 1 1     8 Width 3ft   6003715.872169999 2104475.4119700002 37.75869878143 -122.430195805998 (37.75869878143, -122.430195805998)
35570 240617 2 116 685 Sanchez St 2 2 1 1     13 Width 5ft   6003712.72581 2104261.51662 37.7581112975082 -122.43019142809099 (37.7581112975082, -122.430191428091)
151692 240595 2 116 1300 San Jose Ave 7 7 1 1     27     6003654.00301 2095729.23304 37.7346803033401 -122.429785949874 (37.7346803033401, -122.429785949874)
60921 240596 2 116 1300 San Jose Ave 8 7 1 1     20     6003644.77453 2095717.8337299998 37.7346484808287 -122.429817043043 (37.7346484808287, -122.429817043043)
27359 240611 2 116 255 Jersey St 1 1 1 1     5 Width 3ft   6003497.9531 2101542.75011 37.750634040826796 -122.43074019171699 (37.7506340408268, -122.430740191717)
107500 54927 1 116 485 Duncan St 1 1 1 1   08/16/1972 12:00:00 AM 10   Permit Number 10801 6003402.69319537 2099776.66443458 37.745779384936206 -122.43094357883498 (37.7457793849362, -122.430943578835)
131190 246442 2 116 485 Duncan St 4 7 1 1     40     6003379.46073 2099778.50621 37.7457831256083 -122.431024044746 (37.7457831256083, -122.431024044746)
97021 106360 6 116 1820 POST ST 1 7 1 1     30     6003351.1 2114201.6 37.785383838011 -122.43215193232099 (37.785383838011, -122.432151932321)
102600 106362 6 116 1645 WEBSTER ST 1 7 1 1     12     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178)
125999 106361 6 116 1645 WEBSTER ST 2 7 1 1     30     6003301.2 2114333.7 37.7857437219688 -122.432334009178 (37.7857437219688, -122.432334009178)
150118 240628 2 116 32 Harry St 2 9 1 1     35     6003238.63031 2097694.69053 37.740053469295795 -122.431362290536 (37.7400534692958, -122.431362290536)
161342 240629 2 116 32 Harry St 4 9 1 1     15     6003236.62583 2097684.70359 37.740025933855705 -122.431368508471 (37.7400259338557, -122.431368508471)
34861 240630 2 116 32 Harry St 5 9 1 1     35     6003226.48563 2097681.33135 37.7400160997695 -122.43140332841999 (37.7400160997695, -122.43140332842)
135635 240594 2 116 216 Bemis St 1 9 1 1     47     6003152.3623 2096416.5644900003 37.736539139077394 -122.43156934507401 (37.7365391390774, -122.431569345074)
43173 112929 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
Powered by Datasette · Query took 5.857ms · Data source: data.sfgov.org