Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▲ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112720 | 112720 | 27781 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 4 | 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) | |||
| 112807 | 112807 | 25802 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 112942 | 112942 | 25754 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 7 | 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) | ||
| 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) | ||
| 113256 | 113256 | 25744 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 9 | 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) | ||
| 113720 | 113720 | 25743 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 8 | 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) | ||
| 114362 | 114362 | 25635 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 4 | 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) | ||
| 114665 | 114665 | 27950 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 114765 | 114765 | 27804 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 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) | ||
| 114962 | 114962 | 27698 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 11 | Median : Cutout 11 | Tree 1 | Port 9 | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | |||
| 115229 | 115229 | 27932 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 4 | 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) | ||
| 115397 | 115397 | 28022 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014106.23701 | 2117977.41401 | 37.796355252616294 | -122.39520669408002 | (37.7963552526163, -122.39520669408) | ||
| 115406 | 115406 | 27868 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015038.31301 | 2116806.19801 | 37.793191157262704 | -122.39189954881 | (37.7931911572627, -122.39189954881) | ||
| 115875 | 115875 | 27841 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 2 | 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) | |||
| 116513 | 116513 | 27946 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 116990 | 116990 | 25800 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 117219 | 117219 | 25750 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 3 | 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) | ||
| 117445 | 117445 | 27852 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015817.39201 | 2112182.05801 | 37.780537539741395 | -122.388880882265 | (37.7805375397414, -122.388880882265) | ||
| 117750 | 117750 | 25678 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 350X The Embarcadero | 2 | 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) | ||
| 117908 | 117908 | 28001 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 5 | 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) | ||
| 117942 | 117942 | 25633 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 2 | 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) | ||
| 118074 | 118074 | 27961 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 5 | 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) | |||
| 118319 | 118319 | 27846 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 7 | 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) | |||
| 118790 | 118790 | 27869 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015100.81301 | 2116738.49001 | 37.7930087163181 | -122.39167855690701 | (37.7930087163181, -122.391678556907) | ||
| 118808 | 118808 | 25681 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 350X The Embarcadero | 5 | 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) | ||
| 118856 | 118856 | 25739 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 4 | 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) | ||
| 118985 | 118985 | 25791 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012561.75001 | 2120285.36501 | 37.802606317276 | -122.40071319691499 | (37.802606317276, -122.400713196915) | ||
| 119199 | 119199 | 27935 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 7 | 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) | ||
| 119621 | 119621 | 26019 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 3 | 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) | ||
| 119973 | 119973 | 27999 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 3 | 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) | ||
| 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) | |||
| 120030 | 120030 | 25794 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012712.79201 | 2120057.50001 | 37.8019890781012 | -122.40017449968501 | (37.8019890781012, -122.400174499685) | ||
| 120266 | 120266 | 27849 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015921.55801 | 2112354.58401 | 37.7810170305764 | -122.388532565578 | (37.7810170305764, -122.388532565578) | ||
| 120310 | 120310 | 27785 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 120825 | 120825 | 25789 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012378.15701 | 2120553.5940099997 | 37.8033325675946 | -122.40136738582899 | (37.8033325675946, -122.401367385829) | ||
| 121752 | 121752 | 27776 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.39634576874799 | (37.797431381421, -122.396345768748) | |||
| 123015 | 123015 | 25788 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012327.37501 | 2120629.11501 | 37.8035370964877 | -122.401548430804 | (37.8035370964877, -122.401548430804) | ||
| 123608 | 123608 | 28026 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.39468200241699 | (37.795812278914, -122.394682002417) | ||
| 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) | ||
| 124202 | 124202 | 25733 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 501X The Embarcadero | 3 | 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) | ||
| 124284 | 124284 | 26018 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 2 | 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) | ||
| 125282 | 125282 | 27867 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014979.71901 | 2116870.00001 | 37.7933630896865 | -122.392106753362 | (37.7933630896865, -122.392106753362) | ||
| 125734 | 125734 | 25647 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 5 | 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) | ||
| 125804 | 125804 | 25634 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 3 | 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) | ||
| 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) | ||
| 126250 | 126250 | 26096 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 499X The Embarcadero | 4 | 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) | ||
| 126593 | 126593 | 26022 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 6 | 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) | ||
| 126813 | 126813 | 25644 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 2 | 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) | ||
| 127099 | 127099 | 27943 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 4 | 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) | |||
| 127804 | 127804 | 25792 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012611.22901 | 2120208.54201 | 37.802398139421705 | -122.400536574048 | (37.8023981394217, -122.400536574048) | ||
| 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) | ||
| 127947 | 127947 | 26028 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 4 | 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) | ||
| 128206 | 128206 | 27931 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 3 | 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) | ||
| 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) | ||
| 128560 | 128560 | 26023 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 7 | 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) | ||
| 138363 | 138363 | 25645 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 3 | 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) | ||
| 139415 | 139415 | 27774 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 299X The Embarcadero | 2 | 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) | |||
| 139779 | 139779 | 27853 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.780403982219205 | -122.389031454309 | (37.7804039822192, -122.389031454309) | ||
| 139983 | 139983 | 27851 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.5390099995 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | ||
| 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) | ||
| 140237 | 140237 | 26020 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 4 | 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) | ||
| 140551 | 140551 | 25801 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 140643 | 140643 | 27786 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 140710 | 140710 | 27962 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 6 | 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) | |||
| 140893 | 140893 | 27783 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 6 | 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) | |||
| 141888 | 141888 | 25751 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 4 | 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) | ||
| 142211 | 142211 | 28029 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 9 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.7420099997 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | ||
| 142246 | 142246 | 25740 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 5 | 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) | ||
| 142949 | 142949 | 25680 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 350X The Embarcadero | 4 | 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) | ||
| 143792 | 143792 | 27934 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 6 | 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) | ||
| 144240 | 144240 | 27945 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 144442 | 144442 | 26021 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 899X The Embarcadero | 5 | 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) | ||
| 144544 | 144544 | 27779 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 2 | 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) | |||
| 144869 | 144869 | 26027 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 3 | 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) | ||
| 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) | ||
| 144979 | 144979 | 28028 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) | ||
| 145407 | 145407 | 27787 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 146321 | 146321 | 25753 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 6 | 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) | ||
| 101187 | 101187 | 5485 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 3463 | 3463 | 25005 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 20 | 6004909.6221900005 | 2105744.1135299997 | 37.7622498768445 | -122.426157591005 | (37.7622498768445, -122.426157591005) | |||
| 11148 | 11148 | 20065 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY54 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 15ST | ||||||||
| 13621 | 13621 | 18556 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014603.96741 | 2095108.67042 | 37.7335903547148 | -122.391884517749 | (37.7335903547148, -122.391884517749) | |||
| 14049 | 14049 | 18560 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014546.06488 | 2095149.2171099999 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | |||
| 15304 | 15304 | 19794 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 16559 | 16559 | 18559 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014565.4208 | 2095135.4289 | 37.733661688034104 | -122.392019656183 | (37.7336616880341, -122.392019656183) | |||
| 16768 | 16768 | 18555 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 19 | 6014626.04256 | 2095092.9200799998 | 37.733548332979105 | -122.39180709603201 | (37.7335483329791, -122.391807096032) | |||
| 16811 | 16811 | 18551 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014649.71614 | 2095074.3239900002 | 37.733498586072294 | -122.391723949223 | (37.7334985860723, -122.391723949223) | |||
| 16918 | 16918 | 25119 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005258.69008 | 2099408.1764 | 37.7448725899054 | -122.42449959638999 | (37.7448725899054, -122.42449959639) | |||
| 16926 | 16926 | 24992 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 340 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004882.50848 | 2106257.6214799997 | 37.763658315014204 | -122.426287928865 | (37.7636583150142, -122.426287928865) | |||
| 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) | |||
| 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) | |||
| 17005 | 17005 | 25139 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.741704348480795 | -122.42418177058599 | (37.7417043484808, -122.424181770586) | |||
| 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) | |||
| 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) | |||
| 17078 | 17078 | 25113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005228.94357 | 2100007.06865 | 37.7465153311328 | -122.424645049125 | (37.7465153311328, -122.424645049125) | |||
| 17125 | 17125 | 25503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1900X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005164.8443 | 2108651.7776 | 37.7702480498919 | -122.42548181214701 | (37.7702480498919, -122.425481812147) | ||
| 17149 | 17149 | 25538 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003277.964 | 2106841.2745 | 37.7651700578839 | -122.431879221699 | (37.7651700578839, -122.431879221699) | ||
| 17224 | 17224 | 25054 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6005073.8483 | 2102816.15893 | 37.7542196827988 | -122.42538122246201 | (37.7542196827988, -122.425381222462) |
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");