trees

Custom SQL query returning 21 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2941 261590 2 11 299x 14th St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
14403 260183 2 9 66x McCoppin St 3 Sidewalk: Curb side : Cutout Tree 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
15819 151746 2 1 3030 17th St 3 Sidewalk: Curb side : Cutout Tree 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008502.96204 2106251.6003 37.763845762487 -122.413765441348 (37.763845762487, -122.413765441348) 8 4 7 28859 19
22638 113651 2 162 98X 10TH ST 3 Sidewalk: Curb side : Cutout Tree 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
23724 15248 2 11 1401X Mission St 3 Sidewalk: Curb side : Cutout Tree 2   12/29/2016 12:00:00 AM 3 3X3 Permit Number 770901 6007914.86722 2110337.26914 37.7750310067149 -122.41608885424 (37.7750310067149, -122.41608885424) 8 2 9 28853 34
27322 201695 2 11 342 08th St 3 Sidewalk: Curb side : Cutout Tree 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009961.08769 2109918.57103 37.7739961964126 -122.408980952704 (37.7739961964126, -122.408980952704) 8 2 9 28853 34
36458 113646 2 11 1400 MISSION ST 3 Sidewalk: Curb side : Cutout Tree 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
50722 253485 2 116 1x Gordon St 3 Sidewalk: Curb side : Cutout Tree 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
61672 15237 2 11 1321 Mission St 3 Sidewalk: Curb side : Cutout Tree 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008256.52807 2110680.03106 37.7759913537931 -122.414931236282 (37.7759913537931, -122.414931236282) 8 2 9 28853 34
72715 44010 2 50 405x Florida St 3 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
93259 253749 2 72 2x Rhode Island St 3 Sidewalk: Curb side : Cutout Tree 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
107596 151878 2 8 1450 15th St 3 Sidewalk: Curb side : Cutout Tree 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007623.77597 2107385.08821 37.7669086438472 -122.416886599646 (37.7669086438472, -122.416886599646) 8 4 7 28853 19
112760 196591 2 44 43 Lafayette St 3 : Tree 2     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782) 8 2 9 28853 19
112949 244834 2 36 1875 Mission St 3 Sidewalk: Curb side : Cutout Tree 1   12/02/2017 12:00:00 AM 3 Width 3ft   6006796.01232 2107481.11788 37.7671257231045 -122.419756521569 (37.7671257231045, -122.419756521569) 8 4 7 28853 19
115603 251289 2 11 33 08th St 3 Sidewalk: Curb side : Cutout Tree 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
120199 116966 2 2 480 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree 2     1 3x3   6010311.67872 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703) 8 4 8 28859 19
139534 253737 2 11 1 Henry Adams St 3 Sidewalk: Curb side : Cutout Tree 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
162521 192596 2 11 1335 Mission St 3 Sidewalk: Curb side : Cutout Tree 2   03/07/1995 12:00:00 AM 3 Width 4ft Permit Number 770747 6008295.90964 2110693.56586 37.7760307299718 -122.414795962779 (37.7760307299718, -122.414795962779) 8 2 9 28853 34
164004 201690 2 11 324 08th St 3 Sidewalk: Curb side : Cutout Tree 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009863.47645 2110020.43216 37.7742704149776 -122.409325797764 (37.7742704149776, -122.409325797764) 8 2 9 28853 34
171171 253477 2 140 1222 Harrison St 3 Sidewalk: Curb side : Cutout Tree 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
176471 252908 2 36 600 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 2   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879) 8 4 7 28859 19