sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2439 19802 3 176 100 STAIRWAY22 1 1 1 2     12 20            
5082 19803 3 176 100 STAIRWAY22 2 1 1 2     6 20            
7249 19805 3 176 100 STAIRWAY22 4 1 1 2     6 20            
7994 19761 3 176 100 STAIRWAY15 19 1 1 2     3 20ST            
11584 19594 3 176 100 STAIRWAY4 17 1 1 2     12 60            
87421 111309 2 176 100x GILROY ST 1 14 1 1       30x30   6015178.0 2088529.0 37.7155557353625 -122.38944056945101 (37.7155557353625, -122.389440569451)
91188 111312 2 176 99x GILROY ST 3 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
96975 111311 2 176 99x GILROY ST 2 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
123880 111310 2 176 99x GILROY ST 1 14 1 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
122000 107498 2 176 130 DENSLOWE DR 1 7 1 1           5990637.6 2091559.3 37.722485033503105 -122.474483407877 (37.7224850335031, -122.474483407877)
95045 107166 3 176 59X PROGRESS ST 1 7 1 2     12     6016967.0 2095036.0 37.7335217182981 -122.383709692997 (37.7335217182981, -122.383709692997)
38733 203289 2 176 160 Mangels Ave 1 9 1 1     1 Width 10ft   6000393.30235 2095252.23037 37.733185380101204 -122.441025059854 (37.7331853801012, -122.441025059854)
94393 111274 3 176 700X BOSWORTH ST 10 7 1 2     12     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
100217 111273 3 176 700X BOSWORTH ST 12 7 1 2     3     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
145712 111275 3 176 700X BOSWORTH ST 13 7 1 2     3     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
83858 111541 3 176 900x BOSWORTH ST 19 7 1 2     38     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
97189 111540 3 176 900x BOSWORTH ST 18 7 1 2     15     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
102684 111539 3 176 900x BOSWORTH ST 17 7 1 2     48     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
79865 802 3 176 2801X 37th Ave 3 1 1 2     12 3   5984931.1604164 2096158.6606148 37.7347813867821 -122.49454787659599 (37.7347813867821, -122.494547876596)
119362 801 3 176 2801X 37th Ave 2 1 1 2     12 3   5984931.1604164 2096158.6606148 37.7347813867821 -122.49454787659599 (37.7347813867821, -122.494547876596)
123161 800 3 176 2801X 37th Ave 1 1 1 2     12 3   5984931.1604164 2096158.6606148 37.7347813867821 -122.49454787659599 (37.7347813867821, -122.494547876596)
97463 762 3 176 2801X 36th Ave 2 1 1 2     12 3   5985236.9438562 2096168.6575935 37.734826727907404 -122.49349142956999 (37.7348267279074, -122.49349142957)
104959 763 3 176 2801X 36th Ave 3 1 1 2     12 3   5985236.9438562 2096168.6575935 37.734826727907404 -122.49349142956999 (37.7348267279074, -122.49349142957)
127679 761 3 176 2801X 36th Ave 1 1 1 2     18 3   5985236.9438562 2096168.6575935 37.734826727907404 -122.49349142956999 (37.7348267279074, -122.49349142957)
133421 185027 2 176 2701 Sunset Blvd 53 9 1 1     2 Width 0ft   5985036.876 2096313.2598 37.7352120616634 -122.494193777976 (37.7352120616634, -122.494193777976)
136736 185026 2 176 2701 Sunset Blvd 52 9 1 1     4 Width 0ft   5985036.4573 2096318.7032 37.735226983287 -122.49419562663799 (37.735226983287, -122.494195626638)
82364 799 3 176 2701X 37th Ave 2 1 1 2     3 3   5984908.6005282 2096802.2611077 37.7365472213829 -122.494673306076 (37.7365472213829, -122.494673306076)
100447 798 3 176 2701X 37th Ave 1 1 1 2     24 3   5984908.6005282 2096802.2611077 37.7365472213829 -122.494673306076 (37.7365472213829, -122.494673306076)
102368 759 3 176 2701X 36th Ave 1 1 1 2     3 3   5985213.1657551 2096831.867194 37.736646333728 -122.493622490313 (37.736646333728, -122.493622490313)
141112 760 3 176 2701X 36th Ave 2 1 1 2     24 3   5985213.1657551 2096831.867194 37.736646333728 -122.493622490313 (37.736646333728, -122.493622490313)
42917 221413 2 176 1000 San Jose Ave 102 7 1 1     3     6005081.29226 2097000.2093200001 37.738250839395 -122.424941718412 (37.738250839395, -122.424941718412)
105293 795 3 176 2601X 37th Ave 2 1 1 2     24 3   5984885.5905203 2097482.2850743 37.738413038065296 -122.494802982496 (37.7384130380653, -122.494802982496)
115417 794 3 176 2601X 37th Ave 1 1 1 2     24 3   5984885.5905203 2097482.2850743 37.738413038065296 -122.494802982496 (37.7384130380653, -122.494802982496)
118982 797 3 176 2601X 37th Ave 4 1 1 2     18 3   5984885.5905203 2097482.2850743 37.738413038065296 -122.494802982496 (37.7384130380653, -122.494802982496)
141901 796 3 176 2601X 37th Ave 3 1 1 2     24 3   5984885.5905203 2097482.2850743 37.738413038065296 -122.494802982496 (37.7384130380653, -122.494802982496)
91744 755 3 176 2601X 36th Ave 1 1 1 2     12 3   5985190.1942568 2097493.2421554 37.7384609486164 -122.493750633516 (37.7384609486164, -122.493750633516)
100225 758 3 176 2601X 36th Ave 4 1 1 2     24 3   5985190.1942568 2097493.2421554 37.7384609486164 -122.493750633516 (37.7384609486164, -122.493750633516)
106761 756 3 176 2601X 36th Ave 2 1 1 2     18 3   5985190.1942568 2097493.2421554 37.7384609486164 -122.493750633516 (37.7384609486164, -122.493750633516)
138744 757 3 176 2601X 36th Ave 3 1 1 2     24 3   5985190.1942568 2097493.2421554 37.7384609486164 -122.493750633516 (37.7384609486164, -122.493750633516)
121216 793 3 176 2501X 37th Ave 1 1 1 2     24 3   5984862.6770226 2098160.1830537 37.7402730222877 -122.49493217502199 (37.7402730222877, -122.494932175022)
87012 754 3 176 2501X 36th Ave 1 1 1 2     24 6   5985173.6238532 2098170.7777333 37.740320310041 -122.493857841511 (37.740320310041, -122.493857841511)
53610 104278 6 176 2 Allston Way 1 13 1 1           5994445.1 2098202.2 37.7409446783355 -122.461803277974 (37.7409446783355, -122.461803277974)
84302 104040 2 176 2487 15th Ave 2 1 1 1       2x3   5991681.3 2098507.3 37.741622913937604 -122.471381613625 (37.7416229139376, -122.471381613625)
111449 104039 2 176 2487 15th Ave 1 1 1 1       3x6   5991681.3 2098507.3 37.741622913937604 -122.471381613625 (37.7416229139376, -122.471381613625)
100394 790 3 176 2401X 37th Ave 1 1 1 2     18 5   5984839.6656165 2098840.9778552 37.7421409539499 -122.49506192610399 (37.7421409539499, -122.495061926104)
111512 792 3 176 2401X 37th Ave 3 1 1 2     3 5   5984839.6656165 2098840.9778552 37.7421409539499 -122.49506192610399 (37.7421409539499, -122.495061926104)
120576 791 3 176 2401X 37th Ave 2 1 1 2     18 5   5984839.6656165 2098840.9778552 37.7421409539499 -122.49506192610399 (37.7421409539499, -122.495061926104)
77982 786 3 176 2301X 37th Ave 1 1 1 2     18 5   5984816.659531401 2099521.6133491 37.7440084477813 -122.495191653565 (37.7440084477813, -122.495191653565)
97632 787 3 176 2301X 37th Ave 2 1 1 2     18 5   5984816.659531401 2099521.6133491 37.7440084477813 -122.495191653565 (37.7440084477813, -122.495191653565)
102009 788 3 176 2301X 37th Ave 3 1 1 2     18 5   5984816.659531401 2099521.6133491 37.7440084477813 -122.495191653565 (37.7440084477813, -122.495191653565)
125949 789 3 176 2301X 37th Ave 4 1 1 2     18 5   5984816.659531401 2099521.6133491 37.7440084477813 -122.495191653565 (37.7440084477813, -122.495191653565)
80358 747 3 176 2301X 36th Ave 1 1 1 2     18 6   5985126.566983701 2099532.1780828 37.7440555948275 -122.494120857895 (37.7440555948275, -122.494120857895)
106802 749 3 176 2301X 36th Ave 3 1 1 2     12 6   5985126.566983701 2099532.1780828 37.7440555948275 -122.494120857895 (37.7440555948275, -122.494120857895)
89551 121177 6 176 990x Duncan St 1 7 1 1       3x3 Permit Number 775289 6000056.0 2099639.0 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398)
110611 121178 6 176 990x Duncan St 2 7 1 1       3x3 Permit Number 775289 6000056.0 2099639.0 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398)
143056 121179 6 176 990x Duncan St 3 7 1 1       3x3   6000056.0 2099639.0 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398)
107216 121169 6 176 900x Duncan St 2 7 1 1       3x3 Permit Number 775289 6000584.0 2099647.0 37.745263242779004 -122.44068088983101 (37.745263242779, -122.440680889831)
85363 86733 1 176 345 Santiago St   1 1 1         Permit Number 49707 5991856.0 2099765.0 37.7450863408288 -122.47086916045001 (37.7450863408288, -122.47086916045)
102066 86735 1 176 345 Santiago St   1 1 1         Permit Number 49707 5991856.0 2099765.0 37.7450863408288 -122.47086916045001 (37.7450863408288, -122.47086916045)
110492 86734 1 176 345 Santiago St   1 1 1         Permit Number 49707 5991856.0 2099765.0 37.7450863408288 -122.47086916045001 (37.7450863408288, -122.47086916045)
139613 86736 1 176 345 Santiago St   1 1 1         Permit Number 49707 5991856.0 2099765.0 37.7450863408288 -122.47086916045001 (37.7450863408288, -122.47086916045)
91411 784 3 176 2201X 37th Ave 2 1 1 2     18 5   5984793.4110368 2100199.4734369 37.7458683061814 -122.495322021107 (37.7458683061814, -122.495322021107)
99025 783 3 176 2201X 37th Ave 1 1 1 2     18 5   5984793.4110368 2100199.4734369 37.7458683061814 -122.495322021107 (37.7458683061814, -122.495322021107)
104394 785 3 176 2201X 37th Ave 3 1 1 2     18 5   5984793.4110368 2100199.4734369 37.7458683061814 -122.495322021107 (37.7458683061814, -122.495322021107)
33479 185701 2 176 2101 Sunset Blvd 33 9 1 1     3 Width 0ft   5984913.3929 2100510.2746 37.746728705825 -122.494930059132 (37.746728705825, -122.494930059132)
101062 782 3 176 2100X 37th Ave 4 1 1 2     18 5   5984820.234801 2100881.0701698996 37.747741355474794 -122.495279526069 (37.7477413554748, -122.495279526069)
112543 780 3 176 2100X 37th Ave 2 1 1 2     24 5   5984820.234801 2100881.0701698996 37.747741355474794 -122.495279526069 (37.7477413554748, -122.495279526069)
139964 781 3 176 2100X 37th Ave 3 1 1 2     18 5   5984820.234801 2100881.0701698996 37.747741355474794 -122.495279526069 (37.7477413554748, -122.495279526069)
145102 779 3 176 2100X 37th Ave 1 1 1 2     24 5   5984820.234801 2100881.0701698996 37.747741355474794 -122.495279526069 (37.7477413554748, -122.495279526069)
77644 742 3 176 2101 36th Ave 3 1 1 2     18 6   5985080.7039352 2100890.0347213 37.747781216484796 -122.494379511431 (37.7477812164848, -122.494379511431)
94840 743 3 176 2101 36th Ave 4 1 1 2     24 6   5985080.7039352 2100890.0347213 37.747781216484796 -122.494379511431 (37.7477812164848, -122.494379511431)
97613 740 3 176 2101 36th Ave 1 1 1 2     18 6   5985080.7039352 2100890.0347213 37.747781216484796 -122.494379511431 (37.7477812164848, -122.494379511431)
143799 741 3 176 2101 36th Ave 2 1 1 2     12 3   5985080.7039352 2100890.0347213 37.747781216484796 -122.494379511431 (37.7477812164848, -122.494379511431)
19274 21046 3 176 2101X Sunset Blvd 27 1 1 2     18 60   5984980.9284488 2100900.997098 37.7478054765444 -122.49472533299699 (37.7478054765444, -122.494725332997)
77636 21048 3 176 2101X Sunset Blvd 29 1 1 2     18 60   5984980.9284488 2100900.997098 37.7478054765444 -122.49472533299699 (37.7478054765444, -122.494725332997)
103262 21047 3 176 2101X Sunset Blvd 28 1 1 2     18 60   5984980.9284488 2100900.997098 37.7478054765444 -122.49472533299699 (37.7478054765444, -122.494725332997)
22366 186103 2 176 1901 Sunset Blvd 49 9 1 1     14 Width 0ft   5984851.1704 2101686.0599 37.7499534482555 -122.495231908653 (37.7499534482555, -122.495231908653)
116377 777 3 176 17011 37th Ave 1 1 1 2     18 3   5984675.68892 2103566.89422 37.7551074250993 -122.495977459654 (37.7551074250993, -122.495977459654)
160574 221414 2 176 41 Seward St 1 9 1 1     12 Width 3ft   6000889.94304 2104287.73243 37.7580229948769 -122.439955680513 (37.7580229948769, -122.439955680513)
47910 203287 2 176 544 Lawton St 3 1 1 1     17 Width 4ft   5992508.0047699995 2104596.48623 37.7583900387803 -122.468966203544 (37.7583900387803, -122.468966203544)
188412 203286 2 176 544 Lawton St 2 1 1 1     13 Width 4ft   5992531.89727 2104598.4193599997 37.7583967270571 -122.46888371410601 (37.7583967270571, -122.468883714106)
137544 203288 2 176 1594 12th Ave 1 1 1 1     24 Width 4ft   5992483.87857 2104612.52393 37.758432680137 -122.469050809053 (37.758432680137, -122.469050809053)
82952 20675 3 176 1501X Sunset Blvd 29 1 1 2     6 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
94967 20649 3 176 1501X Sunset Blvd 3 1 1 2     3 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
111650 20676 3 176 1501X Sunset Blvd 30 1 1 2     6 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
121109 20653 3 176 1501X Sunset Blvd 7 1 1 2     6 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
125192 20650 3 176 1501X Sunset Blvd 4 1 1 2     12 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
143777 20654 3 176 1501X Sunset Blvd 8 1 1 2     6 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.49558761620101 (37.7589182591611, -122.495587616201)
142997 771 3 176 1400X 37th Ave 1 1 1 2     12 3   5984657.4341277 2105639.8676386 37.7607981637711 -122.496193525359 (37.7607981637711, -122.496193525359)
78306 767 3 176 1300X 37th Ave 1 1 1 2     12 3   5984634.0974632995 2106318.2046777 37.762659320139 -122.496324287579 (37.762659320139, -122.496324287579)
106059 769 3 176 1300X 37th Ave 3 1 1 2     24 3   5984634.0974632995 2106318.2046777 37.762659320139 -122.496324287579 (37.762659320139, -122.496324287579)
80425 20536 3 176 1303X Sunset Blvd 14 1 1 2     6 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
121041 20537 3 176 1303X Sunset Blvd 15 1 1 2     6 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
101002 766 3 176 1200X 37th Ave 1 1 1 2     12 3   5984560.025895501 2107017.0453459998 37.7645738005913 -122.49663204514 (37.7645738005913, -122.49663204514)
104399 765 1 176 1200X 37th Ave 2 1 1 3     24 3   5984609.996333099 2107018.7644647 37.764581448379396 -122.496459340328 (37.7645814483794, -122.496459340328)
105554 725 3 176 1201X 36th Ave 1 1 1 2     12 3   5984870.2990263 2107018.789781 37.7645967639109 -122.49555903860599 (37.7645967639109, -122.495559038606)
84117 114734 2 176 2 GUERRERO ST 1 1 1 1     7 2x2   6005363.0 2108672.0 37.7703147697533 -122.424797830829 (37.7703147697533, -122.424797830829)
101253 114735 2 176 2 GUERRERO ST 3 1 1 1       2x2   6005363.0 2108672.0 37.7703147697533 -122.424797830829 (37.7703147697533, -122.424797830829)
112908 112286 2 176 895x PAGE ST 1 1 1 1       3x3   6002361.0 2109458.0 37.7723029182135 -122.43523795783399 (37.7723029182135, -122.435237957834)
83358 111449 2 176 291 32ND AVE 1 5 1 1       3x3   5985855.0 2113985.0 37.783781611482794 -122.49266636929501 (37.7837816114828, -122.492666369295)
161691 138634 2 176 1801 Divisadero St 1 1 1 1     16 Width 0ft   6000999.0322 2114804.949 37.7869068439094 -122.440332645522 (37.7869068439094, -122.440332645522)
Powered by Datasette · Query took 2.568ms · Data source: data.sfgov.org