trees
43 rows where Neighborhoods (old) = 12 and qSpecies_id = 133
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7001 | 225622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 67 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997067.03037 | 2106173.30325 | 37.7629819312842 | -122.453312997018 | (37.7629819312842, -122.453312997018) | 15 | 5 | 11 | 29492 | 12 | |||
11337 | 206619 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 181 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994070.38957 | 2104649.56309 | 37.7586259201623 | -122.463566678468 | (37.7586259201623, -122.463566678468) | 1 | 5 | 4 | 56 | 12 | |||
14448 | 206509 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.7579816107664 | -122.474384202485 | (37.7579816107664, -122.474384202485) | 1 | 8 | 4 | 56 | 12 | |||
22339 | 206516 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991047.26108 | 2104483.88717 | 37.7579963659448 | -122.474009836278 | (37.7579963659448, -122.474009836278) | 1 | 8 | 4 | 56 | 12 | |||
32203 | 206500 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993474.54652 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | 1 | 8 | 4 | 56 | 12 | |||
35595 | 206499 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993488.07663 | 2104571.64852 | 37.7583784177465 | -122.46557490416 | (37.7583784177465, -122.46557490416) | 1 | 8 | 4 | 56 | 12 | |||
43073 | 206510 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990951.63934 | 2104480.53076 | 37.7579816107816 | -122.474340288587 | (37.7579816107816, -122.474340288587) | 1 | 8 | 4 | 56 | 12 | |||
54867 | 206505 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993138.76599 | 2102124.24037 | 37.7516383146611 | -122.466605072187 | (37.7516383146611, -122.466605072187) | 1 | 8 | 4 | 29491 | 12 | |||
57352 | 68501 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1968 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32378 | 5993191.21227254 | 2102085.73019228 | 37.7515356020282 | -122.466420909066 | (37.7515356020282, -122.466420909066) | 1 | 8 | 4 | 29491 | 12 | ||
61980 | 206497 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1616 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5993722.38757 | 2104477.64501 | 37.7581338201448 | -122.464757733396 | (37.7581338201448, -122.464757733396) | 1 | 8 | 4 | 56 | 12 | |||
62155 | 206498 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | 1 | 8 | 4 | 56 | 12 | |||
62897 | 206623 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1964 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993824.3832 | 2102096.20379 | 37.7516008749812 | -122.464232103026 | (37.7516008749812, -122.464232103026) | 1 | 8 | 4 | 29491 | 12 | |||
63353 | 206511 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990966.24876 | 2104480.85465 | 37.7579833464788 | -122.474289787164 | (37.7579833464788, -122.474289787164) | 1 | 8 | 4 | 56 | 12 | |||
73036 | 206517 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991060.29058 | 2104484.56084 | 37.7579989703891 | -122.473964824336 | (37.7579989703891, -122.473964824336) | 1 | 8 | 4 | 56 | 12 | |||
74617 | 206562 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1478 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994313.38923 | 2105462.92602 | 37.7608732027602 | -122.462785287235 | (37.7608732027602, -122.462785287235) | 1 | 5 | 11 | 56 | 12 | |||
83897 | 206503 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1957 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993135.46016 | 2102179.05998 | 37.7517886444405 | -122.46662048837 | (37.7517886444405, -122.46662048837) | 1 | 8 | 4 | 29491 | 12 | |||
91240 | 51948 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48172 | 5996897.19536074 | 2106034.05471344 | 37.7625898542367 | -122.453890338129 | (37.7625898542367, -122.453890338129) | 15 | 5 | 11 | 29492 | 12 | ||||
98988 | 206622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1912 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993175.38418 | 2102417.55667 | 37.7524457988584 | -122.466499759777 | (37.7524457988584, -122.466499759777) | 1 | 8 | 4 | 29491 | 12 | |||
109592 | 60142 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1600 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1997 12:00:00 AM | Permit Number 19672 | 5990905.68098297 | 2104491.51831194 | 37.7580091169986 | -122.474500032297 | (37.7580091169986, -122.474500032297) | 1 | 8 | 4 | 56 | 12 | ||
114457 | 206501 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993462.44278 | 2104571.82213 | 37.7583774159051 | -122.465663569242 | (37.7583774159051, -122.465663569242) | 1 | 8 | 4 | 56 | 12 | |||
114669 | 206502 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993453.26762 | 2104570.92091 | 37.7583744121607 | -122.465695235269 | (37.7583744121607, -122.465695235269) | 1 | 8 | 4 | 56 | 12 | |||
115707 | 94159 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53536 | 5993712.5 | 2103021.2 | 37.754134227954 | -122.464686168912 | (37.754134227954, -122.464686168912) | 1 | 8 | 4 | 56 | 12 | ||
117905 | 206513 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990992.34085 | 2104483.78156 | 37.757992894562 | -122.47419976413 | (37.757992894562, -122.47419976413) | 1 | 8 | 4 | 56 | 12 | |||
119257 | 223030 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 125 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997950.67072 | 2104889.0935 | 37.7595064230002 | -122.450164233094 | (37.7595064230002, -122.450164233094) | 15 | 5 | 11 | 28862 | 12 | |||
126854 | 47123 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1818 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45108 | 5991595.47197715 | 2102975.75176021 | 37.7538871618551 | -122.472003987589 | (37.7538871618551, -122.472003987589) | 1 | 8 | 4 | 56 | 12 | ||
129309 | 206564 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.466502884014 | (37.7501303674196, -122.466502884014) | 1 | 8 | 4 | 29491 | 12 | |||
130434 | 206512 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990980.22345 | 2104481.19226 | 37.7579850830548 | -122.474241481884 | (37.7579850830548, -122.474241481884) | 1 | 8 | 4 | 56 | 12 | |||
134005 | 81908 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1601 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50503 | 5991112.7626616 | 2104504.97362674 | 37.7580580577361 | -122.47378484454 | (37.7580580577361, -122.47378484454) | 1 | 8 | 4 | 56 | 12 | ||
151607 | 206507 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1985 10th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993144.62205 | 2101960.97627 | 37.751190371338 | -122.466572955586 | (37.751190371338, -122.466572955586) | 1 | 8 | 4 | 29491 | 12 | |||
155475 | 206563 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2047 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993157.06576 | 2101533.95115 | 37.750018588 | -122.466498890138 | (37.750018588, -122.466498890138) | 1 | 8 | 4 | 29491 | 12 | |||
155534 | 206514 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5991006.3222 | 2104484.4348 | 37.7579954981234 | -122.474151458838 | (37.7579954981234, -122.474151458838) | 1 | 8 | 4 | 56 | 12 | |||
159595 | 206508 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990927.20691 | 2104481.04629 | 37.7579816107755 | -122.474424823051 | (37.7579816107755, -122.474424823051) | 1 | 8 | 4 | 56 | 12 | |||
167985 | 206518 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991072.98938 | 2104484.60902 | 37.7579998382313 | -122.473920910448 | (37.7579998382313, -122.473920910448) | 1 | 8 | 4 | 56 | 12 | |||
168392 | 68613 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1921 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32518 | 5990927.53246028 | 2102322.02893789 | 37.7520535368402 | -122.474266156198 | (37.7520535368402, -122.474266156198) | 1 | 8 | 4 | 29491 | 12 | ||
169106 | 206621 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993175.25671 | 2102431.10448 | 37.7524829903015 | -122.466501185193 | (37.7524829903015, -122.466501185193) | 1 | 8 | 4 | 29491 | 12 | |||
177522 | 35070 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38624 | 5992801.46807232 | 2104400.76142731 | 37.7578695806114 | -122.46793705016 | (37.7578695806114, -122.46793705016) | 1 | 8 | 4 | 56 | 12 | ||
177882 | 206504 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1959 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993136.05327 | 2102151.01657 | 37.7517116786758 | -122.466616399136 | (37.7517116786758, -122.466616399136) | 1 | 8 | 4 | 29491 | 12 | |||
180333 | 68592 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1612 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32493 | 5991166.83201474 | 2104447.27401218 | 37.7579027613113 | -122.473593642621 | (37.7579027613113, -122.473593642621) | 1 | 8 | 4 | 56 | 12 | ||
181480 | 206515 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991033.61709 | 2104484.17502 | 37.7579963659675 | -122.474057043516 | (37.7579963659675, -122.474057043516) | 1 | 8 | 4 | 56 | 12 | |||
181496 | 68621 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32526 | 5990932.87525798 | 2102165.34703457 | 37.7516236388925 | -122.474236248389 | (37.7516236388925, -122.474236248389) | 1 | 8 | 4 | 29491 | 12 | ||
185843 | 68598 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1926 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32501 | 5991291.13136145 | 2102295.45546455 | 37.7520016305294 | -122.473006852086 | (37.7520016305294, -122.473006852086) | 1 | 8 | 4 | 29491 | 12 | ||
188697 | 206506 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1985 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993143.71774 | 2101970.98373 | 37.7512177970674 | -122.466576810083 | (37.7512177970674, -122.466576810083) | 1 | 8 | 4 | 29491 | 12 | |||
192064 | 223029 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 170 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997728.70717 | 2104908.9589 | 37.75954826396 | -122.450933321612 | (37.75954826396, -122.450933321612) | 15 | 5 | 11 | 29492 | 12 |
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) );