trees

Custom SQL query returning 38 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
34099 105230 7 201 69 KEYSTONE WAY 1 Front Yard : Yard Tree 2   06/17/2014 12:00:00 AM 30   Permit Number 773353 5994093.4 2093229.9 37.7272717167315 -122.462658710338 (37.7272717167315, -122.462658710338) 9 8 4 59 40
191669 4260 7 201 4094X Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree 2     6 3X3   6003303.5082097 2100409.5413687 37.7475114969278 -122.431331714787 (37.7475114969278, -122.431331714787) 2 4 5 63 22
56835 4258 7 201 4094X Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree 2     6 3X3   6003364.7569552 2100412.8299453 37.7475239975457 -122.431120155296 (37.7475239975457, -122.431120155296) 2 4 5 63 22
75400 4259 7 201 4094X Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree 2     10 3X3   6003364.7569552 2100412.8299453 37.7475239975457 -122.431120155296 (37.7475239975457, -122.431120155296) 2 4 5 63 22
58269 122812 7 201 889 York St 2 Sidewalk: Curb side : Cutout Tree 2 FUF         6009956.83094511 2104043.07852524 37.7578631996098 -122.40858112242 (37.7578631996098, -122.40858112242) 2 4 7 28859 19
163371 66635 7 201 889 York St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/18/1998 12:00:00 AM     Permit Number 29846 6009956.83094511 2104043.07852524 37.7578631996098 -122.40858112242 (37.7578631996098, -122.40858112242) 2 4 7 28859 19
176336 86911 7 201 2256 Bryant St 1 Sidewalk: Curb side : Cutout Tree 2   11/06/2007 12:00:00 AM 4 3x3 Permit Number 49876 6009641 2104201 37.7582791230904 -122.409684549013 (37.7582791230904, -122.409684549013) 2 4 7 28859 19
80990 107306 7 201 191 CASELLI AVE 2 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6000068 2104828 37.7594596127231 -122.442837096046 (37.7594596127231, -122.442837096046) 2 4 5 28862 3
46643 39172 7 201 736 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/19/1998 12:00:00 AM 8   Permit Number 40834 6007488.6062833 2105367.57823812 37.761361427438 -122.417211152399 (37.761361427438, -122.417211152399) 2 4 7 28859 19
161672 99651 7 201 1300 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/22/2003 12:00:00 AM   3x3   5991764 2106610 37.7638756002396 -122.471686009646 (37.7638756002396, -122.471686009646) 11 8 11 56 12
53502 101169 7 201 1301X 05th Ave 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 33324 5994554 2106650 37.7641464551633 -122.462039213312 (37.7641464551633, -122.462039213312) 1 5 11 56 12
174023 101168 7 201 401 Irving St 3 Sidewalk: Curb side : Cutout Tree 2         Permit Number 33324 5994554 2106650 37.7641464551633 -122.462039213312 (37.7641464551633, -122.462039213312) 1 5 11 56 12
175470 101167 7 201 401 Irving St 2 Sidewalk: Curb side : Cutout Tree 2         Permit Number 33324 5994554 2106650 37.7641464551633 -122.462039213312 (37.7641464551633, -122.462039213312) 1 5 11 56 12
145570 69257 7 201 401 Irving St 1 Sidewalk: Curb side : Cutout Tree 2   03/07/1994 12:00:00 AM     Permit Number 33324 5994548.69419505 2106652.17355678 37.7641521177083 -122.462057722056 (37.7641521177083, -122.462057722056) 1 5 11 56 12
169366 54897 7 201 203 Carl St 1 Sidewalk: Curb side : Cutout Tree 2   08/17/1972 12:00:00 AM   3x3 Permit Number 10763 5997226.12135807 2107036.80892371 37.765362015501 -122.452825087824 (37.765362015501, -122.452825087824) 15 5 11 29492 12
106986 100896 7 201 1800 Folsom St 5 Sidewalk: Curb side : Cutout Tree 2     20 3x3 Permit Number 30965 6007972 2107962 37.7685122898352 -122.415722998498 (37.7685122898352, -122.415722998498) 8 4 7 28853 19
179643 100895 7 201 1800 Folsom St 4 Sidewalk: Curb side : Cutout Tree 2     20 3x3 Permit Number 30965 6007972 2107962 37.7685122898352 -122.415722998498 (37.7685122898352, -122.415722998498) 8 4 7 28853 19
29785 88720 7 201 301 WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree 2   08/07/2008 12:00:00 AM   3x3 Permit Number 774804 6004157.3 2109772.9 37.773269399945 -122.429046849446 (37.773269399945, -122.429046849446) 7 9 11 29492 10
91987 58133 7 201 311 Lyon St 1 Sidewalk: Curb side : Cutout Tree 2   07/05/2016 12:00:00 AM 3   Permit Number 17115 6000220.45021465 2109949.44722515 37.7735305196789 -122.442677584536 (37.7735305196789, -122.442677584536) 15 5 11 29492 16
194128 21848 7 201 224 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree 2   10/25/1993 12:00:00 AM 5 3X3   5994910.90461 2110804.06513 37.775572970261 -122.461105914285 (37.775572970261, -122.461105914285) 11 6 2 54 11
82303 57313 7 201 1504 Lyon St 1 Sidewalk: Curb side : Cutout Tree 2   08/31/1976 12:00:00 AM   3x3 Permit Number 16136 5999704.4841929 2114025.1830868 37.784692017358 -122.444755399201 (37.784692017358, -122.444755399201) 15 6 1 29490 31
66425 12435 7 201 1595X Laguna St 1 Sidewalk: Curb side : Cutout Tree 2     3 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765) 13 9 11 29490 13
103348 12437 7 201 1595X Laguna St 3 Sidewalk: Curb side : Cutout Tree 2     6 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765) 13 9 11 29490 13
108252 12436 7 201 1595X Laguna St 2 Sidewalk: Curb side : Cutout Tree 2     6 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765) 13 9 11 29490 13
11297 12432 7 201 1755 Laguna St 2 Sidewalk: Curb side : Cutout Tree 2     6 4X4   6004422.6934 2114848.24389 37.7872200575435 -122.428490648397 (37.7872200575435, -122.428490648397) 13 9 11 29490 27
28792 12433 7 201 1755 Laguna St 3 Sidewalk: Curb side : Cutout Tree 2     6 4X4   6004422.6934 2114848.24389 37.7872200575435 -122.428490648397 (37.7872200575435, -122.428490648397) 13 9 11 29490 27
136130 12431 7 201 1755 Laguna St 1 Sidewalk: Curb side : Cutout Tree 2     6 4X4   6004422.6934 2114848.24389 37.7872200575435 -122.428490648397 (37.7872200575435, -122.428490648397) 13 9 11 29490 27
192508 12434 7 201 1755 Laguna St 4 Sidewalk: Curb side : Cutout Tree 2     6 4X4   6004422.6934 2114848.24389 37.7872200575435 -122.428490648397 (37.7872200575435, -122.428490648397) 13 9 11 29490 27
46728 2641 7 201 1765X Laguna St 1 Sidewalk: Curb side : Cutout Tree 2     6 4X4   6004408.21795 2114879.70403 37.7873056200256 -122.428542973686 (37.7873056200256, -122.428542973686) 13 9 11 29490 27
75110 2642 7 201 1765X Laguna St 2 Sidewalk: Curb side : Cutout Tree 2     6 4x4   6004408.21795 2114879.70403 37.7873056200256 -122.428542973686 (37.7873056200256, -122.428542973686) 13 9 11 29490 27
44098 2649 7 201 1945 Bush St 2 Sidewalk: Curb side : Cutout Tree 2     6 4X4   6004183.14856 2114926.81574 37.7874222375245 -122.429325027076 (37.7874222375245, -122.429325027076) 13 9 11 29490 27
87715 2648 7 201 1945 Bush St 1 Sidewalk: Curb side : Cutout Tree 2     6 4X4   6004183.14856 2114926.81574 37.7874222375245 -122.429325027076 (37.7874222375245, -122.429325027076) 13 9 11 29490 27
168126 102450 7 201 2205 Pacific Ave 3 Sidewalk: Property side : Cutout Tree 2   02/28/2014 12:00:00 AM     Permit Number 772662 6003508.7 2117188.3 37.7935934914571 -122.431820013768 (37.7935934914571, -122.431820013768) 13 9 1 29490 27
37670 106946 7 201 2710 BAKER ST   Sidewalk: Curb side : Cutout Tree 2   07/02/2014 12:00:00 AM 1 3x3   5999632.3 2118174.9 37.7960819303033 -122.44530359746 (37.7960819303033, -122.44530359746) 13 9 1 57 17
114486 84965 7 201 2503 Union St 1 Sidewalk: Curb side : Cutout Tree 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52401 6001033 2118263 37.7964036854154 -122.440463231838 (37.7964036854154, -122.440463231838) 13 9 1 57 17
108197 53283 7 201 2606 Franklin St 1 Sidewalk: Curb side : Cutout Tree 2   07/20/2007 12:00:00 AM     Permit Number 49537 6005355.41207376 2118914.02943872 37.7984364178674 -122.42555310995 (37.7984364178674, -122.42555310995) 13 9 1 57 17
58602 85259 7 201 2239 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2   07/24/2007 12:00:00 AM     Permit Number 49558 6007574 2120083 37.8017712241665 -122.417959005089 (37.8017712241665, -122.417959005089) 5 1 1 28858 32
44201 58123 7 201 800 Lombard St 1 Sidewalk: Curb side : Cutout Tree 2   02/06/1978 12:00:00 AM     Permit Number 17105 6008509.24459419 2120396.75874665 37.802685318336 -122.414744832906 (37.802685318336, -122.414744832906) 5 1 10 308 32