Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
179770 | 179770 | 71586 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | ||
167538 | 167538 | 179336 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 225 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6002643.14283 | 2086748.99011 | 37.709965266168105 | -122.43263957156 | (37.7099652661681, -122.43263957156) | |||
162050 | 162050 | 179330 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001459.59412 | 2086865.7197599998 | 37.71021858809021 | -122.43673848451999 | (37.7102185880902, -122.43673848452) | |||
161987 | 161987 | 179331 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001453.95042 | 2086881.4918 | 37.7102615738952 | -122.43675911853501 | (37.7102615738952, -122.436759118535) | |||
172017 | 172017 | 179332 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001443.39306 | 2086909.8506099998 | 37.7103388409345 | -122.43679763560301 | (37.7103388409345, -122.436797635603) | |||
180272 | 180272 | 179333 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001438.26403 | 2086921.6489 | 37.710370944937104 | -122.436816206603 | (37.7103709449371, -122.436816206603) | |||
3987 | 3987 | 159341 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.297780001 | 2087238.08175 | 37.7110558677139 | -122.44799199802799 | (37.7110558677139, -122.447991998028) | ||
4111 | 4111 | 159295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 118 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:16:00 PM | 3 | Width 0ft | 5998136.03876 | 2087321.1199900003 | 37.7112795695727 | -122.448258085851 | (37.7112795695727, -122.448258085851) | ||
4050 | 4050 | 159297 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:53:00 PM | 3 | Width 0ft | 5998096.339240001 | 2087362.0634299999 | 37.711389721237104 | -122.448398243388 | (37.7113897212371, -122.448398243388) | ||
4003 | 4003 | 159298 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 122 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:11:00 PM | 3 | Width 0ft | 5998090.67137 | 2087368.5047400002 | 37.711407083550704 | -122.448418296488 | (37.7114070835507, -122.448418296488) | ||
65822 | 65822 | 74096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 10 | 6001902.78384 | 2087667.7277099998 | 37.712445903022704 | -122.435264062185 | (37.7124459030227, -122.435264062185) | ||
165666 | 165666 | 179334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6001947.96661 | 2087712.00011 | 37.7125700310481 | -122.43511106143801 | (37.7125700310481, -122.435111061438) | |||
171035 | 171035 | 179335 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1119 Athens St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6001959.57443 | 2087726.76645 | 37.7126112352992 | -122.435071996701 | (37.7126112352992, -122.435071996701) | |||
3425 | 3425 | 159220 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.71247119106079 | -122.446492798529 | (37.7124711910608, -122.446492798529) | |||
3492 | 3492 | 159213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998902.8056 | 2087977.93006 | 37.7131268274265 | -122.445655159179 | (37.7131268274265, -122.445655159179) | |||
59671 | 59671 | 213985 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 431 Capitol Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995022.34889 | 2088455.31671 | 37.714215306566 | -122.45910178282301 | (37.714215306566, -122.459101782823) | |||
135664 | 135664 | 213984 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994978.50476 | 2088691.4656200001 | 37.7148611951759 | -122.459270414704 | (37.7148611951759, -122.459270414704) | |||
66294 | 66294 | 213983 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994955.32932 | 2088691.9508900002 | 37.7148611951615 | -122.45935055329201 | (37.7148611951615, -122.459350553292) | |||
150336 | 150336 | 213982 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Lobos St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994935.45629 | 2088691.9546700001 | 37.714860062915 | -122.459419242599 | (37.714860062915, -122.459419242599) | |||
174826 | 174826 | 213987 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5996535.27353 | 2089022.9105 | 37.7158606459376 | -122.45391352290599 | (37.7158606459376, -122.453913522906) | |||
149382 | 149382 | 213986 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5996577.00096 | 2089023.1695 | 37.7158637494767 | -122.45376931301399 | (37.7158637494767, -122.453769313014) | |||
62359 | 62359 | 197142 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012879.123819999 | 2089210.84364 | 37.717300215014205 | -122.39743436542601 | (37.7173002150142, -122.397434365426) | |||
165811 | 165811 | 197143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012876.3937800005 | 2089220.9678099998 | 37.717327861958296 | -122.397444511578 | (37.7173278619583, -122.397444511578) | |||
39419 | 39419 | 197144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012875.71849 | 2089235.92195 | 37.717368885441395 | -122.397447893917 | (37.7173688854414, -122.397447893917) | |||
70939 | 70939 | 200236 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 921 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014551.0541 | 2089524.7802 | 37.718255172199896 | -122.39167717639299 | (37.7182551721999, -122.391677176393) | |||
135080 | 135080 | 69741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6010157.175969999 | 2089735.57492 | 37.7185890892048 | -122.40687987112601 | (37.7185890892048, -122.406879871126) | ||
118181 | 118181 | 179285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010162.36149 | 2089750.0772799999 | 37.7186291998585 | -122.40686296837099 | (37.7186291998585, -122.406862968371) | |||
62088 | 62088 | 213946 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996526.79114 | 2090102.3106200001 | 37.718823939946795 | -122.454020752656 | (37.7188239399468, -122.454020752656) | |||
69823 | 69823 | 213978 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 250 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994758.88079 | 2090253.13715 | 37.7191365451831 | -122.460142594324 | (37.7191365451831, -122.460142594324) | |||
188252 | 188252 | 213979 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 254 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994759.40129 | 2090277.98422 | 37.719204799252296 | -122.46014259431999 | (37.7192047992523, -122.46014259432) | |||
42220 | 42220 | 213980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 258 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994759.30681 | 2090307.0454 | 37.7192845888893 | -122.460145025196 | (37.7192845888893, -122.460145025196) | |||
22361 | 22361 | 213977 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994717.86147 | 2090376.1855099997 | 37.719472047173205 | -122.460293291905 | (37.7194720471732, -122.460293291905) | |||
25291 | 25291 | 179283 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 126 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004517.28509 | 2090394.86473 | 37.7200821580385 | -122.426421596896 | (37.7200821580385, -122.426421596896) | |||
186437 | 186437 | 71320 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6004289.26563 | 2090538.0021799998 | 37.720462289783896 | -122.42721997362601 | (37.7204622897839, -122.427219973626) | ||
50254 | 50254 | 213950 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995061.44128 | 2090626.04133 | 37.720177849497794 | -122.459123753274 | (37.7201778494978, -122.459123753274) | |||
164333 | 164333 | 213951 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 319 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994724.0479999995 | 2090709.9007700002 | 37.7203887054465 | -122.460296073498 | (37.7203887054465, -122.460296073498) | |||
44502 | 44502 | 202037 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012270.3118199995 | 2090901.9422 | 37.7219097135375 | -122.399657426574 | (37.7219097135375, -122.399657426574) | |||
148185 | 148185 | 202038 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Crane St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012275.87253 | 2090920.17769 | 37.7219600944649 | -122.39963948420099 | (37.7219600944649, -122.399639484201) | |||
160941 | 160941 | 213952 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994769.73406 | 2090948.84155 | 37.72104740759529 | -122.460155454611 | (37.7210474075953, -122.460155454611) | |||
124104 | 124104 | 213976 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995023.46765 | 2090970.5982400002 | 37.7211217374705 | -122.459279952923 | (37.7211217374705, -122.459279952923) | |||
151351 | 151351 | 213953 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994770.431919999 | 2090973.1015700002 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | |||
59382 | 59382 | 213975 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995024.51997 | 2091003.2487299999 | 37.7212114484221 | -122.45927867859501 | (37.7212114484221, -122.459278678595) | |||
177196 | 177196 | 213954 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994772.0848 | 2091005.96515 | 37.721204390545104 | -122.460151465241 | (37.7212043905451, -122.460151465241) | |||
33788 | 33788 | 213974 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995026.3935 | 2091022.299 | 37.7212638636298 | -122.459273581222 | (37.7212638636298, -122.459273581222) | |||
174480 | 174480 | 213955 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | |||
36604 | 36604 | 213973 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995027.24606 | 2091045.4090900002 | 37.721327367434604 | -122.459272306869 | (37.7213273674346, -122.459272306869) | |||
44482 | 44482 | 213956 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994772.08022 | 2091060.8394799998 | 37.7213550620588 | -122.46015545460699 | (37.7213550620588, -122.460155454607) | |||
177551 | 177551 | 213972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995029.65711 | 2091072.52436 | 37.721401958108295 | -122.459265935174 | (37.7214019581083, -122.459265935174) | |||
159725 | 159725 | 213957 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994771.7805 | 2091087.8520099998 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | |||
29544 | 29544 | 213971 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.07265 | 2091112.6142099998 | 37.7215118291791 | -122.459281227253 | (37.7215118291791, -122.459281227253) | |||
66368 | 66368 | 213958 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5994774.32905 | 2091126.87145 | 37.721536499390105 | -122.460152462564 | (37.7215364993901, -122.460152462564) | |||
71421 | 71421 | 213970 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507607996 | -122.45927995292699 | (37.721597507608, -122.459279952927) | |||
186622 | 186622 | 213959 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994775.57323 | 2091144.94508 | 37.721586196813995 | -122.460149470543 | (37.721586196814, -122.460149470543) | |||
28648 | 28648 | 213960 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994774.81066 | 2091163.6355700002 | 37.7216374725616 | -122.460153459937 | (37.7216374725616, -122.460153459937) | |||
69936 | 69936 | 213969 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995027.18674 | 2091165.82123 | 37.7216579869959 | -122.459281227274 | (37.7216579869959, -122.459281227274) | |||
172877 | 172877 | 213968 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.496169999 | 2091185.65951 | 37.7217124184688 | -122.459285050266 | (37.7217124184688, -122.459285050266) | |||
152237 | 152237 | 213961 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994775.27388 | 2091185.74798 | 37.7216982145873 | -122.460153459921 | (37.7216982145873, -122.460153459921) | |||
152806 | 152806 | 213966 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994898.75092 | 2091213.04066 | 37.72178025523171 | -122.459728611213 | (37.7217802552317, -122.459728611213) | |||
44594 | 44594 | 213965 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5994879.14088 | 2091213.45138 | 37.721780255249904 | -122.459796427288 | (37.7217802552499, -122.459796427288) | |||
76365 | 76365 | 213967 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994931.65056 | 2091213.50095 | 37.72178341096 | -122.45961491981701 | (37.72178341096, -122.459614919817) | |||
154173 | 154173 | 213963 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994830.12755 | 2091215.05246 | 37.7217818326369 | -122.45996596837 | (37.7217818326369, -122.45996596837) | |||
54162 | 54162 | 213964 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994850.90322 | 2091215.19212 | 37.7217834109648 | -122.459894162891 | (37.7217834109648, -122.459894162891) | |||
184348 | 184348 | 213962 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994792.34345 | 2091215.55668 | 37.7217810439445 | -122.460096613778 | (37.7217810439445, -122.460096613778) | |||
147189 | 147189 | 213947 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995892.36071 | 2091233.5723299999 | 37.7218937190991 | -122.456295465473 | (37.7218937190991, -122.456295465473) | |||
171603 | 171603 | 213948 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 300 Holloway Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995862.50546 | 2091234.8214599998 | 37.7218954350104 | -122.456398757109 | (37.7218954350104, -122.456398757109) | |||
131782 | 131782 | 179284 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 721 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 4ft | 6010763.30464 | 2091319.72205 | 37.7229727292859 | -122.404896194231 | (37.7229727292859, -122.404896194231) | |||
69784 | 69784 | 213949 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 223 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994439.2720800005 | 2091407.20179 | 37.722286941382706 | -122.46133096657199 | (37.7222869413827, -122.461330966572) | |||
59413 | 59413 | 70593 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | ||
28339 | 28339 | 73442 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 8 | 6004223.020830001 | 2091452.87155 | 37.72297057362721 | -122.42751410409402 | (37.7229705736272, -122.427514104094) | ||
184861 | 184861 | 70592 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 4 | 6004234.1327 | 2091472.6068400003 | 37.7230253908821 | -122.42747709790001 | (37.7230253908821, -122.4274770979) | ||
167872 | 167872 | 179328 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 381 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003082.18231 | 2091589.31338 | 37.7232806193946 | -122.431467482451 | (37.7232806193946, -122.431467482451) | |||
53551 | 53551 | 179326 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 327 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003741.707719999 | 2091620.88811 | 37.7234046745582 | -122.429189879225 | (37.7234046745582, -122.429189879225) | |||
149933 | 149933 | 179329 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 381 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003114.67783 | 2091636.05117 | 37.7234107926576 | -122.43135848642599 | (37.7234107926576, -122.431358486426) | |||
157725 | 157725 | 70621 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 713 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 6 | 6004140.669919999 | 2091658.5029099998 | 37.7235305337986 | -122.427813419165 | (37.7235305337986, -122.427813419165) | ||
152526 | 152526 | 179327 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 332 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003477.0395 | 2091792.3955 | 37.72386060926979 | -122.430117017306 | (37.7238606092698, -122.430117017306) | |||
47148 | 47148 | 72144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 5 | 6000049.527000001 | 2091859.62504 | 37.723850484693706 | -122.441970156497 | (37.7238504846937, -122.441970156497) | ||
30247 | 30247 | 179306 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 272 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003680.49546 | 2092115.04602 | 37.7247580571263 | -122.429436701757 | (37.7247580571263, -122.429436701757) | |||
134770 | 134770 | 179307 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 263 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003768.55013 | 2092162.8049599999 | 37.724894177618 | -122.429135711245 | (37.724894177618, -122.429135711245) | |||
181259 | 181259 | 179308 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 223 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6003895.65676 | 2092365.8261400003 | 37.7254588232518 | -122.428710784278 | (37.7254588232518, -122.428710784278) | |||
74006 | 74006 | 179305 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 226 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003843.99427 | 2092374.03152 | 37.7254784293655 | -122.42888996161899 | (37.7254784293655, -122.428889961619) | |||
50427 | 50427 | 179309 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 213 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6003911.34447 | 2092391.41197 | 37.725529964113605 | -122.42865837630801 | (37.7255299641136, -122.428658376308) | |||
4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
143665 | 143665 | 179304 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 210 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003900.76299 | 2092464.46075 | 37.7257299409794 | -122.428700160583 | (37.7257299409794, -122.428700160583) | |||
11111 | 11111 | 110496 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003585.89382 | 2092469.97138 | 37.7257272466074 | -122.429789031845 | (37.7257272466074, -122.429789031845) | |||
10316 | 10316 | 110495 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003598.79471 | 2092490.0157299999 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | |||
166360 | 166360 | 179310 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 433 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006956.6621199995 | 2092492.35946 | 37.725979022613295 | -122.41813810341101 | (37.7259790226133, -122.418138103411) | |||
25963 | 25963 | 179311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | |||
66275 | 66275 | 106724 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 421 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6006940.66037 | 2092543.6305799999 | 37.7261189013498 | -122.418197053944 | (37.7261189013498, -122.418197053944) | ||||
161356 | 161356 | 179312 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 407 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6006926.51281 | 2092590.5645700002 | 37.726246975603 | -122.41824928748001 | (37.726246975603, -122.41824928748) | |||
56406 | 56406 | 179294 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 187 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004035.67978 | 2092592.11371 | 37.7260880824925 | -122.428242857139 | (37.7260880824925, -122.428242857139) | |||
149660 | 149660 | 179303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 204 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003684.6928 | 2092628.55261 | 37.726168269630996 | -122.42945879538901 | (37.726168269631, -122.429458795389) | |||
161550 | 161550 | 199972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6017032.2494 | 2092637.585 | 37.7269397498685 | -122.38331721142401 | (37.7269397498685, -122.383317211424) | |||
58178 | 58178 | 179302 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 200 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003690.09434 | 2092638.18195 | 37.7261950154772 | -122.429440808968 | (37.7261950154772, -122.429440808968) | |||
29146 | 29146 | 179293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 180 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004018.855 | 2092658.23186 | 37.7262686762461 | -122.428305729646 | (37.7262686762461, -122.428305729646) | |||
161134 | 161134 | 199943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6017830.3585 | 2092664.2977 | 37.7270571724447 | -122.380559991407 | (37.7270571724447, -122.380559991407) | |||
72007 | 72007 | 179292 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 180 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004024.15435 | 2092667.6547299998 | 37.7262948492128 | -122.428288081343 | (37.7262948492128, -122.428288081343) | |||
47463 | 47463 | 70412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | ||
170803 | 170803 | 179301 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 324 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003618.31142 | 2092719.8675400002 | 37.7264152414524 | -122.429694781997 | (37.7264152414524, -122.429694781997) | |||
40711 | 40711 | 179300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 318 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003594.26211 | 2092734.45611 | 37.7264539365874 | -122.42977895945499 | (37.7264539365874, -122.429778959455) | |||
129542 | 129542 | 199942 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1151 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6017725.4053 | 2092742.7421 | 37.7272667732913 | -122.38092826799401 | (37.7272667732913, -122.380928267994) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");