trees
44 rows where Fire Prevention Districts = 9 and qSpecies_id = 98 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3551 | 215779 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6000598.87988 | 2095863.84134 | 37.7348764283969 | -122.440358172117 | (37.7348764283969, -122.440358172117) | 9 | 7 | 4 | 63 | 40 | |||
29909 | 215762 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000558.90016 | 2095877.84663 | 37.7349126072133 | -122.44049739976 | (37.7349126072133, -122.44049739976) | 9 | 7 | 4 | 63 | 40 | |||
111330 | 215774 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6000585.93673 | 2095868.50192 | 37.7348884882982 | -122.440403255128 | (37.7348884882982, -122.440403255128) | 9 | 7 | 4 | 63 | 40 | |||
127590 | 215766 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000570.32165 | 2095873.79044 | 37.7349021202175 | -122.440457620949 | (37.7349021202175, -122.440457620949) | 9 | 7 | 4 | 63 | 40 | |||
187844 | 215761 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000556.80733 | 2095878.65384 | 37.7349147044535 | -122.440504693264 | (37.7349147044535, -122.440504693264) | 9 | 7 | 4 | 63 | 40 | |||
15363 | 215748 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6000478.91076 | 2095913.68731 | 37.735006462271 | -122.440776520524 | (37.735006462271, -122.440776520524) | 9 | 7 | 4 | 63 | 40 | |||
100570 | 215753 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000483.505 | 2095904.04385 | 37.7349802452242 | -122.44075994513 | (37.7349802452242, -122.44075994513) | 9 | 7 | 4 | 63 | 40 | ||||
159424 | 215750 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000479.78996 | 2095909.84974 | 37.7349959752708 | -122.440773205638 | (37.7349959752708, -122.440773205638) | 9 | 7 | 4 | 63 | 40 | ||||
180414 | 215756 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000507.98466 | 2095900.86283 | 37.734972904964 | -122.440675082413 | (37.734972904964, -122.440675082413) | 9 | 7 | 4 | 63 | 40 | ||||
379 | 215760 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6000555.25402 | 2095877.7313 | 37.734912082925 | -122.440509997443 | (37.734912082925, -122.440509997443) | 9 | 7 | 4 | 63 | 40 | |||
23654 | 215747 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6000485.16891 | 2095910.31103 | 37.7349975481954 | -122.440754641828 | (37.7349975481954, -122.440754641828) | 9 | 7 | 4 | 63 | 40 | |||
84181 | 215743 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 6000467.1026 | 2095936.08344 | 37.7350672843273 | -122.440818951457 | (37.7350672843273, -122.440818951457) | 9 | 7 | 4 | 63 | 40 | |||
158737 | 215752 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6000481.62782 | 2095905.99262 | 37.7349854891864 | -122.440766574932 | (37.7349854891864, -122.440766574932) | 9 | 7 | 4 | 63 | 40 | ||||
6042 | 215755 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6000505.95284 | 2095895.64385 | 37.7349584591572 | -122.440681732884 | (37.7349584591572, -122.440681732884) | 9 | 7 | 4 | 63 | 40 | ||||
4859 | 215767 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6000573.18125 | 2095872.96734 | 37.7349000230045 | -122.440447675323 | (37.7349000230045, -122.440447675323) | 9 | 7 | 4 | 63 | 40 | |||
9841 | 215746 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6000474.8444 | 2095921.02809 | 37.7350263867572 | -122.440791105741 | (37.7350263867572, -122.440791105741) | 9 | 7 | 4 | 63 | 40 | |||
38151 | 29911 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 810x Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
83882 | 29912 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 810 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
28820 | 215776 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6000590.33355 | 2095867.8379 | 37.7348869154046 | -122.440388006217 | (37.7348869154046, -122.440388006217) | 9 | 7 | 4 | 63 | 40 | |||
64170 | 215773 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6000584.07141 | 2095871.02296 | 37.7348953042758 | -122.440409884922 | (37.7348953042758, -122.440409884922) | 9 | 7 | 4 | 63 | 40 | |||
133957 | 215770 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6000577.40993 | 2095873.4525 | 37.7349015959229 | -122.440433090118 | (37.7349015959229, -122.440433090118) | 9 | 7 | 4 | 63 | 40 | |||
181428 | 215765 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6000567.86167 | 2095875.36939 | 37.7349063155722 | -122.440466239146 | (37.7349063155722, -122.440466239146) | 9 | 7 | 4 | 63 | 40 | |||
59560 | 180594 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 222 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 2ft | 6006226.36725 | 2093441.03912 | 37.7285427577377 | -122.420730007995 | (37.7285427577377, -122.420730007995) | 9 | 7 | 7 | 309 | 5 | |||
48866 | 29913 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 810 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
186093 | 215771 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 8ft | 6000578.22769 | 2095871.70651 | 37.734896848405 | -122.440430137662 | (37.734896848405, -122.440430137662) | 9 | 7 | 4 | 63 | 40 | |||
22845 | 215763 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000560.6488 | 2095878.95607 | 37.7349157530474 | -122.440491433659 | (37.7349157530474, -122.440491433659) | 9 | 7 | 4 | 63 | 40 | |||
108492 | 215769 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000576.07621 | 2095873.86239 | 37.7349026454429 | -122.440437730631 | (37.7349026454429, -122.440437730631) | 9 | 7 | 4 | 63 | 40 | |||
167056 | 215745 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 10ft | 6000472.43959 | 2095925.27887 | 37.7350379214503 | -122.440799724826 | (37.7350379214503, -122.440799724826) | 9 | 7 | 4 | 63 | 40 | |||
181225 | 215757 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6000510.50193 | 2095892.79039 | 37.73495088328 | -122.44066580051 | (37.73495088328, -122.44066580051) | 9 | 7 | 4 | 63 | 40 | ||||
77716 | 215768 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6000574.55456 | 2095874.46679 | 37.7349042183411 | -122.440443034827 | (37.7349042183411, -122.440443034827) | 9 | 7 | 4 | 63 | 40 | |||
34047 | 215741 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000462.15679 | 2095947.26146 | 37.735097694886 | -122.440836852437 | (37.735097694886, -122.440836852437) | 9 | 7 | 4 | 63 | 40 | |||
101031 | 215764 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6000563.68419 | 2095877.36552 | 37.7349115586084 | -122.440480825239 | (37.7349115586084, -122.440480825239) | 9 | 7 | 4 | 63 | 40 | |||
121378 | 215754 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000486.86029 | 2095899.39146 | 37.7349676619301 | -122.440748011123 | (37.7349676619301, -122.440748011123) | 9 | 7 | 4 | 63 | 40 | ||||
145053 | 215759 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000518.68875 | 2095889.94729 | 37.7349435430019 | -122.440637292001 | (37.7349435430019, -122.440637292001) | 9 | 7 | 4 | 63 | 40 | ||||
27306 | 215749 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6000479.23488 | 2095910.81601 | 37.7349985968107 | -122.440775194031 | (37.7349985968107, -122.440775194031) | 9 | 7 | 4 | 63 | 40 | ||||
71110 | 215777 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6000591.54294 | 2095870.67707 | 37.7348947799641 | -122.440384028497 | (37.7348947799641, -122.440384028497) | 9 | 7 | 4 | 63 | 40 | |||
101485 | 215751 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6000480.34135 | 2095908.69261 | 37.7349928294638 | -122.440771216316 | (37.7349928294638, -122.440771216316) | 9 | 7 | 4 | 63 | 40 | ||||
127475 | 215740 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6000610.74849 | 2095862.83143 | 37.7348743311859 | -122.440317065893 | (37.7348743311859, -122.440317065893) | 9 | 7 | 4 | 63 | 40 | |||
138258 | 215758 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6000517.64958 | 2095895.31545 | 37.734958223539 | -122.440641269687 | (37.734958223539, -122.440641269687) | 9 | 7 | 4 | 63 | 40 | ||||
51388 | 215775 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6000589.79404 | 2095869.56764 | 37.734891634148 | -122.4403899955 | (37.734891634148, -122.4403899955) | 9 | 7 | 4 | 63 | 40 | |||
118250 | 215742 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000463.99438 | 2095943.40434 | 37.73508720879 | -122.440830222646 | (37.73508720879, -122.440830222646) | 9 | 7 | 4 | 63 | 40 | |||
4936 | 215744 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6000469.85899 | 2095930.29743 | 37.7350515542757 | -122.440809006739 | (37.7350515542757, -122.440809006739) | 9 | 7 | 4 | 63 | 40 | |||
125837 | 215772 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6000580.44136 | 2095871.67109 | 37.7348968771961 | -122.44042248171 | (37.7348968771961, -122.44042248171) | 9 | 7 | 4 | 63 | 40 | |||
76779 | 215778 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6000596.9829 | 2095864.83543 | 37.734879049926 | -122.440364801892 | (37.734879049926, -122.440364801892) | 9 | 7 | 4 | 63 | 40 |
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) );