trees
897 rows where qSpecies_id = 160 sorted by DBH
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
119783 | 233931 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 451 Florida St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 9ft | 6009251.45318 | 2106264.05651 | 37.7639219692477 | -122.411177507234 | (37.7639219692477, -122.411177507234) | 8 | 4 | 7 | 28859 | 19 | |||
130505 | 132111 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011290.22315 | 2121683.26622 | 37.8063736103221 | -122.40521183647 | (37.8063736103221, -122.40521183647) | 3 | 1 | 10 | 308 | 23 | |||
135984 | 194317 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014996.79198 | 2116890.75749 | 37.7934210328094 | -122.392049131461 | (37.7934210328094, -122.392049131461) | 12 | 2 | 9 | 28855 | 6 | |||
137538 | 210903 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1939 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 5991246.46009 | 2102193.40392 | 37.7517188372786 | -122.473153888536 | (37.7517188372786, -122.473153888536) | 1 | 8 | 4 | 29491 | 12 | |||
175303 | 132107 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011604.73213 | 2121437.14607 | 37.8057154028122 | -122.404106084029 | (37.8057154028122, -122.404106084029) | 3 | 1 | 10 | 28860 | 23 | |||
178595 | 194322 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014773.34204 | 2117151.64182 | 37.7941249519603 | -122.392840551058 | (37.7941249519603, -122.392840551058) | 12 | 2 | 10 | 28855 | 6 | |||
186642 | 234353 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 600x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 22 | 6004972.99997 | 2104631.70012 | 37.7591990347337 | -122.425859204936 | (37.7591990347337, -122.425859204936) | 2 | 4 | 5 | 28862 | 3 | ||||
1681 | 132077 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012714.412 | 2120058.13658 | 37.8019909162964 | -122.400168938451 | (37.8019909162964, -122.400168938451) | 3 | 1 | 10 | 28860 | 6 | |||
4408 | 234354 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 23 | 6004979.81363 | 2104508.34972 | 37.7588607286626 | -122.425826859935 | (37.7588607286626, -122.425826859935) | 2 | 4 | 5 | 28862 | 3 | ||||
31169 | 201683 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 19 | Front Yard : Yard | Tree | Private 2 | 23 | 6010259.33764 | 2109773.81073 | 37.7736154207404 | -122.407939040461 | (37.7736154207404, -122.407939040461) | 14 | 2 | 9 | 28853 | 34 | ||||
31694 | 234402 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002514.48058 | 2108813.73054 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | 15 | 5 | 5 | 29492 | 9 | |||
31803 | 132075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012816.85763 | 2119903.53523 | 37.8015721299035 | -122.399803563704 | (37.8015721299035, -122.399803563704) | 3 | 1 | 10 | 28860 | 6 | |||
67451 | 201687 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 23 | Front Yard : Yard | Tree | Private 2 | 23 | 6010195.30306 | 2109846.89146 | 37.7738124981919 | -122.408165701983 | (37.7738124981919, -122.408165701983) | 14 | 2 | 9 | 28853 | 34 | ||||
73081 | 132070 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 1 | Median : Cutout | Tree | DPW 1 | 23 | Width 5ft | 6013297.80252 | 2119184.84583 | 37.7996255806051 | -122.398088816445 | (37.7996255806051, -122.398088816445) | 3 | 1 | 10 | 28860 | 6 | |||
74850 | 132098 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012646.4501 | 2120224.08688 | 37.8024427860524 | -122.400415783487 | (37.8024427860524, -122.400415783487) | 3 | 1 | 10 | 28860 | 6 | |||
78947 | 132116 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013189.6161 | 2119421.22304 | 37.8002685895792 | -122.398479778719 | (37.8002685895792, -122.398479778719) | 3 | 1 | 10 | 28860 | 6 | |||
84322 | 132083 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012328.94165 | 2120621.527 | 37.8035163490725 | -122.401542475719 | (37.8035163490725, -122.401542475719) | 3 | 1 | 10 | 28860 | 6 | |||
95027 | 132071 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013261.91929 | 2119233.02284 | 37.7997558644996 | -122.398216368212 | (37.7997558644996, -122.398216368212) | 3 | 1 | 10 | 28860 | 6 | |||
99322 | 132095 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012798.77066 | 2120004.26494 | 37.8018477010824 | -122.399873230589 | (37.8018477010824, -122.399873230589) | 3 | 1 | 10 | 28860 | 6 | |||
103858 | 194320 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 23 | Width 7ft | 6014831.89764 | 2117081.36813 | 37.7939352489635 | -122.392633022622 | (37.7939352489635, -122.392633022622) | 12 | 2 | 10 | 28855 | 6 | |||
106466 | 234364 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 6 | Median : Yard | Tree | DPW 1 | 23 | 6005148.13697 | 2101464.62312 | 37.7505128760752 | -122.425028157637 | (37.7505128760752, -122.425028157637) | 2 | 4 | 5 | 28862 | 22 | ||||
111683 | 234358 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 23 | 6004991.05597 | 2104342.31446 | 37.7584054702508 | -122.425776160656 | (37.7584054702508, -122.425776160656) | 2 | 4 | 5 | 28862 | 3 | ||||
121346 | 132085 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6012153.58511 | 2120867.04559 | 37.8041806971541 | -122.402166580042 | (37.8041806971541, -122.402166580042) | 3 | 1 | 10 | 28860 | 6 | |||
125694 | 234330 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900x Dolores St | 15 | Median : Yard | Tree | DPW 1 | 23 | 6005083.06258 | 2102603.58555 | 37.7536365264144 | -122.425334231087 | (37.7536365264144, -122.425334231087) | 2 | 4 | 5 | 28862 | 22 | ||||
132004 | 132115 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6013243.85901 | 2119336.70039 | 37.8000395322586 | -122.398286142085 | (37.8000395322586, -122.398286142085) | 3 | 1 | 10 | 28860 | 6 | |||
145461 | 132089 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6011437.6783 | 2121540.455 | 37.8059897284039 | -122.404691478852 | (37.8059897284039, -122.404691478852) | 3 | 1 | 10 | 308 | 23 | |||
156186 | 234328 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 850x Dolores St | 4 | Median : Yard | Tree | DPW 1 | 23 | 6005051.1738 | 2103243.46642 | 37.7553916882954 | -122.425490044948 | (37.7553916882954, -122.425490044948) | 2 | 4 | 5 | 28862 | 22 | ||||
163124 | 234403 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 175 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 6ft | 6006066.15182 | 2108969.94189 | 37.7711725365248 | -122.422386799311 | (37.7711725365248, -122.422386799311) | 8 | 2 | 9 | 28853 | 19 | |||
168330 | 132110 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6011374.63029 | 2121626.67271 | 37.8062229369941 | -122.404915741893 | (37.8062229369941, -122.404915741893) | 3 | 1 | 10 | 308 | 23 | |||
2509 | 27941 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
9507 | 132129 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013671.61354 | 2118630.60451 | 37.7981245788406 | -122.3967564088 | (37.7981245788406, -122.3967564088) | 3 | 1 | 10 | 28860 | 6 | |||
17161 | 28026 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.394682002417 | (37.795812278914, -122.394682002417) | 4 | 2 | 10 | 28860 | 6 | ||
18148 | 27929 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
20840 | 27943 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
22504 | 96822 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
23927 | 27766 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
25850 | 27930 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
28000 | 27867 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014979.71901 | 2116870.00001 | 37.7933630896865 | -122.392106753362 | (37.7933630896865, -122.392106753362) | 12 | 2 | 9 | 28855 | 6 | ||
28206 | 28025 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.7960727946079 | -122.394977873693 | (37.7960727946079, -122.394977873693) | 3 | 2 | 10 | 28860 | 6 | ||
28610 | 25736 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
28715 | 5503 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 773 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6005056.9343 | 2103834.44184 | 37.7570146938877 | -122.425512179943 | (37.7570146938877, -122.425512179943) | 2 | 4 | 5 | 28859 | 19 | |||
29089 | 27944 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | |||
30456 | 96824 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
34341 | 27931 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
39383 | 27948 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
40485 | 132100 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 15 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6012551.63717 | 2120363.68822 | 37.8028208098055 | -122.400753698321 | (37.8028208098055, -122.400753698321) | 3 | 1 | 10 | 28860 | 6 | |||
43793 | 28030 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.87001 | 37.7955777303512 | -122.394439384649 | (37.7955777303512, -122.394439384649) | 4 | 2 | 10 | 28860 | 6 | ||
44516 | 132094 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6012848.0944 | 2119927.29492 | 37.8016391096046 | -122.399697138826 | (37.8016391096046, -122.399697138826) | 3 | 1 | 10 | 28860 | 6 | |||
45682 | 28024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.30001 | 2117911.22501 | 37.7961756855245 | -122.39506688845 | (37.7961756855245, -122.39506688845) | 3 | 2 | 10 | 28860 | 6 | ||
47535 | 25745 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
48553 | 28021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.7964640385194 | -122.395299619332 | (37.7964640385194, -122.395299619332) | 3 | 2 | 10 | 28860 | 6 | ||
51227 | 194309 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 The Embarcadero | 1 | : | Tree | Private 2 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.7927026516602 | -122.39120994708 | (37.7927026516602, -122.39120994708) | 12 | 2 | 9 | 28855 | 6 | |||
58643 | 25738 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
65475 | 96830 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
66185 | 25498 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005901.64349 | 2109360.28288 | 37.7722350378549 | -122.422983588528 | (37.7722350378549, -122.422983588528) | 7 | 2 | 9 | 28853 | 19 | ||
71132 | 25121 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6005252.19486 | 2099522.95164 | 37.7451873697001 | -122.424530218294 | (37.7451873697001, -122.424530218294) | 2 | 7 | 5 | 63 | 22 | |||
73069 | 28001 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
74716 | 27997 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
77477 | 28023 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | 3 | 2 | 10 | 28860 | 6 | ||
80221 | 27782 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
82936 | 124656 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.459606621954 | (37.7883362746058, -122.459606621954) | 11 | 6 | 1 | 54 | 11 | |||
86217 | 27942 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
86437 | 28032 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 12 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | 4 | 2 | 10 | 28860 | 6 | ||
86553 | 27933 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
86897 | 27949 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
88106 | 27780 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
88902 | 27870 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015155.50001 | 2116672.08301 | 37.7928294135533 | -122.391484690649 | (37.7928294135533, -122.391484690649) | 12 | 2 | 9 | 28855 | 6 | ||
88913 | 132132 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013567.49669 | 2118786.0724 | 37.798545661218 | -122.397127593177 | (37.798545661218, -122.397127593177) | 3 | 1 | 10 | 28860 | 6 | |||
89748 | 96821 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 610X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004926.4 | 2104659.4 | 37.7592724584905 | -122.426022342006 | (37.7592724584905, -122.426022342006) | 2 | 4 | 5 | 28862 | 3 | |||
90140 | 104248 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10x20 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
99231 | 25742 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
99532 | 25737 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
109762 | 25500 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 5 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005964.12554 | 2109421.56816 | 37.7724068380339 | -122.422771813485 | (37.7724068380339, -122.422771813485) | 7 | 2 | 9 | 28853 | 19 | ||
109811 | 132072 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013209.18431 | 2119314.66631 | 37.799977100409 | -122.398404583712 | (37.799977100409, -122.398404583712) | 3 | 1 | 10 | 28860 | 6 | |||
111729 | 28027 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014263.57201 | 2117754.97501 | 37.795753235969 | -122.394646693031 | (37.795753235969, -122.394646693031) | 4 | 2 | 10 | 28860 | 6 | ||
112625 | 132073 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013155.58738 | 2119398.118 | 37.8002032529271 | -122.398595909995 | (37.8002032529271, -122.398595909995) | 3 | 1 | 10 | 28860 | 6 | |||
113822 | 27947 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
116516 | 27866 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014921.77607 | 2116935.19701 | 37.7935388882384 | -122.39231180375 | (37.7935388882384, -122.39231180375) | 12 | 2 | 9 | 28855 | 6 | ||
116886 | 118208 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 578 35th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 2ft | 5985073.59503 | 2111934.34638 | 37.7781053878802 | -122.495218423393 | (37.7781053878802, -122.495218423393) | 11 | 6 | 2 | 55 | 26 | |||
119113 | 28000 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
120757 | 194318 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 24 | Width 7ft | 6014918.37663 | 2116934.10067 | 37.7935356891802 | -122.392323489462 | (37.7935356891802, -122.392323489462) | 12 | 2 | 9 | 28855 | 6 | |||
124324 | 25741 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
128669 | 25499 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 4 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005915.63153 | 2109374.76445 | 37.7722755900698 | -122.42293623204 | (37.7722755900698, -122.42293623204) | 7 | 2 | 9 | 28853 | 19 | ||
129077 | 28002 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
129757 | 27951 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
132193 | 28031 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | 4 | 2 | 10 | 28860 | 6 | ||
132259 | 28003 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
132622 | 132130 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 24 | Width 10ft | 6013704.00439 | 2118650.24995 | 37.7981803233112 | -122.396645704061 | (37.7981803233112, -122.396645704061) | 3 | 1 | 10 | 28860 | 6 | |||
133231 | 182873 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1845 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5987506.6654 | 2102709.2443 | 37.7529179526447 | -122.486124291657 | (37.7529179526447, -122.486124291657) | 1 | 8 | 3 | 56 | 35 | |||
133427 | 25744 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
134915 | 104247 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10x20 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
136779 | 96826 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
137989 | 27946 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
138744 | 124647 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Arguello Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5995536.86088 | 2115835.19472 | 37.78942310858 | -122.459305014392 | (37.78942310858, -122.459305014392) | 11 | 6 | 1 | 54 | 31 | ||||
139826 | 27868 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015038.31301 | 2116806.19801 | 37.7931911572627 | -122.39189954881 | (37.7931911572627, -122.39189954881) | 12 | 2 | 9 | 28855 | 6 | ||
140550 | 27781 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
142522 | 25012 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 24 | 20 | 6004896.4850005 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | 2 | 4 | 5 | 28862 | 3 | |||
143696 | 27932 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
144197 | 28022 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014106.23701 | 2117977.41401 | 37.7963552526163 | -122.39520669408 | (37.7963552526163, -122.39520669408) | 3 | 2 | 10 | 28860 | 6 | ||
144410 | 27998 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );