Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1665 | 1665 | 251650 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | |||||||||
| 1954 | 1954 | 20331 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 8246 | 8246 | 20349 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 9565 | 9565 | 20409 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 9606 | 9606 | 20333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 10242 | 10242 | 20328 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 11483 | 11483 | 20348 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 12000 | 12000 | 20347 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 8 | ||||||||
| 12183 | 12183 | 20411 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 12674 | 12674 | 20327 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 101X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 12828 | 12828 | 20459 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 495X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 14471 | 14471 | 20350 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 103X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 8 | ||||||||
| 14576 | 14576 | 20410 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 451X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10 | ||||||||
| 10449 | 10449 | 98333 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 12X Canyon Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 99 | 6003235.70781 | 2086338.01389 | 37.708870401808205 | -122.43056224915199 | (37.7088704018082, -122.430562249152) | ||||
| 13182 | 13182 | 1306 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 4001 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X6 | 5991941.83628 | 2087094.05513 | 37.7103000369794 | -122.469650093897 | (37.7103000369794, -122.469650093897) | |||
| 21816 | 21816 | 19067 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 181 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X6 | 5995183.65728 | 2087383.7822 | 37.711282396136106 | -122.458466724769 | (37.7112823961361, -122.458466724769) | |||
| 19954 | 19954 | 19056 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995399.90932 | 2087379.93977 | 37.7112842712213 | -122.45771903023001 | (37.7112842712213, -122.45771903023) | |||
| 145938 | 145938 | 19047 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 121 Sagamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 5995696.4497884 | 2087392.1121528998 | 37.711334724785296 | -122.456694997796 | (37.7113347247853, -122.456694997796) | |||
| 20969 | 20969 | 19080 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 222 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5994789.79995 | 2087468.8436599998 | 37.711493312329104 | -122.45983414305701 | (37.7114933123291, -122.459834143057) | |||
| 18827 | 18827 | 19077 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 214 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 5994888.1662 | 2087467.46648 | 37.7114951874196 | -122.459494066213 | (37.7114951874196, -122.459494066213) | |||
| 17155 | 17155 | 19075 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 210 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5994852.87647 | 2087468.5468 | 37.7114961245189 | -122.459616114113 | (37.7114961245189, -122.459616114113) | |||
| 18849 | 18849 | 19061 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 170 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5995253.52383 | 2087462.2076 | 37.7115017488875 | -122.45823092253599 | (37.7115017488875, -122.458230922536) | |||
| 21765 | 21765 | 19060 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 168 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5995281.6457400005 | 2087462.6432700001 | 37.71150456104971 | -122.458133757993 | (37.7115045610497, -122.458133757993) | |||
| 109769 | 109769 | 19084 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 228 SAGAMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5994709.0 | 2087484.0 | 37.711530280980504 | -122.4601145042 | (37.7115302809805, -122.4601145042) | |||
| 10881 | 10881 | 1170 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2900 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5996939.82993 | 2087557.20875 | 37.711859355284204 | -122.45240948860099 | (37.7118593552842, -122.452409488601) | |||
| 12680 | 12680 | 1833 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2174 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6011634.522580001 | 2087511.81203 | 37.712565639665705 | -122.40161704481301 | (37.7125656396657, -122.401617044813) | |||
| 12258 | 12258 | 1155 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2700 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5997899.99425 | 2088293.2375900003 | 37.7139352846675 | -122.44914389918199 | (37.7139352846675, -122.449143899182) | |||
| 10684 | 10684 | 1109 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2362 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5999292.86989 | 2089155.09159 | 37.716381308429206 | -122.44439151548201 | (37.7163813084292, -122.444391515482) | |||
| 10510 | 10510 | 1087 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2174 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5999920.01803 | 2089753.43888 | 37.718059997362396 | -122.442266720544 | (37.7180599973624, -122.442266720544) | |||
| 21948 | 21948 | 413 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3854 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 8 | 2X3 | 5990824.06176 | 2090161.99601 | 37.7186591841634 | -122.47373697479401 | (37.7186591841634, -122.473736974794) | ||
| 116026 | 116026 | 1065 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2071X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6000361.32249 | 2090050.85473 | 37.7189017758401 | -122.440762648624 | (37.7189017758401, -122.440762648624) | |||
| 12553 | 12553 | 1045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2003X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000641.86431 | 2090326.5948 | 37.719674868584704 | -122.43981268741999 | (37.7196748685847, -122.43981268742) | |||
| 142119 | 142119 | 1043 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2000 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X5 | 6000617.15273 | 2090448.0855 | 37.7200070478885 | -122.43990681257799 | (37.7200070478885, -122.439906812578) | |||
| 13520 | 13520 | 29553 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014413.8304 | 2090200.1114 | 37.7201018801983 | -122.39219870906601 | (37.7201018801983, -122.392198709066) | |||
| 14160 | 14160 | 29552 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014430.2753 | 2090217.7745 | 37.720151292667495 | -122.392143098776 | (37.7201512926675, -122.392143098776) | |||
| 103182 | 103182 | 29554 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014438.8118347 | 2090233.7051406002 | 37.7201955090298 | -122.39211470411699 | (37.7201955090298, -122.392114704117) | |||
| 114413 | 114413 | 29555 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014438.8118347 | 2090233.7051406002 | 37.7201955090298 | -122.39211470411699 | (37.7201955090298, -122.392114704117) | |||
| 120833 | 120833 | 29558 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014438.8118347 | 2090233.7051406002 | 37.7201955090298 | -122.39211470411699 | (37.7201955090298, -122.392114704117) | |||
| 15135 | 15135 | 29551 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014443.0659 | 2090235.4376 | 37.720200502216294 | -122.39210012020901 | (37.7202005022163, -122.392100120209) | |||
| 102131 | 102131 | 29550 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3000X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6014485.674235599 | 2090296.5698245 | 37.7203707248314 | -122.391957108854 | (37.7203707248314, -122.391957108854) | |||
| 44181 | 44181 | 11759 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 901X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 126341 | 126341 | 11756 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 901X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 10868 | 10868 | 1003 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1750 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001350.47669 | 2091970.9547 | 37.7242302198351 | -122.43748096390101 | (37.7242302198351, -122.437480963901) | |||
| 78239 | 78239 | 1002 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1731 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | |||
| 10640 | 10640 | 998 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1720 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4X4 | 6001400.68712 | 2092099.7720700002 | 37.7245867776358 | -122.43731661368601 | (37.7245867776358, -122.437316613686) | |||
| 84809 | 84809 | 19112 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6001466.92892 | 2092175.6962599999 | 37.724799013784796 | -122.437093058152 | (37.7247990137848, -122.437093058152) | |||
| 99973 | 99973 | 19113 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X6 | 6001466.92892 | 2092175.6962599999 | 37.724799013784796 | -122.437093058152 | (37.7247990137848, -122.437093058152) | |||
| 12386 | 12386 | 996 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1683 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X6 | 6001571.37803 | 2092269.72252 | 37.7250631251444 | -122.436738718312 | (37.7250631251444, -122.436738718312) | |||
| 11445 | 11445 | 993 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1678 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 4x4 | 6001520.694019999 | 2092363.0865 | 37.725316600860204 | -122.43692060802 | (37.7253166008602, -122.43692060802) | |||
| 143835 | 143835 | 16702 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1637X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 1X1 | 6001654.26911 | 2092452.8503299998 | 37.725570663103106 | -122.436465274251 | (37.7255706631031, -122.436465274251) | |||
| 11798 | 11798 | 990 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1660 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001575.36599 | 2092477.83222 | 37.7256347738177 | -122.43673982271099 | (37.7256347738177, -122.436739822711) | |||
| 12061 | 12061 | 988 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1650 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6001605.56044 | 2092548.13054 | 37.7258295130094 | -122.43664047277299 | (37.7258295130094, -122.436640472773) | |||
| 10675 | 10675 | 982 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1604 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6001730.40867 | 2092823.64801 | 37.7265931156608 | -122.4362285905 | (37.7265931156608, -122.4362285905) | |||
| 10416 | 10416 | 971 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1599 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 6001877.39832 | 2092933.59931 | 37.7269033673725 | -122.43572831651501 | (37.7269033673725, -122.435728316515) | |||
| 13216 | 13216 | 972 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1599 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6001888.30681 | 2092957.5679400002 | 37.7269697994111 | -122.43569232024099 | (37.7269697994111, -122.435692320241) | |||
| 14185 | 14185 | 22380 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 6 | 3x3 | 6014144.1347 | 2092787.3564 | 37.7271909591273 | -122.393311918955 | (37.7271909591273, -122.393311918955) | ||
| 77573 | 77573 | 28277 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 5545 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6014154.46846 | 2092818.34328 | 37.7272766169672 | -122.393278362397 | (37.7272766169672, -122.393278362397) | |||
| 4955 | 4955 | 253734 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4956 | 4956 | 253729 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4965 | 4965 | 253732 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4968 | 4968 | 253724 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4982 | 4982 | 253733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4986 | 4986 | 253726 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 4993 | 4993 | 253727 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5004 | 5004 | 253731 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5021 | 5021 | 253725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5028 | 5028 | 253730 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5029 | 5029 | 251680 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 5037 | 5037 | 253728 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Girard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x12 | 6010529.0 | 2093052.0 | 37.7277161040977 | -122.405828105175 | (37.7277161040977, -122.405828105175) | ||||
| 11895 | 11895 | 292 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 2 | 5990518.982340001 | 2093604.8167400002 | 37.7280946372571 | -122.475042684288 | (37.7280946372571, -122.475042684288) | ||
| 5212 | 5212 | 291 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1994 12:00:00 AM | 20 | 2x10 | 5990518.299980001 | 2093633.8541299999 | 37.7281743270786 | -122.475047162015 | (37.7281743270786, -122.475047162015) | ||
| 5237 | 5237 | 290 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2017 12:00:00 AM | 25 | 2X2 | 5990524.87284 | 2093730.4583599998 | 37.728439958917704 | -122.47503148863001 | (37.7284399589177, -122.47503148863) | ||
| 10577 | 10577 | 289 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/1994 12:00:00 AM | 25 | 2 | 5990526.76624 | 2093758.79648 | 37.7285178779945 | -122.475027010894 | (37.7285178779945, -122.475027010894) | ||
| 12467 | 12467 | 288 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 18 | 2 | 5990528.50995 | 2093780.0430700001 | 37.7285763168388 | -122.475022533176 | (37.7285763168388, -122.475022533176) | ||
| 13129 | 13129 | 286 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1998 12:00:00 AM | 20 | 2 | 5990533.76855 | 2093845.0720799998 | 37.728755174887795 | -122.475009099088 | (37.7287551748878, -122.475009099088) | ||
| 12261 | 12261 | 285 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3355 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/1998 12:00:00 AM | 20 | 2 | 5990533.55676 | 2093865.7150400002 | 37.728811842983106 | -122.47501133751999 | (37.7288118429831, -122.47501133752) | ||
| 10852 | 10852 | 945 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1418 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002308.48218 | 2093739.6046799999 | 37.7291409525794 | -122.43429566951401 | (37.7291409525794, -122.434295669514) | |||
| 18283 | 18283 | 274 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3210 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 20 | 2X3 | 5990651.757780001 | 2094310.81175 | 37.730040816024704 | -122.47463518438101 | (37.7300408160247, -122.474635184381) | ||
| 22098 | 22098 | 275 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3210 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 20 | 2X3 | 5990662.18152 | 2094375.08558 | 37.7302178997362 | -122.47460383761299 | (37.7302178997362, -122.474603837613) | ||
| 103658 | 103658 | 920 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1250 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X6 | 6002950.328840001 | 2094206.9021299998 | 37.7304604561159 | -122.43211011174401 | (37.7304604561159, -122.432110111744) | |||
| 12395 | 12395 | 911 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1226 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 5x8 | 6003062.670580001 | 2094235.77356 | 37.7305460992123 | -122.431723791042 | (37.7305460992123, -122.431723791042) | |||
| 85264 | 85264 | 261 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/25/1994 12:00:00 AM | 12 | 2X3 | 5990658.74483 | 2094624.5636900002 | 37.730902704527395 | -122.474633919299 | (37.7309027045274, -122.474633919299) | ||
| 84108 | 84108 | 886 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X ALEMANY BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X6 | 6003437.0 | 2094359.0 | 37.7309056628368 | -122.43043846836599 | (37.7309056628368, -122.430438468366) | |||
| 20338 | 20338 | 260 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3100 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4x4 | 5990641.60602 | 2094627.68915 | 37.730910293152796 | -122.474693398398 | (37.7309102931528, -122.474693398398) | |||
| 18484 | 18484 | 12450 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 84810 | 84810 | 12452 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 104060 | 104060 | 12451 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 122168 | 122168 | 12453 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 127553 | 127553 | 12454 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 127742 | 127742 | 12455 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Lake Merced Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 5983914.9541303 | 2094860.2401332 | 37.7311567434968 | -122.497965345854 | (37.7311567434968, -122.497965345854) | |||
| 20224 | 20224 | 254 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3080 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 12:00:00 AM | 13 | 2 | 5990635.11986 | 2094780.67442 | 37.7313299761991 | -122.474726983585 | (37.7313299761991, -122.474726983585) | ||
| 11974 | 11974 | 256 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3095 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990551.14028 | 2094790.83071 | 37.7313529961409 | -122.475018054557 | (37.7313529961409, -122.475018054557) | |||
| 21787 | 21787 | 249 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3060 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1994 12:00:00 AM | 7 | 2 | 5990633.958819999 | 2094848.4163099998 | 37.7315159110224 | -122.47473593992201 | (37.7315159110224, -122.474735939922) | ||
| 20642 | 20642 | 248 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3050 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1994 12:00:00 AM | 20 | 2 | 5990629.27539 | 2094902.6887400001 | 37.7316646579979 | -122.474756091044 | (37.7316646579979, -122.474756091044) | ||
| 11923 | 11923 | 87592 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3039 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5990542.943940001 | 2094954.8149599999 | 37.731802780363104 | -122.475058356779 | (37.7318027803631, -122.475058356779) | ||||
| 11463 | 11463 | 244 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3027 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 20 | 2 | 5990542.03599 | 2095003.8484200002 | 37.731937361205 | -122.475065073818 | (37.731937361205, -122.475065073818) | ||
| 12400 | 12400 | 243 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3027 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990541.3262 | 2095031.59495 | 37.732013505011295 | -122.475069552433 | (37.7320135050113, -122.475069552433) | ||
| 11685 | 11685 | 242 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990541.155259999 | 2095054.1708099998 | 37.7320754826964 | -122.47507179083401 | (37.7320754826964, -122.475071790834) | ||
| 11341 | 11341 | 241 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/1994 12:00:00 AM | 20 | 2 | 5990539.35496 | 2095091.6143599998 | 37.73217818885811 | -122.47508074718701 | (37.7321781888581, -122.475080747187) | ||
| 104705 | 104705 | 17174 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2999X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2 | 5990529.29755 | 2095287.65599 | 37.732715886567995 | -122.475129823758 | (37.732715886568, -122.475129823758) |
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");