trees
42 rows where qSpecies_id = 111 sorted by DBH
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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 | ||
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 | |||||
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 | |||
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 | |||
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 | ||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
488 | 20353 | DPW Maintained 1 | Acacia decurrens :: Acacia: Silver Wattle 111 | 262X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 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 | |||||||||||||
13765 | 20351 | DPW Maintained 1 | Acacia decurrens :: Acacia: Silver Wattle 111 | 262X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );