trees

Custom SQL query returning 57 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2280 116028 4 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
3804 117402 4 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
11284 117186 4 53 201x GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree 2       6x6   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
12765 117400 4 53 75x BEACH ST 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
13581 113413 4 53 16X LEROY PL 1 Sidewalk: Curb side : Cutout Tree 2     7 1x1   6008359 2116497 37.7919691052865 -122.414988572568 (37.7919691052865, -122.414988572568) 5 1 10 28858 21
20131 113298 4 53 700X DAVIS ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
20147 103506 4 53 1348 Sacramento St 2 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
28305 121625 4 53 101x Trenton St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
28626 100399 4 53 900 Montgomery St 2 Sidewalk: Curb side : Cutout Tree 2   05/17/2016 12:00:00 AM 3 4x4   6011664 2118384 37.7973355180624 -122.403686018548 (37.7973355180624, -122.403686018548) 3 1 10 308 23
28662 99265 4 53 1340 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree 2           6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
35016 120999 4 53 390 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
41004 99266 4 53 1340 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
43430 112751 4 53 135X TRENTON ST 5 Sidewalk: Curb side : Cutout Tree 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
46032 121039 4 53 2101 Polk St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006363 2118098 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697) 13 9 10 28858 32
46917 122714 4 53 855x Kearny St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
47816 107839 4 53 1000x LEAVENWORTH ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
52074 117185 4 53 201x GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
56447 117399 4 53 75x BEACH ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
58111 258045 4 53 1250 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
59611 106127 4 53 1609 POWELL ST 2 Sidewalk: Curb side : Cutout Tree 2       5x5   6009609.6 2119208.8 37.7994852403002 -122.410853080764 (37.7994852403002, -122.410853080764) 3 1 10 308 4
68154 113299 4 53 700X DAVIS ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
72817 121043 4 53 2125 Polk St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006363 2118096 37.7962471953974 -122.422008397548 (37.7962471953974, -122.422008397548) 13 9 10 28858 32
73387 113573 4 53 901 LOMBARD ST 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6007813 2120272 37.8023036186348 -122.417145352251 (37.8023036186348, -122.417145352251) 5 1 10 308 32
74524 95408 4 53 1257 Union St 1 Sidewalk: Curb side : Cutout Tree 2     10 3x3 No record of tree being permitted for planting. 6006989.2 2119073.6 37.7989667366731 -122.419911018667 (37.7989667366731, -122.419911018667) 5 1 10 28858 32
78831 99639 4 53 2201 Polk St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006359 2118331 37.7968922206311 -122.422038941111 (37.7968922206311, -122.422038941111) 13 9 10 28858 32
80346 122712 4 53 855x Kearny St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
82064 117188 4 53 200x GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree 2       9x6   6011596 2120619 37.8034684863456 -122.404078688914 (37.8034684863456, -122.404078688914) 3 1 10 28860 6
83480 120997 4 53 360 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2       4x6   6010836 2115566 37.7895516808253 -122.406352466288 (37.7895516808253, -122.406352466288) 5 1 10 28857 6
84659 117187 4 53 200x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree 2       9x6   6011596 2120619 37.8034684863456 -122.404078688914 (37.8034684863456, -122.404078688914) 3 1 10 28860 6
95573 106226 4 53 350 Sutter St 1 Sidewalk: Curb side : Cutout Tree 3     22 3x5   6010879 2115572 37.7895705607022 -122.406204113006 (37.7895705607022, -122.406204113006) 5 1 10 28857 6
99464 112750 4 53 135X TRENTON ST 4 Sidewalk: Curb side : Cutout Tree 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
99484 116156 4 53 755 SANSOME ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6012110 2118369 37.7973192357085 -122.402141679915 (37.7973192357085, -122.402141679915) 3 1 10 308 4
101743 98254 4 53 571 Broadway 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6010764.4 2118536 37.797702579203 -122.406809598565 (37.797702579203, -122.406809598565) 3 1 10 308 4
102458 99269 4 53 1327 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008010 2116967 37.7932399920042 -122.416229420814 (37.7932399920042, -122.416229420814) 5 1 10 28858 32
105476 120996 4 53 352 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree 3       3x5   6010871.2 2115571.1 37.789567653219 -122.406231036885 (37.789567653219, -122.406231036885) 5 1 10 28857 6
117475 97938 4 53 2133 Stockton St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6009831.3 2121360.2 37.8054048804892 -122.410237896013 (37.8054048804892, -122.410237896013) 3 1 10 308 23
131827 99267 4 53 1340 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
143675 107836 4 53 1000x LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
143936 106224 4 53 340 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree 3     24 3x5   6010923.2 2115578.3 37.7895903312377 -122.406051628897 (37.7895903312377, -122.406051628897) 5 1 10 28857 6
150358 258047 4 53 1250 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
150414 117403 4 53 75x BEACH ST 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
153320 99638 4 53 2201 Polk St 1 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6006359 2118331 37.7968922206311 -122.422038941111 (37.7968922206311, -122.422038941111) 13 9 10 28858 32
154699 121624 4 53 101x Trenton St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
158673 117398 4 53 75x BEACH ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
159297 106225 4 53 340 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree 3     22 3x5   6010923.2 2115578.3 37.7895903312377 -122.406051628897 (37.7895903312377, -122.406051628897) 5 1 10 28857 6
159895 113553 4 53 700 TAYLOR ST 3 Sidewalk: Curb side : Cutout Tree 2   11/24/2015 12:00:00 AM   3x3   6009263 2115423 37.7890709188275 -122.411784791395 (37.7890709188275, -122.411784791395) 5 1 10 28857 21
168220 258046 4 53 1250 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
170611 104729 4 53 250-252 FRANCISCO ST   Sidewalk: Curb side : Cutout Tree 2     22 5x5   6010061.3 2121325.4 37.805322217951 -122.409439489572 (37.805322217951, -122.409439489572) 3 1 10 308 23
176501 104744 4 53 15 WAVERLY PL   Sidewalk: Curb side : Cutout Tree 2     12 3x3   6010745.5 2116998.1 37.7934788206973 -122.406766557506 (37.7934788206973, -122.406766557506) 3 1 10 28857 4
177916 113574 4 53 901 LOMBARD ST 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6007968 2120121 37.8018977290678 -122.416598272247 (37.8018977290678, -122.416598272247) 5 1 10 308 32
178040 120998 4 53 370 Sutter St 1 Sidewalk: Curb side : Cutout Tree 2       4x6   6010792 2115565 37.789546473623 -122.406504631878 (37.789546473623, -122.406504631878) 5 1 10 28857 6
182781 117184 4 53 201x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
185775 117401 4 53 75x BEACH ST 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
186252 116029 4 53 1500 PACIFIC AVE 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
186331 122713 4 53 855x Kearny St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
188867 121000 4 53 390 Sutter St 2 Sidewalk: Curb side : Cutout Tree 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
191099 100527 4 53 1728 Jones St 1 Sidewalk: Curb side : Cutout Tree 2       4.5x6   6008341 2118363 37.7970916696404 -122.415182998934 (37.7970916696404, -122.415182998934) 5 1 10 308 21