trees

Custom SQL query returning 24 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
12651 261028 4 6 743 20th Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/18/2019 12:00:00 AM 3 3x3   5989712 2110287 37.7738527032106 -122.479052157213 (37.7738527032106, -122.479052157213) 11 6 2 55 26
16338 261024 4 6 751 20th Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/18/2019 12:00:00 AM   3x3   5989703 2110237 37.773714894321 -122.479079631213 (37.773714894321, -122.479079631213) 11 6 2 55 26
618 238270 4 6 4102 19th St 2 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6002298.332 2104734.40291 37.7593295173753 -122.435116825204 (37.7593295173753, -122.435116825204) 2 4 5 28862 3
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
8363 238269 4 6 4102 19th St 1 Sidewalk: Curb side : Cutout Tree 2     8 3x3   6002324.68279 2104735.52248 37.7593340877084 -122.435025771543 (37.7593340877084, -122.435025771543) 2 4 5 28862 3
9840 256599 4 6 2x Stillman St 26 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
20319 106193 4 6 3040 TARAVAL ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5983698.2 2098878.7 37.742177638004 -122.499011481047 (37.742177638004, -122.499011481047) 1 8 3 29491 35
29256 256605 4 6 2x Stillman St 32 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
32904 256600 4 6 2x Stillman St 27 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
51877 256607 4 6 2x Stillman St 34 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
54999 101252 4 6 1290X 11th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5992716.9 2106688.9 37.7641473244126 -122.468395985577 (37.7641473244126, -122.468395985577) 11 8 11 56 12
61590 256576 4 6 2x Stillman St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
64471 207005 4 6 171 Wawona St 1 Sidewalk: Curb side : Cutout Tree 2   08/06/2014 12:00:00 AM 1 Width 3ft Permit Number 773294 5992787.45104 2098017.32873 37.7403415032629 -122.467521326669 (37.7403415032629, -122.467521326669) 1 8 4 59 40
70541 256574 4 6 2x Stillman St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
79736 251742 4 6 300 Naylor St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6002771 2086560 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389) 9 7 6 28861 5
92562 256604 4 6 2x Stillman St 31 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
104768 207004 4 6 171 Wawona St 2 Sidewalk: Curb side : Cutout Tree 2   08/06/2014 12:00:00 AM 1 Width 3ft Permit Number 773294 5992803.19794 2098037.09896 37.7403966964551 -122.46746831791 (37.7403966964551, -122.46746831791) 1 8 4 59 40
111372 105757 4 6 1278 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree 2   03/03/2014 12:00:00 AM 10 3x3 Permit Number 771070 5999104.9 2105310.4 37.7607292094813 -122.446202658218 (37.7607292094813, -122.446202658218) 15 5 5 28862 3
113377 115939 4 6 607 34TH AVE 1 Sidewalk: Curb side : Cutout Tree 2   03/07/2016 12:00:00 AM 3 3x3 Permit Number 777685 5985316 2111712 37.7775090776113 -122.494363475489 (37.7775090776113, -122.494363475489) 11 6 2 55 26
134706 256601 4 6 2x Stillman St 28 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
148332 113418 4 6 598X BENTON AVE 1 Sidewalk: Curb side : Cutout Tree 2     1 3x3   6007207 2095355 37.7338532991757 -122.417475487879 (37.7338532991757, -122.417475487879) 2 7 7 28859 2
160238 256575 4 6 2x Stillman St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
177211 102935 4 6 801X Church St 5 Sidewalk: Curb side : Cutout Tree 2     4 3x3   6004394.3 2104124.7 37.7577742117678 -122.427824502367 (37.7577742117678, -122.427824502367) 2 4 5 28862 3
183981 256606 4 6 2x Stillman St 33 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6