Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187965 | 187965 | 179351 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6006769.15045 | 2086918.2406 | 37.7106631220796 | -122.41839126344601 | (37.7106631220796, -122.418391263446) | |||
| 184621 | 184621 | 186023 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 1900 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985031.2475 | 2101908.1707 | 37.7505738451375 | -122.49462557465901 | (37.7505738451375, -122.494625574659) | |||
| 176399 | 176399 | 179357 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007215.96527 | 2086835.5457 | 37.71046120179479 | -122.416841112839 | (37.7104612017948, -122.416841112839) | |||
| 173721 | 173721 | 179353 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007163.47347 | 2086852.8130299998 | 37.710505661580896 | -122.417023758845 | (37.7105056615809, -122.417023758845) | |||
| 171037 | 171037 | 197212 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6017263.91913 | 2098709.4149599997 | 37.74362458719779 | -122.38293871135099 | (37.7436245871978, -122.382938711351) | |||
| 171027 | 171027 | 179352 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007138.6649400005 | 2086865.4653599998 | 37.710539006644794 | -122.41711039862301 | (37.7105390066448, -122.417110398623) | |||
| 170456 | 170456 | 240330 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 1275 San Jose Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6003923.42572 | 2095674.7129099998 | 37.7345458564984 | -122.428850578486 | (37.7345458564984, -122.428850578486) | ||||
| 168544 | 168544 | 179354 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6007178.2893 | 2086848.4615900002 | 37.7104945468639 | -122.41697224389999 | (37.7104945468639, -122.4169722439) | |||
| 167482 | 167482 | 197210 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 1700 22nd St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6012879.70369 | 2103800.3418400004 | 37.7573599607159 | -122.398455506044 | (37.7573599607159, -122.398455506044) | ||||
| 164348 | 164348 | 197218 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017435.50351 | 2098556.05574 | 37.743212972902704 | -122.38233474108101 | (37.7432129729027, -122.382334741081) | |||
| 161598 | 161598 | 117655 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 4945 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5983271.78514 | 2111690.7442400004 | 37.7773308720147 | -122.501433407785 | (37.7773308720147, -122.501433407785) | |||
| 157371 | 157371 | 179356 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6007201.1629800005 | 2086840.57155 | 37.710474169120204 | -122.416892628694 | (37.7104741691202, -122.416892628694) | |||
| 157209 | 157209 | 179360 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 522 Sunnydale Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 6010043.89457 | 2086419.58682 | 37.709477722997 | -122.40703783884399 | (37.709477722997, -122.407037838844) | ||||
| 156588 | 156588 | 197216 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017405.29347 | 2098583.32775 | 37.7432861876121 | -122.38244109758499 | (37.7432861876121, -122.382441097585) | |||
| 155446 | 155446 | 122173 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 200 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991547.68728 | 2113548.29768 | 37.7829137661673 | -122.472940142363 | (37.7829137661673, -122.472940142363) | |||
| 152030 | 152030 | 197217 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 12 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017418.77475 | 2098570.88696 | 37.7432527723975 | -122.382393616971 | (37.7432527723975, -122.382393616971) | |||
| 148693 | 148693 | 123268 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 460 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 5993762.02866 | 2112399.44022 | 37.779887261198795 | -122.4651960286 | (37.7798872611988, -122.4651960286) | |||
| 147091 | 147091 | 122175 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 200 14th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991544.95469 | 2113582.84567 | 37.7830084672106 | -122.47295211599199 | (37.7830084672106, -122.472952115992) | |||
| 145358 | 145358 | 90749 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4327 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982140.9261 | 2110286.22946 | 37.773408005745296 | -122.50524122882601 | (37.7734080057453, -122.505241228826) | ||
| 143599 | 143599 | 89529 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5000X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983095.8091 | 2111736.71305 | 37.7774467524363 | -122.50204555844 | (37.7774467524363, -122.50204555844) | ||
| 142508 | 142508 | 91011 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4622 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5981221.20719 | 2110309.11198 | 37.773416674213706 | -122.508424309329 | (37.7734166742137, -122.508424309329) | ||
| 140935 | 140935 | 89566 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5001X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983110.49799 | 2111681.5935 | 37.7772962731377 | -122.501990666002 | (37.7772962731377, -122.501990666002) | ||
| 136839 | 136839 | 240332 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 60 Sharon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003844.27978 | 2106789.2546 | 37.765059311271294 | -122.429916761647 | (37.7650593112713, -122.429916761647) | |||
| 136158 | 136158 | 197211 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017250.2855 | 2098720.3657 | 37.7436539023979 | -122.382986615562 | (37.7436539023979, -122.382986615562) | |||
| 131835 | 131835 | 138640 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 1646 LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999620.9791 | 2114590.0361 | 37.7862381910735 | -122.445084920177 | (37.7862381910735, -122.445084920177) | |||
| 130584 | 130584 | 183166 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 2418 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982722.9055 | 2098628.3229 | 37.7414329135739 | -122.502365164221 | (37.7414329135739, -122.502365164221) | |||
| 129898 | 129898 | 123267 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 460 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5993762.56243 | 2112432.8054400003 | 37.779978903871296 | -122.46519660622101 | (37.7799789038713, -122.465196606221) | |||
| 128775 | 128775 | 89533 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5140 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982684.3370199995 | 2111722.3179200003 | 37.7773830461441 | -122.503467886196 | (37.7773830461441, -122.503467886196) | ||
| 127746 | 127746 | 89551 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5333 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982065.67399 | 2111646.96238 | 37.7771397519236 | -122.505602419867 | (37.7771397519236, -122.505602419867) | ||
| 126333 | 126333 | 89557 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982344.66025 | 2111655.7855 | 37.777180392486 | -122.504637988559 | (37.777180392486, -122.504637988559) | ||
| 122140 | 122140 | 179350 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 241 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005877.38555 | 2087080.87397 | 37.7110594380007 | -122.42148494928401 | (37.7110594380007, -122.421484949284) | |||
| 117261 | 117261 | 3583 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 8 | 3x3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 116740 | 116740 | 90919 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5048 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 5 | 3x3 | 5982934.22783 | 2111732.57013 | 37.7774258833955 | -122.502604205438 | (37.7774258833955, -122.502604205438) | ||
| 112797 | 112797 | 89565 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5001X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983089.7802099995 | 2111680.23644 | 37.777291329944 | -122.50206223387899 | (37.777291329944, -122.502062233879) | ||
| 111693 | 111693 | 89553 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5301X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982158.297809999 | 2111648.1776099997 | 37.7771485392206 | -122.50528210040001 | (37.7771485392206, -122.5052821004) | ||
| 110382 | 110382 | 90732 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4533 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981514.87502 | 2110263.98035 | 37.7733100587697 | -122.507405139203 | (37.7733100587697, -122.507405139203) | ||
| 110367 | 110367 | 99185 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4345 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2008 12:00:00 AM | 3 | 3x3 | 5982067.9022699995 | 2110283.83078 | 37.7733971225951 | -122.505493646453 | (37.7733971225951, -122.505493646453) | ||
| 108955 | 108955 | 89544 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5324 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982113.874969999 | 2111702.53608 | 37.777295177582204 | -122.505439800548 | (37.7772951775822, -122.505439800548) | ||
| 103204 | 103204 | 89548 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5601 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981205.071959999 | 2111615.6071 | 37.77700297412879 | -122.50857713252199 | (37.7770029741288, -122.508577132522) | ||
| 99596 | 99596 | 89525 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4900X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983384.65726 | 2111746.53595 | 37.7774906880837 | -122.501047080127 | (37.7774906880837, -122.501047080127) | ||
| 99525 | 99525 | 89538 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5226 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982399.00612 | 2111713.8845599997 | 37.777343112143996 | -122.50445429746 | (37.777343112144, -122.50445429746) | ||
| 98051 | 98051 | 89543 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5300X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982144.573969999 | 2111703.4056700002 | 37.7772993717145 | -122.50533366907801 | (37.7772993717145, -122.505333669078) | ||
| 97937 | 97937 | 89571 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4901X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983370.6621900005 | 2111693.23015 | 37.777343504090396 | -122.5010915494 | (37.7773435040904, -122.5010915494) | ||
| 97710 | 97710 | 89546 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5450 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5981705.459980001 | 2111690.26917 | 37.777237453835895 | -122.506851705119 | (37.7772374538359, -122.506851705119) | ||
| 96472 | 96472 | 89558 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982363.16543 | 2111656.98924 | 37.77718478612329 | -122.504574063555 | (37.7771847861233, -122.504574063555) | ||
| 96395 | 96395 | 89563 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5027 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983042.76149 | 2111679.44242 | 37.7772863874375 | -122.502224825366 | (37.7772863874375, -122.502224825366) | ||
| 92891 | 92891 | 89547 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5500 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981512.1941599995 | 2111683.29996 | 37.777206935443 | -122.507519744478 | (37.777206935443, -122.507519744478) | ||
| 90227 | 90227 | 89532 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5130 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982703.43603 | 2111723.1091299998 | 37.777386341369706 | -122.50340187617701 | (37.7773863413697, -122.503401876177) | ||
| 89706 | 89706 | 89572 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 4901X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983389.31662 | 2111692.03112 | 37.777341307260706 | -122.50102693 | (37.7773413072607, -122.50102693) | ||
| 88550 | 88550 | 97441 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 1900@Gough Pacific Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||||
| 84236 | 84236 | 87561 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 1426 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2011 12:00:00 AM | 3 | 3x3 | 5981248.5719800005 | 2105353.680971 | 37.759812110915206 | -122.50796181336901 | (37.7598121109152, -122.507961813369) | ||
| 84065 | 84065 | 89564 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5021 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983068.09266 | 2111680.5005900003 | 37.7772907811029 | -122.502137276438 | (37.7772907811029, -122.502137276438) | ||
| 81150 | 81150 | 89541 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5300X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982202.45771 | 2111704.784 | 37.777306562133106 | -122.505133536108 | (37.7773065621331, -122.505133536108) | ||
| 72978 | 72978 | 117659 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 5048 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982955.71016 | 2111732.11037 | 37.777425883386705 | -122.502529858177 | (37.7774258833867, -122.502529858177) | |||
| 71193 | 71193 | 89530 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5014 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983074.33103 | 2111736.1703 | 37.7774440004005 | -122.502119816782 | (37.7774440004005, -122.502119816782) | ||
| 67081 | 67081 | 120747 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 290 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5989660.66014 | 2113437.65192 | 37.7825005368819 | -122.47946030153999 | (37.7825005368819, -122.47946030154) | |||
| 58085 | 58085 | 197219 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 20 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6017546.94281 | 2098457.41264 | 37.7429482736446 | -122.38194254943599 | (37.7429482736446, -122.381942549436) | |||
| 56191 | 56191 | 3589 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018406.34137 | 2097917.94858 | 37.741514435040294 | -122.37893349789302 | (37.7415144350403, -122.378933497893) | ||
| 56145 | 56145 | 179358 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 200 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6006198.74032 | 2087052.72887 | 37.7110002716272 | -122.420372271187 | (37.7110002716272, -122.420372271187) | |||
| 55323 | 55323 | 214007 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 100x Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5993739.83569 | 2104610.7544299997 | 37.7585003100564 | -122.464707056595 | (37.7585003100564, -122.464707056595) | |||
| 51545 | 51545 | 3580 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 47289 | 47289 | 179359 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 220 Blythdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6006008.5127 | 2087093.06513 | 37.711100304999796 | -122.42103260648001 | (37.7111003049998, -122.42103260648) | |||
| 46884 | 46884 | 119232 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 4333 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5982116.59434 | 2110285.8700900003 | 37.773405587282 | -122.505325367756 | (37.773405587282, -122.505325367756) | |||
| 45802 | 45802 | 240331 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 60 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003844.61217 | 2106805.37047 | 37.7651035803891 | -122.42991676164499 | (37.7651035803891, -122.429916761645) | |||
| 42011 | 42011 | 138639 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 1646 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999626.2324 | 2114571.6495 | 37.786188006097 | -122.44506542288099 | (37.786188006097, -122.445065422881) | |||
| 39034 | 39034 | 122174 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 200 14th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5991544.6782 | 2113562.95943 | 37.782953849079 | -122.472951621926 | (37.782953849079, -122.472951621926) | |||
| 35223 | 35223 | 197213 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017295.11492 | 2098681.7702099998 | 37.74355040393579 | -122.382828919425 | (37.7435504039358, -122.382828919425) | |||
| 35082 | 35082 | 214006 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 200x Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5993658.67007 | 2104606.16817 | 37.7584830376791 | -122.464987428342 | (37.7584830376791, -122.464987428342) | |||
| 25067 | 25067 | 179355 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 65 Blythdale Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 6007191.75083 | 2086844.1379 | 37.7104834321401 | -122.41692541169901 | (37.7104834321401, -122.416925411699) | |||
| 23263 | 23263 | 3508 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6017980.680269999 | 2098133.15007 | 37.7420818568975 | -122.380420257114 | (37.7420818568975, -122.380420257114) | |||
| 22352 | 22352 | 3605 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018137.75637 | 2098119.86028 | 37.7420540318827 | -122.37987620861601 | (37.7420540318827, -122.379876208616) | |||
| 22351 | 22351 | 3656 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 92 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017299.77103 | 2098787.22136 | 37.7438402086508 | -122.38282015645201 | (37.7438402086508, -122.382820156452) | ||
| 22340 | 22340 | 3632 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 68 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017663.5913 | 2098472.7680200003 | 37.7429968775117 | -122.38154027458799 | (37.7429968775117, -122.381540274588) | |||
| 22339 | 22339 | 3642 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 78 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017503.4842 | 2098606.02713 | 37.7433539389383 | -122.382103154832 | (37.7433539389383, -122.382103154832) | |||
| 22338 | 22338 | 3608 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018087.01832 | 2098157.15518 | 37.7421536371939 | -122.380054237523 | (37.7421536371939, -122.380054237523) | ||
| 22337 | 22337 | 3609 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 9 | 3X3 | 6018070.77279 | 2098169.47823 | 37.7421865775631 | -122.380111266222 | (37.7421865775631, -122.380111266222) | |||
| 22335 | 22335 | 3628 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017730.69941 | 2098422.13413 | 37.7428615520079 | -122.38130471064899 | (37.7428615520079, -122.381304710649) | |||
| 22332 | 22332 | 3637 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017581.37685 | 2098535.7297 | 37.7431652179942 | -122.381828930869 | (37.7431652179942, -122.381828930869) | |||
| 22328 | 22328 | 3612 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018020.628269999 | 2098207.76094 | 37.7422889275932 | -122.380287312129 | (37.7422889275932, -122.380287312129) | |||
| 22324 | 22324 | 3625 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 61 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017781.374919999 | 2098384.59743 | 37.7427612812112 | -122.38112687781 | (37.7427612812112, -122.38112687781) | |||
| 22322 | 22322 | 3590 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018389.26392 | 2097931.71648 | 37.7415512973552 | -122.378993502451 | (37.7415512973552, -122.378993502451) | ||
| 22317 | 22317 | 3653 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 89 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017331.733030001 | 2098760.60047 | 37.7437688789233 | -122.382707786159 | (37.7437688789233, -122.382707786159) | |||
| 22315 | 22315 | 3636 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017599.14752 | 2098522.45762 | 37.7431297568333 | -122.38176656108601 | (37.7431297568333, -122.381766561086) | |||
| 22311 | 22311 | 3643 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017487.6627 | 2098619.8542 | 37.7433910314633 | -122.382158823763 | (37.7433910314633, -122.382158823763) | |||
| 16830 | 16830 | 3619 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017883.8496199995 | 2098309.7670299998 | 37.742561468052294 | -122.380767345063 | (37.7425614680523, -122.380767345063) | |||
| 16339 | 16339 | 3548 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018674.8366 | 2097616.25665 | 37.7407008489755 | -122.37798418701999 | (37.7407008489755, -122.37798418702) | |||
| 16197 | 16197 | 3604 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018155.728019999 | 2098107.78819 | 37.742021875700296 | -122.37981322911999 | (37.7420218757003, -122.37981322912) | |||
| 15955 | 15955 | 3494 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017631.184309999 | 2098389.6910900003 | 37.7427669757157 | -122.38164655374099 | (37.7427669757157, -122.381646553741) | |||
| 15603 | 15603 | 3517 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018124.75716 | 2098026.19045 | 37.741796116207105 | -122.37991464925899 | (37.7417961162071, -122.379914649259) | ||
| 15552 | 15552 | 3616 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017954.336080001 | 2098256.07975 | 37.7424179434233 | -122.38051989028901 | (37.7424179434233, -122.380519890289) | |||
| 15506 | 15506 | 3509 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017998.366640001 | 2098120.43609 | 37.742047922763795 | -122.380358219176 | (37.7420479227638, -122.380358219176) | ||
| 15487 | 15487 | 3499 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017721.1126 | 2098322.7096700002 | 37.742588023232 | -122.381330947484 | (37.742588023232, -122.381330947484) | |||
| 15411 | 15411 | 3504 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017814.43885 | 2098252.58182 | 37.7424006179895 | -122.3810033748 | (37.7424006179895, -122.3810033748) | |||
| 15250 | 15250 | 3496 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017663.23695 | 2098365.77973 | 37.74270308968379 | -122.381534061174 | (37.7427030896838, -122.381534061174) | |||
| 15214 | 15214 | 3606 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018122.20462 | 2098131.02661 | 37.742083834489605 | -122.379930757907 | (37.7420838344896, -122.379930757907) | |||
| 15070 | 15070 | 3495 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017646.36043 | 2098378.21595 | 37.742736305236605 | -122.381593280624 | (37.7427363052366, -122.381593280624) | |||
| 14987 | 14987 | 3529 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018316.85209 | 2097881.54987 | 37.7414095570002 | -122.379240396934 | (37.7414095570002, -122.379240396934) | ||
| 14783 | 14783 | 3633 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 69 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017649.0599 | 2098484.04513 | 37.743027039860394 | -122.381591304811 | (37.7430270398604, -122.381591304811) | |||
| 14781 | 14781 | 3543 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6018555.97345 | 2097704.22378 | 37.74093583821671 | -122.378401280909 | (37.7409358382167, -122.378401280909) | ||
| 14413 | 14413 | 3500 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017738.77776 | 2098309.39264 | 37.7425524325559 | -122.381268940124 | (37.7425524325559, -122.381268940124) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");