trees
170 rows where qSpecies_id = 232 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28025 | 177039 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 178 Seville St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6001177.23506 | 2087434.66895 | 37.711764745717 | -122.437755094333 | (37.711764745717, -122.437755094333) | 9 | 7 | 6 | 28861 | 5 | |||
175292 | 177030 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 235 Ottawa Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5998356.41955 | 2089266.50528 | 37.7166337499183 | -122.447636347658 | (37.7166337499183, -122.447636347658) | 9 | 7 | 6 | 28861 | 25 | |||
152109 | 177029 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 123 Seneca Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6000050.76247 | 2090072.63848 | 37.7189438978236 | -122.441837691751 | (37.7189438978236, -122.441837691751) | 9 | 7 | 6 | 28861 | 25 | |||
123906 | 177032 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 663 University St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008682.45825 | 2090982.77812 | 37.7219310184866 | -122.412065479859 | (37.7219310184866, -122.412065479859) | 9 | 3 | 7 | 309 | 28 | |||
157377 | 177033 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 681 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6008991.36209 | 2090994.19316 | 37.7219796888926 | -122.410998479192 | (37.7219796888926, -122.410998479192) | 9 | 3 | 7 | 309 | 28 | |||
67684 | 177034 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 675 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 6008984.35993 | 2091023.84247 | 37.7220607070166 | -122.411024777165 | (37.7220607070166, -122.411024777165) | 9 | 3 | 7 | 309 | 28 | |||
162698 | 177038 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 649 Hamilton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009808.87936 | 2091375.19794 | 37.7230716583033 | -122.408199372618 | (37.7230716583033, -122.408199372618) | 10 | 3 | 7 | 309 | 28 | |||
70889 | 191429 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2399 Lane St | 7 | Side Yard : Yard | Tree | Private 2 | 4 | 6013991.75526 | 2092879.90646 | 37.7274366158882 | -122.393845172923 | (37.7274366158882, -122.393845172923) | 10 | 3 | 8 | 58 | 1 | ||||
48322 | 177031 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 263 Maynard St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 2ft | 6005122.72167 | 2093818.53424 | 37.7295170103902 | -122.424572215729 | (37.7295170103902, -122.424572215729) | 9 | 7 | 6 | 28861 | 5 | |||
27116 | 177037 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 125 Goettingen St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 2ft | 6009971.552 | 2093934.84647 | 37.7301090233129 | -122.407817447612 | (37.7301090233129, -122.407817447612) | 10 | 3 | 7 | 309 | 28 | |||
149824 | 40706 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 758 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 6 | Permit Number 41685 | 6006892.85232 | 2094109.94712 | 37.7304169754587 | -122.41847333919 | (37.7304169754587, -122.41847333919) | 9 | 3 | 7 | 309 | 28 | |
158818 | 66159 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 90 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | 6 | Permit Number 29230 | 6013889.68751 | 2094856.83218 | 37.732859178908 | -122.394336381736 | (37.732859178908, -122.394336381736) | 10 | 3 | 8 | 58 | 1 | |
31336 | 177035 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 15 Merrill St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 2ft | 6009505.01631 | 2094936.0613 | 37.7328320166696 | -122.409500962316 | (37.7328320166696, -122.409500962316) | 10 | 3 | 7 | 309 | 28 | |||
72877 | 177036 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 15 Merrill St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 2ft | 6009502.62349 | 2094943.72581 | 37.7328529276995 | -122.409509775682 | (37.7328529276995, -122.409509775682) | 10 | 3 | 7 | 309 | 28 | |||
115948 | 191430 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 12 Augusta St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6011384.73848 | 2095507.87401 | 37.7345072405216 | -122.403042454946 | (37.7345072405216, -122.403042454946) | 10 | 3 | 8 | 58 | 1 | |||
24261 | 218286 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1 Woodacre Dr | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5991335.90639 | 2095594.80509 | 37.7336059570417 | -122.472363586812 | (37.7336059570417, -122.472363586812) | 1 | 8 | 4 | 64 | 40 | ||||
69895 | 226640 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 10 Crescent Ave | 2 | Side Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6005282.96903 | 2095902.79944 | 37.7352489878562 | -122.424166394858 | (37.7352489878562, -122.424166394858) | 2 | 7 | 7 | 28859 | 2 | |||
91613 | 191428 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 22 Robblee Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6012599.81478 | 2095974.63355 | 37.7358566435644 | -122.39887425376 | (37.7358566435644, -122.39887425376) | 10 | 3 | 8 | 58 | 1 | |||
96764 | 226656 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 121 Moffitt St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 2ft | 6002727.92534 | 2096681.4535 | 37.7372423972127 | -122.433055722954 | (37.7372423972127, -122.433055722954) | 2 | 7 | 5 | 63 | 7 | |||
168271 | 226657 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 117 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003659.76941 | 2097669.44697 | 37.74000801486 | -122.42990436449 | (37.74000801486, -122.42990436449) | 2 | 7 | 5 | 63 | 7 | |||
158349 | 226658 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 117 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003646.08487 | 2097679.68219 | 37.7400353434466 | -122.429952409889 | (37.7400353434466, -122.429952409889) | 2 | 7 | 5 | 63 | 7 | |||
30551 | 5710 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1609 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6005330.55919 | 2098925.54374 | 37.7435514489374 | -122.4242167677 | (37.7435514489374, -122.4242167677) | 2 | 7 | 5 | 28859 | 22 | |||
160443 | 226649 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 410 Valley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003222.12075 | 2099233.47316 | 37.7442776748811 | -122.431529200211 | (37.7442776748811, -122.431529200211) | 2 | 7 | 5 | 63 | 22 | |||
2479 | 226638 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 201 Coso Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6007716.3532 | 2099510.69761 | 37.7452925742068 | -122.416008689563 | (37.7452925742068, -122.416008689563) | 2 | 7 | 7 | 28859 | 2 | |||
175114 | 226639 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 145 Coso Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6007521.18601 | 2099614.94215 | 37.7455678314934 | -122.416690930545 | (37.7455678314934, -122.416690930545) | 2 | 7 | 7 | 28859 | 2 | ||||
161471 | 226648 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1488 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005200.77027 | 2099715.54685 | 37.7457132878504 | -122.424721734337 | (37.7457132878504, -122.424721734337) | 2 | 7 | 5 | 63 | 22 | |||
58621 | 10231 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1440 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 2x2 | 6005821.60814 | 2100602.13393 | 37.7481826984823 | -122.422637956596 | (37.7481826984823, -122.422637956596) | 2 | 4 | 5 | 28859 | 19 | |||
42346 | 226637 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1199 Capp St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 6007225.31017 | 2100622.72822 | 37.7483183396245 | -122.417785447755 | (37.7483183396245, -122.417785447755) | 2 | 4 | 7 | 28859 | 19 | |||
166841 | 226645 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 3626 24th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 1ft | 6005580.70423 | 2101999.04422 | 37.7520046984762 | -122.423570296333 | (37.7520046984762, -122.423570296333) | 2 | 4 | 5 | 28859 | 19 | |||
15496 | 58940 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1360 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1980 12:00:00 AM | 2 | Permit Number 18218 | 6011963.90217 | 2102042.40825 | 37.7524820001659 | -122.401499182338 | (37.7524820001659, -122.401499182338) | 10 | 3 | 8 | 28856 | 29 | |
16162 | 226641 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 953 Treat Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6008623.39527 | 2103036.69536 | 37.7550251300303 | -122.413121556411 | (37.7550251300303, -122.413121556411) | 2 | 4 | 7 | 28859 | 19 | |||
19002 | 207370 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 501x Ortega St | 4 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5992545.91088 | 2103073.93484 | 37.754211699531 | -122.468724320995 | (37.754211699531, -122.468724320995) | 1 | 8 | 4 | 56 | 12 | |||
31116 | 207369 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 501x Ortega St | 6 | Median : Cutout | Tree | DPW 1 | 1 | Width 2ft | 5992541.8863 | 2103083.68699 | 37.7542382439023 | -122.468738948444 | (37.7542382439023, -122.468738948444) | 1 | 8 | 4 | 56 | 12 | |||
99522 | 35353 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1023 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2013 12:00:00 AM | 1 | Permit Number 770231 | 6011656.23225 | 2103580.24733 | 37.7566873964196 | -122.40267130025 | (37.7566873964196, -122.40267130025) | 10 | 3 | 8 | 28856 | 29 | |
91779 | 191426 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1700 22nd St | 5 | Front Yard : Yard | Tree | Private 2 | 6 | 6012934.52583 | 2103813.36642 | 37.7573987772601 | -122.39826682196 | (37.7573987772601, -122.39826682196) | 10 | 3 | 8 | 28856 | 29 | ||||
180341 | 191425 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 798 Wisconsin St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6012697.8338 | 2103815.11788 | 37.7573903991588 | -122.399085525191 | (37.7573903991588, -122.399085525191) | 10 | 3 | 8 | 28856 | 29 | |||
89364 | 207365 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1678 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990916.62821 | 2103981.8612 | 37.7566103677027 | -122.474424980426 | (37.7566103677027, -122.474424980426) | 1 | 8 | 4 | 56 | 12 | |||
138958 | 191424 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 743 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012751.86136 | 2104046.56843 | 37.7580289223265 | -122.398914919298 | (37.7580289223265, -122.398914919298) | 10 | 3 | 8 | 28856 | 29 | |||
116946 | 59609 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1063 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 5 | Permit Number 19011 | 6015560.85054 | 2104166.3389 | 37.7585139078159 | -122.389208516653 | (37.7585139078159, -122.389208516653) | 10 | 3 | 8 | 28856 | 29 | ||
69781 | 191423 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 872 Rhode Island St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6011836.25776 | 2104328.91927 | 37.7587531337637 | -122.402101335126 | (37.7587531337637, -122.402101335126) | 10 | 3 | 8 | 28856 | 29 | |||
36948 | 226644 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 48 Cumberland St | 3 | : | Tree | Private 2 | 2 | Width 2ft | 6005321.77679 | 2104616.40188 | 37.7591767333496 | -122.424651877677 | (37.7591767333496, -122.424651877677) | 2 | 4 | 5 | 28859 | 19 | |||
46651 | 226643 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 48 Cumberland St | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6005334.03507 | 2104616.89651 | 37.7591787837883 | -122.424609517811 | (37.7591787837883, -122.424609517811) | 2 | 4 | 5 | 28859 | 19 | |||
133526 | 226642 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 14 Cumberland St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6005484.04077 | 2104618.29186 | 37.759191085608 | -122.424090824831 | (37.759191085608, -122.424090824831) | 2 | 4 | 5 | 28859 | 19 | |||
75793 | 191420 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 785 Rhode Island St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6011880.44844 | 2104704.93056 | 37.759788043893 | -122.401974935396 | (37.759788043893, -122.401974935396) | 10 | 3 | 8 | 28856 | 29 | |||
76243 | 191421 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 785 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6011879.91992 | 2104709.23521 | 37.7597998340098 | -122.40197706591 | (37.7597998340098, -122.40197706591) | 10 | 3 | 8 | 28856 | 29 | |||
59330 | 191427 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1627 20th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6013091.09687 | 2104712.62895 | 37.7598766756903 | -122.397788409621 | (37.7598766756903, -122.397788409621) | 10 | 3 | 8 | 28856 | 29 | |||
157434 | 207367 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 2 Lurline St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992094.14756 | 2104940.13578 | 37.7593096900047 | -122.470422518894 | (37.7593096900047, -122.470422518894) | 1 | 8 | 4 | 56 | 12 | |||
129923 | 10088 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 680 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X2 | 6005576.87933 | 2105026.12376 | 37.760316137501 | -122.423798743025 | (37.760316137501, -122.423798743025) | 2 | 4 | 5 | 28859 | 19 | |||
62250 | 207368 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5992009.48044 | 2105269.9271 | 37.760210314285 | -122.47073935813 | (37.760210314285, -122.47073935813) | 1 | 8 | 4 | 56 | 12 | |||
118240 | 226652 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 225 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999964.01354 | 2105579.20426 | 37.7615163052595 | -122.443250685888 | (37.7615163052595, -122.443250685888) | 15 | 5 | 5 | 28862 | 3 | |||
186456 | 226655 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 232 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999888.11878 | 2105582.87148 | 37.7615220465382 | -122.443513437219 | (37.7615220465382, -122.443513437219) | 15 | 5 | 5 | 28862 | 3 | |||
129994 | 226654 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 220 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999922.0088 | 2105601.51229 | 37.7615751622837 | -122.443397564951 | (37.7615751622837, -122.443397564951) | 15 | 5 | 5 | 28862 | 3 | |||
43340 | 226653 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 214 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999974.10738 | 2105629.30684 | 37.7616544501161 | -122.443219374174 | (37.7616544501161, -122.443219374174) | 15 | 5 | 5 | 28862 | 3 | |||
55056 | 191419 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 574 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011201.13816 | 2105680.19927 | 37.7624279767963 | -122.404392995652 | (37.7624279767963, -122.404392995652) | 8 | 3 | 8 | 28856 | 29 | |||
31041 | 191422 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 518 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 1ft | 6011739.54492 | 2105950.98951 | 37.7632015790138 | -122.402549877375 | (37.7632015790138, -122.402549877375) | 8 | 3 | 8 | 28856 | 29 | |||
67356 | 226651 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1210 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997784.11523 | 2106211.61184 | 37.7631281925414 | -122.450835621062 | (37.7631281925414, -122.450835621062) | 15 | 5 | 11 | 29492 | 9 | |||
185616 | 226650 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1210 Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997776.79189 | 2106261.76861 | 37.7632654911199 | -122.450864566663 | (37.7632654911199, -122.450864566663) | 15 | 5 | 11 | 29492 | 9 | |||
153258 | 207366 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5990777.74909 | 2106795.52344 | 37.7643278872345 | -122.475110663153 | (37.7643278872345, -122.475110663153) | 11 | 8 | 3 | 56 | 12 | |||
32361 | 112544 | Undocumented 4 | Ligustrum japonicum :: Japanese Privet 232 | 31 HIDALGO TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 3x3 | 6004997 | 2107458 | 37.7669607387675 | -122.425977392818 | (37.7669607387675, -122.425977392818) | 8 | 4 | 5 | 28853 | 19 | |||
95968 | 112545 | Undocumented 4 | Ligustrum japonicum :: Japanese Privet 232 | 31 HIDALGO TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6004997 | 2107458 | 37.7669607387675 | -122.425977392818 | (37.7669607387675, -122.425977392818) | 8 | 4 | 5 | 28853 | 19 | |||
180944 | 226647 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 31 Hidalgo Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6004982.44987 | 2107476.14572 | 37.767009740246 | -122.426029011331 | (37.767009740246, -122.426029011331) | 8 | 4 | 5 | 28853 | 19 | |||
86080 | 226646 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 31 Hidalgo Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004999.4002 | 2107477.29528 | 37.767013854632 | -122.425970464583 | (37.767013854632, -122.425970464583) | 8 | 4 | 5 | 28853 | 19 | |||
25064 | 9989 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 28 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X2 | 6005374.86669 | 2108638.02007 | 37.7702221392707 | -122.424754366229 | (37.7702221392707, -122.424754366229) | 8 | 2 | 5 | 28853 | 19 | |||
27680 | 9990 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 33 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005438.43144 | 2108674.6093 | 37.7703261944175 | -122.424537099004 | (37.7703261944175, -122.424537099004) | 8 | 2 | 5 | 28853 | 19 | |||
177220 | 9988 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 25 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005434.58987 | 2108720.51419 | 37.7704520212643 | -122.424553652838 | (37.7704520212643, -122.424553652838) | 8 | 2 | 5 | 28853 | 19 | |||
77216 | 15295 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 1625 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/02/1995 12:00:00 AM | 3 | 3X3 | 6006990.72739 | 2109176.21889 | 37.7717910362903 | -122.41920328508 | (37.7717910362903, -122.41920328508) | 8 | 2 | 9 | 28853 | 19 | ||
29993 | 117871 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 850 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5983579.82834 | 2110008.29889 | 37.7727294500776 | -122.500243389783 | (37.7727294500776, -122.500243389783) | 11 | 6 | 2 | 55 | 26 | |||
53689 | 123375 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 757 03rd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5995016.33653 | 2110447.72713 | 37.7746006270727 | -122.460715372994 | (37.7746006270727, -122.460715372994) | 11 | 6 | 2 | 54 | 11 | ||||
84296 | 119029 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 767 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5982273.77271 | 2110527.62617 | 37.7740786267097 | -122.504799591882 | (37.7740786267097, -122.504799591882) | 11 | 6 | 2 | 55 | 26 | |||
178205 | 119030 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 767 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 5982272.9223 | 2110539.10892 | 37.7741101049647 | -122.504803384573 | (37.7741101049647, -122.504803384573) | 11 | 6 | 2 | 55 | 26 | |||
5240 | 96951 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 798X 24th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5988521.53055 | 2110635.12143 | 37.7747393420729 | -122.483195657296 | (37.7747393420729, -122.483195657296) | 11 | 6 | 2 | 55 | 26 | |||
185254 | 191431 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 9 Sumner St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6009550.82105 | 2110763.25421 | 37.7762925082147 | -122.410459796982 | (37.7762925082147, -122.410459796982) | 8 | 2 | 9 | 28853 | 34 | |||
4624 | 75146 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010085.43601 | 2111100.02376 | 37.7772471547732 | -122.408634170555 | (37.7772471547732, -122.408634170555) | 8 | 2 | 9 | 28853 | 34 | |||
13461 | 75228 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010065.6483 | 2111120.54922 | 37.7773024046157 | -122.408704071262 | (37.7773024046157, -122.408704071262) | 8 | 2 | 9 | 28853 | 34 | |||
12598 | 75304 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6010043.76488 | 2111144.47071 | 37.7773668617363 | -122.408781461497 | (37.7773668617363, -122.408781461497) | 8 | 2 | 9 | 28853 | 34 | |||
14988 | 75390 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 240 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010035.62368 | 2111155.67227 | 37.7773971625953 | -122.408810415165 | (37.7773971625953, -122.408810415165) | 8 | 2 | 9 | 28853 | 34 | |||
54655 | 119044 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 591 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5982228.00989 | 2111743.54314 | 37.7774144867655 | -122.505048017404 | (37.7774144867655, -122.505048017404) | 11 | 6 | 2 | 55 | 26 | |||
27451 | 121987 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 524 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991287.8185 | 2111802.50892 | 37.7781052628966 | -122.473711776328 | (37.7781052628966, -122.473711776328) | 11 | 6 | 2 | 54 | 26 | |||
161130 | 123060 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 500 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5991917.4637 | 2111957.21563 | 37.7785664917216 | -122.471544903306 | (37.7785664917216, -122.471544903306) | 11 | 6 | 2 | 54 | 11 | |||
37352 | 123059 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 500 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5991916.7341 | 2111968.89129 | 37.7785985076866 | -122.471548278269 | (37.7785985076866, -122.471548278269) | 11 | 6 | 2 | 54 | 11 | |||
52159 | 123058 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 500 Funston Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5991916.77661 | 2111982.49396 | 37.7786358593632 | -122.471549122693 | (37.7786358593632, -122.471549122693) | 11 | 6 | 2 | 54 | 11 | |||
181221 | 45642 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 557 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2001 12:00:00 AM | 3 | Permit Number 44345 | 5987489.41692 | 2112170.49335 | 37.7788949237134 | -122.486878678096 | (37.7788949237134, -122.486878678096) | 11 | 6 | 2 | 55 | 26 | ||
49494 | 40933 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 516 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1999 12:00:00 AM | 3 | Permit Number 41796 | 5987525.4413 | 2112407.46828 | 37.7795476900895 | -122.486771463248 | (37.7795476900895, -122.486771463248) | 11 | 6 | 2 | 55 | 26 | ||
135809 | 118574 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 7900 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5982449.98783 | 2112431.50605 | 37.779316488746 | -122.504331113282 | (37.779316488746, -122.504331113282) | 11 | 6 | 2 | 55 | 26 | |||
118987 | 117693 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 435 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5982808.8484 | 2112817.53757 | 37.7803975176735 | -122.503118273577 | (37.7803975176735, -122.503118273577) | 11 | 6 | 2 | 55 | 26 | |||
141533 | 117692 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 435 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5982808.33309 | 2112832.48805 | 37.7804385370123 | -122.503121163441 | (37.7804385370123, -122.503121163441) | 11 | 6 | 2 | 55 | 26 | |||
5482 | 72076 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 229 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5989910.70009 | 2113826.30511 | 37.7835821901674 | -122.478623713066 | (37.7835821901674, -122.478623713066) | 11 | 6 | 2 | 55 | 26 | |||
145552 | 129513 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 25 Heather Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5997331.52493 | 2114270.89109 | 37.7852309644831 | -122.45298274797 | (37.7852309644831, -122.45298274797) | 15 | 6 | 1 | 54 | 31 | |||
179264 | 120189 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 224 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5987764.62451 | 2114428.11322 | 37.785109748739 | -122.486092406972 | (37.785109748739, -122.486092406972) | 11 | 6 | 2 | 55 | 26 | |||
108113 | 120188 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 224 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5987762.71943 | 2114453.05727 | 37.7851781269564 | -122.486100829584 | (37.7851781269564, -122.486100829584) | 11 | 6 | 2 | 55 | 26 | |||
75259 | 121971 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 106 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5991185.18904 | 2114684.00966 | 37.7860111230721 | -122.474277122949 | (37.7860111230721, -122.474277122949) | 11 | 6 | 2 | 54 | 26 | |||
124347 | 55616 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 407 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/1973 12:00:00 AM | 7 | Permit Number 11594 | 5998117.03892 | 2115073.62503 | 37.7874800448276 | -122.450323009314 | (37.7874800448276, -122.450323009314) | 11 | 6 | 1 | 54 | 31 | ||
153511 | 129556 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 216 Post St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6011025.30596 | 2115257.2463 | 37.7887145046082 | -122.405675728365 | (37.7887145046082, -122.405675728365) | 5 | 1 | 10 | 28857 | 6 | |||
138546 | 129555 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 216 Post St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6011031.64459 | 2115258.30549 | 37.7887177673445 | -122.405653872146 | (37.7887177673445, -122.405653872146) | 5 | 1 | 10 | 28857 | 6 | |||
32840 | 102822 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 347 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 20638 | 5999052.21165 | 2115387.87521 | 37.7883963685539 | -122.447110138134 | (37.7883963685539, -122.447110138134) | 13 | 6 | 1 | 54 | 31 | ||
20209 | 60858 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 347 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/1983 12:00:00 AM | 5 | 3x3 | Permit Number 20638 | 5999049.79752 | 2115408.40483 | 37.7884525995602 | -122.447119968637 | (37.7884525995602, -122.447119968637) | 13 | 6 | 1 | 54 | 31 | |
193637 | 57852 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1977 12:00:00 AM | 10 | Permit Number 16793 | 6012080.13289 | 2115527.66509 | 37.7895159399674 | -122.402045176939 | (37.7895159399674, -122.402045176939) | 4 | 1 | 10 | 28854 | 6 | ||
83143 | 129549 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6012078.1031 | 2115538.76346 | 37.7895463001798 | -122.402052980384 | (37.7895463001798, -122.402052980384) | 4 | 1 | 10 | 28854 | 6 | |||
140132 | 129550 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6012076.26306 | 2115552.15036 | 37.7895829547447 | -122.40206028827 | (37.7895829547447, -122.40206028827) | 4 | 1 | 10 | 28854 | 6 | |||
40212 | 129551 | DPW Maintained 1 | Ligustrum japonicum :: Japanese Privet 232 | 44 Montgomery St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 4ft | 6012074.07881 | 2115564.48535 | 37.789616701801 | -122.40206871312 | (37.789616701801, -122.40206871312) | 4 | 1 | 10 | 28854 | 6 |
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) );