Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
791 | 791 | 191798 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 3 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 6 | Width 3ft | Permit Number 774049 | 6018546.987380001 | 2097184.73725 | 37.7395089360924 | -122.378396294176 | (37.7395089360924, -122.378396294176) | |
827 | 827 | 191800 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2 Newhall St | 5 | : 4 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 19 | Width 4ft | Permit Number 774049 | 6018580.4534 | 2097158.49779 | 37.739438732322704 | -122.37827876085301 | (37.7394387323227, -122.378278760853) | |
874 | 874 | 19854 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 100 STAIRWAY29 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 100ST | ||||||||
3248 | 3248 | 23887 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1750X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003189.5886 | 2113919.6305 | 37.784600462473 | -122.432690563632 | (37.784600462473, -122.432690563632) | |||
5019 | 5019 | 23410 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006148.01248 | 2116523.4539799998 | 37.7919172512266 | -122.422640495371 | (37.7919172512266, -122.422640495371) | |||
5869 | 5869 | 19852 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 100 STAIRWAY29 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
6066 | 6066 | 23885 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1750X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003231.6817 | 2113926.6459999997 | 37.7846221123784 | -122.432545437068 | (37.7846221123784, -122.432545437068) | |||
6122 | 6122 | 23406 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006168.03383 | 2116381.79756 | 37.7915294275986 | -122.42256115088499 | (37.7915294275986, -122.422561150885) | |||
6402 | 6402 | 23443 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6005986.240069999 | 2117685.53144 | 37.7950988961632 | -122.423282873032 | (37.7950988961632, -122.423282873032) | |||
8382 | 8382 | 23409 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1748X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006150.92127 | 2116485.89798 | 37.7918142959375 | -122.42262776096202 | (37.7918142959375, -122.422627760962) | |||
10541 | 10541 | 1813 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2082 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/13/1991 12:00:00 AM | 12 | 3X3 | 6012099.01215 | 2087998.4540799998 | 37.713927769919 | -122.400045768207 | (37.713927769919, -122.400045768207) | ||
17115 | 17115 | 19795 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 100 STAIRWAY20 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
18557 | 18557 | 12099 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1281X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1992 12:00:00 AM | 24 | 3X3 | 6017033.141005999 | 2094557.4754692002 | 37.732211440602605 | -122.383447721977 | (37.7322114406026, -122.383447721977) | ||
19280 | 19280 | 1843 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2200 Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011383.0146015 | 2087402.1416029998 | 37.712250468957 | -122.40247863283399 | (37.712250468957, -122.402478632834) | |||
23139 | 23139 | 19365 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 500X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5993863.684719999 | 2114886.5972700003 | 37.7867221812625 | -122.46502504683998 | (37.7867221812625, -122.46502504684) | |||
23322 | 23322 | 23886 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1750X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6003218.9262 | 2113924.0949 | 37.784614384352004 | -122.432589384494 | (37.784614384352, -122.432589384494) | |||
72210 | 72210 | 16475 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
77351 | 77351 | 12094 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1261X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
83001 | 83001 | 8296 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 18 Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016769.107068701 | 2094699.6972286 | 37.7325873571063 | -122.384370457364 | (37.7325873571063, -122.384370457364) | |||
84644 | 84644 | 8439 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1720X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003193.61701 | 2113921.75435 | 37.7846065224894 | -122.43267677846599 | (37.7846065224894, -122.432676778466) | |||
84693 | 84693 | 1816 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012027.2003656 | 2087907.9406618 | 37.7136752340099 | -122.400287624748 | (37.7136752340099, -122.400287624748) | |||
85616 | 85616 | 1762 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2000X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 3x3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
86584 | 86584 | 16461 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
86585 | 86585 | 1862 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2510 Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010780.8257042 | 2086709.3373148 | 37.710314531205896 | -122.404511250175 | (37.7103145312059, -122.404511250175) | |||
87252 | 87252 | 1861 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2510 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6 | 6010780.8257042 | 2086709.3373148 | 37.710314531205896 | -122.404511250175 | (37.7103145312059, -122.404511250175) | |||
87452 | 87452 | 12105 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1281X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1992 12:00:00 AM | 18 | 3X3 | 6017033.141005999 | 2094557.4754692002 | 37.732211440602605 | -122.383447721977 | (37.7322114406026, -122.383447721977) | ||
87914 | 87914 | 1852 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2401 Bay Shore Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/23/1992 12:00:00 AM | 12 | 3X3 | 6011063.3259362 | 2087019.7277799998 | 37.7111825850692 | -122.403556689346 | (37.7111825850692, -122.403556689346) | ||
89329 | 89329 | 16462 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
93163 | 93163 | 12090 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1261X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
94981 | 94981 | 15024 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 845 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/1992 12:00:00 AM | 17 | 3X3 | 6015971.14204 | 2096622.00458 | 37.7378214697096 | -122.387263283018 | (37.7378214697096, -122.387263283018) | ||
97437 | 97437 | 1826 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2138 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1991 12:00:00 AM | 12 | 3x3 | 6011843.4146873 | 2087682.3291292998 | 37.713045499820794 | -122.400907017094 | (37.7130454998208, -122.400907017094) | ||
97946 | 97946 | 16466 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018746.801501201 | 2097101.6577332001 | 37.739291827880294 | -122.37769965200899 | (37.7392918278803, -122.377699652009) | |||
98048 | 98048 | 24204 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 80X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/1991 12:00:00 AM | 30 | 3x3 | 6016946.00997 | 2094945.60902 | 37.73327236236629 | -122.383775970862 | (37.7332723623663, -122.383775970862) | ||
102500 | 102500 | 3793 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 75 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017167.2819088 | 2095817.4840533 | 37.7356785868328 | -122.38307162670601 | (37.7356785868328, -122.383071626706) | |||
106392 | 106392 | 8302 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 25 Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016780.483136799 | 2094683.2530579 | 37.732542833716 | -122.38432998229099 | (37.732542833716, -122.384329982291) | |||
111168 | 111168 | 22108 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3550 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015960.65745 | 2099048.08294 | 37.744482404383895 | -122.387468734005 | (37.7444824043839, -122.387468734005) | |||
111671 | 111671 | 109907 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1415 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/2015 10:12:00 AM | 9 | 4x4 | 6008287.6 | 2109783.3 | 37.773530888410896 | -122.414760273118 | (37.7735308884109, -122.414760273118) | ||
113390 | 113390 | 117085 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1415 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6008287.6 | 2109783.3 | 37.773530888410896 | -122.414760273118 | (37.7735308884109, -122.414760273118) | |||
113964 | 113964 | 8305 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 29 Garlington Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016787.0658034 | 2094691.4882738998 | 37.732565809963106 | -122.384307797551 | (37.7325658099631, -122.384307797551) | |||
115131 | 115131 | 16473 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
117123 | 117123 | 12636 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 901 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5992666.273990001 | 2114790.8903900003 | 37.7863902797856 | -122.46916079788099 | (37.7863902797856, -122.469160797881) | |||
119232 | 119232 | 6465 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1200X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:16:00 PM | 3 | 3X3 | 6017709.266009999 | 2097062.52601 | 37.739127157777205 | -122.38128430413201 | (37.7391271577772, -122.381284304132) | ||
122570 | 122570 | 22179 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3955X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/1992 12:00:00 AM | 12 | 3X3 | 6015698.56805 | 2097858.21385 | 37.741200749075105 | -122.38829196576599 | (37.7412007490751, -122.388291965766) | ||
123955 | 123955 | 8438 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1720X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6003216.05015 | 2113926.93493 | 37.7846220192585 | -122.432599537586 | (37.7846220192585, -122.432599537586) | |||
125100 | 125100 | 1818 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2100 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6012027.2003656 | 2087907.9406618 | 37.7136752340099 | -122.400287624748 | (37.7136752340099, -122.400287624748) | ||
125721 | 125721 | 12093 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1261X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
127141 | 127141 | 1761 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2000X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/1991 12:00:00 AM | 18 | 3x3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
127345 | 127345 | 28139 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 525X EUGENIA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6007058.0 | 2097880.0 | 37.740778006453795 | -122.418169580752 | (37.7407780064538, -122.418169580752) | |||
127449 | 127449 | 10848 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1139X Hudson Ave | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018102.76401 | 2094614.84701 | 37.7324280296634 | -122.379753739799 | (37.7324280296634, -122.379753739799) | |||
129279 | 129279 | 21837 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 201 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2015 12:00:00 AM | 3 | 3X3 | 5994816.5533 | 2114874.05731 | 37.786742647269705 | -122.46172746258699 | (37.7867426472697, -122.461727462587) | ||
139000 | 139000 | 1768 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2000X Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/1991 12:00:00 AM | 24 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
139020 | 139020 | 1856 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2500 Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010837.5147418 | 2086759.4488696998 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | |||
139770 | 139770 | 8304 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 29 Garlington Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016787.0658034 | 2094691.4882738998 | 37.732565809963106 | -122.384307797551 | (37.7325658099631, -122.384307797551) | |||
140227 | 140227 | 16472 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 9X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018697.204870099 | 2097076.1109207 | 37.73921894851821 | -122.37786936428301 | (37.7392189485182, -122.377869364283) | |||
140266 | 140266 | 12081 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 1261X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1992 12:00:00 AM | 18 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | ||
143575 | 143575 | 1765 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 2000X Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/1991 12:00:00 AM | 36 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
143986 | 143986 | 12622 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 814 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 140 | 3X3 | 5992940.7068300005 | 2114858.78084 | 37.786592541866796 | -122.468216278652 | (37.7865925418668, -122.468216278652) | |||
146005 | 146005 | 191802 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 180x Bay Shore Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6011170.05761 | 2099578.4094700003 | 37.745672070114395 | -122.404071054532 | (37.7456720701144, -122.404071054532) | ||||
157873 | 157873 | 191803 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 180x Bay Shore Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6011162.1503800005 | 2099563.42906 | 37.7456304953456 | -122.404097342621 | (37.7456304953456, -122.404097342621) |
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");