trees
2,421 rows where qSpecies_id = 8 sorted by Supervisor Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1156 | 31893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.7706159506067 | -122.414182168285 | (37.7706159506067, -122.414182168285) | 8 | 2 | 9 | 28853 | 19 | |
2430 | 224109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006481.46308 | 2109309.64111 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | 8 | 2 | 9 | 28853 | 19 | |||
9156 | 73920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008409.30532 | 2108731.32076 | 37.7706492380987 | -122.414264830382 | (37.7706492380987, -122.414264830382) | 8 | 2 | 9 | 28853 | 19 | |||
9467 | 191059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 05th St | 2 | : | Tree | Private 2 | 6 | Width 5ft | 6011805.95608 | 2111927.87879 | 37.7796164636776 | -122.402740539939 | (37.7796164636776, -122.402740539939) | 14 | 2 | 9 | 28856 | 34 | |||
9670 | 85554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
14957 | 85546 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
15417 | 224105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006280.26739 | 2109523.46395 | 37.7727044515829 | -122.421685485523 | (37.7727044515829, -122.421685485523) | 8 | 2 | 9 | 28853 | 19 | |||
15449 | 85521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
17486 | 191662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013078.45063 | 2110885.87068 | 37.776826313422 | -122.398265274217 | (37.776826313422, -122.398265274217) | 6 | 2 | 9 | 28856 | 34 | |||
17998 | 85553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 332 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008375 | 2108695 | 37.7705475827471 | -122.414380922989 | (37.7705475827471, -122.414380922989) | 8 | 2 | 9 | 28853 | 19 | |||
18144 | 70989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 779764 | 6008399.52743 | 2108738.25581 | 37.770667730873 | -122.414299143103 | (37.770667730873, -122.414299143103) | 8 | 2 | 9 | 28853 | 19 | ||
18922 | 74929 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014021.82023 | 2112985.48182 | 37.7826438712502 | -122.395148955186 | (37.7826438712502, -122.395148955186) | 6 | 2 | 9 | 28856 | 6 | |||
21310 | 254733 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 3x3 | 6008656 | 2108503 | 37.7700361768699 | -122.413395357755 | (37.7700361768699, -122.413395357755) | 8 | 2 | 9 | 28853 | 19 | |||
24502 | 191066 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011926.00282 | 2111797.31864 | 37.7792646776498 | -122.40231606173 | (37.7792646776498, -122.40231606173) | 14 | 2 | 9 | 28856 | 34 | |||
31166 | 191060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 1 | Width 2ft | 6011653.22625 | 2111699.06795 | 37.7789796735174 | -122.403252800969 | (37.7789796735174, -122.403252800969) | 14 | 2 | 9 | 28856 | 34 | |||
32023 | 85527 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
33288 | 191666 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013244.57038 | 2111045.61556 | 37.7772741883968 | -122.397701819284 | (37.7772741883968, -122.397701819284) | 6 | 2 | 9 | 28856 | 34 | |||
36375 | 191665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013224.69067 | 2111029.20074 | 37.7772280099979 | -122.397769438408 | (37.7772280099979, -122.397769438408) | 6 | 2 | 9 | 28856 | 34 | |||
42967 | 173911 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
43105 | 85526 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
46431 | 173910 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
51660 | 122788 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007172 | 2109097 | 37.7715837270561 | -122.418570631079 | (37.7715837270561, -122.418570631079) | 8 | 2 | 9 | 28853 | 19 | ||||
54350 | 90432 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | ||
55451 | 256092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6007860.62906 | 2108997.35701 | 37.7713488754693 | -122.416181558888 | (37.7713488754693, -122.416181558888) | 8 | 2 | 9 | 28853 | 19 | |||||
56042 | 100781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 211 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007785.14748 | 2109092.4486 | 37.7716057300517 | -122.416449390639 | (37.7716057300517, -122.416449390639) | 8 | 2 | 9 | 28853 | 19 | |||
56742 | 191077 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 334 12th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008423.37153 | 2108669.51917 | 37.7704803355249 | -122.414211801833 | (37.7704803355249, -122.414211801833) | 8 | 2 | 9 | 28853 | 19 | |||
59073 | 90431 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770519 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | |
59674 | 191663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013137.81115 | 2110946.71833 | 37.7769966935644 | -122.398064196625 | (37.7769966935644, -122.398064196625) | 6 | 2 | 9 | 28856 | 34 | |||
61671 | 191072 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 4 | : | Tree | Private 2 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.7703385556015 | -122.413547385421 | (37.7703385556015, -122.413547385421) | 8 | 2 | 9 | 28853 | 19 | ||
62515 | 90438 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 48X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006368.067431 | 2109508.884182 | 37.7726693696552 | -122.421380739497 | (37.7726693696552, -122.421380739497) | 8 | 2 | 9 | 28853 | 19 | ||
62574 | 191667 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013269.51559 | 2111071.49251 | 37.7773466296777 | -122.397617340561 | (37.7773466296777, -122.397617340561) | 6 | 2 | 9 | 28856 | 34 | |||
63023 | 191073 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 12th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6008306.80877 | 2108790.44152 | 37.7708058118746 | -122.41462355284 | (37.7708058118746, -122.41462355284) | 8 | 2 | 9 | 28853 | 19 | |||
64496 | 85535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 5 | 6007364.04136 | 2109271.58584 | 37.7720739081089 | -122.41791872548 | (37.7720739081089, -122.41791872548) | 8 | 2 | 9 | 28853 | 19 | |||
65939 | 85545 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007812 | 2109019 | 37.7714055675706 | -122.416351302737 | (37.7714055675706, -122.416351302737) | 8 | 2 | 9 | 28853 | 19 | |||
66319 | 251315 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008830 | 2108632 | 37.7704001487298 | -122.41280261367 | (37.7704001487298, -122.41280261367) | 8 | 2 | 9 | 28853 | 19 | ||||
68081 | 191061 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 0 | : | Tree | Private 2 | 6 | Width 3ft | 6011653.56606 | 2111728.79849 | 37.779061325667 | -122.403253717397 | (37.779061325667, -122.403253717397) | 14 | 2 | 9 | 28856 | 34 | |||
69618 | 191057 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 351 Saint Francis Pl | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013212.85575 | 2113183.51616 | 37.78314260738 | -122.397961541709 | (37.78314260738, -122.397961541709) | 6 | 2 | 9 | 28856 | 6 | |||
69970 | 191076 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 12th St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6008335.79472 | 2108708.57829 | 37.7705826631 | -122.414517495805 | (37.7705826631, -122.414517495805) | 8 | 2 | 9 | 28853 | 19 | |||
70118 | 85528 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 225X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007748.883838 | 2109107.739625 | 37.771645676205 | -122.416575912394 | (37.771645676205, -122.416575912394) | 8 | 2 | 9 | 28853 | 19 | |||
70902 | 85555 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
71150 | 191672 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007932.20387 | 2108945.73927 | 37.7712111695782 | -122.415930321737 | (37.7712111695782, -122.415930321737) | 8 | 2 | 9 | 28853 | 19 | |||
72439 | 246381 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6006946.7351 | 2109071.9998 | 37.7715023978524 | -122.419348063063 | (37.7715023978524, -122.419348063063) | 8 | 2 | 9 | 28853 | 19 | |||
73566 | 90435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006637.011883 | 2109229.055885 | 37.7719161875872 | -122.420430563972 | (37.7719161875872, -122.420430563972) | 8 | 2 | 9 | 28853 | 19 | ||
76303 | 85538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007511.05272 | 2109187.82256 | 37.7718521865557 | -122.417404262918 | (37.7718521865557, -122.417404262918) | 8 | 2 | 9 | 28853 | 19 | |||
80770 | 85540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007564 | 2109156 | 37.7717677882225 | -122.417218858728 | (37.7717677882225, -122.417218858728) | 8 | 2 | 9 | 28853 | 19 | |||
81603 | 85537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007421.29052 | 2109238.78217 | 37.7719870587743 | -122.417718370032 | (37.7719870587743, -122.417718370032) | 8 | 2 | 9 | 28853 | 19 | |||
82399 | 224103 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006296.39827 | 2109605.75372 | 37.7729313091609 | -122.421635532653 | (37.7729313091609, -122.421635532653) | 8 | 2 | 9 | 28853 | 19 | |||
82966 | 255270 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6006259.41691 | 2109543.76315 | 37.7727590125447 | -122.421759051834 | (37.7727590125447, -122.421759051834) | 8 | 2 | 9 | 28853 | 19 | ||||
88212 | 191064 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 6011636.45479 | 2111621.63376 | 37.7787661204973 | -122.403305371746 | (37.7787661204973, -122.403305371746) | 14 | 2 | 9 | 28856 | 34 | |||
92376 | 85523 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
92559 | 91019 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006519.340216 | 2109351.489576 | 37.7722457294122 | -122.420846293315 | (37.7722457294122, -122.420846293315) | 8 | 2 | 9 | 28853 | 19 | ||
92791 | 191062 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 236 Clara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6011643.64166 | 2111627.47024 | 37.7787825475055 | -122.403280920094 | (37.7787825475055, -122.403280920094) | 14 | 2 | 9 | 28856 | 34 | |||
93307 | 224107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006435.98558 | 2109358.16079 | 37.7722593483308 | -122.421135098612 | (37.7722593483308, -122.421135098612) | 8 | 2 | 9 | 28853 | 19 | |||
94102 | 28997 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321X 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008985.04718 | 2109404.34917 | 37.7725295406243 | -122.412320901705 | (37.7725295406243, -122.412320901705) | 8 | 2 | 9 | 28853 | 34 | ||
95257 | 110438 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775407 | 6007788.2 | 2109003.3 | 37.7713611206973 | -122.416432516069 | (37.7713611206973, -122.416432516069) | 8 | 2 | 9 | 28853 | 19 | |
96061 | 90436 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 8 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006637.011883 | 2109229.055885 | 37.7719161875872 | -122.420430563972 | (37.7719161875872, -122.420430563972) | 8 | 2 | 9 | 28853 | 19 | ||
96936 | 85544 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007812 | 2109019 | 37.7714055675706 | -122.416351302737 | (37.7714055675706, -122.416351302737) | 8 | 2 | 9 | 28853 | 19 | |||
98310 | 63152 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 230 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23688 | 6008095.93385005 | 2113196.54307112 | 37.7828920680587 | -122.415664995853 | (37.7828920680587, -122.415664995853) | 7 | 10 | 9 | 28852 | 36 | ||
99188 | 85556 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
103270 | 90433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | ||
103339 | 191673 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007961.75494 | 2108927.69321 | 37.771163280688 | -122.415826825061 | (37.771163280688, -122.415826825061) | 8 | 2 | 9 | 28853 | 19 | |||
104675 | 85543 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007812 | 2109019 | 37.7714055675706 | -122.416351302737 | (37.7714055675706, -122.416351302737) | 8 | 2 | 9 | 28853 | 19 | |||
104744 | 85536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007398.39847 | 2109252.27561 | 37.7720228203246 | -122.417798512189 | (37.7720228203246, -122.417798512189) | 8 | 2 | 9 | 28853 | 19 | |||
104786 | 191065 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Clara St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6011631.45196 | 2111618.92007 | 37.7787583899224 | -122.403322487638 | (37.7787583899224, -122.403322487638) | 14 | 2 | 9 | 28856 | 34 | |||
105140 | 85550 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
105371 | 191674 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007983.0809 | 2108917.80929 | 37.7711373406456 | -122.41575235758 | (37.7711373406456, -122.41575235758) | 8 | 2 | 9 | 28853 | 19 | |||
105700 | 191671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007916.30437 | 2108953.33208 | 37.7712311237499 | -122.415985856679 | (37.7712311237499, -122.415985856679) | 8 | 2 | 9 | 28853 | 19 | |||
106066 | 191079 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1559 Howard St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6007858.27887 | 2109378.13672 | 37.7723942745191 | -122.416216661379 | (37.7723942745191, -122.416216661379) | 8 | 2 | 9 | 28853 | 19 | |||
106973 | 85522 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
108528 | 191677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007442.31511 | 2109225.32703 | 37.7719512972482 | -122.417644690367 | (37.7719512972482, -122.417644690367) | 8 | 2 | 9 | 28853 | 19 | |||
108598 | 191067 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/2014 12:00:00 AM | 8 | Width 3ft | 6011934.76855 | 2111785.94153 | 37.779233928048 | -122.402284937117 | (37.779233928048, -122.402284937117) | 14 | 2 | 9 | 28856 | 34 | ||
109402 | 255703 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782078 | 6009781.99069 | 2112750.42942 | 37.7817617797421 | -122.409800416291 | (37.7817617797421, -122.409800416291) | 14 | 2 | 9 | 28853 | 34 | |
112674 | 85547 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
113152 | 85530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007333.48731 | 2109350.50444 | 37.7722888802537 | -122.418030010287 | (37.7722888802537, -122.418030010287) | 8 | 2 | 9 | 28853 | 19 | |||
113778 | 224106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006301.05377 | 2109500.02866 | 37.7726412760089 | -122.421611918271 | (37.7726412760089, -122.421611918271) | 8 | 2 | 9 | 28853 | 19 | |||
114137 | 253629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
114851 | 192937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 394 12th St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6008622.94883 | 2108550.94003 | 37.770165953233 | -122.413513072694 | (37.770165953233, -122.413513072694) | 8 | 2 | 9 | 28853 | 19 | |||
116157 | 224110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006506.1757 | 2109285.60199 | 37.7720640758221 | -122.420887151946 | (37.7720640758221, -122.420887151946) | 8 | 2 | 9 | 28853 | 19 | |||
116707 | 85542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007856.45059 | 2108988.34971 | 37.7713239085987 | -122.416195374412 | (37.7713239085987, -122.416195374412) | 8 | 2 | 9 | 28853 | 19 | |||
118077 | 85533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007332.25294 | 2109288.61069 | 37.7721188652314 | -122.418029891562 | (37.7721188652314, -122.418029891562) | 8 | 2 | 9 | 28853 | 19 | |||
119852 | 85539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007548.32218 | 2109164.73144 | 37.7717908806656 | -122.417273708325 | (37.7717908806656, -122.417273708325) | 8 | 2 | 9 | 28853 | 19 | |||
119957 | 253631 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 6009957.29008 | 2113442.89538 | 37.7836729493992 | -122.409242840109 | (37.7836729493992, -122.409242840109) | 14 | 10 | 9 | 28852 | 36 | ||||
123555 | 44768 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 712 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | 6 | Permit Number 43876 | 6012361.28636 | 2111165.48886 | 37.7775541068837 | -122.400765825683 | (37.7775541068837, -122.400765825683) | 14 | 2 | 9 | 28856 | 34 | ||
124170 | 85525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
124716 | 91020 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006519.340216 | 2109351.489576 | 37.7722457294122 | -122.420846293315 | (37.7722457294122, -122.420846293315) | 8 | 2 | 9 | 28853 | 19 | ||
125701 | 85558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008677.32979 | 2108520.19339 | 37.7700845834737 | -122.413322794134 | (37.7700845834737, -122.413322794134) | 8 | 2 | 9 | 28853 | 19 | |||
125971 | 85531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007317.96828 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | 8 | 2 | 9 | 28853 | 19 | |||
127278 | 81551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 555 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50132 | 6009979.0752 | 2111765.16578 | 37.7790675210845 | -122.409049052091 | (37.7790675210845, -122.409049052091) | 14 | 2 | 9 | 28853 | 34 | |
127723 | 251316 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008830 | 2108632 | 37.7704001487298 | -122.41280261367 | (37.7704001487298, -122.41280261367) | 8 | 2 | 9 | 28853 | 19 | ||||
128307 | 191669 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 2 | Width 3ft | 6007874.13645 | 2108978.90348 | 37.771298965913 | -122.416133528945 | (37.771298965913, -122.416133528945) | 8 | 2 | 9 | 28853 | 19 | ||
129518 | 85548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | ||||
134922 | 106798 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009957 | 2113442 | 37.783670474647 | -122.409243780474 | (37.783670474647, -122.409243780474) | 14 | 10 | 9 | 28852 | 36 | ||||
136185 | 28906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.7795285306637 | -122.402635398413 | (37.7795285306637, -122.402635398413) | 14 | 2 | 9 | 28856 | 34 | |
138977 | 191071 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6008644.67271 | 2108598.98896 | 37.7702991041399 | -122.413441328359 | (37.7702991041399, -122.413441328359) | 8 | 2 | 9 | 28853 | 19 | |||
141455 | 224101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2x Gough St | 5 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006607.58912 | 2109275.93798 | 37.7720432565284 | -122.420535668101 | (37.7720432565284, -122.420535668101) | 8 | 2 | 9 | 28853 | 19 | |||
142294 | 224104 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006259.41691 | 2109543.76315 | 37.7727590125447 | -122.421759051834 | (37.7727590125447, -122.421759051834) | 8 | 2 | 9 | 28853 | 19 | |||
146836 | 44769 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 712 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43876 | 6012402.09298601 | 2111195.83512486 | 37.7776397067003 | -122.400626793323 | (37.7776397067003, -122.400626793323) | 14 | 2 | 9 | 28856 | 34 | |||
146915 | 191670 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007891.80002 | 2108968.36802 | 37.7712710311727 | -122.416071683472 | (37.7712710311727, -122.416071683472) | 8 | 2 | 9 | 28853 | 19 | |||
146918 | 191664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013199.96962 | 2111004.76664 | 37.7771595428277 | -122.397853242637 | (37.7771595428277, -122.397853242637) | 6 | 2 | 9 | 28856 | 34 | |||
148796 | 191661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013060.06963 | 2110865.5961 | 37.7767696201591 | -122.398327437183 | (37.7767696201591, -122.398327437183) | 6 | 2 | 9 | 28856 | 34 |
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) );