trees

Custom SQL query returning 17 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
43 264724 1 26 2901 Broadway 1 Front Yard : Yard Tree 2       3x3   5999656 2116990 37.7928298614365 -122.445136362104 (37.7928298614365, -122.445136362104) 13 6 1 29490 27
6745 74583 1 26 151X Palm Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 01/31/2018 12:00:00 AM 3 3x3   5995884.6031 2113341.96396 37.7825973527613 -122.457921374418 (37.7825973527613, -122.457921374418) 11 6 1 54 31
11183 74883 1 26 151X Palm Ave 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 01/31/2018 12:00:00 AM 3 3x3   5995886.83117 2113252.75826 37.7823525456975 -122.457907208857 (37.7823525456975, -122.457907208857) 11 6 1 54 31
11450 93122 1 26 151X Palm Ave 14 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 01/31/2018 12:00:00 AM 3 3x3   5995895.24901 2113041.91566 37.7817741116959 -122.457862824896 (37.7817741116959, -122.457862824896) 11 6 1 54 31
13799 262114 4 26 36 Perego Ter 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5999463 2101439 37.7501197399185 -122.44468588524 (37.7501197399185, -122.44468588524) 2 5 5 63 38
14965 262113 4 26 32 Perego Ter 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5999450 2101420 37.7500668286854 -122.444729474312 (37.7500668286854, -122.444729474312) 2 5 5 63 38
28167 256679 2 26 330 Twin Peaks Blvd 5 Sidewalk: Curb side : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
31410 23029 7 26 3 Valencia St 1 Sidewalk: Curb side : Cutout Tree 2   01/08/1998 12:00:00 AM 20 3X3   6006356.28069 2104163.0328 37.7579902585112 -122.42104187029 (37.7579902585112, -122.42104187029) 2 4 7 28859 19
45261 24827 7 26 200X Alemany Blvd 5 Sidewalk: Curb side : Cutout Tree 7   01/29/1998 12:00:00 AM 20 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
45324 24198 1 26 55X Whitney Young Cir 14 Sidewalk: Curb side : Cutout Tree 1   03/29/1990 12:00:00 AM 12 3x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
48101 24845 7 26 200X Alemany Blvd 23 Sidewalk: Curb side : Cutout Tree 7   01/29/1998 12:00:00 AM 25 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
75947 256676 2 26 330 Twin Peaks Blvd 1 Sidewalk: Curb side : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
123272 256677 2 26 330 Twin Peaks Blvd 2 Sidewalk: Curb side : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
161826 256678 2 26 330 Twin Peaks Blvd 4 Sidewalk: Curb side : Cutout Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
174486 27699 7 26 2480 Sacramento St 1 Sidewalk: Curb side : Cutout Tree 2   11/26/2002 12:00:00 AM 9 3X3   6002931.52986 2115871.3895 37.789944858134 -122.43372290238 (37.789944858134, -122.43372290238) 13 9 1 29490 27
182251 24196 1 26 55X Whitney Young Cir 12 Sidewalk: Curb side : Cutout Tree 1   02/04/1998 12:00:00 AM 6 3x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
191327 17226 1 26 1884X Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree 1     15 3X3   6001017.03183 2091170.89799 37.7220144825363 -122.438576333542 (37.7220144825363, -122.438576333542) 9 7 6 28861 25