trees

Custom SQL query returning 46 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
4815 98680 7 57 199X Park St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
24545 70470 4 57 450X Banks St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
25379 70471 4 28 450X Banks St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 32 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
33305 102189 4 57 3999X Folsom St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
44529 97900 1 148 375X Precita Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   16 3x4   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
46177 73875 4 163 450X Banks St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 8 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
50209 97899 4 8 375X Precita Ave 5 Sidewalk: Curb side : Cutout Tree 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
51837 113436 1 57 198x HIGHLAND AVE 3 Sidewalk: Curb side : Cutout Tree 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
52882 102190 4 57 3999X Folsom St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
57109 102194 4 57 3999X Folsom St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   4 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
58400 113437 1 57 198x HIGHLAND AVE 4 Sidewalk: Curb side : Cutout Tree 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
67353 98678 7 57 199X Park St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
68964 113434 1 57 198x HIGHLAND AVE 1 Sidewalk: Curb side : Cutout Tree 4     12 4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
69126 102186 4 70 3999X Folsom St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
71171 98681 7 57 199X Park St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
78075 98679 7 57 199X Park St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
78897 102155 4 57 450X Banks St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
81015 97898 4 8 375X Precita Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
84800 97902 4 37 375X Precita Ave 8 Sidewalk: Curb side : Cutout Tree 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
85919 98676 7 57 199X Park St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
87067 98675 7 17 199X Park St 1 Sidewalk: Curb side : Cutout Tree 4 DPW         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
87145 113435 1 57 198x HIGHLAND AVE 2 Sidewalk: Curb side : Cutout Tree 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
87595 97901 4 37 375X Precita Ave 7 Sidewalk: Curb side : Cutout Tree 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
91360 110190 1 57 625 Holly Park Cir 6 Sidewalk: Curb side : Cutout Tree 4           6006167.62160945 2096413.49051844 37.7367011423593 -122.421144072665 (37.7367011423593, -122.421144072665) 2 7 7 28859 2
92761 110187 1 57 625 Holly Park Cir 3 Sidewalk: Curb side : Cutout Tree 4           6006167.62160945 2096413.49051844 37.7367011423593 -122.421144072665 (37.7367011423593, -122.421144072665) 2 7 7 28859 2
97154 70472 4 31 450X Banks St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 4 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
98851 98677 7 57 199X Park St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
100826 78999 4 57 555 Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
101825 97903 4 16 375X Precita Ave 9 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
103551 102191 4 57 3999X Folsom St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
104727 78992 4 57 450X Banks St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
108397 102154 4 57 450X Banks St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
109710 97896 4 8 375X Precita Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
126964 97897 4 8 375X Precita Ave 3 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
130673 102193 4 57 3999X Folsom St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   18 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
149558 73421 4 44 450X Banks St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 10 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
151372 74109 4 57 555 Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
153285 102156 4 57 450X Banks St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
154930 78998 4 40 450X Banks St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 6 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
155971 73874 4 57 450X Banks St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
160561 102187 4 70 3999X Folsom St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   8 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
165008 98682 7 57 199X Park St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
169010 102195 4 57 3999X Folsom St 9 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
176008 74108 4 57 555 Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
183831 102192 4 57 3999X Folsom St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
189482 97895 4 8 375X Precita Ave 1 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2