Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35801 | 35801 | 215481 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.739936758872204 | -122.462836916405 | (37.7399367588722, -122.462836916405) | |||
180262 | 180262 | 215482 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994118.54253 | 2097814.9092900003 | 37.7398624703831 | -122.462904293614 | (37.7398624703831, -122.462904293614) | |||
150445 | 150445 | 180561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1134 Naples St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6001348.51244 | 2087850.78247 | 37.712917038962495 | -122.437192888562 | (37.7129170389625, -122.437192888562) | |||
165192 | 165192 | 180560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1134 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 6001363.50733 | 2087875.35573 | 37.7129853640648 | -122.437142819708 | (37.7129853640648, -122.437142819708) | |||
27196 | 27196 | 198667 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 124 Russ St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6010302.39718 | 2111555.70743 | 37.778510504382794 | -122.407915770511 | (37.7785105043828, -122.407915770511) | |||
171259 | 171259 | 215529 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 14 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994038.78637 | 2097743.43372 | 37.739661622078295 | -122.46317486995001 | (37.7396616220783, -122.46317486995) | |||
64122 | 64122 | 242453 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 140 Belgrave Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 2ft | 5997900.49529 | 2104918.67096 | 37.7595847638524 | -122.45033989586399 | (37.7595847638524, -122.450339895864) | |||
167461 | 167461 | 198680 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6010306.35372 | 2111595.60808 | 37.7786202837256 | -122.40790489770399 | (37.7786202837256, -122.407904897704) | |||
37359 | 37359 | 215483 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994103.6572 | 2097790.09327 | 37.7397934743851 | -122.46295396047199 | (37.7397934743851, -122.462953960472) | |||
63775 | 63775 | 200790 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1582 McKinnon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 6015482.0599 | 2095886.5322 | 37.735774914559 | -122.38890295979799 | (37.735774914559, -122.388902959798) | |||
74354 | 74354 | 200792 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1582 McKinnon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 6015444.6863 | 2095914.5624 | 37.735849808179296 | -122.389034132513 | (37.7358498081793, -122.389034132513) | |||
55611 | 55611 | 198674 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 169 Russ St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6010536.5691599995 | 2111353.45515 | 37.7779682743635 | -122.407091416859 | (37.7779682743635, -122.407091416859) | |||
59944 | 59944 | 198525 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014663.37225 | 2096146.01075 | 37.736441977203995 | -122.391751642923 | (37.736441977204, -122.391751642923) | |||
76234 | 76234 | 198526 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014646.0524 | 2096160.0564599999 | 37.736479582376 | -122.391812507248 | (37.736479582376, -122.391812507248) | |||
185967 | 185967 | 198527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014634.66691 | 2096168.3212099997 | 37.736501643630795 | -122.39185244975599 | (37.7365016436308, -122.391852449756) | |||
31013 | 31013 | 198560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1708 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6014655.2828 | 2096153.01044 | 37.7364607478562 | -122.39178010106899 | (37.7364607478562, -122.391780101069) | |||
39339 | 39339 | 198561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1708 Newcomb Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6014636.301940001 | 2096168.28095 | 37.7365016238531 | -122.391846793904 | (37.7365016238531, -122.391846793904) | |||
73770 | 73770 | 198559 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1708 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6014669.54022 | 2096142.63764 | 37.7364330577276 | -122.39173008170201 | (37.7364330577276, -122.391730081702) | |||
24337 | 24337 | 198558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014602.581680001 | 2096122.3818299999 | 37.73637372225429 | -122.391960171423 | (37.7363737222543, -122.391960171423) | |||
168657 | 168657 | 198524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014591.36063 | 2096131.8328599997 | 37.7363990498707 | -122.391999628307 | (37.7363990498707, -122.391999628307) | |||
129804 | 129804 | 198557 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6014596.8944 | 2096198.8509099998 | 37.7365833749264 | -122.391985180675 | (37.7365833749264, -122.391985180675) | |||
149918 | 149918 | 198528 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 7ft | 6014599.09575 | 2096195.7007900001 | 37.736574847558295 | -122.39197734938601 | (37.7365748475583, -122.391977349386) | |||
161771 | 161771 | 198523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1721 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014565.5806599995 | 2096150.99697 | 37.7364502392755 | -122.392090100993 | (37.7364502392755, -122.392090100993) | |||
172471 | 172471 | 198556 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1721 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6014562.239130001 | 2096154.4115400002 | 37.736459429456794 | -122.392101892885 | (37.7364594294568, -122.392101892885) | |||
69805 | 69805 | 198553 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1731 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014499.16672 | 2096200.32532 | 37.736581997166205 | -122.392323172901 | (37.7365819971662, -122.392323172901) | |||
25994 | 25994 | 198552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1737 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6014479.14008 | 2096215.50605 | 37.7366225682648 | -122.39239347560499 | (37.7366225682648, -122.392393475605) | |||
131093 | 131093 | 198520 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1737 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 7ft | 6014468.3432 | 2096223.93289 | 37.7366451070745 | -122.392431394602 | (37.7366451070745, -122.392431394602) | |||
158886 | 158886 | 198521 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1737 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6014485.10287 | 2096211.0948599998 | 37.7366107871579 | -122.39237255107099 | (37.7366107871579, -122.392372551071) | |||
61140 | 61140 | 198551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1739 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6014460.695 | 2096227.3713599998 | 37.736654123686705 | -122.392458078374 | (37.7366541236867, -122.392458078374) | |||
59161 | 59161 | 198549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1742 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6014473.930819999 | 2096284.0177200001 | 37.73681039796789 | -122.39241627700899 | (37.7368103979679, -122.392416277009) | |||
25770 | 25770 | 198550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1743 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6014437.8332 | 2096238.2314099998 | 37.736682673554895 | -122.392537881536 | (37.7366826735549, -122.392537881536) | |||
137036 | 137036 | 198519 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1743 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 7ft | 6014430.37923 | 2096250.7581099998 | 37.7367166553422 | -122.39256452932699 | (37.7367166553422, -122.392564529327) | |||
54689 | 54689 | 198548 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1748 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6014451.76229 | 2096301.9779599998 | 37.7368584820264 | -122.39249417986 | (37.7368584820264, -122.39249417986) | |||
154449 | 154449 | 198530 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1748 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014455.10696 | 2096302.51395 | 37.7368601394856 | -122.39248265324899 | (37.7368601394856, -122.392482653249) | |||
29855 | 29855 | 198531 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1750 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014434.12864 | 2096316.99865 | 37.736898746479895 | -122.392556198035 | (37.7368987464799, -122.392556198035) | |||
74748 | 74748 | 198547 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1750 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6014431.1753 | 2096316.6231 | 37.73689755128171 | -122.392566382859 | (37.7368975512817, -122.392566382859) | |||
53945 | 53945 | 198518 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1759 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6014349.89775 | 2096310.6445799998 | 37.7368766213595 | -122.392846979413 | (37.7368766213595, -122.392846979413) | |||
179616 | 179616 | 198546 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1759 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6014355.59614 | 2096302.28152 | 37.7368539746257 | -122.39282669249901 | (37.7368539746257, -122.392826692499) | |||
135251 | 135251 | 198533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1762 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014374.32844 | 2096361.3025900002 | 37.737017074781896 | -122.392766053934 | (37.7370170747819, -122.392766053934) | |||
160048 | 160048 | 198542 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1762 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6014379.25839 | 2096358.1696400002 | 37.7370087461611 | -122.39274878964301 | (37.7370087461611, -122.392748789643) | |||
129816 | 129816 | 198516 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1763 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 7ft | 6014335.026380001 | 2096322.17337 | 37.736907451020606 | -122.392899203062 | (37.7369074510206, -122.392899203062) | |||
181781 | 181781 | 198545 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1763 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6014347.46676 | 2096307.9182900002 | 37.736869000500995 | -122.392855193808 | (37.736869000501, -122.392855193808) | |||
61085 | 61085 | 198534 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1766 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 7ft | 6014341.63524 | 2096385.88519 | 37.7370827576597 | -122.392880809218 | (37.7370827576597, -122.392880809218) | |||
164412 | 164412 | 198541 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1766 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6014350.02594 | 2096380.1036099999 | 37.737067348687404 | -122.39285139418502 | (37.7370673486874, -122.392851394185) | |||
26682 | 26682 | 198540 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1770 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6014330.01059 | 2096395.8315299999 | 37.7371094225658 | -122.39292169687401 | (37.7371094225658, -122.392921696874) | |||
150324 | 150324 | 198535 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1770 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014325.04496 | 2096399.73326 | 37.73711986009079 | -122.392939138341 | (37.7371198600908, -122.392939138341) | |||
76754 | 76754 | 198539 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1774 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6014319.22336 | 2096405.90013 | 37.7371364696747 | -122.392959697748 | (37.7371364696747, -122.392959697748) | |||
186460 | 186460 | 198536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1782 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014278.07437 | 2096434.6477400002 | 37.7372131188949 | -122.393103980488 | (37.7372131188949, -122.393103980488) | |||
71554 | 71554 | 215528 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994077.87758 | 2097807.84952 | 37.7398407436586 | -122.46304438280501 | (37.7398407436586, -122.463044382805) | |||
159900 | 159900 | 215527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994087.51719 | 2097826.08343 | 37.739891364696895 | -122.463012375939 | (37.7398913646969, -122.463012375939) | |||
158809 | 158809 | 215530 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 20 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994021.331259999 | 2097709.05499 | 37.739566221105704 | -122.463232727835 | (37.7395662211057, -122.463232727835) | |||
33160 | 33160 | 215550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994032.03336 | 2096692.14483 | 37.7367746553097 | -122.463121959218 | (37.7367746553097, -122.463121959218) | |||
36619 | 36619 | 215549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994024.47246 | 2096717.6403700002 | 37.7368442241821 | -122.463149949734 | (37.7368442241821, -122.463149949734) | |||
39650 | 39650 | 215547 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994018.95115 | 2096748.4675900002 | 37.7369285500121 | -122.46317127533999 | (37.7369285500121, -122.46317127534) | |||
133047 | 133047 | 215548 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994023.18881 | 2096729.95205 | 37.736877955053295 | -122.463155280903 | (37.7368779550533, -122.463155280903) | |||
28099 | 28099 | 215484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.739679229001496 | -122.46304340523001 | (37.7396792290015, -122.46304340523) | |||
36418 | 36418 | 215485 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994064.51337 | 2097723.86139 | 37.7396093633696 | -122.46308449795299 | (37.7396093633696, -122.463084497953) | |||
27525 | 27525 | 215551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 212 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994048.13405 | 2096632.6874900002 | 37.7366123276804 | -122.46306197983401 | (37.7366123276804, -122.463061979834) | |||
74462 | 74462 | 215552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 220 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994058.81672 | 2096590.6188599998 | 37.73649743301171 | -122.463021994195 | (37.7364974330117, -122.463021994195) | |||
143698 | 143698 | 215500 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 223 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994062.94348 | 2096703.04121 | 37.736806354618004 | -122.46301588057301 | (37.736806354618, -122.463015880573) | |||
64525 | 64525 | 215554 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 224 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994072.66196 | 2096533.8959299999 | 37.736342483419705 | -122.462970011551 | (37.7363424834197, -122.462970011551) | |||
155291 | 155291 | 215553 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 224 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994066.55371 | 2096555.1384299998 | 37.736400458215 | -122.46299267090099 | (37.736400458215, -122.462992670901) | |||
48305 | 48305 | 215502 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 225 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994102.838830001 | 2096543.31026 | 37.7363700710175 | -122.462866361103 | (37.7363700710175, -122.462866361103) | |||
171175 | 171175 | 215501 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 225 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994092.6368 | 2096583.0249700001 | 37.7364785301452 | -122.462904513945 | (37.7364785301452, -122.462904513945) | |||
28058 | 28058 | 215555 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 230 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994079.01038 | 2096505.73845 | 37.7362655356317 | -122.46294602033701 | (37.7362655356317, -122.462946020337) | |||
137176 | 137176 | 215557 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 230 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994081.97838 | 2096463.44747 | 37.7361495860356 | -122.462932691498 | (37.7361495860356, -122.462932691498) | |||
185782 | 185782 | 215556 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 230 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994083.61734 | 2096486.4471099998 | 37.736212831753896 | -122.46292869311701 | (37.7362128317539, -122.462928693117) | |||
59643 | 59643 | 215503 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 233 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994106.38436 | 2096527.49502 | 37.736326850502294 | -122.46285295579901 | (37.7363268505023, -122.462852955799) | |||
44229 | 44229 | 181868 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2335 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 5987618.1769 | 2099375.389 | 37.7437705756333 | -122.48549403463801 | (37.7437705756333, -122.485494034638) | |||
151862 | 151862 | 215504 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 235 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994113.803830001 | 2096483.0865200001 | 37.736205343103705 | -122.462824083076 | (37.7362053431037, -122.462824083076) | |||
26007 | 26007 | 215558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994076.83101 | 2096438.6024200001 | 37.7360810711916 | -122.46294868592699 | (37.7360810711916, -122.462948685927) | |||
50663 | 50663 | 215561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994051.56415 | 2096391.9131599998 | 37.7359514186289 | -122.46303265654899 | (37.7359514186289, -122.463032656549) | |||
170224 | 170224 | 215559 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994067.05947 | 2096413.8540400001 | 37.7360125554181 | -122.46298067483102 | (37.7360125554181, -122.462980674831) | |||
181242 | 181242 | 215560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994063.02887 | 2096405.4928599999 | 37.7359893655189 | -122.462994003686 | (37.7359893655189, -122.462994003686) | |||
137681 | 137681 | 183427 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2419 22nd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5989498.022999999 | 2098855.9096 | 37.7424535651362 | -122.478956057135 | (37.7424535651362, -122.478956057135) | |||
154584 | 154584 | 183426 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2419 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5989497.0526 | 2098869.9717 | 37.742492119648205 | -122.478960440771 | (37.7424921196482, -122.478960440771) | |||
131337 | 131337 | 215562 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 244 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994036.57489 | 2096375.72 | 37.735906092783 | -122.463083305449 | (37.735906092783, -122.463083305449) | |||
135165 | 135165 | 215563 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 244 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993985.88408 | 2096348.3750200002 | 37.735828090088894 | -122.463256578734 | (37.7358280900889, -122.463256578734) | |||
177068 | 177068 | 215505 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 245 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994112.73436 | 2096460.53675 | 37.7361433654214 | -122.462826145227 | (37.7361433654214, -122.462826145227) | |||
64606 | 64606 | 215486 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 25 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994053.65956 | 2097702.19422 | 37.739549245488796 | -122.46312045374901 | (37.7395492454888, -122.463120453749) | |||
66415 | 66415 | 215487 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 25 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994042.19305 | 2097679.65263 | 37.7394866913615 | -122.46315846449 | (37.7394866913615, -122.46315846449) | |||
24162 | 24162 | 215566 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993936.1007 | 2096327.5375 | 37.735768007292705 | -122.463427186434 | (37.7357680072927, -122.463427186434) | |||
109259 | 109259 | 215564 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993972.9824 | 2096339.8161099998 | 37.7358038461725 | -122.463300563692 | (37.7358038461725, -122.463300563692) | |||
167961 | 167961 | 215565 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993953.18487 | 2096333.32123 | 37.7357848722665 | -122.46336853982099 | (37.7357848722665, -122.463368539821) | |||
62362 | 62362 | 215567 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 254 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993893.11792 | 2096318.4579099999 | 37.735740600456 | -122.46357513479201 | (37.735740600456, -122.463575134792) | |||
68154 | 68154 | 215507 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 255 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994095.64493 | 2096399.41615 | 37.735974559073604 | -122.462880797029 | (37.7359745590736, -122.462880797029) | |||
181522 | 181522 | 215506 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 255 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994105.35353 | 2096421.48762 | 37.7360357210632 | -122.46284883151199 | (37.7360357210632, -122.462848831512) | |||
173974 | 173974 | 215508 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 261 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994073.52001 | 2096368.39822 | 37.7358881171279 | -122.462955041436 | (37.7358881171279, -122.462955041436) | |||
47189 | 47189 | 215569 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 262 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993829.85654 | 2096316.71457 | 37.735732168414 | -122.46379372579901 | (37.735732168414, -122.463793725799) | |||
49155 | 49155 | 215568 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 262 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993854.87202 | 2096314.6537799998 | 37.735727951492294 | -122.463707088708 | (37.7357279514923, -122.463707088708) | |||
188770 | 188770 | 215509 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 265 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994040.687530001 | 2096338.7929099998 | 37.7358049370452 | -122.46306640808201 | (37.7358049370452, -122.463066408082) | |||
33717 | 33717 | 215511 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993997.50574 | 2096315.53912 | 37.73573860035479 | -122.463214016518 | (37.7357386003548, -122.463214016518) | |||
56932 | 56932 | 215513 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993924.28661 | 2096292.23015 | 37.7356703813878 | -122.463465470563 | (37.7356703813878, -122.463465470563) | |||
74578 | 74578 | 215514 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993902.7407599995 | 2096288.82132 | 37.7356597801802 | -122.463539714991 | (37.7356597801802, -122.463539714991) | |||
131907 | 131907 | 215515 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993879.1268 | 2096286.34679 | 37.735651625116795 | -122.463621177382 | (37.7356516251168, -122.463621177382) | |||
153089 | 153089 | 215510 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994019.7098199995 | 2096325.7252599997 | 37.73576784809 | -122.463137987822 | (37.73576784809, -122.463137987822) | |||
170673 | 170673 | 215512 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993946.596609999 | 2096298.3133099999 | 37.7356883696217 | -122.463388778181 | (37.7356883696217, -122.463388778181) | |||
179957 | 179957 | 123533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3 05th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5994221.757259999 | 2115563.2113799998 | 37.7886006193808 | -122.46383534054199 | (37.7886006193808, -122.463835340542) | |||
43463 | 43463 | 215571 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 32 Malta Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5999675.11481 | 2095972.7575700001 | 37.7351228462426 | -122.443559761297 | (37.7351228462426, -122.443559761297) | |||
169976 | 169976 | 215488 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 33 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994033.38086 | 2097656.1674099998 | 37.7394216991581 | -122.463187229312 | (37.7394216991581, -122.463187229312) |
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");