sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
102237 104721 2 17   3 1 1 1     16 5x5   6002949.0 2107631.0 37.7673197977372 -122.43307345634199 (37.7673197977372, -122.433073456342)
157253 131214 2 50 * Green St 1 1 1 1     11 Width 4ft   6004570.89315 2118403.70426 37.7969908368189 -122.428231397978 (37.7969908368189, -122.428231397978)
135877 199650 2 54 0 1 4 1 1     0 Width 0ft   6014963.58685 2093280.8179400002 37.728591398452394 -122.390513521988 (37.7285913984524, -122.390513521988)
178220 199651 2 54 0 37 4 1 1     0 Width 0ft   6018297.01834 2097895.80454 37.7414476037323 -122.37930996579901 (37.7414476037323, -122.379309965799)
53867 204800 2 12 0 16th Ave 1 2 1 1     6 Width 3ft   5991281.57381 2102416.71556 37.752334025717296 -122.473048745206 (37.7523340257173, -122.473048745206)
29152 247788 2 5 0 30th St 4 4 1 1     14 Width 3ft   6004361.25599 2098418.6984200003 37.742104989252894 -122.427532277614 (37.7421049892529, -122.427532277614)
38229 247791 2 165 0 30th St 7 4 1 1     24 Width 3ft   6004198.23071 2098409.9185599997 37.74207165946871 -122.428095342253 (37.7420716594687, -122.428095342253)
137783 247787 2 37 0 30th St 3 4 1 1     6 Width 3ft   6004405.04711 2098420.28659 37.74211182679821 -122.42738097477199 (37.7421118267982, -122.427380974772)
154157 247786 2 37 0 30th St 2 4 1 1     3 Width 3ft   6004434.4666 2098422.1705099996 37.7421186634473 -122.42727938556101 (37.7421186634473, -122.427279385561)
157576 247792 2 5 0 30th St 8 4 1 1     10 Width 3ft   6004127.24522 2098408.26883 37.742063113214996 -122.42834067009 (37.742063113215, -122.42834067009)
163763 247789 2 5 0 30th St 5 4 1 1     14 Width 3ft   6004321.812940001 2098415.77613 37.742094734277 -122.427668451138 (37.742094734277, -122.427668451138)
179978 247790 2 5 0 30th St 6 4 1 1     13 Width 3ft   6004284.58274 2098414.05293 37.742087896749794 -122.42779705870501 (37.7420878967498, -122.427797058705)
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)
57235 175648 2 28 0 Cardenas Ave 1 9 1 1     7 Width 6ft   5990403.32902 2090274.19266 37.7189428716957 -122.475199448694 (37.7189428716957, -122.475199448694)
67405 175650 2 28 0 Cardenas Ave 3 9 1 1     7 Width 6ft   5990453.87404 2090277.7472299999 37.718955561137705 -122.475024995517 (37.7189555611377, -122.475024995517)
180905 175649 2 28 0 Cardenas Ave 2 9 1 1     8 Width 6ft   5990437.61377 2090276.93523 37.7189523892072 -122.47508114108 (37.7189523892072, -122.47508114108)
185753 175651 2 28 0 Cardenas Ave 4 9 1 1     7 Width 6ft   5990482.39675 2090282.34445 37.7189698369625 -122.47492674008001 (37.7189698369625, -122.47492674008)
49521 240131 2 82 0 Chattanooga St 3 1 1 1     11 Width 3ft   6004671.7789900005 2103561.17999 37.7562426115098 -122.426824733295 (37.7562426115098, -122.426824733295)
50268 226146 2 44 0 Chattanooga St 2 1 1 1     1 Width 3ft   6004672.1171 2103577.59935 37.756287714330796 -122.42682473328199 (37.7562877143308, -122.426824733282)
75125 240132 2 82 0 Chattanooga St 4 1 1 1     8 Width 3ft   6004672.38894 2103545.66672 37.7562000502026 -122.42682151911801 (37.7562000502026, -122.426821519118)
154817 240133 2 82 0 Chattanooga St 5 1 1 1     11 Width 3ft   6004672.52486 2103529.70008 37.756156217245604 -122.426819912015 (37.7561562172456, -122.426819912015)
24871 178331 2 3 0 Crespi Dr 3 9 1 1     14     5990248.62782 2090529.4940400003 37.719634898219205 -122.47575281776001 (37.7196348982192, -122.47575281776)
35071 176378 2 39 0 Crespi Dr 2 2 1 1     19     5989827.05129 2090325.18948 37.7190494782331 -122.477195118066 (37.7190494782331, -122.477195118066)
36449 176377 2 39 0 Crespi Dr 1 2 1 1     18     5989839.20092 2090334.4554299999 37.7190756251255 -122.47715379871201 (37.7190756251255, -122.477153798712)
39653 178330 2 3 0 Crespi Dr 2 9 1 1     13     5990231.62588 2090527.9032400001 37.7196295445501 -122.47581147062 (37.7196295445501, -122.47581147062)
73344 176058 2 60 0 Crespi Dr 2 2 1 1     25     5989854.78687 2090110.33741 37.7184611570226 -122.47708355628599 (37.7184611570226, -122.477083556286)
135205 177925 2 41 0 Crespi Dr 1 2 1 1     28     5989826.52584 2090074.03315 37.71835983492971 -122.477178590321 (37.7183598349297, -122.477178590321)
154609 178329 2 3 0 Crespi Dr 1 9 1 1     10     5990213.26487 2090523.74185 37.719617053850996 -122.47587463361 (37.719617053851, -122.47587463361)
184101 177924 2 41 0 Crespi Dr 3 2 1 1     16     5989730.82285 2090240.32639 37.718810881792 -122.47752153959 (37.718810881792, -122.47752153959)
69468 177945 2 41 0 Diaz Ave 1 2 1 1     6     5990273.00331 2089979.48461 37.718126121809604 -122.47562842082701 (37.7181261218096, -122.475628420827)
22882 176369 2 39 0 Font Blvd 2 2 1 1     13     5990491.08034 2089186.3269 37.7159609464097 -122.47481676917101 (37.7159609464097, -122.474816769171)
25725 178308 2 3 0 Font Blvd 1 2 1 1     31     5990210.12045 2089417.27348 37.716578783365605 -122.47580474370501 (37.7165787833656, -122.475804743705)
38217 176045 2 60 0 Font Blvd 1 2 1 1     20     5990157.58815 2089581.85402 37.7170276349961 -122.475998332672 (37.7170276349961, -122.475998332672)
44468 176364 2 39 0 Font Blvd 1 2 1 1     13     5988874.21496 2090711.48965 37.720054833031504 -122.480516928613 (37.7200548330315, -122.480516928613)
53417 176367 2 39 0 Font Blvd 1 2 1 1     18     5989068.70923 2090618.6052 37.7198110969962 -122.479837842465 (37.7198110969962, -122.479837842465)
65336 176043 2 60 0 Font Blvd 1 2 1 1     19     5989267.954919999 2090414.23117 37.7192615104927 -122.47913418591499 (37.7192615104927, -122.479134185915)
71655 176365 2 39 0 Font Blvd 2 2 1 1     12     5988916.46599 2090663.1949 37.719924683163 -122.48036734976999 (37.719924683163, -122.48036734977)
75369 176363 2 39 0 Font Blvd 2 2 1 1     1     5988462.773440001 2091307.9607099998 37.7216686718604 -122.48198279658399 (37.7216686718604, -122.481982796584)
134960 176366 2 39 0 Font Blvd 2 2 1 1     16     5989001.162169999 2090698.46083 37.720026436042104 -122.48007716733801 (37.7200264360421, -122.480077167338)
136145 176368 2 39 0 Font Blvd 3 2 1 1     15     5990356.63176 2089404.5642 37.7165523801656 -122.475297405564 (37.7165523801656, -122.475297405564)
136573 177298 2 187 0 Font Blvd 1 2 1 1     3     5988403.4281 2091243.7200900002 37.721488831717 -122.48218323117099 (37.721488831717, -122.482183231171)
151804 176362 2 39 0 Font Blvd 1 2 1 1     24     5988643.66331 2091104.1894200002 37.721119686105204 -122.481342600695 (37.7211196861052, -122.481342600695)
153599 176040 2 60 0 Font Blvd 2 2 1 1     25     5989182.3515099995 2090508.47222 37.719515300969206 -122.479436972335 (37.7195153009692, -122.479436972335)
161995 176044 2 60 0 Font Blvd 2 2 1 1     21     5990534.22824 2089263.3063400001 37.7161748133009 -122.47467324639099 (37.7161748133009, -122.474673246391)
163843 176041 2 60 0 Font Blvd 1 2 1 1     20     5989102.080019999 2090436.91452 37.71931415859461 -122.479709205217 (37.7193141585946, -122.479709205217)
166239 176046 2 60 0 Font Blvd 2 2 1 1     24     5990073.98867 2089647.08481 37.7172018948419 -122.47629205486 (37.7172018948419, -122.47629205486)
183286 177914 2 41 0 Font Blvd 3 2 1 1     14     5989849.3669300005 2089820.74775 37.7176657012986 -122.477081140675 (37.7176657012986, -122.477081140675)
185959 176042 2 60 0 Font Blvd 2 2 1 1     19     5989234.3289 2090278.8910299998 37.7188879474116 -122.47924052173599 (37.7188879474116, -122.479240521736)
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)
54108 176348 2 103 0 Fuente Ave 2 2 1 1     26     5989603.79735 2090546.09261 37.7196430676648 -122.47798295295799 (37.7196430676648, -122.477982952958)
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)
136838 104722 2 11 0 Garces Dr 1 1 1 1     2   Permit Number 770294 5989426.465469999 2089157.7784799999 37.7158208086468 -122.478494450472 (37.7158208086468, -122.478494450472)
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)
71030 225636 2 44 0 Gates St 1 1 1 1     2 Width 3ft   6008158.437390001 2095854.0250900001 37.7352770017363 -122.414221366146 (37.7352770017363, -122.414221366146)
24035 178607 2 15 0 Gonzalez Dr 1 2 1 1     2     5990327.66617 2089955.55198 37.7180635775375 -122.47543773036101 (37.7180635775375, -122.475437730361)
24183 175768 2 20 0 Gonzalez Dr 2 2 1 1     13     5989578.68884 2089185.3656400002 37.7159053925979 -122.47797031747801 (37.7159053925979, -122.477970317478)
24841 175769 2 20 0 Gonzalez Dr 1 2 1 1     6     5989661.94364 2089233.64885 37.716042798215206 -122.477686080452 (37.7160427982152, -122.477686080452)
24880 178117 2 104 0 Gonzalez Dr 3 2 1 1     2     5988789.573419999 2089765.1297400002 37.717451446800204 -122.480740256365 (37.7174514468002, -122.480740256365)
27306 178328 2 3 0 Gonzalez Dr 2 2 1 1     29     5990317.34225 2090043.8786900002 37.718305502374704 -122.47547986090599 (37.7183055023747, -122.475479860906)
29157 175654 2 28 0 Gonzalez Dr 2 2 1 1     7     5989491.89044 2089216.44658 37.7159856948481 -122.478272601196 (37.7159856948481, -122.478272601196)
29386 177222 2 11 0 Gonzalez Dr 5 2 1 1     12     5989183.517969999 2089355.54971 37.7163497314364 -122.479348640047 (37.7163497314364, -122.479348640047)
31497 178323 2 3 0 Gonzalez Dr 1 2 1 1     26     5990245.32384 2089538.4798299999 37.7169136270349 -122.475691910275 (37.7169136270349, -122.475691910275)
36738 181277 2 75 0 Gonzalez Dr 6 2 1 1     11     5988402.74919 2089827.8491900002 37.7176011677477 -122.482081905481 (37.7176011677477, -122.482081905481)
36921 175655 2 28 0 Gonzalez Dr 4 2 1 1     5     5989994.06268 2089291.6225400001 37.7162212479866 -122.476542364932 (37.7162212479866, -122.476542364932)
40050 176160 2 47 0 Gonzalez Dr 2 2 1 1     2     5990378.89561 2089837.21304 37.7177416175535 -122.47525201947701 (37.7177416175535, -122.475252019477)
40111 178175 2 71 0 Gonzalez Dr 2 2 1 1     6     5989026.35056 2089515.5020599999 37.7167797908382 -122.47990357931002 (37.7167797908382, -122.47990357931)
40567 176049 2 60 0 Gonzalez Dr 6 2 1 1     18     5989054.79394 2089564.29309 37.716915411303 -122.479808833919 (37.716915411303, -122.479808833919)
40789 176052 2 60 0 Gonzalez Dr 1 2 1 1     17     5989234.209980001 2089407.1197400002 37.716494274064495 -122.47917719598 (37.7164942740645, -122.47917719598)
41434 175767 2 20 0 Gonzalez Dr 1 2 1 1     13     5989494.93952 2089175.43765 37.7158732715029 -122.478259065526 (37.7158732715029, -122.478259065526)
43657 177729 2 2 0 Gonzalez Dr 1 2 1 1     2     5990316.61378 2090071.1896099998 37.718380449173395 -122.47548437190399 (37.7183804491734, -122.475484371904)
44057 175774 2 20 0 Gonzalez Dr 1 2 1 1     9     5990113.97654 2089437.91841 37.7166298945381 -122.47613856845 (37.7166298945381, -122.47613856845)
44691 175766 2 20 0 Gonzalez Dr 5 2 1 1     13     5989094.03032 2089506.27121 37.7167583770722 -122.47966897135001 (37.7167583770722, -122.47966897135)
44701 175656 2 28 0 Gonzalez Dr 3 2 1 1     9     5990014.1272599995 2089314.5953099998 37.716285489253 -122.476474690052 (37.716285489253, -122.476474690052)
51076 177220 2 11 0 Gonzalez Dr 1 2 1 1     3     5989003.1682400005 2089530.2906900002 37.7168190498446 -122.47998478988801 (37.7168190498446, -122.479984789888)
53937 175653 2 28 0 Gonzalez Dr 2 2 1 1     5     5988966.88544 2089648.46014 37.7171414055178 -122.480118843736 (37.7171414055178, -122.480118843736)
55378 176054 2 60 0 Gonzalez Dr 2 2 1 1     16     5989245.31981 2089315.2477799999 37.7162426617475 -122.47913207879101 (37.7162426617475, -122.479132078791)
56400 175657 2 28 0 Gonzalez Dr 1 2 1 1     5     5990127.49163 2089397.98883 37.716521041479204 -122.476088939347 (37.7165210414792, -122.476088939347)
56811 178172 2 71 0 Gonzalez Dr 7 2 1 1     2     5988133.68649 2089845.1312099998 37.7176329668754 -122.483013187625 (37.7176329668754, -122.483013187625)
59851 175772 2 20 0 Gonzalez Dr 5 2 1 1     9     5989911.02174 2089222.5365 37.716026738112 -122.47682434649201 (37.716026738112, -122.476824346492)
60239 178116 2 104 0 Gonzalez Dr 2 2 1 1     2     5988774.083930001 2089765.9400900002 37.7174527715132 -122.480793855056 (37.7174527715132, -122.480793855056)
62427 176057 2 60 0 Gonzalez Dr 5 2 1 1     18     5989281.98257 2089351.5172299999 37.7163443777799 -122.479008007435 (37.7163443777799, -122.479008007435)
63730 178606 2 15 0 Gonzalez Dr 3 2 1 1     2     5989765.07873 2089203.5232 37.715966065363205 -122.47732740025499 (37.7159660653632, -122.477327400255)
67488 177728 2 2 0 Gonzalez Dr 5 2 1 1     3     5990346.90752 2090145.93714 37.7185874434309 -122.475385114628 (37.7185874434309, -122.475385114628)
Powered by Datasette · Query took 133.742ms · Data source: data.sfgov.org