trees

Custom SQL query returning 60 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1936 84069 1 162 817 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/19/2008 12:00:00 AM 3 3x3 Permit Number 51015 5999219.92840826 2110050.76557572 37.7737516279449 -122.446145813494 (37.7737516279449, -122.446145813494) 15 5 11 29492 16
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
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
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
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
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
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
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
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
35934 87978 7 162 819 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51015 5999196 2110014.8 37.7736515091341 -122.446225997678 (37.7736515091341, -122.446225997678) 15 5 11 29492 16
37339 88266 7 162 650 Shrader St 2 Sidewalk: Curb side : Cutout Tree 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51251 5997597.8 2108325.1 37.7689206253965 -122.451632481066 (37.7689206253965, -122.451632481066) 15 5 11 29492 9
38515 54336 7 162 1327 04th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/15/1972 12:00:00 AM   4x4 Permit Number 10097 5994847.28834456 2106520.78678165 37.7638085505273 -122.461015454906 (37.7638085505273, -122.461015454906) 15 5 11 56 12
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
54800 14509 1 162 500X Masonic Ave 6 Sidewalk: Curb side : Cutout Tree 1   04/10/2001 12:00:00 AM 20 6X6   5999167.52145 2111070.84281 37.7765495060171 -122.446400495731 (37.7765495060171, -122.446400495731) 15 5 11 29492 16
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
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
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
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
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
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
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
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
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
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
92093 88265 7 162 650 Shrader St 1 Sidewalk: Curb side : Cutout Tree 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51251 5997597.8 2108325.1 37.7689206253965 -122.451632481066 (37.7689206253965, -122.451632481066) 15 5 11 29492 9
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
110165 14507 1 162 500X Masonic Ave 4 Sidewalk: Curb side : Cutout Tree 1   08/15/2012 12:00:00 AM 3 6x6   5999120.2068649 2111135.4671938 37.776724245508 -122.44656882047 (37.776724245508, -122.44656882047) 15 5 11 29492 16
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
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
131254 88267 7 162 669 Shrader St   Sidewalk: Curb side : Cutout Tree 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51252 5997547 2108255 37.7687252393927 -122.451803136311 (37.7687252393927, -122.451803136311) 15 5 11 29492 9
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
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
176223 14508 1 162 500X Masonic Ave 5 Sidewalk: Curb side : Cutout Tree 1   08/15/2012 12:00:00 AM 3 6x6   5999120.2068649 2111135.4671938 37.776724245508 -122.44656882047 (37.776724245508, -122.44656882047) 15 5 11 29492 16
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
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