trees
36 rows where Neighborhoods (old) = 41 and qSpecies_id = 35 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
150152 | 120624 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
40576 | 120625 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6004349 | 2113949 | 37.7847467885767 | -122.428681484586 | (37.7847467885767, -122.428681484586) | 13 | 9 | 11 | 29490 | 41 | |||||
1049 | 120626 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
156411 | 120627 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
436 | 120628 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
63063 | 139214 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 8 | Median : Cutout | Tree | DPW 1 | 29 | Width 0ft | 6004809.3749 | 2114055.503 | 37.7850652633568 | -122.427096327106 | (37.7850652633568, -122.427096327106) | 13 | 9 | 11 | 28858 | 41 | |||
177341 | 139329 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 3 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005196.3246 | 2114113.3931 | 37.7852460889347 | -122.425761723999 | (37.7852460889347, -122.425761723999) | 13 | 9 | 11 | 28858 | 41 | |||
65641 | 139330 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 4 | Median : Cutout | Tree | DPW 1 | 31 | Width 0ft | 6005126.2471 | 2114101.4827 | 37.7852094256692 | -122.426003322666 | (37.7852094256692, -122.426003322666) | 13 | 9 | 11 | 28858 | 41 | |||
110654 | 139356 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 5 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6005063.0942 | 2114090.4032 | 37.7851754347521 | -122.426221023287 | (37.7851754347521, -122.426221023287) | 13 | 9 | 11 | 28858 | 41 | |||
187582 | 139358 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 7 | Median : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6004934.0187 | 2114075.446 | 37.7851270694756 | -122.426666519258 | (37.7851270694756, -122.426666519258) | 13 | 9 | 11 | 28858 | 41 | |||
94670 | 139359 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1350x GEARY BLVD | 9 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6004685.2851 | 2114039.9918 | 37.7850156556233 | -122.427524533418 | (37.7850156556233, -122.427524533418) | 13 | 9 | 11 | 28858 | 41 | |||
127704 | 4530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004963.1338 | 2113665.364 | 37.7840027322121 | -122.426536579485 | (37.7840027322121, -122.426536579485) | 7 | 9 | 11 | 28858 | 41 | |
137065 | 4531 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6004996.2689 | 2113667.7308 | 37.7840111039908 | -122.426422112629 | (37.7840111039908, -122.426422112629) | 7 | 9 | 11 | 28858 | 41 | |
63272 | 4532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 45 Cleary Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3X3 | Permit Number 781999 | 6005027.0371 | 2113673.2533 | 37.784028006638 | -122.42631605912 | (37.784028006638, -122.42631605912) | 7 | 9 | 11 | 28858 | 41 | |
45559 | 8390 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004488.7034 | 2114010.5767 | 37.7849237683164 | -122.428202546761 | (37.7849237683164, -122.428202546761) | 13 | 9 | 11 | 29490 | 41 | |||
65698 | 8391 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004438.3798 | 2114005.2394 | 37.784906265949 | -122.428376269712 | (37.784906265949, -122.428376269712) | 13 | 9 | 11 | 29490 | 41 | |||
74880 | 8392 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004378.144 | 2113996.8521 | 37.7848798278423 | -122.428584068109 | (37.7848798278423, -122.428584068109) | 13 | 9 | 11 | 29490 | 41 | |||
54682 | 8393 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004320.9581 | 2113985.4149 | 37.7848451877241 | -122.428781097193 | (37.7848451877241, -122.428781097193) | 13 | 9 | 11 | 29490 | 41 | |||
97674 | 8394 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 36 | 8 | 6004234.0356 | 2113977.7901 | 37.784819331933 | -122.429081276927 | (37.784819331933, -122.429081276927) | 13 | 9 | 11 | 29490 | 41 | |||
73905 | 8395 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 06/09/1994 12:00:00 AM | 6 | 8 | 6004192.8617 | 2113973.9777 | 37.7848065332396 | -122.429223453232 | (37.7848065332396, -122.429223453232) | 13 | 9 | 11 | 29490 | 41 | ||
112575 | 8469 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 48 | 8 | 6002244.0904 | 2113695.2 | 37.7839305664786 | -122.435945599699 | (37.7839305664786, -122.435945599699) | 13 | 5 | 11 | 29490 | 41 | |||
38568 | 8471 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 06/03/1994 12:00:00 AM | 6 | 8 | 6002124.2891 | 2113678.9558 | 37.7838791576421 | -122.43635890448 | (37.7838791576421, -122.43635890448) | 13 | 5 | 11 | 29490 | 41 | ||
26940 | 8472 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6002074.2026 | 2113678.2789 | 37.7838744530021 | -122.436532136471 | (37.7838744530021, -122.436532136471) | 13 | 5 | 11 | 29490 | 41 | |||
110569 | 8474 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001879.2717 | 2113651.882 | 37.7837908949329 | -122.437204633286 | (37.7837908949329, -122.437204633286) | 13 | 5 | 11 | 29490 | 41 | |||
127126 | 8475 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1900 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 06/03/1994 12:00:00 AM | 6 | 8 | 6001831.8926 | 2113645.1136 | 37.7837696172579 | -122.437368062109 | (37.7837696172579, -122.437368062109) | 13 | 5 | 11 | 29490 | 41 | ||
183037 | 8530 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100X Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 15 | 6001630.1932 | 2113615.3325 | 37.7836763773468 | -122.438063730933 | (37.7836763773468, -122.438063730933) | 15 | 5 | 11 | 29490 | 41 | |||
126371 | 8532 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001535.4351 | 2113580.6442 | 37.7835757427727 | -122.438389071264 | (37.7835757427727, -122.438389071264) | 15 | 5 | 11 | 29490 | 41 | ||
122803 | 8535 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2100 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6001300.5704 | 2113502.1304 | 37.7833468021346 | -122.439195981768 | (37.7833468021346, -122.439195981768) | 15 | 5 | 11 | 29490 | 41 | |||
43150 | 8574 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | 6 | 6001134.4053 | 2113480.979 | 37.7832792690603 | -122.439769329053 | (37.7832792690603, -122.439769329053) | 15 | 5 | 11 | 29490 | 41 | |||
116060 | 8575 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001093.7947 | 2113474.2106 | 37.7832583731226 | -122.439909339764 | (37.7832583731226, -122.439909339764) | 15 | 5 | 11 | 29490 | 41 | |||
23996 | 8576 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | 15 | 5 | 11 | 29490 | 41 | |||
65234 | 8577 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 36 | 6 | 6000958.4259 | 2113453.9053 | 37.7831949132778 | -122.440376203878 | (37.7831949132778, -122.440376203878) | 15 | 5 | 11 | 29490 | 41 | |||
170733 | 8578 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6000905.6321 | 2113444.4294 | 37.7831658887746 | -122.440558168856 | (37.7831658887746, -122.440558168856) | 15 | 5 | 11 | 29490 | 41 | |||
101800 | 8581 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000715.1007 | 2113420.9091 | 37.7830904567466 | -122.441215640748 | (37.7830904567466, -122.441215640748) | 15 | 5 | 1 | 29490 | 41 | |||
186033 | 8582 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6000649.7853 | 2113412.1102 | 37.7830625764785 | -122.441440973241 | (37.7830625764785, -122.441440973241) | 15 | 5 | 1 | 29490 | 41 | |||
141624 | 8586 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 2200 Geary Blvd | 13 | Median : Cutout | Tree | DPW 1 | 24 | 6 | 6000400.7068 | 2113377.2527 | 37.7829526738098 | -122.442300177437 | (37.7829526738098, -122.442300177437) | 15 | 5 | 1 | 29490 | 41 |
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) );