sf-trees

Data source: data.sfgov.org

Custom SQL query returning 30 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2276 252994 1 73 1201 Tennessee St 3 1 1 1   07/10/2017 12:00:00 AM 3     6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
3405 180669 2 73 171 Winding Way 3 2 1 1     0 Width 6ft   6002170.184219999 2086635.71157 37.70962739445179 -122.434266111507 (37.7096273944518, -122.434266111507)
4134 216704 2 73 251 Faxon Ave 3 1 1 1   10/06/2017 08:35:00 AM 3 Width 2ft   5994715.27121 2090263.18688 37.719161630891705 -122.46029406262699 (37.7191616308917, -122.460294062627)
4205 251774 2 73 120 Seville St 3 2 1 1   10/10/2017 10:14:00 AM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4722 160433 2 73 401 France Ave 3 1 1 1 1 10/24/2017 12:12:00 PM 3 Width 0ft   6002070.28716 2089835.8834 37.7184086896908 -122.43484007413 (37.7184086896908, -122.43484007413)
4838 243005 2 73 301 Dolores St 3 1 1 1     0 Width 6ft   6004912.59389 2106510.6516400003 37.7643547760633 -122.42620188801001 (37.7643547760633, -122.42620188801)
26639 117155 2 73 701 Pennsylvania Ave 3 1 1 1     8 3x3   6014460.76675 2103748.99279 37.757306918684 -122.392983929988 (37.757306918684, -122.392983929988)
31110 101612 1 73 681 San Bruno Ave 3 1 1 1     8 7x5   6011003.086019999 2105162.84205 37.7609963604006 -122.40504155884399 (37.7609963604006, -122.405041558844)
36116 75673 2 73 618X Missouri St 3 1 1 1 1 08/03/1996 12:00:00 AM 7     6013545.06469 2104202.26889 37.7585006086339 -122.396182576568 (37.7585006086339, -122.396182576568)
37611 230424 2 73 387 Shotwell St 3 1 1 1     3 Width 3ft   6007831.12637 2105698.0394200003 37.76228806116921 -122.41604991899099 (37.7622880611692, -122.416049918991)
44441 230406 2 73 701 Potrero Ave 3 1 1 1     7 Width 3ft   6010469.85138 2104738.84531 37.7598023377254 -122.406855910494 (37.7598023377254, -122.406855910494)
53201 230399 2 73 635 Potrero Ave 3 1 1 1     2 Width 5ft   6010446.039030001 2105294.43136 37.761326519519 -122.406977425991 (37.761326519519, -122.406977425991)
55809 123781 2 73 1100 Cabrillo St 3 1 1 1     5 Width 3ft   5992148.272480001 2110704.3151 37.775139717422704 -122.47065517411998 (37.7751397174227, -122.47065517412)
58655 202021 2 73 1330 Fitzgerald Ave 3 4 1 1     4 Width 3ft   6013834.37055 2091185.2446599999 37.722774667999 -122.39427065747101 (37.722774667999, -122.394270657471)
61446 230417 2 73 1301 San Jose Ave 3 1 1 1     3 Width 3ft   6003609.08364 2095506.47935 37.7340661284367 -122.42992536726801 (37.7340661284367, -122.429925367268)
70356 193410 2 73 551 Utah St 3 1 1 1     3 Width 3ft   6010705.60274 2105553.4377099997 37.762052213957794 -122.40609794748501 (37.7620522139578, -122.406097947485)
107887 93247 3 73 990 Church St 3 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
119799 94256 2 73 2777X 19th St 3 1 1 1     9 3x3   6009684.4 2104752.7 37.7597963985886 -122.40957339028499 (37.7597963985886, -122.409573390285)
123112 18993 1 73 2965 Sacramento St 3 1 1 1   04/08/1999 12:00:00 AM 3 3X3   6000621.16815 2115478.56365 37.7887348935356 -122.441688325582 (37.7887348935356, -122.441688325582)
124081 93240 3 73 600X Church St 3 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004217.7 2105335.5 37.761088789181 -122.428521561971 (37.761088789181, -122.428521561971)
126378 45656 1 73 501 Irving St 3 1 1 1   03/24/2011 12:00:00 AM     Permit Number 767754 5994244.0 2106639.0 37.764098399310704 -122.463110607355 (37.7640983993107, -122.463110607355)
128958 100007 2 73 501X Mission St 3 10 1 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339)
130484 193429 2 73 1151 22nd St 3 1 1 1     6 Width 3ft   6014506.85634 2103858.18885 37.7576093076281 -122.39283217206699 (37.7576093076281, -122.392832172067)
138541 230402 2 73 995 Potrero Ave 3 4 1 1     7 Width 4ft   6010527.0507 2103856.48907 37.7573827855076 -122.406595905697 (37.7573827855076, -122.406595905697)
145552 96632 1 73 1212 10th Ave 3 1 1 1   06/14/2011 12:00:00 AM     Permit Number 767886 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359)
151479 193416 2 73 1425 Indiana St 3 1 1 1     5 Width 4ft   6015128.54714 2101843.94886 37.75211314410829 -122.390541350608 (37.7521131441083, -122.390541350608)
154854 177455 2 73 1651 San Jose Ave 3 1 1 1     4 Width 2ft   6001518.96973 2094154.72477 37.7302359329302 -122.43705478235701 (37.7302359329302, -122.437054782357)
172396 193422 2 73 501 18th St 3 1 1 1     7 Width 3ft   6015855.7958 2105797.31045 37.763008553013 -122.388302284235 (37.763008553013, -122.388302284235)
183298 193436 2 73 608 Missouri St 3 4 1 1     5 Width 3ft   6013540.38062 2104266.7592 37.758677424352896 -122.39620329606899 (37.7586774243529, -122.396203296069)
186395 193434 2 73 598 Missouri St 3 4 1 1     6 Width 3ft   6013537.98707 2104307.6187400003 37.758789482567295 -122.396214437761 (37.7587894825673, -122.396214437761)
Powered by Datasette · Query took 3.386ms · Data source: data.sfgov.org