sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
122316 99339 3 2 450 30th Ave 17 1 1 4 2   12 3.5x3.5   5986576.130469999 2112991.43823 37.7810957151351 -122.49009845653799 (37.7810957151351, -122.490098456538)
104011 99337 3 2 450 30th Ave 15 1 1 4 2   30 4x4   5986576.2181 2112940.18967 37.7809550063526 -122.490094382689 (37.7809550063526, -122.490094382689)
91017 99338 3 60 450 30th Ave 16 1 1 4 2   4 3X3   5986576.26956 2112967.74794 37.7810306764919 -122.490096232309 (37.7810306764919, -122.490096232309)
86659 99336 3 60 450 30th Ave 14 1 1 4 2   3 3x3   5986577.60051 2112919.49158 37.7808982560395 -122.490088077428 (37.7808982560395, -122.490088077428)
124662 99335 3 39 450 30th Ave 13 1 1 4 2   30 3.5x3.5   5986578.25407 2112899.8451 37.780844350584005 -122.490084370963 (37.780844350584, -122.490084370963)
109890 99334 3 60 450 30th Ave 12 1 1 4 2   4 3x3   5986579.77919 2112870.79018 37.780764663134896 -122.49007695716298 (37.7807646631349, -122.490076957163)
84682 99332 3 2 450 30th Ave 10 1 1 4 2   8 4x4   5986580.56369 2112816.99686 37.7806170078534 -122.490070285368 (37.7806170078534, -122.490070285368)
140800 47197 3 39 2899X Clement St 1 1 1 4 2 05/08/2002 12:00:00 AM 3 3x3   5986581.22601267 2112881.07204474 37.7807929786872 -122.490072708464 (37.7807929786872, -122.490072708464)
126708 99331 3 2 450 30th Ave 9 1 1 4 2   6 3x3   5986581.6367 2112796.91447 37.780561930004296 -122.49006509580099 (37.7805619300043, -122.490065095801)
97193 99333 3 2 450 30th Ave 11 1 1 4 2   30 4x4   5986581.860780001 2112837.6690700003 37.7806738435833 -122.490067319136 (37.7806738435833, -122.490067319136)
127043 95458 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986582.44659 2111474.61787 37.7769313271764 -122.48996501092199 (37.7769313271764, -122.489965010922)
119293 99330 3 2 450 30th Ave 8 1 1 4 2   8 4x4   5986582.509190001 2112777.47658 37.780508610058 -122.490060647344 (37.780508610058, -122.490060647344)
115568 95457 2 2 601X 30th Ave 1 1 1 4 2   6 3x3   5986582.95432 2111498.49198 37.776996908357 -122.48996501091601 (37.776996908357, -122.489965010916)
139544 47198 3 2 450 30th Ave 7 1 1 4 2 05/08/2002 12:00:00 AM 8 4x4 Permit Number 45157 5986584.00139 2112756.95832 37.780452359911706 -122.490053975567 (37.7804523599117, -122.490053975567)
88275 47199 3 2 450 30th Ave 6 1 1 4 2 05/08/2002 12:00:00 AM 8 4x4 Permit Number 45157 5986584.12235 2112732.41489 37.7803849777225 -122.49005175134701 (37.7803849777225, -122.490051751347)
139260 99329 3 2 450 30th Ave 5 1 1 4 2   5 3x3   5986584.84396 2112715.96758 37.7803398602424 -122.49004804489701 (37.7803398602424, -122.490048044897)
86703 95460 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986585.7747 2111417.7398 37.77677535046679 -122.489949313769 (37.7767753504668, -122.489949313769)
104767 99328 3 2 450 30th Ave 4 1 1 4 2   8 3x3   5986586.09055 2112693.96092 37.780279509029604 -122.490042113304 (37.7802795090296, -122.490042113304)
97627 99327 3 2 450 30th Ave 3 1 1 4 2   4 3x3   5986588.015819999 2112673.6469799997 37.780223845173396 -122.49003395842699 (37.7802238451734, -122.490033958427)
126367 95461 2 2 601X 30th Ave 1 1 1 4 2   10 3x3   5986588.1418 2111391.86812 37.776704452390796 -122.489939222082 (37.7767044523908, -122.489939222082)
82909 95459 2 60 657X 30th Ave 1 1 1 4 2   18 3x3   5986588.2 2111449.2 37.776861872872 -122.48994323847201 (37.776861872872, -122.489943238472)
82878 60316 3 2 450 30th Ave 1 1 1 4 2 10/07/1982 12:00:00 AM 8 4x4   5986588.61699 2112633.05068 37.7801124144217 -122.490028891926 (37.7801124144217, -122.490028891926)
126588 99326 3 2 450 30th Ave 2 1 1 4 2   6 3x3   5986588.88353 2112653.99552 37.7801699385412 -122.490029510836 (37.7801699385412, -122.490029510836)
120350 95462 2 2 601X 30th Ave 1 1 1 4 2   3 3x3   5986590.675530001 2111282.39545 37.776404019422294 -122.489922403821 (37.7764040194223, -122.489922403821)
87154 95463 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986592.12306 2111264.12941 37.7763539505765 -122.489916052727 (37.7763539505765, -122.489916052727)
118537 95464 2 2 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986592.75422 2111242.97331 37.7762958987751 -122.48991231304501 (37.7762958987751, -122.489912313045)
127891 95465 2 41 601X 30th Ave 2 1 1 4 2   8 3x3   5986594.5418 2111220.3413400003 37.7762338621769 -122.489904464478 (37.7762338621769, -122.489904464478)
115776 47200 3 39 2801X Clement St 2 1 1 4 2 05/08/2002 12:00:00 AM 6 3x3 Permit Number 45157 5986636.7904199995 2113215.6243 37.7817148081587 -122.489905099586 (37.7817148081587, -122.489905099586)
84343 47201 3 39 2801X Clement St 3 1 1 4 2 05/08/2002 12:00:00 AM 8 3x3 Permit Number 45157 5986666.180509999 2113215.9234599997 37.7817173456419 -122.489803447111 (37.7817173456419, -122.489803447111)
42328 115970 3 8 1599x 30TH AVE 7 1 1 4     0 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
95487 115964 3 8 1599x 30TH AVE 1 1 1 4     8 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
168456 115973 3 8 1599x 30TH AVE 10 1 1 4     0 3x3   5986686.0 2104596.0 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136)
81219 117257 3 15 1570 31ST AVE 5 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
85887 117255 3 53 1570 31ST AVE 3 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
94173 117256 3 53 1570 31ST AVE 4 1 1 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
143144 105784 2 53 1570 31ST AVE 1 1 1 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
138862 47202 3 39 2801X Clement St 4 1 1 4 2 05/08/2002 12:00:00 AM 12 3x3 Permit Number 45157 5986698.68199 2113217.08014 37.7817224192006 -122.489691093913 (37.7817224192006, -122.489691093913)
106239 47203 3 39 2801X Clement St 5 1 1 4 2 05/08/2002 12:00:00 AM 10 3x3 Permit Number 45157 5986727.74959 2113216.7702900004 37.7817232655044 -122.48959051227101 (37.7817232655044, -122.489590512271)
160302 115965 3 8 1599x 30th Ave 2 1 1 4     7 3x3   5986811.649 2104744.2782 37.758465070521105 -122.488677324697 (37.7584650705211, -122.488677324697)
175061 115966 3 8 1599x 30th Ave 3 1 1 4     6 3x3   5986811.649 2104717.0256 37.7583902423484 -122.488675321582 (37.7583902423484, -122.488675321582)
48933 115967 3 8 1599x 30th Ave 4 1 1 4     4 3x3   5986812.8086 2104676.4366 37.758278863742106 -122.488668327875 (37.7582788637421, -122.488668327875)
13009 115969 3 41 1599x 30th Ave 6 1 1 4     2 3x3   5986813.3885 2104627.15 37.7581435700771 -122.488662699732 (37.7581435700771, -122.488662699732)
164886 115968 3 8 1599x 30th Ave 5 1 1 4     6 3x3   5986813.3885 2104648.6042 37.7582024774349 -122.48866427663799 (37.7582024774349, -122.488664276638)
166151 115971 3 8 1599x 30th Ave 8 1 1 4     4 3x3   5986813.9683 2104572.6448 37.757993947556 -122.48865668838499 (37.757993947556, -122.488656688385)
177652 115972 3 8 1599x 30th Ave 9 1 1 4     8 3x3   5986817.4474 2104547.1317 37.757924098588795 -122.488642781125 (37.7579240985888, -122.488642781125)
82051 99347 3 2 451X 29th Ave 1 1 1 4 2   3 3x3   5986832.70752 2113173.16715 37.7816096708126 -122.489224205331 (37.7816096708126, -122.489224205331)
83441 99349 3 2 451X 29th Ave 3 1 1 4 2   8 3x3   5986833.62785 2113132.91132 37.781499193517 -122.489218060865 (37.781499193517, -122.489218060865)
111856 99348 3 2 451X 29th Ave 2 1 1 4 2   10 3x3   5986834.12581 2113156.3350299997 37.7815635374039 -122.48921806087401 (37.7815635374039, -122.489218060874)
114467 99352 3 2 451X 29th Ave 6 1 1 4 2   10 3x3   5986835.92891 2113074.05562 37.781337726878206 -122.489205771916 (37.7813377268782, -122.489205771916)
82527 99350 3 2 451X 29th Ave 4 1 1 4 2   10 3x3   5986835.93382 2113116.0605599997 37.7814530607414 -122.48920884414801 (37.7814530607414, -122.489208844148)
102838 99353 3 2 451X 29th Ave 7 1 1 4 2   8 3x3   5986836.83736 2113054.13933 37.781283095456 -122.489201164445 (37.781283095456, -122.489201164445)
106710 99351 3 2 451X 29th Ave 5 1 1 4 2   6 3x3   5986837.3239400005 2113097.9024799997 37.7814032849786 -122.48920269965099 (37.7814032849786, -122.489202699651)
128470 99356 3 2 451X 29th Ave 10 1 1 4 2   10 3x3   5986838.12863 2112989.55693 37.781105845983 -122.489191947731 (37.781105845983, -122.489191947731)
83643 99358 3 2 451X 29th Ave 12 1 1 4 2   8 3x3   5986838.55817 2112947.1003900003 37.7809892975063 -122.489187339371 (37.7809892975063, -122.489187339371)
106953 99355 3 2 451X 29th Ave 9 1 1 4 2   12 3x3   5986839.023440001 2113010.7614599997 37.7811641198035 -122.489190411627 (37.7811641198035, -122.489190411627)
138303 99357 3 2 451X 29th Ave 11 1 1 4 2   3 3x3   5986839.06552 2112970.96623 37.7810548559101 -122.489187339385 (37.7810548559101, -122.489187339385)
91293 99354 3 2 451X 29th Ave 8 1 1 4 2   8 3x3   5986839.805509999 2113026.66255 37.7812078253097 -122.489188875507 (37.7812078253097, -122.489188875507)
98081 99360 3 2 451X 29th Ave 14 1 1 4 2   10 3x3   5986841.26301 2112907.24873 37.7808800340934 -122.48917505132299 (37.7808800340934, -122.489175051323)
100990 99361 3 2 451X 29th Ave 15 1 1 4 2   6 3x3   5986841.31224 2112888.6768400003 37.78082904385229 -122.489173515193 (37.7808290438523, -122.489173515193)
94940 99359 3 2 451X 29th Ave 13 1 1 4 2   6 3x3   5986842.11085 2112926.2434400003 37.7809322376389 -122.48917351518499 (37.7809322376389, -122.489173515185)
89968 99362 3 2 451X 29th Ave 16 1 1 4 2   6 3x3   5986843.024069999 2112864.76375 37.7807634852432 -122.489165834601 (37.7807634852432, -122.489165834601)
112132 99365 3 2 451X 29th Ave 19 1 1 4 2   10 3x3   5986845.14154 2112755.50502 37.7804636155038 -122.48915047430201 (37.7804636155038, -122.489150474302)
123039 99363 3 2 451X 29th Ave 17 1 1 4 2   8 3x3 Permit Number 773617 5986845.56233 2112796.17507 37.7805753084335 -122.489152009534 (37.7805753084335, -122.489152009534)
114662 99364 3 2 451X 29th Ave 18 1 1 4 2   10 3x3 Permit Number 773617 5986846.87705 2112774.48123 37.7805158200694 -122.489145865965 (37.7805158200694, -122.489145865965)
142697 99369 3 2 451X 29th Ave 23 1 1 4 2   12 3x3   5986847.81361 2112672.3215799998 37.7802353734381 -122.489135113122 (37.7802353734381, -122.489135113122)
83791 99367 3 2 451X 29th Ave 21 1 1 4 2   10 3x3   5986848.243530001 2112713.4337400002 37.780348280813605 -122.489136649255 (37.7803482808136, -122.489136649255)
142333 99366 3 2 451X 29th Ave 20 1 1 4 2   10 3x3   5986848.25067 2112734.65735 37.7804065552175 -122.48913818535101 (37.7804065552175, -122.489138185351)
112307 99368 3 2 451X 29th Ave 22 1 1 4 2   8 3x3   5986849.57732 2112692.62378 37.7802912204421 -122.48913050474701 (37.7802912204421, -122.489130504747)
85591 99370 3 2 451X 29th Ave 24 1 1 4 2   6 3x3   5986851.72562 2112647.47743 37.7801673868145 -122.489119752829 (37.7801673868145, -122.489119752829)
127856 99371 3 2 451X 29th Ave 25 1 1 4 2   10 3x3   5986853.20034 2112633.2968599997 37.7801285370834 -122.48911360833598 (37.7801285370834, -122.489113608336)
61694 99372 3 2 499X 29th Ave 26 1 1 4 2   12 3x3   5986859.5 2112566.5 37.7799454996166 -122.48908690310101 (37.7799454996166, -122.489086903101)
106807 99373 3 2 499X 29th Ave 27 1 1 4 2   8 3x3   5986859.5 2112566.5 37.7799454996166 -122.48908690310101 (37.7799454996166, -122.489086903101)
58967 96572 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
80235 96569 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81160 96570 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
86907 96483 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
97749 96481 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
99207 96568 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
101102 96484 6 180 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
103034 96485 6 180 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
109217 96482 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
113578 96571 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
124197 96567 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
138508 96480 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
139752 92963 1 17 1515 Quintara St 4 1 1 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53121 5988690.8 2100920.9 37.7480765758445 -122.481898390884 (37.7480765758445, -122.481898390884)
41129 95156 1 10 250 23rd Ave 12 1 1 4 2   21     5988717.78601 2113765.0163 37.7833445754979 -122.48274619510799 (37.7833445754979, -122.482746195108)
146991 95155 1 10 250 23rd Ave 11 1 1 4 2   16     5988718.098730001 2113738.3311400004 37.7832713237769 -122.482743157022 (37.7832713237769, -122.482743157022)
70878 95154 1 10 250 23rd Ave 10 1 1 4 2   20     5988718.8555 2113711.8550400003 37.783198671909794 -122.48273859805 (37.7831986719098, -122.48273859805)
120054 95152 1 2 250 23rd Ave 8 1 1 4 2   10     5988720.65561 2113620.6282200003 37.7829482935383 -122.482725682965 (37.7829482935383, -122.482725682965)
183769 95151 1 2 250 23rd Ave 7 1 1 4 2   13     5988720.99449 2113605.53219 37.7829068638151 -122.482723403965 (37.7829068638151, -122.482723403965)
41571 95149 1 2 250 23rd Ave 5 1 1 4 2   15     5988721.12033 2113580.3815900004 37.7828378146839 -122.48272112492901 (37.7828378146839, -122.482721124929)
63647 95150 1 2 250 23rd Ave 6 1 1 4 2   12     5988721.361169999 2113591.74757 37.7828690364709 -122.482721124926 (37.7828690364709, -122.482721124926)
163336 95153 1 2 250 23rd Ave 9 1 1 4 2   18     5988721.4522400005 2113658.22406 37.783051567455004 -122.482725682991 (37.783051567455, -122.482725682991)
33468 95148 1 2 250 23rd Ave 4 1 1 4 2   14     5988724.779619999 2113566.5271900003 37.78279998730721 -122.482707449869 (37.7827999873072, -122.482707449869)
60314 95147 1 2 250 23rd Ave 3 1 1 4 2   13     5988726.59645 2113538.2792 37.7827225319963 -122.48269909375901 (37.7827225319963, -122.482699093759)
151441 70932 1 2 250 23rd Ave 2 1 1 4 2 03/11/1995 12:00:00 AM 14     5988727.46903 2113517.2675099997 37.7826648905872 -122.48269453478301 (37.7826648905872, -122.482694534783)
159681 73495 1 2 250 23rd Ave 1 1 1 4 2 03/11/1995 12:00:00 AM 10     5988730.14838 2113498.62278 37.7826138532986 -122.482683898749 (37.7826138532986, -122.482683898749)
99342 95260 3 51 2290X 14th Ave 8 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
106816 95261 3 51 2290X 14th Ave 9 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
119088 95258 3 51 2290X 14th Ave 6 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
138703 95262 3 51 2290X 14th Ave 10 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
Powered by Datasette · Query took 12.239ms · Data source: data.sfgov.org