trees

Custom SQL query returning 39 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6227 77210 1 67 499X Hearst Ave 17 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
15793 42348 1 67 380X Flood Ave 7 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 3 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
23669 42343 1 67 380X Flood Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
37102 77218 1 1 499X Hearst Ave 22 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 6x50   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
37151 77198 1 67 499X Hearst Ave 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
55302 42355 1 151 380X Flood Ave 14 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 9 8x90 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
70737 42344 1 151 380X Flood Ave 3 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 8 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
72021 42345 1 67 380X Flood Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
72982 42350 1 67 380X Flood Ave 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
76451 77217 1 67 499X Hearst Ave 21 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
81932 42360 1 67 380X Flood Ave 19 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
82359 42366 1 67 250 Foerster St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
82711 42354 1 67 380X Flood Ave 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
89171 77219 1 67 499X Hearst Ave 23 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
90903 77212 1 67 499X Hearst Ave 19 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
99306 77204 1 67 499X Hearst Ave 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 6 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
99818 77211 1 67 499X Hearst Ave 18 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 8 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
104954 95260 1 149 2290X 14th Ave 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
108541 42349 1 67 380X Flood Ave 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
112205 74759 1 70 250 Foerster St 13 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 30 5x7   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
115123 77207 1 67 499X Hearst Ave 14 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
123453 95261 1 149 2290X 14th Ave 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
130186 42352 1 67 380X Flood Ave 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
144395 42361 1 67 250 Foerster St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
147728 42365 1 67 250 Foerster St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
153739 77206 1 67 499X Hearst Ave 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
154352 42367 1 67 250 Foerster St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
158580 95258 1 149 2290X 14th Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
160859 42357 1 67 380X Flood Ave 16 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 3 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
161881 42369 1 67 250 Foerster St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
162866 42347 1 67 380X Flood Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
180710 42358 1 67 380X Flood Ave 17 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 4x4 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
182513 42356 1 67 380X Flood Ave 15 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
186220 77209 1 67 499X Hearst Ave 16 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
187263 96085 1 149 2290X 14th Ave 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
188359 95262 1 149 2290X 14th Ave 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
189005 75040 1 17 499X Hearst Ave 2 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 18 6x20   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
190317 95259 1 149 2290X 14th Ave 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
193722 77213 1 151 499X Hearst Ave 20 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency 05/15/1999 12:00:00 AM 8 6x50   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40