Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1379 | 1379 | 25668 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014174.0749699995 | 2117868.41683 | 37.796059744425996 | -122.394964320767 | (37.796059744426, -122.394964320767) | ||
| 4067 | 4067 | 25799 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012220.09673 | 2120843.1378 | 37.8041187644177 | -122.401934728525 | (37.8041187644177, -122.401934728525) | ||
| 5785 | 5785 | 25798 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.39960734420201 | (37.801354716114, -122.399607344202) | ||
| 7340 | 7340 | 25782 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 36 | 10 | 6013997.3565 | 2118221.08563 | 37.7970182616509 | -122.395600527244 | (37.7970182616509, -122.395600527244) | ||
| 17004 | 17004 | 25108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005223.671490001 | 2100130.84124 | 37.7468548845426 | -122.424672082757 | (37.7468548845426, -122.424672082757) | |||
| 17056 | 17056 | 25058 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594341996 | -122.425291287561 | (37.753237594342, -122.425291287561) | |||
| 17311 | 17311 | 25026 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 750X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005011.77925 | 2103932.39938 | 37.7572811108424 | -122.42567531518499 | (37.7572811108424, -122.425675315185) | |||
| 17339 | 17339 | 25501 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005202.0445 | 2108688.1512 | 37.770350024818704 | -122.425355725564 | (37.7703500248187, -122.425355725564) | ||
| 17411 | 17411 | 25526 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.43368067367201 | (37.7637593960329, -122.433680673672) | ||
| 17518 | 17518 | 25033 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004995.411590001 | 2104224.22732 | 37.7580814768833 | -122.425752691957 | (37.7580814768833, -122.425752691957) | |||
| 17575 | 17575 | 24996 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004898.747380001 | 2105973.30508 | 37.7628785677218 | -122.42621152066002 | (37.7628785677218, -122.42621152066) | |||
| 17620 | 17620 | 25096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005188.030230001 | 2100718.94336 | 37.748467664846295 | -122.42483715961001 | (37.7484676648463, -122.42483715961) | |||
| 17932 | 17932 | 24987 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6004879.52665 | 2106321.34538 | 37.7638331171148 | -122.42630277934799 | (37.7638331171148, -122.426302779348) | |||
| 18142 | 18142 | 13388 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 218 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5 | 5997667.5215300005 | 2098758.8322 | 37.7426580336411 | -122.45070150968999 | (37.7426580336411, -122.45070150969) | |||
| 18236 | 18236 | 25007 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004931.59557 | 2105384.6255099997 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | |||
| 18432 | 18432 | 25070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005125.726319999 | 2101888.99536 | 37.751676838028395 | -122.425135847862 | (37.7516768380284, -122.425135847862) | |||
| 18527 | 18527 | 25047 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.754832226347396 | -122.425437427413 | (37.7548322263474, -122.425437427413) | |||
| 19284 | 19284 | 25135 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005318.690690001 | 2098391.09531 | 37.742083304809206 | -122.424219803815 | (37.7420833048092, -122.424219803815) | |||
| 19492 | 19492 | 25148 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004781.85822 | 2108123.31219 | 37.7687753648286 | -122.426768919571 | (37.7687753648286, -122.426768919571) | |||
| 19585 | 19585 | 24338 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004443.4589 | 2107950.1478 | 37.76828075872071 | -122.42792707731 | (37.7682807587207, -122.42792707731) | ||
| 19687 | 19687 | 25091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1350 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005204.68058 | 2100428.03656 | 37.7476698420965 | -122.42475889070299 | (37.7476698420965, -122.424758890703) | |||
| 19946 | 19946 | 25514 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004037.0875 | 2107573.3112 | 37.7672230586461 | -122.429305801661 | (37.7672230586461, -122.429305801661) | ||
| 20630 | 20630 | 24974 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004833.67989 | 2107139.93189 | 37.7660781684855 | -122.426519640982 | (37.7660781684855, -122.426519640982) | |||
| 21445 | 21445 | 25496 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005866.13841 | 2109325.7941099997 | 37.772138336447 | -122.42310395199499 | (37.772138336447, -122.423103951995) | ||
| 21462 | 21462 | 25153 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004788.48534 | 2107965.7019599997 | 37.768342979778204 | -122.426734771418 | (37.7683429797782, -122.426734771418) | |||
| 21512 | 21512 | 25120 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005269.99247 | 2099258.02767 | 37.744460954018 | -122.424449836913 | (37.744460954018, -122.424449836913) | |||
| 21853 | 21853 | 25535 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003362.1302 | 2106920.4307 | 37.765392172561796 | -122.431593762963 | (37.7653921725618, -122.431593762963) | ||
| 21891 | 21891 | 25037 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005031.31461 | 2103614.04185 | 37.7564080795924 | -122.425585096976 | (37.7564080795924, -122.425585096976) | |||
| 22009 | 22009 | 24961 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.76770891277079 | -122.42667516163999 | (37.7677089127708, -122.42667516164) | ||
| 24559 | 24559 | 246349 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6003723.2107 | 2107266.4094 | 37.766362606026796 | -122.430369556243 | (37.7663626060268, -122.430369556243) | |||
| 36176 | 36176 | 246402 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | Width 0ft | 6004659.311000001 | 2108158.3365 | 37.7688646036969 | -122.42719529666901 | (37.7688646036969, -122.427195296669) | |||
| 38993 | 38993 | 248619 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1801x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6005765.0052 | 2109117.0426 | 37.7715594473913 | -122.42343893750099 | (37.7715594473913, -122.423438937501) | |||
| 54798 | 54798 | 246348 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2150x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003809.2361 | 2107348.5599 | 37.766593043924 | -122.430077871393 | (37.766593043924, -122.430077871393) | |||
| 58367 | 58367 | 132070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 6013297.802519999 | 2119184.84583 | 37.7996255806051 | -122.39808881644501 | (37.7996255806051, -122.398088816445) | |||
| 76348 | 76348 | 27944 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | |||
| 77825 | 77825 | 25016 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
| 78576 | 78576 | 25731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 501X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744005 | 2119020.8269614 | 37.799180234142106 | -122.39776600258999 | (37.7991802341421, -122.39776600259) | ||
| 81675 | 81675 | 25075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1198 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | |||
| 82580 | 82580 | 28021 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.796464038519396 | -122.39529961933201 | (37.7964640385194, -122.395299619332) | ||
| 85336 | 85336 | 25079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1162 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005068.3 | 2101554.8 | 37.7507559707678 | -122.42531065650499 | (37.7507559707678, -122.425310656505) | |||
| 87172 | 87172 | 26029 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 499X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6013385.9217822 | 2119009.0450001 | 37.7991477810775 | -122.397771551765 | (37.7991477810775, -122.397771551765) | ||
| 89841 | 89841 | 25748 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.40473704035801 | (37.805854321699, -122.404737040358) | ||
| 89908 | 89908 | 27997 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 91142 | 91142 | 28372 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 91779 | 91779 | 26017 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113668997 | 37.8026699057947 | -122.40098537237499 | (37.8026699057947, -122.400985372375) | ||
| 92759 | 92759 | 25076 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1184 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005073.9 | 2101453.9 | 37.750479239095604 | -122.42528411198299 | (37.7504792390956, -122.425284111983) | |||
| 93699 | 93699 | 25077 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1178 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005072.5 | 2101478.6 | 37.750546980486895 | -122.42529071074 | (37.7505469804869, -122.42529071074) | |||
| 95346 | 95346 | 96821 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
| 96124 | 96124 | 27767 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/10/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 100172 | 100172 | 25080 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1156 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005077.9 | 2101580.2 | 37.7508262556468 | -122.425279266089 | (37.7508262556468, -122.425279266089) | |||
| 101121 | 101121 | 27717 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 09/11/2000 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | |||
| 105106 | 105106 | 25746 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1101X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | ||
| 105677 | 105677 | 27827 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.797486624670704 | -122.395833154489 | (37.7974866246707, -122.395833154489) | |||
| 109422 | 109422 | 27866 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014921.77607 | 2116935.19701 | 37.793538888238395 | -122.39231180375 | (37.7935388882384, -122.39231180375) | ||
| 110274 | 110274 | 96826 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
| 113255 | 113255 | 25643 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 114920 | 114920 | 25677 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 350X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 120022 | 120022 | 27940 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 121975 | 121975 | 25078 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1166 DOLORES ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005069.8 | 2101528.7 | 37.7506843909536 | -122.42530361228901 | (37.7506843909536, -122.425303612289) | |||
| 123638 | 123638 | 27929 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
| 125860 | 125860 | 27766 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
| 126124 | 126124 | 25683 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 3X3 | 6015960.62101 | 2112553.15201 | 37.781564418481004 | -122.388411289639 | (37.781564418481, -122.388411289639) | ||
| 126653 | 126653 | 100537 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2010X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 8 | 6004815.4 | 2108376.1 | 37.7694713555808 | -122.426670904591 | (37.7694713555808, -122.426670904591) | |||
| 127945 | 127945 | 25787 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012271.38601 | 2120709.8440099997 | 37.803755634424206 | -122.401747862284 | (37.8037556344242, -122.401747862284) | ||
| 128307 | 128307 | 25736 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
| 138316 | 138316 | 119699 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 6x Octavia St Frontage West | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
| 140032 | 140032 | 25632 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 144953 | 144953 | 26025 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | ||
| 148059 | 148059 | 248621 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 132x McCoppin St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6005771.7237 | 2109102.262 | 37.7715192426118 | -122.42341464686501 | (37.7715192426118, -122.423414646865) | |||
| 170719 | 170719 | 194307 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200x The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 6015377.01126 | 2116388.0666 | 37.792061862225204 | -122.39069838843399 | (37.7920618622252, -122.390698388434) | |||
| 172221 | 172221 | 245963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6005062.3371 | 2108554.2304 | 37.7699744164919 | -122.425829439833 | (37.7699744164919, -122.425829439833) | |||
| 6748 | 6748 | 26030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014150.34723 | 2117905.1373099997 | 37.796159250800294 | -122.395048997307 | (37.7961592508003, -122.395048997307) | ||
| 7108 | 7108 | 25783 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013938.98446 | 2118296.9177 | 37.7972232315271 | -122.39580782638599 | (37.7972232315271, -122.395807826386) | ||
| 16962 | 16962 | 25071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005127.376540001 | 2101840.69033 | 37.751544296835206 | -122.42512670443001 | (37.7515442968352, -122.42512670443) | |||
| 17024 | 17024 | 25136 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.741947963130706 | -122.424208394127 | (37.7419479631307, -122.424208394127) | |||
| 17397 | 17397 | 25527 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2300X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002730.2479 | 2106324.2376 | 37.7637193356407 | -122.433736680672 | (37.7637193356407, -122.433736680672) | ||
| 17405 | 17405 | 24337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004420.4688 | 2107930.9893 | 37.7682268534635 | -122.428005232451 | (37.7682268534635, -122.428005232451) | ||
| 17629 | 17629 | 25102 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005226.05485 | 2100086.94121 | 37.7467344797311 | -122.424660718923 | (37.7467344797311, -122.424660718923) | |||
| 18585 | 18585 | 25121 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6005252.19486 | 2099522.95164 | 37.745187369700105 | -122.424530218294 | (37.7451873697001, -122.424530218294) | |||
| 18703 | 18703 | 24975 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 200 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004832.79825 | 2107115.15692 | 37.76601009251021 | -122.426520926121 | (37.7660100925102, -122.426520926121) | |||
| 18866 | 18866 | 25038 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005033.4036 | 2103578.1948599997 | 37.756309770193 | -122.425575321353 | (37.756309770193, -122.425575321353) | |||
| 19235 | 19235 | 24988 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 370X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6004888.10333 | 2106135.4070099997 | 37.7633230594236 | -122.426259876316 | (37.7633230594236, -122.426259876316) | |||
| 19325 | 19325 | 25154 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 50X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004786.45589 | 2107937.0696900003 | 37.7682642477152 | -122.42673975183901 | (37.7682642477152, -122.426739751839) | |||
| 20149 | 20149 | 25149 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20x10 | 6004775.29887 | 2108114.09165 | 37.768749676587205 | -122.42679095116002 | (37.7687496765872, -122.42679095116) | |||
| 20169 | 20169 | 24997 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/04/1999 12:00:00 AM | 70 | 20 | 6004897.70828 | 2105945.4375400003 | 37.7628019913498 | -122.426213130441 | (37.7628019913498, -122.426213130441) | ||
| 20326 | 20326 | 25115 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1550X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005272.16967 | 2099229.32207 | 37.7443822579348 | -122.424440267208 | (37.7443822579348, -122.424440267208) | |||
| 20716 | 20716 | 25082 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005158.72228 | 2101250.83835 | 37.7499264704292 | -122.424976344106 | (37.7499264704292, -122.424976344106) | |||
| 20879 | 20879 | 25092 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6005189.02223 | 2100681.47449 | 37.7483648399821 | -122.424831064022 | (37.7483648399821, -122.424831064022) | |||
| 20929 | 20929 | 25087 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1250X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005179.035519999 | 2100967.22192 | 37.7491488725392 | -122.42488592444401 | (37.7491488725392, -122.424885924444) | |||
| 21421 | 21421 | 25497 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005883.25661 | 2109339.92737 | 37.7721781089695 | -122.42304574337099 | (37.7721781089695, -122.423045743371) | ||
| 21602 | 21602 | 25126 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005303.102530001 | 2098649.37036 | 37.7427915892743 | -122.424292067924 | (37.7427915892743, -122.424292067924) | |||
| 21636 | 21636 | 24991 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004880.84753 | 2106292.81252 | 37.763754847342206 | -122.42629617923299 | (37.7637548473422, -122.426296179233) | |||
| 21723 | 21723 | 25536 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003342.0906 | 2106904.3991 | 37.7653470177984 | -122.43166193058599 | (37.7653470177984, -122.431661930586) | ||
| 21915 | 21915 | 25502 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005183.0311 | 2108665.831 | 37.7702876647003 | -122.425419904307 | (37.7702876647003, -122.425419904307) | ||
| 22145 | 22145 | 25515 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 10 | 6004020.8124 | 2107556.2611 | 37.767175321793 | -122.429360878869 | (37.767175321793, -122.429360878869) | ||
| 24676 | 24676 | 25027 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 740X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 20 | 6004958.5167563 | 2104022.9997464 | 37.75752686832129 | -122.425865966748 | (37.7575268683213, -122.425865966748) | |||
| 44570 | 44570 | 27941 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 64559 | 64559 | 246403 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6004628.6575 | 2108127.683 | 37.7687787030374 | -122.427299141169 | (37.7687787030374, -122.427299141169) | |||
| 69372 | 69372 | 25749 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.40473704035801 | (37.805854321699, -122.404737040358) | ||
| 77513 | 77513 | 27958 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982005 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) |
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");