trees

Custom SQL query returning 47 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
628 256542 8 15 133 Olympia Way 1 Back Yard : Yard Tree 2       3x3   5996852 2101844 37.7510824274474 -122.453744067192 (37.7510824274474, -122.453744067192) 1 5 4 63 38
4239 258982 8 15 239 Panorama Dr 1 Back Yard : Yard Tree 2       3x3   5997275 2101153 37.7492093542443 -122.452231443092 (37.7492093542443, -122.452231443092) 1 5 4 63 38
15601 99374 8 15 21 Panorama Dr   Back Yard : Yard Tree 2     24     5998009 2100230 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288) 1 5 4 63 38
22075 187658 8 42 600X Clarendon Ave 1 Front Yard : Yard Tree 2       3x3   5995637 2102382 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932) 1 5 4 63 12
28314 256608 8 15 279 Oak Park Dr 2 Back Yard : Yard Tree 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
51917 256537 8 15 139 Olympia Way 1 Back Yard : Cutout Tree 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
87678 254111 8 15 279 Oak Park Dr 1 Back Yard : Yard Tree 2       10x10   5995764 2102990 37.7541666190925 -122.457589367448 (37.7541666190925, -122.457589367448) 1 5 4 63 12
89545 256543 8 15 139 Olympia Way 1 Back Yard : Yard Tree 2       3x3   5996818 2101849 37.7510942069084 -122.453862003079 (37.7510942069084, -122.453862003079) 1 5 4 63 38
124235 122518 8 15 772X Panorama Dr 1 Back Yard : Cutout Tree 2       3x3   5996713 2102901 37.7539767153501 -122.45430108189 (37.7539767153501, -122.45430108189) 1 5 4 63 38
161514 253207 8 41 89 Woodhaven Ct 1 Back Yard : Cutout Tree 2       3x3   5996069 2103645 37.7559825991437 -122.456581972884 (37.7559825991437, -122.456581972884) 1 5 4 63 12
178160 173600 8 28 500 Clarendon Ave 1 Sidewalk: Property side : Cutout Tree 2       3x3   5996184 2102497 37.7528370823128 -122.456101271869 (37.7528370823128, -122.456101271869) 1 5 4 63 12
43876 114817 8 15 100 RACCOON DR 1 Back Yard : Cutout Tree 2           5998725 2104028 37.757186355085 -122.447424250084 (37.757186355085, -122.447424250084) 15 5 5 63 3
227 102275 8 17 267 Topaz Way   Back Yard : Yard Landscaping 2           6001225.6 2097744.2 37.7400751189117 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
2059 264900 8 15 35X Parkridge Dr 1 Median : Yard Tree 2       3x3   5999060 2101975 37.7515684597407 -122.446118026985 (37.7515684597407, -122.446118026985) 2 5 5 63 38
5758 262529 8 63 555 Portola Dr 8 Front Yard : Yard Tree 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
6585 260539 8 15 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree 2       3x3   5997905 2100119 37.7464063138276 -122.449978390477 (37.7464063138276, -122.449978390477) 2 5 4 63 38
9029 258675 8 62 60 Laidley St 1 Back Yard : Yard Tree 2       3x3   6003232 2097949 37.7407513687421 -122.431403364879 (37.7407513687421, -122.431403364879) 2 7 5 63 7
10460 258772 8 337 20 Crestline Dr 1 Sidewalk: Curb side : Cutout Tree 5 Private     3x3   5999139 2101332 37.7498074496931 -122.445798597569 (37.7498074496931, -122.445798597569) 2 5 5 63 38
22321 256538 8 41 19 Miguel St 1 Back Yard : Yard Tree 2       3x3   6003470 2097467 37.7394413932778 -122.430546066859 (37.7394413932778, -122.430546066859) 2 7 5 63 7
23775 108576 8 45 2479 Diamond St 1 Front Yard : Yard Landscaping 2           6002240 2097369 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338) 2 7 5 63 7
28785 122558 8 15 1760 Diamond St 1 Back Yard : Yard Tree 2     20 3x3   6001927 2098732 37.7428272563398 -122.435971568238 (37.7428272563398, -122.435971568238) 2 7 5 63 22
30200 98503 8 41 208 Glenview Dr   Back Yard : Yard Tree 2           5998871 2100779 37.7482737407191 -122.446685565827 (37.7482737407191, -122.446685565827) 2 5 5 63 38
33684 97290 8 15 55 Hiliritas Ave   Front Yard : Yard Tree 2         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981) 2 7 5 63 7
33827 99268 8 17 292 Whitney St   Front Yard : Cutout Tree 2           6004280 2096681 37.7373290690714 -122.427689454915 (37.7373290690714, -122.427689454915) 2 7 5 63 7
40432 110929 8 15 445 BEACON ST   Back Yard : Yard Tree 2       3x3   6002243 2098437 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675) 2 7 5 63 7
44517 251117 8 240 2024 Castro St 1 Back Yard : Yard Tree 2           6002622 2099601 37.7452527853239 -122.433630548541 (37.7452527853239, -122.433630548541) 2 7 5 63 22
45129 98465 8 17 190 Portola Dr   Back Yard : Yard Landscaping 2           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302) 2 5 5 63 38
48396 109097 8 14 601 29th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
54211 98502 8 17 244 Glenview Dr   Back Yard : Yard Landscaping 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
58309 100046 8 17 562 28th St   Front Yard : Yard Tree 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262 2099459 37.7448424535299 -122.434865213189 (37.7448424535299, -122.434865213189) 2 7 5 63 22
68497 99961 8 67 537 Valley St 1 Front Yard : Yard Tree 2   07/25/2012 12:00:00 AM     Permit Number 768880 6002459 2099152 37.7440106863694 -122.434162082356 (37.7440106863694, -122.434162082356) 2 7 5 63 22
90504 98893 8 17 216 Glenview Dr   Back Yard : Yard Landscaping 2           5998910 2100761 37.7482265448319 -122.446549410607 (37.7482265448319, -122.446549410607) 2 5 5 63 38
99841 98436 8 17 238 Glenview Dr   Back Yard : Yard Tree 2           5999035 2100736 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035) 2 5 5 63 38
105747 98892 8 17 220 Glenview Dr   Back Yard : Yard Landscaping 2           5998935 2100753 37.7482060067302 -122.44646238624 (37.7482060067302, -122.44646238624) 2 5 5 63 38
106981 109092 8 40 237 28th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282) 2 7 5 63 22
113384 98890 8 17 256 Glenview Dr   Back Yard : Yard Landscaping 2           5999134 2100748 37.7482036421854 -122.44577389345 (37.7482036421854, -122.44577389345) 2 5 5 63 38
120627 100045 8 111 556 28th St   Front Yard : Yard Tree 2         Not sure which property tree is located on. 6002301 2099461 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
135134 113440 8 41 190 BEACON ST   Back Yard : Yard Tree 2     32 3x3   6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
137033 114410 8 15 10 GARDENSIDE DR   Sidewalk: Curb side : Cutout Tree 2           5999306 2102458 37.7529087049134 -122.445302055175 (37.7529087049134, -122.445302055175) 2 5 5 63 38
137283 109242 8 284 2479 DIAMOND ST   Sidewalk: Curb side : Yard Landscaping 2           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916) 2 7 5 63 7
137488 98501 8 17 232 Glenview Dr   Back Yard : Yard Landscaping 2           5998998 2100740 37.7481739100487 -122.446243600021 (37.7481739100487, -122.446243600021) 2 5 5 63 38
145213 256660 8 284 40X Miguel St 1 Back Yard : Yard Landscaping 2       3x3   6003624 2097154 37.7385906898162 -122.429991281012 (37.7385906898162, -122.429991281012) 2 7 5 63 7
173830 98139 8 175 556 Laidley St   Back Yard : Yard Tree 2       3x3   6003085 2096041 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062) 2 7 5 63 7
192149 98878 8 17 11 Panorama Dr   Back Yard : Yard Landscaping 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38
30542 98548 8 155 132 Hamerton Ave 1 Front Yard : Yard Tree 2           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907) 9 7 5 63 40
53937 94690 8 348 749 Congo St   Front Yard : Yard Tree 2   10/28/2010 12:00:00 AM     Permit Number 53820 6000274 2096023 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367) 9 7 4 63 40
171323 253471 8 240 17 Valletta Ct 1 Side Yard : Yard Tree 2       6x10   5999337 2096545 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358) 9 7 4 63 40