trees
183 rows where qSpecies_id = 119 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 561 | 19835 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
| 8381 | 19836 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
| 9086 | 19838 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
| 9550 | 20003 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY46 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | |||||||||||||
| 11967 | 19792 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY19 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
| 17879 | 19817 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 17991 | 19926 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY37 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 93765 | 191710 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1427x Innes Ave | 28 | Median : Yard | Tree | DPW 1 | 3 | 6016141.21336 | 2096757.17707 | 37.7382020430791 | -122.386684681762 | (37.7382020430791, -122.386684681762) | 10 | 3 | 8 | 58 | 1 | ||||
| 34549 | 191699 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 50 Quint St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 6ft | 6015737.97927 | 2099766.71571 | 37.7464432855229 | -122.388288861864 | (37.7464432855229, -122.388288861864) | 10 | 3 | 8 | 58 | 1 | |||
| 73718 | 191698 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 602 Arthur Ave | 35 | Front Yard : Yard | Tree | Private 2 | 2 | 6015659.04453 | 2099869.60737 | 37.7467214305684 | -122.38856899259 | (37.7467214305684, -122.38856899259) | 3 | 8 | 58 | 1 | |||||
| 2236 | 71359 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1620 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015449.34332 | 2096256.73769 | 37.7367896101585 | -122.389041914574 | (37.7367896101585, -122.389041914574) | 10 | 3 | 8 | 58 | 1 | |||
| 17085 | 73562 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1620 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015449.23036 | 2096256.56638 | 37.7367891335144 | -122.389042293172 | (37.7367891335144, -122.389042293172) | 10 | 3 | 8 | 58 | 1 | |||
| 80883 | 191686 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1301 Minnesota St | 14 | Front Yard : Yard | Tree | Private 2 | 6 | 6015385.37717 | 2102357.37277 | 37.7535371423304 | -122.389689042427 | (37.7535371423304, -122.389689042427) | 10 | 3 | 8 | 28856 | 29 | ||||
| 35044 | 191685 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1301 Minnesota St | 13 | Front Yard : Yard | Tree | Private 2 | 4 | 6015385.02289 | 2102351.05831 | 37.7535197845136 | -122.389689826618 | (37.7535197845136, -122.389689826618) | 10 | 3 | 8 | 28856 | 29 | ||||
| 183711 | 191687 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 800 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6015123.17396 | 2105339.16037 | 37.7617099499859 | -122.390804173874 | (37.7617099499859, -122.390804173874) | 10 | 3 | 8 | 28856 | 29 | |||
| 118049 | 191688 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 800 19th St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6014977.94549 | 2105331.22601 | 37.7616801050661 | -122.39130591015 | (37.7616801050661, -122.39130591015) | 10 | 3 | 8 | 28856 | 29 | |||
| 58793 | 18564 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700X Quesada Ave | 19 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014511.59225 | 2095170.64304 | 37.7337553901961 | -122.392208220649 | (37.7337553901961, -122.392208220649) | 10 | 3 | 8 | 58 | 1 | |||
| 44756 | 191700 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700x Quesada Ave | 39 | Median : Yard | Tree | DPW 1 | 3 | 6014384.30677 | 2095263.82729 | 37.7340041867507 | -122.392654804178 | (37.7340041867507, -122.392654804178) | 10 | 3 | 8 | 58 | 1 | ||||
| 157864 | 191689 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1 01st St | 27 | : Yard | Tree | Private 2 | 3 | 6014402.09171 | 2105890.67407 | 37.7631842517621 | -122.393336722306 | (37.7631842517621, -122.393336722306) | 14 | 3 | 8 | 28856 | 29 | ||||
| 51320 | 191705 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700 Armstrong Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6013900.77828 | 2092879.68746 | 37.7274309582526 | -122.394159667654 | (37.7274309582526, -122.394159667654) | 10 | 3 | 8 | 58 | 1 | ||||
| 80989 | 200198 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3125 Jennings St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 6013701.6232 | 2090281.2208 | 37.7202850194185 | -122.394666263771 | (37.7202850194185, -122.394666263771) | 10 | 3 | 8 | 58 | 1 | |||
| 122202 | 191708 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 979 Le Conte Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6013251.20953 | 2089459.918 | 37.7180048338374 | -122.396165676526 | (37.7180048338374, -122.396165676526) | 10 | 3 | 8 | 58 | 1 | ||||
| 156568 | 176281 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 600 Blanken Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6013188.37125 | 2086854.32403 | 37.7108468913331 | -122.396200370571 | (37.7108468913331, -122.396200370571) | 10 | 3 | 8 | 309 | 1 | |||
| 96190 | 176280 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 600 Blanken Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6013180.81524 | 2086857.67381 | 37.7108556687339 | -122.396226720696 | (37.7108556687339, -122.396226720696) | 10 | 3 | 8 | 309 | 1 | |||
| 153174 | 191704 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1501 Quint St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | Width 4ft | 6013263.69136 | 2096352.02038 | 37.7369298387513 | -122.396605400918 | (37.7369298387513, -122.396605400918) | 10 | 3 | 8 | 58 | 1 | |||
| 8877 | 191703 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1501 Quint St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 4ft | 6013259.66608 | 2096346.42133 | 37.7369142408999 | -122.396618925818 | (37.7369142408999, -122.396618925818) | 10 | 3 | 8 | 58 | 1 | |||
| 98191 | 173854 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 240 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013446 | 2105960 | 37.763321440581 | -122.396648407729 | (37.763321440581, -122.396648407729) | 14 | 3 | 8 | 28856 | 29 | ||||
| 180779 | 22498 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 6404 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | 3 | 3X3 | 6013069.4059 | 2090221.21293 | 37.7200850799347 | -122.396847440878 | (37.7200850799347, -122.396847440878) | 10 | 3 | 8 | 58 | 1 | ||
| 107585 | 191709 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3535 Jennings St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6013020.36677 | 2089365.26266 | 37.7177320820479 | -122.39695697201 | (37.7177320820479, -122.39695697201) | 10 | 3 | 8 | 58 | 1 | ||||
| 118144 | 201358 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 245 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 2ft | 6013008.61874 | 2092664.02794 | 37.7267891723748 | -122.39722877051 | (37.7267891723748, -122.39722877051) | 10 | 3 | 8 | 58 | 1 | |||
| 122868 | 17442 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1944 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6013068.40824 | 2096637.61256 | 37.73770314508 | -122.397300607455 | (37.73770314508, -122.397300607455) | 10 | 3 | 8 | 58 | 1 | |||
| 39476 | 191702 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1998 Revere Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6013024.54675 | 2095962.65305 | 37.7358474048249 | -122.397404937794 | (37.7358474048249, -122.397404937794) | 10 | 3 | 8 | 58 | 1 | ||||
| 148321 | 191696 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700 22nd St | 3 | Front Yard : Yard | Tree | Private 2 | 7 | 6012930.9536 | 2103804.38992 | 37.7573739307682 | -122.398278546439 | (37.7573739307682, -122.398278546439) | 10 | 3 | 8 | 28856 | 29 | ||||
| 74905 | 191701 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2025 Revere Ave | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6012750.04967 | 2096000.36179 | 37.7359356579989 | -122.398356633674 | (37.7359356579989, -122.398356633674) | 10 | 3 | 8 | 58 | 1 | |||
| 163389 | 191697 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700 22nd St | 7 | Front Yard : Yard | Tree | Private 2 | 13 | 6012906.92778 | 2103803.94978 | 37.7573713838993 | -122.398361606903 | (37.7573713838993, -122.398361606903) | 10 | 3 | 8 | 28856 | 29 | ||||
| 25767 | 191706 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1499 Rankin St | 7 | Side Yard : Yard | Tree | Private 2 | 1 | Width 3ft | 6012685.03055 | 2096691.54362 | 37.7378298766422 | -122.398629920547 | (37.7378298766422, -122.398629920547) | 10 | 3 | 8 | 58 | 1 | |||
| 160265 | 54637 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1747 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10460 | 6012648.74415 | 2095666.17396 | 37.7350124040996 | -122.398683444593 | (37.7350124040996, -122.398683444593) | 10 | 3 | 8 | 58 | 1 | ||
| 76618 | 191690 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 900x Carolina St | 22 | Median : Yard | Tree | DPW 1 | 2 | 6012468.62754 | 2103498.74867 | 37.7565089430612 | -122.399856001374 | (37.7565089430612, -122.399856001374) | 10 | 3 | 8 | 28856 | 29 | ||||
| 143684 | 202013 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 7 Wheat St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012149.42791 | 2091374.55614 | 37.7232006759464 | -122.400108468936 | (37.7232006759464, -122.400108468936) | 10 | 3 | 8 | 58 | 1 | |||
| 158130 | 191693 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2212 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012143.16846 | 2101895.7398 | 37.7520892815067 | -122.400868941954 | (37.7520892815067, -122.400868941954) | 10 | 3 | 8 | 28856 | 29 | |||
| 154304 | 191694 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2250 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012110.05032 | 2101893.72392 | 37.7520818989832 | -122.400983328513 | (37.7520818989832, -122.400983328513) | 10 | 3 | 8 | 28856 | 29 | |||
| 119543 | 191707 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2187 Revere Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6011937.92175 | 2096699.93433 | 37.7378112633764 | -122.401213644004 | (37.7378112633764, -122.401213644004) | 10 | 3 | 8 | 58 | 1 | ||||
| 123750 | 191692 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 764 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6012093.5937 | 2104845.22166 | 37.7601851458373 | -122.401247624904 | (37.7601851458373, -122.401247624904) | 10 | 3 | 8 | 28856 | 29 | ||||
| 131673 | 111563 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1498x Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6011720.06091 | 2101415.90544 | 37.7507481513226 | -122.40229838558 | (37.7507481513226, -122.40229838558) | 10 | 3 | 8 | 28856 | 29 | |||
| 87106 | 191695 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 950x Kansas St | 4 | Median : Yard | Tree | DPW 1 | 4 | 6011603.94241 | 2103847.92507 | 37.7574194607598 | -122.402870964129 | (37.7574194607598, -122.402870964129) | 10 | 3 | 8 | 28856 | 29 | ||||
| 24987 | 249981 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 224 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011659.45074 | 2120118.51197 | 37.8020978133144 | -122.403823874987 | (37.8020978133144, -122.403823874987) | 3 | 1 | 10 | 308 | 23 | |||
| 74386 | 249863 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 233 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 6011630.03083 | 2120434.01589 | 37.8029624665125 | -122.403947897788 | (37.8029624665125, -122.403947897788) | 3 | 1 | 10 | 308 | 23 | |||
| 14087 | 72881 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 130 Alpha St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010899.06821 | 2088108.56402 | 37.7141631333099 | -122.404200991296 | (37.7141631333099, -122.404200991296) | 9 | 7 | 8 | 309 | 39 | |||
| 135280 | 187568 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 138 Alpha St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6010896.54149 | 2088103.23155 | 37.7141483502397 | -122.404209349584 | (37.7141483502397, -122.404209349584) | 9 | 7 | 8 | 309 | 39 | |||
| 118137 | 249880 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 230 Greenwich St | 16 | Back Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011523.78476 | 2120446.01272 | 37.8029894704488 | -122.404316411196 | (37.8029894704488, -122.404316411196) | 3 | 1 | 10 | 28860 | 6 | |||
| 70334 | 249883 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 230 Greenwich St | 19 | Back Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011507.08304 | 2120427.11079 | 37.8029366370675 | -122.404372876909 | (37.8029366370675, -122.404372876909) | 3 | 1 | 10 | 308 | 23 | |||
| 56792 | 249890 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 230 Greenwich St | 26 | Back Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011458.55673 | 2120431.85719 | 37.8029469576839 | -122.404541138271 | (37.8029469576839, -122.404541138271) | 3 | 1 | 10 | 28860 | 6 | |||
| 86235 | 249846 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 289 Greenwich St | 3 | Side Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6011427.16735 | 2120382.55668 | 37.8028098362532 | -122.404646289706 | (37.8028098362532, -122.404646289706) | 3 | 1 | 10 | 308 | 23 | |||
| 172147 | 249903 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 300 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 17 | Width 0ft | 6011307.54061 | 2120412.72536 | 37.8028859854681 | -122.405062387114 | (37.8028859854681, -122.405062387114) | 3 | 1 | 10 | 308 | 23 | |||
| 41791 | 249910 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 308 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 6011272.31007 | 2120413.30181 | 37.8028855987512 | -122.405184344187 | (37.8028855987512, -122.405184344187) | 3 | 1 | 10 | 308 | 23 | |||
| 136327 | 191691 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2301 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6010894.94565 | 2105057.58809 | 37.7607013108401 | -122.405408158461 | (37.7607013108401, -122.405408158461) | 10 | 3 | 8 | 28856 | 29 | ||||
| 126650 | 247967 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 16 Joy St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6010333.49571 | 2098927.49611 | 37.7438380268983 | -122.40691790615 | (37.7438380268983, -122.40691790615) | 2 | 7 | 7 | 28859 | 2 | ||||
| 121776 | 143060 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 444 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010718.0238 | 2120346.7181 | 37.8026717731778 | -122.407097773383 | (37.8026717731778, -122.407097773383) | 3 | 1 | 10 | 308 | 23 | |||
| 9946 | 247879 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 388 Mayflower St | 8 | Side Yard : Yard | Tree | Private 2 | 3 | 6009924.14803 | 2098382.32436 | 37.7423181897436 | -122.408294896795 | (37.7423181897436, -122.408294896795) | 10 | 7 | 7 | 28859 | 2 | ||||
| 120318 | 247873 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 388 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6009888.01932 | 2098399.59712 | 37.7423635938187 | -122.408421037503 | (37.7423635938187, -122.408421037503) | 10 | 7 | 7 | 28859 | 2 | ||||
| 70351 | 224117 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2818 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009831.98095 | 2102814.76339 | 37.7544835286044 | -122.408926245167 | (37.7544835286044, -122.408926245167) | 2 | 4 | 7 | 28859 | 19 | |||
| 87091 | 224118 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1525 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009611.07907 | 2100364.72243 | 37.7477438841853 | -122.409517278718 | (37.7477438841853, -122.409517278718) | 2 | 7 | 7 | 28859 | 2 | |||
| 50533 | 113121 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 1x TOMASO CT | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
| 174138 | 113120 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 1x TOMASO CT | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
| 188172 | 176283 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 35 Tomaso Ct | 9 | Side Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6009206.42472 | 2086339.23376 | 37.7092101890802 | -122.40992661864 | (37.7092101890802, -122.40992661864) | 9 | 7 | 8 | 309 | 39 | |||
| 158281 | 246774 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1850 Alabama St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6009457.96402 | 2098740.81971 | 37.7432764236648 | -122.409932126974 | (37.7432764236648, -122.409932126974) | 2 | 7 | 7 | 28859 | 2 | ||||
| 151602 | 176282 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 35 Tomaso Ct | 8 | Side Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6009202.48899 | 2086331.05779 | 37.7091875189513 | -122.409939644414 | (37.7091875189513, -122.409939644414) | 9 | 7 | 8 | 309 | 39 | |||
| 36602 | 126561 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 8 Codman Pl | 2 | Back Yard : Yard | Tree | Private 2 | 7 | 6009832.93804 | 2117260.06639 | 37.7941470150322 | -122.40994260679 | (37.7941470150322, -122.40994260679) | 3 | 1 | 10 | 28857 | 21 | ||||
| 165069 | 126562 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 8 Codman Pl | 1 | Back Yard : Yard | Tree | Private 2 | 9 | 6009829.32931 | 2117256.53261 | 37.7941371098806 | -122.409954843859 | (37.7941371098806, -122.409954843859) | 3 | 1 | 10 | 28857 | 21 | ||||
| 47335 | 176276 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 62 Tomaso Ct | 7 | Front Yard : Yard | Tree | Private 2 | 12 | Width 8ft | 6009192.32266 | 2086308.36594 | 37.7091246419674 | -122.409973180132 | (37.7091246419674, -122.409973180132) | 9 | 7 | 8 | 309 | 39 | |||
| 38491 | 246771 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1850 Alabama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6009333.37029 | 2098874.50038 | 37.743636497837 | -122.410372378408 | (37.743636497837, -122.410372378408) | 2 | 7 | 7 | 28859 | 2 | ||||
| 47047 | 246754 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1838 Alabama St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6009313.62627 | 2099009.88757 | 37.7440071345341 | -122.410450206611 | (37.7440071345341, -122.410450206611) | 2 | 7 | 7 | 28859 | 2 | ||||
| 110805 | 246755 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1838 Alabama St | 2 | Front Yard : Yard | Tree | Private 2 | 16 | 6009311.20113 | 2098998.06122 | 37.7439745260177 | -122.410457757318 | (37.7439745260177, -122.410457757318) | 2 | 7 | 7 | 28859 | 2 | ||||
| 54915 | 246770 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 99 Waltham St | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 6009309.01668 | 2098932.20278 | 37.7437935707282 | -122.410460661231 | (37.7437935707282, -122.410460661231) | 2 | 7 | 7 | 28859 | 2 | ||||
| 187997 | 246764 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 70 Waltham St | 8 | Front Yard : Yard | Tree | Private 2 | 8 | 6009279.96949 | 2098891.64841 | 37.7436805888792 | -122.410558236772 | (37.7436805888792, -122.410558236772) | 2 | 7 | 7 | 28859 | 2 | ||||
| 163446 | 224131 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1340 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009255.1331 | 2101276.97976 | 37.7502287892492 | -122.410812544378 | (37.7502287892492, -122.410812544378) | 2 | 4 | 7 | 28859 | 19 | |||
| 58166 | 109887 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1024 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6009193.94635 | 2118049.36414 | 37.7962784001887 | -122.412209406439 | (37.7962784001887, -122.412209406439) | 3 | 1 | 10 | 308 | 21 | ||||
| 40158 | 253917 | Significant Tree 6 | Eriobotrya japonica :: Edible Loquat 119 | 1819 Mason St | 1 | Front Yard : Yard | Tree | Private 2 | 6009087 | 2119549 | 37.8003900283184 | -122.412685532944 | (37.8003900283184, -122.412685532944) | 3 | 1 | 10 | 308 | 32 | |||||
| 89041 | 224124 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1244 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008668.58024 | 2101297.73586 | 37.7502528748804 | -122.412842355611 | (37.7502528748804, -122.412842355611) | 2 | 4 | 7 | 28859 | 19 | |||
| 19239 | 224123 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 601X Powhattan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008526.38321 | 2098121.40646 | 37.7415233967761 | -122.413109512687 | (37.7415233967761, -122.413109512687) | 10 | 7 | 7 | 28859 | 2 | ||||
| 11577 | 224121 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 499X Ogden Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008290.10508 | 2096093.22608 | 37.7359411906366 | -122.413783055452 | (37.7359411906366, -122.413783055452) | 2 | 7 | 7 | 28859 | 2 | |||
| 9830 | 224122 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 499X Ogden Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008272.03754 | 2096094.48518 | 37.7359436331948 | -122.413845611379 | (37.7359436331948, -122.413845611379) | 2 | 7 | 7 | 28859 | 2 | |||
| 93520 | 126572 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1001 Vallejo St | 5 | Front Yard : Yard | Tree | Private 2 | 6 | 6008680.36365 | 2118649.32289 | 37.7978969073709 | -122.414028979559 | (37.7978969073709, -122.414028979559) | 5 | 1 | 10 | 308 | 21 | ||||
| 118921 | 126571 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1013 Vallejo St | 2 | Front Yard : Yard | Tree | Private 2 | 13 | 6008640.83285 | 2118637.52711 | 37.7978622987641 | -122.414164932777 | (37.7978622987641, -122.414164932777) | 5 | 1 | 10 | 308 | 21 | ||||
| 90526 | 7445 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2548 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6008209.4393 | 2103591.66563 | 37.7565257046152 | -122.414592409312 | (37.7565257046152, -122.414592409312) | 2 | 4 | 7 | 28859 | 19 | |||
| 63491 | 65002 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1628 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1989 12:00:00 AM | 7 | Permit Number 26041 | 6007789.57951 | 2087924.39296 | 37.7134831981768 | -122.414935588817 | (37.7134831981768, -122.414935588817) | 9 | 7 | 8 | 309 | 39 | ||
| 162017 | 224125 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1745 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008033.82801 | 2108179.59599 | 37.7691132329216 | -122.415524547646 | (37.7691132329216, -122.415524547646) | 8 | 4 | 7 | 28853 | 19 | |||
| 33980 | 126570 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 94 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008053.53116 | 2119101.30283 | 37.7991027057905 | -122.416230031603 | (37.7991027057905, -122.416230031603) | 5 | 1 | 10 | 308 | 32 | ||||
| 53757 | 176288 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 51 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007278.51632 | 2093753.93468 | 37.7294611462914 | -122.417114824212 | (37.7294611462914, -122.417114824212) | 9 | 3 | 7 | 309 | 28 | |||
| 8190 | 261370 | Planning Code 138.1 required 2 | Eriobotrya japonica :: Edible Loquat 119 | 102 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007140 | 2095356 | 37.7338522748733 | -122.417707198486 | (37.7338522748733, -122.417707198486) | 2 | 7 | 7 | 28859 | 2 | ||||
| 113035 | 176287 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1565 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6006970.59339 | 2091697.77071 | 37.723798037137 | -122.418033639041 | (37.723798037137, -122.418033639041) | 9 | 7 | 7 | 309 | 28 | |||
| 124641 | 248210 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 69 Fair Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6007064.668 | 2099422.3589 | 37.7450133544796 | -122.418255851634 | (37.7450133544796, -122.418255851634) | 2 | 7 | 7 | 28859 | 2 | |||
| 83388 | 224126 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3213 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006857.14128 | 2103777.70396 | 37.7569604557817 | -122.419282344129 | (37.7569604557817, -122.419282344129) | 2 | 4 | 7 | 28859 | 19 | |||
| 22081 | 111169 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1469 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007081.20428 | 2117722.03099 | 37.7952608496747 | -122.419496712817 | (37.7952608496747, -122.419496712817) | 5 | 1 | 10 | 28858 | 32 | |||
| 119596 | 126566 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1519 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006877.84584 | 2117681.84008 | 37.7951390391788 | -122.420197513099 | (37.7951390391788, -122.420197513099) | 13 | 9 | 10 | 28858 | 32 | |||
| 30972 | 126565 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1519 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006864.87455 | 2117678.32819 | 37.795128665521 | -122.420242146478 | (37.795128665521, -122.420242146478) | 13 | 9 | 10 | 28858 | 32 | |||
| 123058 | 126564 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1519 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006833.89403 | 2117675.37487 | 37.7951188107324 | -122.420349134325 | (37.7951188107324, -122.420349134325) | 13 | 9 | 10 | 28858 | 32 | |||
| 9793 | 126563 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1519 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006819.81222 | 2117673.20836 | 37.7951120685147 | -122.420397705787 | (37.7951120685147, -122.420397705787) | 13 | 9 | 10 | 28858 | 32 | |||
| 56150 | 224116 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 400 Prospect Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6006205.79839 | 2097605.42741 | 37.7399760871276 | -122.421096686769 | (37.7399760871276, -122.421096686769) | 2 | 7 | 7 | 28859 | 2 | ||||
| 75825 | 126568 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2745 Larkin St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6006520.94056 | 2120654.06544 | 37.8032799020007 | -122.421643667929 | (37.8032799020007, -122.421643667929) | 5 | 9 | 1 | 28858 | 32 |
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) );