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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
125642 | 125642 | 39796 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
59080 | 59080 | 54488 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 541 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1972 12:00:00 AM | 7 | Permit Number 10280 | 5983765.72695 | 2112144.55084 | 37.7786058896943 | -122.49975827976499 | (37.7786058896943, -122.499758279765) | ||
73714 | 73714 | 184906 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1990 41st Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983545.4397 | 2101789.6902 | 37.7501614543488 | -122.49975477788901 | (37.7501614543488, -122.499754777889) | |||
184396 | 184396 | 117905 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 541 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5983767.17374 | 2112125.62524 | 37.7785540103948 | -122.499751875651 | (37.7785540103948, -122.499751875651) | |||
168824 | 168824 | 52562 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1267 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 3 | Permit Number 48659 | 5983648.1273 | 2106539.2749 | 37.763208509322794 | -122.49975069135 | (37.7632085093228, -122.49975069135) | |
76688 | 76688 | 183284 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1267 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983648.6729 | 2106520.7252 | 37.763157609115204 | -122.499747433217 | (37.7631576091152, -122.499747433217) | |||
37029 | 37029 | 184963 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1990 41st Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983546.455 | 2101707.1153 | 37.7499347861229 | -122.499745164476 | (37.7499347861229, -122.499745164476) | |||
60804 | 60804 | 184962 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1990 41st Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5983548.4855 | 2101665.8278 | 37.7498215412297 | -122.49973509178899 | (37.7498215412297, -122.499735091789) | |||
28439 | 28439 | 54494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 555 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1972 12:00:00 AM | 7 | Permit Number 10286 | 5983770.26355 | 2112042.83675 | 37.7783268785645 | -122.49973506639401 | (37.7783268785645, -122.499735066394) | ||
171115 | 171115 | 43047 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2151 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 4 | Permit Number 42901 | 5983544.7629 | 2100515.7013 | 37.7466633929793 | -122.499662971026 | (37.7466633929793, -122.499662971026) | |
32285 | 32285 | 43048 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2159 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 8 | Permit Number 42902 | 5983545.7781 | 2100465.2765 | 37.7465249999307 | -122.499655734442 | (37.7465249999307, -122.499655734442) | |
65561 | 65561 | 43049 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2163 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 4 | Permit Number 42903 | 5983547.8087 | 2100426.6964 | 37.746419188745705 | -122.499645862071 | (37.7464191887457, -122.499645862071) | |
176567 | 176567 | 52561 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1234 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 7 | Permit Number 48657 | 5983685.9087 | 2106728.1821 | 37.7637294119346 | -122.49963398254299 | (37.7637294119346, -122.499633982543) | |
151762 | 151762 | 54503 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 530 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 8 | Permit Number 10297 | 5983809.75078 | 2112179.78652 | 37.778705219862104 | -122.499608591667 | (37.7787052198621, -122.499608591667) | ||
65452 | 65452 | 54489 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 542 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1972 12:00:00 AM | 6 | Permit Number 10281 | 5983813.3329 | 2112120.03018 | 37.7785413564974 | -122.49959178241001 | (37.7785413564974, -122.49959178241) | ||
167197 | 167197 | 183312 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1278 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983694.637999999 | 2106469.3043 | 37.7630191190041 | -122.499584657362 | (37.7630191190041, -122.499584657362) | |||
176291 | 176291 | 54492 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 550 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/1972 12:00:00 AM | 8 | Permit Number 10284 | 5983814.5335 | 2112067.92848 | 37.7783983708083 | -122.49958377753 | (37.7783983708083, -122.49958377753) | ||
163762 | 163762 | 183311 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1278 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983695.1836 | 2106447.4811 | 37.7629592306856 | -122.499581157409 | (37.7629592306856, -122.499581157409) | |||
54766 | 54766 | 117843 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5983810.12526 | 2111540.49138 | 37.776949922870294 | -122.49956003685301 | (37.7769499228703, -122.499560036853) | |||
69761 | 69761 | 117845 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 6ft | 5983812.70856 | 2111515.33399 | 37.7768809995382 | -122.49954924088199 | (37.7768809995382, -122.499549240882) | |||
154625 | 154625 | 117847 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 640x 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 5983816.430369999 | 2111419.8653700002 | 37.7766190887274 | -122.49952930905701 | (37.7766190887274, -122.499529309057) | |||
76029 | 76029 | 117836 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 6ft | 5983819.78589 | 2111279.0355 | 37.776232607542504 | -122.499507291354 | (37.7762326075425, -122.499507291354) | |||
167503 | 167503 | 117838 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5983820.62988 | 2111252.49481 | 37.7761597840052 | -122.499502409931 | (37.7761597840052, -122.499502409931) | |||
105087 | 105087 | 813 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
111465 | 111465 | 810 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
114988 | 114988 | 812 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
145424 | 145424 | 809 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
54755 | 54755 | 71633 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 666 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983841.90754 | 2111286.39703 | 37.7762541180901 | -122.49943131186501 | (37.7762541180901, -122.499431311865) | ||
106760 | 106760 | 99309 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 6 | 3X3 | 5983703.9 | 2101544.3 | 37.7494969779561 | -122.49918869137501 | (37.7494969779561, -122.499188691375) | ||
62674 | 62674 | 185050 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2735 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983672.8883 | 2096524.5821 | 37.7357123843546 | -122.498925114194 | (37.7357123843546, -122.498925114194) | |||
64086 | 64086 | 53480 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1206 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1969 12:00:00 AM | 2 | Permit Number 6389 | 5983992.7975 | 2106909.1782 | 37.764244378480704 | -122.49858593622 | (37.7642443784807, -122.49858593622) | ||
77146 | 77146 | 118235 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 670 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5984152.37424 | 2111283.69905 | 37.7762649206021 | -122.49835713968201 | (37.7762649206021, -122.498357139682) | |||
122493 | 122493 | 50403 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1546 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | Permit Number 48650 | 5984072.75898707 | 2104637.91247465 | 37.7580128106665 | -122.49814162678999 | (37.7580128106665, -122.49814162679) | ||
47114 | 47114 | 83992 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1682 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51096 | 5984098.9069 | 2103728.8955 | 37.7555184368042 | -122.497984070914 | (37.7555184368042, -122.497984070914) | |
130211 | 130211 | 52069 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1766 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2005 12:00:00 AM | 2 | Permit Number 48264 | 5984118.7262 | 2103148.2845 | 37.75392540236329 | -122.497872659115 | (37.7539254023633, -122.497872659115) | ||
170767 | 170767 | 183714 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1215 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5984258.0858 | 2106883.6724 | 37.7641899012706 | -122.497666510275 | (37.7641899012706, -122.497666510275) | |||
181316 | 181316 | 75333 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 550 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 4 | 5984432.92075 | 2112122.5576299997 | 37.7785846311766 | -122.497448611437 | (37.7785846311766, -122.497448611437) | ||
133131 | 133131 | 75410 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 550 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 4 | 5984433.26554 | 2112138.70931 | 37.7786289992279 | -122.49744861143101 | (37.7786289992279, -122.497448611431) | ||
165422 | 165422 | 75252 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 550 37th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 6 | 5984435.27406 | 2112051.0213099997 | 37.7783883510577 | -122.49743518792499 | (37.7783883510577, -122.497435187925) | ||
171615 | 171615 | 75170 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 550 37th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5984437.14625 | 2112031.3092900002 | 37.7783343372815 | -122.49742725578501 | (37.7783343372815, -122.497427255785) | ||
170274 | 170274 | 183706 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1390 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984341.3234 | 2105731.2824 | 37.7610306415519 | -122.497293543423 | (37.7610306415519, -122.497293543423) | |||
71239 | 71239 | 184540 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3131 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5984528.9702 | 2103585.9441 | 37.7551511364506 | -122.496486253509 | (37.7551511364506, -122.496486253509) | |||
33616 | 33616 | 69029 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1423 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 8 | Permit Number 33035 | 5984615.7707 | 2105488.0931 | 37.7603789927974 | -122.49632641947399 | (37.7603789927974, -122.496326419474) | |
72254 | 72254 | 183152 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2358 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984567.4093 | 2099139.1957 | 37.742943836885296 | -122.49602528472 | (37.7429438368853, -122.49602528472) | |||
35474 | 35474 | 183151 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2358 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984568.7624 | 2099123.297 | 37.7429002626214 | -122.496019433491 | (37.7429002626214, -122.496019433491) | |||
121007 | 121007 | 20749 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1692X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
103970 | 103970 | 20876 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1892X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
115042 | 115042 | 20880 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1892X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
115084 | 115084 | 20877 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1892X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
41200 | 41200 | 104071 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 590 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2013 12:00:00 AM | 1 | 3x3 | Permit Number 770130 | 5985063.180319999 | 2111850.11147 | 37.777873493280296 | -122.495248237578 | (37.7778734932803, -122.495248237578) | |
130267 | 130267 | 184018 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984912.6418 | 2103753.8138 | 37.7556345299307 | -122.495171803184 | (37.7556345299307, -122.495171803184) | |||
133852 | 133852 | 184026 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984920.3345 | 2103785.5463 | 37.7557221089671 | -122.495147539697 | (37.7557221089671, -122.495147539697) | |||
173503 | 173503 | 184034 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984925.6803 | 2103804.9468 | 37.7557756903402 | -122.49513048303801 | (37.7557756903402, -122.495130483038) | |||
147099 | 147099 | 184031 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984927.2534 | 2103793.0767 | 37.755743190427204 | -122.495124167563 | (37.7557431904272, -122.495124167563) | |||
167786 | 167786 | 184036 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984928.8265 | 2103810.0952 | 37.7557900106144 | -122.49511998225799 | (37.7557900106144, -122.495119982258) | |||
39133 | 39133 | 184025 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984931.5337 | 2103784.5063 | 37.7557199090675 | -122.495108733182 | (37.7557199090675, -122.495108733182) | |||
137954 | 137954 | 184027 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984931.8298 | 2103786.2121 | 37.7557246100571 | -122.495107834969 | (37.7557246100571, -122.495107834969) | |||
59223 | 59223 | 184039 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984935.4051 | 2103815.5297 | 37.755805317385004 | -122.4950976324 | (37.755805317385, -122.4950976324) | |||
76965 | 76965 | 184009 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984939.2377 | 2103728.7585 | 37.755567292052795 | -122.495077980088 | (37.7555672920528, -122.495077980088) | |||
176625 | 176625 | 118253 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 843 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5985078.99766 | 2110125.70475 | 37.7731396920548 | -122.495066333199 | (37.7731396920548, -122.495066333199) | |||
33247 | 33247 | 118252 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 843 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5985079.97814 | 2110107.82999 | 37.773090670458295 | -122.49506162333599 | (37.7730906704583, -122.495061623336) | |||
147236 | 147236 | 184010 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1600 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984951.0048 | 2103730.9648 | 37.755574038818104 | -122.49503744907301 | (37.7555740388181, -122.495037449073) | |||
182236 | 182236 | 182356 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3151 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5985005.527000001 | 2104966.2042 | 37.7589688553292 | -122.494939971824 | (37.7589688553292, -122.494939971824) | |||
168303 | 168303 | 187200 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2301 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984910.7598 | 2099021.3208 | 37.7426402887161 | -122.49482940193998 | (37.7426402887161, -122.49482940194) | |||
185004 | 185004 | 186299 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1800 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985021.1385 | 2102711.497 | 37.7527789669048 | -122.49471975093701 | (37.7527789669048, -122.494719750937) | |||
37184 | 37184 | 182357 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3141 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5985082.5718 | 2104968.549 | 37.7589798033254 | -122.494673691497 | (37.7589798033254, -122.494673691497) | |||
76535 | 76535 | 187242 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2401 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984947.0235 | 2098562.0875 | 37.7413814807711 | -122.494670165431 | (37.7413814807711, -122.494670165431) | |||
179104 | 179104 | 187244 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2401 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984957.2356 | 2098537.5785 | 37.7413147833906 | -122.494633049632 | (37.7413147833906, -122.494633049632) | |||
24225 | 24225 | 50246 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1287 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 0 | Permit Number 46951 | 5985199.39967199 | 2106457.48369728 | 37.7630748403476 | -122.49437940567101 | (37.7630748403476, -122.494379405671) | |
114354 | 114354 | 21248 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2401X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.49433209823401 | (37.7422115377949, -122.494332098234) | |||
156868 | 156868 | 185356 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2601 Sunset Blvd | 81 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985014.265 | 2096945.9513 | 37.736947940348294 | -122.49431857261001 | (37.7369479403483, -122.49431857261) | |||
65631 | 65631 | 96633 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2827 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767879 | 5985197.0326 | 2102920.1993 | 37.7533623000315 | -122.494126866912 | (37.7533623000315, -122.494126866912) | |
52134 | 52134 | 45597 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1770 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2001 12:00:00 AM | 7 | Permit Number 44332 | 5985361.4044 | 2103173.351 | 37.7540670019119 | -122.493577094797 | (37.7540670019119, -122.493577094797) | |
63320 | 63320 | 182847 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1790 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985366.9663 | 2103044.3154 | 37.7537130309901 | -122.493548353659 | (37.7537130309901, -122.493548353659) | |||
151163 | 151163 | 185759 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2520 Rivera St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985327.7352 | 2100265.3599 | 37.7460804829424 | -122.49347928321899 | (37.7460804829424, -122.493479283219) | |||
173413 | 173413 | 185757 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2510 Rivera St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985356.995 | 2100268.6849 | 37.74609132403779 | -122.493378353024 | (37.7460913240378, -122.493378353024) | |||
46729 | 46729 | 185755 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2500 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985387.9173 | 2100269.6824 | 37.7460958716028 | -122.493271502729 | (37.7460958716028, -122.493271502729) | |||
71762 | 71762 | 118180 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 719 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985671.7912800005 | 2110975.9940400003 | 37.775509030509795 | -122.493078461204 | (37.7755090305098, -122.493078461204) | |||
147341 | 147341 | 118179 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 725 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5985671.99476 | 2110951.2879 | 37.7754412063892 | -122.49307593694701 | (37.7754412063892, -122.493075936947) | |||
158965 | 158965 | 118178 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 727 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5985673.201280001 | 2110928.01346 | 37.775377371969796 | -122.493070048484 | (37.7753773719698, -122.493070048484) | |||
60942 | 60942 | 118177 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 731 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985675.34948 | 2110903.2656 | 37.7753095470309 | -122.493060794027 | (37.7753095470309, -122.493060794027) | |||
53121 | 53121 | 118176 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 735 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985681.324990001 | 2110875.53029 | 37.775233743237 | -122.493038080126 | (37.775233743237, -122.493038080126) | |||
157427 | 157427 | 118175 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 791 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985688.2167 | 2110525.43748 | 37.7742728910373 | -122.492988446406 | (37.7742728910373, -122.492988446406) | |||
172483 | 172483 | 92250 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1418 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52699 | 5985588.7674 | 2105529.3375 | 37.760549188292295 | -122.49296436224199 | (37.7605491882923, -122.492964362242) | |
184023 | 184023 | 119455 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5985727.9206 | 2110655.10709 | 37.7746312487913 | -122.49286065837799 | (37.7746312487913, -122.492860658378) | |||
25782 | 25782 | 119454 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 770 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5985729.2789 | 2110639.79727 | 37.774589291809605 | -122.492854831906 | (37.7745892918096, -122.492854831906) | |||
163947 | 163947 | 119453 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 774 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5985730.235119999 | 2110623.1913400004 | 37.7745437525651 | -122.49285030080601 | (37.7745437525651, -122.492850300806) | |||
65746 | 65746 | 182411 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1522 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985613.8208 | 2104844.1281 | 37.7586692583075 | -122.49282724454201 | (37.7586692583075, -122.492827244542) | |||
55142 | 55142 | 182410 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1522 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985613.4353 | 2104824.559 | 37.7586155044304 | -122.492827136387 | (37.7586155044304, -122.492827136387) | |||
154052 | 154052 | 182383 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1518 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985615.4072 | 2104868.7172 | 37.75873686594 | -122.49282356924299 | (37.75873686594, -122.492823569243) | |||
167864 | 167864 | 84303 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3132 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50097 | 5985826.14463 | 2111157.47725 | 37.776016357760504 | -122.492557891983 | (37.7760163577605, -122.492557891983) | |
131266 | 131266 | 250766 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 242 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5985905.94434 | 2114279.52557 | 37.7845932723154 | -122.49251182078699 | (37.7845932723154, -122.492511820787) | |||
178795 | 178795 | 119436 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 743 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985983.03487 | 2110840.7670299998 | 37.775155933503 | -122.491991851858 | (37.775155933503, -122.491991851858) | |||
31142 | 31142 | 119437 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985984.32142 | 2110827.9235900003 | 37.7751207442671 | -122.491986455657 | (37.7751207442671, -122.491986455657) | |||
66373 | 66373 | 50239 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1446 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 4 | Permit Number 46945 | 5985903.9099 | 2105369.6531 | 37.7601291639736 | -122.491862687346 | (37.7601291639736, -122.491862687346) | |
105492 | 105492 | 50238 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1446 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2003 12:00:00 AM | Permit Number 46945 | 5985908.94380478 | 2105381.71258491 | 37.760162570205395 | -122.491846165538 | (37.7601625702054, -122.491846165538) | |||
174151 | 174151 | 84307 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 722 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50096 | 5986028.94056 | 2110951.60768 | 37.7754629536311 | -122.491841217841 | (37.7754629536311, -122.491841217841) | |
45237 | 45237 | 185266 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2301 Vicente St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5985748.3724 | 2097496.5905 | 37.7385027823228 | -122.491820997516 | (37.7385027823228, -122.491820997516) | |||
158036 | 158036 | 42882 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2410 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 10 | Permit Number 42803 | 5985820.9879 | 2098800.5796 | 37.7420874316705 | -122.49166589554501 | (37.7420874316705, -122.491665895545) | |
174164 | 174164 | 119375 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 870 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5986062.66321 | 2109973.28361 | 37.7727787239531 | -122.49165253212401 | (37.7727787239531, -122.491652532124) |
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");