trees

Custom SQL query returning 53 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
992 192119 7 38 807 Mission St 1 Sidewalk: Curb side : Cutout Tree 7     22 Width 4ft   6010836.94593 2113119.25584 37.782833554469 -122.406176740686 (37.782833554469, -122.406176740686) 12 2 9 28853 34
4189 192124 7 38 807 Mission St 6 Sidewalk: Curb side : Cutout Tree 7     25 Width 4ft   6011038.85416 2113311.43716 37.783372530757 -122.405491758548 (37.783372530757, -122.405491758548) 12 2 9 28853 34
8181 192121 7 38 807 Mission St 3 Sidewalk: Curb side : Cutout Tree 7     27 Width 4ft   6010922.27002 2113199.63335 37.783059024392 -122.405887217429 (37.783059024392, -122.405887217429) 12 2 9 28853 34
8874 15149 7 53 895X Mission St 3 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
10886 192122 7 38 807 Mission St 4 Sidewalk: Curb side : Cutout Tree 7     23 Width 4ft   6010961.41826 2113239.46389 37.7831705790105 -122.405754586311 (37.7831705790105, -122.405754586311) 12 2 9 28853 34
12465 192125 7 38 807 Mission St 7 Sidewalk: Curb side : Cutout Tree 7     23 Width 4ft   6011096.71819 2113372.25093 37.7835427463303 -122.405295854729 (37.7835427463303, -122.405295854729) 12 2 9 28853 34
15602 192120 7 38 807 Mission St 2 Sidewalk: Curb side : Cutout Tree 7     17 Width 4ft   6010853.09093 2113135.89795 37.7828801528353 -122.406122058309 (37.7828801528353, -122.406122058309) 12 2 9 28853 34
16235 112148 4 12 101X 05TH ST 2 Sidewalk: Curb side : Cutout Tree 7     10 3x3   6010794 2113100 37.782778280213 -122.406323959165 (37.782778280213, -122.406323959165) 12 2 9 28853 34
19070 15154 7 53 895X Mission St 8 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
27832 15155 7 53 895X Mission St 9 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
31550 15160 7 53 895X Mission St 14 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
33650 251244 1 27 99 Grove St 5 Sidewalk: Curb side : Cutout Tree 7   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.7784411543423 -122.418166265193 (37.7784411543423, -122.418166265193) 7 9 9 28852 36
34792 15148 7 53 895X Mission St 2 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
38544 14628 7 27 460 McAllister St 1 Sidewalk: Curb side : Cutout Tree 7     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425) 7 9 9 28852 36
39622 15164 7 53 895X Mission St 18 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
40645 134568 1 27 99 Grove St 4 Sidewalk: Curb side : Cutout Tree 7   12/17/2009 12:00:00 AM 5 Width 4ft   6007669.37768 2111613.23365 37.7785206946058 -122.417028485685 (37.7785206946058, -122.417028485685) 7 9 9 28852 36
42209 112149 4 12 101X 05TH ST 3 Sidewalk: Curb side : Cutout Tree 7     10 3x3   6010794 2113100 37.782778280213 -122.406323959165 (37.782778280213, -122.406323959165) 12 2 9 28853 34
43608 112287 1 11 50 Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree 7     5     6007006.5 2110627.3 37.7757762467653 -122.419251679167 (37.7757762467653, -122.419251679167) 7 9 9 28852 36
45235 15147 7 53 895X Mission St 1 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
46324 112150 4 12 101X 05TH ST 4 Sidewalk: Curb side : Cutout Tree 7     10 3x3   6010794 2113100 37.782778280213 -122.406323959165 (37.782778280213, -122.406323959165) 12 2 9 28853 34
55672 23150 7 11 50 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 7     3 3X3   6007031.8302252 2110521.0652082 37.7754859780082 -122.419156518057 (37.7754859780082, -122.419156518057) 7 9 9 28852 36
56609 9951 7 27 95X Grove St 2 Sidewalk: Curb side : Cutout Tree 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
58538 15152 7 53 895X Mission St 6 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
65065 23151 7 11 50 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree 7   08/24/1993 12:00:00 AM 8 3X3   6007030.5326516 2110530.1061031 37.7755107290659 -122.419161648128 (37.7755107290659, -122.419161648128) 7 9 9 28852 36
67792 15158 7 53 895X Mission St 12 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
68900 15165 7 53 895X Mission St 19 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
90491 134567 1 27 99 Grove St 3 Sidewalk: Curb side : Cutout Tree 7   07/06/2011 12:00:00 AM 4 Width 4ft   6007561.6986 2111595.58464 37.7784661768053 -122.417399738421 (37.7784661768053, -122.417399738421) 7 9 9 28852 36
92451 15169 7 53 895X Mission St 23 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
94893 9952 7 27 95X Grove St 3 Sidewalk: Curb side : Cutout Tree 7   07/06/2011 12:00:00 AM 3 3x3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
102440 14627 7 27 410X McAllister St 2 Sidewalk: Curb side : Cutout Tree 7     35 3X3   6007165.24508 2112272.29684 37.7803019512551 -122.418819229453 (37.7803019512551, -122.418819229453) 7 9 9 28852 36
103078 15168 7 53 895X Mission St 22 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
110518 15161 7 53 895X Mission St 15 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
110566 14098 7 27 1480X Market St 1 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6007076.6773563 2110527.4337913 37.7755059900951 -122.419001832587 (37.7755059900951, -122.419001832587) 7 2 9 28852 36
112808 15167 7 53 895X Mission St 21 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
115831 15162 7 53 895X Mission St 16 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
121554 15163 7 53 895X Mission St 17 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
122483 14626 7 148 410X McAllister St 1 Sidewalk: Curb side : Cutout Tree 7   01/05/2001 12:00:00 AM 20 3X3   6007165.24508 2112272.29684 37.7803019512551 -122.418819229453 (37.7803019512551, -122.418819229453) 7 9 9 28852 36
125734 26896 7 27 460 McAllister St 2 Sidewalk: Curb side : Cutout Tree 7     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425) 7 9 9 28852 36
127129 23174 1 27 240 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 7     5 3x3   6006908.21847 2111432.04348 37.7779803432508 -122.419648771078 (37.7779803432508, -122.419648771078) 7 9 9 28852 36
128940 23156 7 11 50 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 7   08/24/1993 12:00:00 AM 18 3X3   6007006.484382 2110627.274272 37.7757761752428 -122.419251731369 (37.7757761752428, -122.419251731369) 7 9 9 28852 36
133044 9953 7 27 95X Grove St 4 Sidewalk: Curb side : Cutout Tree 7   12/17/2009 12:00:00 AM 12 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
142191 14103 7 27 1525 Market St 2 Sidewalk: Curb side : Cutout Tree 7     12 4X4   6006946.0284757 2110289.3486747 37.774844907593 -122.419436884969 (37.774844907593, -122.419436884969) 8 2 9 28853 19
143433 15157 7 53 895X Mission St 11 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
143636 15150 7 53 895X Mission St 4 Sidewalk: Curb side : Cutout Tree 7     18 3x3   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
146362 134566 1 27 99 Grove St 2 Sidewalk: Curb side : Cutout Tree 7     14 Width 4ft   6007493.55732 2111589.97349 37.7784469358085 -122.417635067622 (37.7784469358085, -122.417635067622) 7 9 9 28852 36
150707 28886 7 19 120X 04th St 1 Sidewalk: Curb side : Cutout Tree 7   02/11/2006 12:00:00 AM 3 3x3   6011510.8284999 2113558.299704 37.7840767362854 -122.403876281312 (37.7840767362854, -122.403876281312) 12 2 9 28853 34
155906 134565 1 27 99 Grove St 1 Sidewalk: Curb side : Cutout Tree 7     15 Width 4ft   6007431.26589 2111583.6583 37.7784260904314 -122.417850109903 (37.7784260904314, -122.417850109903) 7 9 9 28852 36
165205 9950 7 27 95X Grove St 1 Sidewalk: Curb side : Cutout Tree 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
166064 14099 7 27 1484 Market St 1 Sidewalk: Curb side : Cutout Tree 7     12 4X4   6007056.5524178 2110508.208095 37.7754520676647 -122.419070085744 (37.7754520676647, -122.419070085744) 7 2 9 28852 36
170682 14102 7 27 1525 Market St 1 Sidewalk: Curb side : Cutout Tree 7     12 4X4   6006946.0284757 2110289.3486747 37.774844907593 -122.419436884969 (37.774844907593, -122.419436884969) 8 2 9 28853 19
185169 15159 7 53 895X Mission St 13 Sidewalk: Curb side : Cutout Tree 7 Private   18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
188945 112147 4 12 101X 05TH ST 1 Sidewalk: Curb side : Cutout Tree 7     10 3x3   6010794 2113100 37.782778280213 -122.406323959165 (37.782778280213, -122.406323959165) 12 2 9 28853 34
190500 23152 7 11 50 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 7   10/03/2000 12:00:00 AM 12     6007026.70172 2110556.798269 37.7755838036152 -122.419176794071 (37.7755838036152, -122.419176794071) 7 9 9 28852 36