trees
23 rows where qSpecies_id = 241 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104977 | 100229 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 701X 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778265 | 5983807.97543 | 2110975.72776 | 37.7753991192247 | -122.499525725678 | (37.7753991192247, -122.499525725678) | 11 | 6 | 2 | 55 | 26 | |
71375 | 181967 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 2423 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5986399.1816 | 2098739.8329 | 37.7419544119514 | -122.489662245235 | (37.7419544119514, -122.489662245235) | 1 | 8 | 3 | 29491 | 35 | |||
2694 | 184872 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1201 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984669.9453 | 2106823.2961 | 37.7640482591194 | -122.496237573009 | (37.7640482591194, -122.496237573009) | 1 | 8 | 3 | 56 | 35 | |||
27824 | 187974 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6013741.64285 | 2092638.14431 | 37.7267588832154 | -122.394692895458 | (37.7267588832154, -122.394692895458) | 10 | 3 | 8 | 58 | 1 | |||
126869 | 187975 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 6013720.25954 | 2092652.55253 | 37.7267972563783 | -122.394767826095 | (37.7267972563783, -122.394767826095) | 10 | 3 | 8 | 58 | 1 | |||
183034 | 187976 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 6013686.9099 | 2092676.67516 | 37.726861637932 | -122.394884804484 | (37.726861637932, -122.394884804484) | 10 | 3 | 8 | 58 | 1 | |||
177854 | 187977 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6013646.8498 | 2092708.23202 | 37.726946059107 | -122.395025501647 | (37.726946059107, -122.395025501647) | 10 | 3 | 8 | 58 | 1 | |||
108622 | 187978 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 5ft | 6013630.25148 | 2092720.21437 | 37.726978037202 | -122.395083721055 | (37.726978037202, -122.395083721055) | 10 | 3 | 8 | 58 | 1 | |||
36367 | 187979 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 5ft | 6013615.832 | 2092731.99702 | 37.7270095881002 | -122.395134394263 | (37.7270095881002, -122.395134394263) | 10 | 3 | 8 | 58 | 1 | |||
75896 | 187980 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 6013594.15592 | 2092747.34309 | 37.7270505198448 | -122.395210403156 | (37.7270505198448, -122.395210403156) | 10 | 3 | 8 | 58 | 1 | |||
106830 | 187981 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 5ft | 6013574.18197 | 2092762.03339 | 37.7270897455934 | -122.395280481931 | (37.7270897455934, -122.395280481931) | 10 | 3 | 8 | 58 | 1 | |||
48480 | 187982 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 6013557.45285 | 2092775.26074 | 37.7271251348046 | -122.395339240918 | (37.7271251348046, -122.395339240918) | 10 | 3 | 8 | 58 | 1 | |||
104586 | 187983 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 6013541.30669 | 2092786.45742 | 37.7271549806017 | -122.395395842461 | (37.7271549806017, -122.395395842461) | 10 | 3 | 8 | 58 | 1 | |||
86071 | 187984 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1740 Bancroft Ave | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 5ft | 6013523.18412 | 2092800.17844 | 37.7271916477681 | -122.395459453304 | (37.7271916477681, -122.395459453304) | 10 | 3 | 8 | 58 | 1 | |||
88928 | 200824 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 5300 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014267.0455 | 2093396.2046 | 37.7288695613347 | -122.392929593283 | (37.7288695613347, -122.392929593283) | 10 | 3 | 8 | 58 | 1 | |||
167600 | 200825 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 5300 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014263.6097 | 2093382.4616 | 37.7288316349873 | -122.392940510044 | (37.7288316349873, -122.392940510044) | 10 | 3 | 8 | 58 | 1 | |||
99287 | 200826 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 5300 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014262.4645 | 2093372.7269 | 37.7288048418563 | -122.392943788301 | (37.7288048418563, -122.392943788301) | 10 | 3 | 8 | 58 | 1 | |||
119799 | 200827 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 5300 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6014256.7382 | 2093362.9923 | 37.7287777945327 | -122.392962903849 | (37.7287777945327, -122.392962903849) | 10 | 3 | 8 | 58 | 1 | |||
91995 | 222008 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 22 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 6004062.61518 | 2108585.10305 | 37.7700026390277 | -122.429289661699 | (37.7700026390277, -122.429289661699) | 7 | 9 | 5 | 29492 | 10 | |||
152607 | 22359 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 5330X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1995 12:00:00 AM | 3 | 3X3 | 6014288.31752 | 2093466.43912 | 37.7290635926926 | -122.392860965574 | (37.7290635926926, -122.392860965574) | 10 | 3 | 8 | 58 | 1 | ||
142371 | 22360 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 5330X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6014288.31752 | 2093466.43912 | 37.7290635926926 | -122.392860965574 | (37.7290635926926, -122.392860965574) | 10 | 3 | 8 | 58 | 1 | |||
62123 | 22361 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 5330X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6014288.31752 | 2093466.43912 | 37.7290635926926 | -122.392860965574 | (37.7290635926926, -122.392860965574) | 10 | 3 | 8 | 58 | 1 | |||
7651 | 80467 | DPW Maintained 1 | Alnus cordata :: Italian Alder 241 | 1780 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6013451.73876 | 2092852.71308 | 37.7273319231299 | -122.395710120444 | (37.7273319231299, -122.395710120444) | 10 | 3 | 8 | 58 | 1 |
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) );