trees

Custom SQL query returning 28 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
45878 173675 6 464 299x Beale St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
48723 96186 6 17 333 Harrison St 3 Sidewalk: Property side : Tree 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6
50152 173671 6 72 299x Beale St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
62378 173676 6 464 299x Beale St 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
65204 100696 6 145 200X 01st St 3 Front Yard : Yard Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
67391 173674 6 102 299x Beale St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
68704 173596 6 27 300 Howard St 1 Sidewalk: Property side : Yard Tree 2       3x3 Permit Number 779179 6014439 2115766 37.7903017260092 -122.393900378517 (37.7903017260092, -122.393900378517) 12 2 9 28855 6
70762 100699 6 145 200X 01st St 6 Front Yard : Yard Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
73225 100695 6 145 200X 01st St 2 Front Yard : Yard Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
92116 173673 6 102 299x Beale St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
93660 96184 6 17 333 Harrison St 1 Sidewalk: Property side : Tree 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6
98870 100701 6 145 200X 01st St 8 Front Yard : Yard Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
100518 100698 6 145 200X 01st St 5 Front Yard : Yard Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
111755 109415 6 71 4 GUY PL 2 Front Yard : Yard Tree 2           6014378.1 2114502.6 37.7868293368446 -122.394022608955 (37.7868293368446, -122.394022608955) 6 2 9 28855 6
126787 96185 6 17 333 Harrison St 2 Sidewalk: Property side : Tree 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6
137482 100694 6 145 200X 01st St 1 Front Yard : Yard Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
170900 100697 6 145 200X 01st St 4 Front Yard : Yard Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
177074 173678 6 72 299x Beale St 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
181535 173677 6 464 299x Beale St 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
182062 100700 6 145 200X 01st St 7 Front Yard : Yard Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137) 6 2 9 28855 6
182808 173672 6 102 299x Beale St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
40244 115123 6 11 499X MAIN ST 1 Sidewalk: Curb side : Cutout Tree 2     12     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
18324 109414 6 34 4 GUY PL 1 Front Yard : Yard Tree 2     14     6014378.1 2114502.6 37.7868293368446 -122.394022608955 (37.7868293368446, -122.394022608955) 6 2 9 28855 6
2213 261044 6 12 499x Howard St 2 Sidewalk: Curb side : Cutout Tree 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
16799 261042 6 12 499x Howard St 3 Sidewalk: Curb side : Cutout Tree 2   12/10/2019 12:00:00 AM 3 3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6
68737 104228 6 17 183 FREMONT ST 1 Front Yard : Yard Tree 2     4   Permit Number 770922 6014038 2115456 37.7894282446126 -122.395266095466 (37.7894282446126, -122.395266095466) 12 2 9 28855 6
46337 115125 6 11 499X MAIN ST 3 Sidewalk: Curb side : Cutout Tree 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
110338 115124 6 11 499X MAIN ST 2 Sidewalk: Curb side : Cutout Tree 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6