sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
42045 182773 2 54 1 33rd Ave 1 2 1 1     0 Width 0ft   5985975.4571 2103368.6441 37.754639125693004 -122.491467955558 (37.754639125693, -122.491467955558)
27474 183607 2 54 1 Quintara St 1 2 1 1     0 Width 0ft   5989903.61 2101103.2452 37.748647706091596 -122.477717911497 (37.7486477060916, -122.477717911497)
66528 142128 2 54 10 HEMWAY TER 1 1 1 1     0 Width 0ft   5998660.4892 2110810.2219 37.775804936046704 -122.448135688829 (37.7758049360467, -122.448135688829)
66691 142129 2 54 10 HEMWAY TER 2 1 1 1     0 Width 0ft   5998655.1761 2110837.1975 37.775878700373895 -122.448156010928 (37.7758787003739, -122.448156010928)
77581 33407 1 54 100 Ulloa St 2 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
79062 33409 1 54 100 Ulloa St 4 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
87303 33408 1 54 100 Ulloa St 3 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
91200 33411 1 54 100 Ulloa St 6 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
99156 33410 1 54 100 Ulloa St 5 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
140197 33406 1 54 100 Ulloa St 1 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
25062 247418 2 54 1001 Fell St 2 1 1 1     0 Width 0ft   6002608.194 2110213.5869 37.7743916070028 -122.43443692499599 (37.7743916070028, -122.434436924996)
37581 200170 2 54 1001 Ingerson Ave 1 19 1 1     0 Width 0ft   6014099.661 2089867.5171 37.71917119290661 -122.393261433304 (37.7191711929066, -122.393261433304)
34444 139926 2 54 1001 TURK ST 2 1 1 1     0 Width 0ft   6005215.378 2112666.1069 37.78127327564229 -122.425592763682 (37.7812732756423, -122.425592763682)
177358 200205 2 54 1003 Hollister Ave 1 19 1 1     0 Width 0ft   6014813.9755 2089679.7161 37.71869518696921 -122.39077918277701 (37.7186951869692, -122.390779182777)
64371 248338 2 54 101 Belvedere St 1 1 1 1     3 Width 0ft   5998210.6283 2108198.2582 37.7686074267176 -122.44950361782 (37.7686074267176, -122.44950361782)
171847 245199 2 54 101 Broderick St 1 1 1 1     0 Width 0ft   6001311.3344 2109146.8192 37.771388829884 -122.43884653486 (37.771388829884, -122.43884653486)
36431 137758 2 54 101 Saint Joseph's Ave 19 1 1 1     0 Width 0ft   6000707.9938 2112291.934 37.7799901751967 -122.44115920153799 (37.7799901751967, -122.441159201538)
60095 137739 2 54 101 Saint Joseph's Ave 10 1 1 1     0 Width 0ft   6000676.859 2112512.2466 37.7805933238275 -122.441282722586 (37.7805933238275, -122.441282722586)
156661 137740 2 54 101 Saint Joseph's Ave 11 1 1 1     0 Width 0ft   6000679.5664 2112493.295 37.7805414418009 -122.441271996241 (37.7805414418009, -122.441271996241)
182449 200194 2 54 1011 Hollister Ave 1 19 1 1     0 Width 0ft   6014781.1104 2089713.2519999999 37.718785446443206 -122.390895127615 (37.7187854464432, -122.390895127615)
153937 247379 2 54 1015 Oak St 3 1 1 1     0 Width 0ft   6002146.8166 2109803.9081 37.7732405306973 -122.436003592649 (37.7732405306973, -122.436003592649)
150420 200167 2 54 1019 Ingerson Ave 1 19 1 1     0 Width 0ft   6014049.3571 2089910.4430000002 37.7192862641022 -122.393438318502 (37.7192862641022, -122.393438318502)
164210 247384 2 54 1021 Oak St 1 1 1 1     0 Width 0ft   6002057.9469 2109793.0538 37.7732056784261 -122.436310227416 (37.7732056784261, -122.436310227416)
133594 200166 2 54 1023 Ingerson Ave 1 19 1 1     0 Width 0ft   6014031.9185 2089919.1624 37.7193092369184 -122.393499207549 (37.7193092369184, -122.393499207549)
179075 200190 2 54 1027 Hollister Ave 1 19 1 1     0 Width 0ft   6014706.6607 2089771.6044 37.7189415394071 -122.391156549139 (37.7189415394071, -122.391156549139)
30792 200164 2 54 1027 Ingerson Ave 1 19 1 1     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555)
43519 200180 2 54 1031 Hollister Ave 1 19 1 1     0 Width 0ft   6014690.5634 2089785.0188 37.7189774793874 -122.391213128817 (37.7189774793874, -122.391213128817)
74346 200162 2 54 1035 Ingerson Ave 1 19 1 1     0 Width 0ft   6013970.2124 2089969.4662 37.7194439323961 -122.393716023061 (37.7194439323961, -122.393716023061)
83254 110159 1 54 1041 Broadway 5 1 1 1     3   Permit Number 55966 6008597.3 2118278.8 37.7968748776387 -122.414290174718 (37.7968748776387, -122.414290174718)
28513 200177 2 54 1041 Hollister Ave 1 19 1 1     0 Width 0ft   6014650.3204 2089811.8475 37.7190489123065 -122.39135410876001 (37.7190489123065, -122.39135410876)
29863 200176 2 54 1047 Hollister Ave 1 19 1 1     0 Width 0ft   6014610.748 2089844.7127 37.7191369573176 -122.391493192738 (37.7191369573176, -122.391493192738)
58301 200156 2 54 1047 Ingerson Ave 1 19 1 1     0 Width 0ft   6013914.5428 2090009.7093 37.7195513382693 -122.39391126933 (37.7195513382693, -122.39391126933)
177846 200172 2 54 1053 Hollister Ave 1 19 1 1     0 Width 0ft   6014576.5414 2089866.8464 37.7191958334242 -122.391612979464 (37.7191958334242, -122.391612979464)
61127 200498 2 54 1055 Ingerson Ave 1 19 1 1     0 Width 0ft   6013869.6047 2090039.2209 37.7196298737115 -122.394068670065 (37.7196298737115, -122.394068670065)
186420 200171 2 54 1059 Hollister Ave 1 19 1 1     0 Width 0ft   6014549.7127 2089886.9679 37.7192495938582 -122.391707122944 (37.7192495938582, -122.391707122944)
189029 140863 2 54 106 JORDAN AVE 1 2 1 1     0 Width 0ft   5996246.41 2113718.2127 37.7836512118011 -122.45669690496901 (37.7836512118011, -122.456696904969)
144780 200169 2 54 1061 Hollister Ave 1 19 1 1     0 Width 0ft   6014525.5668 2089911.1138 37.719314553356206 -122.391792274296 (37.7193145533562, -122.391792274296)
29647 200249 2 54 1067 Ingerson Ave 1 19 1 1     0 Width 0ft   6013803.2037 2090093.549 37.7197753570889 -122.394301997885 (37.7197753570889, -122.394301997885)
156632 200165 2 54 1071 Hollister Ave 1 19 1 1     0 Width 0ft   6014485.3238 2089939.2839 37.7193896687982 -122.39193334918501 (37.7193896687982, -122.391933349185)
168550 200246 2 54 1071 Ingerson Ave 1 19 1 1     0 Width 0ft   6013781.7407 2090110.9877 37.719822047209 -122.394377408818 (37.719822047209, -122.394377408818)
28131 200245 2 54 1075 Ingerson Ave 1 19 1 1     0 Width 0ft   6013768.3263 2090118.3656 37.71984155975311 -122.394424294358 (37.7198415597531, -122.394424294358)
188973 200161 2 54 1083 Hollister Ave 1 19 1 1     0 Width 0ft   6014425.6299 2089982.8806 37.7195060625081 -122.392142737787 (37.7195060625081, -122.392142737787)
178876 200201 2 54 1090 Ingerson Ave 2 2 1 1     0 Width 0ft   6013694.5474 2090234.3998 37.7201560648851 -122.394687445541 (37.7201560648851, -122.394687445541)
181617 200202 2 54 1090 Ingerson Ave 1 1 1 1     0 Width 0ft   6013720.7054 2090215.6197 37.72010595277 -122.394595711042 (37.72010595277, -122.394595711042)
44928 200155 2 54 1091 Hollister Ave 1 19 1 1     0 Width 0ft   6014363.9238 2090021.1115 37.719607610680704 -122.39235870744899 (37.7196076106807, -122.392358707449)
52467 200157 2 54 1091 Hollister Ave 1 19 1 1     0 Width 0ft   6014392.094 2090006.3557 37.7195686584119 -122.39226030100401 (37.7195686584119, -122.392260301004)
92851 7876 3 54 1095X Franklin St 1 1 1 2   03/04/2011 12:00:00 AM 3 3x3   6006012.62101 2113826.37447 37.784504100894395 -122.42291717866101 (37.7845041008944, -122.422917178661)
33065 185060 3 54 10x El Mirasol Pl 1 11 1 2     0 Width 0ft   5987413.8008 2096060.1353 37.7346558528299 -122.485957413668 (37.7346558528299, -122.485957413668)
137463 142105 2 54 11 HEMWAY TER 1 1 1 1     0 Width 0ft   5998624.9098 2110833.4671 37.7758667273984 -122.44826044071199 (37.7758667273984, -122.448260440712)
62615 142063 2 54 1100 GOLDEN GATE AVE 3 1 1 1     0 Width 0ft   6004132.6367 2112218.0001 37.779981646673896 -122.42930655266399 (37.7799816466739, -122.429306552664)
24523 141857 2 54 1100 TURK ST 1 1 1 1     0 Width 0ft   6004651.3626 2112630.8889 37.781144690344895 -122.42754147050199 (37.7811446903449, -122.427541470502)
185965 140443 2 54 1101 FILLMORE ST 4 1 1 1     0 Width 0ft   6003331.4074 2112177.9445 37.7798262712775 -122.432075500833 (37.7798262712775, -122.432075500833)
75169 141944 2 54 1101 GOLDEN GATE AVE 9 1 1 1     0 Width 0ft   6004183.4678 2112169.0928 37.779850236925 -122.429127216952 (37.779850236925, -122.429127216952)
105066 141940 2 54 1101 GOLDEN GATE AVE 5 1 1 1     0 Width 0ft   6004067.7741 2112149.004 37.7797885282032 -122.42952601949499 (37.7797885282032, -122.429526019495)
163263 141945 2 54 1101 GOLDEN GATE AVE 10 1 1 1     0 Width 0ft   6004212.2215 2112170.9783 37.7798570416861 -122.429027879664 (37.7798570416861, -122.429027879664)
31028 139809 2 54 1101 GOUGH ST 9 1 1 1     0 Width 0ft   6005660.0139 2112868.3262 37.7818536339515 -122.424068925498 (37.7818536339515, -122.424068925498)
54871 200168 2 54 1101 Gilman Ave 1 2 1 1     0 Width 0ft   6014990.039 2089901.3883 37.7193136223873 -122.390186075408 (37.7193136223873, -122.390186075408)
131768 200212 2 54 1101 Ingerson Ave 1 19 1 1     0 Width 0ft   6013545.647999999 2090276.655 37.720263809593604 -122.395205102903 (37.7202638095936, -122.395205102903)
168399 200213 2 54 1101 Ingerson Ave 2 19 1 1     0 Width 0ft   6013590.5861 2090251.1677 37.7201963256026 -122.395047981349 (37.7201963256026, -122.395047981349)
39813 200248 2 54 1107 Hollister Ave 1 19 1 1     0 Width 0ft   6014274.7183 2090092.8783 37.719799714154504 -122.392672078819 (37.7197997141545, -122.392672078819)
518 251314 4 54 1108 Diamond St 1 1 1 1       3x3   6001901.0 2100825.0 37.7485726639367 -122.43621121860001 (37.7485726639367, -122.4362112186)
28625 217557 2 54 111 Broad St 1 1 1 1     0 Width 0ft   5995778.3452 2088036.9975 37.7131101315221 -122.456458551068 (37.7131101315221, -122.456458551068)
176452 200497 2 54 1110 Gilman Ave 1 2 1 1     0 Width 0ft   6014977.2953 2089975.1673 37.7195154981888 -122.39023527774799 (37.7195154981888, -122.390235277748)
88179 105438 2 54 1116 Castro St 2 1 1 1       3x3   6002483.0 2102334.0 37.75274907025911 -122.43430654109899 (37.7527490702591, -122.434306541099)
104872 105437 2 54 1116 Castro St 1 1 1 1       3x3   6002483.0 2102334.0 37.75274907025911 -122.43430654109899 (37.7527490702591, -122.434306541099)
74672 140885 2 54 112 COMMONWEALTH AVE 1 2 1 1     0 Width 0ft   5996566.0494 2113683.1859999998 37.7835733852629 -122.45558854835899 (37.7835733852629, -122.455588548359)
68603 142716 3 54 1120 COLUMBUS AVE 2 1 1 1     0 Width 0ft   6008073.8404 2121121.2819 37.804650203273 -122.416302902461 (37.804650203273, -122.416302902461)
171950 200244 2 54 1123 Hollister Ave 1 19 1 1     0 Width 0ft   6014193.5615 2090152.5722 37.7199591140845 -122.39295678576201 (37.7199591140845, -122.392956785762)
76283 244483 2 54 1124 Page St 1 1 1 1     0 Width 0ft   6001145.6174 2109366.8236 37.7719834774065 -122.439435529733 (37.7719834774065, -122.439435529733)
177939 200226 2 54 1131 Fitzgerald Ave 1 2 1 1     0 Width 0ft   6015013.4132 2090222.9153 37.720197768832605 -122.390127728915 (37.7201977688326, -122.390127728915)
157610 200239 2 54 1131 Hollister Ave 1 19 1 1     0 Width 0ft   6014148.6234 2090188.791 37.7200560674381 -122.39311465541401 (37.7200560674381, -122.393114655414)
127351 35482 1 54 1136 Silver Ave 1 1 1 1 1 09/16/2000 12:00:00 AM     Permit Number 40088 6008340.04148266 2093836.36406151 37.7297471396453 -122.413450843683 (37.7297471396453, -122.413450843683)
144324 120651 2 54 114 Fair Oaks St 1 1 1 1       3x3   6005371.0 2102934.0 37.7545600310384 -122.424361977892 (37.7545600310384, -122.424361977892)
75983 183877 2 54 1145 Quintara St 1 2 1 1     0 Width 0ft   5989814.4341 2101045.8603 37.7484849666087 -122.47802208270001 (37.7484849666087, -122.4780220827)
37734 137587 2 54 1150 PIERCE ST 8 1 1 1     0 Width 0ft   6002352.8955 2112542.7356 37.78077237103221 -122.435486703411 (37.7807723710322, -122.435486703411)
74459 137586 2 54 1150 PIERCE ST 7 1 1 1     0 Width 0ft   6002357.4789 2112504.0318 37.7806663604621 -122.435468077701 (37.7806663604621, -122.435468077701)
135485 137588 2 54 1150 PIERCE ST 9 1 1 1     0 Width 0ft   6002345.2566 2112562.5967 37.7808264707559 -122.435514551268 (37.7808264707559, -122.435514551268)
136289 137589 2 54 1150 PIERCE ST 10 1 1 1     0 Width 0ft   6002346.2752 2112589.0782 37.780899240130296 -122.435512922421 (37.7808992401303, -122.435512922421)
36850 141882 2 54 1160 WEBSTER ST 1 1 1 1     0 Width 0ft   6003839.6945 2112655.4467 37.7811661774464 -122.430351190021 (37.7811661774464, -122.430351190021)
161 142720 2 54 1170 COLUMBUS AVE 3 1 1 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
39749 139753 2 54 1171 Gough St 1 1 1 1     0 Width 0ft   6005547.6328 2113641.325 37.7839697525349 -122.424512713511 (37.7839697525349, -122.424512713511)
39107 139604 2 54 1173 SCOTT ST 2 1 1 1     0 Width 0ft   6001838.238 2112425.6952 37.7804217645564 -122.437258767268 (37.7804217645564, -122.437258767268)
172283 200182 2 54 1175 Ingerson Ave 2 1 1 1     0 Width 0ft   6013359.1884 2090422.8715 37.720654919465396 -122.395859877099 (37.7206549194654, -122.395859877099)
185802 200181 2 54 1175 Ingerson Ave 1 9 1 1     0 Width 0ft   6013299.4945 2090456.4074 37.7207436812319 -122.396068570714 (37.7207436812319, -122.396068570714)
40807 200183 2 54 1197 Hollister Ave 1 19 1 1     0 Width 0ft   6013828.6909 2090422.2008 37.7206791862384 -122.39423689451401 (37.7206791862384, -122.394236894514)
31430 141865 2 54 1198 TURK ST 1 1 1 1     0 Width 0ft   6004361.706 2112589.3295 37.7810141909048 -122.42854057505699 (37.7810141909048, -122.428540575057)
125370 3826 3 54 120 Cashmere St 1 1 1 2   11/16/1992 12:00:00 AM 3 3X3   6016868.5122165 2095917.6664165 37.7359371538987 -122.384111573291 (37.7359371538987, -122.384111573291)
33464 200884 2 54 1200 16th St 1 1 1 1     0 Width 0ft   6012817.0471 2107089.1245 37.7663867409086 -122.39890301603998 (37.7663867409086, -122.39890301604)
36416 183338 2 54 1200 La Playa 1 1 1 1     0 Width 0ft   5980889.0479 2106803.3028 37.7637711641625 -122.50931286551399 (37.7637711641625, -122.509312865514)
54059 185599 2 54 1200 Quintara St 1 2 1 1     0 Width 0ft   5989708.1577 2101099.3093 37.7486255543569 -122.47839348828 (37.7486255543569, -122.47839348828)
179934 185601 2 54 1200 Quintara St 3 2 1 1     0 Width 0ft   5989640.5487 2101098.6399 37.7486197911777 -122.478627227884 (37.7486197911777, -122.478627227884)
70132 186781 2 54 1200 Sunset Blvd 49 9 1 1     4 Width 0ft   5984857.4742 2106824.7830000003 37.764063324835796 -122.49558908498399 (37.7640633248358, -122.495589084984)
168416 186800 2 54 1200 Sunset Blvd 78 9 1 1     3 Width 0ft   5984846.2035 2106925.1049 37.7643381205783 -122.495635466651 (37.7643381205783, -122.495635466651)
169869 186771 2 54 1200 Sunset Blvd 39 9 1 1     4 Width 0ft   5984865.2362 2106774.8154 37.7639265823683 -122.495558553205 (37.7639265823683, -122.495558553205)
42137 186840 2 54 1201 36th Ave 2 2 1 1     0 Width 0ft   5984884.6409 2106758.5555 37.763883073514 -122.495490239842 (37.763883073514, -122.495490239842)
155391 183316 2 54 1201 39th Ave 1 1 1 1     0 Width 0ft   5983946.4232 2106931.1378 37.764301953552106 -122.498747951587 (37.7643019535521, -122.498747951587)
176831 184891 2 54 1201 Sunset Blvd 2 2 1 1     0 Width 0ft   5984723.2958 2106746.9726 37.7638418212229 -122.49604742094299 (37.7638418212229, -122.496047420943)
2270 253008 1 54 1201 Tennessee St 1 1 2 1   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
83041 109366 1 54 1205 Filbert St 3 5 2 1 1 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
Powered by Datasette · Query took 16.135ms · Data source: data.sfgov.org