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)
167 99668 1 17 150X Alma St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
23622 99684 1 17 165 Grattan St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/04/2013 12:00:00 AM 8 3x3 Permit Number 770537 5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
24577 99676 1 17 1250X Shrader St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
34106 31711 1 7 1250X Shrader St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/19/1995 12:00:00 AM 6 3x3 Permit Number 35211 5997882.313818 2106467.94501531 37.7638376395234 -122.450514467435 (37.7638376395234, -122.450514467435) 15 5 11 29492 9
37865 99674 1 17 1250X Shrader St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   30 4x4   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
45783 99671 1 16 150X Alma St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
52988 99678 1 57 1250X Shrader St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 4x4 Permit Number 770537 5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
55011 99667 1 17 150X Alma St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
56802 99677 1 17 1250X Shrader St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/04/2013 12:00:00 AM 16 3x3 Permit Number 770537 5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
66778 99664 1 17 150X Alma St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5997932 2106516 37.7639724300488 -122.450346083136 (37.7639724300488, -122.450346083136) 15 5 11 29492 9
67135 99683 1 17 165 Grattan St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/04/2013 12:00:00 AM 8 3x3 Permit Number 770537 5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
69253 72535 1 17 150X Alma St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/21/1992 12:00:00 AM 20 3x3   5997957.39996807 2106223.02713962 37.7631694542329 -122.450237113175 (37.7631694542329, -122.450237113175) 15 5 11 29492 9
79000 99679 1 119 165 Grattan St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
81109 99665 1 17 150X Alma St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
94523 99689 1 16 150X Alma St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
97987 99681 1 36 165 Grattan St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
99360 99687 1 17 165 Grattan St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
114759 99670 1 17 150X Alma St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
117961 99675 1 17 1250X Shrader St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
150789 99672 1 66 1250X Shrader St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
156345 72536 1 17 1250X Shrader St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/21/1992 12:00:00 AM 10 3x3   5997766.568459 2106397.97443782 37.7636388926021 -122.45090974788 (37.7636388926021, -122.45090974788) 15 5 11 29492 9
157508 99686 1 17 165 Grattan St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
171377 99688 1 17 165 Grattan St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
175889 99669 1 17 150X Alma St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x6   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
176228 99673 1 17 1250X Shrader St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 4x4   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
180042 99682 1 57 165 Grattan St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
183108 99680 1 36 165 Grattan St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   5 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
193525 99685 1 17 165 Grattan St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9