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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5467 | 5467 | 27939 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013788.66429 | 2118525.16075 | 37.7978415693921 | -122.396343981507 | (37.7978415693921, -122.396343981507) | |||
| 7009 | 7009 | 27938 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013758.52527 | 2118508.2804400004 | 37.7977935429048 | -122.396447087875 | (37.7977935429048, -122.396447087875) | |||
| 8788 | 8788 | 27937 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013847.17816 | 2118440.8928400003 | 37.797613445554205 | -122.396135596873 | (37.7976134455542, -122.396135596873) | |||
| 9337 | 9337 | 113319 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005986.0 | 2109035.0 | 37.7713466487942 | -122.42266867187 | (37.7713466487942, -122.42266867187) | |||
| 9471 | 9471 | 18535 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 270 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6006489.0 | 2098160.0 | 37.74151478014 | -122.420156839009 | (37.74151478014, -122.420156839009) | |||
| 13733 | 13733 | 29537 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2600X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6015071.7012 | 2091079.6967 | 37.7225535544976 | -122.38998606447299 | (37.7225535544976, -122.389986064473) | |||
| 14133 | 14133 | 29536 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2600X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6015127.6919 | 2091149.846 | 37.7227492757118 | -122.38979741293699 | (37.7227492757118, -122.389797412937) | |||
| 14829 | 14829 | 95065 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 4801 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014916.5089 | 2095299.5463 | 37.7341318071091 | -122.390817297505 | (37.7341318071091, -122.390817297505) | |||
| 17598 | 17598 | 9369 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 276 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | 6001136.50681 | 2098095.27018 | 37.7410340073111 | -122.438659251142 | (37.7410340073111, -122.438659251142) | |||
| 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) | |||
| 80037 | 80037 | 86731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Pico Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.724367252780496 | -122.462549157922 | (37.7243672527805, -122.462549157922) | |||||
| 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) | ||||
| 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) | |||
| 101242 | 101242 | 27788 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 199X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 14 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 103830 | 103830 | 27697 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 10 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | |||
| 110630 | 110630 | 92744 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 627 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52968 | 6009200.0 | 2091312.0 | 37.722864017361395 | -122.41029969523998 | (37.7228640173614, -122.41029969524) | |||
| 110645 | 110645 | 27936 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 599X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6012976.7050292995 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | |||
| 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) | |||
| 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) | ||||
| 126077 | 126077 | 51202 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 567 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47573 | 6003673.55383836 | 2104968.22861825 | 37.760049541377796 | -122.43037732338999 | (37.7600495413778, -122.43037732339) | ||||
| 139986 | 139986 | 1443 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 151X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | |||
| 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) | ||||
| 142373 | 142373 | 87850 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 94 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50753 | 5997405.9 | 2099153.7 | 37.7437272652603 | -122.45163459365601 | (37.7437272652603, -122.451634593656) | |||
| 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) | ||||
| 94674 | 94674 | 27870 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015155.50001 | 2116672.0830099997 | 37.79282941355329 | -122.391484690649 | (37.7928294135533, -122.391484690649) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 78230 | 78230 | 27930 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 2 | 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) | ||
| 83420 | 83420 | 27948 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 5 | 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) | ||
| 91110 | 91110 | 27949 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 6 | 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) | ||
| 92133 | 92133 | 27942 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 3 | 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) | |||
| 95434 | 95434 | 27933 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 5 | 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) | ||
| 98325 | 98325 | 27947 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 4 | 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) | ||
| 106831 | 106831 | 27951 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 8 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 77877 | 77877 | 28025 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.796072794607895 | -122.39497787369301 | (37.7960727946079, -122.394977873693) | ||
| 78636 | 78636 | 28030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.8700099997 | 37.795577730351205 | -122.39443938464899 | (37.7955777303512, -122.394439384649) | ||
| 79708 | 79708 | 27959 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 3 | 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) | |||
| 81176 | 81176 | 27963 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1101X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | ||
| 81297 | 81297 | 28024 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.300009999 | 2117911.2250099997 | 37.7961756855245 | -122.39506688844999 | (37.7961756855245, -122.39506688845) | ||
| 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) | ||
| 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) | ||
| 92971 | 92971 | 28023 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | ||
| 93856 | 93856 | 27960 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 307X The Embarcadero | 4 | 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) | |||
| 94898 | 94898 | 28032 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 12 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | ||
| 102648 | 102648 | 28027 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014263.57201 | 2117754.9750099997 | 37.795753235969 | -122.394646693031 | (37.795753235969, -122.394646693031) | ||
| 104366 | 104366 | 28002 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 6 | 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) | ||
| 104388 | 104388 | 28031 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 11 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | ||
| 106008 | 106008 | 28003 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 7 | 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) | ||
| 107611 | 107611 | 28000 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 4 | 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) | ||
| 111881 | 111881 | 27998 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 2 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 34895 | 34895 | 67033 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 174 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1992 12:00:00 AM | 30 | 5x5 | Permit Number 30405 | 5992451.37715 | 2114312.24159 | 37.7850636224737 | -122.469869417746 | (37.7850636224737, -122.469869417746) | |
| 37148 | 37148 | 96681 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985880.88078 | 2113443.18167 | 37.7822954478301 | -122.49253691723301 | (37.7822954478301, -122.492536917233) | ||
| 87101 | 87101 | 96694 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 103442 | 103442 | 96695 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 106263 | 106263 | 96692 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 107261 | 107261 | 96693 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 3132@32nd Ave Clement St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | Permit Number 768040 | 5985890.0 | 2113240.0 | 37.7817381026149 | -122.49249040156602 | (37.7817381026149, -122.492490401566) | |||
| 147563 | 147563 | 96683 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 28 | Permit Number 768040 | 5985881.4573800005 | 2113426.06761 | 37.782248491261605 | -122.49253366172199 | (37.7822484912616, -122.492533661722) | ||
| 186098 | 186098 | 96686 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985884.08947 | 2113350.81045 | 37.7820420106561 | -122.49251901199499 | (37.7820420106561, -122.492519011995) | ||
| 78875 | 78875 | 27848 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015938.91901 | 2112416.43301 | 37.7811878161514 | -122.388476823036 | (37.7811878161514, -122.388476823036) | ||
| 83890 | 83890 | 27801 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 90111 | 90111 | 27847 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 8 | 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) | |||
| 99547 | 99547 | 27845 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 6 | 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) | |||
| 100729 | 100729 | 27843 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 4 | 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) | |||
| 105556 | 105556 | 27842 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 3 | 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) | |||
| 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) | |||
| 109189 | 109189 | 27850 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015895.51701 | 2112292.73501 | 37.7808457639334 | -122.38861833648701 | (37.7808457639334, -122.388618336487) | ||
| 110061 | 110061 | 27844 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 280 The Embarcadero | 5 | 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 724 | 724 | 25734 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.1858599996 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | ||
| 1312 | 1312 | 25735 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013816.07307 | 2118422.78251 | 37.7975619881486 | -122.396241959692 | (37.7975619881486, -122.396241959692) | ||
| 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) | ||
| 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) |
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");