trees
390 rows where qSpecies_id = 126 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1584 | 79997 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5981344.9471 | 2112403.21249 | 37.7791737487824 | -122.508151741605 | (37.7791737487824, -122.508151741605) | 11 | 6 | 2 | 55 | 26 | |||
3048 | 199537 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 16 | Front Yard : Yard | Tree | Private 2 | 4 | 6014323.98726 | 2106464.8847 | 37.7647565688948 | -122.393647053167 | (37.7647565688948, -122.393647053167) | 14 | 3 | 8 | 310 | 29 | ||||
3638 | 72610 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014116.81236 | 2101967.79317 | 37.7523970151345 | -122.394048777632 | (37.7523970151345, -122.394048777632) | 10 | 3 | 8 | 28856 | 1 | |||
5110 | 79998 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981347.81694 | 2112377.495 | 37.7791033052806 | -122.508139904514 | (37.7791033052806, -122.508139904514) | 11 | 6 | 2 | 55 | 26 | |||
6509 | 217512 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 180 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998882.8177 | 2093813.39274 | 37.7291485212785 | -122.446143732968 | (37.7291485212785, -122.446143732968) | 9 | 7 | 4 | 28861 | 40 | ||||
6916 | 217513 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 180 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998878.5265 | 2093813.54586 | 37.7291486966488 | -122.446158578953 | (37.7291486966488, -122.446158578953) | 9 | 7 | 4 | 28861 | 40 | ||||
6982 | 72625 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014103.8148 | 2101960.56144 | 37.7523764359486 | -122.394093219441 | (37.7523764359486, -122.394093219441) | 10 | 3 | 8 | 28856 | 1 | |||
7251 | 78261 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 414 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 50 | 6009735.35322 | 2092462.55281 | 37.7260531896995 | -122.408530204426 | (37.7260531896995, -122.408530204426) | 10 | 3 | 7 | 309 | 28 | |||
7873 | 74275 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010944.70013 | 2088154.7138 | 37.714292400951 | -122.404046514754 | (37.714292400951, -122.404046514754) | 9 | 7 | 8 | 309 | 39 | |||
8435 | 199530 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1091 19th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6014489.75504 | 2105264.07428 | 37.7614686151109 | -122.392989678445 | (37.7614686151109, -122.392989678445) | 10 | 3 | 8 | 28856 | 29 | ||||
8542 | 73713 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1265 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 27 | 6012277.51673 | 2102506.08306 | 37.7537726442006 | -122.400447210275 | (37.7537726442006, -122.400447210275) | 10 | 3 | 8 | 28856 | 29 | |||
9749 | 73730 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1799 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6014041.4845 | 2095157.58141 | 37.7336934116182 | -122.393832621075 | (37.7336934116182, -122.393832621075) | 10 | 3 | 8 | 58 | 1 | |||
9874 | 199550 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 6 | : Yard | Tree | Private 2 | 15 | 6014401.0054 | 2105922.09622 | 37.7632704697749 | -122.393342678542 | (37.7632704697749, -122.393342678542) | 14 | 3 | 8 | 28856 | 29 | ||||
12016 | 38374 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3805 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 5 | Permit Number 40433 | 5982188.1991 | 2102815.1083 | 37.7528972278417 | -122.504524079724 | (37.7528972278417, -122.504524079724) | 1 | 8 | 3 | 56 | 35 | |
12929 | 79999 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5981389.70051 | 2112378.3 | 37.7791079835189 | -122.50799507452 | (37.7791079835189, -122.50799507452) | 11 | 6 | 2 | 55 | 26 | |||
16924 | 199525 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1301 Minnesota St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6015396.88376 | 2102219.87285 | 37.7531602346611 | -122.389639647178 | (37.7531602346611, -122.389639647178) | 10 | 3 | 8 | 28856 | 29 | ||||
17458 | 199543 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 38 | Front Yard : Yard | Tree | Private 2 | 5 | 6014244.47574 | 2106692.17431 | 37.7653762377352 | -122.393937976682 | (37.7653762377352, -122.393937976682) | 14 | 3 | 8 | 28856 | 20 | ||||
17619 | 61510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1237 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1984 12:00:00 AM | 23 | Permit Number 21466 | 6012274.20726 | 2102601.29078 | 37.754033879279 | -122.400465342406 | (37.754033879279, -122.400465342406) | 10 | 3 | 8 | 28856 | 29 | |
17695 | 61786 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1453 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 5 | Permit Number 21808 | 6012048.53726 | 2101599.7362 | 37.7512712410927 | -122.401175394927 | (37.7512712410927, -122.401175394927) | 10 | 3 | 8 | 28856 | 29 | |
17741 | 74618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2650 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5995104.27879 | 2110288.95981 | 37.7741697532931 | -122.460399659179 | (37.7741697532931, -122.460399659179) | 11 | 6 | 2 | 54 | 11 | |||
18569 | 74063 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010946.7362 | 2088147.19919 | 37.7142718811123 | -122.404038948741 | (37.7142718811123, -122.404038948741) | 9 | 7 | 8 | 309 | 39 | |||
22872 | 199568 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 680 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012064.94705 | 2105270.66031 | 37.7613517077453 | -122.401376599377 | (37.7613517077453, -122.401376599377) | 10 | 3 | 8 | 28856 | 29 | ||||
22966 | 217506 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 427 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 5997927.13531 | 2094070.23257 | 37.7297991196196 | -122.449466089413 | (37.7297991196196, -122.449466089413) | 9 | 7 | 4 | 28861 | 40 | ||||
24332 | 45455 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 258 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 44240 | 5997038.9938 | 2112669.4435 | 37.7808170441833 | -122.453879118533 | (37.7808170441833, -122.453879118533) | 11 | 6 | 2 | 54 | 16 | |||
25333 | 199595 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6012041.40362 | 2101659.26991 | 37.7514343097479 | -122.401204246987 | (37.7514343097479, -122.401204246987) | 10 | 3 | 8 | 28856 | 29 | ||||
25390 | 246783 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 175 Brewster St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6010050.00115 | 2098693.85293 | 37.7431806261 | -122.407881696082 | (37.7431806261, -122.407881696082) | 10 | 7 | 7 | 28859 | 2 | ||||
26204 | 84910 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5546 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2007 12:00:00 AM | 18 | Permit No. 49266 | 5981366.54955 | 2111678.1896 | 37.7771843232036 | -122.50802318732 | (37.7771843232036, -122.50802318732) | 11 | 6 | 2 | 55 | 26 | ||
26871 | 199533 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 6 | Front Yard : Yard | Tree | Private 2 | 4 | 6014329.6983 | 2106362.34828 | 37.7644753436933 | -122.393620122984 | (37.7644753436933, -122.393620122984) | 14 | 3 | 8 | 310 | 29 | ||||
30312 | 217517 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998604.94971 | 2093225.36447 | 37.7275180612089 | -122.447062041474 | (37.7275180612089, -122.447062041474) | 9 | 7 | 4 | 28861 | 40 | ||||
32056 | 199570 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 6012307.76781 | 2101930.26834 | 37.752193269208 | -122.40030215414 | (37.752193269208, -122.40030215414) | 10 | 3 | 8 | 28856 | 29 | ||||
33081 | 243978 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 76 | Front Yard : Yard | Tree | Private 2 | 4 | 6004588.46206 | 2096170.32088 | 37.7359443031923 | -122.426586604496 | (37.7359443031923, -122.426586604496) | 2 | 7 | 5 | 28861 | 2 | ||||
33914 | 202077 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 6 | Front Yard : Yard | Tree | Private 2 | 9 | 6012700.16365 | 2090713.41208 | 37.721416000129 | -122.398158307957 | (37.721416000129, -122.398158307957) | 10 | 3 | 8 | 58 | 1 | ||||
34358 | 55063 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599X 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 4 | Permit Number 10952 | 5982538.31905 | 2111794.35525 | 37.7775722542249 | -122.503978338592 | (37.7775722542249, -122.503978338592) | 11 | 6 | 2 | 55 | 26 | ||
35282 | 199555 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 15 | : Yard | Tree | Private 2 | 8 | 6014446.64039 | 2105914.65899 | 37.7632525840546 | -122.393184320496 | (37.7632525840546, -122.393184320496) | 14 | 3 | 8 | 28856 | 29 | ||||
38078 | 38815 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 204 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | 8 | Permit Number 40651 | 5994944.16478 | 2114141.25002 | 37.7847379015342 | -122.461232820546 | (37.7847379015342, -122.461232820546) | 11 | 6 | 2 | 54 | 11 | |
41511 | 217525 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2 Lobos St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5996931.31529 | 2088711.97504 | 37.7150295887309 | -122.452522199764 | (37.7150295887309, -122.452522199764) | 9 | 8 | 6 | 28861 | 24 | ||||
42837 | 199592 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1453 Rhode Island St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6012056.44689 | 2101608.80688 | 37.7512965884693 | -122.401148679688 | (37.7512965884693, -122.401148679688) | 10 | 3 | 8 | 28856 | 29 | ||||
44320 | 199612 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1570 Michigan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6016520.08797 | 2100945.2789 | 37.7497226822544 | -122.385666519716 | (37.7497226822544, -122.385666519716) | 10 | 3 | 8 | 58 | 1 | ||||
46515 | 202076 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 5 | Front Yard : Yard | Tree | Private 2 | 18 | 6012694.00092 | 2090696.52405 | 37.7213692857431 | -122.398178426718 | (37.7213692857431, -122.398178426718) | 10 | 3 | 8 | 58 | 1 | ||||
46797 | 47839 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4400 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 8 | Permit Number 45601 | 5981941.89951 | 2110334.18546 | 37.7735279659603 | -122.505933234325 | (37.7735279659603, -122.505933234325) | 11 | 6 | 2 | 55 | 26 | |
47998 | 199553 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 9 | : Yard | Tree | Private 2 | 20 | 6014424.93308 | 2105923.01259 | 37.7632743152759 | -122.393259984074 | (37.7632743152759, -122.393259984074) | 14 | 3 | 8 | 28856 | 29 | ||||
48352 | 30689 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 529 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 12 | Permit Number 34609 | 6004554.59281 | 2110367.64108 | 37.7749248947896 | -122.427714942511 | (37.7749248947896, -122.427714942511) | 7 | 9 | 11 | 28852 | 10 | |
50655 | 217514 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 181 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998875.02726 | 2093813.80402 | 37.7291492056601 | -122.44617069463 | (37.7291492056601, -122.44617069463) | 9 | 7 | 4 | 28861 | 40 | ||||
51970 | 199546 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 2 | : Yard | Tree | Private 2 | 8 | 6014366.09507 | 2105920.56167 | 37.7632643166198 | -122.393463315392 | (37.7632643166198, -122.393463315392) | 14 | 3 | 8 | 28856 | 29 | ||||
52808 | 199571 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | 6012297.36216 | 2101934.2505 | 37.7522036231042 | -122.400338418383 | (37.7522036231042, -122.400338418383) | 10 | 3 | 8 | 28856 | 29 | ||||
55653 | 199539 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 29 | Front Yard : Yard | Tree | Private 2 | 4 | 6014306.32543 | 2106588.22491 | 37.7650942526332 | -122.393716774935 | (37.7650942526332, -122.393716774935) | 14 | 3 | 8 | 310 | 29 | ||||
57391 | 243968 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1200 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6004061.61432 | 2095990.9181 | 37.7354219049951 | -122.428395344371 | (37.7354219049951, -122.428395344371) | 2 | 7 | 5 | 63 | 7 | ||||
57688 | 199617 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1670 Armstrong Ave | 2 | Front Yard : Yard | Tree | Private 2 | 24 | 6013996.30242 | 2092813.56299 | 37.7272547028171 | -122.39382481138 | (37.7272547028171, -122.39382481138) | 10 | 3 | 8 | 58 | 1 | ||||
60244 | 199531 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1098 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014488.94971 | 2105281.88683 | 37.7615174797697 | -122.392993710091 | (37.7615174797697, -122.392993710091) | 10 | 3 | 8 | 28856 | 29 | ||||
60644 | 243977 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 74 | Front Yard : Yard | Tree | Private 2 | 21 | 6004578.54944 | 2096162.87225 | 37.7359232905307 | -122.426620346145 | (37.7359232905307, -122.426620346145) | 2 | 7 | 5 | 28861 | 2 | ||||
61178 | 199557 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 18 | : Yard | Tree | Private 2 | 9 | 6014448.03527 | 2105905.59327 | 37.7632277690557 | -122.393178861636 | (37.7632277690557, -122.393178861636) | 14 | 3 | 8 | 28856 | 29 | ||||
64013 | 199524 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1350 Indiana St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6015069.09228 | 2102280.3688 | 37.7533081623518 | -122.390777452343 | (37.7533081623518, -122.390777452343) | 10 | 3 | 8 | 28856 | 29 | ||||
64145 | 199616 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1999 Revere Ave | 7 | Side Yard : Yard | Tree | Private 2 | 3 | 6013002.21254 | 2095907.198 | 37.7356938932469 | -122.397478268519 | (37.7356938932469, -122.397478268519) | 10 | 3 | 8 | 58 | 1 | ||||
65739 | 199548 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 4 | : Yard | Tree | Private 2 | 9 | 6014382.11605 | 2105919.95745 | 37.7632635477036 | -122.393407861395 | (37.7632635477036, -122.393407861395) | 14 | 3 | 8 | 28856 | 29 | ||||
68930 | 199541 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 34 | Front Yard : Yard | Tree | Private 2 | 4 | 6014267.9908 | 2106682.1532 | 37.7653500288033 | -122.393855941398 | (37.7653500288033, -122.393855941398) | 14 | 3 | 8 | 310 | 20 | ||||
73821 | 65394 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1989 12:00:00 AM | 53 | Permit Number 28237 | 6011952.10102 | 2099776.9681 | 37.7462609336071 | -122.401380800085 | (37.7462609336071, -122.401380800085) | 10 | 3 | 8 | 58 | 1 | ||
76368 | 104212 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1117 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6012239.80468 | 2103199.03133 | 37.7556732255654 | -122.400626303066 | (37.7556732255654, -122.400626303066) | 10 | 3 | 8 | 28856 | 29 | ||||
77316 | 199614 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 53 | Median : Yard | Tree | DPW 1 | 16 | 6014257.65945 | 2095401.98638 | 37.7343765087595 | -122.393102330216 | (37.7343765087595, -122.393102330216) | 10 | 3 | 8 | 58 | 1 | ||||
77734 | 199532 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1098 19th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 6014487.32888 | 2105297.7815 | 37.7615610330466 | -122.393000428053 | (37.7615610330466, -122.393000428053) | 10 | 3 | 8 | 28856 | 29 | ||||
77896 | 217537 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 89 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 18 | 5992163.63598 | 2088434.33055 | 37.7139929276052 | -122.468980989298 | (37.7139929276052, -122.468980989298) | 9 | 8 | 6 | 64 | 24 | ||||
80617 | 243996 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 483 Valley St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6002809.94275 | 2099165.62414 | 37.7440680069386 | -122.432949575959 | (37.7440680069386, -122.432949575959) | 2 | 7 | 5 | 63 | 22 | ||||
80861 | 243975 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 220 Coso Ave | 6 | Front Yard : Yard | Tree | Private 2 | 10 | 6007595.15715 | 2099522.63398 | 37.7453185340155 | -122.416428611787 | (37.7453185340155, -122.416428611787) | 2 | 7 | 7 | 28859 | 2 | ||||
81156 | 199597 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1400 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 65 | 6012249.42802 | 2101848.61895 | 37.7519658243772 | -122.400498168571 | (37.7519658243772, -122.400498168571) | 10 | 3 | 8 | 28856 | 29 | ||||
85368 | 199603 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 628 Missouri St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 24 | 6013523.6449 | 2104171.29494 | 37.7584143690574 | -122.396254485475 | (37.7584143690574, -122.396254485475) | 10 | 3 | 8 | 28856 | 29 | ||||
86416 | 199615 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 56 | Median : Yard | Tree | DPW 1 | 20 | 6014226.56708 | 2095397.27479 | 37.7343618444247 | -122.393209497917 | (37.7343618444247, -122.393209497917) | 10 | 3 | 8 | 58 | 1 | ||||
86485 | 108262 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Gould St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6012679.64923 | 2090646.14976 | 37.7212301687063 | -122.398224504378 | (37.7212301687063, -122.398224504378) | 10 | 3 | 8 | 58 | 1 | ||||
88992 | 244013 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 502 28th St | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 46 | 6002533.73614 | 2099484.81655 | 37.7449287642466 | -122.43392744661 | (37.7449287642466, -122.43392744661) | 2 | 7 | 5 | 63 | 22 | ||||
89610 | 199620 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | 6013988.45481 | 2092875.57425 | 37.7274245370974 | -122.393856279557 | (37.7274245370974, -122.393856279557) | 10 | 3 | 8 | 58 | 1 | ||||
90406 | 199588 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 875 Vermont St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6011303.70153 | 2104278.08884 | 37.7585838255903 | -122.403939592556 | (37.7585838255903, -122.403939592556) | 10 | 3 | 8 | 28856 | 29 | ||||
90528 | 199552 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 8 | : Yard | Tree | Private 2 | 15 | 6014417.3246 | 2105922.3261 | 37.7632720076265 | -122.393286251461 | (37.7632720076265, -122.393286251461) | 14 | 3 | 8 | 28856 | 29 | ||||
91156 | 243980 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 79 | Front Yard : Yard | Tree | Private 2 | 6 | 6004603.12758 | 2096184.79771 | 37.7359848823907 | -122.426536930441 | (37.7359848823907, -122.426536930441) | 2 | 7 | 5 | 28861 | 2 | ||||
93012 | 199547 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 3 | : Yard | Tree | Private 2 | 15 | 6014373.91679 | 2105917.88241 | 37.7632573945418 | -122.393436074922 | (37.7632573945418, -122.393436074922) | 14 | 3 | 8 | 28856 | 29 | ||||
95458 | 217499 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 414 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5999453.36521 | 2094474.27973 | 37.7309957287723 | -122.444218781791 | (37.7309957287723, -122.444218781791) | 9 | 7 | 4 | 63 | 40 | ||||
96396 | 199538 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 18 | Front Yard : Yard | Tree | Private 2 | 4 | 6014323.67037 | 2106494.67035 | 37.7648383361526 | -122.393650234094 | (37.7648383361526, -122.393650234094) | 14 | 3 | 8 | 310 | 29 | ||||
97857 | 199618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 4 | Side Yard : Yard | Tree | Private 2 | 9 | 6013981.31336 | 2092866.65416 | 37.7273996474538 | -122.393880343621 | (37.7273996474538, -122.393880343621) | 10 | 3 | 8 | 58 | 1 | ||||
98598 | 243976 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 18 | 6004556.64322 | 2096143.57753 | 37.7358690730924 | -122.426694711107 | (37.7358690730924, -122.426694711107) | 2 | 7 | 5 | 28861 | 2 | ||||
98748 | 217526 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2 Lobos St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5996904.36667 | 2088697.84896 | 37.7149892577353 | -122.452614326309 | (37.7149892577353, -122.452614326309) | 9 | 8 | 6 | 28861 | 24 | ||||
99328 | 199535 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 10 | Front Yard : Yard | Tree | Private 2 | 6 | 6014327.91583 | 2106402.88098 | 37.7645865385638 | -122.393629125195 | (37.7645865385638, -122.393629125195) | 14 | 3 | 8 | 310 | 29 | ||||
101340 | 199556 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 17 | : Yard | Tree | Private 2 | 4 | 6014441.57524 | 2105911.35616 | 37.7632432338158 | -122.393201608186 | (37.7632432338158, -122.393201608186) | 14 | 3 | 8 | 28856 | 29 | ||||
102062 | 199542 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 36 | Front Yard : Yard | Tree | Private 2 | 9 | 6014252.51342 | 2106695.17949 | 37.7653849359952 | -122.393910386379 | (37.7653849359952, -122.393910386379) | 14 | 3 | 8 | 28856 | 20 | ||||
107083 | 199540 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 31 | Front Yard : Yard | Tree | Private 2 | 4 | 6014294.90001 | 2106622.244 | 37.765187026683 | -122.393758674316 | (37.765187026683, -122.393758674316) | 14 | 3 | 8 | 310 | 29 | ||||
108035 | 199601 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 22nd St | 18 | Front Yard : Yard | Tree | Private 2 | 15 | 6013350.80583 | 2103837.53278 | 37.757488311954 | -122.396828844671 | (37.757488311954, -122.396828844671) | 10 | 3 | 8 | 28856 | 29 | ||||
108225 | 199577 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 3 | Median : Yard | Tree | DPW 1 | 15 | 6012278.40127 | 2102219.77174 | 37.7529865450046 | -122.400424041944 | (37.7529865450046, -122.400424041944) | 10 | 3 | 8 | 28856 | 29 | ||||
108866 | 181293 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 184 Mount Vernon Ave | 1 | Side Yard : Yard | Tree | Private 2 | 25 | 5998992.13606 | 2089349.93081 | 37.7168991290824 | -122.44544499659 | (37.7168991290824, -122.44544499659) | 9 | 7 | 6 | 28861 | 25 | ||||
109382 | 246640 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6009029.3215 | 2099227.55373 | 37.744588855582 | -122.411448646563 | (37.744588855582, -122.411448646563) | 2 | 7 | 7 | 28859 | 2 | ||||
109463 | 199598 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1400 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 65 | 6012249.21193 | 2101837.97965 | 37.7519365991191 | -122.400498168573 | (37.7519365991191, -122.400498168573) | 10 | 3 | 8 | 28856 | 29 | ||||
110592 | 247132 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 500 27th St | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 6003218.38287 | 2100061.52539 | 37.7465511016707 | -122.431601230532 | (37.7465511016707, -122.431601230532) | 2 | 7 | 5 | 63 | 22 | ||||
110609 | 246641 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6009029.72026 | 2099218.69445 | 37.744564552317 | -122.411446641953 | (37.744564552317, -122.411446641953) | 2 | 7 | 7 | 28859 | 2 | ||||
114215 | 202075 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 4 | Front Yard : Yard | Tree | Private 2 | 18 | 6012687.55592 | 2090674.96794 | 37.7213097380253 | -122.398199193847 | (37.7213097380253, -122.398199193847) | 10 | 3 | 8 | 58 | 1 | ||||
116538 | 199589 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 875 Vermont St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6011296.13019 | 2104285.32637 | 37.7586032752312 | -122.403966287131 | (37.7586032752312, -122.403966287131) | 10 | 3 | 8 | 28856 | 29 | ||||
117010 | 57583 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2001 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1976 12:00:00 AM | 31 | Permit Number 16451 | 6011409.07768 | 2106483.20737 | 37.764644474674 | -122.403730310432 | (37.764644474674, -122.403730310432) | 8 | 3 | 8 | 28856 | 29 | ||
121007 | 250140 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2550x Lyon St | 8 | Median : Yard | Tree | DPW 1 | 15 | 5999207.82154 | 2117620.05733 | 37.7945342406205 | -122.446732429154 | (37.7945342406205, -122.446732429154) | 13 | 1 | 57 | 30 | |||||
121475 | 217515 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 181 Staples Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998870.21413 | 2093813.74069 | 37.7291487568991 | -122.4461873294 | (37.7291487568991, -122.4461873294) | 9 | 7 | 4 | 28861 | 40 | ||||
122630 | 199621 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2330 Lane St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6013971.3633 | 2092946.01515 | 37.7276170037228 | -122.393920294208 | (37.7276170037228, -122.393920294208) | 10 | 3 | 8 | 58 | 1 | ||||
124548 | 243974 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 220 Coso Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6007544.45686 | 2099548.29836 | 37.7453861513651 | -122.416605743182 | (37.7453861513651, -122.416605743182) | 2 | 7 | 7 | 28859 | 2 | ||||
125020 | 199572 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 6012303.84438 | 2101937.88969 | 37.7522139769989 | -122.400316257304 | (37.7522139769989, -122.400316257304) | 10 | 3 | 8 | 28856 | 29 | ||||
125405 | 199545 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 1 | : Yard | Tree | Private 2 | 12 | 6014356.43896 | 2105915.99545 | 37.7632512422621 | -122.393496393361 | (37.7632512422621, -122.393496393361) | 14 | 3 | 8 | 28856 | 29 | ||||
129090 | 199590 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2150 26th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6012089.24008 | 2101393.99303 | 37.7507085856518 | -122.401020184544 | (37.7507085856518, -122.401020184544) | 10 | 3 | 8 | 28856 | 29 | ||||
131503 | 202074 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | 6012682.24985 | 2090663.29707 | 37.7212773966172 | -122.398216717151 | (37.7212773966172, -122.398216717151) | 10 | 3 | 8 | 58 | 1 | ||||
131609 | 217516 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998607.55261 | 2093227.99671 | 37.7275254374392 | -122.447053232615 | (37.7275254374392, -122.447053232615) | 9 | 7 | 4 | 28861 | 40 |
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) );