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                      
32951 112484 6 52 1275 Columbus Ave 4 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
64346 109844 4 52 535 CLAY ST 1 Sidewalk: Curb side : Cutout Tree 2     17 5x5   6012019 2117742 37.7955925645 -122.402412455116 (37.7955925645, -122.402412455116) 3 1 10 28860 4
77919 32699 7 52 665 Geary St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37104 6008544.39382175 2114510.13304212 37.7865240684083 -122.414206472781 (37.7865240684083, -122.414206472781) 5 1 9 28852 36
115879 112485 6 52 1275 Columbus Ave 5 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
131448 112486 7 52 1275 Columbus Ave 6 Front Yard : Yard Tree 2   08/03/2015 12:00:00 AM     Permit Number 774532 6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
157517 112488 6 52 1275 Columbus Ave 8 Front Yard : Yard Tree 2           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
167115 112487 6 52 1275 Columbus Ave 7 Front Yard : Yard Tree 2           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
192906 61359 7 52 1234 Washington St 1 Sidewalk: Curb side : Cutout Tree 2   01/12/2016 12:00:00 AM   3x3 Permit Number 21268 6008775.22346441 2117343.22168335 37.7943160027564 -122.413608310086 (37.7943160027564, -122.413608310086) 5 1 10 28857 21
44857 6104 1 52 500X 08th St 6 Median : Cutout Tree 1     12 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
48855 6103 1 52 500X 08th St 5 Median : Cutout Tree 1     3 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
82519 6106 1 52 500X 08th St 8 Median : Cutout Tree 1     18 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
83538 6101 1 52 500X 08th St 3 Median : Cutout Tree 1     3 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
92481 32999 7 52 666 Folsom St 8 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37299 6013145.25876593 2113656.86996444 37.7844385625752 -122.39822862272 (37.7844385625752, -122.39822862272) 6 2 9 28853 6
108995 6102 1 52 500X 08th St 4 Sidewalk: Property side : Cutout Tree 1     6 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
140238 6100 1 52 500X 08th St 2 Median : Cutout Tree 1     24 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
152575 6105 1 52 500X 08th St 7 Sidewalk: Property side : Cutout Tree 1     3 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
158313 30787 7 52 488 Bryant St 1 Sidewalk: Curb side : Cutout Tree 2   01/31/1995 12:00:00 AM   3x3 Permit Number 51964 6013865.01842582 2112595.14259648 37.7815633679001 -122.395664068446 (37.7815633679001, -122.395664068446) 6 2 9 28856 6
180688 32992 7 52 666 Folsom St 9 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37299 6013145.25876593 2113656.86996444 37.7844385625752 -122.39822862272 (37.7844385625752, -122.39822862272) 6 2 9 28853 6
181750 6099 6 52 500X 08th St 1 Sidewalk: Property side : Cutout Tree 2     18 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
184426 32990 7 52 666 Folsom St 11 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37299 6013145.25876593 2113656.86996444 37.7844385625752 -122.39822862272 (37.7844385625752, -122.39822862272) 6 2 9 28853 6
186774 32991 7 52 666 Folsom St 10 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37299 6013145.25876593 2113656.86996444 37.7844385625752 -122.39822862272 (37.7844385625752, -122.39822862272) 6 2 9 28853 6
163 17253 1 52 15 Osceola Ln 1 Sidewalk: Curb side : Cutout Tree 1     24 3X3   6017345.102761 2094248.0837329 37.7313791485056 -122.382347671583 (37.7313791485056, -122.382347671583) 10 3 8 58 1
308 102295 7 52 1500 Michigan St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6016449 2101073.5 37.7500708170088 -122.385921283567 (37.7500708170088, -122.385921283567) 10 3 8 58 1
454 11293 1 52 1199X Ingalls St 5 Sidewalk: Curb side : Cutout Tree 1     60 3X3   6017612.0195749 2093925.7037957 37.7305086962257 -122.381402471608 (37.7305086962257, -122.381402471608) 10 3 8 58 1
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
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
3992 9289 1 52 13X George Ct 6 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6017208.5497632 2094048.0250587 37.7308222832509 -122.382805848563 (37.7308222832509, -122.382805848563) 10 3 8 58 1
4220 11355 1 52 1339 Ingalls St 4 Sidewalk: Curb side : Cutout Tree 1     70 3X3   6017292.9099838 2093920.0801467 37.7304756321775 -122.382505299944 (37.7304756321775, -122.382505299944) 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
5870 11357 1 52 1350X Ingalls St 1 Sidewalk: Curb side : Cutout Tree 1     70 3X3   6017253.696644 2093959.2156364 37.7305809242894 -122.382643589629 (37.7305809242894, -122.382643589629) 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
7246 264704 1 52 95 Middle Point Rd 37 Front Yard : Cutout Tree 2       3x3   6018242 2095673 37.7353411892906 -122.379345838246 (37.7353411892906, -122.379345838246) 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
12194 261567 4 52 1299 Wisconsin St 12 Sidewalk: Property side : Yard Tree 1       3x3   6013134 2101730 37.751689413587 -122.397430852298 (37.751689413587, -122.397430852298) 10 3 8 28856 29
13854 9287 1 52 13X George Ct 4 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6017208.5497632 2094048.0250587 37.7308222832509 -122.382805848563 (37.7308222832509, -122.382805848563) 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
18106 25447 1 52 1261X La Salle Ave 15 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6017141.6501925 2094501.7221284 37.732064349457 -122.383068698568 (37.732064349457, -122.383068698568) 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
19028 17266 1 52 40 Osceola Dr 1 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6017197.5430923 2094354.669125 37.7316636592684 -122.382865232677 (37.7316636592684, -122.382865232677) 10 3 8 58 1
19364 10993 1 52 1514 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6016151.5025 2097133.86056 37.7392369091669 -122.386675366572 (37.7392369091669, -122.386675366572) 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
22120 11335 1 52 1279 Ingalls St 4 Sidewalk: Curb side : Cutout Tree 1     70 3X3   6017412.9471167 2093950.7223454 37.7305663998171 -122.382092440811 (37.7305663998171, -122.382092440811) 10 3 8 58 1