trees
390 rows where qSpecies_id = 126 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
51671 | 243965 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 60 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 73 | Width 5ft | 6005189.67155 | 2107490.26222 | 37.7670602101766 | -122.425313267905 | (37.7670602101766, -122.425313267905) | 8 | 4 | 5 | 28853 | 19 | |||
115507 | 243992 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 43 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 2ft | 6005443.40742 | 2108630.14777 | 37.7702043947487 | -122.424516723989 | (37.7702043947487, -122.424516723989) | 8 | 2 | 5 | 28853 | 19 | |||
144992 | 253609 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 318 Utah St | 2 | Front Yard : Yard | Tree | Private 2 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.406617457953 | (37.7654141639451, -122.406617457953) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
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 | |||
8279 | 199563 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012717.44536 | 2104654.08234 | 37.7596951043532 | -122.399076586828 | (37.7596951043532, -122.399076586828) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 | ||||
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 | |
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 | ||||
24638 | 199569 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1236 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6012213.10584 | 2102625.8594 | 37.7540979317002 | -122.400678372936 | (37.7540979317002, -122.400678372936) | 10 | 3 | 8 | 28856 | 29 | |||
24752 | 199526 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6014906.74898 | 2105806.13827 | 37.7629801596351 | -122.391585356499 | (37.7629801596351, -122.391585356499) | 14 | 3 | 8 | 28856 | 29 | |||
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 | ||||
28529 | 199578 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1275 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6012281.81813 | 2102445.37278 | 37.7536061868776 | -122.400428070902 | (37.7536061868776, -122.400428070902) | 10 | 3 | 8 | 28856 | 29 | |||
29794 | 199606 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1515 19th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6013141.4962 | 2105177.84105 | 37.7611568525403 | -122.397646731323 | (37.7611568525403, -122.397646731323) | 10 | 3 | 8 | 28856 | 29 | |||
31019 | 199561 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 6012720.09988 | 2104604.72261 | 37.7595597213173 | -122.399063941474 | (37.7595597213173, -122.399063941474) | 10 | 3 | 8 | 28856 | 29 | |||
31444 | 199600 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1500 22nd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6013491.56821 | 2103854.04221 | 37.7575414771611 | -122.396343185582 | (37.7575414771611, -122.396343185582) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
32789 | 32956 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1218 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | 3x8 | Permit Number 37270 | 6013588.68321 | 2106187.45016 | 37.7639539086769 | -122.396170851203 | (37.7639539086769, -122.396170851203) | 14 | 3 | 8 | 28856 | 29 |
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 | ||||
36481 | 199579 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2212 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6012144.74308 | 2101906.79924 | 37.7521197361546 | -122.400864273582 | (37.7521197361546, -122.400864273582) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
45739 | 199558 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 265 Arkansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 2ft | 6012944.07027 | 2105820.99329 | 37.7629118111405 | -122.398374675861 | (37.7629118111405, -122.398374675861) | 14 | 3 | 8 | 28856 | 29 | |||
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 | ||||
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 | ||||
53732 | 199599 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1510x 22nd St | 2 | Median : Cutout | Tree | DPW 1 | 9 | Width 6ft | 6013497.50922 | 2103827.38808 | 37.7574686213053 | -122.396320770893 | (37.7574686213053, -122.396320770893) | 10 | 3 | 8 | 28856 | 29 | |||
59861 | 199522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6015555.37035 | 2103675.62885 | 37.7571662188511 | -122.389193205711 | (37.7571662188511, -122.389193205711) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
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 | ||||
65066 | 199529 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1002 Pennsylvania Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 8ft | 6014459.21941 | 2102468.19683 | 37.7537900415949 | -122.392899675174 | (37.7537900415949, -122.392899675174) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
71941 | 199560 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1224 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6013565.3857 | 2106186.89187 | 37.763951079408 | -122.39625139179 | (37.763951079408, -122.39625139179) | 14 | 3 | 8 | 28856 | 29 | |||
72509 | 199520 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 900 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016073.01766 | 2101191.4647 | 37.7503739092406 | -122.387229690715 | (37.7503739092406, -122.387229690715) | 10 | 3 | 8 | 28856 | 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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
93407 | 199581 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 800 Vermont St | 36 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011269.47396 | 2104166.61707 | 37.7582758365713 | -122.404050122828 | (37.7582758365713, -122.404050122828) | 10 | 3 | 8 | 28856 | 29 | |||
100487 | 199576 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6012291.12869 | 2102166.26661 | 37.7528403413075 | -122.40037626996 | (37.7528403413075, -122.40037626996) | 10 | 3 | 8 | 28856 | 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 | ||||
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 | ||||
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 | ||||
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 | ||
119577 | 199585 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 875 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 8ft | 6011335.71651 | 2104267.18906 | 37.7585556858141 | -122.4038281027 | (37.7585556858141, -122.4038281027) | 10 | 3 | 8 | 28856 | 29 | |||
120379 | 199567 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 580 De Haro St | 12 | Front Yard : Yard | Tree | Private 2 | 4 | Width 5ft | 6012037.95559 | 2105660.50299 | 37.7624206230271 | -122.401497351342 | (37.7624206230271, -122.401497351342) | 8 | 3 | 8 | 28856 | 29 | |||
122476 | 199559 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 265 Arkansas St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6012943.102 | 2105838.27208 | 37.7629592009391 | -122.398379237231 | (37.7629592009391, -122.398379237231) | 14 | 3 | 8 | 28856 | 29 | |||
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 | ||||
126378 | 199586 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 875 Vermont St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 6011318.30745 | 2104281.86088 | 37.7585949987827 | -122.40388934384 | (37.7585949987827, -122.40388934384) | 10 | 3 | 8 | 28856 | 29 | |||
128769 | 199528 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 695 Minnesota St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 2ft | 6015204.40478 | 2105547.51975 | 37.7622865664905 | -122.390537786585 | (37.7622865664905, -122.390537786585) | 10 | 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 | ||||
131658 | 199554 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 10 | : Yard | Tree | Private 2 | 17 | 6014431.68682 | 2105923.15598 | 37.7632750842003 | -122.393236634966 | (37.7632750842003, -122.393236634966) | 14 | 3 | 8 | 28856 | 29 | ||||
133552 | 199527 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 18th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 2ft | 6014914.45801 | 2105734.69881 | 37.7627844302812 | -122.391553698568 | (37.7627844302812, -122.391553698568) | 10 | 3 | 8 | 28856 | 29 | |||
142127 | 199565 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6014128.38291 | 2101966.7218 | 37.7523947164539 | -122.394008689474 | (37.7523947164539, -122.394008689474) | 10 | 3 | 8 | 28856 | 1 | ||||
142592 | 199574 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 33 | Median : Yard | Tree | DPW 1 | 35 | 6012273.26957 | 2101981.44078 | 37.7523318538423 | -122.400425049202 | (37.7523318538423, -122.400425049202) | 10 | 3 | 8 | 28856 | 29 | ||||
142969 | 199582 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 889 Vermont St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6011322.9034 | 2104202.94749 | 37.7583785769172 | -122.403867895912 | (37.7583785769172, -122.403867895912) | 10 | 3 | 8 | 28856 | 29 | ||||
145630 | 199544 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 42 | Front Yard : Yard | Tree | Private 2 | 4 | 6014223.58604 | 2106699.16409 | 37.7653942691555 | -122.394010719216 | (37.7653942691555, -122.394010719216) | 14 | 3 | 8 | 28856 | 20 | ||||
148756 | 199587 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 875 Vermont St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011307.00123 | 2104284.0502 | 37.7586003785102 | -122.403928600141 | (37.7586003785102, -122.403928600141) | 10 | 3 | 8 | 28856 | 29 | ||||
149914 | 199580 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 920 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 10ft | 6011326.45045 | 2104017.48504 | 37.7578695363793 | -122.403842578193 | (37.7578695363793, -122.403842578193) | 10 | 3 | 8 | 28856 | 29 | |||
154704 | 199596 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700 22nd St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6012934.13528 | 2103807.83059 | 37.7573835553253 | -122.398267784253 | (37.7573835553253, -122.398267784253) | 10 | 3 | 8 | 28856 | 29 | ||||
155531 | 199551 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 7 | : Yard | Tree | Private 2 | 15 | 6014408.59689 | 2105921.94262 | 37.7632704697891 | -122.393316411129 | (37.7632704697891, -122.393316411129) | 14 | 3 | 8 | 28856 | 29 | ||||
158913 | 199562 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 6012719.76904 | 2104617.31298 | 37.7595942732681 | -122.399065969425 | (37.7595942732681, -122.399065969425) | 10 | 3 | 8 | 28856 | 29 | |||
163621 | 92398 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1919 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52800 | 6012329.06895 | 2103729.70142 | 37.7571353073613 | -122.400354868801 | (37.7571353073613, -122.400354868801) | 10 | 3 | 8 | 28856 | 29 | |
168037 | 199591 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2250 26th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6011839.26664 | 2101391.56211 | 37.7506879632992 | -122.401884448303 | (37.7506879632992, -122.401884448303) | 10 | 3 | 8 | 28856 | 29 | ||||
168884 | 199549 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 5 | : Yard | Tree | Private 2 | 9 | 6014392.26095 | 2105920.87265 | 37.7632666242892 | -122.393372837314 | (37.7632666242892, -122.393372837314) | 14 | 3 | 8 | 28856 | 29 | ||||
169737 | 199583 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 889 Vermont St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011324.46991 | 2104197.94013 | 37.7583649153354 | -122.403862125843 | (37.7583649153354, -122.403862125843) | 10 | 3 | 8 | 28856 | 29 | ||||
170044 | 199605 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 651 Missouri St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6013602.02772 | 2104054.17781 | 37.7580971520802 | -122.395975193824 | (37.7580971520802, -122.395975193824) | 10 | 3 | 8 | 28856 | 29 | ||||
170144 | 199607 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1515 19th St | 3 | : | Tree | Private 2 | 23 | Width 4ft | 6013161.794 | 2105177.42941 | 37.7611568525187 | -122.397576500574 | (37.7611568525187, -122.397576500574) | 10 | 3 | 8 | 28856 | 29 | |||
170277 | 199604 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 630 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | 6013529.78506 | 2104152.57114 | 37.7583632992371 | -122.396231937657 | (37.7583632992371, -122.396231937657) | 10 | 3 | 8 | 28856 | 29 | ||||
173215 | 199566 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1512 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 9ft | 6014108.69485 | 2102017.75026 | 37.7525337354666 | -122.394080346538 | (37.7525337354666, -122.394080346538) | 10 | 3 | 8 | 28856 | 29 | |||
174323 | 199523 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 4ft | 6015556.62319 | 2103663.95863 | 37.7571342443646 | -122.389188058008 | (37.7571342443646, -122.389188058008) | 10 | 3 | 8 | 28856 | 29 | |||
174973 | 199573 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6012315.17384 | 2101950.7126 | 37.7522498176817 | -122.400277978566 | (37.7522498176817, -122.400277978566) | 10 | 3 | 8 | 28856 | 29 | ||||
175137 | 119670 | Undocumented 4 | Yucca gloriosa :: Spanish Dagger 126 | 699x Missouri St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
178286 | 199594 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012053.10974 | 2101657.49367 | 37.751430085644 | -122.401163640783 | (37.751430085644, -122.401163640783) | 10 | 3 | 8 | 28856 | 29 | |||
179199 | 199564 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 6012717.45668 | 2104647.64454 | 37.7596774282013 | -122.399076095796 | (37.7596774282013, -122.399076095796) | 10 | 3 | 8 | 28856 | 29 | |||
181626 | 199521 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1112 Tennessee St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 58 | Width 6ft | 6015518.58105 | 2103812.19357 | 37.7575391569355 | -122.389329974622 | (37.7575391569355, -122.389329974622) | 10 | 3 | 8 | 28856 | 29 | |||
183169 | 199584 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 889 Vermont St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6011329.43673 | 2104204.01823 | 37.7583818819269 | -122.403845375987 | (37.7583818819269, -122.403845375987) | 10 | 3 | 8 | 28856 | 29 | ||||
186119 | 199519 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 575 San Bruno Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6010977.45969 | 2105690.75221 | 37.7624444505698 | -122.405167364075 | (37.7624444505698, -122.405167364075) | 8 | 3 | 8 | 28856 | 29 | |||
191233 | 199602 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 628 Missouri St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | 6013530.55815 | 2104182.03337 | 37.7584442391246 | -122.396231328824 | (37.7584442391246, -122.396231328824) | 10 | 3 | 8 | 28856 | 29 | ||||
193438 | 199593 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1451 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6012044.93423 | 2101620.11846 | 37.7513270053431 | -122.40118928678 | (37.7513270053431, -122.40118928678) | 10 | 3 | 8 | 28856 | 29 | ||||
193806 | 199575 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1300x De Haro St | 25 | Median : Yard | Tree | DPW 1 | 27 | 6012270.74731 | 2102100.89416 | 37.7526597061983 | -122.400442161487 | (37.7526597061983, -122.400442161487) | 10 | 3 | 8 | 28856 | 29 | ||||
103227 | 137516 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8 Kimball Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6007999.84688 | 2116492.3826 | 37.7919362386146 | -122.41623092104 | (37.7919362386146, -122.41623092104) | 5 | 1 | 10 | 28858 | 21 | |||
3852 | 243986 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 922 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6008569.40583 | 2103127.50468 | 37.7552714408323 | -122.413314689443 | (37.7552714408323, -122.413314689443) | 2 | 4 | 7 | 28859 | 19 | |||
13716 | 243963 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3450 26th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006727.57204 | 2100887.26512 | 37.7490166748846 | -122.419525382284 | (37.7490166748846, -122.419525382284) | 2 | 4 | 7 | 28859 | 19 | |||
23566 | 243983 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 23 Juri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 1ft | 6005990.8298 | 2101226.6861 | 37.749907121539 | -122.422097155577 | (37.749907121539, -122.422097155577) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||||
35549 | 243970 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6006476.24786 | 2097234.87805 | 37.7389738835382 | -122.420135291714 | (37.7389738835382, -122.420135291714) | 2 | 7 | 7 | 28859 | 2 |
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) );