42 rows where qSpecies_id = 111 sorted by PlantType

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType ▼ qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
488 20353 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
695 20360 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
1216 20357 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
4713 20363 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
5086 20356 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
9843 20362 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
10860 20352 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
13505 20358 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
13765 20351 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 60                      
15186 20364 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
15977 20354 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
18122 20359 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
18295 20355 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
18336 20361 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 262X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 60                      
21986 99434 Undocumented 4 Acacia decurrens :: Acacia: Silver Wattle 111 244 Glenview Dr 2 Sidewalk: Curb side : Yard Tree Private 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
26536 220115 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 456 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5998557.4561 2106556.13282 37.7641184000685 -122.448185715597 (37.7641184000685, -122.448185715597) 15 5 11 29492 9
27051 201702 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 43 Gilroy St 2 Side Yard : Yard Tree Private 2     30 Width 0ft   6015209.27922 2088565.69519 37.7156582274311 -122.38933501442 (37.7156582274311, -122.38933501442) 10 3 8 58 1
29519 201703 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 43 Gilroy St 3 Side Yard : Yard Tree Private 2     39 Width 0ft   6015230.77883 2088581.00853 37.7157014668276 -122.389261770026 (37.7157014668276, -122.389261770026) 10 3 8 58 1
42617 220116 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 1294 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5997564.34231 2104932.51093 37.7596035209956 -122.451503472906 (37.7596035209956, -122.451503472906) 15 5 11 29492 12
47414 201704 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 42 Gilroy St 1 Side Yard : Yard Tree Private 2     34 Width 0ft   6015220.38125 2088614.28808 37.7157922695756 -122.389300031678 (37.7157922695756, -122.389300031678) 10 3 8 58 1
49477 203672 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 1650 18th Ave 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 4ft   5990615.48268 2104135.94174 37.7570159799128 -122.475477689069 (37.7570159799128, -122.475477689069) 1 8 4 56 12
55813 12921 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 1050 Lawton St 1 Median : Cutout Tree DPW 1     12 12   5990990.03726 2104515.89347 37.7580809319146 -122.474210073944 (37.7580809319146, -122.474210073944) 1 8 4 56 12
65607 12922 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 1050 Lawton St 2 Median : Cutout Tree DPW 1   02/04/2016 07:28:00 AM 3 12   5990985.67005 2104518.50205 37.7580878413873 -122.474225367817 (37.7580878413873, -122.474225367817) 1 8 4 56 12
69475 246629 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 3300 Harrison St 7 Side Yard : Yard Tree Private 2     11     6009040.22496 2099335.66052 37.7448863045706 -122.411418580397 (37.7448863045706, -122.411418580397) 2 7 7 28859 2
69827 201706 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 42 Gilroy St 4 Side Yard : Yard Tree Private 2     6 Width 0ft   6015220.50019 2088604.52214 37.7157654607945 -122.389298939006 (37.7157654607945, -122.389298939006) 10 3 8 58 1
72246 248084 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 15 Montcalm St 1 Side Yard : Yard Tree Private 2     9     6010670.84523 2100349.03377 37.7477601313264 -122.40585153954 (37.7477601313264, -122.40585153954) 2 7 7 28859 2
81713 109645 Undocumented 4 Acacia decurrens :: Acacia: Silver Wattle 111 999X PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001842 2109394 37.7720977038705 -122.437028639855 (37.7720977038705, -122.437028639855) 15 5 11 29492 9
86481 86925 Permitted Site 7 Acacia decurrens :: Acacia: Silver Wattle 111 746 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/08/2007 12:00:00 AM   3x3 Permit Number 49882 6012399 2104446 37.7591060051571 -122.400163324164 (37.7591060051571, -122.400163324164) 10 3 8 28856 29
95354 201701 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 43 Gilroy St 1 Side Yard : Yard Tree Private 2     23 Width 0ft   6015213.19192 2088555.85264 37.7156314186226 -122.389320803321 (37.7156314186226, -122.389320803321) 10 3 8 58 1
95907 12924 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 1050 Lawton St 4 Median : Cutout Tree DPW 1   03/01/2016 02:10:00 PM 3 12   5990975.53972 2104517.45741 37.7580843862142 -122.474260326262 (37.7580843862142, -122.474260326262) 1 8 4 56 12
96827 201705 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 42 Gilroy St 2 Side Yard : Yard Tree Private 2     7 Width 0ft   6015223.65534 2088604.14368 37.7157645965377 -122.389288006849 (37.7157645965377, -122.389288006849) 10 3 8 58 1
96896 92794 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 999 Wisconsin St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2009 12:00:00 AM 3   Permit Number 52022 6012812.69075 2102940.3148 37.7549947806047 -122.398626914107 (37.7549947806047, -122.398626914107) 10 3 8 28856 29
99232 188540 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 701 Terry A Francois Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     9     6016727.21777 2107625.64787 37.7680770223524 -122.385415722176 (37.7680770223524, -122.385415722176) 14 3 9 310 20
109301 247847 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 149 Chapman St 2 Side Yard : Yard Tree Private 2     19     6009164.82997 2098210.04366 37.7418025958088 -122.410908232241 (37.7418025958088, -122.410908232241) 10 7 7 28859 2
115743 99435 Undocumented 4 Acacia decurrens :: Acacia: Silver Wattle 111 244 Glenview Dr 3 Sidewalk: Curb side : Yard Tree Private 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
116263 86926 Permitted Site 7 Acacia decurrens :: Acacia: Silver Wattle 111 746 Carolina St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/08/2007 12:00:00 AM   3x3 Permit Number 49882 6012399 2104446 37.7591060051571 -122.400163324164 (37.7591060051571, -122.400163324164) 10 3 8 28856 29
120627 100045 Property Tree 8 Acacia decurrens :: Acacia: Silver Wattle 111 556 28th St   Front Yard : Yard Tree Private 2         Not sure which property tree is located on. 6002301 2099461 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
125673 201707 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 42 Gilroy St 3 Side Yard : Yard Tree Private 2     15 Width 0ft   6015219.60254 2088607.05992 37.7157723792799 -122.389302218834 (37.7157723792799, -122.389302218834) 10 3 8 58 1
127458 247845 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 151 Chapman St 3 Side Yard : Yard Tree Private 2     17     6009128.63652 2098211.49028 37.7418045383421 -122.41103347993 (37.7418045383421, -122.41103347993) 10 7 7 28859 2
167794 12923 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 1050 Lawton St 3 Median : Cutout Tree DPW 1     7 12   5990980.55181 2104515.4644 37.7580792042973 -122.474242847056 (37.7580792042973, -122.474242847056) 1 8 4 56 12
175237 12925 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 1050 Lawton St 5 Median : Cutout Tree DPW 1     18 12   5990970.42148 2104514.41976 37.7580757491191 -122.474277805496 (37.7580757491191, -122.474277805496) 1 8 4 56 12
192908 220114 DPW Maintained 1 Acacia decurrens :: Acacia: Silver Wattle 111 130 Belgrave Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5997929.61055 2104920.40859 37.7595912011862 -122.450239326508 (37.7595912011862, -122.450239326508) 15 5 11 29492 12

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);