trees

Custom SQL query returning 40 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
74594 26720 1 162 1203X Webster St 7 Sidewalk: Curb side : Cutout Tree 1     20 3X3   6003742.20526 2112831.75991 37.7816447668943 -122.430701039692 (37.7816447668943, -122.430701039692) 15 9 11 29490 41
76359 26443 1 162 1430 Eddy St 1 Sidewalk: Curb side : Cutout Tree 1     6 2X2   6003606.97335 2112834.41067 37.7816443828524 -122.431169066991 (37.7816443828524, -122.431169066991) 15 9 11 29490 41
78486 94301 6 162 1150X Fillmore St 5 Sidewalk: Property side : Cutout Tree 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
79085 26721 1 162 1203X Webster St 8 Sidewalk: Curb side : Cutout Tree 1     25 3X3   6003742.20526 2112831.75991 37.7816447668943 -122.430701039692 (37.7816447668943, -122.430701039692) 15 9 11 29490 41
80702 103188 1 162 1125 Fillmore St 3 Sidewalk: Curb side : Cutout Tree 2     3 3x3   6003319.4 2112265.6 37.7800662706417 -122.432123301144 (37.7800662706417, -122.432123301144) 15 9 11 29490 41
89137 103239 7 162 1240 Fillmore St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6003317 2112564 37.7808854664086 -122.432152919664 (37.7808854664086, -122.432152919664) 15 9 11 29490 41
93396 26439 1 162 1410 Eddy St 1 Sidewalk: Curb side : Cutout Tree 1     6 2X2   6003703.23726 2112842.65121 37.7816724639119 -122.430836627926 (37.7816724639119, -122.430836627926) 15 9 11 29490 41
94027 26445 1 162 1442 Eddy St 1 Sidewalk: Curb side : Cutout Tree 2     6 2X2   6003549.33255 2112826.4539 37.7816192690049 -122.431367908549 (37.7816192690049, -122.431367908549) 15 9 11 29490 41
102520 94372 1 162 1633 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2     9 4x4   6003065.02645 2113947.68581 37.7846704302621 -122.433123511568 (37.7846704302621, -122.433123511568) 13 9 11 29490 13
109943 29075 1 162 1146 Turk St 1 Sidewalk: Curb side : Cutout Tree 1   12/15/2005 12:00:00 AM 3 3x3   6004514.09191 2112609.33919 37.7810777550034 -122.428014822778 (37.7810777550034, -122.428014822778) 7 9 11 29490 41
111460 22621 1 162 1100X Turk St 1 Sidewalk: Curb side : Cutout Tree 1   12/15/2005 12:00:00 AM 3 4x4   6004069.05987 2112481.21433 37.7807007681203 -122.429545270382 (37.7807007681203, -122.429545270382) 7 9 11 29490 41
111521 26440 1 162 1410 Eddy St 2 Sidewalk: Curb side : Cutout Tree 1     6 2X2   6003703.23726 2112842.65121 37.7816724639119 -122.430836627926 (37.7816724639119, -122.430836627926) 15 9 11 29490 41
120173 5950 1 162 1499X Eddy St 1 Sidewalk: Curb side : Cutout Tree 1   12/15/2005 12:00:00 AM 3 3X3   6003288.58523 2112739.98604 37.7813670689673 -122.432263792423 (37.7813670689673, -122.432263792423) 15 9 11 29490 41
120446 26444 1 162 1434 Eddy St 1 Sidewalk: Curb side : Cutout Tree 1     6 2X2   6003588.47201 2112826.80892 37.7816224618989 -122.431232530045 (37.7816224618989, -122.431232530045) 15 9 11 29490 41
120826 103181 1 162 1125 Fillmore St 2 Sidewalk: Curb side : Cutout Tree 2     4 3x3   6003319.4 2112265.6 37.7800662706417 -122.432123301144 (37.7800662706417, -122.432123301144) 15 9 11 29490 41
122963 12332 7 162 1105X Turk St 1 Sidewalk: Curb side : Cutout Tree 2   12/15/2005 12:00:00 AM 3 3X3   6004706.62549 2112590.71039 37.7810374956819 -122.427347425327 (37.7810374956819, -122.427347425327) 7 9 11 29490 41
125310 94299 6 162 1150X Fillmore St 4 Sidewalk: Property side : Cutout Tree 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
128969 103167 7 162 1201X Fillmore St 8 Sidewalk: Curb side : Cutout Tree 2       3x3   6003055.6 2112559.2 37.7808574628324 -122.43305688657 (37.7808574628324, -122.43305688657) 15 9 11 29490 41
129932 45608 1 162 1100X Fillmore St 1 Sidewalk: Curb side : Cutout Tree 1   08/06/2001 12:00:00 AM 2   Permit Number 44335 6003389.50485138 2112095.5826587 37.7796034198271 -122.431868633724 (37.7796034198271, -122.431868633724) 15 9 11 29490 41
132671 103165 7 162 1201X Fillmore St 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6003055.6 2112559.2 37.7808574628324 -122.43305688657 (37.7808574628324, -122.43305688657) 15 9 11 29490 41
133799 103242 1 162 1290 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6003293 2112734 37.7813508831163 -122.432248091846 (37.7813508831163, -122.432248091846) 15 9 11 29490 41
136721 103205 1 162 1113 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6003277.3 2112173.6 37.7798112746289 -122.432262371693 (37.7798112746289, -122.432262371693) 15 9 11 29490 41
138711 103164 7 162 1201X Fillmore St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6003055.6 2112559.2 37.7808574628324 -122.43305688657 (37.7808574628324, -122.43305688657) 15 9 11 29490 41
143287 103243 1 162 1290 Fillmore St 2 Sidewalk: Curb side : Cutout Tree 2     5 3x3   6003293 2112734 37.7813508831163 -122.432248091846 (37.7813508831163, -122.432248091846) 15 9 11 29490 41
146493 103241 7 162 1240 Fillmore St 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6003317 2112564 37.7808854664086 -122.432152919664 (37.7808854664086, -122.432152919664) 15 9 11 29490 41
150341 26715 1 162 1203X Webster St 2 Sidewalk: Curb side : Cutout Tree 1     15 3X3   6003742.20526 2112831.75991 37.7816447668943 -122.430701039692 (37.7816447668943, -122.430701039692) 15 9 11 29490 41
153059 26716 1 162 1203X Webster St 3 Sidewalk: Curb side : Cutout Tree 1     30 3X3   6003742.20526 2112831.75991 37.7816447668943 -122.430701039692 (37.7816447668943, -122.430701039692) 15 9 11 29490 41
153073 94297 6 162 1150X Fillmore St 3 Sidewalk: Property side : Cutout Tree 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
156305 22630 1 162 1170 Turk St 1 Sidewalk: Curb side : Cutout Tree 1   12/15/2005 12:00:00 AM 3 3X3   6004485.54362 2112758.65341 37.7814861196775 -122.428124229573 (37.7814861196775, -122.428124229573) 7 9 11 29490 41
158977 5952 1 162 1499X Eddy St 3 Sidewalk: Curb side : Cutout Tree 1   12/15/2005 12:00:00 AM 3 3X3   6003344.76358 2112747.58282 37.781391112972 -122.432069985491 (37.781391112972, -122.432069985491) 15 9 11 29490 41
159118 26441 1 162 1422 Eddy St 1 Sidewalk: Curb side : Cutout Tree 2     6 2X2   6003645.85463 2112834.73007 37.7816474630851 -122.43103457907 (37.7816474630851, -122.43103457907) 15 9 11 29490 41
159685 103244 1 162 1290 Fillmore St 3 Sidewalk: Curb side : Cutout Tree 2     4 3x3   6003293 2112734 37.7813508831163 -122.432248091846 (37.7813508831163, -122.432248091846) 15 9 11 29490 41
178520 26446 1 162 1446 Eddy St 1 Sidewalk: Curb side : Cutout Tree 1     6 2x2   6003531.77334 2112813.93522 37.7815839006792 -122.431427761093 (37.7815839006792, -122.431427761093) 15 9 11 29490 41
180041 103162 7 162 1201X Fillmore St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6003055.6 2112559.2 37.7808574628324 -122.43305688657 (37.7808574628324, -122.43305688657) 15 9 11 29490 41
181097 103175 1 162 1125 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2     7 3x3   6003319.4 2112265.6 37.7800662706417 -122.432123301144 (37.7800662706417, -122.432123301144) 15 9 11 29490 41
183100 103210 1 162 1113 Fillmore St 2 Sidewalk: Curb side : Cutout Tree 1   05/08/2013 12:00:00 AM   3x3   6003277.3 2112173.6 37.7798112746289 -122.432262371693 (37.7798112746289, -122.432262371693) 15 9 11 29490 41
184436 103202 7 162 1117 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003337 2112136 37.7797114192122 -122.432053157487 (37.7797114192122, -122.432053157487) 15 9 11 29490 41
190661 117083 1 162 1548 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree 1     2 5x5   6003183 2113711 37.7840272420603 -122.432698449568 (37.7840272420603, -122.432698449568) 13 9 11 29490 41
191009 29074 1 162 1149 Laguna St 1 Sidewalk: Curb side : Cutout Tree 1   12/15/2005 12:00:00 AM 3 3x3   6004485.54395 2112758.65374 37.7814861206023 -122.428124228455 (37.7814861206023, -122.428124228455) 7 9 11 29490 41
192340 103236 7 162 1240 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003317 2112564 37.7808854664086 -122.432152919664 (37.7808854664086, -122.432152919664) 15 9 11 29490 41