trees

Custom SQL query returning 31 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
15723 105168 6 28 4755X 03RD ST 2 Front Yard : Cutout Tree 19     23 3x3 Permit Number 770204 6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
24698 8097 7 40 762 Fulton St 8 Sidewalk: Curb side : Cutout Tree 19   12/04/2010 12:00:00 AM 3 3X3   6004143.8911021 2111521.3201229 37.7780693729621 -122.4292179278 (37.7780693729621, -122.4292179278) 7 9 11 28852 41
29803 105161 6 40 1600X Oakdale Ave 2 Front Yard : Cutout Tree 19     13 3x3   6014869.34112 2095641.83637 37.735069048787 -122.391004288315 (37.735069048787, -122.391004288315) 10 3 8 58 1
48629 105164 1 16 1600X Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree 19     15 5x5   6014842.39521 2095664.68421 37.735130289038 -122.391099047201 (37.735130289038, -122.391099047201) 10 3 8 58 1
52126 22281 7 53 4755X 03rd St 5 Sidewalk: Curb side : Cutout Tree 19     18 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
57045 105169 8 28 4755X 03RD ST 3 Front Yard : Cutout Tree 19     23 4x4   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
60470 8094 1 71 762 Fulton St 5 Sidewalk: Curb side : Cutout Tree 19     100 3X3   6004211.6397 2111535.7715 37.7781128879326 -122.428984591665 (37.7781128879326, -122.428984591665) 7 9 11 28852 41
75443 105174 4 57 1601X NEWCOMB AVE 3 Sidewalk: Curb side : Cutout Tree 19     40 3x3 Permit Number 770204 6015135 2095759 37.7354054940815 -122.390093985074 (37.7354054940815, -122.390093985074) 10 3 8 58 1
84098 105172 4 122 1601X NEWCOMB AVE 1 Sidewalk: Curb side : Cutout Tree 19     12 3x3 Permit Number 770204 6015135 2095759 37.7354054940815 -122.390093985074 (37.7354054940815, -122.390093985074) 10 3 8 58 1
87319 22283 7 44 4755X 03rd St 7 Sidewalk: Curb side : Cutout Tree 19     6 3X3 Permit Number 770204 6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
88357 8090 1 84 762 Fulton St 1 Sidewalk: Curb side : Cutout Tree 19   12/04/2010 12:00:00 AM 3 3X3   6004349.2473 2111557.1689 37.7781794280627 -122.428510082803 (37.7781794280627, -122.428510082803) 7 9 11 28852 41
89603 26011 7 8 1618X Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree 19   01/02/1998 12:00:00 AM 6 3X3   6014975.06835 2095558.90554 37.7348472038217 -122.390632955135 (37.7348472038217, -122.390632955135) 10 3 8 58 1
91890 22277 7 123 4755X 03rd St 1 Sidewalk: Curb side : Cutout Tree 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
93143 22280 7 123 4755X 03rd St 4 Sidewalk: Curb side : Cutout Tree 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
101451 105175 1 122 1601X Newcomb Ave 4 Sidewalk: Curb side : Cutout Tree 19     10 3x3   6015153.3918 2095715.6028 37.7352873542424 -122.390027366589 (37.7352873542424, -122.390027366589) 10 3 8 58 1
103033 105163 4 230 1600X OAKDALE AVE 2 Sidewalk: Curb side : Cutout Tree 19     17 4x4 Permit Number 770204 6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
122917 22284 7 44 4755X 03rd St 8 Sidewalk: Curb side : Cutout Tree 19     6 3x3 Permit Number 770204 6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
130535 105165 1 38 1600X OAKDALE AVE 4 Sidewalk: Curb side : Cutout Tree 19     16 3x3   6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
133384 105167 8 28 4755X 03RD ST 1 Front Yard : Cutout Tree 19     8 3x3   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
142553 8096 1 83 762 Fulton St 7 Sidewalk: Curb side : Cutout Tree 19   04/14/1998 12:00:00 AM 18 3X3   6004110.3708 2111520.4613 37.7780651171853 -122.429333825297 (37.7780651171853, -122.429333825297) 7 9 11 28852 41
146144 105171 8 19 4755X 03RD ST 5 Front Yard : Yard Tree 19     14 4x4   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
149337 8095 1 83 762 Fulton St 6 Sidewalk: Curb side : Cutout Tree 19   04/14/1998 12:00:00 AM 24 3X3   6004129.5547 2111522.3059 37.77807126806 -122.429267592872 (37.77807126806, -122.429267592872) 7 9 11 28852 41
149518 109194 8 172 4705 03rd St   Back Yard : Yard Tree 19     45     6015121.6 2095617 37.7350148477359 -122.390130397219 (37.7350148477359, -122.390130397219) 10 3 8 58 1
151905 22278 7 123 4755X 03rd St 2 Sidewalk: Curb side : Cutout Tree 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
164164 105170 8 19 4755X 03RD ST 4 Front Yard : Cutout Tree 19     2 3x3   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
168475 8092 1 84 762 Fulton St 3 Sidewalk: Curb side : Cutout Tree 19   12/04/2010 12:00:00 AM 3 3X3   6004291.3267 2111546.8391 37.778147787093 -122.428709714706 (37.778147787093, -122.428709714706) 7 9 11 28852 41
170027 22282 7 123 4755X 03rd St 6 Sidewalk: Curb side : Cutout Tree 19     4 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
174039 22279 7 123 4755X 03rd St 3 Sidewalk: Curb side : Cutout Tree 19     6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
179978 105160 6 28 1600X OAKDALE AVE 1 Front Yard : Yard Tree 19     13   Permit Number 770204 6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
185160 8091 1 84 762 Fulton St 2 Sidewalk: Curb side : Cutout Tree 19   12/04/2010 12:00:00 AM 3 3X3   6004317.1512 2111553.1108 37.7781664691559 -122.428620825565 (37.7781664691559, -122.428620825565) 7 9 11 28852 41
191133 26012 1 230 1618X Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree 19   01/02/1998 12:00:00 AM 3 3X3   6015044.019 2095518.8416 37.7347410214535 -122.390391768412 (37.7347410214535, -122.390391768412) 10 3 8 58 1