sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
561 204410 2 12 450x Lawton St 1 1 1 1     15 Width 3ft   5992920.0 2104601.0 37.7584262276473 -122.46754168203998 (37.7584262276473, -122.46754168204)
752 251380 2 12 731 Huron Ave 1 1 1 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
783 251381 2 12 731 Huron Ave 2 1 1 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
1556 251583 2 12 75 Rice St   1 1 1       3x3   5995352.0 2086409.0 37.7086155444167 -122.45781440192499 (37.7086155444167, -122.457814401925)
1688 219867 2 12 825X Crescent Ave 2 1 1 1     8 Width 3ft   6008218.0 2095659.0 37.7347448507601 -122.414001643438 (37.7347448507601, -122.414001643438)
1695 219868 2 12 825x Crescent Ave 1 1 1 1     8 Width 3ft   6008218.0 2095659.0 37.7347448507601 -122.414001643438 (37.7347448507601, -122.414001643438)
1878 251764 2 12 187 Seville St 4 2 1 1       Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
1916 182474 2 12 1570 29th Ave 1 1 1 1     2 3x9   5987173.0512 2104601.3953 37.758093836212794 -122.487416955394 (37.7580938362128, -122.487416955394)
2253 185120 2 12 2865 34th Ave 2 1 1 1     9 3x9   5985842.0 2096048.0 37.734530809359605 -122.491390692258 (37.7345308093596, -122.491390692258)
2480 253100 2 12 501x Tompkins Ave 1 1 1 1       3x3   6008413.0 2096458.0 37.736949681186296 -122.41338394609 (37.7369496811863, -122.41338394609)
2702 175365 2 12 1 Brotherhood Way 18 2 1 1     7 Width 5ft   5993296.25394 2087788.76232 37.712285726578 -122.465019407322 (37.712285726578, -122.465019407322)
2703 175367 2 12 1 Brotherhood Way 23 2 1 1     5 Width 5ft   5993394.31846 2087754.15211 37.7121963492565 -122.464677958129 (37.7121963492565, -122.464677958129)
2705 175366 2 12 1 Brotherhood Way 22 2 1 1     4 Width 5ft   5993316.47827 2087783.2739799998 37.7122718230516 -122.464949108223 (37.7122718230516, -122.464949108223)
2708 175370 2 12 1 Brotherhood Way 26 2 1 1     5 Width 5ft   5993448.13741 2087722.6413599998 37.712112930839 -122.464489658971 (37.712112930839, -122.464489658971)
2709 175364 2 12 1 Brotherhood Way 15 2 1 1     3 Width 5ft   5993263.021319999 2087797.41727 37.7123075747038 -122.465134896479 (37.7123075747038, -122.465134896479)
2716 175362 2 12 1 Brotherhood Way 10 2 1 1     6 Width 5ft   5993185.52762 2087808.44828 37.7123333942447 -122.46540353654 (37.7123333942447, -122.46540353654)
2720 175369 2 12 1 Brotherhood Way 25 2 1 1     3 Width 5ft   5993431.63462 2087732.39125 37.7121387503812 -122.46454740445101 (37.7121387503812, -122.464547404451)
2721 175371 2 12 1 Brotherhood Way 27 2 1 1     3 Width 5ft   5993471.88559 2087712.01586 37.712085124705204 -122.464406808033 (37.7120851247052, -122.464406808033)
2722 175368 2 12 1 Brotherhood Way 24 2 1 1     2 Width 5ft   5993415.10175 2087740.6954 37.7121605985029 -122.464605149022 (37.7121605985029, -122.464605149022)
2749 253209 2 12 1129 Naples St   1 1 1       3x3   6001432.0 2087854.0 37.712930619101 -122.43690455890899 (37.712930619101, -122.436904558909)
2849 253236 2 12 101 Paloma Ave 2 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2862 253241 2 12 101 Paloma Ave 7 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2863 221127 2 12 1218 Treat Ave 1 1 1 1     1 Width 3ft   6008662.3869 2101444.26707 37.750654869142 -122.412874131348 (37.750654869142, -122.412874131348)
2866 253244 2 12 299X Moncada Way 3 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2884 253239 2 12 101 Paloma Ave 5 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2888 253238 2 12 101 Paloma Ave 4 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2901 253237 2 12 101 Paloma Ave 3 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2902 253245 2 12 299X Moncada Way 4 1 1 1       3x2   5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
2986 114577 2 12 3610 Washington St 1 1 1 1   01/21/2016 12:00:00 AM 30 3x3 Permit Number 777195 5997470.267659999 2115762.68023 37.7893349711866 -122.452610443035 (37.7893349711866, -122.452610443035)
3032 253284 2 12 1711 27th Ave 1 1 1 1       3x3   5987766.0 2103624.0 37.7554447356639 -122.48529459198 (37.7554447356639, -122.48529459198)
3184 125654 2 12 1930 Jackson St 1 1 1 1     21 Width 4ft   6004929.0 2117144.0 37.7935522647148 -122.426902500154 (37.7935522647148, -122.426902500154)
3263 171246 2 12 134 Madrid St 1 1 1 1     0 Width 3ft   6003944.63732 2093041.28338 37.7273162506437 -122.428589588953 (37.7273162506437, -122.428589588953)
3530 123324 2 12 798 05th Ave 2 9 1 1     13   Permit Number 780721 5994466.95086 2110266.43708 37.7740712286384 -122.462602639066 (37.7740712286384, -122.462602639066)
3540 123527 2 12 2850 Fulton St 1 9 1 1     8 Width 8ft Permit Number 780721 5994500.1201 2110215.1995599996 37.77393245416361 -122.462484184544 (37.7739324541636, -122.462484184544)
3579 123325 2 12 798 05th Ave 1 9 1 1     12   Permit Number 780721 5994467.5512 2110242.48836 37.7740055063811 -122.46259882484101 (37.7740055063811, -122.462598824841)
3637 253235 2 12 101 Paloma Ave 1 1 1 1       3x2 Permit Number 780627 5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3647 253240 2 12 101 Paloma Ave 6 1 1 1       3x2 Permit Number 780627 5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3654 253242 2 12 299X Moncada Way 1 1 1 1       3x2 Permit Number 780627 5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3679 253243 2 12 299X Moncada Way 2 1 1 1       3x2 Permit Number 780627 5992091.0 2093757.0 37.728603476542396 -122.469619290083 (37.7286034765424, -122.469619290083)
3733 175357 2 12 1 Brotherhood Way 2 7 1 1     3 Width 5ft   5992890.63105 2087809.5806900002 37.7123194916216 -122.466422861444 (37.7123194916216, -122.466422861444)
3737 175356 2 12 1 Brotherhood Way 1 1 1 1     3 Width 5ft   5992860.08995 2087808.05232 37.71231353272879 -122.46652830874201 (37.7123135327288, -122.466528308742)
3738 175361 2 12 1 Brotherhood Way 6 7 1 1     3 Width 5ft   5993097.02114 2087813.9243700001 37.7123433254574 -122.465709836634 (37.7123433254574, -122.465709836634)
3740 175359 2 12 1 Brotherhood Way 4 7 1 1     7 Width 5ft   5993023.53483 2087808.23472 37.7123234639353 -122.465963412176 (37.7123234639353, -122.465963412176)
3743 175363 2 12 1 Brotherhood Way 8 17 1 1     3 Width 5ft   5993226.79298 2087801.79474 37.71231750501779 -122.465260429219 (37.7123175050178, -122.465260429219)
3747 175360 2 12 1 Brotherhood Way 5 7 1 1     5 Width 5ft   5993054.1062900005 2087811.2090200002 37.7123333942521 -122.46585796488002 (37.7123333942521, -122.46585796488)
3748 175358 2 12 1 Brotherhood Way 3 7 1 1     3 Width 5ft   5992915.27224 2087806.8926400002 37.7123135327144 -122.466337499576 (37.7123135327144, -122.466337499576)
4008 216051 2 12 48 Lobos St 1 2 1 1   10/05/2017 02:54:00 PM 3     5996419.4156599995 2088710.03455 37.7149949180514 -122.454291392827 (37.7149949180514, -122.454291392827)
4030 216055 2 12 52 Lobos St 3 2 1 1   10/05/2017 02:49:00 PM 3     5996381.618969999 2088696.9088599999 37.714956710372 -122.454421085891 (37.714956710372, -122.454421085891)
4092 216045 2 12 36 Lobos St 2 2 1 1   10/05/2017 03:04:00 PM 3     5996513.0629 2088696.2251900001 37.7149623706927 -122.45396671331999 (37.7149623706927, -122.45396671332)
4097 216058 2 12 58 Lobos St 1 2 1 1   10/05/2017 02:35:00 PM 3     5996320.31527 2088710.5585599998 37.7149906732676 -122.45463396169599 (37.7149906732676, -122.454633961696)
4103 216046 2 12 38 Lobos St 1 2 1 1   10/05/2017 03:02:00 PM 3     5996487.74032 2088710.41168 37.7149998715299 -122.454055262356 (37.7149998715299, -122.454055262356)
4117 216048 2 12 40 Lobos St 1 2 1 1   10/05/2017 02:58:00 PM 3     5996463.1782599995 2088711.43982 37.7150012861457 -122.45414023299999 (37.7150012861457, -122.454140233)
4185 175269 2 12 72 Morse St 1 1 1 1   10/10/2017 11:02:00 AM 3 Width 4ft   6001060.69663 2088020.77374 37.7133674320474 -122.438199842368 (37.7133674320474, -122.438199842368)
4289 175270 2 12 72 Morse St 2 1 1 1   10/10/2017 11:06:00 AM 3 Width 4ft   6001043.39915 2088014.71934 37.7133498242071 -122.438259194899 (37.7133498242071, -122.438259194899)
4337 180894 2 12 887 Geneva Ave 1 1 1 1   10/11/2017 10:58:00 AM 3 Width 1ft   6000229.00431 2089321.38405 37.716891277996 -122.441167710317 (37.716891277996, -122.441167710317)
4464 222031 2 12 301 Webster St 1 1 1 1     4 Width 3ft   6004133.844959999 2109890.1232 37.7735899384632 -122.429136343468 (37.7735899384632, -122.429136343468)
4682 213163 2 12 142 Granada Ave 1 1 1 1   05/09/2017 12:00:00 AM 3 3x3 Permit Number 780043 5995654.76041 2090862.8911099997 37.7208622740576 -122.45708998411101 (37.7208622740576, -122.457089984111)
5245 205593 2 12 30 Vasquez Ave 2 2 1 1     7 Width 3ft   5995699.652000001 2100090.8564 37.746202601761105 -122.45760214624201 (37.7462026017611, -122.457602146242)
7819 74571 2 12 1055 Pine St 4 1 1 1 1 11/17/2014 12:00:00 AM 3   Permit Number 774207 6008908.989 2115950.0282799997 37.7904981444129 -122.413046908194 (37.7904981444129, -122.413046908194)
9835 121650 2 12 90 Fernwood Dr 5 1 1 1   01/03/2017 12:00:00 AM 3 2x2 Permit Number 779248 5994730.0 2095273.0 37.7329182144954 -122.46060599283999 (37.7329182144954, -122.46060599284)
10129 173878 2 12 89 Montana St 5 1 1 1       3x3   5995989.0 2089223.0 37.7163787086702 -122.455816142362 (37.7163787086702, -122.455816142362)
10633 78424 2 12 337 Amazon Ave 1 1 1 1 1 08/12/2000 12:00:00 AM 12 3x3   6001367.33803 2089018.36243 37.716124024086 -122.43721136872499 (37.716124024086, -122.437211368725)
10912 75399 2 12 1350 Santiago St 1 1 1 1 1 07/22/1995 12:00:00 AM 12 4x6   5988689.6276 2099701.3205 37.7447278644639 -122.48181312543501 (37.7447278644639, -122.481813125435)
10939 75321 2 12 1350 Santiago St 2 1 1 1 1 07/22/1995 12:00:00 AM 6 9x4   5988672.5581 2099700.4669999997 37.7447245283024 -122.481872085268 (37.7447245283024, -122.481872085268)
10955 109923 2 12 214 state st 1 1 1 1       3x3            
11277 105244 2 12 2398X 22nd Ave 1 1 1 1     7 4x4   5989539.9051 2099080.116 37.7430716095087 -122.47882763740299 (37.7430716095087, -122.478827637403)
11335 106714 2 12 201X Campbell Ave 1 1 1 1     2 3x3   6011615.93031 2088323.1081400001 37.7147922585389 -122.401738295884 (37.7147922585389, -122.401738295884)
12892 98234 2 12 1714 24th Ave 1 1 1 1     20 7x3.5   5988761.0773 2103624.0997 37.7555029284864 -122.481853358314 (37.7555029284864, -122.481853358314)
13187 106199 2 12 2107 42nd Ave 1 1 1 1 1   4 3x4   5983225.8003 2100763.9337 37.74732624942661 -122.500784246807 (37.7473262494266, -122.500784246807)
18372 105016 2 12 1099X 23rd St 2 1 1 1         Marked for a basin expansion. SB 6015050.3 2102960.5 37.755174615412 -122.390889970266 (37.755174615412, -122.390889970266)
22367 123236 2 12 483 08th Ave 1 1 1 1     5 Width 3ft   5993412.976369999 2112216.81611 37.7793656900854 -122.466390268708 (37.7793656900854, -122.466390268708)
22369 142528 2 12 2099 STOCKTON ST 2 1 1 1     5 Width 0ft   6009851.4529 2121181.5487 37.8049154781273 -122.410155533168 (37.8049154781273, -122.410155533168)
22858 175520 2 12 37 Somerset St 1 1 1 1     3 Width 3ft   6009556.22459 2094251.46903 37.7309551414619 -122.40927562817801 (37.7309551414619, -122.409275628178)
22860 175521 2 12 1390 Silver Ave 1 1 1 1     3 Width 3ft   6009545.15873 2094354.93032 37.7312386041589 -122.40932118334699 (37.7312386041589, -122.409321183347)
22864 175524 2 12 1390 Silver Ave 8 1 1 1     3 Width 3ft   6009731.24208 2094424.2667 37.7314394111049 -122.408682746526 (37.7314394111049, -122.408682746526)
22865 175522 2 12 1390 Silver Ave 6 1 1 1     3 Width 3ft   6009701.36269 2094412.91258 37.73140656156 -122.408785244942 (37.73140656156, -122.408785244942)
22871 175523 2 12 1390 Silver Ave 7 1 1 1     3 Width 3ft   6009716.77094 2094417.8082599998 37.731420867084104 -122.408732320751 (37.7314208670841, -122.408732320751)
22946 111775 2 12 2025 HAYES ST 1 1 1 1   09/04/2015 12:00:00 AM 1 3x3   5998152.0 2109921.0 37.773334280678505 -122.449830575963 (37.7733342806785, -122.449830575963)
23386 188175 2 12 210 Nelson Rising Ln 7 1 1 1     4 Width 5ft   6014711.2463 2108247.22794 37.7696720032978 -122.392432291228 (37.7696720032978, -122.392432291228)
23413 221006 2 12 3690 21st St 1 1 1 1     3 Width 3ft   6003830.15393 2103652.098 37.7564446289193 -122.429741845322 (37.7564446289193, -122.429741845322)
23480 175453 2 12 268 Harvard St 2 1 1 1     8 Width 3ft   6006269.154569999 2092540.7045599998 37.72607304672079 -122.420518206868 (37.7260730467208, -122.420518206868)
23486 125677 2 12 1108 Green St 3 1 1 1     3 Width 3ft   6007673.08729 2118891.44858 37.7985050990805 -122.417531618596 (37.7985050990805, -122.417531618596)
23490 175458 2 12 1530 Felton St 5 1 1 1     6 Width 3ft   6006357.8594 2092519.5291099998 37.72601990217 -122.420210056863 (37.72601990217, -122.420210056863)
23494 219849 2 12 72 Skyview Way 1 4 1 1     4 Width 3ft   5997939.73785 2101790.86322 37.7509988274335 -122.449978746126 (37.7509988274335, -122.449978746126)
23530 222049 2 12 201 Treat Ave 12 2 1 1     6 Width 6ft   6008976.23011 2107818.47181 37.768174596097104 -122.41223929451401 (37.7681745960971, -122.412239294514)
23559 188032 2 12 1 Coral Rd 6 1 1 1     1 Width 3ft   6012685.55222 2102502.84879 37.7537865099459 -122.39903589429599 (37.7537865099459, -122.399035894296)
23618 219766 2 12 1620 Diamond St 2 1 1 1     4 Width 4ft   6002007.01314 2099294.499 37.744376291847 -122.43573514146999 (37.744376291847, -122.43573514147)
23625 175428 2 12 133 Craut St 4 1 1 1     2 Width 3ft   6004048.265380001 2094226.60975 37.7305767562012 -122.428315791245 (37.7305767562012, -122.428315791245)
23643 219597 2 12 1179 Treat Ave 1 1 1 1     10 Width 4ft   6008685.27618 2101713.0986599997 37.751394305222 -122.41281398199 (37.751394305222, -122.41281398199)
23698 175314 2 12 899 Mansell St 8 1 1 1     8 Width 4ft   6009495.89635 2089986.4010299998 37.7192407811117 -122.409183344249 (37.7192407811117, -122.409183344249)
23834 175245 2 12 545 Geneva Ave 2 1 1 1     0 Width 1ft   5998908.22641 2090670.86353 37.720521316785 -122.445829976599 (37.720521316785, -122.445829976599)
23836 204823 2 12 1331 09th Ave 1 10 1 1     2 Width 4ft   5993302.77838 2106404.87542 37.7634012905668 -122.466348974927 (37.7634012905668, -122.466348974927)
23874 219680 2 12 278 Gates St 1 1 1 1     2 Width 3ft   6008233.556580001 2097312.36183 37.739285495029705 -122.41406478786999 (37.7392854950297, -122.41406478787)
23943 114557 2 12 2775 Green St 1 1 1 1     3 3x3   5999783.32875 2117736.28966 37.7948862424707 -122.444749467237 (37.7948862424707, -122.444749467237)
23956 204909 2 12 2 Pizarro Way 2 1 1 1     8 Width 2ft   5995160.976480001 2093941.9337799998 37.729288215671204 -122.459019662151 (37.7292882156712, -122.459019662151)
23998 188188 2 12 765 Clementina St 1 1 1 1     4 Width 2ft   6009214.52328 2110157.3825 37.7746100682212 -122.41158033158199 (37.7746100682212, -122.411580331582)
24069 204989 2 12 491 Ulloa St 1 2 1 1     7 Width 4ft   5995151.4003 2098200.0926599996 37.7409795263895 -122.459361016022 (37.7409795263895, -122.459361016022)
24296 244453 2 12 172 Lily St 1 1 1 1     7 Width 0ft   6005736.4691 2110172.6896 37.774456388941104 -122.42361271258301 (37.7744563889411, -122.423612712583)
24345 124697 2 12 451 Cherry St 1 1 1 1     1 Width 3ft   5996214.788240001 2114760.29077 37.786510664059 -122.456881699337 (37.786510664059, -122.456881699337)
24346 175319 2 12 75 Ankeny St 1 1 1 1     6 Width 3ft   6010803.296080001 2089937.5359 37.7191797656998 -122.40466069593201 (37.7191797656998, -122.404660695932)
Powered by Datasette · Query took 5.356ms · Data source: data.sfgov.org