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)
25067 91795 7 148 500x Harrison St 1 Sidewalk: Curb side : Cutout Tree 2   03/07/2007 12:00:00 AM 3 3x3 Permit Number 775014 6014662.1325 2114223.547757 37.7860789052247 -122.39302038306 (37.7860789052247, -122.39302038306) 6 2 9 28855 6
27805 49020 7 148 507 Howard St 1 Sidewalk: Curb side : Cutout Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013774.69039299 2115066.5155164 37.7883441634439 -122.396149816377 (37.7883441634439, -122.396149816377) 6 2 9 28855 6
40360 13581 1 148 525 Market St 3 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6012787.5365724 2115865.9219292 37.7904841708264 -122.399621379879 (37.7904841708264, -122.399621379879) 12 2 9 28855 6
42062 13492 1 148 215 Market St 2 Sidewalk: Curb side : Cutout Tree 1   10/28/2005 12:00:00 AM 6 4X4   6013729.1406446 2116782.463481 37.7930532214207 -122.396427736192 (37.7930532214207, -122.396427736192) 12 2 9 28855 6
74683 13505 1 148 245 Market St 7 Sidewalk: Curb side : Cutout Tree 1   10/28/2005 12:00:00 AM 6 4X4   6013642.6483486 2116679.2066582 37.7927648888925 -122.396719764541 (37.7927648888925, -122.396719764541) 12 2 9 28855 6
82698 13471 1 148 101 Market St 10 Sidewalk: Curb side : Cutout Tree 1   01/01/2005 12:00:00 AM 20 4X4   6013989.3283097 2117008.9290081 37.79368951828 -122.395543339024 (37.79368951828, -122.395543339024) 12 2 9 28855 6
88844 13503 1 148 245 Market St 5 Sidewalk: Curb side : Cutout Tree 1   10/28/2005 12:00:00 AM 6 4X4   6013642.6483486 2116679.2066582 37.7927648888925 -122.396719764541 (37.7927648888925, -122.396719764541) 12 2 9 28855 6
91931 13591 1 148 525 Market St 13 Sidewalk: Curb side : Cutout Tree 1   02/15/2004 12:00:00 AM 8 4X4   6012787.5365724 2115865.9219292 37.7904841708264 -122.399621379879 (37.7904841708264, -122.399621379879) 12 2 9 28855 6
112989 13466 1 148 101 Market St 5 Sidewalk: Curb side : Cutout Tree 1   01/01/2005 12:00:00 AM 20 4X4   6013989.3283097 2117008.9290081 37.79368951828 -122.395543339024 (37.79368951828, -122.395543339024) 12 2 9 28855 6
120614 13586 1 148 525 Market St 8 Sidewalk: Curb side : Cutout Tree 1   03/19/2004 12:00:00 AM 20 4X4   6012787.5365724 2115865.9219292 37.7904841708264 -122.399621379879 (37.7904841708264, -122.399621379879) 12 2 9 28855 6
120690 13657 1 148 619 Market St 1 Sidewalk: Curb side : Cutout Tree 1     30 4X4   6012007.3883744 2115123.3531128 37.7884017343709 -122.402268428095 (37.7884017343709, -122.402268428095) 12 2 9 28855 6
127010 13469 1 148 101 Market St 8 Sidewalk: Curb side : Cutout Tree 1   01/01/2005 12:00:00 AM 20 4X4   6013989.3283097 2117008.9290081 37.79368951828 -122.395543339024 (37.79368951828, -122.395543339024) 12 2 9 28855 6
130584 49022 7 148 507 Howard St 3 Sidewalk: Curb side : Cutout Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013774.69039299 2115066.5155164 37.7883441634439 -122.396149816377 (37.7883441634439, -122.396149816377) 6 2 9 28855 6
145061 49021 7 148 507 Howard St 2 Sidewalk: Curb side : Cutout Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013774.69039299 2115066.5155164 37.7883441634439 -122.396149816377 (37.7883441634439, -122.396149816377) 6 2 9 28855 6
146745 49019 7 148 507 Howard St 4 Sidewalk: Curb side : Cutout Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013774.69039299 2115066.5155164 37.7883441634439 -122.396149816377 (37.7883441634439, -122.396149816377) 6 2 9 28855 6
156677 91796 1 148 500x Harrison St 2 Sidewalk: Curb side : Cutout Tree 1   03/07/2007 12:00:00 AM 3 3x3 Permit Number 775014 6014662.1325 2114223.547757 37.7860789052247 -122.39302038306 (37.7860789052247, -122.39302038306) 6 2 9 28855 6
165577 100715 7 148 507 Howard St 5 Sidewalk: Curb side : Cutout Tree 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013735 2115044 37.7882801326001 -122.396285560985 (37.7882801326001, -122.396285560985) 6 2 9 28855 6
166367 13463 1 148 101 Market St 2 Sidewalk: Curb side : Cutout Tree 1   01/01/2005 12:00:00 AM 20 4X4   6013989.3283097 2117008.9290081 37.79368951828 -122.395543339024 (37.79368951828, -122.395543339024) 12 2 9 28855 6
176159 13468 1 148 101 Market St 7 Sidewalk: Curb side : Cutout Tree 1   01/01/2005 12:00:00 AM 20 4X4   6013989.3283097 2117008.9290081 37.79368951828 -122.395543339024 (37.79368951828, -122.395543339024) 12 2 9 28855 6
190865 13588 1 148 525 Market St 10 Sidewalk: Curb side : Cutout Tree 1     30 4X4   6012787.5365724 2115865.9219292 37.7904841708264 -122.399621379879 (37.7904841708264, -122.399621379879) 12 2 9 28855 6
191456 13493 1 148 215 Market St 4 Sidewalk: Curb side : Cutout Tree 1   10/28/2005 12:00:00 AM 6 4X4   6013729.1406446 2116782.463481 37.7930532214207 -122.396427736192 (37.7930532214207, -122.396427736192) 12 2 9 28855 6