trees

Custom SQL query returning 43 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
4037 260562 1 48 260 Sagamore St 10 Sidewalk: Curb side : Cutout Landscaping 2       6x15   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
8171 260560 1 48 260 Sagamore St 8 Sidewalk: Curb side : Cutout Landscaping 2       6x8   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
13072 260558 1 48 260 Sagamore St 6 Sidewalk: Curb side : Cutout Landscaping 2       6x6   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
14896 260559 1 48 260 Sagamore St 7 Sidewalk: Curb side : Cutout Landscaping 2       6x12   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
18080 260563 1 48 260 Sagamore St 11 Sidewalk: Curb side : Cutout Landscaping 2       6x10   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
19343 260561 1 48 260 Sagamore St 9 Sidewalk: Curb side : Cutout Landscaping 2       6x7   5994371.63973 2087473.84971 37.7114830007096 -122.46127976636 (37.7114830007096, -122.46127976636) 9 8 6 28861 24
842 261260 1 48 431 Hickory St 1 Sidewalk: Curb side : Cutout Tree 2       Width 2ft   6004908 2110310 37.7747866111117 -122.426488326031 (37.7747866111117, -122.426488326031) 7 9 11 28852 10
2911 258680 4 48 2824 21st St   Sidewalk: Curb side : Cutout Tree 2       3x3   6009247 2103976 37.7576392372832 -122.411031286576 (37.7576392372832, -122.411031286576) 2 4 7 28859 19
3850 262121 2 48 296x Day St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
4151 251414 1 48 10x Jones St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009207 2112641 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248) 14 10 9 28852 36
5012 261384 4 48 246 Leavenworth St   Sidewalk: Curb side : Cutout Tree 2       3x3   6008558 2113314 37.7832405398106 -122.41407474629 (37.7832405398106, -122.41407474629) 7 10 9 28852 36
5250 264790 4 48 2640 25th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011026 2101818 37.7518134471323 -122.404726825793 (37.7518134471323, -122.404726825793) 10 4 8 28859 19
5644 264791 4 48 2640 25th St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6011026 2101818 37.7518134471323 -122.404726825793 (37.7518134471323, -122.404726825793) 10 4 8 28859 19
6533 258833 4 48 1199X Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5996025 2091881 37.7236790151497 -122.455883747529 (37.7236790151497, -122.455883747529) 9 8 4 28861 24
7182 262122 2 48 296x Day St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
10048 258883 4 48 1198X Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5996138 2091849 37.7235976355668 -122.455490816534 (37.7235976355668, -122.455490816534) 9 8 4 28861 24
10491 261696 1 48 1590 22nd Ave 1 Sidewalk: Curb side : Cutout Tree 2       Width 0ft   5989373 2104538 37.758047821522 -122.479804035874 (37.758047821522, -122.479804035874) 1 8 3 56 35
11948 264853 1 48 840 Polk St 3 Sidewalk: Curb side : Cutout Tree 2 DPW     3x3   6006827.36035 2113629.74006 37.7840101293977 -122.42008449353 (37.7840101293977, -122.42008449353) 7 9 9 28858 36
12646 261695 1 48 1470 22nd Ave 1 Sidewalk: Curb side : Cutout Tree 2       Width 0ft   5989346 2105344 37.7602593121964 -122.479956394756 (37.7602593121964, -122.479956394756) 1 8 3 56 35
14522 258882 4 48 1199X Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5996025 2091881 37.7236790151497 -122.455883747529 (37.7236790151497, -122.455883747529) 9 8 4 28861 24
15403 251413 1 48 10x Jones St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009207 2112641 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248) 14 10 9 28852 36
16085 261385 4 48 238 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008591 2113342 37.7833192745132 -122.413962560517 (37.7833192745132, -122.413962560517) 7 10 9 28852 36
16223 251415 1 48 10x Jones St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009207 2112641 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248) 14 10 9 28852 36
18588 261261 1 48 425 Hickory St 1 Sidewalk: Curb side : Cutout Tree 2       Width 2ft   6004928 2110351 37.7749003177122 -122.426422061759 (37.7749003177122, -122.426422061759) 7 9 11 28852 10
19185 264854 1 48 840 Polk St 4 Sidewalk: Curb side : Cutout Tree 2 DPW     3x3   6006827.36035 2113629.74006 37.7840101293977 -122.42008449353 (37.7840101293977, -122.42008449353) 7 9 9 28858 36
19196 258834 4 48 1198X Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5996138 2091849 37.7235976355668 -122.455490816534 (37.7235976355668, -122.455490816534) 9 8 4 28861 24
30535 255733 1 48 840 Polk St 2 Sidewalk: Curb side : Cutout Tree 2 DPW     3x3   6006827.36035 2113629.74006 37.7840101293977 -122.42008449353 (37.7840101293977, -122.42008449353) 7 9 9 28858 36
39308 187624 1 48 325 Vicente St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5991928 2097693 37.7394013212876 -122.470469324928 (37.7394013212876, -122.470469324928) 1 8 4 59 40
39960 258413 7 48 119 Buchanan St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6004727 2108913 37.7709405550078 -122.427014922048 (37.7709405550078, -122.427014922048) 7 9 11 28852 10
96239 187623 1 48 325 Vicente St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5991928 2097693 37.7394013212876 -122.470469324928 (37.7394013212876, -122.470469324928) 1 8 4 59 40
97540 254135 1 48 779 14th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5991599 2110135 37.7735447550356 -122.472513696557 (37.7735447550356, -122.472513696557) 11 6 2 54 26
100810 258347 4 48 373 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6010476 2118794 37.7983948432015 -122.407825748362 (37.7983948432015, -122.407825748362) 3 1 10 308 4
119450 173669 1 48 1200X Alabama St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6009203.67582999 2102144.49744393 37.7526079137784 -122.411051756336 (37.7526079137784, -122.411051756336) 2 4 7 28859 19
120146 256138 4 48 701x Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008779 2096509 37.7371102589049 -122.412122119739 (37.7371102589049, -122.412122119739) 10 7 7 28859 2
133720 187653 1 48 307 Vicente St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5992004 2097696 37.7394139526506 -122.470206771239 (37.7394139526506, -122.470206771239) 1 8 4 59 40
136876 256136 4 48 799X Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6008891 2096498 37.7370863389093 -122.411734106556 (37.7370863389093, -122.411734106556) 10 7 7 28859 2
156155 256137 4 48 799X Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6008891 2096501 37.7370945762582 -122.411734318471 (37.7370945762582, -122.411734318471) 10 7 7 28859 2
157754 251416 1 48 10x Jones St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6009207 2112641 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248) 14 10 9 28852 36
194337 265035 4 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194339 265037 4 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194353 265038 4 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19
194364 265034 4 48 3012 25th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009402 2101646 37.7512502705876 -122.410330719668 (37.7512502705876, -122.410330719668) 2 4 7 28859 19
194365 265036 4 48 1250X Alabama St   Sidewalk: Curb side : Cutout Tree 2       3x3   6009246 2101881 37.7518867820544 -122.410886782822 (37.7518867820544, -122.410886782822) 2 4 7 28859 19