trees

Custom SQL query returning 73 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
77810 1321 1 63 4050X Alemany Blvd 7 Sidewalk: Curb side : Cutout Tree 1     75 TR   5991740.4279021 2087082.0100679 37.7102553211792 -122.470345319704 (37.7102553211792, -122.470345319704) 9 8 4 64 24
22688 120924 6 63 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
60656 120926 6 63 3995X Alemany Blvd 9 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
109715 120932 6 63 3995X Alemany Blvd 15 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
136239 120933 6 63 3995X Alemany Blvd 16 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
145282 120934 6 63 3995X Alemany Blvd 17 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
156900 120929 6 63 3995X Alemany Blvd 12 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
162123 120936 6 63 3995X Alemany Blvd 19 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
162461 120921 6 63 3995X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree 2       3X3   5992394 2087287 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588) 9 8 4 64 24
49296 121082 1 63 24X KEMPTON AVE 6 Side Yard : Yard Tree 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
120938 110397 4 63 2200 BAY SHORE BLVD 1 Sidewalk: Curb side : Cutout Tree 2       3x30   6011234 2087411 37.7122664722191 -122.40299429709 (37.7122664722191, -122.40299429709) 9 7 8 309 39
36162 110396 4 63 1x ARLETA AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x30   6011055 2087587 37.7127397354919 -122.403625353192 (37.7127397354919, -122.403625353192) 9 7 8 309 39
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
135343 30050 1 63 900X Junipero Serra Blvd 1 Median : Cutout Tree 1     3 3X3   5991182.41456 2091161.54655 37.7214244519661 -122.472571141372 (37.7214244519661, -122.472571141372) 9 8 4 64 40
118486 100845 4 63 1 Estero Ave 3 Sidewalk: Property side : Yard Tree 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 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
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
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
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
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
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
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
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
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
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
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
188305 178179 1 63 201 Yale St 1 Sidewalk: Curb side : Cutout Tree 2     20 Width 4ft   6007200.07685 2092715.80897 37.7266062646522 -122.417312460112 (37.7266062646522, -122.417312460112) 9 3 7 309 28
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
160036 253982 1 63 438X Detroit St 1 Unaccepted Street : Yard Tree 2       10x10   5999326 2094622 37.7313940668699 -122.444669716777 (37.7313940668699, -122.444669716777) 9 7 4 59 40
4567 261551 6 63 135 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5994788 2095004 37.7321829429526 -122.460385989231 (37.7321829429526, -122.460385989231) 9 8 4 59 40
136927 211081 1 63 90 Melrose Ave 7 Sidewalk: Property side : Yard Tree 2     9 Width 8ft   5999513.42858 2095531.79881 37.7339028547188 -122.444087092249 (37.7339028547188, -122.444087092249) 9 7 4 63 40
186578 211080 1 63 90 Melrose Ave 5 Sidewalk: Property side : Yard Tree 2     6 Width 8ft   5999525.10685 2095532.7271 37.7339060697915 -122.444046783738 (37.7339060697915, -122.444046783738) 9 7 4 63 40
3008 251503 1 63 800X Bosworth St 15 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
22926 251501 1 63 800X Bosworth St 13 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
60691 111521 1 63 800x BOSWORTH ST 16 Front Yard : Yard Tree 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
63289 111517 1 63 800x BOSWORTH ST 12 Front Yard : Yard Tree 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
68470 251502 1 63 800X Bosworth St 14 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
69354 111518 1 63 800x BOSWORTH ST 13 Front Yard : Yard Tree 1     27     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
90813 111522 1 63 800x BOSWORTH ST 17 Front Yard : Yard Tree 1     20     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
115262 251499 1 63 800X Bosworth St 11 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
150055 111519 1 63 800x BOSWORTH ST 14 Front Yard : Yard Tree 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
177928 251498 1 63 800X Bosworth St 10 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
183860 111506 1 63 800x BOSWORTH ST 1 Front Yard : Yard Tree 1     48     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
184944 251500 1 63 800X Bosworth St 12 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
170298 211082 1 63 843 Detroit St 7 Sidewalk: Property side : Yard Tree 2     1 Width 5ft   5999417.62854 2095618.00896 37.7341341018996 -122.444424494503 (37.7341341018996, -122.444424494503) 9 7 4 59 40
38246 111524 1 63 900x BOSWORTH ST 2 Front Yard : Yard Tree 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
110008 111523 1 63 900x BOSWORTH ST 1 Front Yard : Yard Tree 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
31868 13401 1 63 344 Marietta Dr 1 Median : Cutout Tree 1     70 5   5999579.163416 2097433.156503 37.7391272835542 -122.443996396446 (37.7391272835542, -122.443996396446) 9 7 4 59 40
7002 262493 1 63 1100X Portola Dr 2 Median : Yard Tree 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
10438 262492 1 63 1100X Portola Dr 1 Median : Yard Tree 2       10x10   5995372 2097783 37.7398469739468 -122.458568082407 (37.7398469739468, -122.458568082407) 9 7 4 59 40
164258 253422 1 63 2X Miraloma Dr 1 Side Yard : Cutout Tree 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
184680 256643 1 63 2X Miraloma Dr 2 Side Yard : Cutout Tree 1       10x10   5994995 2097925 37.7402151966004 -122.459881864698 (37.7402151966004, -122.459881864698) 9 8 4 59 40
82478 98836 1 63 1101X Portola Dr 6 Sidewalk: Property side : Yard Tree 1           5994967.95791 2097979.30417 37.740362747151 -122.459979297607 (37.740362747151, -122.459979297607) 9 8 4 59 40