trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6051 207048 1 6 658 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/20/2017 12:00:00 AM 3 Width 2ft Permit Number 772511 5997718.79866 2095007.66028 37.7323611532403 -122.450253874818 (37.7323611532403, -122.450253874818) 9 7 4 59 40
12204 164659 1 6 150 Granville Way 1 Sidewalk: Curb side : Cutout Tree 2   08/13/2020 12:00:00 AM 3 Width 4ft Permit Number 785596 5994533.58351 2098539.8464 37.7418768645301 -122.461521809887 (37.7418768645301, -122.461521809887) 1 8 4 59 40
19808 207047 1 6 654 Joost Ave 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 2ft   5997739.24902 2095008.66176 37.7323650733825 -122.450183245677 (37.7323650733825, -122.450183245677) 9 7 4 59 40
28945 157260 1 6 1059 Portola Dr 1 Sidewalk: Curb side : Cutout Tree 2   05/31/2018 12:00:00 AM 3 Width 0ft Permit Number 781960 5995594.16193 2098091.79633 37.7407076181758 -122.457822284089 (37.7407076181758, -122.457822284089) 9 7 4 59 40
50062 254193 1 6 1265 Monterey Blvd 1 Front Yard : Cutout Tree 2 FUF 01/19/2018 12:00:00 AM 3 3x3 Permit Number 781221 5994091.43615 2094320.67109 37.7302665946388 -122.462744594485 (37.7302665946388, -122.462744594485) 9 8 4 59 40
57763 207044 1 6 755 Foerster St 1 Sidewalk: Property side : Yard Tree 2     4 Width 3ft   5998014.32968 2095894.50831 37.7348131350024 -122.44929603208 (37.7348131350024, -122.44929603208) 9 7 4 59 40
63727 207043 1 6 73 Keystone Way 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   5994097.83418 2093287.06293 37.7274289275879 -122.46264752637 (37.7274289275879, -122.46264752637) 9 8 4 59 40
79084 207006 1 6 243 Vicente St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   5992316.05801 2097825.56846 37.7397877510963 -122.469137249186 (37.7397877510963, -122.469137249186) 1 8 4 59 40
80935 207042 1 6 40 Vasquez Ave 3 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   5995660.33467 2100048.89738 37.746085134133 -122.457735064227 (37.746085134133, -122.457735064227) 1 5 4 59 40
81975 207014 1 6 651 Joost Ave 2 Sidewalk: Curb side : Cutout Tree 2   11/20/2017 12:00:00 AM 3 Width 1ft Permit Number 771866 5997782.54111 2094977.36202 37.7322816090925 -122.450031320482 (37.7322816090925, -122.450031320482) 9 7 4 59 40
147878 207049 1 6 662 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 2ft   5997703.56918 2095007.7992 37.7323606631136 -122.450306536421 (37.7323606631136, -122.450306536421) 9 7 4 59 40
161683 207045 1 6 607 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5998977.59415 2096753.43976 37.7372266087217 -122.446027465895 (37.7372266087217, -122.446027465895) 9 7 4 59 40
165946 207007 1 6 127 Westgate Dr 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   5993382.10868 2093854.31743 37.7289452232334 -122.465162955333 (37.7289452232334, -122.465162955333) 9 8 4 59 40
173911 207046 1 6 654 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 2ft   5997758.19926 2095006.4821 37.7323601729864 -122.450117573561 (37.7323601729864, -122.450117573561) 9 7 4 59 40
64471 207005 4 6 171 Wawona St 1 Sidewalk: Curb side : Cutout Tree 2   08/06/2014 12:00:00 AM 1 Width 3ft Permit Number 773294 5992787.45104 2098017.32873 37.7403415032629 -122.467521326669 (37.7403415032629, -122.467521326669) 1 8 4 59 40
104768 207004 4 6 171 Wawona St 2 Sidewalk: Curb side : Cutout Tree 2   08/06/2014 12:00:00 AM 1 Width 3ft Permit Number 773294 5992803.19794 2098037.09896 37.7403966964551 -122.46746831791 (37.7403966964551, -122.46746831791) 1 8 4 59 40
14691 69919 7 6 95 Mercedes Way 2 Sidewalk: Curb side : Cutout Tree 2 FUF 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.7286182461033 -122.470591251084 (37.7286182461033, -122.470591251084) 9 8 4 59 40
29381 94673 7 6 662 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53809 5997706.3 2095032.9 37.7324297402139 -122.450298904109 (37.7324297402139, -122.450298904109) 9 7 4 59 40
53141 71841 7 6 95 Mercedes Way 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.7286182461033 -122.470591251084 (37.7286182461033, -122.470591251084) 9 8 4 59 40
66000 88139 7 6 523 Teresita Blvd   Sidewalk: Curb side : Cutout Tree 2   07/07/2008 12:00:00 AM   3x3 Permit Number 51168 5998937.5 2097522.9 37.7393370734625 -122.446221422912 (37.7393370734625, -122.446221422912) 9 7 4 59 40
79056 94672 7 6 658 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53808 5997731.1 2095032.6 37.732430335747 -122.450213143469 (37.732430335747, -122.450213143469) 9 7 4 59 40
89273 38913 7 6 70 Borica St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40725 5992519.41888039 2091685.55807474 37.7229405587858 -122.467987623931 (37.7229405587858, -122.467987623931) 9 8 4 59 40
109198 94671 7 6 654 Joost Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53807 5997755.7 2095032.2 37.7324306451966 -122.450128067067 (37.7324306451966, -122.450128067067) 9 7 4 59 40
150135 50120 7 6 243 Vicente St 1 Sidewalk: Curb side : Cutout Tree 2   09/14/2012 12:00:00 AM     Permit Number 769150 5992346.75268289 2097836.73381964 37.7398201819052 -122.469031933295 (37.7398201819052, -122.469031933295) 1 8 4 59 40
154355 38914 7 6 70 Borica St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40725 5992519.41888039 2091685.55807474 37.7229405587858 -122.467987623931 (37.7229405587858, -122.467987623931) 9 8 4 59 40
189614 94670 7 6 654 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53807 5997755.7 2095032.2 37.7324306451966 -122.450128067067 (37.7324306451966, -122.450128067067) 9 7 4 59 40