sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
136004 119197 2 1 850 La Playa 3 1 1 1     10 Width 3ft   5980800.71853 2109703.31069 37.771728531734794 -122.50983380285 (37.7717285317348, -122.50983380285)
41141 119198 2 1 850 La Playa 2 1 1 1     11 Width 3ft   5980803.32606 2109672.6528 37.771644507950896 -122.50982250562599 (37.7716445079509, -122.509822505626)
131773 119165 2 1 850 La Playa 1 1 1 1     6 Width 3ft   5980803.057 2109634.63853 37.7715401160565 -122.50982061198098 (37.7715401160565, -122.509820611981)
132935 118679 2 1 4749 Balboa St 3 1 1 1     8 Width 4ft   5980848.5753 2110916.87516 37.7750634448303 -122.509758426999 (37.7750634448303, -122.509758426999)
63333 118678 2 108 4749 Balboa St 2 10 1 1     4 Width 3ft   5980862.87698 2110909.19366 37.77504319711021 -122.50970838455 (37.7750431971102, -122.50970838455)
38458 118677 2 108 4749 Balboa St 1 10 1 1     8 Width 3ft   5980875.63021 2110909.60557 37.7750450801709 -122.50966429974702 (37.7750450801709, -122.509664299747)
173832 183666 2 1 1301 Lower Great Hwy 1 1 1 1     13 Width 0ft   5980807.2532 2105649.1672 37.7605974181757 -122.509510037409 (37.7605974181757, -122.509510037409)
58803 183667 2 1 1301 Lower Great Hwy 2 1 1 1     14 Width 0ft   5980810.0798 2105619.8412 37.7605170641014 -122.509498083519 (37.7605170641014, -122.509498083519)
156549 183668 2 1 1301 Lower Great Hwy 3 1 1 1     13 Width 0ft   5980813.613 2105594.4018 37.760447423174206 -122.509483974564 (37.7604474231742, -122.509483974564)
149444 184330 2 1 1301 Lower Great Hwy 4 1 1 1     14 Width 0ft   5980817.5309 2105553.3064 37.7603348180604 -122.50946737235701 (37.7603348180604, -122.509467372357)
159785 186621 2 1 1301 Lower Great Hwy 5 1 1 1     15 Width 0ft   5980819.2183 2105525.4648 37.7602584725403 -122.50945946869 (37.7602584725403, -122.50945946869)
160086 186622 2 1 1301 Lower Great Hwy 6 1 1 1     14 Width 0ft   5980820.062000001 2105514.4969 37.760228407593104 -122.509455736178 (37.7602284075931, -122.509455736178)
60784 186623 2 1 1301 Lower Great Hwy 7 1 1 1     12 Width 0ft   5980820.9057 2105500.9979 37.760191392973496 -122.50945181568198 (37.7601913929735, -122.509451815682)
45218 250986 2 2 185 Seal Rock Dr 1 4 1 1     16 Width 3ft   5980980.82201 2112923.78682 37.7805816277787 -122.50945005058 (37.7805816277787, -122.50945005058)
78490 108957 2 17 1401X GREAT HWY 5 1 1 3   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823.0 2105507.0 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403)
86287 108954 2 17 1401X GREAT HWY 2 1 1 3   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823.0 2105507.0 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403)
112267 108955 2 17 1401X GREAT HWY 3 1 1 3   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823.0 2105507.0 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403)
116607 108953 2 17 1401X GREAT HWY 1 1 1 3   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823.0 2105507.0 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403)
141246 108956 2 17 1401X GREAT HWY 4 1 1 3   02/10/2015 12:00:00 AM 3 4x4 Permit Number 774900 5980823.0 2105507.0 37.7602079965022 -122.509445018403 (37.7602079965022, -122.509445018403)
66965 186624 2 1 1301 Lower Great Hwy 8 1 1 1     13 Width 0ft   5980825.1241 2105476.531 37.7601244626444 -122.509435409323 (37.7601244626444, -122.509435409323)
150532 186487 2 1 1301 Lower Great Hwy 9 1 1 1     15 Width 0ft   5980829.9285 2105384.5624 37.75987222661821 -122.509411963006 (37.7598722266182, -122.509411963006)
166500 184360 2 1 1301 Lower Great Hwy 10 1 1 1     15 Width 0ft   5980832.1706 2105363.038 37.7598132590094 -122.50940261021799 (37.7598132590094, -122.509402610218)
31308 181437 2 1 1300 Lower Great Hwy 6 1 1 1     9 Width 0ft   5980841.348999999 2105728.8419999997 37.7608181926765 -122.50939803508601 (37.7608181926765, -122.509398035086)
129643 181436 2 1 1300 Lower Great Hwy 4 1 1 1     2 Width 0ft   5980846.2956 2105673.7233 37.7606671442701 -122.50937683368299 (37.7606671442701, -122.509376833683)
170848 181602 2 1 1300 Lower Great Hwy 5 1 1 1     9 Width 0ft   5980850.9081 2105690.7559 37.76071418284771 -122.5093621464 (37.7607141828477, -122.5093621464)
75339 103704 2 2 4700 Cabrillo St 5 1 1 1     11 4x4   5980950.21824 2110299.88198 37.7733753570212 -122.50936099615801 (37.7733753570212, -122.509360996158)
118624 109510 2 1 7200X FULTON ST 3 1 1 1       3x3   5980935.0 2109588.0 37.7714198408482 -122.509360757847 (37.7714198408482, -122.509360757847)
47354 119238 2 224 4701 Cabrillo St 2 9 1 1     6 Width 3ft   5980953.58736 2110230.22563 37.773184299817096 -122.509344168 (37.7731842998171, -122.509344168)
135357 181601 2 1 1300 Lower Great Hwy 3 1 1 1     7 Width 0ft   5980856.8807 2105634.5433 37.7605601913922 -122.509337315457 (37.7605601913922, -122.509337315457)
27191 186631 2 47 1300 Lower Great Hwy 7 19 1 1     2 Width 0ft   5980860.0426 2105683.7293 37.7606954284135 -122.50933003298901 (37.7606954284135, -122.509330032989)
23578 181600 2 1 1300 Lower Great Hwy 2 1 1 1     9 Width 0ft   5980858.6373 2105611.0043 37.7604956636473 -122.50932949211399 (37.7604956636473, -122.509329492114)
73687 186630 2 47 1300 Lower Great Hwy 6 19 1 1     2 Width 0ft   5980860.7453 2105672.8381 37.7606655657469 -122.50932679385099 (37.7606655657469, -122.509326793851)
155462 186632 2 47 1300 Lower Great Hwy 8 19 1 1     5 Width 0ft   5980861.0966 2105687.2426 37.7607051370684 -122.509326648666 (37.7607051370684, -122.509326648666)
157705 181599 2 1 1300 Lower Great Hwy 1 1 1 1     9 Width 0ft   5980858.9886 2105581.4927 37.760414654003 -122.509326085413 (37.760414654003, -122.509326085413)
170571 186629 2 1 1300 Lower Great Hwy 5 19 1 1     3 Width 0ft   5980862.5019 2105665.4602 37.7606454117292 -122.50932017074 (37.7606454117292, -122.50932017074)
155117 186636 2 2 1300 Lower Great Hwy 12 19 1 1     3 Width 0ft   5980864.6099 2105729.0507 37.7608201372164 -122.509317602916 (37.7608201372164, -122.509317602916)
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)
158735 186635 2 1 1300 Lower Great Hwy 11 19 1 1     4 Width 0ft   5980866.0152 2105705.863 37.7607565533288 -122.50931102062 (37.7607565533288, -122.50931102062)
63003 118456 2 1 490 48th Ave 1 1 1 1     21 Width 3ft   5981010.56733 2112424.984 37.7792138173967 -122.50931009492099 (37.7792138173967, -122.509310094921)
182740 118457 2 1 490 48th Ave 2 1 1 1     21 Width 3ft   5981011.746169999 2112476.4222 37.779355120923 -122.509309837992 (37.779355120923, -122.509309837992)
67142 118470 2 18 510 48th Ave 1 1 1 1     1 Width 3ft   5981008.92024 2112222.55161 37.7786579010228 -122.50930075514499 (37.7786579010228, -122.509300755145)
43243 103703 2 108 4700 Cabrillo St 4 1 1 1     5 4x4   5980967.69346 2110300.1672 37.7733771705098 -122.509300569193 (37.7733771705098, -122.509300569193)
58204 183260 2 108 1220 La Playa 2 1 1 1     3 Width 0ft   5980890.8145 2106708.2585 37.763510304179995 -122.509299696626 (37.76351030418, -122.509299696626)
180173 186625 2 2 1300 Lower Great Hwy 1 19 1 1     2 Width 0ft   5980868.2988 2105582.371 37.76041761449721 -122.50929395155 (37.7604176144972, -122.50929395155)
68383 183259 2 108 1220 La Playa 1 1 1 1     3 Width 0ft   5980894.3477 2106672.2193 37.7634115592808 -122.50928480005899 (37.7634115592808, -122.509284800059)
52895 186634 2 2 1300 Lower Great Hwy 10 19 1 1     2 Width 0ft   5980874.0957 2105690.7559 37.7607155500113 -122.509281952349 (37.7607155500113, -122.509281952349)
133309 186628 2 1 1300 Lower Great Hwy 4 19 1 1     5 Width 0ft   5980874.0957 2105652.4611 37.760610403518 -122.509279108369 (37.760610403518, -122.509279108369)
137510 118414 2 47 641 48th Ave 1 9 1 1     26     5980997.21538 2111360.64896 37.7762906814163 -122.509277221064 (37.7762906814163, -122.509277221064)
174389 186633 2 47 1300 Lower Great Hwy 9 19 1 1     3 Width 0ft   5980876.555 2105686.5399 37.760704119089 -122.509273133786 (37.760704119089, -122.509273133786)
69172 186627 2 1 1300 Lower Great Hwy 3 19 1 1     3 Width 0ft   5980877.609 2105668.6222 37.760654984387706 -122.509268157881 (37.7606549843877, -122.509268157881)
153024 186626 2 47 1300 Lower Great Hwy 2 19 1 1     7 Width 0ft   5980879.19 2105650.5288 37.7606053983358 -122.509261346313 (37.7606053983358, -122.509261346313)
24690 103701 2 2 4700 Cabrillo St 3 1 1 1     14 4x4   5980981.42101 2110300.97358 37.7733801939619 -122.50925314442 (37.7733801939619, -122.50925314442)
150810 186483 2 1 1400 Lower Great Hwy 38 19 1 1     5 Width 0ft   5980878.6055 2105409.1394 37.7599425780444 -122.509245441233 (37.7599425780444, -122.509245441233)
61319 186489 2 1 1400 Lower Great Hwy 35 19 1 1     4 Width 0ft   5980878.6055 2105387.9124 37.759884294807 -122.509243864844 (37.759884294807, -122.509243864844)
153493 118477 2 2 562 48th Ave 1 2 1 1     7 Width 3ft   5981021.8691 2111857.25612 37.7776556713315 -122.509228826135 (37.7776556713315, -122.509228826135)
51431 186843 2 1 1400 Lower Great Hwy 33 19 1 1     7 Width 0ft   5980882.2296 2105351.6713 37.759785000838704 -122.509228639712 (37.7597850008387, -122.509228639712)
167264 186490 2 105 1400 Lower Great Hwy 36 19 1 1     1 Width 0ft   5980883.265 2105397.7493 37.7599115788226 -122.509228480711 (37.7599115788226, -122.509228480711)
147843 186500 2 1 1400 Lower Great Hwy 28 19 1 1     2 Width 0ft   5980882.7473 2105316.9833 37.7596897880858 -122.509224273257 (37.7596897880858, -122.509224273257)
63349 186499 2 1 1400 Lower Great Hwy 27 19 1 1     1 Width 0ft   5980882.7473 2105311.2882 37.7596741509783 -122.50922385032601 (37.7596741509783, -122.509223850326)
49608 186504 2 1 1400 Lower Great Hwy 32 19 1 1     4 Width 0ft   5980883.7828 2105343.3876 37.7597623477539 -122.50922265288601 (37.7597623477539, -122.509222652886)
157531 186484 2 1 1400 Lower Great Hwy 24 19 1 1     2 Width 0ft   5980883.7828 2105293.6854 37.7596258798004 -122.50921896188801 (37.7596258798004, -122.509218961888)
70661 186503 2 1 1400 Lower Great Hwy 31 19 1 1     4 Width 0ft   5980885.336 2105334.0684 37.759736851483396 -122.50921658916701 (37.7597368514834, -122.509216589167)
65556 186486 2 1 1400 Lower Great Hwy 26 19 1 1     2 Width 0ft   5980884.8182 2105306.6287 37.759661479426796 -122.509216342217 (37.7596614794268, -122.509216342217)
67642 118478 2 18 578 48th Ave 1 2 1 1     8 Width 3ft   5981024.51617 2111800.84509 37.7775009394111 -122.509215478972 (37.7775009394111, -122.509215478972)
30380 186493 2 1 1400 Lower Great Hwy 23 19 1 1     2 Width 0ft   5980884.8182 2105286.9549 37.7596074608269 -122.509214881201 (37.7596074608269, -122.509214881201)
49038 186494 2 1 1400 Lower Great Hwy 19 19 1 1     2 Width 0ft   5980884.3005 2105262.6215 37.7595406177816 -122.50921486458799 (37.7595406177816, -122.509214864588)
58818 186492 2 1 1400 Lower Great Hwy 22 19 1 1     2 Width 0ft   5980885.336 2105278.6712 37.759584746696 -122.509212475259 (37.759584746696, -122.509212475259)
166154 186488 2 47 1400 Lower Great Hwy 34 19 1 1     15 Width 0ft   5980888.4423 2105382.2174 37.7598692379346 -122.50920942183998 (37.7598692379346, -122.50920942184)
167996 186482 2 1 1400 Lower Great Hwy 37 19 1 1     3 Width 0ft   5980889.9955 2105407.5862 37.7599389849374 -122.50920593411199 (37.7599389849374, -122.509205934112)
53673 103700 2 108 4700 Cabrillo St 2 1 1 1     5 4x4   5980996.66702 2110300.42587 37.773379588986394 -122.509200366595 (37.7733795889864, -122.509200366595)
166592 118482 2 12 8349 Geary Blvd 4 9 1 1     1     5981039.36975 2112282.68151 37.7788247951526 -122.509199886896 (37.7788247951526, -122.509199886896)
69350 186498 2 1 1400 Lower Great Hwy 18 19 1 1     2 Width 0ft   5980888.4423 2105252.2669 37.7595124312164 -122.5091997715 (37.7595124312164, -122.5091997715)
180522 250985 2 93 169 Seal Rock Dr 1 4 1 1     5 Width 3ft   5981053.81587 2112927.8042099997 37.7805969621145 -122.509197833038 (37.7805969621145, -122.509197833038)
182255 186502 2 1 1400 Lower Great Hwy 30 19 1 1     5 Width 0ft   5980892.5842 2105334.0684 37.7597372788194 -122.509191521679 (37.7597372788194, -122.509191521679)
129570 186495 2 1 1400 Lower Great Hwy 20 19 1 1     3 Width 0ft   5980891.5487 2105262.6215 37.7595410451172 -122.509189797166 (37.7595410451172, -122.509189797166)
151681 118454 2 62 8350 Geary Blvd 1 9 1 1     7     5981044.43167 2112373.0207700003 37.7790731383894 -122.50918908645399 (37.7790731383894, -122.509189086454)
51060 183255 2 54 1300 La Playa 4 1 1 1     0 Width 0ft   5980911.3073 2106159.7216 37.762005388573606 -122.509188082818 (37.7620053885736, -122.509188082818)
46197 186496 2 1 1400 Lower Great Hwy 16 19 1 1     2 Width 0ft   5980891.5487 2105237.2527 37.7594713896823 -122.509187913256 (37.7594713896823, -122.509187913256)
47007 186501 2 1 1400 Lower Great Hwy 29 19 1 1     3 Width 0ft   5980893.6197 2105317.501 37.7596918505514 -122.50918671014799 (37.7596918505514, -122.509186710148)
99492 110751 2 18 510 48th Ave 1 1 1 1   05/05/2015 12:00:00 AM 3   Permit Number 775489 5981042.2 2112214.0 37.778636382962 -122.509184994454 (37.778636382962, -122.509184994454)
162558 183254 2 54 1300 La Playa 3 1 1 1     0 Width 0ft   5980911.6607 2106131.1023 37.76192682906861 -122.50918473520399 (37.7619268290686, -122.509184735204)
52894 186485 2 1 1400 Lower Great Hwy 25 19 1 1     9 Width 0ft   5980894.6551 2105298.8627 37.7596407361809 -122.50918174518299 (37.7596407361809, -122.509181745183)
159650 109509 2 2 7200X Fulton St 2 1 1 1     1 3x3   5980988.44063 2109621.98513 37.7715163048766 -122.50917843155399 (37.7715163048766, -122.509178431554)
58408 186491 2 1 1400 Lower Great Hwy 21 19 1 1     8 Width 0ft   5980895.1728 2105273.4939 37.759571111269004 -122.509178070846 (37.759571111269, -122.509178070846)
24192 183253 2 141 1300 La Playa 2 1 1 1     4 Width 0ft   5980913.074 2106102.483 37.7618483320506 -122.50917772189 (37.7618483320506, -122.50917772189)
23747 186497 2 1 1400 Lower Great Hwy 17 19 1 1     2 Width 0ft   5980894.6551 2105244.501 37.7594914745751 -122.509177708249 (37.7594914745751, -122.509177708249)
29234 186513 2 38 1400 Lower Great Hwy 14 19 1 1     5 Width 0ft   5980894.1374 2105147.1675 37.759224194224 -122.509172270667 (37.759224194224, -122.509172270667)
52773 183252 2 38 1300 La Playa 1 1 1 1     10 Width 0ft   5980914.4873 2106074.2169999997 37.761770805091096 -122.50917073482799 (37.7617708050911, -122.509170734828)
130131 118484 2 75 8349 Geary Blvd 2 2 1 1     17     5981049.15965 2112307.0389 37.7788922504996 -122.50916782963499 (37.7788922504996, -122.509167829635)
174165 186511 2 1 1400 Lower Great Hwy 12 19 1 1     5 Width 0ft   5980895.6906 2105140.9548 37.7592072275053 -122.509166437696 (37.7592072275053, -122.509166437696)
31425 119228 2 2 701 48th Ave 1 1 1 1     19 Width 4ft   5981020.55796 2110899.83837 37.7750268077692 -122.509162246597 (37.7750268077692, -122.509162246597)
27012 186514 2 1 1400 Lower Great Hwy 15 19 1 1     4 Width 0ft   5980897.7615 2105153.3803 37.759241466452295 -122.509160198369 (37.7592414664523, -122.509160198369)
37608 119226 2 2 715 48th Ave 1 1 1 1     17 Width 4ft   5981020.44403 2110823.32053 37.774816705617106 -122.509156957318 (37.7748167056171, -122.509156957318)
157477 119227 2 2 711 48th Ave 1 1 1 1     23 Width 4ft   5981021.77199 2110849.56022 37.7748888303639 -122.50915431266199 (37.7748888303639, -122.509154312662)
131767 186507 2 1 1400 Lower Great Hwy 8 19 1 1     5 Width 0ft   5980898.797 2105106.7845 37.759113588816 -122.509153157003 (37.759113588816, -122.509153157003)
182655 186512 2 38 1400 Lower Great Hwy 13 19 1 1     5 Width 0ft   5980899.8324 2105147.1675 37.7592245299801 -122.509152574968 (37.7592245299801, -122.509152574968)
127053 103699 2 2 4700 Cabrillo St 1 1 1 1     12 4x4   5981012.38843 2110301.40953 37.7733832167065 -122.509146058065 (37.7733832167065, -122.509146058065)
50995 186509 2 38 1400 Lower Great Hwy 10 19 1 1     7 Width 0ft   5980901.3856 2105130.6001 37.759179132228 -122.509145973072 (37.759179132228, -122.509145973072)
66913 186510 2 38 1400 Lower Great Hwy 11 19 1 1     5 Width 0ft   5980902.4211 2105136.8129 37.759196251841395 -122.509142853237 (37.7591962518414, -122.509142853237)
26095 119225 2 2 727 48th Ave 1 1 1 1     14 Width 3ft   5981023.84612 2110741.39714 37.7745919686982 -122.509139104186 (37.7745919686982, -122.509139104186)
130883 118392 2 2 626 48th Ave 1 1 1 1     12 Width 3ft   5981039.09397 2111430.83509 37.7764858608449 -122.50913756719 (37.7764858608449, -122.50913756719)
Powered by Datasette · Query took 95.841ms · Data source: data.sfgov.org