sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
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)
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)
67578 178320 2 3 0 Gonzalez Dr 3 2 1 1     28     5988848.05481 2089780.78106 37.7174978203386 -122.480539260585 (37.7174978203386, -122.480539260585)
69208 176048 2 60 0 Gonzalez Dr 1 2 1 1     18     5989010.93647 2089619.81285 37.7170653066825 -122.479964486788 (37.7170653066825, -122.479964486788)
69442 178322 2 3 0 Gonzalez Dr 4 2 1 1     31     5989407.26888 2089196.13882 37.7159250221006 -122.478563605643 (37.7159250221006, -122.478563605643)
70417 177219 2 11 0 Gonzalez Dr 2 2 1 1     2     5988139.55796 2089802.05972 37.7175150450661 -122.48298973781 (37.7175150450661, -122.48298973781)
71083 175563 2 146 0 Gonzalez Dr 3 2 1 1     4     5988277.07749 2089797.21556 37.71750974536221 -122.482514046798 (37.7175097453622, -122.482514046798)
90725 178324 2 3 0 Gonzalez Dr 2 2 1 1     30     5990257.3816599995 2089553.17282 37.7169546693979 -122.475651304982 (37.7169546693979, -122.475651304982)
117022 177727 2 2 0 Gonzalez Dr 3 2 1 1     3     5989471.66726 2089216.87415 37.715985694863896 -122.47834253249201 (37.7159856948639, -122.478342532492)
127115 178176 2 71 0 Gonzalez Dr 3 2 1 1     3     5989163.89955 2089384.56057 37.7164282485354 -122.479418571325 (37.7164282485354, -122.479418571325)
130676 178327 2 3 0 Gonzalez Dr 2 2 1 1     28     5990329.946140001 2089929.88135 37.7179932244997 -122.475427976322 (37.7179932244997, -122.475427976322)
132572 177726 2 2 0 Gonzalez Dr 4 2 1 1     3     5989405.70354 2089245.5650799999 37.7160606434521 -122.478572628528 (37.7160606434521, -122.478572628528)
132856 178174 2 71 0 Gonzalez Dr 5 2 1 1     2     5988358.3694 2089791.63303 37.717499145949 -122.48223265254101 (37.717499145949, -122.482232652541)
134179 178325 2 3 0 Gonzalez Dr 1 2 1 1     28     5990390.33795 2089760.9336299999 37.7175328363477 -122.47520690318599 (37.7175328363477, -122.475206903186)
135161 178321 2 3 0 Gonzalez Dr 4 2 1 1     20     5989145.21541 2089457.7452900002 37.716628110272005 -122.479488503489 (37.716628110272, -122.479488503489)
146394 178605 2 15 0 Gonzalez Dr 6 2 1 1     2     5988508.8443599995 2089780.72483 37.71747794624039 -122.48171173733299 (37.7174779462404, -122.481711737333)
148106 178604 2 15 0 Gonzalez Dr 1 2 1 1     2     5988124.07873 2089803.3530000001 37.7175176953569 -122.48304333649999 (37.7175176953569, -122.4830433365)
152019 178326 2 3 0 Gonzalez Dr 3 2 1 1     25     5990372.2115400005 2089922.4902 37.7179753801352 -122.475281345478 (37.7179753801352, -122.475281345478)
152141 177221 2 11 0 Gonzalez Dr 4 2 1 1     13     5989179.19874 2089367.33922 37.7163818516244 -122.479364431248 (37.7163818516244, -122.479364431248)
154455 175771 2 20 0 Gonzalez Dr 4 2 1 1     5     5989791.935380001 2089208.15493 37.7159803412063 -122.477234910356 (37.7159803412063, -122.477234910356)
154485 176056 2 60 0 Gonzalez Dr 6 2 1 1     24     5989277.7182599995 2089365.90518 37.7163836358725 -122.47902379861401 (37.7163836358725, -122.479023798614)
156730 181275 2 75 0 Gonzalez Dr 4 2 1 1     11     5988424.04089 2089826.4329400002 37.7175985174299 -122.482008206935 (37.7175985174299, -122.482008206935)
160065 176051 2 60 0 Gonzalez Dr 2 2 1 1     25     5989218.52603 2089406.1518400002 37.7164907055632 -122.479231336085 (37.7164907055632, -122.479231336085)
165883 178118 2 104 0 Gonzalez Dr 4 2 1 1     2     5988803.05395 2089760.9840900002 37.7174408474004 -122.480693357611 (37.7174408474004, -122.480693357611)
167088 175765 2 20 0 Gonzalez Dr 1 2 1 1     18     5988629.85447 2089774.3019599998 37.7174673468061 -122.481292995899 (37.7174673468061, -122.481292995899)
168076 175652 2 28 0 Gonzalez Dr 5 2 1 1     5     5988848.344219999 2089725.7642299999 37.717346774709505 -122.480534235175 (37.7173467747095, -122.480534235175)
168519 181276 2 75 0 Gonzalez Dr 5 2 1 1     11     5988413.87941 2089827.13064 37.7175998421416 -122.482043381217 (37.7175998421416, -122.482043381217)
169232 178173 2 71 0 Gonzalez Dr 4 2 1 1     2     5988347.73388 2089792.82325 37.717501795356 -122.482269501364 (37.717501795356, -122.482269501364)
Powered by Datasette · Query took 20.521ms · Data source: data.sfgov.org