trees

Custom SQL query returning 61 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
57084 7219 7 162 1000X Fillmore St 5 Sidewalk: Curb side : Cutout Tree 2     12 4X4   6003426.09434 2111753.60864 37.778666518442 -122.431717632161 (37.778666518442, -122.431717632161) 15 9 11 29490 41
22425 45606 1 162 1100X Fillmore St 2 Sidewalk: Curb side : Cutout Tree 1   08/06/2001 12:00:00 AM 4   Permit Number 44335 6003389.50485138 2112095.5826587 37.7796034198271 -122.431868633724 (37.7796034198271, -122.431868633724) 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
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
15895 140445 1 162 1101 FILLMORE ST 6 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6003336.4315 2112141.3403 37.7797260501135 -122.432055505631 (37.7797260501135, -122.432055505631) 15 9 11 29490 41
55562 103196 7 162 1119 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003336 2112143 37.7797305827723 -122.432057116929 (37.7797305827723, -122.432057116929) 15 9 11 29490 41
8127 140444 1 162 1101 FILLMORE ST 5 Sidewalk: Curb side : Cutout Tree 2   01/24/2020 11:08:00 AM 4 Width 0ft   6003334.2784 2112160.0013 37.7797771664963 -122.432064287097 (37.7797771664963, -122.432064287097) 15 9 11 29490 41
2874 261577 1 162 1101 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2   03/15/2014 12:00:00 AM   Width 0ft   6003302 2112170 37.779802790384 -122.432176666415 (37.779802790384, -122.432176666415) 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
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
7634 140443 1 162 1101 FILLMORE ST 4 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   6003331.4074 2112177.9445 37.7798262712775 -122.432075500833 (37.7798262712775, -122.432075500833) 15 9 11 29490 41
13346 261570 1 162 1100 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 1   08/06/2001 12:00:00 AM       6003395 2112193 37.7798712150659 -122.43185658143 (37.7798712150659, -122.43185658143) 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
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
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
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
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
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
55723 103233 1 162 1180X Fillmore St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6003347.1 2112356 37.7803160569069 -122.4320339316 (37.7803160569069, -122.4320339316) 15 9 11 29490 41
73359 103234 1 162 1180X Fillmore St 2 Sidewalk: Curb side : Cutout Tree 1       3x3   6003347.1 2112356 37.7803160569069 -122.4320339316 (37.7803160569069, -122.4320339316) 15 9 11 29490 41
11849 6015 1 162 1735 Eddy St 1 Sidewalk: Curb side : Cutout Tree 1   12/27/2007 12:00:00 AM 3 3X3   6002103.39353 2112426.40407 37.7804387805264 -122.436341522247 (37.7804387805264, -122.436341522247) 15 5 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
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
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
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
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
25183 103240 7 162 1240 Fillmore St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6003317 2112564 37.7808854664086 -122.432152919664 (37.7808854664086, -122.432152919664) 15 9 11 29490 41
42823 103238 7 162 1240 Fillmore St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6003317 2112564 37.7808854664086 -122.432152919664 (37.7808854664086, -122.432152919664) 15 9 11 29490 41
73211 103237 7 162 1240 Fillmore St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6003317 2112564 37.7808854664086 -122.432152919664 (37.7808854664086, -122.432152919664) 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
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
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
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
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
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
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
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
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
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
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
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
58656 5957 7 162 1499X Eddy St 8 Sidewalk: Curb side : Cutout Tree 2   12/15/2005 12:00:00 AM 3 3X3   6003438.71486 2112759.60085 37.781429437525 -122.431745818262 (37.781429437525, -122.431745818262) 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
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
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
63174 26722 1 162 1203X Webster St 9 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
72651 26718 1 162 1203X Webster St 5 Sidewalk: Curb side : Cutout Tree 1     35 3X3   6003742.20526 2112831.75991 37.7816447668943 -122.430701039692 (37.7816447668943, -122.430701039692) 15 9 11 29490 41
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
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
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
67879 26442 1 162 1424 Eddy St 1 Sidewalk: Curb side : Cutout Tree 1     6 2X2   6003636.29086 2112833.40988 37.7816432962484 -122.431067570908 (37.7816432962484, -122.431067570908) 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
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
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
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
26912 117082 1 162 1538 FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree 2     4 3x3   6003149 2113637 37.7838221284182 -122.432810788933 (37.7838221284182, -122.432810788933) 13 9 11 29490 41
41715 117084 1 162 1548 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree 1     2 5x5   6003183 2113711 37.7840272420603 -122.432698449568 (37.7840272420603, -122.432698449568) 13 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
41688 106205 1 162 1600X FILLMORE ST 3 Sidewalk: Curb side : Cutout Tree 2     2 5x5   6003136.7 2113842.5 37.7843856819978 -122.432868028127 (37.7843856819978, -122.432868028127) 13 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