Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
1070 | 1070 | 19942 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
3884 | 3884 | 20320 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
6027 | 6027 | 20016 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
6772 | 6772 | 20314 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
7805 | 7805 | 19939 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
7960 | 7960 | 23202 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006708.88776 | 2112470.99571 | 37.7808218241176 | -122.420412091366 | (37.7808218241176, -122.420412091366) | |||
8002 | 8002 | 19938 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
8496 | 8496 | 20017 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY48 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
8841 | 8841 | 23183 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006719.9876 | 2112427.32903 | 37.780702551515496 | -122.42037059124901 | (37.7807025515155, -122.420370591249) | ||
10119 | 10119 | 173856 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 118 Saint Mary's Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
12003 | 12003 | 20316 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
12342 | 12342 | 24268 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 350X Winding Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001111.916180001 | 2086587.12369 | 37.7094338594537 | -122.437920185566 | (37.7094338594537, -122.437920185566) | |||
12367 | 12367 | 24267 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 350X Winding Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6001124.44895 | 2086586.86413 | 37.7094338594468 | -122.43787685174401 | (37.7094338594468, -122.437876851744) | |||
14348 | 14348 | 19941 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
14547 | 14547 | 19940 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100 STAIRWAY38 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 10ST | ||||||||
16276 | 16276 | 20315 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
17047 | 17047 | 20318 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
17109 | 17109 | 20319 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 101X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
18271 | 18271 | 28138 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 418 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X5 | 6006975.957669999 | 2097881.62293 | 37.7407778444163 | -122.41845336792801 | (37.7407778444163, -122.418453367928) | |||
19068 | 19068 | 26911 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 10 Caine Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997609.86555 | 2089654.4499099997 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | |||
19139 | 19139 | 29600 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991176.92289 | 2091079.14193 | 37.7211978713578 | -122.472584119478 | (37.7211978713578, -122.472584119478) | ||
20653 | 20653 | 2618 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
28512 | 28512 | 176338 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | |||
38393 | 38393 | 176339 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | |||
43329 | 43329 | 111546 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 24 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 15 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
44177 | 44177 | 113502 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x MANSELL ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6011136.0 | 2090597.0 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | |||
44888 | 44888 | 176341 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | |||
47690 | 47690 | 176337 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 59 | Width 0ft | 6011478.9031 | 2090656.6645400003 | 37.72119208331829 | -122.40237590353901 | (37.7211920833183, -122.402375903539) | |||
55507 | 55507 | 191724 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 6011608.5229400005 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | ||||
71413 | 71413 | 113506 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 39 | 3x3 | 6011135.08211 | 2090555.5358799999 | 37.7208952054249 | -122.40355728893199 | (37.7208952054249, -122.403557288932) | |||
78801 | 78801 | 2617 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
79476 | 79476 | 116530 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 745X SANCHEZ ST | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
80756 | 80756 | 2614 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
85741 | 85741 | 114041 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
87799 | 87799 | 13410 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 364 Marietta Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
88008 | 88008 | 111551 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 29 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 27 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
90640 | 90640 | 114042 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
92343 | 92343 | 113367 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 6X Christopher Dr | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 25 | 5996701.11551 | 2103988.82524 | 37.7569629284433 | -122.454420756361 | (37.7569629284433, -122.454420756361) | ||||
92885 | 92885 | 111536 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 14 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
99315 | 99315 | 3751 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 990 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.756077292734105 | -122.399959384248 | (37.7560772927341, -122.399959384248) | |||
100681 | 100681 | 111529 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
101800 | 101800 | 114043 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
102861 | 102861 | 112189 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 301x CORBETT AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 12 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | |||
102874 | 102874 | 111513 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 800x BOSWORTH ST | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 16 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
102986 | 102986 | 112188 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 301x CORBETT AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 45 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | |||
106180 | 106180 | 106794 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
109383 | 109383 | 106792 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
111260 | 111260 | 111511 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 800x BOSWORTH ST | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | |||||
112606 | 112606 | 105901 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
113760 | 113760 | 106810 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 3500X MISSION ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
116419 | 116419 | 2615 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
117576 | 117576 | 111525 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 26 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
120548 | 120548 | 111538 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 16 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 28 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
122561 | 122561 | 105900 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
123394 | 123394 | 114040 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | |||
126390 | 126390 | 2619 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 10X10 | 6004877.75733 | 2115027.26874 | 37.7877373561683 | -122.42692897924101 | (37.7877373561683, -122.426928979241) | |||
127427 | 127427 | 106795 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 199X ARLINGTON ST | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
138324 | 138324 | 2616 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) | |||
138343 | 138343 | 105902 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 40 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
139032 | 139032 | 30154 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 410X Mansell St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
141204 | 141204 | 111548 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 26 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
144679 | 144679 | 106811 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 3500X MISSION ST | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
149487 | 149487 | 208977 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 300x Marietta Dr | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 5ft | 5999505.82373 | 2097502.74743 | 37.7393141797969 | -122.44425497048401 | (37.7393141797969, -122.444254970484) | |||
153783 | 153783 | 191723 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x Carolina St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6012476.48508 | 2103328.88343 | 37.7560429683291 | -122.39981689974701 | (37.7560429683291, -122.399816899747) | ||||
165255 | 165255 | 224249 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x 27th St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | Width 4ft | 6002852.0087 | 2100065.56768 | 37.7465414276517 | -122.432868400457 | (37.7465414276517, -122.432868400457) | |||
168122 | 168122 | 169607 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 118 Saint Mary's Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 0 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | |||
173688 | 173688 | 191721 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 1150x Tennessee St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6015559.12531 | 2103608.85918 | 37.75698309171089 | -122.389175557402 | (37.7569830917109, -122.389175557402) | ||||
178271 | 178271 | 176340 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011135.84107 | 2090535.2556900003 | 37.720839562571996 | -122.403553239308 | (37.720839562572, -122.403553239308) | |||
180599 | 180599 | 191725 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 46 | 6011608.2265 | 2103816.01851 | 37.75733209161471 | -122.40285390399201 | (37.7573320916147, -122.402853903992) |
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");