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)
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                      
18515 12492 7 52 307 Lake Merced Blvd 37 Sidewalk: Curb side : Cutout Tree 8     36 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
21244 186970 1 52 1650x Sloat Blvd 1 Median : Cutout Tree 1     10 Width 0ft   5986025.4295 2095869.2083 37.7340506115946 -122.490743373283 (37.7340506115946, -122.490743373283) 1 8 4 64 35
22682 254083 1 52 170x Kensington Way 2 Sidewalk: Property side : Yard Tree 2       3x3   5994883 2098695 37.7423229834884 -122.460324888843 (37.7423229834884, -122.460324888843) 1 8 4 59 40
24518 12493 7 52 307 Lake Merced Blvd 38 Sidewalk: Curb side : Cutout Tree 8     18 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
28949 12494 7 52 307 Lake Merced Blvd 39 Sidewalk: Curb side : Cutout Tree 8     12 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
29305 187037 1 52 2501 Sunset Blvd 56 Sidewalk: Property side : Yard Tree 2     29 Width 0ft   5984959.5362 2097794.0341 37.7392733453171 -122.494570293909 (37.7392733453171, -122.494570293909) 1 8 3 29491 35
29973 64888 7 52 2418 22nd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/01/1989 12:00:00 AM     Permit Number 25914 5989547.06003251 2098884.34921412 37.7425345003811 -122.478788583135 (37.7425345003811, -122.478788583135) 1 8 3 29491 35
32149 253205 1 52 2253 09th Ave 2 Sidewalk: Property side : Cutout Tree 2       3x3   5993186 2100608 37.7474778324271 -122.466331547971 (37.7474778324271, -122.466331547971) 1 8 4 29491 40
38900 97781 4 52 249 Wawona St 1 Sidewalk: Curb side : Cutout Tree 2     13 strip   5992441.6 2097612.4 37.7392096976829 -122.468687674985 (37.7392096976829, -122.468687674985) 1 8 4 59 40
43117 62644 1 52 1255 42nd Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/03/2008 12:00:00 AM 1 3x3 Permit Number 50627 5983022.3246657 2106594.48040873 37.7633233458854 -122.501919183937 (37.7633233458854, -122.501919183937) 1 8 3 56 35
43131 116576 6 52 2500x OCEAN AVE 1 Sidewalk: Property side : Yard Tree 3 DPW   30 10X10   5991377 2094742 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256) 1 8 4 64 40
46417 49473 7 52 1300 Ulloa St 1 Sidewalk: Curb side : Cutout Tree 2   04/08/2003 12:00:00 AM   3x3 Permit Number 46398 5992038.44394874 2098453.2514756 37.7414951640526 -122.470142806909 (37.7414951640526, -122.470142806909) 1 8 4 29491 40
51469 12490 7 52 307 Lake Merced Blvd 35 Sidewalk: Curb side : Cutout Tree 8     24 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
56984 254082 1 52 170x Kensington Way 1 Sidewalk: Property side : Yard Tree 2       3x3   5994883 2098695 37.7423229834884 -122.460324888843 (37.7423229834884, -122.460324888843) 1 8 4 59 40
60624 33221 7 52 130 Vasquez Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37412 5995037.97859853 2099619.33373801 37.7448698872964 -122.459855964981 (37.7448698872964, -122.459855964981) 1 8 4 59 40
60728 185127 1 52 700x Sloat Blvd 2 Median : Cutout Tree 1     10 Width 0ft   5989015.4133 2095969.6432 37.7345005898995 -122.480413539116 (37.7345005898995, -122.480413539116) 1 8 4 64 35
64610 56525 7 52 1645 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/1987 12:00:00 AM     Permit Number 24366 5993992.30583295 2104307.94730884 37.7576834321386 -122.463811929837 (37.7576834321386, -122.463811929837) 1 5 4 56 12
65900 69470 7 52 1570 16th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/16/1994 12:00:00 AM     Permit Number 33586 5991155.36555461 2104799.07062441 37.7588680376507 -122.47365896033 (37.7588680376507, -122.47365896033) 1 8 4 56 12
68155 186974 1 52 1600x Sloat Blvd 1 Median : Cutout Tree 1     9 Width 0ft   5986249.0864 2095869.2083 37.7340636742344 -122.489970132524 (37.7340636742344, -122.489970132524) 1 8 4 64 35
69921 112580 4 52 274X SAN MARCOS AVE 1 Median : Cutout Tree 2       3x20   5993121 2100271 37.7465487656332 -122.466531821158 (37.7465487656332, -122.466531821158) 1 8 4 29491 40
77820 183716 1 52 1231 37th Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5984571.0948 2106790.8677 37.7639534289968 -122.49657706948 (37.7639534289968, -122.49657706948) 1 8 3 56 35
80444 12496 7 52 307 Lake Merced Blvd 41 Sidewalk: Curb side : Cutout Tree 8     24 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
87134 66337 1 52 1230 31st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/10/1990 12:00:00 AM 12   Permit Number 29458 5986478.94641131 2106871.16119587 37.7642854833106 -122.489984375656 (37.7642854833106, -122.489984375656) 1 8 3 56 35
94353 107708 4 52 1798X 31st Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5986575.46002 2103344.33269 37.7546074174257 -122.489391225039 (37.7546074174257, -122.489391225039) 1 8 3 56 35
95679 107709 4 52 1798X 31st Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5986575.46002 2103344.33269 37.7546074174257 -122.489391225039 (37.7546074174257, -122.489391225039) 1 8 3 56 35
97429 187030 1 52 2501 Sunset Blvd 49 Sidewalk: Property side : Yard Tree 2     16 Width 0ft   5984957.5185 2097843.1311 37.7394080343891 -122.494580888609 (37.7394080343891, -122.494580888609) 1 8 3 29491 35
102135 63496 7 52 1665 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/03/1993 12:00:00 AM     Permit Number 31923 5993996.85139129 2104175.81914419 37.7573209042452 -122.463786619524 (37.7573209042452, -122.463786619524) 1 5 4 56 12
105578 185059 1 52 700x Sloat Blvd 3 Median : Cutout Tree 1     13 Width 0ft   5988840.8776 2095965.7184 37.7344796690595 -122.481016672562 (37.7344796690595, -122.481016672562) 1 8 4 64 35
106932 20988 1 52 2002X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree 1     200 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
108671 33222 7 52 130 Vasquez Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 11/06/1996 12:00:00 AM     Permit Number 37412 5995037.97859853 2099619.33373801 37.7448698872964 -122.459855964981 (37.7448698872964, -122.459855964981) 1 8 4 59 40
109483 218283 1 52 2x Sloat Blvd 8 Median : Yard Tree 1     10     5990775.7158 2095986.69925 37.7346495609245 -122.474328895956 (37.7346495609245, -122.474328895956) 1 8 4 64 40
113514 109631 4 52 390 BUCKINGHAM WAY   Sidewalk: Curb side : Cutout Tree 2       9x9   5989374 2093588 37.7279820381776 -122.478999652651 (37.7279820381776, -122.478999652651) 1 8 4 64 14
116388 111865 4 52 2X CHRISTOPHER DR 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5996768 2104018 37.7570468705973 -122.454191553084 (37.7570468705973, -122.454191553084) 1 5 4 63 12
117421 12495 7 52 307 Lake Merced Blvd 40 Sidewalk: Curb side : Cutout Tree 8     18 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
118053 12488 7 52 307 Lake Merced Blvd 33 Sidewalk: Curb side : Cutout Tree 8     24 90M   5985224.7663097 2094165.6248747 37.7293262181041 -122.49338600271 (37.7293262181041, -122.49338600271) 1 8 4 64 14
120756 217803 1 52 2x Sloat Blvd 3 Median : Yard Tree 1     34     5991018.47185 2095992.29774 37.7346789939345 -122.473490022742 (37.7346789939345, -122.473490022742) 1 8 4 64 40
121348 187032 1 52 2501 Sunset Blvd 51 Sidewalk: Property side : Yard Tree 2     11 Width 0ft   5984967.607 2097835.0603 37.7393864646033 -122.494545412715 (37.7393864646033, -122.494545412715) 1 8 3 29491 35
133966 187652 1 52 46 Cragmont Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5992908 2101735 37.7505562410762 -122.467374782979 (37.7505562410762, -122.467374782979) 1 8 4 29491 12
136242 181588 1 52 1227 37th Ave 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 0ft   5984569.5881 2106811.9615 37.7640112583591 -122.496583837339 (37.7640112583591, -122.496583837339) 1 8 3 56 35
138384 187029 1 52 2501 Sunset Blvd 48 Sidewalk: Property side : Yard Tree 2     38 Width 0ft   5984947.4301 2097843.1311 37.7394074439231 -122.49461576934 (37.7394074439231, -122.49461576934) 1 8 3 29491 35
149269 187038 1 52 2501 Sunset Blvd 57 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984961.8902 2097789.6624 37.7392614795793 -122.494561832752 (37.7392614795793, -122.494561832752) 1 8 3 29491 35
152370 69180 1 52 1310 45th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/26/1994 12:00:00 AM 8   Permit Number 33219 5982156.72464205 2106168.22486515 37.7621020835294 -122.504881372035 (37.7621020835294, -122.504881372035) 1 8 3 56 35
153065 254084 1 52 170x Kensington Way 3 Sidewalk: Property side : Yard Tree 2       3x3   5994883 2098695 37.7423229834884 -122.460324888843 (37.7423229834884, -122.460324888843) 1 8 4 59 40
153526 63705 7 52 1679 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/19/1987 12:00:00 AM     Permit Number 24365 5994000.03328261 2104083.32941502 37.757067134665 -122.463768902449 (37.757067134665, -122.463768902449) 1 5 4 56 12
154295 187031 1 52 2501 Sunset Blvd 50 Sidewalk: Property side : Yard Tree 2     19 Width 0ft   5984966.2618 2097842.7948 37.7394076227298 -122.494550633787 (37.7394076227298, -122.494550633787) 1 8 3 29491 35
156558 68317 7 52 1999X 48th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32130 5981353.71840295 2101490.23529545 37.7492103807501 -122.507311533808 (37.7492103807501, -122.507311533808) 1 8 3 29491 35