sf-trees

Data source: data.sfgov.org

Custom SQL query returning 36 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92 98091 3 35 2X Frank Norris St 4 1 1 4 2   3 3x3   6007129.633230001 2115568.12393 37.789349482642606 -122.41917628075599 (37.7893494826426, -122.419176280756)
2229 43306 3 133 693 Vermont St 12 1 1 4 2 07/12/2000 12:00:00 AM 22   Permit Number 43072 6011289.47877 2105149.93268 37.7609769197604 -122.404050137204 (37.7609769197604, -122.404050137204)
2613 98090 3 35 2X Frank Norris St 3 1 1 4 2   3 3x3   6007144.43128 2115568.9527 37.7893525915946 -122.419125139911 (37.7893525915946, -122.419125139911)
4558 142520 3 16 301 FRANCISCO ST 3 1 1 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145)
4605 142542 3 16 301 FRANCISCO ST 1 1 1 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
4611 142519 3 16 301 FRANCISCO ST 2 1 1 4     6 Width 0ft   6009452.9889 2121171.5596 37.804865708173104 -122.411533760714 (37.8048657081731, -122.411533760714)
4622 142543 3 16 301 FRANCISCO ST 5 1 1 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924)
4753 98088 3 35 2X Frank Norris St 1 1 1 4 2   3 3x3   6007178.15894 2115574.08384 37.7893685797349 -122.41900880992901 (37.7893685797349, -122.419008809929)
7387 98089 3 35 2X Frank Norris St 2 1 1 4 2   3 3x3   6007160.90241 2115572.1732 37.789362361841505 -122.41906838009899 (37.7893623618415, -122.419068380099)
10557 37839 3 35 451 Athens St 3 1 1 4 2 07/07/1998 12:00:00 AM 3 4x6 Permit Number 40134 6003658.0147400005 2090473.5929 37.720249717041504 -122.42939741397 (37.7202497170415, -122.42939741397)
11797 37838 3 35 451 Athens St 2 1 1 4 2 07/07/1998 12:00:00 AM 3 4x6 Permit Number 40134 6003644.26117 2090451.27602 37.720187661114295 -122.429443364835 (37.7201876611143, -122.429443364835)
12710 37830 3 35 451 Athens St 1 1 1 4 2 07/09/2007 12:00:00 AM 3 6x6 Permit Number 49480 6003635.85955 2090436.9204099998 37.7201477680848 -122.429471383195 (37.7201477680848, -122.429471383195)
13085 37840 3 35 451 Athens St 4 1 1 4 2 07/09/2007 12:00:00 AM 3 4x6 Permit Number 49480 6003672.4294 2090496.5417099998 37.7203135455184 -122.42934922289801 (37.7203135455184, -122.429349222898)
16818 51361 3 237 50 Pomona St 11 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014122.20154 2094470.50183 37.7318113167403 -122.39350548730499 (37.7318113167403, -122.393505487305)
77433 31711 3 16 1250X Shrader St 8 1 1 4 2 06/19/1995 12:00:00 AM 6 3x3 Permit Number 35211 5997882.313818 2106467.94501531 37.763837639523395 -122.450514467435 (37.7638376395234, -122.450514467435)
87567 100981 3 468 2190 Powell St 2 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
87723 43903 1 35 1050 York St 2 1 1 4   04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.755232893914794 -122.408509176777 (37.7552328939148, -122.408509176777)
89035 100982 3 468 2190 Powell St 3 1 1 4 4 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
93623 94948 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
97910 100983 3 16 2190 Powell St 4 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
100074 43904 1 35 1050 York St 3 1 1 4 2 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.755232893914794 -122.408509176777 (37.7552328939148, -122.408509176777)
101459 98790 3 18 950x CLAY ST 5 1 1 4 2     3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
103824 94947 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
105255 98564 3 16 301X Francisco St 2 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
107842 100984 3 16 2190 Powell St 5 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
108801 98744 2 16 540X Eureka St 1 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
112530 98567 3 16 301X Francisco St 5 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
114698 94946 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
119959 100985 3 18 2190 Powell St 6 1 1 4 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
120907 78998 2 18 450X Banks St 1 1 1 4 2 06/18/1994 12:00:00 AM 6 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
123219 98563 3 16 301X Francisco St 1 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
136374 116064 3 133 693 Vermont St 1 1 1 4 2   6 8x7   6011272.30638 2105412.17877 37.761696029365794 -122.404127986133 (37.7616960293658, -122.404127986133)
138890 98565 3 16 301X Francisco St 3 1 1 4 2     3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
140818 100980 3 468 2190 Powell St 1 1 1 4 4 05/03/2013 12:00:00 AM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
145388 100987 3 16 2190 Powell St 8 1 1 4 4     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
146100 43905 1 35 1050 York St 1 1 1 4 2 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.755232893914794 -122.408509176777 (37.7552328939148, -122.408509176777)
Powered by Datasette · Query took 21.106ms · Data source: data.sfgov.org