sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6162 35284 1 41   3 1 1 1   02/17/1998 12:00:00 AM     Permit Number 38758          
8735 35281 1 41   5 1 1 1   02/17/1998 12:00:00 AM     Permit Number 38758          
11312 35280 1 41   1 1 1 1   02/17/1998 12:00:00 AM     Permit Number 38758          
13846 35283 1 41   2 1 1 1   02/17/1998 12:00:00 AM     Permit Number 38758          
16213 35285 1 41   4 1 1 1   02/17/1998 12:00:00 AM     Permit Number 38758          
3486 39483 1 41 0 19th St 3 1 1 1   12/28/1998 12:00:00 AM     Permit Number 40941          
6472 39482 1 41 0 19th St 2 1 1 1   12/28/1998 12:00:00 AM     Permit Number 40941          
16886 39481 1 41 0 19th St 1 1 1 1   12/28/1998 12:00:00 AM     Permit Number 40941          
29723 177927 2 41 0 Bucareli Dr 4 2 1 1     17     5988959.91996 2089504.3338 37.716745265857 -122.48013237763 (37.716745265857, -122.48013237763)
61160 177926 2 41 0 Bucareli Dr 1 2 1 1     16     5988935.7978 2089543.3512799998 37.7168509964648 -122.480218609114 (37.7168509964648, -122.480218609114)
61899 177929 2 41 0 Bucareli Dr 3 2 1 1     12     5988839.75679 2089455.3276 37.7166037242653 -122.48054413220699 (37.7166037242653, -122.480544132207)
69696 177930 2 41 0 Bucareli Dr 3 2 1 1     12     5988862.76325 2089422.54432 37.7165150466091 -122.480462212988 (37.7165150466091, -122.480462212988)
70010 177934 2 41 0 Bucareli Dr 5 2 1 1     4     5988635.61259 2089280.10032 37.7161107276166 -122.481236924063 (37.7161107276166, -122.481236924063)
131812 177931 2 41 0 Bucareli Dr 2 2 1 1     15     5988808.760919999 2089375.86435 37.716383736599205 -122.480645454328 (37.7163837365992, -122.480645454328)
135710 177932 2 41 0 Bucareli Dr 1 2 1 1     15     5988789.67714 2089358.2569799998 37.7163342819918 -122.480710128176 (37.7163342819918, -122.480710128176)
146613 177923 2 41 0 Bucareli Dr 1 2 1 1     6     5988561.02848 2089156.81478 37.715767879956104 -122.481485695422 (37.7157678799561, -122.481485695422)
148235 177933 2 41 0 Bucareli Dr 4 2 1 1     11     5988685.34824 2089320.7162799998 37.7162251402652 -122.481067988213 (37.7162251402652, -122.481067988213)
178623 177928 2 41 0 Bucareli Dr 2 2 1 1     7     5988855.6313 2089468.65527 37.716641241284705 -122.480490237638 (37.7166412412847, -122.480490237638)
67404 177922 2 41 0 Cambon Dr 2 9 1 1     8 Width 5ft   5990625.846609999 2089245.25322 37.7161305522573 -122.474355255986 (37.7161305522573, -122.474355255986)
72659 177921 2 41 0 Cambon Dr 1 9 1 1     8 Width 5ft   5990636.51581 2089256.00468 37.7161606912434 -122.47431916261499 (37.7161606912434, -122.474319162615)
135205 177925 2 41 0 Crespi Dr 1 2 1 1     28     5989826.52584 2090074.03315 37.71835983492971 -122.477178590321 (37.7183598349297, -122.477178590321)
184101 177924 2 41 0 Crespi Dr 3 2 1 1     16     5989730.82285 2090240.32639 37.718810881792 -122.47752153959 (37.718810881792, -122.47752153959)
11662 102569 6 41 0 Diaz Ave 1 7 1 1   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.8197400002 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439)
69468 177945 2 41 0 Diaz Ave 1 2 1 1     6     5990273.00331 2089979.48461 37.718126121809604 -122.47562842082701 (37.7181261218096, -122.475628420827)
183286 177914 2 41 0 Font Blvd 3 2 1 1     14     5989849.3669300005 2089820.74775 37.7176657012986 -122.477081140675 (37.7176657012986, -122.477081140675)
25292 177947 2 41 0 Fuente Ave 1 2 1 1     13     5989601.96089 2090504.09134 37.7195276360688 -122.477986231896 (37.7195276360688, -122.477986231896)
32094 177949 2 41 0 Fuente Ave 2 2 1 1     18     5989559.04866 2090448.7873900002 37.7193732944219 -122.47813052091101 (37.7193732944219, -122.478130520911)
62097 177948 2 41 0 Fuente Ave 1 2 1 1     9     5989566.53985 2090511.4530000002 37.7195457933774 -122.47810920609601 (37.7195457933774, -122.478109206096)
123716 177946 2 41 0 Fuente Ave 1 2 1 1     14     5989610.43005 2090657.9013200002 37.7199504514394 -122.477968195982 (37.7199504514394, -122.477968195982)
27126 177939 2 41 0 Garces Dr 5 2 1 1     9     5989472.35628 2089125.29207 37.7157342731997 -122.478333458321 (37.7157342731997, -122.478333458321)
51889 177940 2 41 0 Garces Dr 2 2 1 1     15     5989427.62768 2089128.0215200002 37.7157391708956 -122.478488258642 (37.7157391708956, -122.478488258642)
149147 177935 2 41 0 Garces Dr 1 2 1 1     15     5989493.36658 2088932.77712 37.715206894553795 -122.47824676997699 (37.7152068945538, -122.478246769977)
172901 177937 2 41 0 Garces Dr 3 2 1 1     8     5989487.39768 2088989.39507 37.7153620069155 -122.47827153820299 (37.7153620069155, -122.478271538203)
176036 177936 2 41 0 Garces Dr 2 2 1 1     8     5989491.06081 2088964.9371200001 37.715295064093205 -122.478257089699 (37.7152950640932, -122.478257089699)
184364 177938 2 41 0 Garces Dr 4 2 1 1     7     5989480.9198900005 2089050.18574 37.71552854698071 -122.478298370392 (37.7155285469807, -122.478298370392)
29240 177953 2 41 0 Grijalva Dr 3 2 1 1     15     5989426.93386 2089569.48868 37.7169512897353 -122.47852292122101 (37.7169512897353, -122.478522921221)
45156 177964 2 41 0 Grijalva Dr 3 2 1 1     15     5988925.38088 2089008.91353 37.715382958419106 -122.48021552173901 (37.7153829584191, -122.480215521739)
51581 177959 2 41 0 Grijalva Dr 2 2 1 1     12     5989083.70402 2089208.46347 37.71594007136579 -122.47968288565201 (37.7159400713658, -122.479682885652)
58315 177961 2 41 0 Grijalva Dr 3 2 1 1     15     5989118.28423 2089183.8613200001 37.7158745287534 -122.479561562622 (37.7158745287534, -122.479561562622)
64301 177951 2 41 0 Grijalva Dr 1 2 1 1     9     5989499.70601 2089731.63068 37.7174007160611 -122.478283234789 (37.7174007160611, -122.478283234789)
65659 177955 2 41 0 Grijalva Dr 3 2 1 1     17     5989333.41698 2089519.4632700002 37.7168085025868 -122.478842503398 (37.7168085025868, -122.478842503398)
67763 177962 2 41 0 Grijalva Dr 2 2 1 1     11     5989078.7127 2089134.3997099998 37.7157364207672 -122.479694721656 (37.7157364207672, -122.479694721656)
70016 177950 2 41 0 Grijalva Dr 4 2 1 1     16     5989537.87078 2089714.6263700002 37.7173562418745 -122.47815007578801 (37.7173562418745, -122.478150075788)
72252 177954 2 41 0 Grijalva Dr 2 2 1 1     8     5989416.48515 2089561.1846099999 37.716927882190596 -122.478558430025 (37.7169278821906, -122.478558430025)
100885 177956 2 41 0 Grijalva Dr 1 2 1 1     7     5989293.3686 2089406.92644 37.7164971788871 -122.47897270272301 (37.7164971788871, -122.478972702723)
130538 177963 2 41 0 Grijalva Dr 1 2 1 1     14     5988967.059330001 2088996.0962599998 37.7153501871281 -122.48007052675501 (37.7153501871281, -122.480070526755)
146359 177952 2 41 0 Grijalva Dr 2 2 1 1     15     5989400.28977 2089605.00468 37.7170472609007 -122.47861761173901 (37.7170472609007, -122.478617611739)
173704 177960 2 41 0 Grijalva Dr 4 2 1 1     9     5989129.76935 2089200.6687 37.7159213447791 -122.47952309413701 (37.7159213447791, -122.479523094137)
174720 177957 2 41 0 Grijalva Dr 5 2 1 1     13     5989199.228490001 2089287.00846 37.7161624467126 -122.479289326156 (37.7161624467126, -122.479289326156)
175833 177958 2 41 0 Grijalva Dr 1 2 1 1     12     5989169.01716 2089315.78059 37.7162396930894 -122.479395853531 (37.7162396930894, -122.479395853531)
61440 177943 2 41 0 Josepha Ave 3 2 1 1     14     5989687.380890001 2089641.08495 37.7171629928544 -122.477627922194 (37.7171629928544, -122.477627922194)
61872 177944 2 41 0 Josepha Ave 4 2 1 1     6     5989684.83075 2089660.83958 37.717217086174 -122.477638179862 (37.717217086174, -122.477638179862)
136472 177941 2 41 0 Josepha Ave 1 2 1 1     4     5989724.378719999 2089308.8326299998 37.7162528573591 -122.47747576951599 (37.7162528573591, -122.477475769516)
149588 177942 2 41 0 Josepha Ave 2 2 1 1     4     5989710.75871 2089436.6850700001 37.7166031181237 -122.477532185763 (37.7166031181237, -122.477532185763)
24979 177920 2 41 0 Juan Bautista Cir 4 2 1 1     13     5989764.376630001 2089755.55448 37.7174817656499 -122.477370148614 (37.7174817656499, -122.477370148614)
52939 177917 2 41 0 Juan Bautista Cir 1 2 1 1     13     5989687.39355 2089722.5642099997 37.717386715401204 -122.477633830752 (37.7173867154012, -122.477633830752)
58703 177916 2 41 0 Juan Bautista Cir 2 2 1 1     13     5989586.18825 2089731.4345 37.717405197378504 -122.477984294746 (37.7174051973785, -122.477984294746)
129714 177918 2 41 0 Juan Bautista Cir 2 2 1 1     12     5989709.79651 2089731.70675 37.7174131186015 -122.477557062834 (37.7174131186015, -122.477557062834)
157607 177915 2 41 0 Juan Bautista Cir 1 2 1 1     8     5989561.17412 2089735.8094900001 37.7174157581119 -122.47807107572399 (37.7174157581119, -122.478071075724)
159324 177919 2 41 0 Juan Bautista Cir 3 2 1 1     14     5989736.060409999 2089740.7673799999 37.7174395208859 -122.47746694353901 (37.7174395208859, -122.477466943539)
186931 232435 2 41 1 Church St 14 9 1 1     14 Width 6ft   6004121.39652 2108664.33355 37.7702235143292 -122.42909198802201 (37.7702235143292, -122.429091988022)
135821 233227 2 41 1 Holly Park Cir 2 1 1 1     4 Width 3ft   6006435.78425 2096959.1175799998 37.7382144267543 -122.420255629995 (37.7382144267543, -122.420255629995)
58538 210822 2 41 1 Ventura Ave 2 2 1 1     4 Width 3ft   5994075.12889 2102034.61648 37.7514462212671 -122.463360530485 (37.7514462212671, -122.463360530485)
67850 210823 2 41 1 Ventura Ave 1 2 1 1     4 Width 3ft   5994071.60304 2101964.35734 37.7512531044495 -122.46336762522101 (37.7512531044495, -122.463367625221)
128002 107077 2 41 10 BRADY ST 1 1 1 1     14 3x4   6006482.0 2109752.0 37.773343330406796 -122.421003898549 (37.7733433304068, -122.421003898549)
31671 232963 2 41 10 Carmel St 3 1 1 1     6 Width 4ft   5998915.09351 2105421.46828 37.761023333779 -122.446867103551 (37.761023333779, -122.446867103551)
45481 232964 2 41 10 Carmel St 4 1 1 1     6 Width 4ft   5998893.42724 2105419.84777 37.7610176464756 -122.446941920852 (37.7610176464756, -122.446941920852)
178742 232962 2 41 10 Carmel St 2 1 1 1     6 Width 4ft   5998932.6102599995 2105423.58947 37.7610301587293 -122.446806673598 (37.7610301587293, -122.446806673598)
185998 232961 2 41 10 Carmel St 1 1 1 1     7 Width 4ft   5998954.69213 2105425.20137 37.7610358460469 -122.446730418281 (37.7610358460469, -122.446730418281)
122562 65473 1 41 10 De Montfort Ave 1 1 1 1 1 10/24/1990 12:00:00 AM     Permit Number 29345 5995326.58257059 2091913.57647422 37.7237283530048 -122.45830039747 (37.7237283530048, -122.45830039747)
74805 210756 2 41 10 Judah St 2 1 1 1     3 Width 3ft   5994500.79193 2106024.87293 37.7624269551699 -122.462177903984 (37.7624269551699, -122.462177903984)
166067 210755 2 41 10 Judah St 1 1 1 1     4 Width 3ft   5994519.49208 2106024.97078 37.762428300536 -122.46211323464199 (37.762428300536, -122.462113234642)
30422 233781 2 41 10 Saturn St 3 9 1 1     8 Width 3ft   6000622.86001 2106032.19557 37.762797654817604 -122.44100451216299 (37.7627976548176, -122.441004512163)
33801 233782 2 41 10 Saturn St 4 9 1 1     12 Width 3ft   6000620.83206 2106027.61812 37.762784970763896 -122.441011197703 (37.7627849707639, -122.441011197703)
51108 233783 2 41 10 Saturn St 5 9 1 1     8 Width 3ft   6000623.49703 2106025.6379400003 37.7627796854658 -122.441001838469 (37.7627796854658, -122.441001838469)
60421 233779 2 41 10 Saturn St 1 9 1 1     10 Width 3ft   6000624.58928 2106041.01354 37.762821965281 -122.44099916388001 (37.762821965281, -122.44099916388)
129801 233780 2 41 10 Saturn St 2 9 1 1     8 Width 3ft   6000618.75311 2106039.2097 37.7628166799724 -122.44101921967501 (37.7628166799724, -122.441019219675)
57078 232867 2 41 100 Alemany Blvd 28 1 1 1     5 Width 3ft   6009311.71143 2095856.6182400002 37.735348835078796 -122.410234240737 (37.7353488350788, -122.410234240737)
74856 232866 2 41 100 Alemany Blvd 4 1 1 1     7 Width 3ft   6009630.05174 2096202.69692 37.736316931874 -122.409158028324 (37.736316931874, -122.409158028324)
78335 47594 1 41 100 Alemany Blvd 6 1 1 1 1 05/20/2002 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555)
79024 47597 1 41 100 Alemany Blvd 2 1 1 1 1 01/04/2003 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555)
103660 47593 1 41 100 Alemany Blvd 7 1 1 1 1 05/20/2002 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555)
139060 47595 1 41 100 Alemany Blvd 5 1 1 1 1 05/20/2002 12:00:00 AM     Permit Number 45435 6009710.93340167 2096438.06354235 37.7369677288425 -122.408894986555 (37.7369677288425, -122.408894986555)
29676 194152 2 41 100 Carolina St 4 2 1 1     1 Width 4ft   6012254.865130001 2106816.35106 37.7656064246163 -122.400828345673 (37.7656064246163, -122.400828345673)
137723 194151 2 41 100 Carolina St 3 2 1 1     1 Width 4ft   6012252.37464 2106853.87297 37.7657093124668 -122.400839596166 (37.7657093124668, -122.400839596166)
146894 194153 2 41 100 Carolina St 5 2 1 1     1 Width 4ft   6012257.457909999 2106772.39506 37.765485875897 -122.400816289341 (37.765485875897, -122.400816289341)
177165 194150 2 41 100 Carolina St 2 2 1 1     1 Width 4ft   6012249.4838 2106891.9100200003 37.765813592442605 -122.400852267621 (37.7658135924426, -122.400852267621)
40108 232434 2 41 100 Church St 1 4 1 1     6 Width 3ft   6004077.27006 2108309.3730900004 37.7692463811546 -122.429219306844 (37.7692463811546, -122.429219306844)
75787 232433 2 41 100 Church St 2 4 1 1     7 Width 3ft   6004078.2597199995 2108290.75217 37.7691953086514 -122.429214555715 (37.7691953086514, -122.429214555715)
99915 113323 1 41 100 Church St 3 1 1 1 1   12     6004079.74050315 2108375.213269 37.7694273021614 -122.42921545709 (37.7694273021614, -122.42921545709)
123392 113322 1 41 100 Church St 2 1 1 1 1         6004079.74050315 2108375.213269 37.7694273021614 -122.42921545709 (37.7694273021614, -122.42921545709)
185707 232432 2 41 100 Church St 3 4 1 1     15 Width 4ft   6004078.65513 2108269.95494 37.7691382268875 -122.429211704867 (37.7691382268875, -122.429211704867)
99111 88512 1 41 100 Eastwood Dr 1 1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51445 5995638.0 2093313.0 37.7275887253261 -122.457325078591 (37.7275887253261, -122.457325078591)
104694 88513 1 41 100 Eastwood Dr 2 1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51445 5995638.0 2093313.0 37.7275887253261 -122.457325078591 (37.7275887253261, -122.457325078591)
66805 210831 2 41 100 El Verano Way 2 9 1 1     3 Width 3ft   5994495.152530001 2094669.90963 37.7312487620154 -122.461374210478 (37.7312487620154, -122.461374210478)
182313 210832 2 41 100 El Verano Way 1 9 1 1     2 Width 3ft   5994491.87078 2094685.88565 37.731292439379395 -122.461386713728 (37.7312924393794, -122.461386713728)
147033 210600 2 41 100 Hugo St 1 1 1 1     14 Width 2ft   5995427.38447 2107071.96 37.765355293446795 -122.459049004307 (37.7653552934468, -122.459049004307)
159616 210601 2 41 100 Hugo St 2 1 1 1     16 Width 2ft   5995408.81164 2107071.42488 37.7653527564515 -122.45911320421999 (37.7653527564515, -122.45911320422)
136958 210681 2 41 100 Malta Dr 5 2 1 1     3     5999441.24065 2096192.06642 37.735711675549 -122.444384101443 (37.735711675549, -122.444384101443)
37993 210661 2 41 100 Maywood Dr 3 1 1 1     5 Width 2ft   5994208.63776 2095900.82229 37.734612051092704 -122.462453985083 (37.7346120510927, -122.462453985083)
51358 210658 2 41 100 Pinehurst Way 1 1 1 1     3 Width 2ft   5993547.0242 2093685.64408 37.728491596189606 -122.464580592135 (37.7284915961896, -122.464580592135)
Powered by Datasette · Query took 14.151ms · Data source: data.sfgov.org