sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3721 36883 1 197 2515 Fillmore St 3 1 1 1   11/23/2016 12:00:00 AM 3   Permit Number 779178 6002662.87522 2116961.2420799998 37.792922065545504 -122.43473038919501 (37.7929220655455, -122.434730389195)
3779 61682 1 197 27 Ceres St 3 1 1 1 1 01/12/1985 12:00:00 AM 4   Permit Number 21679 6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
19658 103913 1 197 6025 03rd St 14 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
20296 103912 1 197 6025 03rd St 13 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
21889 16054 1 197 215 Monterey Blvd 1 1 1 1   02/11/2000 12:00:00 AM 3 3X3   6000626.0327699995 2094620.4537900002 37.7314639212093 -122.440175160965 (37.7314639212093, -122.440175160965)
23823 42743 1 197 295 Tocoloma Ave 2 1 1 1   06/26/2000 12:00:00 AM 6   Permit Number 42737 6012647.1314 2087116.87515 37.7115376741026 -122.398089440585 (37.7115376741026, -122.398089440585)
25505 37639 1 197 574 09th Ave 1 1 1 1 1 06/26/1998 12:00:00 AM 6   Permit Number 40056 5993171.91156 2111565.06758 37.7775622521226 -122.467176805707 (37.7775622521226, -122.467176805707)
36240 50010 1 197 1465@ 26th ST Rhode Island St 1 1 1 1 1 07/25/2003 12:00:00 AM 7   Permit Number 46741 6012041.28455 2101546.95627 37.7511259142534 -122.401196767325 (37.7511259142534, -122.401196767325)
36954 56424 1 197 279 18th Ave 1 1 1 1   06/27/2011 12:00:00 AM 4   Permit Number 767957 5990232.5043 2113517.65935 37.7827534137466 -122.477487840106 (37.7827534137466, -122.477487840106)
37206 64452 1 197 2255 Mariposa St 1 1 1 1 1 09/17/1994 12:00:00 AM 6   Permit Number 49675 6010720.79087 2105970.79652 37.763199036616996 -122.40607482140499 (37.763199036617, -122.406074821405)
38347 103902 1 197 6025 03rd St 3 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
54894 69414 1 197 77 Seville St 1 1 1 1 1 05/09/1994 12:00:00 AM 8   Permit Number 33519 6001938.39138 2087385.6198099998 37.711673318833796 -122.435120827182 (37.7116733188338, -122.435120827182)
62894 50307 1 197 755 Wisconsin St 1 1 1 1   09/22/2003 12:00:00 AM 6   Permit Number 47018 6012755.49383 2104002.55412 37.7579082710796 -122.398899267499 (37.7579082710796, -122.398899267499)
64439 67487 1 197 1715 20th St 1 1 1 1 1 09/08/1992 12:00:00 AM 3   Permit Number 31011 6012862.87074 2104700.41126 37.759830416353296 -122.398576880337 (37.7598304163533, -122.398576880337)
68970 31151 1 197 666 Hearst Ave 1 1 1 1 1 03/21/1995 12:00:00 AM 6   Permit Number 34854 5997015.55395 2094425.7402599999 37.7307230695921 -122.45264315945299 (37.7307230695921, -122.452643159453)
72322 31150 1 197 666 Hearst Ave 2 1 1 1 1 03/21/1995 12:00:00 AM 6   Permit Number 34854 5996999.96036 2094426.5225799999 37.730724324156704 -122.452697125077 (37.7307243241567, -122.452697125077)
81102 94349 1 197 1265@ Waller St Masonic Ave 1 1 1 1       3x3   5999439.6 2108532.0 37.7695940252359 -122.445276718787 (37.7695940252359, -122.445276718787)
86086 103907 1 197 6025 03rd St 8 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
90361 88617 1 197 2494 47th Ave   1 1 1   08/04/2008 12:00:00 AM   3x3 Permit Number 51590 5981831.2 2098131.1 37.740015242507 -122.505411474316 (37.740015242507, -122.505411474316)
91472 94355 1 197 1265@ Waller St Masonic Ave 7 1 1 1   07/19/2010 12:00:00 AM   3x3 Permit Number 53635 5999439.6 2108532.0 37.7695940252359 -122.445276718787 (37.7695940252359, -122.445276718787)
94145 103911 1 197 6025 03rd St 12 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
100077 103909 1 197 6025 03rd St 10 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
107558 103901 1 197 6025 03rd St 2 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
109731 103908 1 197 6025 03rd St 9 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
117707 94350 1 197 1265@ Waller St Masonic Ave 2 1 1 1       3x3   5999439.6 2108532.0 37.7695940252359 -122.445276718787 (37.7695940252359, -122.445276718787)
118191 103906 1 197 6025 03rd St 7 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
120276 103903 1 197 6025 03rd St 4 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
121635 94353 1 197 1265@ Waller St Masonic Ave 5 1 1 1       3x3   5999439.6 2108532.0 37.7695940252359 -122.445276718787 (37.7695940252359, -122.445276718787)
124611 103905 1 197 6025 03rd St 6 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
128312 103900 1 197 6025 03rd St 1 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
128683 94354 1 197 1265@ Waller St Masonic Ave 6 1 1 1       3x3   5999439.6 2108532.0 37.7695940252359 -122.445276718787 (37.7695940252359, -122.445276718787)
129119 94351 1 197 1265@ Waller St Masonic Ave 3 1 1 1       3x3   5999439.6 2108532.0 37.7695940252359 -122.445276718787 (37.7695940252359, -122.445276718787)
132267 38192 1 197 715 Girard St 1 1 1 1 1 07/17/1998 12:00:00 AM 6   Permit Number 40321 6011331.34824 2091527.76082 37.72357569684971 -122.40294719786002 (37.7235756968497, -122.40294719786)
138663 94352 1 197 1265@ Waller St Masonic Ave 4 1 1 1       3x3   5999439.6 2108532.0 37.7695940252359 -122.445276718787 (37.7695940252359, -122.445276718787)
138857 103904 1 197 6025 03rd St 5 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
144807 103910 1 197 6025 03rd St 11 9 1 1   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451.0 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675)
151056 41175 1 197 2435 Bay St 1 1 1 1 1 11/23/1999 12:00:00 AM 4   Permit Number 41894 5999108.60374 2120208.9624099997 37.801637012407106 -122.44726215142799 (37.8016370124071, -122.447262151428)
165427 34706 1 197 640 46th Ave 1 1 1 1 1 07/28/1997 12:00:00 AM 4   Permit Number 38363 5981668.46483 2111340.0522 37.776273682439 -122.50695369625299 (37.776273682439, -122.506953696253)
166758 51342 1 197 2121 Jackson St 1 1 1 1   09/30/2004 12:00:00 AM 4   Permit Number 47688 6004025.96964 2116952.58925 37.7929755986043 -122.430013396525 (37.7929755986043, -122.430013396525)
173871 35481 1 197 1011 Silliman St 2 1 1 1   03/18/1998 12:00:00 AM 9   Permit Number 38892 6007771.76175 2093386.17164 37.7284790839175 -122.415383596892 (37.7284790839175, -122.415383596892)
184394 31994 1 197 115 06th Ave 1 1 1 1 1 06/30/1995 12:00:00 AM 4   Permit Number 35395 5993939.00756 2114733.42644 37.786305958853895 -122.464753322645 (37.7863059588539, -122.464753322645)
187272 45474 1 197 1349 Cayuga Ave 1 1 1 1 1 07/19/2001 12:00:00 AM 4   Permit Number 44253 5999367.63833 2089888.0893 37.718398218877 -122.444185721794 (37.718398218877, -122.444185721794)
188086 65745 1 197 242 Curtis St 1 1 1 1 1 04/20/1990 12:00:00 AM 10   Permit Number 28704 6000840.51659 2087219.5194400002 37.7111548407988 -122.43890347461 (37.7111548407988, -122.43890347461)
188310 35816 1 197 448 Brussels St 1 1 1 1 1 07/12/2000 12:00:00 AM 5   Permit Number 43043 6010644.99759 2092590.80492 37.7264562451386 -122.405394631775 (37.7264562451386, -122.405394631775)
3056 223292 2 197 101X Downey St 1 1 1 1     7 Width 3ft   5998862.7522 2107587.12928 37.766966704981996 -122.447203994986 (37.766966704982, -122.447203994986)
3058 223293 2 197 101X Downey St 2 1 1 1     9 Width 3ft   5998863.8718 2107567.85033 37.7669138338245 -122.44719873483601 (37.7669138338245, -122.447198734836)
22358 122197 2 197 131 14th Ave 2 1 1 1     6 Width 3ft   5991469.09784 2114541.60598 37.7856365655774 -122.47328449533899 (37.7856365655774, -122.473284495339)
22363 223333 2 197 203 Randall St 1 1 1 1     6 Width 3ft   6004237.41218 2097504.4182 37.7395875791097 -122.42789535729099 (37.7395875791097, -122.427895357291)
23388 191040 2 197 1301 Minnesota St 35 7 1 1     15     6015380.38588 2102504.53618 37.75394094514021 -122.389716581452 (37.7539409451402, -122.389716581452)
23859 223337 2 197 21 Poppy Ln 1 13 1 1     5 Width 2ft   6002002.72042 2096679.5859400001 37.737196106421706 -122.435562951888 (37.7371961064217, -122.435562951888)
24113 223308 2 197 4645 19th St 1 1 1 1     3 Width 3ft   6000449.27846 2104630.8077 37.7589399004855 -122.44150430050199 (37.7589399004855, -122.441504300502)
24238 223314 2 197 737 Sanchez St 10 2 1 1     4 Width 3ft   6003692.0750400005 2104158.0805900004 37.7578261171073 -122.43025546792101 (37.7578261171073, -122.430255467921)
24737 207467 2 197 555 Flood Ave 5 9 1 1     1 Width 10ft   5997138.67547 2094084.4213299998 37.7297929430915 -122.452192893201 (37.7297929430915, -122.452192893201)
24777 123037 2 197 598 Funston Ave 1 2 1 1     4 Width 3ft   5991936.90153 2111420.91872 37.777095091129105 -122.471438573307 (37.7770950911291, -122.471438573307)
24868 223297 2 197 216 Precita Ave 1 1 1 1     4 Width 3ft   6007815.61312 2100277.20089 37.747402801003204 -122.41571972750201 (37.7474028010032, -122.415719727502)
24928 223320 2 197 4404 20th St 5 23 1 1     6 Width 3ft   6003607.3788 2104219.57182 37.7579901597246 -122.430552770305 (37.7579901597246, -122.430552770305)
25470 223317 2 197 4404 20th St 2 23 1 1     3 Width 3ft   6003628.73131 2104227.65103 37.7580135529078 -122.430479500748 (37.7580135529078, -122.430479500748)
25525 223307 2 197 300 Hill St 4 1 1 1     3 Width 3ft   6004278.85639 2103386.69911 37.755741304225396 -122.428171160475 (37.7557413042254, -122.428171160475)
25855 176183 2 197 500 Geneva Ave 1 9 1 1     8 Width 5ft   5998729.89326 2090676.55478 37.7205267594696 -122.446446824275 (37.7205267594696, -122.446446824275)
25878 207430 2 197 1550 15th Ave 3 2 1 1     10     5991564.83032 2104929.84825 37.759250823982605 -122.47225238743601 (37.7592508239826, -122.472252387436)
26062 247051 2 197 519 Valley St 1 4 1 1     1 Width 3ft   6002519.90495 2099141.5459 37.743985438385295 -122.43395073994499 (37.7439854383853, -122.433950739945)
26100 201969 2 197 1651 Carroll Ave 22 9 1 1     3 Width 10ft   6013782.624009999 2092181.31295 37.725506794893896 -122.394519248986 (37.7255067948939, -122.394519248986)
26369 201988 2 197 1651 Carroll Ave 3 9 1 1     4     6013586.6338 2092298.57883 37.7258178856713 -122.39520498563 (37.7258178856713, -122.39520498563)
26383 207515 2 197 71 Melrose Ave 1 9 1 1     1     5999632.40668 2095469.97761 37.7337398948819 -122.443671310503 (37.7337398948819, -122.443671310503)
26691 222522 2 197 791 27th St 3 10 1 1     7 Width 5ft   6001439.60059 2099957.7516 37.7461651800752 -122.43774462443899 (37.7461651800752, -122.437744624439)
26765 207471 2 197 555 Flood Ave 8 9 1 1     1 Width 10ft   5997138.11204 2094076.47997 37.7297711057327 -122.45219426825399 (37.7297711057327, -122.452194268254)
26792 223897 2 197 1000 Dolores St 11 1 1 1     4 Width 2ft   6005050.02816 2102464.15698 37.753251821628204 -122.42543854974899 (37.7532518216282, -122.425438549749)
27218 223299 2 197 267 San Jose Ave 2 1 1 1     4 Width 3ft   6006192.90217 2101673.64979 37.7511457766604 -122.4214301167 (37.7511457766604, -122.4214301167)
27379 207465 2 197 555 Flood Ave 2 9 1 1     1 Width 10ft   5997138.25418 2094089.75184 37.729807555268295 -122.452194734107 (37.7298075552683, -122.452194734107)
27710 247815 2 197 536 30th St 1 4 1 1     2 Width 3ft   6003101.83098 2098352.54128 37.7418520216442 -122.43188224706101 (37.7418520216442, -122.431882247061)
28382 207524 2 197 266 Judson Ave 2 9 1 1     6     5998309.1596 2093573.15338 37.728456103557896 -122.448109616788 (37.7284561035579, -122.448109616788)
28400 207500 2 197 145 Casitas Ave 1 1 1 1     6 Width 3ft   5995396.1404800005 2096963.9149 37.73759935523479 -122.458425341581 (37.7375993552348, -122.458425341581)
28548 223916 2 197 588 Ogden Ave 5 10 1 1     1 Width 4ft   6007765.411040001 2096148.4497200001 37.736063342858 -122.415601045774 (37.736063342858, -122.415601045774)
29457 223906 2 197 1000 Dolores St 21 1 1 1     5 Width 2ft   6005052.89667 2102434.79152 37.7531713529793 -122.42542654021901 (37.7531713529793, -122.425426540219)
29667 176185 2 197 500 Geneva Ave 6 9 1 1     7 Width 5ft   5998832.19664 2090623.5038299998 37.7203869364761 -122.446089381522 (37.7203869364761, -122.446089381522)
30038 207511 2 197 300 Mangels Ave 9 9 1 1     1     5999356.36789 2095270.9974099998 37.733177794305 -122.44461135834601 (37.733177794305, -122.444611358346)
30335 223901 2 197 1000 Dolores St 16 1 1 1     3 Width 2ft   6005051.96111 2102449.00234 37.753210319725106 -122.425430786811 (37.7532103197251, -122.425430786811)
30834 222515 2 197 1445 Douglass St 3 9 1 1     6 Width 4ft   6001418.004509999 2099470.26771 37.7448254366625 -122.43778439245001 (37.7448254366625, -122.43778439245)
31618 222513 2 197 1445 Douglass St 1 9 1 1     8 Width 4ft   6001419.9831 2099436.11309 37.7447317686527 -122.43777510514 (37.7447317686527, -122.43777510514)
31908 207496 2 197 426 Bright St 1 9 1 1     3     5993791.26805 2090028.04623 37.7184627965046 -122.46347090877899 (37.7184627965046, -122.463470908779)
33336 117665 2 197 4739 Anza St 2 1 1 1     13 Width 2ft   5983866.28213 2111708.82719 37.7774154190485 -122.49937821872601 (37.7774154190485, -122.499378218726)
33489 223330 2 197 71 Randall St 1 1 1 1     5 Width 3ft   6005065.72447 2097560.7917400002 37.73978919271671 -122.425035418766 (37.7397891927167, -122.425035418766)
33695 117663 2 197 4739 Anza St 4 1 1 1     9 Width 2ft   5983899.75591 2111710.53343 37.7774220677076 -122.499262549855 (37.7774220677076, -122.499262549855)
34556 176189 2 197 500 Geneva Ave 11 9 1 1     4 Width 5ft   5998893.49045 2090593.19981 37.7203072286757 -122.445875331189 (37.7203072286757, -122.445875331189)
34784 207435 2 197 1550 15th Ave 8 2 1 1     10     5991562.287830001 2104945.46167 37.759293547166 -122.472262318665 (37.759293547166, -122.472262318665)
35272 223291 2 197 271 Bemis St 1 9 1 1     3 Width 4ft   6002969.0531 2096218.7937599998 37.7359857142716 -122.432189003136 (37.7359857142716, -122.432189003136)
35988 222510 2 197 123 Marsily St 3 9 1 1     6 Width 2ft   6004279.53355 2095213.5865099998 37.7332998565836 -122.427586552585 (37.7332998565836, -122.427586552585)
36355 191048 2 197 508 Missouri St 4 4 1 1     2 Width 8ft   6013509.22069 2104630.04045 37.759673181581796 -122.396336524335 (37.7596731815818, -122.396336524335)
36540 207466 2 197 555 Flood Ave 3 9 1 1     1 Width 10ft   5997138.05021 2094086.70842 37.7297991870776 -122.452195219742 (37.7297991870776, -122.452195219742)
37079 207498 2 197 1315 Plymouth Ave 1 1 1 1     5 Width 3ft   5995864.997719999 2092813.12874 37.726229233786704 -122.45650421791099 (37.7262292337867, -122.456504217911)
37144 126467 2 197 2711 Clay St 1 1 1 1     12 Width 4ft   6001788.68499 2115988.81164 37.7902023547025 -122.437685450844 (37.7902023547025, -122.437685450844)
37542 223915 2 197 588 Ogden Ave 4 10 1 1     2 Width 4ft   6007768.9471 2096146.5978599999 37.73605845682229 -122.415588689077 (37.7360584568223, -122.415588689077)
38078 223907 2 197 1000 Dolores St 22 1 1 1     5 Width 2ft   6005052.86926 2102433.4593700003 37.7531676936567 -122.425426540214 (37.7531676936567, -122.425426540214)
38165 223321 2 197 4404 20th St 6 23 1 1     6 Width 3ft   6003607.59341 2104210.2360400003 37.757964538052796 -122.430551361954 (37.7579645380528, -122.430551361954)
39053 201987 2 197 1651 Carroll Ave 5 9 1 1     3 Width 5ft   6013596.70102 2092297.48635 37.7258154458067 -122.39517010723301 (37.7258154458067, -122.395170107233)
39353 176191 2 197 500 Geneva Ave 14 9 1 1     12 Width 5ft   5998925.79803 2090576.3375099998 37.7202627733854 -122.44576244287799 (37.7202627733854, -122.445762442878)
39981 207473 2 197 549 Flood Ave 2 9 1 1     1 Width 10ft   5997163.92167 2094087.8656099997 37.729803846463795 -122.45210586311 (37.7298038464638, -122.45210586311)
40162 223298 2 197 352 Shotwell St 1 1 1 1     3 Width 3ft   6007782.782930001 2105864.77472 37.7627431594916 -122.416228930816 (37.7627431594916, -122.416228930816)
41331 223920 2 197 603 San Jose Ave 1 1 1 1     1 Width 3ft   6006073.38987 2099874.4724 37.7461989073679 -122.421715625397 (37.7461989073679, -122.421715625397)
41608 207494 2 197 589 Arch St 4 9 1 1     7 Width 10ft   5992718.62693 2091039.53667 37.7211782436554 -122.467252058845 (37.7211782436554, -122.467252058845)
41726 247864 2 197 399 Mayflower St 1 17 1 1     1     6009555.15097 2098432.68764 37.742435806664794 -122.409574335293 (37.7424358066648, -122.409574335293)
Powered by Datasette · Query took 6.133ms · Data source: data.sfgov.org