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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
166867 | 166867 | 132106 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011673.52168 | 2121373.1691 | 37.8055435810345 | -122.40386352159099 | (37.8055435810345, -122.403863521591) | |||
168474 | 168474 | 132105 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6012001.46692 | 2121074.30881 | 37.8047412994387 | -122.402707584299 | (37.8047412994387, -122.402707584299) | |||
172221 | 172221 | 245963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6005062.3371 | 2108554.2304 | 37.7699744164919 | -122.425829439833 | (37.7699744164919, -122.425829439833) | |||
176298 | 176298 | 247642 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 632 Banks St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 4ft | 6008490.96565 | 2095907.56445 | 37.7354426820387 | -122.41307547425501 | (37.7354426820387, -122.413075474255) | |||
183995 | 183995 | 194395 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 5ft | 6014427.53162 | 2089348.9061599998 | 37.7177653992236 | -122.392091851971 | (37.7177653992236, -122.392091851971) | |||
26160 | 26160 | 194311 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 7ft | 6015171.2298099995 | 2116694.38601 | 37.79289152546961 | -122.39143182424401 | (37.7928915254696, -122.391431824244) | |||
27286 | 27286 | 132113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.39797700193701 | (37.7996825238869, -122.397977001937) | |||
41127 | 41127 | 132091 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011272.98764 | 2121658.8993 | 37.806305741188204 | -122.405269766312 | (37.8063057411882, -122.405269766312) | |||
50014 | 50014 | 132109 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011459.50109 | 2121569.1071 | 37.8060696196846 | -122.40461797546301 | (37.8060696196846, -122.404617975463) | |||
62222 | 62222 | 132090 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011358.77785 | 2121601.92287 | 37.8061540939119 | -122.40496885853999 | (37.8061540939119, -122.40496885854) | |||
63890 | 63890 | 234360 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005142.56045 | 2101579.1271 | 37.7508269625113 | -122.425055587855 | (37.7508269625113, -122.425055587855) | ||||
65398 | 65398 | 132082 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012375.04896 | 2120549.1986599998 | 37.803320325622295 | -122.40137783233999 | (37.8033203256223, -122.40137783234) | |||
75574 | 75574 | 132078 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012663.130340001 | 2120132.51785 | 37.8021922897941 | -122.40035162582899 | (37.8021922897941, -122.400351625829) | |||
123736 | 123736 | 234368 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | ||||
150555 | 150555 | 132096 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012742.85934 | 2120080.46122 | 37.8020538004962 | -122.400072065282 | (37.8020538004962, -122.400072065282) | |||
173586 | 173586 | 194339 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 8ft | 6015964.49017 | 2112481.16819 | 37.781366981449295 | -122.388392878343 | (37.7813669814493, -122.388392878343) | |||
176286 | 176286 | 132079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.40053431322399 | (37.8023972264213, -122.400534313224) | |||
181994 | 181994 | 132108 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6011532.668269999 | 2121506.48507 | 37.8059017639302 | -122.404360356561 | (37.8059017639302, -122.404360356561) | |||
38595 | 38595 | 234356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004985.9304599995 | 2104422.99085 | 37.7586266989802 | -122.42579962935301 | (37.7586266989802, -122.425799629353) | ||||
55424 | 55424 | 210903 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1939 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5991246.46009 | 2102193.40392 | 37.7517188372786 | -122.47315388853599 | (37.7517188372786, -122.473153888536) | |||
59618 | 59618 | 132097 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012695.81427 | 2120154.0888900002 | 37.8022533411719 | -122.400240038841 | (37.8022533411719, -122.400240038841) | |||
64753 | 64753 | 233931 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 451 Florida St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 9ft | 6009251.45318 | 2106264.05651 | 37.763921969247704 | -122.411177507234 | (37.7639219692477, -122.411177507234) | |||
70595 | 70595 | 132088 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6011509.10408 | 2121480.92062 | 37.8058302534199 | -122.404440103948 | (37.8058302534199, -122.404440103948) | |||
72003 | 72003 | 194321 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014800.62587 | 2117118.44333 | 37.794035312034104 | -122.392743821769 | (37.7940353120341, -122.392743821769) | |||
129992 | 129992 | 132099 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6012592.45443 | 2120302.68635 | 37.8026555899447 | -122.40060816104099 | (37.8026555899447, -122.400608161041) | |||
149311 | 149311 | 132111 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6011290.22315 | 2121683.26622 | 37.806373610322105 | -122.40521183646999 | (37.8063736103221, -122.40521183647) | |||
157078 | 157078 | 120819 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 101 20th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5989573.42956 | 2114582.3778 | 37.7856385654779 | -122.47984587101999 | (37.7856385654779, -122.47984587102) | |||
162235 | 162235 | 194317 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014996.79198 | 2116890.75749 | 37.7934210328094 | -122.392049131461 | (37.7934210328094, -122.392049131461) | |||
182038 | 182038 | 234353 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004972.999969999 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | ||||
182110 | 182110 | 194322 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 7ft | 6014773.3420400005 | 2117151.64182 | 37.7941249519603 | -122.392840551058 | (37.7941249519603, -122.392840551058) | |||
182470 | 182470 | 132107 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6011604.73213 | 2121437.1460700002 | 37.805715402812204 | -122.40410608402901 | (37.8057154028122, -122.404106084029) | |||
25390 | 25390 | 132077 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012714.4120000005 | 2120058.1365799997 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | |||
27355 | 27355 | 234354 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004979.813630001 | 2104508.3497200003 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | ||||
32862 | 32862 | 132075 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | |||
42394 | 42394 | 201687 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010195.30306 | 2109846.89146 | 37.7738124981919 | -122.408165701983 | (37.7738124981919, -122.408165701983) | ||||
58367 | 58367 | 132070 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 6013297.802519999 | 2119184.84583 | 37.7996255806051 | -122.39808881644501 | (37.7996255806051, -122.398088816445) | |||
61544 | 61544 | 132098 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012646.4501 | 2120224.08688 | 37.802442786052396 | -122.40041578348699 | (37.8024427860524, -122.400415783487) | |||
62709 | 62709 | 132071 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013261.919290001 | 2119233.02284 | 37.7997558644996 | -122.39821636821199 | (37.7997558644996, -122.398216368212) | |||
68393 | 68393 | 132116 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013189.6161 | 2119421.22304 | 37.800268589579204 | -122.39847977871901 | (37.8002685895792, -122.398479778719) | |||
70617 | 70617 | 132083 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012328.94165 | 2120621.527 | 37.8035163490725 | -122.401542475719 | (37.8035163490725, -122.401542475719) | |||
76777 | 76777 | 132095 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012798.77066 | 2120004.26494 | 37.801847701082394 | -122.39987323058901 | (37.8018477010824, -122.399873230589) | |||
131012 | 131012 | 234358 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6004991.05597 | 2104342.31446 | 37.7584054702508 | -122.425776160656 | (37.7584054702508, -122.425776160656) | ||||
131405 | 131405 | 194320 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 7ft | 6014831.89764 | 2117081.36813 | 37.7939352489635 | -122.392633022622 | (37.7939352489635, -122.392633022622) | |||
132937 | 132937 | 234364 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1150x Dolores St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005148.136969999 | 2101464.62312 | 37.7505128760752 | -122.425028157637 | (37.7505128760752, -122.425028157637) | ||||
147998 | 147998 | 132115 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6013243.85901 | 2119336.7003900004 | 37.8000395322586 | -122.398286142085 | (37.8000395322586, -122.398286142085) | |||
150698 | 150698 | 234330 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005083.062580001 | 2102603.58555 | 37.7536365264144 | -122.42533423108699 | (37.7536365264144, -122.425334231087) | ||||
153490 | 153490 | 132085 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6012153.585109999 | 2120867.04559 | 37.8041806971541 | -122.402166580042 | (37.8041806971541, -122.402166580042) | |||
155474 | 155474 | 132089 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6011437.6783 | 2121540.455 | 37.805989728403894 | -122.404691478852 | (37.8059897284039, -122.404691478852) | |||
167096 | 167096 | 234328 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005051.1738 | 2103243.46642 | 37.7553916882954 | -122.425490044948 | (37.7553916882954, -122.425490044948) | ||||
168748 | 168748 | 132110 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6011374.63029 | 2121626.67271 | 37.8062229369941 | -122.404915741893 | (37.8062229369941, -122.404915741893) | |||
177164 | 177164 | 234402 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002514.48058 | 2108813.7305400004 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | |||
181231 | 181231 | 234403 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 175 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6006066.151819999 | 2108969.9418900004 | 37.771172536524794 | -122.42238679931101 | (37.7711725365248, -122.422386799311) | |||
184903 | 184903 | 201683 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 401 08th St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010259.3376400005 | 2109773.81073 | 37.7736154207404 | -122.407939040461 | (37.7736154207404, -122.407939040461) | ||||
17523 | 17523 | 5503 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.757014693887704 | -122.42551217994301 | (37.7570146938877, -122.425512179943) | |||
18337 | 18337 | 25498 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005901.64349 | 2109360.28288 | 37.7722350378549 | -122.422983588528 | (37.7722350378549, -122.422983588528) | ||
18585 | 18585 | 25121 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6005252.19486 | 2099522.95164 | 37.745187369700105 | -122.424530218294 | (37.7451873697001, -122.424530218294) | |||
20060 | 20060 | 25500 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005964.12554 | 2109421.56816 | 37.7724068380339 | -122.422771813485 | (37.7724068380339, -122.422771813485) | ||
20628 | 20628 | 25499 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005915.63153 | 2109374.76445 | 37.772275590069796 | -122.42293623203999 | (37.7722755900698, -122.42293623204) | ||
21421 | 21421 | 25497 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005883.25661 | 2109339.92737 | 37.7721781089695 | -122.42304574337099 | (37.7721781089695, -122.423045743371) | ||
21445 | 21445 | 25496 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1745X Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005866.13841 | 2109325.7941099997 | 37.772138336447 | -122.42310395199499 | (37.772138336447, -122.423103951995) | ||
23802 | 23802 | 132129 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500x The Embarcadero | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013671.61354 | 2118630.60451 | 37.79812457884061 | -122.39675640879999 | (37.7981245788406, -122.3967564088) | |||
25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
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) | |||
48115 | 48115 | 132100 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012551.63717 | 2120363.68822 | 37.802820809805496 | -122.400753698321 | (37.8028208098055, -122.400753698321) | |||
49479 | 49479 | 132094 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6012848.0944 | 2119927.2949200002 | 37.8016391096046 | -122.39969713882601 | (37.8016391096046, -122.399697138826) | |||
56280 | 56280 | 194309 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 380 The Embarcadero | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.79270265166021 | -122.39120994708 | (37.7927026516602, -122.39120994708) | |||
62624 | 62624 | 132132 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 500x The Embarcadero | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 6013567.49669 | 2118786.0724 | 37.798545661218 | -122.39712759317699 | (37.798545661218, -122.397127593177) | |||
71126 | 71126 | 194298 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 550 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6014390.53553 | 2117381.11551 | 37.794733763298105 | -122.394181185735 | (37.7947337632981, -122.394181185735) | |||
71688 | 71688 | 182873 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1845 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5987506.6654 | 2102709.2443 | 37.7529179526447 | -122.486124291657 | (37.7529179526447, -122.486124291657) | |||
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
81328 | 81328 | 25745 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 10 | 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) | ||
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) | ||
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) | ||
86291 | 86291 | 25738 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 3 | 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) | ||
87718 | 87718 | 96830 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004936.0 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | |||
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) | ||
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) | |||
92364 | 92364 | 27782 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 5 | 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) | |||
92652 | 92652 | 27780 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 3 | 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) | |||
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) | ||
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) | ||
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) | ||
95346 | 95346 | 96821 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 610X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | |||
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) | ||
96723 | 96723 | 104248 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 8X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10x20 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
98209 | 98209 | 25737 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 2 | 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) | ||
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) | ||
101160 | 101160 | 25742 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 7 | 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) | ||
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) | ||
104498 | 104498 | 25741 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 6 | 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) | ||
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) | ||
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) | ||
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) |
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");