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)
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
68559 91429 1 100 800X Portola Dr 3 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
68327 186829 1 100 1200 Sunset Blvd 94 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984823.8588 2106586.1554 37.763406151967 -122.495687746344 (37.763406151967, -122.495687746344) 1 8 3 56 35
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
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
61835 110697 4 100 2999X Turk St 3 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
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
60998 186736 1 100 1200 Sunset Blvd 2 Sidewalk: Property side : Yard Tree 2     22 Width 0ft   5984872.7556 2106587.8007 37.76341353282 -122.495518752014 (37.76341353282, -122.495518752014) 1 8 3 56 35
60871 110703 4 100 2999X Turk St 9 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
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
57780 12503 1 100 1200X Lake Merced Blvd 5 Median : Cutout Tree 1     12 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649) 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
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
54825 110699 4 100 2999X Turk St 5 Sidewalk: Property side : Cutout Tree 2       5x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
52821 91428 1 100 800X Portola Dr 2 Median : Cutout Tree 1   10/10/2005 12:00:00 AM 3 4x4   5996711.121131 2099335.742872 37.7441872967186 -122.454050104178 (37.7441872967186, -122.454050104178) 1 7 4 59 40
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
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
48449 186134 1 100 1700 Sunset Blvd 19 Sidewalk: Property side : Yard Tree 2     4 Width 0ft   5984955.6705 2103171.5067 37.754038194553 -122.49498006395 (37.754038194553, -122.49498006395) 1 8 3 56 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
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
43322 21267 1 100 2492X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     3 60   5984994.4282385 2098239.2478178 37.740497824548 -122.494482465671 (37.740497824548, -122.494482465671) 1 8 3 29491 35
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
38345 181498 1 100 1400 Sunset Blvd 58 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984861.653 2105433.8466 37.7602444476946 -122.495472038545 (37.7602444476946, -122.495472038545) 1 8 3 56 35
37573 141619 1 100 31 LOYOLA TER 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   5998404.7923 2110908.8953 37.7760612473543 -122.449027315104 (37.7760612473543, -122.449027315104) 15 6 2 29492 16
35747 93927 7 100 737 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree 2   04/28/2010 12:00:00 AM     Permit Number 53387 5988857.6 2089713.7 37.7173141872637 -122.480501360019 (37.7173141872637, -122.480501360019) 1 8 4 64 14
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
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
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
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
26457 194520 1 100 1600 Bay Shore Blvd 40 Sidewalk: Property side : Yard Tree 2     6 Width 6ft   6012006.62045 2091255.62525 37.7228661524341 -122.400593779099 (37.7228661524341, -122.400593779099) 10 3 7 309 28
25634 211049 1 100 50 Garcia Ave 25 Sidewalk: Curb side : Yard Tree 2     23 Width 3ft   5994782.37935 2099248.26832 37.7438363316793 -122.460712887715 (37.7438363316793, -122.460712887715) 1 8 4 59 40
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
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
21989 187401 1 100 2100 Sunset Blvd 54 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5985066.4729 2100733.1142 37.747349522643 -122.494417155333 (37.747349522643, -122.494417155333) 1 8 3 29491 35
20775 186778 1 100 1200 Sunset Blvd 46 Sidewalk: Property side : Yard Tree 2     27 Width 0ft   5984835.1586 2106804.893 37.7640074057024 -122.495664799754 (37.7640074057024, -122.495664799754) 1 8 3 56 35
19598 19633 1 100 100 STAIRWAY5 32 Sidewalk: Curb side : Cutout Tree 1     6 30                      
19429 19994 1 100 100 STAIRWAY46 14 Sidewalk: Curb side : Cutout Tree 1     12 40                      
19337 20012 1 100 100 STAIRWAY47 21 Sidewalk: Curb side : Cutout Tree 1     6 100ST                      
19228 19750 1 100 100 STAIRWAY15 6 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
19223 19615 1 100 100 STAIRWAY5 14 Sidewalk: Curb side : Cutout Tree 1     12 30                      
18925 19645 1 100 100 STAIRWAY5 44 Sidewalk: Curb side : Cutout Tree 1     3 30                      
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
18817 19689 1 100 100 STAIRWAY5 88 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
18793 19631 1 100 100 STAIRWAY5 30 Sidewalk: Curb side : Cutout Tree 1     12 30                      
18738 19646 1 100 100 STAIRWAY5 45 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
18658 19704 1 100 100 STAIRWAY13 2 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
18599 19604 1 100 100 STAIRWAY5 3 Sidewalk: Curb side : Cutout Tree 1     12 30                      
18517 19608 1 100 100 STAIRWAY5 7 Sidewalk: Curb side : Cutout Tree 1     12 30                      
18480 19609 1 100 100 STAIRWAY5 8 Sidewalk: Curb side : Cutout Tree 1     6 30                      
18475 19731 1 100 100 STAIRWAY14 9 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
18118 19603 1 100 100 STAIRWAY5 2 Sidewalk: Curb side : Cutout Tree 1     12 30                      
17887 20041 1 100 100 STAIRWAY51 12 Sidewalk: Curb side : Cutout Tree 1     6 ST                      
17754 19655 1 100 100 STAIRWAY5 54 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
17668 19627 1 100 100 STAIRWAY5 26 Sidewalk: Curb side : Cutout Tree 1     12 30                      
17616 19684 1 100 100 STAIRWAY5 83 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
17497 19970 1 100 100 STAIRWAY44 1 Sidewalk: Curb side : Cutout Tree 1     12 15                      
17410 19681 1 100 100 STAIRWAY5 80 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
16896 19981 1 100 100 STAIRWAY46 1 Sidewalk: Curb side : Cutout Tree 1     3 40                      
16876 19738 1 100 100 STAIRWAY14 16 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
16767 181422 1 100 1500 Sunset Blvd 55 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984930.7159 2104775.5208 37.758440912105 -122.495184638383 (37.758440912105, -122.495184638383) 1 8 3 56 35
16746 19862 1 100 100 STAIRWAY30 6 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
16706 19652 1 100 100 STAIRWAY5 51 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
16655 19861 1 100 100 STAIRWAY30 5 Sidewalk: Curb side : Cutout Tree 1     24 30ST                      
16380 19763 1 100 100 STAIRWAY16 2 Sidewalk: Curb side : Cutout Tree 1     6 30ST                      
16278 19717 1 100 100 STAIRWAY13 15 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
16250 19688 1 100 100 STAIRWAY5 87 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
16095 19616 1 100 100 STAIRWAY5 15 Sidewalk: Curb side : Cutout Tree 1     12 30                      
16026 19673 1 100 100 STAIRWAY5 72 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
15815 19739 1 100 100 STAIRWAY14 17 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
15775 19733 1 100 100 STAIRWAY14 11 Sidewalk: Curb side : Cutout Tree 1     6 40ST                      
15745 19847 1 100 100 STAIRWAY26 5 Sidewalk: Curb side : Cutout Tree 1     3 30                      
15694 19654 1 100 100 STAIRWAY5 53 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
15658 19658 1 100 100 STAIRWAY5 57 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
15491 19647 1 100 100 STAIRWAY5 46 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
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
15419 23925 1 100 1700X Webster St 7 Median : Cutout Tree 1     60 12x1   6003454.8844904 2114845.825423 37.7871586020093 -122.431838884639 (37.7871586020093, -122.431838884639) 13 9 11 29490 27
15362 20010 1 100 100 STAIRWAY47 19 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
15132 19718 1 100 100 STAIRWAY13 16 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
14796 19621 1 100 100 STAIRWAY5 20 Sidewalk: Curb side : Cutout Tree 1     12 30                      
14700 19670 1 100 100 STAIRWAY5 69 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
14227 19634 1 100 100 STAIRWAY5 33 Sidewalk: Curb side : Cutout Tree 1     6 30                      
13846 262084 1 100 498X Burnett Ave 8 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
13544 19716 1 100 100 STAIRWAY13 14 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
13490 19614 1 100 100 STAIRWAY5 13 Sidewalk: Curb side : Cutout Tree 1     12 30                      
13154 19625 1 100 100 STAIRWAY5 24 Sidewalk: Curb side : Cutout Tree 1     6 30                      
13138 19607 1 100 100 STAIRWAY5 6 Sidewalk: Curb side : Cutout Tree 1     6 30                      
12562 262087 1 100 498X Burnett Ave 5 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
12300 93053 7 100     Front Yard : Yard Tree 2   04/28/2010 12:00:00 AM 36   Permit Number 53387                    
11958 262083 1 100 498X Burnett Ave 9 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
11844 262089 1 100 498X Burnett Ave 3 Sidewalk: Property side : Cutout Tree 1 Private     3x3   5999387 2102682 37.7535283774883 -122.445038044935 (37.7535283774883, -122.445038044935) 2 5 5 63 38
11608 20009 1 100 100 STAIRWAY47 18 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
11434 19648 1 100 100 STAIRWAY5 47 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
11194 19644 1 100 100 STAIRWAY5 43 Sidewalk: Curb side : Cutout Tree 1     12 30                      
11089 19690 1 100 100 STAIRWAY5 89 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
10838 233336 1 100 5545 Diamond Heights Blvd 4 Sidewalk: Property side : Yard Tree 2     11 Width 9ft   6001777.47587 2097325.41548 37.7389566084644 -122.436387932367 (37.7389566084644, -122.436387932367) 2 7 5 63 7
10714 19791 1 100 100 STAIRWAY19 13 Sidewalk: Curb side : Cutout Tree 1     12 20ST                      
10472 19659 1 100 100 STAIRWAY5 58 Sidewalk: Curb side : Cutout Tree 1     18 60ST                      
10384 19679 1 100 100 STAIRWAY5 78 Sidewalk: Curb side : Cutout Tree 1     12 60ST                      
10352 19743 1 100 100 STAIRWAY15 -8 Sidewalk: Curb side : Cutout Tree 1     6 1OST                      
9917 19611 1 100 100 STAIRWAY5 10 Sidewalk: Curb side : Cutout Tree 1     12 30                      
9459 19610 1 100 100 STAIRWAY5 9 Sidewalk: Curb side : Cutout Tree 1     12 30