trees

Custom SQL query returning 33 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
150789 99672 1 66 1250X Shrader St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
49423 181571 1 66 1200 Sunset Blvd 30 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984860.385 2106736.0056 37.7638197374851 -122.495572469111 (37.7638197374851, -122.495572469111) 1 8 3 56 35
35821 93164 1 66 201 Upper Ter 2 Sidewalk: Property side : Cutout Landscaping 2   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
133338 93163 1 66 201 Upper Ter 1 Sidewalk: Property side : Cutout Landscaping 2   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
3033 121390 4 66 1301x 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5993851 2106604 37.7639796518152 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
8234 121391 4 66 1301x 07th Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5993851 2106604 37.7639796518152 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
10543 184869 1 66 1201 Sunset Blvd 58 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984640.7069 2106821.7773 37.7640423761792 -122.496338586447 (37.7640423761792, -122.496338586447) 1 8 3 56 35
120610 181577 1 66 1200 Sunset Blvd 59 Sidewalk: Property side : Yard Tree 2     6 Width 0ft   5984846.2035 2106866.5794 37.7641774260073 -122.495631149537 (37.7641774260073, -122.495631149537) 1 8 3 56 35
69162 181582 1 66 1200 Sunset Blvd 72 Sidewalk: Property side : Yard Tree 2     5 Width 0ft   5984863.0361 2106906.9776 37.7642893338004 -122.495575911156 (37.7642893338004, -122.495575911156) 1 8 3 56 35
66991 96631 7 66 1212 10th Ave 2 Sidewalk: Curb side : Cutout Tree 2   11/24/2015 12:00:00 AM   4x4 Permit Number 776835 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359) 11 8 11 56 12
143620 106469 4 66 100X HENRY ST 1 Sidewalk: Curb side : Cutout Tree 2     4 5x5   6002548 2107375 37.7665941299684 -122.434442151396 (37.7665941299684, -122.434442151396) 15 5 5 28862 3
157 114186 4 66 2200 HAYES ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
48266 114185 4 66 2200 HAYES ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
87985 237035 1 66 150 Octavia St 2 : Tree 1   04/12/2017 02:27:00 PM 3 Width 4ft   6005709.86547 2109855.10938 37.7735828886787 -122.423682154918 (37.7735828886787, -122.423682154918) 7 9 11 28852 10
32529 237036 1 66 150 Octavia St 4 : Tree 1   04/13/2017 02:42:00 PM 3 Width 4ft   6005705.05318 2109878.39065 37.7736465417793 -122.423700457022 (37.7736465417793, -122.423700457022) 7 9 11 28852 10
147554 239154 1 66 150 Octavia St 6 : Tree 1   04/13/2017 02:47:00 PM 3 Width 4ft   6005701.84613 2109911.12293 37.773736235682 -122.42371387849 (37.773736235682, -122.42371387849) 7 9 11 28852 10
36468 140265 1 66 2100X Grove St 3 Sidewalk: Curb side : Cutout Landscaping 2     0 Width 0ft   5997671.17 2110272.3417 37.7742714515841 -122.45151917218 (37.7742714515841, -122.45151917218) 15 5 2 29492 16
82677 244391 1 66 250 Octavia St 3 Sidewalk: Curb side : Cutout Tree 2   04/15/2017 01:16:00 PM 3 Width 0ft   6005650.1507 2110201.4148 37.774530388668 -122.423913347785 (37.774530388668, -122.423913347785) 7 9 11 28852 10
118266 244393 1 66 250 Octavia St 5 Sidewalk: Curb side : Cutout Tree 2   04/15/2017 01:35:00 PM 3 Width 0ft   6005645.568 2110235.0213 37.774622405266 -122.423931590501 (37.774622405266, -122.423931590501) 7 9 11 28852 10
143999 244348 1 66 300 Octavia St 3 Sidewalk: Curb side : Cutout Tree 1   04/19/2017 02:44:00 PM 3 Width 0ft   6005622.9962 2110384.2841 37.7750309704349 -122.424020287681 (37.7750309704349, -122.424020287681) 7 9 11 28852 10
126230 244349 1 66 300 Octavia St 4 Sidewalk: Curb side : Cutout Tree 1   04/19/2017 02:48:00 PM 3 Width 0ft   6005619.6911 2110403.6421 37.7750839362118 -122.424033097665 (37.7750839362118, -122.424033097665) 7 9 11 28852 10
90692 244351 1 66 300 Octavia St 6 Sidewalk: Curb side : Cutout Tree 1   04/20/2017 07:17:00 AM 3 Width 0ft   6005616.3861 2110436.6924 37.7751744977295 -122.424046881247 (37.7751744977295, -122.424046881247) 7 9 11 28852 10
126561 244299 1 66 350 Octavia St 2 Sidewalk: Curb side : Cutout Tree 1   04/20/2017 11:32:00 AM 3 Width 0ft   6005603.4021 2110525.6921 37.7754181362545 -122.424098126533 (37.7754181362545, -122.424098126533) 7 9 11 28852 10
21592 244300 1 66 350 Octavia St 3 Sidewalk: Curb side : Cutout Tree 1   04/20/2017 11:46:00 AM 3 Width 0ft   6005602.4578 2110538.44 37.7754530855803 -122.424102299872 (37.7754530855803, -122.424102299872) 7 9 11 28852 10
73743 244301 1 66 350 Octavia St 4 Sidewalk: Curb side : Cutout Tree 1   04/20/2017 11:53:00 AM 3 Width 0ft   6005600.097 2110553.5487 37.7754944371133 -122.424111541162 (37.7754944371133, -122.424111541162) 7 9 11 28852 10
163415 139390 1 66 432 OCTAVIA ST 5 Sidewalk: Curb side : Cutout Tree 2   05/02/2017 03:33:00 PM 3 Width 0ft   6005538.2982 2110931.9956 37.7765300709458 -122.424352241322 (37.7765300709458, -122.424352241322) 7 9 11 28852 10
41363 102755 4 66 61 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree 2     0 3x3   5996159.1 2114114.4 37.7847340229516 -122.457027629275 (37.7847340229516, -122.457027629275) 11 6 1 54 31
105604 23896 1 66 1581 Webster St 3 Sidewalk: Curb side : Cutout Tree 1   05/24/2017 12:00:00 AM 3 3x3   6003535.3531022 2114132.0136397 37.7852032161945 -122.431509502733 (37.7852032161945, -122.431509502733) 13 9 11 29490 13
59943 100203 1 66 2237 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2     0 4x4   6001906 2114287 37.7855362863546 -122.437157652203 (37.7855362863546, -122.437157652203) 13 6 11 29490 13
78365 12755 1 66 1733 Lake St 1 Sidewalk: Curb side : Cutout Tree 1   02/24/2008 12:00:00 AM 3 3X3   5990033.85435 2114674.56985 37.7859184370017 -122.478259694764 (37.7859184370017, -122.478259694764) 11 6 2 55 26
149312 104783 4 66 50 Walnut St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   5998501.2 2116298 37.790863832623 -122.449082132455 (37.790863832623, -122.449082132455) 13 6 1 54 31
112926 251642 1 66 2253 Broderick St 4 Sidewalk: Curb side : Cutout Landscaping 2       3x3   6000298.51737 2116393.24113 37.7912279703404 -122.442870356286 (37.7912279703404, -122.442870356286) 13 6 1 29490 27
9498 97930 4 66 1615 Grant Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6010461.1 2120070.1 37.801897866839 -122.40796734514 (37.801897866839, -122.40796734514) 3 1 10 308 23