trees

Custom SQL query returning 59 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
371 251215 1 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree 1       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
3630 258965 1 53 398x Bryant St 5 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
5064 258966 1 53 398x Bryant St 6 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
6270 258961 1 53 398x Bryant St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
9626 258963 1 53 398x Bryant St 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
9664 258964 1 53 398x Bryant St 4 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
10154 258967 1 53 398x Bryant St 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
11514 258968 1 53 398x Bryant St 8 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
16987 17305 1 53 51X Otis St 2 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
17682 258962 1 53 398x Bryant St 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
18544 258969 1 53 398x Bryant St 9 Sidewalk: Curb side : Cutout Tree 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
20552 15171 1 53 941 Mission St 2 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6010472.08374 2112774.72891 37.7818671496492 -122.407414720255 (37.7818671496492, -122.407414720255) 14 2 9 28853 34
27252 17296 1 53 5X Otis St 7 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6007104.29527 2109558.64203 37.7728474744005 -122.418837572 (37.7728474744005, -122.418837572) 8 2 9 28853 19
28163 10573 1 53 1000X Harrison St 2 Sidewalk: Curb side : Cutout Tree 1     65 4x4   6011301.87316 2111047.97507 37.7771722946398 -122.404422436991 (37.7771722946398, -122.404422436991) 14 2 9 28853 34
32017 116771 1 53 590X NATOMA ST 1 Sidewalk: Curb side : Cutout Tree 1     20 3x3   6009883 2111689 37.7788530052944 -122.409376039999 (37.7788530052944, -122.409376039999) 14 2 9 28853 34
34758 15261 1 53 1500 Mission St 5 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6007445.07805 2110006.65891 37.7740968045009 -122.417690522857 (37.7740968045009, -122.417690522857) 8 2 9 28853 19
40269 25702 1 53 550 06th St 4 Sidewalk: Curb side : Cutout Tree 1     20 3X3   6012081.78675 2110335.7627 37.7752602760543 -122.401674380603 (37.7752602760543, -122.401674380603) 14 2 9 28853 34
40345 17320 1 53 99X Otis St 1 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
41708 251371 1 53 390 06th St 3 Sidewalk: Curb side : Cutout Tree 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
42234 25701 1 53 550 06th St 3 Sidewalk: Curb side : Cutout Tree 1     20 3X3   6012066.85402 2110350.08491 37.7752987682674 -122.40172704355 (37.7752987682674, -122.40172704355) 14 2 9 28853 34
43589 15250 1 53 1450X Mission St 2 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6007716.15968 2110227.06056 37.7747172257492 -122.416768419302 (37.7747172257492, -122.416768419302) 8 2 9 28853 34
51241 15259 1 53 1500 Mission St 3 Sidewalk: Curb side : Cutout Tree 1     24 3x3   6007494.54134 2110025.11497 37.7741502637452 -122.417520728591 (37.7741502637452, -122.417520728591) 8 2 9 28853 19
51739 19375 1 53 390X 06th St 6 Sidewalk: Curb side : Cutout Tree 1     35 3X3   6011348.29286 2111104.97037 37.7773313845055 -122.404265868127 (37.7773313845055, -122.404265868127) 14 2 9 28853 34
51840 15324 1 53 1698X Mission St 2 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6006725.5802 2108585.93757 37.7701553284346 -122.420078550817 (37.7701553284346, -122.420078550817) 8 4 9 28853 19
54802 17309 1 53 70 Otis St 2 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
55801 15251 1 53 1450X Mission St 3 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6007694.41094 2110207.30516 37.7746617588291 -122.416842252889 (37.7746617588291, -122.416842252889) 8 2 9 28853 34
64749 17324 1 53 99X Otis St 5 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
66600 17310 1 53 70 Otis St 3 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
72154 17321 1 53 99X Otis St 2 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
72411 15256 1 53 1500 Mission St 7 Sidewalk: Curb side : Cutout Tree 1     24 3X3   6007417.64852 2109947.83449 37.7739337430824 -122.417781236147 (37.7739337430824, -122.417781236147) 8 2 9 28853 19
91800 19370 1 53 390X 06TH ST 1 Sidewalk: Curb side : Cutout Tree 1     30 4X4   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
97139 15172 1 53 941 Mission St 3 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6010497.86985 2112769.44604 37.7818540873698 -122.40732513932 (37.7818540873698, -122.40732513932) 14 2 9 28853 34
108637 27712 1 53 175X Otis St 12 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
109251 17295 1 53 5X Otis St 6 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6007087.86369 2109540.24307 37.7727960300261 -122.418893105705 (37.7727960300261, -122.418893105705) 8 2 9 28853 19
109824 17315 1 53 86 OTIS ST 3 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
113415 17294 1 53 5X Otis St 5 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6007138.45925 2109591.54151 37.7729397321212 -122.418721728138 (37.7729397321212, -122.418721728138) 8 2 9 28853 19
122653 17306 1 53 51X Otis St 3 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
131297 17307 1 53 51X Otis St 4 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6006961.49044 2109420.44821 37.772459985288 -122.419321746309 (37.772459985288, -122.419321746309) 8 2 9 28853 19
140527 15263 1 53 1500 Mission St 8 Sidewalk: Curb side : Cutout Tree 1   09/30/2008 12:00:00 AM 12 3x3 Permit Number 51766 6007587.5132074 2110099.4827033 37.7743596907053 -122.417204392502 (37.7743596907053, -122.417204392502) 8 2 9 28853 19
141769 15252 1 53 1450X Mission St 4 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6007671.66057 2110183.15551 37.7745941699553 -122.416919239811 (37.7745941699553, -122.416919239811) 8 2 9 28853 34
148523 15253 1 53 1450X Mission St 5 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6007637.14046 2110148.71 37.7744976489686 -122.417036210851 (37.7744976489686, -122.417036210851) 8 2 9 28853 34
148917 19373 1 53 390X 06th St 4 Sidewalk: Curb side : Cutout Tree 1     35 4X4   6011348.29286 2111104.97037 37.7773313845055 -122.404265868127 (37.7773313845055, -122.404265868127) 14 2 9 28853 34
155474 17322 1 53 99X Otis St 3 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
156641 15249 1 53 1450X Mission St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6007741.56076 2110251.13936 37.7747847690696 -122.416682257719 (37.7747847690696, -122.416682257719) 8 2 9 28853 34
157267 17313 1 53 86 OTIS ST 1 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
167163 17304 1 53 51X Otis St 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
173445 15262 1 53 1500 Mission St 6 Sidewalk: Curb side : Cutout Tree 1     24 3X3   6007448.14843 2109975.86864 37.774012434525 -122.417677719037 (37.774012434525, -122.417677719037) 8 2 9 28853 19
173835 17323 1 53 99X Otis St 4 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
175687 17314 1 53 86 OTIS ST 2 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
177980 27711 1 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
180877 10578 1 53 1005X HARRISON ST 4 Sidewalk: Curb side : Cutout Tree 1     16 3x7   6011386 2111037 37.7771468605476 -122.404130641378 (37.7771468605476, -122.404130641378) 14 2 9 28853 34
181935 17311 1 53 77 Otis St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6006769.4589066 2109244.8738273 37.7719670827617 -122.419973541884 (37.7719670827617, -122.419973541884) 8 2 9 28853 19
183025 26841 1 53 100 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 1     18 3X3 Permit Number 779930 6006975.88726 2110943.04151 37.7766414730488 -122.419379980819 (37.7766414730488, -122.419379980819) 7 9 9 28852 36
185238 15310 1 53 1650 Mission St 7 Sidewalk: Curb side : Cutout Tree 1     12 4X4   6006887.5781181 2109042.9003069 37.7714191656036 -122.41955062575 (37.7714191656036, -122.41955062575) 8 2 9 28853 19
186181 251369 1 53 390 06th St 1 Sidewalk: Curb side : Cutout Tree 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
187641 17308 1 53 70 Otis St 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
189650 15279 1 53 1551 MISSION ST 3 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6007345 2109715.7 37.7732922684508 -122.418016080506 (37.7732922684508, -122.418016080506) 8 2 9 28853 19
190135 15260 1 53 1500 Mission St 4 Sidewalk: Curb side : Cutout Tree 1     24 3X3   6007445.07805 2110006.65891 37.7740968045009 -122.417690522857 (37.7740968045009, -122.417690522857) 8 2 9 28853 19
190383 17316 1 53 86 OTIS ST 4 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19