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)
297 113036 1 17 242X 07TH AVE 1 Sidewalk: Curb side : Cutout Tree 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
1119 113031 1 78 251 06th Ave 2 Sidewalk: Curb side : Cutout Tree 4     14 3x3   5993971.49407 2113867.66105 37.7839306754778 -122.464578040665 (37.7839306754778, -122.464578040665) 11 6 2 54 11
3404 74737 1 86 151X Palm Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5995889.08215 2113282.06845 37.7824331529909 -122.457901543211 (37.7824331529909, -122.457901543211) 11 6 1 54 31
5484 71815 1 36 151X Palm Ave 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   5995888.68435 2113315.23973 37.7825242096287 -122.45790532062 (37.7825242096287, -122.45790532062) 11 6 1 54 31
6245 75019 1 86 151X Palm Ave 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5995892.05475 2113163.21783 37.782106991639 -122.457882656117 (37.782106991639, -122.457882656117) 11 6 1 54 31
6745 74583 1 26 151X Palm Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 01/31/2018 12:00:00 AM 3 3x3   5995884.6031 2113341.96396 37.7825973527613 -122.457921374418 (37.7825973527613, -122.457921374418) 11 6 1 54 31
10723 113037 1 17 242X 07TH AVE 2 Sidewalk: Curb side : Cutout Tree 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
11183 74883 1 26 151X Palm Ave 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 01/31/2018 12:00:00 AM 3 3x3   5995886.83117 2113252.75826 37.7823525456975 -122.457907208857 (37.7823525456975, -122.457907208857) 11 6 1 54 31
11450 93122 1 26 151X Palm Ave 14 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 01/31/2018 12:00:00 AM 3 3x3   5995895.24901 2113041.91566 37.7817741116959 -122.457862824896 (37.7817741116959, -122.457862824896) 11 6 1 54 31
12599 93632 1 26 151X Palm Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 01/31/2018 12:00:00 AM 3 3x3 Permit Number 53266 5995882.07932 2113403.99303 37.7827675230466 -122.457934595796 (37.7827675230466, -122.457934595796) 11 6 1 54 31
16772 113034 1 25 251 06th Ave 5 Sidewalk: Curb side : Cutout Tree 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617) 11 6 2 54 11
18625 113033 1 33 251 06th Ave 4 Sidewalk: Curb side : Cutout Tree 4     14 3x3   5993974.82941 2113822.74411 37.7838075380241 -122.464563239136 (37.7838075380241, -122.464563239136) 11 6 2 54 11
19099 113032 1 205 251 06th Ave 3 Sidewalk: Curb side : Cutout Tree 4     3 3x3   5993973.41927 2113841.38508 37.7838586397785 -122.464569471656 (37.7838586397785, -122.464569471656) 11 6 2 54 11
63809 99258 1 36 151X Palm Ave 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   5 3x3   5995889.58772 2113188.82138 37.7821771504315 -122.45789304424 (37.7821771504315, -122.45789304424) 11 6 1 54 31
74212 93121 1 70 151X Palm Ave 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   9 3x3   5995892.67419 2113127.59534 37.7820092173573 -122.457877934554 (37.7820092173573, -122.457877934554) 11 6 1 54 31
75199 113039 1 17 242X 07TH AVE 4 Sidewalk: Curb side : Cutout Tree 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
83242 113035 1 110 251 06th Ave 6 Sidewalk: Curb side : Cutout Tree 4     1 3x3   5993975.80165 2113783.25834 37.7836991768592 -122.464557007516 (37.7836991768592, -122.464557007516) 11 6 2 54 11
85175 93633 1 36 151X Palm Ave 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/16/2010 12:00:00 AM 3 3x3 Permit Number 53266 5995881.0393 2113432.55638 37.7828458906338 -122.457940261495 (37.7828458906338, -122.457940261495) 11 6 1 54 31
89046 113040 1 17 242X 07TH AVE 5 Sidewalk: Curb side : Cutout Tree 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
95696 99259 1 36 151X Palm Ave 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   5995893.7088 2113098.76002 37.7819301026873 -122.457872268014 (37.7819301026873, -122.457872268014) 11 6 1 54 31
124230 107423 1 110 251 06th Ave 1 Sidewalk: Curb side : Cutout Tree 4     2 3x3   5993968.46376 2113916.3836 37.7840642796834 -122.464592063385 (37.7840642796834, -122.464592063385) 11 6 2 54 11
130847 98743 4 70 155 Masonic Ave 5 Sidewalk: Property side : Tree 4 DPW for City Agency         5998843.8 2112455 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218) 15 6 2 54 16
142206 99260 1 36 151X Palm Ave 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/08/2015 03:10:00 PM 3 3x3   5995894.58408 2113075.36458 37.7818659153243 -122.457867546462 (37.7818659153243, -122.457867546462) 11 6 1 54 31
144986 113038 1 17 242X 07TH AVE 3 Sidewalk: Curb side : Cutout Tree 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
165305 93105 1 36 151X Palm Ave 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 02/02/2010 12:00:00 AM 3 3x3 Permit Number 53160 5995888.42271 2113224.45495 37.7822749237882 -122.457899654053 (37.7822749237882, -122.457899654053) 11 6 1 54 31
185623 99257 1 36 151X Palm Ave 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   5995884.63149 2113369.41772 37.7826727350965 -122.457923263549 (37.7826727350965, -122.457923263549) 11 6 1 54 31