sf-trees

Data source: data.sfgov.org

Custom SQL query returning 49 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
12240 44475 1 51 275 Harvard St 1 1 1 1 1 03/26/2001 12:00:00 AM 8 3x3 Permit Number 43789 6006290.74635 2092615.37122 37.726279281939895 -122.42044886282301 (37.7262792819399, -122.420448862823)
20785 856 3 51 400X Alemany Blvd 2 1 1 2   04/19/2001 12:00:00 AM 8 3x3   6008178.91279 2095102.6011299998 37.7332149048351 -122.414097431452 (37.7332149048351, -122.414097431452)
23782 219426 2 51 1426 16th Ave 1 1 1 1     8 Width 3ft   5991173.89859 2105672.02771 37.7612660194265 -122.473658544928 (37.7612660194265, -122.473658544928)
27967 44472 1 51 236 Harvard St 1 1 1 1 1 03/26/2001 12:00:00 AM 8   Permit Number 43786 6006212.75467 2092719.23658 37.726560078178395 -122.420725846847 (37.7265600781784, -122.420725846847)
31207 198409 2 51 50 Washburn St 2 1 1 1     8 Width 2ft   6008437.7646 2110373.29523 37.7751593120891 -122.41428258206801 (37.7751593120891, -122.414282582068)
33652 180465 2 51 599 University St 33 1 1 1     8 Width 3ft   6008194.47669 2092552.7848 37.7262145316512 -122.413863317257 (37.7262145316512, -122.413863317257)
38435 136931 2 51 3825 Scott St 4 1 1 1     8 Width 5ft   6000586.31642 2121417.2428200003 37.805038952541295 -122.442235392672 (37.8050389525413, -122.442235392672)
38608 180407 2 51 314 Cayuga Ave 1 9 1 1     8 Width 3ft   6002242.22225 2094108.3589599999 37.7301497068323 -122.434551091376 (37.7301497068323, -122.434551091376)
38853 70336 2 51 324 Silliman St 1 1 1 1 1 04/30/1994 12:00:00 AM 8     6009735.9866 2094035.87413 37.7303732333298 -122.408638954927 (37.7303732333298, -122.408638954927)
44658 180462 2 51 599 University St 30 1 1 1     8 Width 3ft   6008228.9593 2092440.66794 37.725908619167704 -122.413736185485 (37.7259086191677, -122.413736185485)
45366 70407 2 51 231 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 8     6006535.83698 2092862.23217 37.7269709172726 -122.419619102459 (37.7269709172726, -122.419619102459)
56808 47721 1 51 2325 Union St 1 1 1 1 1 09/28/2002 12:00:00 AM 8   Permit Number 45805 6001839.98608 2118371.66878 37.7967479784971 -122.437678679828 (37.7967479784971, -122.437678679828)
57296 47722 1 51 2325 Union St 2 1 1 1 1 09/28/2002 12:00:00 AM 8   Permit Number 45805 6001852.4852599995 2118373.09609 37.796752608195796 -122.437635532153 (37.7967526081958, -122.437635532153)
58632 180467 2 51 599 University St 35 1 1 1     8 Width 3ft   6008177.51533 2092609.86875 37.72637031941721 -122.413925988288 (37.7263703194172, -122.413925988288)
58932 40193 1 51 3430 Scott St 1 1 1 1   04/30/1999 12:00:00 AM 8   Permit Number 41376 6000802.81629 2120169.1836 37.801624451566894 -122.441396561715 (37.8016244515669, -122.441396561715)
59288 219438 2 51 2551 15th Ave 1 1 1 1     8 Width 3ft   5991712.62848 2098073.6420400003 37.74043401203279 -122.471241703239 (37.7404340120328, -122.471241703239)
60291 180468 2 51 599 University St 36 1 1 1     8 Width 3ft   6008161.02959 2092664.87988 37.7265204423377 -122.413986868806 (37.7265204423377, -122.413986868806)
65259 136914 2 51 2325 Union St 3 1 1 1     8 Width 3ft   6001866.38234 2118375.10794 37.7967589223518 -122.437587589309 (37.7967589223518, -122.437587589309)
65789 219445 2 51 332 Congo St 2 1 1 1     8 Width 3ft   6000112.34279 2094905.0087400002 37.73221598377361 -122.441971496493 (37.7322159837736, -122.441971496493)
71395 136927 2 51 3835 Scott St 3 1 1 1     8 Width 5ft   6000575.8794 2121488.3697200003 37.8052336530829 -122.44227662028 (37.8052336530829, -122.44227662028)
97843 29758 3 51 699X Green St 2 1 1 2     8 3x3   6009685.79902 2119118.10904 37.7992404975665 -122.41058299614099 (37.7992404975665, -122.410582996141)
116305 26040 3 51 32 Broad St 9 1 1 2   06/03/2015 12:00:00 AM 8 3x3   5996258.07972 2088089.3008299998 37.7132812744111 -122.45480421322901 (37.7132812744111, -122.454804213229)
118573 120668 2 51 1154 Clayton St 1 1 1 1     8 3x3   5998951.0 2105925.0 37.76240795737721 -122.44677915122601 (37.7624079573772, -122.446779151226)
130711 75004 2 51 101 Laurel St 1 1 1 1 1 02/10/1996 12:00:00 AM 8     5997965.54363 2116098.57851 37.7902856238171 -122.450921084564 (37.7902856238171, -122.450921084564)
132171 242912 2 51 1154 Church St 1 1 1 1     8 Width 2ft   6004415.185819999 2102148.8561 37.7523501901347 -122.427611502469 (37.7523501901347, -122.427611502469)
134180 219427 2 51 1426 16th Ave 2 2 1 1     8 Width 4ft   5991170.38541 2105691.7804 37.7613200515933 -122.47367213637101 (37.7613200515933, -122.473672136371)
134417 198415 2 51 3310 Jennings St 2 1 1 1     8 Width 3ft   6013330.68803 2089861.99882 37.7191132896144 -122.39591911208299 (37.7191132896144, -122.395919112083)
136729 136918 2 51 1 Alhambra St 1 1 1 1     8 Width 3ft   6001921.35919 2120601.2758299997 37.8028745199931 -122.437556861278 (37.8028745199931, -122.437556861278)
154342 136919 2 51 101 Laurel St 5 9 1 1     8 Width 7ft   5997971.7056 2116051.1115099997 37.790155644821 -122.450896340588 (37.790155644821, -122.450896340588)
156961 32340 1 51 120 Burrows St 2 1 1 1   10/03/1996 12:00:00 AM 8   Permit Number 36902 6010864.0771699995 2093419.2397900003 37.7287432013131 -122.40469557435 (37.7287432013131, -122.40469557435)
159217 47193 1 51 383 28th Ave 1 1 1 1 1 05/08/2002 12:00:00 AM 8   Permit Number 45152 5987133.5813 2113398.4948 37.7822459140534 -122.488199902231 (37.7822459140534, -122.488199902231)
159263 120760 2 51 2000 Lake St 2 1 1 1     8 Width 3ft   5989219.70066 2114726.96958 37.7860150171 -122.481080247842 (37.7860150171, -122.481080247842)
161848 70149 2 51 754 21st Ave 1 1 1 1 1 05/22/1993 12:00:00 AM 8     5989468.1167 2110177.57013 37.773538072981204 -122.479887770247 (37.7735380729812, -122.479887770247)
163030 136929 2 51 3825 Scott St 2 1 1 1     8 Width 5ft   6000583.85394 2121442.09911 37.8051070609006 -122.442245699797 (37.8051070609006, -122.442245699797)
163047 44470 1 51 128 Gambier St 1 1 1 1 1 03/26/2001 12:00:00 AM 8   Permit Number 43784 6005782.65957 2093100.8203 37.727583573204896 -122.422239770059 (37.7275835732049, -122.422239770059)
167045 219446 2 51 762 Joost Ave 2 9 1 1     8     5997041.47466 2095025.35 37.7323709396524 -122.45259680479201 (37.7323709396524, -122.452596804792)
167505 62133 1 51 221 San Juan Ave 1 1 1 1 1 04/26/1993 12:00:00 AM 8   Permit Number 31836 6001106.23705 2092334.34097 37.7252141069394 -122.43835128458599 (37.7252141069394, -122.438351284586)
169678 198407 2 51 42 Washburn St 1 1 1 1     8 Width 2ft   6008385.72143 2110427.77402 37.7753059744256 -122.414466467358 (37.7753059744256, -122.414466467358)
171114 136915 2 51 2301 Union St 1 1 1 1     8 Width 3ft   6001927.36855 2118383.65644 37.796785861541096 -122.43737717584101 (37.7967858615411, -122.437377175841)
172853 123882 2 51 1 12th Ave 2 1 1 1     8 Width 3ft   5992074.12323 2114872.38939 37.7865798197895 -122.47121541022601 (37.7865798197895, -122.471215410226)
173810 75766 2 51 100 Goettingen St 1 1 1 1 1 04/30/1994 12:00:00 AM 8     6009894.26848 2094011.0737400001 37.730314000377 -122.408090001562 (37.730314000377, -122.408090001562)
176376 70562 2 51 164 South Park 3 1 1 1 1 07/23/1994 12:00:00 AM 8     6014127.69322 2112419.53716 37.7810958034577 -122.39474303089199 (37.7810958034577, -122.394743030892)
180856 72281 2 51 730 42nd Ave 1 1 1 1 1 01/20/1996 12:00:00 AM 8     5982929.242880001 2110803.7534 37.7748753302021 -122.502552686167 (37.7748753302021, -122.502552686167)
181702 70405 2 51 225 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 8     6006525.54367 2092869.6574799998 37.726990725739 -122.41965521291999 (37.726990725739, -122.41965521292)
182709 180445 2 51 599 University St 12 1 1 1     8 Width 3ft   6008486.19305 2091610.48343 37.723643550705 -122.412788276664 (37.723643550705, -122.412788276664)
183248 136920 2 51 207 Maple St 2 10 1 1     8 Width 4ft   5996591.90102 2115549.28793 37.788698686447894 -122.45563404108499 (37.7886986864479, -122.455634041085)
185844 68890 1 51 35 Exeter St 1 1 1 1 1 12/29/1993 12:00:00 AM 8   Permit Number 32862 6012596.9510699995 2091063.5496200002 37.7223716575091 -122.398539644797 (37.7223716575091, -122.398539644797)
187668 180443 2 51 599 University St 10 1 1 1     8 Width 3ft   6008502.54989 2091553.3243 37.7234875219066 -122.412727694727 (37.7234875219066, -122.412727694727)
188081 47192 1 51 383 28th Ave 2 1 1 1 1 05/08/2002 12:00:00 AM 8   Permit Number 45152 5987134.96931 2113380.92602 37.782197756171705 -122.488193808962 (37.7821977561717, -122.488193808962)
Powered by Datasette · Query took 21.48ms · Data source: data.sfgov.org