sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
105405 98743 2 5 155 Masonic Ave 5 26 1 4 2         5998843.8 2112455.0 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218)
73756 188569 2 5 1 24th St 26 23 1 1     5     6017110.36972 2102585.1726599997 37.754258135118796 -122.383739444343 (37.7542581351188, -122.383739444343)
98922 188568 2 5 1 24th St 24 23 1 1     38     6017120.705080001 2102612.3766799998 37.7543334029878 -122.38370559563499 (37.7543334029878, -122.383705595635)
32088 186539 2 5 1501 Sunset Blvd 10 19 1 1     1 Width 0ft   5984748.3754 2104879.0915 37.7587146113666 -122.49582288356001 (37.7587146113666, -122.49582288356)
41370 186537 2 5 1501 Sunset Blvd 8 19 1 1     14 Width 0ft   5984743.3507 2104891.2345 37.7587476583889 -122.49584115676501 (37.7587476583889, -122.495841156765)
51500 185486 2 5 2400 Sunset Blvd 39 19 1 1     3 Width 0ft   5985131.6978 2098522.3598 37.7412832067047 -122.494028708144 (37.7412832067047, -122.494028708144)
55634 185460 2 5 2400 Sunset Blvd 10 19 1 1     3 Width 0ft   5985122.4012 2098351.0376 37.7408122581003 -122.49404822844801 (37.7408122581003, -122.494048228448)
130262 200159 2 5 1043 Ingerson Ave 1 19 1 1     9 Width 0ft   6013947.408 2089985.5634 37.719486864857004 -122.39379597620301 (37.719486864857, -122.393795976203)
150157 186541 2 5 1501 Sunset Blvd 12 19 1 1     7 Width 0ft   5984745.863 2104876.5792 37.7587075661518 -122.49583138713601 (37.7587075661518, -122.495831387136)
156135 200237 2 5 919 Ingerson Ave 1 19 1 1     4 Width 0ft   6014571.1757 2089512.0366 37.7182212977035 -122.39160673351002 (37.7182212977035, -122.39160673351)
164141 185483 2 5 2400 Sunset Blvd 36 19 1 1     2 Width 0ft   5985132.3618 2098506.4228 37.741239486847206 -122.494025238023 (37.7412394868472, -122.494025238023)
23489 247849 2 5 152 Chapman St 1 17 1 1     15     6009118.007540001 2098230.0964599997 37.74185503078979 -122.41107154552401 (37.7418550307898, -122.411071545524)
25663 188593 2 5 1 20th St 1 17 1 1     27     6010961.38996 2104652.9831 37.759594070921004 -122.40514986509899 (37.759594070921, -122.405149865099)
31230 187779 2 5 230 Middle Point Rd 2 17 1 1     5 Width 6ft   6018271.33931 2096490.0449 37.737586251210104 -122.379301134458 (37.7375862512101, -122.379301134458)
44107 188705 2 5 1998 Revere Ave 2 17 1 1     3     6013030.362000001 2095929.4873 37.7357566623473 -122.397382506903 (37.7357566623473, -122.397382506903)
49102 248109 2 5 138 Rutledge St 3 17 1 1     24     6010416.26244 2099462.28287 37.7453110660681 -122.406669396477 (37.7453110660681, -122.406669396477)
53119 175069 2 5 101 Woolsey St 6 17 1 1     20     6011573.1556 2092162.2260200002 37.7253313074768 -122.402155892479 (37.7253313074768, -122.402155892479)
56158 247931 2 5 1099 Esmeralda Ave 4 17 1 1     6     6010377.81236 2098773.8118 37.7434185228518 -122.406753840137 (37.7434185228518, -122.406753840137)
65626 247850 2 5 152 Chapman St 2 17 1 1     42     6009080.756440001 2098231.91815 37.7418579436943 -122.41120047681801 (37.7418579436943, -122.411200476818)
66596 248070 2 5 20 Rutledge St 4 17 1 1     13     6010599.59932 2099402.0661 37.745155979779504 -122.406031203374 (37.7451559797795, -122.406031203374)
69221 247529 2 5 1101 Waller St 10 17 1 1     2     6000073.75314 2108487.72588 37.7695086378454 -122.44308003233499 (37.7695086378454, -122.443080032335)
130643 247527 2 5 1101 Waller St 8 17 1 1     2     6000059.53834 2108484.86365 37.769499968379705 -122.443128995021 (37.7694999683797, -122.443128995021)
132984 175066 2 5 800 Thornton Ave 1 17 1 1     8     6010981.076169999 2094029.55145 37.73042552801979 -122.40433403878599 (37.7304255280198, -122.404334038786)
133560 247858 2 5 82 Bradford St 1 17 1 1     12     6009570.7437 2098077.6511 37.7414618274161 -122.40949536852501 (37.7414618274161, -122.409495368525)
156377 247522 2 5 1101 Waller St 3 17 1 1     10     6000010.6242 2108472.60358 37.7694635161602 -122.443297305835 (37.7694635161602, -122.443297305835)
159551 247520 2 5 1101 Waller St 1 17 1 1     14     6000003.99995 2108482.26842 37.7694896756401 -122.443320913055 (37.7694896756401, -122.443320913055)
165964 175067 2 5 800 Thornton Ave 2 17 1 1     26     6010979.40226 2094033.66945 37.730436741644894 -122.404340115499 (37.7304367416449, -122.404340115499)
172072 187778 2 5 230 Middle Point Rd 1 17 1 1     2 Width 6ft   6018276.18855 2096495.79876 37.7376023175876 -122.37928476769899 (37.7376023175876, -122.379284767699)
172088 125288 2 5 943 Green St 11 17 1 1     1     6008674.79926 2118995.08989 37.7988459853112 -122.41407270821101 (37.7988459853112, -122.414072708211)
176347 125277 2 5 1285 Greenwich St 2 17 1 1     10     6006721.71386 2119753.35883 37.800818109519206 -122.420884898228 (37.8008181095192, -122.420884898228)
179049 175068 2 5 101 Woolsey St 5 17 1 1     5     6011564.90281 2092154.99462 37.7253109908919 -122.402183913575 (37.7253109908919, -122.402183913575)
181186 175070 2 5 104 Woolsey St 2 17 1 1     14     6011561.993480001 2092186.33195 37.725396874350096 -122.40219617312599 (37.7253968743501, -122.402196173126)
181546 125276 2 5 1285 Greenwich St 1 17 1 1     15     6006714.64641 2119759.73621 37.800835221824 -122.420909807645 (37.800835221824, -122.420909807645)
182693 187780 2 5 230 Middle Point Rd 3 17 1 1     4 Width 6ft   6018250.04699 2096453.9006400001 37.7374858320104 -122.379372242948 (37.7374858320104, -122.379372242948)
185208 247934 2 5 1099 Esmeralda Ave 7 17 1 1     14     6010311.02519 2098743.98721 37.7433328939103 -122.406982672633 (37.7433328939103, -122.406982672633)
100593 115407 2 5 46 PROSPECT AVE 1 16 1 1     14 3x3   6007068.0 2099193.0 37.7443837739696 -122.41822807190901 (37.7443837739696, -122.418228071909)
99604 106503 2 5 3974 22nd St 1 14 1 1         Permit Number 773286 6002049.0 2102947.0 37.754407578182004 -122.435851245675 (37.754407578182, -122.435851245675)
106187 106504 2 5 3974 22nd St 2 14 1 1         Permit Number 773286 6002049.0 2102947.0 37.754407578182004 -122.435851245675 (37.754407578182, -122.435851245675)
107113 106505 2 5 3975 22nd St 1 14 1 1         Permit Number 773291 6002049.0 2102913.0 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122)
128960 106506 2 5 3975 22nd St 2 14 1 1         Permit Number 773291 6002049.0 2102913.0 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122)
30471 188564 2 5 300 Vermont St 4 13 1 1     21     6011131.87643 2106822.77201 37.7655613532939 -122.404712987912 (37.7655613532939, -122.404712987912)
34603 249714 2 5 2975 Broadway 3 13 1 1     20     5999388.9274 2116973.5904200003 37.7927695576174 -122.446059261445 (37.7927695576174, -122.446059261445)
35242 249713 2 5 2975 Broadway 2 13 1 1     15     5999382.51554 2116973.87968 37.792769985700296 -122.446081467494 (37.7927699857003, -122.446081467494)
35303 249715 2 5 2975 Broadway 4 13 1 1     18     5999395.51836 2116974.38878 37.7927721260745 -122.44603651397 (37.7927721260745, -122.44603651397)
133552 249874 2 5 230 Greenwich St 10 13 1 1     21 Width 0ft   6011664.0982800005 2120483.35155 37.803099833442296 -122.403833479743 (37.8030998334423, -122.403833479743)
155707 203875 2 5 41 Ralston St 3 13 1 1     7     5992168.26739 2088231.33888 37.7134358290799 -122.468950218092 (37.7134358290799, -122.468950218092)
157520 203877 2 5 41 Ralston St 6 13 1 1     23     5992177.10886 2088222.03993 37.7134108072361 -122.468918982843 (37.7134108072361, -122.468918982843)
160942 249712 2 5 2975 Broadway 1 13 1 1     21     5999372.04623 2116967.23886 37.792751153907204 -122.44611721373998 (37.7927511539072, -122.44611721374)
161892 203876 2 5 41 Ralston St 4 13 1 1     25     5992169.18145 2088225.46502 37.7134197536892 -122.468946631609 (37.7134197536892, -122.468946631609)
188029 249872 2 5 230 Greenwich St 8 13 1 1     9 Width 0ft   6011683.12279 2120489.80597 37.8031186185004 -122.403768099014 (37.8031186185004, -122.403768099014)
90127 89023 3 5 2x Hollywood Ct 1 12 1 2           6000329.0 2088600.0 37.714916215224 -122.440770357879 (37.714916215224, -122.440770357879)
6171 8616 3 5 2600 Geary Blvd 4 11 1 2     12 20   5999337.0471 2113224.2861 37.78247198716561 -122.44596898090299 (37.7824719871656, -122.445968980903)
6495 26421 3 5 2235X Octavia St 6 11 1 2     6 20   6004624.1328 2116974.76242 37.793070338586205 -122.427945300259 (37.7930703385862, -122.427945300259)
8054 14425 3 5 90X Masonic Ave 1 11 1 2     40 12   5998875.1013 2112962.0092 37.781725454134396 -122.447548220181 (37.7817254541344, -122.447548220181)
9882 173729 3 5 994 Carolina St 2 11 1 2     6 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
9888 173719 3 5 922 Carolina St 1 11 1 2     12 3x3   6012422.0 2103621.0 37.7568420188621 -122.40002584196199 (37.7568420188621, -122.400025841962)
9889 3743 3 5 906 Carolina St 2 11 1 2     18 18   6012418.0 2103694.0 37.757042237838796 -122.400044801952 (37.7570422378388, -122.400044801952)
9898 3765 3 5 1074 Carolina St 3 11 1 2     15 18   6012456.6037355 2102966.9856684 37.7550481677782 -122.39986024500799 (37.7550481677782, -122.399860245008)
9903 3758 3 5 1056 Carolina St 3 11 1 2     15 18   6012452.0863519 2103047.5184298 37.7552690413169 -122.399881522302 (37.7552690413169, -122.399881522302)
9906 173728 3 5 994 Carolina St 1 11 1 2     8 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
9908 3768 3 5 1098 Carolina St 1 11 1 2     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.39983195341699 (37.754754478768, -122.399831953417)
10951 24278 3 5 350X Winding Way 16 11 1 2     6 8   6000808.42529 2086790.5767400002 37.709975233345 -122.438983668972 (37.709975233345, -122.438983668972)
12225 24277 3 5 350X Winding Way 15 11 1 2     6 8   6000814.16949 2086790.4577099998 37.709975233345496 -122.43896380743999 (37.7099752333455, -122.43896380744)
13612 3695 3 5 400X Cargo Way 2 11 1 2     12 8   6017120.58643 2098873.01635 37.7440658827378 -122.383445712243 (37.7440658827378, -122.383445712243)
13675 18550 9 5 1700X Quesada Ave 5 11 1 2     30 19   6014656.2717 2095062.2920900001 37.733465912826 -122.391700443637 (37.733465912826, -122.391700443637)
13955 97226 3 5 1301X Newcomb Ave 6 11 1 2   09/30/2011 12:00:00 AM 3 15x200   6016643.51258 2094941.1276900002 37.7332433315076 -122.38482148523899 (37.7332433315076, -122.384821485239)
15352 97230 3 5 1301X Newcomb Ave 10 11 1 2     10 15x200   6016626.81073 2094919.21722 37.7331822459561 -122.38487770274999 (37.7331822459561, -122.38487770275)
15525 3745 3 5 900 Carolina St 4 11 1 2     6 18   6012461.71984 2103674.63492 37.7569915030708 -122.39989224135799 (37.7569915030708, -122.399892241358)
15842 97227 3 5 1301X Newcomb Ave 7 11 1 2     8 15x200   6016638.64484 2094938.128 37.733234825728296 -122.384838105605 (37.7332348257283, -122.384838105605)
16107 97223 3 5 1301X Newcomb Ave 3 11 1 2   09/30/2011 12:00:00 AM 3 15x200   6016661.55982 2094959.63165 37.733295137843 -122.384760378985 (37.733295137843, -122.384760378985)
16240 97228 3 5 1301X Newcomb Ave 8 11 1 2     6 15x200   6016642.6726 2094934.5266099998 37.733225159799204 -122.384823929606 (37.7332251597992, -122.384823929606)
16402 97222 3 5 1301X Newcomb Ave 2 11 1 2     24 15x200   6016676.72369 2094975.37763 37.733339211818105 -122.38470904929702 (37.7333392118181, -122.384709049297)
16543 15277 3 5 1563X Mission St 2 11 1 2   10/28/2016 12:00:00 AM 3 4X4 Permit Number 777705 6007250.560819999 2109703.40074 37.7732531819334 -122.418341887077 (37.7732531819334, -122.418341887077)
18211 11709 3 5 700X Junipero Serra Blvd 26 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991284.83406 2092750.4086799999 37.7257930014245 -122.472332875878 (37.7257930014245, -122.472332875878)
20854 11187 3 5 100 Idora Ave 3 11 1 2     12 8   5995309.2253 2099420.08132 37.7443383854121 -122.458903627104 (37.7443383854121, -122.458903627104)
21068 29972 3 5 500X Junipero Serra Blvd 16 11 1 2   04/01/2007 12:00:00 AM 3 3x3   5991341.172 2093706.68724 37.7284219643784 -122.47220779725299 (37.7284219643784, -122.472207797253)
21937 29584 3 5 500X Junipero Serra Blvd 17 11 1 2   02/12/2016 12:00:00 AM 3 3X3   5991345.88941 2093701.3780900002 37.728407659786 -122.47219110225299 (37.728407659786, -122.472191102253)
23028 97224 3 5 1301X Newcomb Ave 4 11 1 2   09/30/2011 12:00:00 AM 6 15x200   6016653.042219999 2094950.9325 37.733270780626995 -122.38478922115499 (37.733270780627, -122.384789221155)
23851 200603 3 5 1400x La Salle Ave 52 11 1 2     17 Width 0ft   6016419.7448 2095144.9307 37.733790555057 -122.38560931762301 (37.733790555057, -122.385609317623)
34139 200562 3 5 1400x La Salle Ave 38 11 1 2     13 Width 0ft   6016315.2256 2095489.7997 37.73473171245129 -122.385994706933 (37.7347317124513, -122.385994706933)
36772 175020 3 5 500x Mansell St 11 11 1 2     12 Width 0ft   6010396.843230001 2090323.76583 37.7202175482911 -122.40609285101401 (37.7202175482911, -122.406092851014)
38412 200551 3 5 1400x La Salle Ave 27 11 1 2     15 Width 0ft   6016216.4893 2095621.6927 37.735088399287 -122.38634526793001 (37.735088399287, -122.38634526793)
38644 200553 3 5 1400x La Salle Ave 29 11 1 2     6 Width 0ft   6016224.312999999 2095613.1578 37.7350653972301 -122.38631762348301 (37.7350653972301, -122.386317623483)
42056 200548 3 5 1400x La Salle Ave 24 11 1 2     13 Width 0ft   6016205.9984 2095634.3174 37.7351224834655 -122.38638241900699 (37.7351224834655, -122.386382419007)
42146 220273 3 5 500x 27th St 16 11 1 2     23 Width 4ft   6002878.6956 2100066.19718 37.746544669703106 -122.432776165093 (37.7465446697031, -122.432776165093)
42702 200540 3 5 1400x La Salle Ave 16 11 1 2     3 Width 0ft   6016179.8101 2095650.1621 37.7351645401576 -122.38647406665501 (37.7351645401576, -122.386474066655)
44175 99145 2 5 302X Pacheco St 29 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
46940 200568 3 5 1400x La Salle Ave 40 11 1 2     13 Width 0ft   6016324.0126 2095472.2809 37.7346840956345 -122.385963106208 (37.7346840956345, -122.385963106208)
49094 200518 3 5 1400x La Salle Ave 1 11 1 2     18 Width 0ft   6016087.5147 2095748.7503 37.7354301338826 -122.386800041299 (37.7354301338826, -122.386800041299)
49943 200538 3 5 1400x La Salle Ave 14 11 1 2     7 Width 0ft   6016175.1953 2095654.7768 37.7351769557335 -122.38649034349899 (37.7351769557335, -122.386490343499)
51216 200556 3 5 1400x La Salle Ave 32 11 1 2     4 Width 0ft   6016262.7203 2095558.3918 37.734917146653 -122.38618101771601 (37.734917146653, -122.386181017716)
54812 175058 3 5 1132x Alemany Blvd 2 11 1 2     1 Width 3ft   6003548.97454 2094354.07012 37.7308984688672 -122.430051002559 (37.7308984688672, -122.430051002559)
55316 200609 3 5 1400x La Salle Ave 49 11 1 2     1 Width 0ft   6016412.3996 2095168.4353 37.7338546875634 -122.385636349995 (37.7338546875634, -122.385636349995)
55546 200544 3 5 1400x La Salle Ave 20 11 1 2     11 Width 0ft   6016191.0622 2095640.0073 37.73513727999379 -122.38643445590401 (37.7351372799938, -122.386434455904)
58892 200537 3 5 1400x La Salle Ave 13 11 1 2     10 Width 0ft   6016177.7125 2095662.3283 37.735197829979 -122.38648216691001 (37.735197829979, -122.38648216691)
59915 200610 3 5 1400x La Salle Ave 50 11 1 2     4 Width 0ft   6016417.2964 2095161.5798 37.733836134681795 -122.385618942498 (37.7338361346818, -122.385618942498)
62523 220272 3 5 500x 27th St 13 11 1 2     10 Width 4ft   6002834.52979 2100065.9287400004 37.7465414276535 -122.432928866369 (37.7465414276535, -122.432928866369)
62628 200574 3 5 1400x La Salle Ave 44 11 1 2     1 Width 0ft   6016364.4111 2095326.6015 37.734286324847005 -122.385813282871 (37.734286324847, -122.385813282871)
63458 220274 3 5 500x 27th St 23 11 1 2     10 Width 4ft   6002921.47786 2100071.21628 37.7465608772933 -122.43262858725299 (37.7465608772933, -122.432628587253)
69094 200554 3 5 1400x La Salle Ave 30 11 1 2     14 Width 0ft   6016223.9574 2095601.7778 37.7350341303539 -122.386318059776 (37.7350341303539, -122.386318059776)
73683 203961 3 5 200x Dorantes Ave 1 11 1 2     38 Width 3ft   5993559.03115 2099734.05216 37.745099710091296 -122.4649781788 (37.7450997100913, -122.4649781788)
Powered by Datasette · Query took 29.429ms · Data source: data.sfgov.org