trees
1,650 rows where qSpecies_id = 64 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137 | 189330 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 23 | Median : Yard | Tree | DPW 1 | 15 | 6016163.75351 | 2096735.77367 | 37.7381445215441 | -122.386605256348 | (37.7381445215441, -122.386605256348) | 10 | 3 | 8 | 58 | 1 | ||||
1646 | 19899 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
2365 | 97086 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4550 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2020 12:00:00 AM | 3 | 3x3 | 5981457.56361 | 2110998.49669 | 37.7753234489943 | -122.507657898162 | (37.7753234489943, -122.507657898162) | 11 | 6 | 2 | 55 | 26 | ||
3460 | 20048 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
6229 | 54527 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4550 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2020 12:00:00 AM | 3 | 3x5 | Permit Number 10322 | 5981462.67511 | 2111006.65453 | 37.775346149152 | -122.507640822085 | (37.775346149152, -122.507640822085) | 11 | 6 | 2 | 55 | 26 | |
7958 | 258015 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1267 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5983961.07451 | 2106546.41289 | 37.7632464670432 | -122.498668855343 | (37.7632464670432, -122.498668855343) | 1 | 8 | 3 | 56 | 35 | |||
8902 | 89579 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4801X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983739.98456 | 2111706.68293 | 37.777402120963 | -122.499814958061 | (37.777402120963, -122.499814958061) | 11 | 6 | 2 | 55 | 26 | ||
9111 | 29980 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1622X Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005918.53507 | 2099515.50587 | 37.7452045332674 | -122.422225595834 | (37.7452045332674, -122.422225595834) | 2 | 7 | 5 | 28859 | 2 | ||
9188 | 250134 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2550x Lyon St | 2 | Median : Yard | Tree | DPW 1 | 15 | 5999224.86929 | 2117537.18532 | 37.7943076699218 | -122.446667476532 | (37.7943076699218, -122.446667476532) | 13 | 9 | 1 | 57 | 27 | ||||
11211 | 256751 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1858 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 5985068.08912 | 2102552.26769 | 37.7523445150231 | -122.494545652262 | (37.7523445150231, -122.494545652262) | 1 | 8 | 3 | 56 | 35 | ||
12337 | 89570 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4935 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983308.7395 | 2111690.55403 | 37.77733251999 | -122.501305558655 | (37.77733251999, -122.501305558655) | 11 | 6 | 2 | 55 | 26 | ||
12509 | 260552 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1822 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/27/2019 12:00:00 AM | 3 | 5983200.28736 | 2102724.03033 | 37.752706632515 | -122.501017410169 | (37.752706632515, -122.501017410169) | 1 | 8 | 3 | 56 | 35 | ||
13700 | 104171 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2607 DIAMOND ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6002306 | 2096613 | 37.7370304975493 | -122.434509617625 | (37.7370304975493, -122.434509617625) | 2 | 7 | 5 | 63 | 7 | |||
13857 | 260533 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1514 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982198.3547 | 2104783.64712 | 37.7583028764812 | -122.504634801553 | (37.7583028764812, -122.504634801553) | 1 | 8 | 3 | 56 | 35 | ||
13936 | 189326 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 19 | Median : Yard | Tree | DPW 1 | 16 | 6016187.80706 | 2096717.46995 | 37.7380955948279 | -122.386520814503 | (37.7380955948279, -122.386520814503) | 10 | 3 | 8 | 58 | 1 | ||||
14709 | 5008 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5300 Diamond Heights Blvd | 25 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | |||
15574 | 257971 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2375 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5982047.40699 | 2098940.49295 | 37.7422503328302 | -122.504723889349 | (37.7422503328302, -122.504723889349) | 1 | 8 | 3 | 29491 | 35 | |||
15929 | 20047 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
17004 | 259318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012713 | 2104246 | 37.7585743521834 | -122.399063317374 | (37.7585743521834, -122.399063317374) | 10 | 3 | 8 | 28856 | 29 | |||||
17008 | 29712 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594X Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 6 | 6005909.34325 | 2099821.50359 | 37.7460442149832 | -122.422279116311 | (37.7460442149832, -122.422279116311) | 2 | 7 | 5 | 28859 | 22 | |||
20085 | 30016 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 8 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005691.52892 | 2098774.02454 | 37.7431557868143 | -122.422957855325 | (37.7431557868143, -122.422957855325) | 2 | 7 | 7 | 28859 | 2 | ||
20604 | 11607 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4300 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 5981158.1048 | 2105571.7891 | 37.7604056423858 | -122.508290879089 | (37.7604056423858, -122.508290879089) | 1 | 8 | 3 | 56 | 35 | |||
20932 | 205329 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 21 | Median : Cutout | Tree | DPW 1 | 16 | Width 0ft | 5996217.25377 | 2089002.70313 | 37.7157869221923 | -122.455011281241 | (37.7157869221923, -122.455011281241) | 9 | 8 | 6 | 28861 | 24 | |||
22362 | 104523 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 51X BONVIEW ST | 1 | Front Yard : Yard | Tree | DPW 1 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | |||||
26854 | 12684 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5991425.07466 | 2114725.18458 | 37.7861380722177 | -122.473450196302 | (37.7861380722177, -122.473450196302) | 11 | 6 | 2 | 54 | 26 | |||
32663 | 111520 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 800x BOSWORTH ST | 15 | Front Yard : Yard | Tree | DPW 1 | 7 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
33840 | 30007 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 3 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005678.3438 | 2098731.55781 | 37.7430384387857 | -122.42300042833 | (37.7430384387857, -122.42300042833) | 2 | 7 | 7 | 28859 | 2 | ||
34073 | 29992 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 7 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005877.58141 | 2099371.3233 | 37.7448063305595 | -122.422356964316 | (37.7448063305595, -122.422356964316) | 2 | 7 | 5 | 28859 | 2 | ||
37010 | 5006 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5300 Diamond Heights Blvd | 23 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.7435139095193 | -122.437744874344 | (37.7435139095193, -122.437744874344) | 2 | 7 | 5 | 63 | 7 | |||
37268 | 89567 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4949X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983344.613126 | 2111698.253315 | 37.7773557666221 | -122.501182031755 | (37.7773557666221, -122.501182031755) | 11 | 6 | 2 | 55 | 26 | |
38452 | 189333 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 26 | Median : Yard | Tree | DPW 1 | 18 | 6016146.37557 | 2096749.3676 | 37.7381808856511 | -122.386666288817 | (37.7381808856511, -122.386666288817) | 10 | 3 | 8 | 58 | 1 | ||||
38981 | 89536 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5200 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982527.27308 | 2111717.02924 | 37.777359290085 | -122.504010820775 | (37.777359290085, -122.504010820775) | 11 | 6 | 2 | 55 | 26 | ||
40739 | 189335 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 29 | Median : Yard | Tree | DPW 1 | 15 | 6016137.08007 | 2096756.05642 | 37.7381987371688 | -122.386698894633 | (37.7381987371688, -122.386698894633) | 10 | 3 | 8 | 58 | 1 | ||||
45696 | 24382 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1450 Holloway Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5X5 | 5990869.8996566 | 2091172.9547398 | 37.7214376817414 | -122.473652239882 | (37.7214376817414, -122.473652239882) | 9 | 8 | 4 | 64 | 40 | |||
46426 | 29661 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 4 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
46882 | 189307 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1510x 22nd St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6013533.7803 | 2103828.56548 | 37.7574738724493 | -122.396195412608 | (37.7574738724493, -122.396195412608) | 10 | 3 | 8 | 28856 | 29 | |||
47394 | 89537 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5200 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982508.64024 | 2111716.77355 | 37.7773574923137 | -122.504075257813 | (37.7773574923137, -122.504075257813) | 11 | 6 | 2 | 55 | 26 | ||
47870 | 189323 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 301x Cashmere St | 1 | Median : Yard | Tree | DPW 1 | 6 | 6016365.09613 | 2096197.70243 | 37.7366782309168 | -122.385871612795 | (37.7366782309168, -122.385871612795) | 10 | 3 | 8 | 58 | 1 | ||||
48702 | 189322 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299x Cashmere St | 31 | Median : Yard | Tree | DPW 1 | 2 | 6016409.15229 | 2096168.44158 | 37.736600324449 | -122.385717251362 | (37.736600324449, -122.385717251362) | 10 | 3 | 8 | 58 | 1 | ||||
52105 | 2325 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2298X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2004 12:00:00 AM | 3 | 3X3 | 6009629.89674 | 2103998.72024 | 37.757723086282 | -122.409708671514 | (37.757723086282, -122.409708671514) | 2 | 4 | 7 | 28859 | 19 | ||
52266 | 175915 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 350x Winding Way | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6000968.48443 | 2086648.88049 | 37.7095952724697 | -122.438420330043 | (37.7095952724697, -122.438420330043) | 9 | 7 | 6 | 28861 | 5 | |||
52331 | 29994 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 9 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005883.22983 | 2099389.42314 | 37.7448563472359 | -122.422338718883 | (37.7448563472359, -122.422338718883) | 2 | 7 | 5 | 28859 | 2 | ||
53696 | 89549 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5601 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981225.68793 | 2111616.84519 | 37.7770075886204 | -122.508505908708 | (37.7770075886204, -122.508505908708) | 11 | 6 | 2 | 55 | 26 | ||
55309 | 30017 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 9 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005697.924 | 2098794.21109 | 37.743211575362 | -122.422937177222 | (37.743211575362, -122.422937177222) | 2 | 7 | 7 | 28859 | 2 | ||
58409 | 29998 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 12 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005888.8207 | 2099404.7215 | 37.7448986684345 | -122.422320473416 | (37.7448986684345, -122.422320473416) | 2 | 7 | 5 | 28859 | 2 | ||
60300 | 102 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 923 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6002670.32945 | 2107653.00365 | 37.7673644031782 | -122.434038910361 | (37.7673644031782, -122.434038910361) | 15 | 5 | 5 | 28862 | 3 | |||
60482 | 5572 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1035 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6005146.9010804 | 2102326.2346427 | 37.7528785917901 | -122.425093730386 | (37.7528785917901, -122.425093730386) | 2 | 4 | 5 | 28859 | 19 | |||
62477 | 205301 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100x Idora Ave | 16 | Median : Yard | Tree | DPW 1 | 6 | Width 9ft | 5995644.80929 | 2099340.4392 | 37.7441389922109 | -122.457737494208 | (37.7441389922109, -122.457737494208) | 1 | 8 | 4 | 59 | 40 | |||
65032 | 250133 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2550x Lyon St | 1 | Median : Yard | Tree | DPW 1 | 16 | 5999242.46646 | 2117532.27961 | 37.7942952053215 | -122.446606235406 | (37.7942952053215, -122.446606235406) | 13 | 9 | 1 | 57 | 27 | ||||
65696 | 30012 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 738X San Jose Ave | 4 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005734.30948 | 2098905.3013 | 37.743518656953 | -122.422819258997 | (37.743518656953, -122.422819258997) | 2 | 7 | 7 | 28859 | 2 | ||
66809 | 205288 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100x Casitas Ave | 1 | Median : Cutout | Tree | DPW 1 | 13 | Width 4ft | 5995094.0197 | 2097032.76312 | 37.7377710286069 | -122.459474894452 | (37.7377710286069, -122.459474894452) | 9 | 7 | 4 | 59 | 40 | |||
67628 | 12683 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5991446.19952 | 2114750.37653 | 37.7862084655919 | -122.473378948706 | (37.7862084655919, -122.473378948706) | 11 | 6 | 2 | 54 | 26 | |||
67804 | 189329 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 22 | Median : Yard | Tree | DPW 1 | 22 | 6016170.50674 | 2096734.91499 | 37.7381425376441 | -122.386581846976 | (37.7381425376441, -122.386581846976) | 10 | 3 | 8 | 58 | 1 | ||||
68199 | 245665 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681x San Jose Ave | 1 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005853.52339 | 2099296.15265 | 37.744598571882 | -122.42243481233 | (37.744598571882, -122.42243481233) | 2 | 7 | 5 | 28859 | 2 | |||
70082 | 4979 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5200X Diamond Heights Blvd | 15 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | 2 | 7 | 5 | 63 | 7 | |||
72134 | 189324 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 13 | Median : Yard | Tree | DPW 1 | 4 | 6016254.7178 | 2096666.03631 | 37.7379580722924 | -122.386285883701 | (37.7379580722924, -122.386285883701) | 10 | 3 | 8 | 58 | 1 | ||||
76937 | 189321 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299x Cashmere St | 30 | Median : Yard | Tree | DPW 1 | 7 | 6016453.45941 | 2096140.51631 | 37.7365260988976 | -122.38556211562 | (37.7365260988976, -122.38556211562) | 10 | 3 | 8 | 58 | 1 | ||||
77965 | 96415 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2701x Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6008948.88746 | 2102724.5327 | 37.7541862689808 | -122.411973848371 | (37.7541862689808, -122.411973848371) | 2 | 4 | 7 | 28859 | 19 | |||
78020 | 30011 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 795X San Jose Ave | 3 | Median : Cutout | Tree | DPW 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | 6005625.43803 | 2098570.80228 | 37.7425940549807 | -122.423171938039 | (37.7425940549807, -122.423171938039) | 2 | 7 | 7 | 28859 | 2 | ||
79053 | 15065 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1X Minerva St | 8 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996005.0253 | 2089004.00266 | 37.7157783129984 | -122.455744930195 | (37.7157783129984, -122.455744930195) | 9 | 8 | 6 | 28861 | 24 | |||
83966 | 29660 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 3 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
88148 | 5696 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1552 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/2008 12:00:00 AM | 6 | 3x3 | 6005224.49905 | 2099276.7754 | 37.7445098618418 | -122.424608477322 | (37.7445098618418, -122.424608477322) | 2 | 7 | 5 | 63 | 22 | ||
88804 | 189332 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 25 | Median : Yard | Tree | DPW 1 | 5 | 6016155.51714 | 2096746.87389 | 37.7381745445247 | -122.386634507683 | (37.7381745445247, -122.386634507683) | 10 | 3 | 8 | 58 | 1 | ||||
91377 | 89540 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5250X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982405.612283 | 2111704.340527 | 37.7773172955843 | -122.50443073774 | (37.7773172955843, -122.50443073774) | 11 | 6 | 2 | 55 | 26 | |
92797 | 29662 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 5 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
92831 | 29656 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 190X Cashmere St | 1 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016261.8205744 | 2096260.7089353 | 37.7368455183428 | -122.386233075665 | (37.7368455183428, -122.386233075665) | 10 | 3 | 8 | 58 | 1 | ||
94414 | 29989 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 4 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005863.98756 | 2099326.06351 | 37.7446812906148 | -122.422400754108 | (37.7446812906148, -122.422400754108) | 2 | 7 | 5 | 28859 | 2 | ||
94755 | 205300 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100x Idora Ave | 15 | Median : Yard | Tree | DPW 1 | 6 | Width 9ft | 5995637.60627 | 2099342.55805 | 37.7441443962476 | -122.457762553794 | (37.7441443962476, -122.457762553794) | 1 | 8 | 4 | 59 | 40 | |||
95266 | 189327 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 20 | Median : Yard | Tree | DPW 1 | 24 | 6016185.54998 | 2096725.46158 | 37.7381174132775 | -122.386529175505 | (37.7381174132775, -122.386529175505) | 10 | 3 | 8 | 58 | 1 | ||||
96704 | 26510 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2854 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6008945.91858 | 2101850.94862 | 37.7517874366552 | -122.411922386923 | (37.7517874366552, -122.411922386923) | 2 | 4 | 7 | 28859 | 19 | |||
98029 | 11605 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4300 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 5981172.9444 | 2105571.7891 | 37.7604065168831 | -122.508239556702 | (37.7604065168831, -122.508239556702) | 1 | 8 | 3 | 56 | 35 | |||
100121 | 29997 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 11 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005888.0743 | 2099402.63475 | 37.7448928965893 | -122.422322906097 | (37.7448928965893, -122.422322906097) | 2 | 7 | 5 | 28859 | 2 | ||
104581 | 29988 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 3 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005860.9876 | 2099317.01753 | 37.7446562831756 | -122.422410484775 | (37.7446562831756, -122.422410484775) | 2 | 7 | 5 | 28859 | 2 | ||
104745 | 89560 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5049 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983034.051449 | 2111686.835149 | 37.7773061739746 | -122.502255502941 | (37.7773061739746, -122.502255502941) | 11 | 6 | 2 | 55 | 26 | |
104753 | 89555 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5301X Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982189.04125 | 2111648.71892 | 37.7771518344652 | -122.505175791066 | (37.7771518344652, -122.505175791066) | 11 | 6 | 2 | 55 | 26 | ||
105209 | 5712 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1617 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005334.50752 | 2098914.22042 | 37.743520580615 | -122.424202310195 | (37.743520580615, -122.424202310195) | 2 | 7 | 5 | 28859 | 22 | |||
108055 | 101029 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1010X Portola Dr | 3 | Front Yard : Yard | Tree | DPW 1 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | |||||
108093 | 245662 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750x San Jose Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005689.97131 | 2098766.69991 | 37.743135587148 | -122.422962720654 | (37.743135587148, -122.422962720654) | 2 | 7 | 7 | 28859 | 2 | |||
109567 | 89513 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4700X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984104.789121 | 2111765.230895 | 37.7775842773972 | -122.498557324957 | (37.7775842773972, -122.498557324957) | 11 | 6 | 2 | 55 | 26 | |
113392 | 102273 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100X Casitas Ave | 7 | Median : Cutout | Tree | DPW 1 | 12 | 6x14 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | 9 | 7 | 4 | 59 | 40 | |||
113739 | 89494 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4424 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984903.74024 | 2111802.58602 | 37.7777336659006 | -122.495796281736 | (37.7777336659006, -122.495796281736) | 11 | 6 | 2 | 55 | 26 | ||
117988 | 89542 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5300X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982175.49645 | 2111704.48875 | 37.7773041650818 | -122.505226780346 | (37.7773041650818, -122.505226780346) | 11 | 6 | 2 | 55 | 26 | ||
119204 | 245672 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005912.3551 | 2099779.75668 | 37.7459297573535 | -122.422265736192 | (37.7459297573535, -122.422265736192) | 2 | 7 | 5 | 28859 | 22 | |||
119979 | 89561 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5033 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983081.723549 | 2111688.543497 | 37.7773136653868 | -122.502090718872 | (37.7773136653868, -122.502090718872) | 11 | 6 | 2 | 55 | 26 | |
121476 | 5571 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1033 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005142.90403 | 2102326.22826 | 37.7528783484711 | -122.425107552489 | (37.7528783484711, -122.425107552489) | 2 | 4 | 5 | 28859 | 19 | |||
126602 | 29709 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594X Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 6 | 6005913.75363 | 2099762.2133 | 37.7458816661082 | -122.422259654058 | (37.7458816661082, -122.422259654058) | 2 | 7 | 5 | 28859 | 22 | |||
128022 | 29981 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1622X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005920.83177 | 2099524.56663 | 37.7452295416039 | -122.422218297841 | (37.7452295416039, -122.422218297841) | 2 | 7 | 5 | 28859 | 2 | ||
128736 | 30009 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 5 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005685.14822 | 2098754.53828 | 37.7431019219116 | -122.422978533436 | (37.7431019219116, -122.422978533436) | 2 | 7 | 7 | 28859 | 2 | ||
129675 | 29990 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 5 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005867.00191 | 2099335.81011 | 37.7447082226084 | -122.422391023449 | (37.7447082226084, -122.422391023449) | 2 | 7 | 5 | 28859 | 2 | ||
129872 | 245663 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750x San Jose Ave | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005696.33761 | 2098785.48588 | 37.7431875283974 | -122.422942042552 | (37.7431875283974, -122.422942042552) | 2 | 7 | 7 | 28859 | 2 | |||
132408 | 189331 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 24 | Median : Yard | Tree | DPW 1 | 25 | 6016158.58159 | 2096743.10155 | 37.7381643560956 | -122.386623649267 | (37.7381643560956, -122.386623649267) | 10 | 3 | 8 | 58 | 1 | ||||
133511 | 89534 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5140 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982666.25083 | 2111721.90508 | 37.7773808493197 | -122.503530420619 | (37.7773808493197, -122.503530420619) | 11 | 6 | 2 | 55 | 26 | ||
133676 | 5092 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2605 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 51 | 6002286.56903 | 2096627.94981 | 37.7370704432348 | -122.434577867771 | (37.7370704432348, -122.434577867771) | 2 | 7 | 5 | 63 | 7 | ||||
134995 | 29982 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1622X Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005921.74385 | 2099534.70656 | 37.7452574349955 | -122.422215864289 | (37.7452574349955, -122.422215864289) | 2 | 7 | 5 | 28859 | 2 | ||
138442 | 89523 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4840X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983582.72617 | 2111754.03693 | 37.7775229118204 | -122.50036245966 | (37.7775229118204, -122.50036245966) | 11 | 6 | 2 | 55 | 26 | ||
139316 | 89569 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4939 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983374.388584 | 2111699.374735 | 37.7773605941443 | -122.501079113369 | (37.7773605941443, -122.501079113369) | 11 | 6 | 2 | 55 | 26 | |
142515 | 29987 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 688X San Jose Ave | 2 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005801.21502 | 2099130.13322 | 37.7441397692444 | -122.42260388936 | (37.7441397692444, -122.42260388936) | 2 | 7 | 5 | 28859 | 2 | ||
143116 | 205332 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 37 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 5996356.8338 | 2088999.78722 | 37.7157869222184 | -122.454528620522 | (37.7157869222184, -122.454528620522) | 9 | 8 | 6 | 28861 | 24 | |||
143299 | 89574 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4901X Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983427.52717 | 2111694.21423 | 37.7773495449975 | -122.500894910902 | (37.7773495449975, -122.500894910902) | 11 | 6 | 2 | 55 | 26 | ||
144372 | 29713 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594X Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6005909.20012 | 2099831.66519 | 37.7460721083515 | -122.422280333079 | (37.7460721083515, -122.422280333079) | 2 | 7 | 5 | 28859 | 22 |
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) );