trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
12300 93053 7 100     Front Yard : Yard Tree 2   04/28/2010 12:00:00 AM 36   Permit Number 53387                    
35285 110616 4 100 182X LOWER TER   Sidewalk: Curb side : Cutout Tree 2       3x3   5999820 2106230 37.7632950157782 -122.44379552503 (37.7632950157782, -122.44379552503) 15 5 5 29492 3
50522 93931 6 100     Front Yard : Yard Tree 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
57396 106550 1 100 81 MINERVA ST   Median : Cutout Tree 1           5996079.6 2088963.3 37.7156708325413 -122.455484227095 (37.7156708325413, -122.455484227095) 9 8 6 28861 24
90765 113415 1 100 450 PORTOLA DR   Sidewalk: Curb side : Cutout Tree 1     60 3x3   5998094 2100018 37.7461398052423 -122.449317577522 (37.7461398052423, -122.449317577522) 2 7 5 63 7
98050 110259 4 100 655 SANCHEZ ST   Sidewalk: Curb side : Cutout Tree 2       3x3   6003729.2 2104438 37.7585968119418 -122.430147043342 (37.7585968119418, -122.430147043342) 2 4 5 28862 3
105498 93932 6 100     Front Yard : Yard Tree 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
167631 112904 4 100 727 BURNETT AVE   Back Yard : Yard Tree 2       3x3   5999303 2101616 37.750596607185 -122.44525189688 (37.750596607185, -122.44525189688) 2 5 5 63 38
171763 106405 6 100 4849X 19th St   Front Yard : Yard Tree 2         Permit Number 772769 5999644.57626 2104777.09851 37.7592957011711 -122.444297841065 (37.7592957011711, -122.444297841065) 2 4 5 28862 3
8572 19744 1 100 100 STAIRWAY15 -7 Sidewalk: Curb side : Cutout Tree 1     6 1OST                      
10352 19743 1 100 100 STAIRWAY15 -8 Sidewalk: Curb side : Cutout Tree 1     6 1OST                      
398 234490 1 100 4053 20th St 1 Front Yard : Yard Tree 2     13 Width 3ft   6003306.74467 2104167.50736 37.7578301676468 -122.43158877311 (37.7578301676468, -122.43158877311) 2 4 5 28862 3
985 262391 9 100 2646 38th Ave 1 Back Yard : Yard Tree 2       Width 0ft   5984657 2097167 37.7375339667511 -122.495570077384 (37.7375339667511, -122.495570077384) 1 8 3 29491 35
1202 254563 1 100 98x High St 1 unknown : Yard Tree 1       3x3   5999731 2100707 37.748125134697 -122.443706547761 (37.748125134697, -122.443706547761) 2 4 5 63 22
3233 245150 1 100 100 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     23 Width 0ft   6000845.3118 2109360.3422 37.7719485860085 -122.440473841976 (37.7719485860085, -122.440473841976) 15 5 11 29492 9
4649 141530 1 100 2901 TURK BLVD 1 Sidewalk: Property side : Cutout Tree 2     10 Width 0ft   5996711.9256 2111472.0638 37.7775105970069 -122.454924058113 (37.7775105970069, -122.454924058113) 15 6 2 54 16
5502 19723 1 100 100 STAIRWAY14 1 Sidewalk: Curb side : Cutout Tree 1     3 40ST                      
7083 19857 1 100 100 STAIRWAY30 1 Sidewalk: Curb side : Cutout Tree 1     24 30ST                      
15464 262332 1 100 1X Cuesta Ct 1 Unaccepted Street : Yard Tree 2       3x3   5999654 2101769 37.7510367373071 -122.444049107076 (37.7510367373071, -122.444049107076) 2 5 5 63 38
16896 19981 1 100 100 STAIRWAY46 1 Sidewalk: Curb side : Cutout Tree 1     3 40                      
17497 19970 1 100 100 STAIRWAY44 1 Sidewalk: Curb side : Cutout Tree 1     12 15                      
18853 262082 1 100 498X Burnett Ave 1 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
22262 23613 1 100 900X Vermont St 1 Sidewalk: Curb side : Cutout Tree 1     36 30X30PL   6011293.8960822 2104150.9045186 37.7582340578883 -122.40396455427 (37.7582340578883, -122.40396455427) 10 3 8 28856 29
25415 132165 1 100 3075 Clay St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 4ft   6000074.17402 2115752.57218 37.7894560684958 -122.443600532065 (37.7894560684958, -122.443600532065) 13 6 1 29490 27
28797 106211 1 100 1646 35TH AVE 1 Sidewalk: Curb side : Yard Tree 2         Permit Number 773238 5985355 2103995.9 37.7563251201532 -122.493659849192 (37.7563251201532, -122.493659849192) 1 8 3 56 35
28928 116154 8 100 324 POPE ST 1 Back Yard : Yard Tree 2       3x3   6000502 2087202 37.7110874704678 -122.440072212787 (37.7110874704678, -122.440072212787) 9 7 6 28861 5
35177 13405 1 100 362 Marietta Dr 1 Median : Cutout Tree 1     45 5   5999656.8275613 2097385.3812268 37.7390005339934 -122.443724438614 (37.7390005339934, -122.443724438614) 9 7 4 59 40
48765 98082 6 100 525 Grafton Ave 1 Sidewalk: Property side : Cutout Tree 2           5995193.7 2090526.9 37.7199132334677 -122.45865940878 (37.7199132334677, -122.45865940878) 9 8 6 28861 24
56024 105231 8 100 460X ROOSEVELT WAY 1 Front Yard : Yard Tree 2     9     6000051 2106345 37.7636239504047 -122.443004833609 (37.7636239504047, -122.443004833609) 15 5 5 29492 3
59834 253717 6 100 4101 Balboa St 1 Back Yard : Yard Tree 2   01/08/2018 12:00:00 AM 3   Permit Number 780863 5982822 2110967 37.7753172554615 -122.50293574331 (37.7753172554615, -122.50293574331) 11 6 2 55 26
61690 106324 4 100 800 INDIANA ST 1 Sidewalk: Property side : Yard Tree 2     20     6014913.4 2104437.2 37.7592217202179 -122.391466645187 (37.7592217202179, -122.391466645187) 10 3 8 28856 29
63239 93054 7 100 737 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree 2   04/28/2010 12:00:00 AM 49   Permit Number 53387 5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
64164 251362 1 100 1300X Stanyan St 1 Unaccepted Street : Yard Tree 2       3x3   5997565 2104877 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349) 15 5 11 28862 12
72516 258223 6 100 53 Starr King Way 1 Sidewalk: Property side : Cutout Tree 2       Width 3ft Permit Number 782966 6005764 2113984 37.784922869937 -122.423788535241 (37.784922869937, -122.423788535241) 13 9 11 28858 41
78297 234492 1 100 33 Mars St 1 Sidewalk: Property side : Yard Tree 2     28 Width 3ft   5999611.22264 2105612.60046 37.7615878796102 -122.444473240453 (37.7615878796102, -122.444473240453) 15 5 5 28862 3
93834 87762 7 100 747 Howard St 1 Sidewalk: Curb side : Cutout Tree 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50415 6012202 2113577 37.7841666723804 -122.401486377799 (37.7841666723804, -122.401486377799) 6 2 9 28853 34
97021 105907 6 100 1837 30TH AVE 1 Front Yard : Yard Tree 2     6     5986904 2102674 37.7527860393128 -122.488205804709 (37.7527860393128, -122.488205804709) 1 8 3 56 35
103685 248958 6 100 98x Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree 2   03/06/2017 12:00:00 AM 3 3x3   5994824 2095658 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898) 9 8 4 59 40
107393 98343 4 100 2999x Turk St 1 Sidewalk: Property side : Cutout Tree 2   02/01/2012 12:00:00 AM   5x3 Permit Number 768613 5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
112548 3763 1 100 1074 Carolina St 1 Median : Cutout Tree 1     12 18   6012456.6037355 2102966.9856684 37.7550481677782 -122.399860245008 (37.7550481677782, -122.399860245008) 10 3 8 28856 29
125688 117419 4 100 452 OAK ST 1 Front Yard : Yard Tree 2           6004802 2110240 37.774588415373 -122.426850015779 (37.774588415373, -122.426850015779) 7 9 11 28852 10
137658 91427 1 100 800X Portola Dr 1 Median : Cutout Tree 1   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
137660 183336 1 100 4711 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree 2     3 3x3   5981096.0962 2106871.8479 37.7639715747264 -122.508601850774 (37.7639715747264, -122.508601850774) 1 8 3 56 35
141912 234486 1 100 787 Sanchez St 1 Sidewalk: Curb side : Cutout Tree 2     29 Width 3ft   6003746.3772 2103694.46852 37.756556224011 -122.430034597112 (37.756556224011, -122.430034597112) 2 4 5 28862 3
154492 20647 1 100 1501X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree 1     3 60   5984817.9532367 2104951.7766639 37.7589182591611 -122.495587616201 (37.7589182591611, -122.495587616201) 1 8 3 56 35
157910 16689 1 100 620 Noriega St 1 Median : Cutout Tree 1     12 2   5992122.8128645 2103567.9103998 37.7555435761415 -122.470223454796 (37.7555435761415, -122.470223454796) 1 8 4 56 12
167924 23578 1 100 3100X Van Ness Ave 1 Median : Cutout Tree 1     24 9   6005553.2513401 2120985.4040713 37.8041350589608 -122.425015980687 (37.8041350589608, -122.425015980687) 5 1 1 28858 32
167995 3761 1 100 1074 Carolina St 1 Median : Cutout Tree 1     12 18   6012458 2102979 37.7550812343514 -122.399856259894 (37.7550812343514, -122.399856259894) 10 3 8 28856 29
174020 12499 1 100 1200X Lake Merced Blvd 1 Median : Cutout Tree 1     18 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649) 1 8 4 64 14
182249 173897 4 100 90x Knollview Way 1 Back Yard : Yard Tree 2       3x3   5997593 2101480 37.7501254274205 -122.451155378281 (37.7501254274205, -122.451155378281) 1 5 4 63 38
193767 251050 1 100 5800x Geary Blvd 1 Median : Yard Tree 1     4 Width 10ft   5988878.2157 2112618.8979 37.7802069893248 -122.482107186669 (37.7802069893248, -122.482107186669) 11 6 2 55 26
7444 19914 1 100 100 STAIRWAY35 10 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
7846 19732 1 100 100 STAIRWAY14 10 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
9917 19611 1 100 100 STAIRWAY5 10 Sidewalk: Curb side : Cutout Tree 1     12 30                      
135364 185161 1 100 2500 Sunset Blvd 10 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985124.0613 2097656.7845 37.7389061227579 -122.493991335448 (37.7389061227579, -122.493991335448) 1 8 3 29491 35
1363 19612 1 100 100 STAIRWAY5 11 Sidewalk: Curb side : Cutout Tree 1     6 30                      
4582 19867 1 100 100 STAIRWAY30 11 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
9396 19915 1 100 100 STAIRWAY35 11 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
15775 19733 1 100 100 STAIRWAY14 11 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
40408 20784 1 100 1701X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree 1     12 60   5984888.092725 2103630.7874996 37.7552952964732 -122.49524762816 (37.7552952964732, -122.49524762816) 1 8 3 56 35
70203 141487 1 100 2901 TURK BLVD 11 Sidewalk: Curb side : Cutout Tree 2     25 Width 0ft   5996890.9122 2111495.5172 37.7775852598057 -122.45430658183 (37.7775852598057, -122.45430658183) 15 6 2 54 16
116302 110705 4 100 2999X Turk St 11 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
5857 19992 1 100 100 STAIRWAY46 12 Sidewalk: Curb side : Cutout Tree 1     12 40                      
7883 19613 1 100 100 STAIRWAY5 12 Sidewalk: Curb side : Cutout Tree 1     12 30                      
17887 20041 1 100 100 STAIRWAY51 12 Sidewalk: Curb side : Cutout Tree 1     6 ST                      
151364 20534 1 100 1303X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree 1     6 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
874 19715 1 100 100 STAIRWAY13 13 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
2883 19735 1 100 100 STAIRWAY14 13 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
4763 19993 1 100 100 STAIRWAY46 13 Sidewalk: Curb side : Cutout Tree 1     12 40                      
10714 19791 1 100 100 STAIRWAY19 13 Sidewalk: Curb side : Cutout Tree 1     12 20ST                      
13490 19614 1 100 100 STAIRWAY5 13 Sidewalk: Curb side : Cutout Tree 1     12 30                      
45445 21490 1 100 2792X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree 1     3 60   5985060.3629888 2096294.4798015 37.7351618711636 -122.49411119238 (37.7351618711636, -122.49411119238) 1 8 3 29491 35
45981 185462 1 100 2400 Sunset Blvd 13 unknown : Yard Tree 2     2 Width 0ft   5985138.3382 2098374.943 37.740878828405 -122.493994886454 (37.740878828405, -122.493994886454) 1 8 3 29491 35
80145 110707 4 100 2999X Turk St 13 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
85674 141489 1 100 2901 TURK BLVD 13 Sidewalk: Curb side : Cutout Tree 2     27 Width 0ft   5996912.3083 2111498.8089 37.777595524924 -122.45423280375 (37.777595524924, -122.45423280375) 15 6 2 54 16
146890 815 1 100 600X 39th Ave 13 Median : Cutout Tree 1     3 6-HOA   5983831.1679936 2111715.0127262 37.7774303425616 -122.499500145383 (37.7774303425616, -122.499500145383) 11 6 2 55 26
161472 185163 1 100 2500 Sunset Blvd 13 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985155.9352 2097682.682 37.7389790952829 -122.493883039881 (37.7389790952829, -122.493883039881) 1 8 3 29491 35
6896 19756 1 100 100 STAIRWAY15 14 Sidewalk: Curb side : Cutout Tree 1     3 20ST                      
7921 19736 1 100 100 STAIRWAY14 14 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
13544 19716 1 100 100 STAIRWAY13 14 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
19223 19615 1 100 100 STAIRWAY5 14 Sidewalk: Curb side : Cutout Tree 1     12 30                      
19429 19994 1 100 100 STAIRWAY46 14 Sidewalk: Curb side : Cutout Tree 1     12 40                      
4839 19757 1 100 100 STAIRWAY15 15 Sidewalk: Curb side : Cutout Tree 1     3 20ST                      
6279 19737 1 100 100 STAIRWAY14 15 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
16095 19616 1 100 100 STAIRWAY5 15 Sidewalk: Curb side : Cutout Tree 1     12 30                      
16278 19717 1 100 100 STAIRWAY13 15 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
93191 110709 4 100 2999X Turk St 15 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
113118 141491 1 100 2901 TURK BLVD 15 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   5996944.1281 2111502.1006 37.7776063877102 -122.454122966753 (37.7776063877102, -122.454122966753) 15 6 2 54 16
130886 187232 1 100 2401 Sunset Blvd 15 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984921.2891 2098611.514 37.7415156862998 -122.494762787921 (37.7415156862998, -122.494762787921) 1 8 3 29491 35
15132 19718 1 100 100 STAIRWAY13 16 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
16876 19738 1 100 100 STAIRWAY14 16 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
6212 19719 1 100 100 STAIRWAY13 17 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
6893 19997 1 100 100 STAIRWAY46 17 Sidewalk: Curb side : Cutout Tree 1     12 40                      
15815 19739 1 100 100 STAIRWAY14 17 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
139990 186132 1 100 1700 Sunset Blvd 17 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984975.4043 2103142.7715 37.753960450821 -122.494909702152 (37.753960450821, -122.494909702152) 1 8 3 56 35
165349 110711 4 100 2999X Turk St 17 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
185727 185166 1 100 2500 Sunset Blvd 17 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5985143.9825 2097713.2278 37.7390622665176 -122.493926616722 (37.7390622665176, -122.493926616722) 1 8 3 29491 35
193417 141493 1 100 2901 TURK BLVD 17 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   5996968.2673 2111507.0382 37.7776213292106 -122.45403981827 (37.7776213292106, -122.45403981827) 15 6 2 54 16
11608 20009 1 100 100 STAIRWAY47 18 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
70195 186133 1 100 1700 Sunset Blvd 18 Sidewalk: Property side : Yard Tree 2     8 Width 0ft   5984952.5547 2103165.275 37.7540209016237 -122.494990379508 (37.7540209016237, -122.494990379508) 1 8 3 56 35
5085 19999 1 100 100 STAIRWAY46 19 Sidewalk: Curb side : Cutout Tree 1     12 40