sf-trees

Data source: data.sfgov.org

Custom SQL query returning 50 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
25361 229873 2 52 3571 21st St 1 1 1 1     2 Width 4ft   6004534.157880001 2103646.15858 37.75646816057971 -122.427306727641 (37.7564681605797, -122.427306727641)
28599 226426 2 52 3323 23rd St 1 1 1 1     2 Width 3ft   6006880.3188 2102604.06002 37.753739204713895 -122.419118940914 (37.7537392047139, -122.419118940914)
30189 229788 2 52 1799 15th St 2 1 1 1     2 Width 3ft   6005571.35245 2107231.70655 37.7663718340174 -122.423974702579 (37.7663718340174, -122.423974702579)
31787 121581 2 52 199X Texas St 1 1 1 1 1   2 3x3   6013754.46885 2106222.8302700003 37.764060277784 -122.395599922908 (37.764060277784, -122.395599922908)
34263 226464 2 52 2670 Harrison St 2 1 1 1     2 Width 3ft   6008878.67119 2102975.76915 37.7548721679187 -122.412234430081 (37.7548721679187, -122.412234430081)
36855 226463 2 52 2680 Harrison St 1 1 1 1     2 Width 3ft   6008883.3825199995 2102935.43228 37.754761676334205 -122.412215286208 (37.7547616763342, -122.412215286208)
38730 226338 2 52 41 Bartlett St 5 1 1 1     2 Width 3ft   6006684.19647 2103512.2186 37.7562217526516 -122.41986161543001 (37.7562217526516, -122.41986161543)
38848 229842 2 52 3731 20th St 1 1 1 1     2 Width 3ft   6005435.33161 2104281.1313099996 37.758262571580794 -122.424235305437 (37.7582625715808, -122.424235305437)
40742 226305 2 52 84 Santa Marina St 1 1 1 1     2 Width 3ft   6006137.34667 2097561.4602200002 37.7398515040311 -122.42133024340599 (37.7398515040311, -122.421330243406)
42743 108444 1 52 1 Sycamore St 1 1 1 1 1 12/22/2014 12:00:00 AM 2 3x2.5   6014877.0 2117007.0 37.793733556134896 -122.39247175850299 (37.7937335561349, -122.392471758503)
48658 226335 2 52 19 Bartlett St 1 1 1 1     2 Width 3ft   6006677.49566 2103645.89142 37.756588409851496 -122.419894274305 (37.7565884098515, -122.419894274305)
48894 226782 2 52 579 Noe St 1 2 1 1     2 Width 3ft   6003036.36439 2104869.3742 37.7597419968272 -122.43257399299999 (37.7597419968272, -122.432573993)
53368 78724 1 52 1300 Rhode Island St 2 1 1 1   06/22/2010 12:00:00 AM 2 3x3 Permit Number 53574 6011950.73154 2102276.22736 37.7531232815236 -122.40156116092699 (37.7531232815236, -122.401561160927)
53861 176586 2 52 205 Seneca Ave 4 9 1 1     2 Width 6ft   5999824.12192 2090353.8387799999 37.7197030929005 -122.44264127649099 (37.7197030929005, -122.442641276491)
58267 226467 2 52 11 28th St 1 1 1 1     2 Width 3ft   6005807.5274 2099625.67838 37.7455007798334 -122.42261726946998 (37.7455007798334, -122.42261726947)
58379 229740 2 52 60 Dorland St 1 1 1 1     2 Width 3ft   6005206.89439 2105762.97862 37.762318473540795 -122.425130780182 (37.7623184735408, -122.425130780182)
61111 226339 2 52 41 Bartlett St 4 1 1 1     2 Width 3ft   6006685.94494 2103496.44851 37.7561785501259 -122.41985444962201 (37.7561785501259, -122.419854449622)
63374 226817 2 52 4430 17th St 1 1 1 1     2 Width 3ft   5999749.40261 2105767.64242 37.762021469725795 -122.444006474335 (37.7620214697258, -122.444006474335)
72874 226805 2 52 73 Collingwood St 2 1 1 1     2 Width 3ft   6002033.709009999 2105453.8141799998 37.7612898163989 -122.43608349926501 (37.7612898163989, -122.436083499265)
74219 226309 2 52 161 Newman St 2 1 1 1     2 Width 2ft   6007378.4424 2096771.82308 37.737753229234 -122.41698311040301 (37.737753229234, -122.416983110403)
75004 229795 2 52 277 Clinton Park 1 1 1 1     2 Width 4ft   6004958.17286 2108195.3416 37.7689831073039 -122.426164188445 (37.7689831073039, -122.426164188445)
92205 105745 2 52 418 Pierce St 1 1 1 1   06/02/2014 12:00:00 AM 2 4x4 Permit Number 771651 6002705.0 2109971.0 37.7737310181147 -122.43408471033301 (37.7737310181147, -122.434084710333)
98500 67792 1 52 4252 25th St 1 1 1 1   09/29/2009 12:00:00 AM 2 3x3 Permit Number 52966 6002229.57555078 2101227.41307609 37.7496962578989 -122.435103788069 (37.7496962578989, -122.435103788069)
115952 229863 2 52 1511 York St 1 1 1 1     2 Width 3ft   6010172.47865 2100425.75688 37.74794291223429 -122.40758028200001 (37.7479429122343, -122.407580282)
118175 226318 2 52 1453 Alabama St 1 1 1 1     2 Width 4ft   6009324.958769999 2100785.02024 37.748881892593296 -122.410536346369 (37.7488818925933, -122.410536346369)
130489 229763 2 52 1201 Vermont St 33 9 1 1     2 Width 4ft   6011453.21392 2102329.36922 37.753241423671795 -122.403285422977 (37.7532414236718, -122.403285422977)
132415 226334 2 52 1 Bartlett St 1 1 1 1     2 Width 3ft   6006673.9132199995 2103705.36513 37.756751509094 -122.419910883878 (37.756751509094, -122.419910883878)
135455 226308 2 52 161 Newman St 1 1 1 1     2 Width 2ft   6007401.10475 2096768.5296099999 37.7377454608683 -122.416904522239 (37.7377454608683, -122.416904522239)
137381 43189 1 52 175 Sweeny St 1 1 1 1 1 07/11/2000 12:00:00 AM 2   Permit Number 42991 6009687.65103 2094852.37094 37.7326124525905 -122.40886364246401 (37.7326124525905, -122.408863642464)
138072 229807 2 52 2560 Bryant St 1 1 1 1     2 Width 3ft   6009717.31333 2102417.08102 37.753385157817604 -122.409294735183 (37.7533851578176, -122.409294735183)
138131 201517 2 52 911 Innes Ave 3 9 1 1     2 Width 5ft   6019123.25931 2094488.31096 37.7321368236424 -122.37621683574699 (37.7321368236424, -122.376216835747)
152017 176588 2 52 151 Ney St 1 1 1 1     2 Width 3ft   6004383.65032 2094057.6355400002 37.73013176266 -122.42714428398399 (37.73013176266, -122.427144283984)
152576 229841 2 52 3772 20th St 1 1 1 1     2 Width 6ft   6005193.66428 2104309.8133400003 37.758327677085205 -122.425073138141 (37.7583276770852, -122.425073138141)
152773 226340 2 52 41 Bartlett St 3 1 1 1     2 Width 3ft   6006685.59051 2103479.17398 37.7561310982853 -122.419854449627 (37.7561310982853, -122.419854449627)
152926 190743 2 52 39 Latona St 1 4 1 1     2 Width 6ft   6014419.07803 2094437.81167 37.731738047151296 -122.392476830144 (37.7317380471513, -122.392476830144)
153170 228548 2 52 1325 Florida St 2 1 1 1     2 Width 4ft   6009560.01396 2101278.1954 37.7502492173426 -122.409758328497 (37.7502492173426, -122.409758328497)
153521 219234 2 52 273 Dalewood Way 1 1 1 1     2 Width 3ft   5995327.0897 2097229.7554099998 37.7383253194549 -122.458683321089 (37.7383253194549, -122.458683321089)
154552 229742 2 52 749 Dolores St 5 2 1 1     2 Width 8ft   6005048.07948 2104060.60475 37.7576351838315 -122.425558898838 (37.7576351838315, -122.425558898838)
156830 248273 2 52 155 Lundy's Ln 2 1 1 1     2 Width 2ft   6006714.66464 2098690.1987099997 37.7429832995482 -122.419414171229 (37.7429832995482, -122.419414171229)
160223 40004 1 52 911 Innes Ave 2 1 1 1 1 02/03/1999 12:00:00 AM 2   Permit Number 41258 6019111.21169 2094496.3329 37.7321581870346 -122.376259043617 (37.7321581870346, -122.376259043617)
161138 190749 2 52 111 08th St 1 1 1 1     2 Width 4ft   6008907.60615 2111116.85343 37.7772273283225 -122.41270986656201 (37.7772273283225, -122.412709866562)
163533 226374 2 52 4120 22nd St 1 1 1 1     2 Width 3ft   6001383.53668 2102929.36368 37.754321328688505 -122.438151321247 (37.7543213286885, -122.438151321247)
167292 54450 1 52 435 Vermont St 1 1 1 1   09/16/2008 12:00:00 AM 2 3x3 Permit Number 51720 6011224.5432 2106327.02843 37.7642053321404 -122.40435757586 (37.7642053321404, -122.40435757586)
172269 57319 1 52 2719 Sutter St 1 1 1 1   08/31/1976 12:00:00 AM 2   Permit Number 16144 5999557.8231 2113954.6853 37.784490078245604 -122.44525772561501 (37.7844900782456, -122.445257725615)
173236 226336 2 52 25 Bartlett St 1 1 1 1     2 Width 3ft   6006679.39058 2103618.84473 37.7565142526416 -122.41988580180201 (37.7565142526416, -122.419885801802)
178416 129103 3 52 1306x Montgomery St 29 3 1 2     2 Width 8ft   6011435.37643 2120050.37627 37.8018982087863 -122.40459448426901 (37.8018982087863, -122.404594484269)
178840 226774 2 52 4069 25th St 1 1 1 1     2 Width 3ft   6003404.88062 2101242.91418 37.749805488230706 -122.431040646222 (37.7498054882307, -122.431040646222)
179526 190700 2 52 199 Texas St 2 1 1 1     2 Width 3ft   6013754.83495 2106240.90179 37.764109918566206 -122.395599922892 (37.7641099185662, -122.395599922892)
186242 200047 2 52 1582 Shafter Ave 1 1 1 1     2 Width 0ft   6015033.0267 2094124.7502 37.730912518823295 -122.39033240224899 (37.7309125188233, -122.390332402249)
186575 226337 2 52 41 Bartlett St 6 1 1 1     2 Width 3ft   6006682.98669 2103529.00936 37.756267788048795 -122.41986699069099 (37.7562677880488, -122.419866990691)
Powered by Datasette · Query took 6.14ms · Data source: data.sfgov.org