Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3087 | 3087 | 19650 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 4862 | 4862 | 19656 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 5896 | 5896 | 19680 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 5976 | 5976 | 19649 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 6914 | 6914 | 19672 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7103 | 7103 | 19675 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7153 | 7153 | 19677 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 76 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7446 | 7446 | 19683 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 9546 | 9546 | 19678 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 77 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 9875 | 9875 | 19651 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 10475 | 10475 | 19661 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 12748 | 12748 | 19671 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 14057 | 14057 | 19674 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 14729 | 14729 | 19657 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 15686 | 15686 | 19660 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 16120 | 16120 | 19653 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 12006 | 12006 | 1294 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991953.08243 | 2087152.92109 | 37.7104623187479 | -122.469615507754 | (37.7104623187479, -122.469615507754) | |||
| 10605 | 10605 | 1293 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5991961.87152 | 2087160.6390900002 | 37.7104840184951 | -122.46958569253701 | (37.7104840184951, -122.469585692537) | |||
| 109964 | 109964 | 1773 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2000X Bay Shore Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 83866 | 83866 | 11477 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10X Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | |||
| 112318 | 112318 | 11486 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10X Jennings St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | |||
| 118292 | 118292 | 11478 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | |||
| 124892 | 124892 | 11481 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10X Jennings St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6012892.419875 | 2089345.335603 | 37.7176702433836 | -122.397397833393 | (37.7176702433836, -122.397397833393) | |||
| 42536 | 42536 | 176390 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 700x Mansell St | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 6009150.9462 | 2089957.5754799999 | 37.7191423008581 | -122.410373676998 | (37.7191423008581, -122.410373676998) | |||
| 33628 | 33628 | 176389 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 700x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 0ft | 6009439.980830001 | 2090047.93275 | 37.719406601704 | -122.40938096396499 | (37.719406601704, -122.409380963965) | |||
| 67100 | 67100 | 176388 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6011438.192840001 | 2090648.2271599998 | 37.7211666433202 | -122.40251603501001 | (37.7211666433202, -122.40251603501) | |||
| 54771 | 54771 | 176387 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6011480.82156 | 2090667.2216900003 | 37.7212211781905 | -122.402370013862 | (37.7212211781905, -122.402370013862) | |||
| 70249 | 70249 | 176386 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011666.66331 | 2090722.9963200002 | 37.7213846965192 | -122.40173152668501 | (37.7213846965192, -122.401731526685) | |||
| 162071 | 162071 | 176385 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 10x Mansell St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6011675.69162 | 2090725.79104 | 37.7213928740681 | -122.401700514484 | (37.7213928740681, -122.401700514484) | |||
| 15306 | 15306 | 22434 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 6000 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6013550.0151 | 2091475.3264 | 37.7235553639507 | -122.395273931127 | (37.7235553639507, -122.395273931127) | |||
| 16658 | 16658 | 22427 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 5919 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6013743.1817 | 2091759.1378 | 37.724345394142 | -122.39462604842699 | (37.724345394142, -122.394626048427) | |||
| 20112 | 20112 | 29963 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991394.8537099995 | 2093447.95886 | 37.7277146673841 | -122.47200336878099 | (37.7277146673841, -122.472003368781) | ||
| 111415 | 111415 | 11292 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1199X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/1990 12:00:00 AM | 30 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | ||
| 85513 | 85513 | 11303 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1201X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017591.0151778 | 2093928.8426978001 | 37.7305161553992 | -122.38147530581499 | (37.7305161553992, -122.381475305815) | ||
| 96922 | 96922 | 11305 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1201X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017591.0151778 | 2093928.8426978001 | 37.7305161553992 | -122.38147530581499 | (37.7305161553992, -122.381475305815) | ||
| 101060 | 101060 | 11326 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1223 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 50 | 3X3 | 6017540.6929483 | 2093936.3628531997 | 37.730534025837706 | -122.38164980170299 | (37.7305340258377, -122.381649801703) | ||
| 124644 | 124644 | 11327 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1223 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017540.6929483 | 2093936.3628531997 | 37.730534025837706 | -122.38164980170299 | (37.7305340258377, -122.381649801703) | ||
| 37403 | 37403 | 11269 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1176X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1990 12:00:00 AM | 3 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 85383 | 85383 | 11265 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1176X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | 20 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 95268 | 95268 | 11318 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1216X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1990 12:00:00 AM | 60 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | ||
| 103086 | 103086 | 11230 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1050X Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/1990 12:00:00 AM | 45 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | ||
| 128599 | 128599 | 11231 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1050X Ingalls St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/1990 12:00:00 AM | 50 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | ||
| 181793 | 181793 | 206291 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500x Junipero Serra Blvd | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991445.95006 | 2094262.4550299998 | 37.7299540269465 | -122.471886066612 | (37.7299540269465, -122.471886066612) | |||
| 18348 | 18348 | 16020 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 107 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001336.16248 | 2094611.17288 | 37.731478841871706 | -122.437719447913 | (37.7314788418717, -122.437719447913) | |||
| 22088 | 22088 | 16025 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 131 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001203.7257900005 | 2094613.91575 | 37.7314788418574 | -122.438177502293 | (37.7314788418574, -122.438177502293) | |||
| 20184 | 20184 | 16030 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 147 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001102.99289 | 2094615.6926099998 | 37.731477991115796 | -122.438525881668 | (37.7314779911158, -122.438525881668) | |||
| 19938 | 19938 | 16038 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 163 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000989.84379 | 2094618.6563099998 | 37.7314796917131 | -122.43891727113301 | (37.7314796917131, -122.438917271133) | |||
| 124037 | 124037 | 10826 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1139X Hudson Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 3X4 | 6017834.53501 | 2094620.0550099998 | 37.732427530713004 | -122.380681442077 | (37.732427530713, -122.380681442077) | ||
| 21993 | 21993 | 16119 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000050.07874 | 2094632.71852 | 37.7314647899581 | -122.442167217764 | (37.7314647899581, -122.442167217764) | |||
| 17352 | 17352 | 16120 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 303 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000032.3049 | 2094633.40383 | 37.7314656586952 | -122.44222871430401 | (37.7314656586952, -122.442228714304) | |||
| 143617 | 143617 | 16166 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 405 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999388.049433099 | 2094640.7964516003 | 37.7314492181413 | -122.44445655139799 | (37.7314492181413, -122.444456551398) | |||
| 17573 | 17573 | 16029 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 146 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001109.44487 | 2094693.26414 | 37.7316913516547 | -122.43850913181002 | (37.7316913516547, -122.43850913181) | |||
| 98031 | 98031 | 16026 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 134 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001180.6151014995 | 2094696.8372785 | 37.7317052108344 | -122.438263338431 | (37.7317052108344, -122.438263338431) | |||
| 106493 | 106493 | 10804 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1139X Hudson Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X4 | 6017540.26401 | 2094828.3880099999 | 37.7329833277332 | -122.38171330076901 | (37.7329833277332, -122.381713300769) | |||
| 15523 | 15523 | 26807 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1487 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015996.3267 | 2095429.905 | 37.7345495997276 | -122.38709308337098 | (37.7345495997276, -122.387093083371) | |||
| 14940 | 14940 | 26805 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1491 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015969.8239 | 2095448.3954 | 37.734598903014295 | -122.38718600253901 | (37.7345989030143, -122.387186002539) | |||
| 88912 | 88912 | 14871 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 91909 | 91909 | 14872 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 96819 | 96819 | 14870 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 112180 | 112180 | 26802 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 81336 | 81336 | 26808 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1485 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015936.7189767 | 2095472.8520506 | 37.7346642227188 | -122.387302163855 | (37.7346642227188, -122.387302163855) | |||
| 107395 | 107395 | 26806 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1487 McKinnon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015928.376782499 | 2095479.8947363999 | 37.7346830985113 | -122.38733149702601 | (37.7346830985113, -122.387331497026) | |||
| 83724 | 83724 | 26803 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1470 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6016001.5116582 | 2095486.8668237 | 37.734706292549205 | -122.387079128733 | (37.7347062925492, -122.387079128733) | |||
| 99444 | 99444 | 6126 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000780.36286 | 2096039.2702900001 | 37.7353684469933 | -122.439743296782 | (37.7353684469933, -122.439743296782) | |||
| 138565 | 138565 | 6127 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000782.74757 | 2096053.9984099998 | 37.735409022713704 | -122.439736107551 | (37.7354090227137, -122.439736107551) | |||
| 1520 | 1520 | 199389 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 16 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6017439.78771 | 2096071.60272 | 37.7363914002406 | -122.38214713169901 | (37.7363914002406, -122.382147131699) | |||
| 116261 | 116261 | 18633 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017006.0134624 | 2096129.8208529998 | 37.7365272887181 | -122.38365093789899 | (37.7365272887181, -122.383650937899) | |||
| 3956 | 3956 | 15038 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1017 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6015648.0 | 2096190.0 | 37.7366173719863 | -122.388350408836 | (37.7366173719863, -122.388350408836) | |||
| 97379 | 97379 | 15039 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1017 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6015648.596419999 | 2096190.1744099997 | 37.736617883929604 | -122.388348358907 | (37.7366178839296, -122.388348358907) | |||
| 81339 | 81339 | 6119 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 81374 | 81374 | 6123 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 84321 | 84321 | 6121 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 93664 | 93664 | 6117 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 103050 | 103050 | 6118 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 109965 | 109965 | 6122 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 145856 | 145856 | 6120 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 146271 | 146271 | 6125 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
| 13610 | 13610 | 11963 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6015687.60896 | 2096283.0567700001 | 37.736875081728705 | -122.38821995489599 | (37.7368750817287, -122.388219954896) | |||
| 23270 | 23270 | 11971 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1022X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X3 | 6015641.62594 | 2096289.89853 | 37.736891319872896 | -122.388379417299 | (37.7368913198729, -122.388379417299) | |||
| 23178 | 23178 | 11964 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6015715.011390001 | 2096321.03931 | 37.7369808923559 | -122.38812786163 | (37.7369808923559, -122.38812786163) | |||
| 123575 | 123575 | 11966 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015728.77645 | 2096327.58352 | 37.736999624078 | -122.38808072579599 | (37.736999624078, -122.388080725796) | |||
| 144147 | 144147 | 11973 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1020X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015669.55392 | 2096331.84807 | 37.7370080523218 | -122.388285783946 | (37.7370080523218, -122.388285783946) | |||
| 45604 | 45604 | 11962 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 945X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015820.0973 | 2096449.8462 | 37.7373403917231 | -122.38777351408001 | (37.7373403917231, -122.38777351408) | |||
| 16820 | 16820 | 11511 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5 | 6018385.91854 | 2096547.1526 | 37.7377493756286 | -122.378908940096 | (37.7377493756286, -122.378908940096) | |||
| 15508 | 15508 | 11512 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018400.60741 | 2096569.54507 | 37.7378116707805 | -122.378859707612 | (37.7378116707805, -122.378859707612) | |||
| 16711 | 16711 | 11513 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018414.43418 | 2096589.52395 | 37.7378672911411 | -122.378813288221 | (37.7378672911411, -122.378813288221) | |||
| 15917 | 15917 | 11515 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018435.759869999 | 2096618.26492 | 37.7379473838671 | -122.378741549297 | (37.7379473838671, -122.378741549297) | |||
| 13998 | 13998 | 11516 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018445.80461 | 2096632.24283 | 37.737986318204605 | -122.378707789643 | (37.7379863182046, -122.378707789643) | |||
| 15740 | 15740 | 11517 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018459.10272 | 2096646.1554299998 | 37.738025252555 | -122.37866277678499 | (37.738025252555, -122.378662776785) | |||
| 123070 | 123070 | 11559 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 830X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015912.14045 | 2096650.33898 | 37.737896002535294 | -122.387469258127 | (37.7378960025353, -122.387469258127) | |||
| 20202 | 20202 | 5091 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2600 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002242.42307 | 2096653.9998400002 | 37.7371394644141 | -122.434732362321 | (37.7371394644141, -122.434732362321) | |||
| 13853 | 13853 | 11518 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018467.96004 | 2096661.77747 | 37.7380686358665 | -122.37863323672899 | (37.7380686358665, -122.378633236729) | |||
| 121890 | 121890 | 11558 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 830X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015923.7081699995 | 2096663.9429799998 | 37.7379339970425 | -122.387430211254 | (37.7379339970425, -122.387430211254) | |||
| 16734 | 16734 | 11519 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018482.73466 | 2096678.8993400002 | 37.7381164636019 | -122.378583341463 | (37.7381164636019, -122.378583341463) | |||
| 122202 | 122202 | 11556 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 830X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 18 | 3X3 | 6015938.87476 | 2096683.24967 | 37.737987849284394 | -122.387379118862 | (37.7379878492844, -122.387379118862) | ||
| 1068 | 1068 | 11520 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3X3 | 6018495.90717 | 2096693.85175 | 37.738158246093 | -122.378538834904 | (37.738158246093, -122.378538834904) | ||
| 15479 | 15479 | 11521 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018533.508280001 | 2096747.4741099998 | 37.738307555143706 | -122.378412549408 | (37.7383075551437, -122.378412549408) | |||
| 14633 | 14633 | 11522 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018545.03968 | 2096763.4476400001 | 37.738352050906 | -122.37837378772801 | (37.738352050906, -122.378373787728) | |||
| 140492 | 140492 | 11523 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018517.10401 | 2096771.58701 | 37.7383728601739 | -122.378470941616 | (37.7383728601739, -122.378470941616) | |||
| 14283 | 14283 | 11524 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018572.85172 | 2096797.82035 | 37.7384479645089 | -122.378280011831 | (37.7384479645089, -122.378280011831) |
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");