trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
900 19637 1 52 100 STAIRWAY5 36 Sidewalk: Curb side : Cutout Tree 1     12 30                      
1171 19952 1 52 100 STAIRWAY39 9 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
1350 19628 1 52 100 STAIRWAY5 27 Sidewalk: Curb side : Cutout Tree 1     6 30                      
1420 19991 1 52 100 STAIRWAY46 11 Sidewalk: Curb side : Cutout Tree 1     12 40                      
2026 19643 1 52 100 STAIRWAY5 42 Sidewalk: Curb side : Cutout Tree 1     12 30                      
2649 20050 1 52 100 STAIRWAY52 6 Sidewalk: Curb side : Cutout Tree 1     12 10                      
3196 19917 1 52 100 STAIRWAY35 13 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
3527 19876 1 52 100 STAIRWAY33 8 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
3552 19877 1 52 100 STAIRWAY33 9 Sidewalk: Curb side : Cutout Tree 1     24 25ST                      
4099 19572 1 52 100 STAIRWAY1 6 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
4115 19918 1 52 100 STAIRWAY35 14 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
4242 19575 1 52 100 STAIRWAY1 10 Sidewalk: Curb side : Cutout Tree 1     36 100ST                      
4705 19622 1 52 100 STAIRWAY5 21 Sidewalk: Curb side : Cutout Tree 1     12 30                      
4768 17628 1 52 150 Phelps St 1 Sidewalk: Curb side : Cutout Tree 1     12 10M                      
4870 19873 1 52 100 STAIRWAY33 5 Sidewalk: Curb side : Cutout Tree 1     30 25ST                      
5641 19822 1 52 100 STAIRWAY25 6 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
5768 87061 7 52     unknown : Yard Tree 2       3x3 Permit Number 50003                    
6428 19770 1 52 100 STAIRWAY16 9 Sidewalk: Curb side : Cutout Tree 1     6 30ST                      
6890 19879 1 52 100 STAIRWAY33 11 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
7211 19619 1 52 100 STAIRWAY5 18 Sidewalk: Curb side : Cutout Tree 1     12 30                      
7383 17629 1 52 150 Phelps St 2 Sidewalk: Curb side : Cutout Tree 1     12 10M                      
7681 19824 1 52 100 STAIRWAY25 8 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
8240 20391 1 52 262X Sunset Blvd 37 Sidewalk: Curb side : Cutout Tree 1     12 60                      
8446 19823 1 52 100 STAIRWAY25 7 Sidewalk: Curb side : Cutout Tree 1     6 10ST                      
8556 19623 1 52 100 STAIRWAY5 22 Sidewalk: Curb side : Cutout Tree 1     12 30                      
8778 19630 1 52 100 STAIRWAY5 29 Sidewalk: Curb side : Cutout Tree 1     12 30                      
9166 19571 1 52 100 STAIRWAY1 5 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
9314 19995 1 52 100 STAIRWAY46 15 Sidewalk: Curb side : Cutout Tree 1     12 40                      
9456 19881 1 52 100 STAIRWAY33 13 Sidewalk: Curb side : Cutout Tree 1     12 25ST                      
9686 19629 1 52 100 STAIRWAY5 28 Sidewalk: Curb side : Cutout Tree 1     6 30                      
9690 19636 1 52 100 STAIRWAY5 35 Sidewalk: Curb side : Cutout Tree 1     12 30                      
9767 19990 1 52 100 STAIRWAY46 10 Sidewalk: Curb side : Cutout Tree 1     6 40                      
10139 19618 1 52 100 STAIRWAY5 17 Sidewalk: Curb side : Cutout Tree 1     6 30                      
10150 19701 1 52 100 STAIRWAY12 1 Sidewalk: Curb side : Cutout Tree 1     12 60                      
10734 20046 1 52 100 STAIRWAY52 2 Sidewalk: Curb side : Cutout Tree 1     3 10                      
11237 19870 1 52 100 STAIRWAY33 2 Sidewalk: Curb side : Cutout Tree 1     36 25ST                      
11589 19641 1 52 100 STAIRWAY5 40 Sidewalk: Curb side : Cutout Tree 1     12 30                      
11997 20028 1 52 100 STAIRWAY49 1 Sidewalk: Curb side : Cutout Tree 1     12 10                      
12219 19617 1 52 100 STAIRWAY5 16 Sidewalk: Curb side : Cutout Tree 1     6 30                      
12413 19734 1 52 100 STAIRWAY14 12 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
12534 19640 1 52 100 STAIRWAY5 39 Sidewalk: Curb side : Cutout Tree 1     6 30                      
13069 19574 1 52 100 STAIRWAY1 8 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
13619 19639 1 52 100 STAIRWAY5 38 Sidewalk: Curb side : Cutout Tree 1     6 30                      
13651 19987 1 52 100 STAIRWAY46 7 Sidewalk: Curb side : Cutout Tree 1     6 40                      
13892 19884 1 52 100 STAIRWAY33 16 Sidewalk: Curb side : Cutout Tree 1     18 25ST                      
15245 19996 1 52 100 STAIRWAY46 16 Sidewalk: Curb side : Cutout Tree 1     12 40                      
15612 19626 1 52 100 STAIRWAY5 25 Sidewalk: Curb side : Cutout Tree 1     12 30                      
15637 19921 1 52 100 STAIRWAY37 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3                      
15654 19916 1 52 100 STAIRWAY35 12 Sidewalk: Curb side : Cutout Tree 1     6 120ST                      
16165 19703 1 52 100 STAIRWAY13 1 Sidewalk: Curb side : Cutout Tree 1     12 40ST                      
16570 19635 1 52 100 STAIRWAY5 34 Sidewalk: Curb side : Cutout Tree 1     12 30                      
16689 19767 1 52 100 STAIRWAY16 6 Sidewalk: Curb side : Cutout Tree 1     12 30ST                      
16816 19567 1 52 100 STAIRWAY1 1 Sidewalk: Curb side : Cutout Tree 1     24 100ST                      
17526 19573 1 52 100 STAIRWAY1 7 Sidewalk: Curb side : Cutout Tree 1     12 100ST                      
18251 19765 1 52 100 STAIRWAY16 4 Sidewalk: Curb side : Cutout Tree 1     12 30ST                      
149539 176333 1 52 12x Canyon Dr 12 Median : Cutout Tree 1     12 Width 0ft   6002752.1139 2086168.71447 37.7083781345093 -122.432221533399 (37.7083781345093, -122.432221533399) 9 7 6 28861 5
113132 108685 1 52 301X CHESTER AVE 1 Sidewalk: Property side : Cutout Tree 1     18     5991720 2087146 37.7104298409998 -122.470420579231 (37.7104298409998, -122.470420579231) 9 8 4 64 24
116280 1854 1 52 2500 Bay Shore Blvd 1 Median : Cutout Tree 1     12 6   6010837.5147418 2086759.4488697 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881) 9 7 8 309 39
173225 1855 1 52 2500 Bay Shore Blvd 2 Median : Cutout Tree 1     3 6   6010837.5147418 2086759.4488697 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881) 9 7 8 309 39
145233 54757 1 52 330 Lathrop Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/08/1972 12:00:00 AM 14   Permit Number 10606 6012426.81669 2086731.57127 37.7104674323033 -122.398823887208 (37.7104674323033, -122.398823887208) 10 3 8 309 1
38905 54758 1 52 324 Lathrop Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/08/1972 12:00:00 AM 8   Permit Number 10607 6012398.45595 2086740.40831 37.710490116783 -122.398922528457 (37.710490116783, -122.398922528457) 10 3 8 309 1
29971 117550 1 52 24X KEMPTON AVE 4 Side Yard : Yard Tree 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
68183 117549 1 52 24X KEMPTON AVE 3 Side Yard : Yard Tree 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
144569 117548 1 52 24X KEMPTON AVE 2 Side Yard : Yard Tree 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
153608 117546 1 52 24X KEMPTON AVE 1 Side Yard : Yard Tree 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
192628 121081 1 52 24X KEMPTON AVE 5 Side Yard : Yard Tree 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
82563 104649 4 52 200 Wheeler Ave 1 Sidewalk: Curb side : Yard Tree 2           6012242.2 2087732.7 37.7132060446128 -122.399532207425 (37.7132060446128, -122.399532207425) 10 3 8 309 1
94023 65615 7 52 907 Madrid St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/07/1990 12:00:00 AM     Permit Number 28522 6001416.70920324 2088928.18069936 37.7158792115697 -122.437034265981 (37.7158792115697, -122.437034265981) 9 7 6 28861 5
149348 65614 7 52 901 Madrid St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/07/1990 12:00:00 AM   3x3 Permit Number 28521 6001429.80797007 2088950.28994853 37.7159406631737 -122.436990572562 (37.7159406631737, -122.436990572562) 9 7 6 28861 5
2633 261854 1 52 1900x Bay Shore Blvd 12 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
4835 261613 1 52 1900x Bay Shore Blvd 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
4933 261616 1 52 1900x Bay Shore Blvd 9 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
5847 261615 1 52 1900x Bay Shore Blvd 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
6505 261618 4 52 1900x Bay Shore Blvd 11 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
9982 261614 1 52 1900x Bay Shore Blvd 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
11530 261611 1 52 1900x Bay Shore Blvd 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
14460 261617 4 52 1900x Bay Shore Blvd 10 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
16957 261853 1 52 1900x Bay Shore Blvd 13 Sidewalk: Curb side : Cutout Tree 1       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
18183 261610 1 52 1900x Bay Shore Blvd 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
19379 261609 1 52 1900x Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
123761 69542 7 52 775 Edinburg St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/28/1998 12:00:00 AM 8   Permit Number 38643 6001970.16460074 2089302.5400568 37.71693856245 -122.435148029449 (37.71693856245, -122.435148029449) 9 7 6 28861 5
161363 254812 4 52 2595 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5997881 2089586 37.7174838262402 -122.449302633722 (37.7174838262402, -122.449302633722) 9 8 6 28861 24
2862 261320 6 52 872 Ingerson Ave   Sidewalk: Curb side : Cutout Tree 2       3x3   6014869 2089377 37.7178670406836 -122.390567842363 (37.7178670406836, -122.390567842363) 10 3 8 58 1
184072 176332 1 52 700x Mansell St 40 Median : Cutout Tree 1     10 Width 0ft   6009122.37089 2089940.9339 37.7190950046208 -122.410471276831 (37.7190950046208, -122.410471276831) 9 3 8 309 18
170148 176331 1 52 700x Mansell St 36 Median : Cutout Tree 1     27 Width 0ft   6009160.31915 2089943.19891 37.7191033512163 -122.410340263619 (37.7191033512163, -122.410340263619) 9 3 8 309 18
31787 176327 1 52 700x Mansell St 31 Median : Cutout Tree 1     46 Width 0ft   6009212.31958 2089948.46975 37.7191207387124 -122.410160889327 (37.7191207387124, -122.410160889327) 9 3 8 309 18
136060 176328 1 52 700x Mansell St 32 Median : Cutout Tree 1     11 Width 0ft   6009200.77281 2089956.05158 37.7191409096134 -122.410201337249 (37.7191409096134, -122.410201337249) 9 3 8 309 18
38642 176330 1 52 700x Mansell St 35 Median : Cutout Tree 1     7 Width 0ft   6009184.10476 2089961.98667 37.7191562718235 -122.410259371368 (37.7191562718235, -122.410259371368) 9 3 8 309 18
145650 176329 1 52 700x Mansell St 33 Median : Cutout Tree 1     11 Width 0ft   6009197.90265 2089964.97601 37.719165253359 -122.410211888084 (37.719165253359, -122.410211888084) 9 3 8 309 18
95630 176324 1 52 700x Mansell St 24 Median : Cutout Tree 1     43 Width 0ft   6009336.81226 2089985.35608 37.7192289981902 -122.409733166348 (37.7192289981902, -122.409733166348) 9 3 8 309 18
45941 176323 1 52 700x Mansell St 23 Median : Cutout Tree 1     31 Width 0ft   6009342.20287 2090002.90208 37.719277477945 -122.409715770784 (37.719277477945, -122.409715770784) 9 3 8 309 18
79194 176326 1 52 700x Mansell St 26 Median : Cutout Tree 1     11 Width 0ft   6009300.41458 2090007.16421 37.7192868390067 -122.409860518467 (37.7192868390067, -122.409860518467) 9 3 8 309 18
97499 176325 1 52 700x Mansell St 25 Median : Cutout Tree 1     7 Width 0ft   6009306.38792 2090008.28787 37.7192902591068 -122.409839950067 (37.7192902591068, -122.409839950067) 9 3 8 309 18
77468 176321 1 52 700x Mansell St 10 Median : Cutout Tree 1     20 Width 0ft   6009491.13352 2090035.22052 37.7193745624679 -122.409203250746 (37.7193745624679, -122.409203250746) 9 3 8 309 18
86806 176322 1 52 700x Mansell St 11 Median : Cutout Tree 1     11 Width 0ft   6009482.93202 2090051.63911 37.7194191850237 -122.409232758387 (37.7194191850237, -122.409232758387) 9 3 8 309 18
184155 176320 1 52 700x Mansell St 5 Median : Cutout Tree 1     15 Width 0ft   6009693.65645 2090109.67926 37.7195903547889 -122.408508450717 (37.7195903547889, -122.408508450717) 9 3 8 309 18
181652 176319 1 52 700x Mansell St 2 Median : Cutout Tree 1     18 Width 0ft   6009753.29629 2090123.38013 37.7196313144016 -122.408303262296 (37.7196313144016, -122.408303262296) 9 3 8 309 18
84267 176318 1 52 600x Mansell St 6 Median : Cutout Tree 1     24 Width 0ft   6009900.75619 2090162.07565 37.71974582058 -122.40779627129 (37.71974582058, -122.40779627129) 9 7 8 309 18
36545 176317 1 52 600x Mansell St 5 Median : Cutout Tree 1     20 Width 0ft   6009952.88344 2090194.234 37.7198370388417 -122.407618351232 (37.7198370388417, -122.407618351232) 10 3 8 309 18
111630 176316 1 52 600x Mansell St 4 Median : Cutout Tree 1     20 Width 0ft   6009975.17316 2090196.62711 37.7198448575227 -122.40754147176 (37.7198448575227, -122.40754147176) 10 3 8 309 18
162446 176315 1 52 600x Mansell St 2 Median : Cutout Tree 1     36 Width 0ft   6010056.94301 2090202.23729 37.7198648386596 -122.407259215964 (37.7198648386596, -122.407259215964) 9 7 8 309 18