Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8235 | 8235 | 102182 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1824 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5x7 | 6003456.0858 | 2115079.5840000003 | 37.7878005119829 | -122.43185142562 | (37.7878005119829, -122.43185142562) | |||
16578 | 16578 | 22107 | DPW Maintained 3 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 3550 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6015967.58634 | 2099056.56935 | 37.744506090079 | -122.387445367011 | (37.744506090079, -122.387445367011) | |||
22847 | 22847 | 191749 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1625 Owen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014300.87385 | 2107548.11125 | 37.7677295863811 | -122.393802824746 | (37.7677295863811, -122.393802824746) | |||
26745 | 26745 | 191764 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014300.70844 | 2107474.67738 | 37.7675279439837 | -122.393798256194 | (37.7675279439837, -122.393798256194) | |||
27823 | 27823 | 191791 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014449.771240001 | 2109490.54971 | 37.7730713650891 | -122.39342375512501 | (37.7730713650891, -122.393423755125) | |||
28038 | 28038 | 224273 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1300 San Jose Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6003378.57618 | 2095536.0341299998 | 37.7341342224082 | -122.43072441129601 | (37.7341342224082, -122.430724411296) | ||||
31842 | 31842 | 191744 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1699 Owen St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014515.2981 | 2107319.9336200003 | 37.7671149743997 | -122.393045184606 | (37.7671149743997, -122.393045184606) | |||
32394 | 32394 | 191785 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6014578.31828 | 2109612.65593 | 37.7734137828497 | -122.39298763609399 | (37.7734137828497, -122.392987636094) | |||
32884 | 32884 | 224270 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1000 San Jose Ave | 99 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6004965.43171 | 2096836.50087 | 37.7377947878061 | -122.42533066077699 | (37.7377947878061, -122.425330660777) | ||||
35791 | 35791 | 191792 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6014433.644169999 | 2109472.38014 | 37.773020579462205 | -122.39347826930599 | (37.7730205794622, -122.393478269306) | |||
36827 | 36827 | 191783 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014612.48499 | 2109646.15421 | 37.7735076594811 | -122.392871791707 | (37.7735076594811, -122.392871791707) | |||
37927 | 37927 | 191786 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014558.79858 | 2109593.71449 | 37.773360689586 | -122.393053832481 | (37.773360689586, -122.393053832481) | |||
38495 | 38495 | 191765 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014318.27741 | 2107455.19183 | 37.767475417278796 | -122.39373612294901 | (37.7674754172788, -122.393736122949) | |||
42126 | 42126 | 191788 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014523.52915 | 2109561.3593900003 | 37.7732698904311 | -122.39317357090401 | (37.7732698904311, -122.393173570904) | |||
42162 | 42162 | 191769 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1700 Owen St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014406.5254 | 2107353.03478 | 37.7671998200381 | -122.393423732624 | (37.7671998200381, -122.393423732624) | |||
43010 | 43010 | 191781 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014648.08638 | 2109681.02435 | 37.773605382502296 | -122.392751080204 | (37.7736053825023, -122.392751080204) | |||
43426 | 43426 | 191782 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6014630.86236 | 2109664.2780299997 | 37.7735584441913 | -122.39280948936899 | (37.7735584441913, -122.392809489369) | |||
47370 | 47370 | 191787 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014542.42986 | 2109577.51132 | 37.7733152900047 | -122.39310932065099 | (37.7733152900047, -122.393109320651) | |||
50375 | 50375 | 191779 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014704.8611 | 2109733.12142 | 37.773751582593 | -122.39255833122 | (37.773751582593, -122.39255833122) | |||
50482 | 50482 | 191761 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014244.216019999 | 2107530.9753400004 | 37.767679386225 | -122.393997599031 | (37.767679386225, -122.393997599031) | |||
52811 | 52811 | 191759 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014180.67748 | 2107596.60783 | 37.7678560670335 | -122.39422196817101 | (37.7678560670335, -122.394221968171) | |||
58044 | 58044 | 191776 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014758.24285 | 2109784.44646 | 37.7738954741324 | -122.392377264405 | (37.7738954741324, -122.392377264405) | |||
59194 | 59194 | 191748 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1699 Owen St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014426.86102 | 2107413.78571 | 37.767367758551 | -122.39335764596599 | (37.767367758551, -122.393357645966) | |||
60068 | 60068 | 191751 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1625 Owen St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014208.40259 | 2107643.9572 | 37.7679876189722 | -122.39412938476102 | (37.7679876189722, -122.394129384761) | |||
62971 | 62971 | 224271 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1000 San Jose Ave | 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6005045.997 | 2096959.12957 | 37.73813604993279 | -122.425060830014 | (37.7381360499328, -122.425060830014) | ||||
63100 | 63100 | 191745 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1699 Owen St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014498.46709 | 2107339.22822 | 37.7671670181599 | -122.39310475118499 | (37.7671670181599, -122.393104751185) | |||
64029 | 64029 | 191754 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014095.94554 | 2107687.51362 | 37.768100964124606 | -122.394521414531 | (37.7681009641246, -122.394521414531) | |||
65684 | 65684 | 191774 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014898.64334 | 2109922.2864099997 | 37.7742817473506 | -122.391901232578 | (37.7742817473506, -122.391901232578) | |||
66947 | 66947 | 191773 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1700 Owen St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014495.64641 | 2107253.89984 | 37.7669325685033 | -122.393108536438 | (37.7669325685033, -122.393108536438) | |||
68777 | 68777 | 191770 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1700 Owen St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014421.9927900005 | 2107332.46349 | 37.7671441951686 | -122.393368793037 | (37.7671441951686, -122.393368793037) | |||
68944 | 68944 | 137899 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1826 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003438.8883 | 2115172.4505 | 37.7880545249544 | -122.431917559394 | (37.7880545249544, -122.431917559394) | |||
70485 | 70485 | 191755 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014113.52931 | 2107668.7730799997 | 37.7680504842614 | -122.394459281275 | (37.7680504842614, -122.394459281275) | |||
71646 | 71646 | 191756 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014131.117869999 | 2107650.2807299998 | 37.7680006861063 | -122.394397148916 | (37.7680006861063, -122.394397148916) | |||
130024 | 130024 | 191790 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014469.3027 | 2109510.05157 | 37.7731259980049 | -122.393357557806 | (37.7731259980049, -122.393357557806) | |||
133384 | 133384 | 191775 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014793.011390001 | 2109819.89403 | 37.7739947358896 | -122.392259473006 | (37.7739947358896, -122.392259473006) | |||
134422 | 134422 | 191789 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014504.606000001 | 2109544.0871200003 | 37.7732214133716 | -122.393237820291 | (37.7732214133716, -122.393237820291) | |||
135366 | 135366 | 217818 | DPW Maintained 3 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1x Junipero Serra Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 5991630.64581 | 2095733.14753 | 37.7340028647425 | -122.471354673377 | (37.7340028647425, -122.471354673377) | ||||
135736 | 135736 | 191784 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014596.0879999995 | 2109628.5504099997 | 37.7734584125988 | -122.392927279876 | (37.7734584125988, -122.392927279876) | |||
137492 | 137492 | 191771 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1700 Owen St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014456.78592 | 2107294.74285 | 37.7670425555978 | -122.39324580804899 | (37.7670425555978, -122.393245808049) | |||
137580 | 137580 | 191757 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014146.70674 | 2107631.58061 | 37.76795020627 | -122.394341918847 | (37.76795020627, -122.394341918847) | |||
137626 | 137626 | 224272 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1000 San Jose Ave | 118 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005007.01889 | 2096875.50161 | 37.737904224505 | -122.425189647979 | (37.737904224505, -122.425189647979) | ||||
137664 | 137664 | 191750 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1625 Owen St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014226.3037 | 2107625.43664 | 37.767937760555604 | -122.394066169617 | (37.7679377605556, -122.394066169617) | |||
138015 | 138015 | 191743 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1699 Owen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014558.8773300005 | 2107278.73682 | 37.7670042777465 | -122.39289156688999 | (37.7670042777465, -122.39289156689) | |||
151103 | 151103 | 224274 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1300 San Jose Ave | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6003341.2882900005 | 2095541.9984900001 | 37.734148486561395 | -122.430853752702 | (37.7341484865614, -122.430853752702) | ||||
155789 | 155789 | 32014 | Permitted Site 1 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 466 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 7 | Permit Number 45606 | 5984414.61405 | 2112665.59366 | 37.7800745778358 | -122.49755204346901 | (37.7800745778358, -122.497552043469) | |
157760 | 157760 | 224275 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1300 San Jose Ave | 53 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6003325.50221 | 2095516.5443799999 | 37.734077700922896 | -122.43090651413999 | (37.7340777009229, -122.43090651414) | ||||
159979 | 159979 | 191766 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1700 Owen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014354.18326 | 2107417.19862 | 37.7673730915094 | -122.39360926905701 | (37.7673730915094, -122.393609269057) | |||
160104 | 160104 | 191760 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014227.64463 | 2107550.44075 | 37.7677319129348 | -122.394056280688 | (37.7677319129348, -122.394056280688) | |||
161036 | 161036 | 191778 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6014723.1873699995 | 2109748.72437 | 37.773795442550295 | -122.392496028863 | (37.7737954425503, -122.392496028863) | |||
166451 | 166451 | 191777 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014740.46792 | 2109768.2716099997 | 37.7738500745454 | -122.392437619717 | (37.7738500745454, -122.392437619717) | |||
168291 | 168291 | 191793 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014414.77166 | 2109457.6288799997 | 37.772979027179396 | -122.39354251957701 | (37.7729790271794, -122.393542519577) | |||
168743 | 168743 | 191768 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1700 Owen St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014388.9965 | 2107374.50723 | 37.7672578047264 | -122.39348586588801 | (37.7672578047264, -122.393485865888) | |||
169072 | 169072 | 191780 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014685.91527 | 2109714.7286799997 | 37.7737000280525 | -122.39262258148399 | (37.7737000280525, -122.392622581484) | |||
169142 | 169142 | 191741 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 301 Mendell St | 7 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6016911.13187 | 2097912.78393 | 37.7414177012714 | -122.38410311127 | (37.7414177012714, -122.38410311127) | |||
174518 | 174518 | 191763 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014281.36362 | 2107492.70863 | 37.7675763787784 | -122.393866430199 | (37.7675763787784, -122.393866430199) | |||
176063 | 176063 | 191753 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1625 Owen St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014169.77832 | 2107683.74351 | 37.7680947165235 | -122.39426576877399 | (37.7680947165235, -122.394265768774) | |||
176304 | 176304 | 140644 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 51 SHRADER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997268.3746 | 2110231.7749 | 37.774136991388104 | -122.452909578762 | (37.7741369913881, -122.452909578762) | |||
176694 | 176694 | 191767 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1700 Owen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014372.20079 | 2107395.2194 | 37.7673137425589 | -122.393545410014 | (37.7673137425589, -122.393545410014) | |||
177702 | 177702 | 191746 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1699 Owen St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014483.07335 | 2107354.88341 | 37.767209148715 | -122.393159091815 | (37.767209148715, -122.393159091815) | |||
179444 | 179444 | 191742 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1699 Owen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014584.87581 | 2107249.6291099996 | 37.766925798418896 | -122.392799604924 | (37.7669257984189, -122.392799604924) | |||
180631 | 180631 | 191758 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014164.005890001 | 2107611.1066900003 | 37.7678949510119 | -122.39428064894 | (37.7678949510119, -122.39428064894) | |||
180757 | 180757 | 191762 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1650 Owen St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014265.24091 | 2107509.68062 | 37.767622084109 | -122.39392338518101 | (37.767622084109, -122.393923385181) | |||
181859 | 181859 | 191747 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1699 Owen St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014448.72859 | 2107389.57546 | 37.767302497441705 | -122.39328031414401 | (37.7673024974417, -122.393280314144) | |||
184923 | 184923 | 191772 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1700 Owen St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014477.54447 | 2107273.40031 | 37.7669851069029 | -122.39317251330401 | (37.7669851069029, -122.393172513304) | |||
186909 | 186909 | 191752 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1625 Owen St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014185.50439 | 2107669.58575 | 37.7680567165689 | -122.394210382216 | (37.7680567165689, -122.394210382216) |
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");