trees

Custom SQL query returning 20 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
158967 79726 7 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50955 6008416.19534554 2114892.53002417 37.7875668360064 -122.414677080613 (37.7875668360064, -122.414677080613) 5 1 10 28858 21
131191 71549 1 6 780 Post St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 08/18/2015 12:00:00 AM 3 3x3 Permit Number 772812 6008431.05429 2114892.38013 37.7875672592553 -122.414625660841 (37.7875672592553, -122.414625660841) 5 1 10 28858 21
49974 73594 1 6 780 Post St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/12/2014 12:00:00 AM 3   Permit Number 772812 6008453.79298 2114896.74793 37.7875805296608 -122.414547298434 (37.7875805296608, -122.414547298434) 5 1 10 28858 21
142268 129380 1 6 730 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6008321.92773 2115014.63424 37.7878968077251 -122.415011874722 (37.7878968077251, -122.415011874722) 5 1 10 28858 21
102379 84816 1 6 736 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2   11/13/2009 12:00:00 AM 4 3x3 Permit Number 53031 6008319.93046 2115035.61847 37.7879543130824 -122.415020270782 (37.7879543130824, -122.415020270782) 5 1 10 28858 21
81750 129385 1 6 722 Mason St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6009662.68842 2115877.38276 37.7903409582254 -122.41043401253 (37.7903409582254, -122.41043401253) 5 1 10 28857 21
74010 129386 1 6 929 Pine St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6009490.7484 2116033.66261 37.7907604245028 -122.411039958651 (37.7907604245028, -122.411039958651) 5 1 10 28857 21
146089 52362 1 6 1438ASHINGTON Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/14/2005 12:00:00 AM 9   Permit Number 48498 6007994.93646 2117377.76116 37.7943669936906 -122.416310648633 (37.7943669936906, -122.416310648633) 5 1 10 28858 21
154237 60223 1 6 1230 Mason St 1 Sidewalk: Curb side : Cutout Tree 2   06/30/2009 12:00:00 AM 8 3x3 Permit Number 52240 6009426.59197 2117542.6242 37.7949000677337 -122.411368584404 (37.7949000677337, -122.411368584404) 3 1 10 28857 4
166093 88438 7 6 1248 Mason St   Sidewalk: Curb side : Cutout Tree 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52242 6009421 2117567 37.7949666840821 -122.411389656386 (37.7949666840821, -122.411389656386) 3 1 10 28857 4
81222 83687 1 6 1250-1262 Mason St 1 Sidewalk: Curb side : Cutout Tree 2   06/30/2009 12:00:00 AM 6 3x3 Permit Number 52242 6009414.65188 2117634.89994 37.7951527646548 -122.411416421158 (37.7951527646548, -122.411416421158) 3 1 10 28857 4
42267 83686 1 6 1250-1262 Mason St 2 Sidewalk: Curb side : Cutout Tree 2   06/30/2009 12:00:00 AM 7 3x3 Permit Number 52242 6009408.29288 2117660.17543 37.7952218082983 -122.411440210903 (37.7952218082983, -122.411440210903) 3 1 10 28857 4
80490 83685 1 6 1250-1262 Mason St 3 Sidewalk: Curb side : Cutout Tree 2   06/30/2009 12:00:00 AM 6 3x3 Permit Number 52242 6009407.14931 2117677.56911 37.7952695029448 -122.411445397284 (37.7952695029448, -122.411445397284) 3 1 10 28857 4
194195 52070 1 6 939 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009656.25559 2117750.51311 37.7954837583147 -122.410588599703 (37.7954837583147, -122.410588599703) 3 1 10 28857 4
127633 52071 1 6 939 Jackson St 2 Sidewalk: Curb side : Cutout Tree 2   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009677.58908 2117754.14875 37.7954949369081 -122.410515038747 (37.7954949369081, -122.410515038747) 3 1 10 28857 4
4231 261663 4 6 1099x Broadway   Sidewalk: Curb side : Cutout Tree 2   10/28/2020 12:00:00 AM 3 3x3   6008393 2118190 37.7966195766837 -122.414990814528 (37.7966195766837, -122.414990814528) 5 1 10 308 21
6798 125247 1 6 1085 Broadway 1 Sidewalk: Curb side : Cutout Tree 2   10/28/2020 12:00:00 AM 3 3x3 Permit Number 782055 6008420.1565 2118241.89629 37.796763597016 -122.414900521554 (37.796763597016, -122.414900521554) 5 1 10 308 21
4801 125249 1 6 1077 Broadway 1 Sidewalk: Curb side : Cutout Tree 2   10/28/2020 12:00:00 AM 3 Width 3ft   6008457.69643 2118247.71377 37.7967816796858 -122.414771036277 (37.7967816796858, -122.414771036277) 5 1 10 308 21
150091 129390 1 6 902 Vallejo St 1 Sidewalk: Curb side : Pot Tree 2     4 Width 4ft   6009192.86484 2118752.75452 37.798209676283 -122.412262888224 (37.798209676283, -122.412262888224) 3 1 10 308 21
188002 88645 7 6 2500x Larkin St   Sidewalk: Curb side : Cutout Tree 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51618 6006882.7 2119972.1 37.8014277902223 -122.420343352043 (37.8014277902223, -122.420343352043) 5 1 1 28858 32