trees

Custom SQL query returning 34 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
133 211075 1 63 650x Miramar Ave 6 Median : Yard Tree 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
10229 264894 6 63 56 Keystone Way 1 Back Yard : Yard Tree 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
12567 211070 1 63 500x Miramar Ave 7 Median : Yard Tree 1     24     5995378.92982 2093188.43217 37.7272318087773 -122.458211668947 (37.7272318087773, -122.458211668947) 9 7 4 28861 40
23455 97490 4 63 500X Miramar Ave 7 Median : Cutout Tree 2     12 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
28620 211073 1 63 602x Miramar Ave 5 Median : Yard Tree 1     26     5995385.83715 2093544.41078 37.7282096371561 -122.458213544022 (37.7282096371561, -122.458213544022) 9 7 4 28861 40
30931 211072 1 63 602x Miramar Ave 2 Median : Yard Tree 1     35     5995382.34021 2093429.07469 37.7278927511259 -122.458217288807 (37.7278927511259, -122.458217288807) 9 7 4 28861 40
33425 99460 4 63 550X Miramar Ave 7 Median : Cutout Tree 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
35868 24283 1 63 300X Winding Way 21 Median : Cutout Tree 1     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
36279 99451 4 63 400X Miramar Ave 1 Median : Cutout Tree 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
49979 99473 4 63 600X Miramar Ave 2 Median : Cutout Tree 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
50718 211068 1 63 500x Miramar Ave 1 Median : Yard Tree 1     35     5995376.89131 2092998.0023 37.7267088170477 -122.4582049393 (37.7267088170477, -122.4582049393) 9 7 4 28861 40
59640 211078 1 63 97 Ashton Ave 1 Sidewalk: Property side : Yard Tree 2     25 Width 8ft   5994121.91269 2090532.87853 37.7198679898921 -122.462364611346 (37.7198679898921, -122.462364611346) 9 8 6 28861 24
60529 211074 1 63 650x Miramar Ave 5 Median : Yard Tree 1     30     5995392.34643 2093881.33119 37.7291351132945 -122.458215416413 (37.7291351132945, -122.458215416413) 9 7 4 28861 40
62980 211065 1 63 400x Miramar Ave 1 Median : Yard Tree 1     25     5995367.47216 2092431.62053 37.7251531275117 -122.458196526171 (37.7251531275117, -122.458196526171) 9 7 4 28861 40
67798 211064 1 63 300x Miramar Ave 3 Median : Yard Tree 1     35     5995363.79151 2092232.49572 37.7246061670234 -122.458194844436 (37.7246061670234, -122.458194844436) 9 7 4 28861 40
70023 97489 4 63 500X Miramar Ave 5 Median : Cutout Tree 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
70780 211076 1 63 700x Miramar Ave 2 Median : Yard Tree 1     74     5995394.80602 2094076.5012 37.7296711442905 -122.458221033586 (37.7296711442905, -122.458221033586) 9 7 4 28861 40
74864 99487 4 63 700X Miramar Ave 4 Median : Cutout Tree 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
87097 211066 1 63 500x Miramar Ave 2 Median : Yard Tree 1     36     5995372.70371 2092704.86629 37.7259036953978 -122.458198208802 (37.7259036953978, -122.458198208802) 9 7 4 28861 40
99546 211067 1 63 500x Miramar Ave 5 Median : Yard Tree 1     39     5995372.66361 2092795.985 37.7261538831809 -122.458204939322 (37.7261538831809, -122.458204939322) 9 7 4 28861 40
101918 99474 4 63 650X Miramar Ave 5 Median : Cutout Tree 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
111527 99477 4 63 650X Miramar Ave 6 Median : Cutout Tree 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
113341 92210 7 63 300x Miramar Ave 4 Median : Cutout Tree 2   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.7243160320082 -122.458116274775 (37.7243160320082, -122.458116274775) 9 8 4 28861 24
139390 99472 4 63 600X Miramar Ave 5 Median : Cutout Tree 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
142912 99486 4 63 700X Miramar Ave 3 Median : Cutout Tree 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
144307 92207 7 63 300X Miramar Ave 1 Median : Cutout Tree 2   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.7243160320082 -122.458116274775 (37.7243160320082, -122.458116274775) 9 8 4 28861 24
145613 211069 1 63 500x Miramar Ave 3 Median : Yard Tree 1     29     5995377.19569 2093059.06381 37.7268764947539 -122.458208304568 (37.7268764947539, -122.458208304568) 9 7 4 28861 40
152878 234517 1 63 10x Benton Ave 1 Median : Yard Tree 1     29     6004828.72428 2095028.54608 37.7328228256069 -122.425674682059 (37.7328228256069, -122.425674682059) 2 7 7 28861 2
154451 178178 1 63 769 Cayuga Ave 2 Sidewalk: Property side : Yard Tree 2     4 Width 8ft   6001369.37887 2092541.7115 37.725798463024 -122.43745647446 (37.725798463024, -122.43745647446) 9 7 6 28861 25
161389 211071 1 63 500x Miramar Ave 8 Median : Yard Tree 1     25     5995380.09454 2093218.25605 37.727313764897 -122.458209800169 (37.727313764897, -122.458209800169) 9 7 4 28861 40
161917 99457 4 63 550X Miramar Ave 1 Median : Cutout Tree 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
163251 97485 4 63 500X Miramar Ave 1 Median : Cutout Tree 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
188497 99458 4 63 550X Miramar Ave 3 Median : Cutout Tree 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
193394 99455 4 63 400X Miramar Ave 5 Median : Cutout Tree 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40