trees
66 rows where qCaretaker_id = 1 and qSpecies_id = 193
This data as json, CSV (advanced)
These facets timed out: qCaretaker_id
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2936 | 86592 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2464 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 5 | 3x3 | 6009700 | 2102983 | 37.7549380748285 | -122.40939454386 | (37.7549380748285, -122.40939454386) | 2 | 4 | 7 | 28859 | 19 | ||
| 10899 | 85668 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 595 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013195 | 2111894 | 37.7796008978727 | -122.397932828244 | (37.7796008978727, -122.397932828244) | 6 | 2 | 9 | 28856 | 34 | ||
| 12491 | 85685 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 690X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012554.937239 | 2111333.645207 | 37.7780266247864 | -122.400107730612 | (37.7780266247864, -122.400107730612) | 6 | 2 | 9 | 28856 | 34 | ||
| 13987 | 86667 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1401 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009415.210394 | 2108121.51235 | 37.7690312978784 | -122.410742304305 | (37.7690312978784, -122.410742304305) | 8 | 4 | 8 | 28853 | 19 | ||
| 17635 | 86658 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 17763 | 85665 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 655 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012806 | 2111523 | 37.7785605448609 | -122.399252504881 | (37.7785605448609, -122.399252504881) | 6 | 2 | 9 | 28856 | 34 | ||
| 21916 | 86662 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1525 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009431 | 2107695 | 37.7678610788154 | -122.410657564802 | (37.7678610788154, -122.410657564802) | 8 | 4 | 8 | 28853 | 19 | ||
| 22010 | 14692 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 780 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | ||
| 25274 | 86663 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1525 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009431 | 2107695 | 37.7678610788154 | -122.410657564802 | (37.7678610788154, -122.410657564802) | 8 | 4 | 8 | 28853 | 19 | ||
| 30104 | 85676 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 704 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012451.875069 | 2111235.132166 | 37.7777503836654 | -122.400457340145 | (37.7777503836654, -122.400457340145) | 14 | 2 | 9 | 28856 | 34 | ||
| 30855 | 86651 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 31716 | 86608 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1320 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009356.692757 | 2108225.261998 | 37.7693128892067 | -122.410952042831 | (37.7693128892067, -122.410952042831) | 8 | 4 | 7 | 28853 | 19 | ||
| 32523 | 86664 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1525 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009431 | 2107695 | 37.7678610788154 | -122.410657564802 | (37.7678610788154, -122.410657564802) | 8 | 4 | 8 | 28853 | 19 | ||
| 32569 | 85670 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 501X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013820.479094 | 2112489.047875 | 37.7812695783915 | -122.395810717988 | (37.7812695783915, -122.395810717988) | 6 | 2 | 9 | 28856 | 34 | ||
| 33209 | 86670 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1199X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009734.918039 | 2108585.630992 | 37.7703235808018 | -122.409669213753 | (37.7703235808018, -122.409669213753) | 8 | 2 | 9 | 28853 | 34 | ||
| 33304 | 86638 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2645 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009791 | 2101940 | 37.7520793276673 | -122.40900625069 | (37.7520793276673, -122.40900625069) | 2 | 4 | 7 | 28859 | 19 | ||
| 36096 | 85673 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 501X Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013820.479094 | 2112489.047875 | 37.7812695783915 | -122.395810717988 | (37.7812695783915, -122.395810717988) | 6 | 2 | 9 | 28856 | 34 | ||
| 37043 | 86604 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1634 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009426.950202 | 2107176.510466 | 37.7664371989841 | -122.41063495341 | (37.7664371989841, -122.41063495341) | 8 | 4 | 7 | 28853 | 19 | ||
| 43254 | 86632 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 758 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6012037 | 2110834 | 37.7766258220476 | -122.401864339976 | (37.7766258220476, -122.401864339976) | 14 | 2 | 9 | 28856 | 34 | ||
| 44166 | 86597 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1900X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009482.453 | 2105855.071 | 37.7628119405714 | -122.410349665328 | (37.7628119405714, -122.410349665328) | 8 | 4 | 7 | 28859 | 19 | ||
| 48778 | 86665 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1525 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009431 | 2107695 | 37.7678610788154 | -122.410657564802 | (37.7678610788154, -122.410657564802) | 8 | 4 | 8 | 28853 | 19 | ||
| 49506 | 85669 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 595 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013195 | 2111894 | 37.7796008978727 | -122.397932828244 | (37.7796008978727, -122.397932828244) | 6 | 2 | 9 | 28856 | 34 | ||
| 50308 | 86607 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1504 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009401 | 2107786 | 37.7681092617719 | -122.410767759211 | (37.7681092617719, -122.410767759211) | 8 | 4 | 7 | 28853 | 19 | ||
| 57768 | 86686 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 835 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011628 | 2110396 | 37.7754003409411 | -122.403248379763 | (37.7754003409411, -122.403248379763) | 14 | 2 | 9 | 28853 | 34 | ||
| 57798 | 86650 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 59034 | 85675 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 427 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6014308 | 2112959 | 37.7825870687932 | -122.394157033517 | (37.7825870687932, -122.394157033517) | 6 | 2 | 9 | 28856 | 6 | ||
| 60176 | 85671 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 501X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013820.479094 | 2112489.047875 | 37.7812695783915 | -122.395810717988 | (37.7812695783915, -122.395810717988) | 6 | 2 | 9 | 28856 | 34 | ||
| 66552 | 86656 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 77322 | 86590 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2406 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 5 | 3x3 | 6009684 | 2103329 | 37.7558872167904 | -122.409474294377 | (37.7558872167904, -122.409474294377) | 2 | 4 | 7 | 28859 | 19 | ||
| 78844 | 14668 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 716 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | ||
| 79897 | 86612 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1102 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010044.972727 | 2108933.970613 | 37.7712974106288 | -122.408621307268 | (37.7712974106288, -122.408621307268) | 8 | 2 | 9 | 28853 | 34 | ||
| 81409 | 86602 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1798 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009476 | 2106404 | 37.7643188123937 | -122.410410745966 | (37.7643188123937, -122.410410745966) | 8 | 4 | 7 | 28859 | 19 | ||
| 87616 | 86601 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1728 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2011 12:00:00 AM | 3 | 3x3 | Replant with Acer rubrum 'Red Sunset' | 6009458 | 2106735 | 37.7652266534479 | -122.410496377801 | (37.7652266534479, -122.410496377801) | 8 | 4 | 7 | 28859 | 19 | |
| 100737 | 86603 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1634 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009426.950202 | 2107176.510466 | 37.7664371989841 | -122.41063495341 | (37.7664371989841, -122.41063495341) | 8 | 4 | 7 | 28853 | 19 | ||
| 105164 | 86649 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1975 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009547 | 2105587 | 37.7620794968032 | -122.410107492535 | (37.7620794968032, -122.410107492535) | 8 | 4 | 8 | 28859 | 19 | ||
| 107107 | 86668 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1401 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009415.210394 | 2108121.51235 | 37.7690312978784 | -122.410742304305 | (37.7690312978784, -122.410742304305) | 8 | 4 | 8 | 28853 | 19 | ||
| 110162 | 86600 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1890 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009499 | 2105975 | 37.7631421657967 | -122.410300902972 | (37.7631421657967, -122.410300902972) | 8 | 4 | 7 | 28859 | 19 | ||
| 117122 | 86639 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2603 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009782.125197 | 2102173.977013 | 37.7527212793357 | -122.409053449069 | (37.7527212793357, -122.409053449069) | 2 | 4 | 7 | 28859 | 19 | ||
| 118415 | 85672 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 501X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013820.479094 | 2112489.047875 | 37.7812695783915 | -122.395810717988 | (37.7812695783915, -122.395810717988) | 6 | 2 | 9 | 28856 | 34 | ||
| 120364 | 86605 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1504 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009401 | 2107786 | 37.7681092617719 | -122.410767759211 | (37.7681092617719, -122.410767759211) | 8 | 4 | 7 | 28853 | 19 | ||
| 124010 | 86611 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1102 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010044.972727 | 2108933.970613 | 37.7712974106288 | -122.408621307268 | (37.7712974106288, -122.408621307268) | 8 | 2 | 9 | 28853 | 34 | ||
| 127100 | 86598 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1900X Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009485.925 | 2105820.783 | 37.7627179881765 | -122.410335235745 | (37.7627179881765, -122.410335235745) | 8 | 4 | 7 | 28859 | 19 | ||
| 130464 | 86669 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1199X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009734.918039 | 2108585.630992 | 37.7703235808018 | -122.409669213753 | (37.7703235808018, -122.409669213753) | 8 | 2 | 9 | 28853 | 34 | ||
| 130779 | 14676 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | 7 | 9 | 11 | 28852 | 41 | |||
| 132016 | 85686 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 690X Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012554.937239 | 2111333.645207 | 37.7780266247864 | -122.400107730612 | (37.7780266247864, -122.400107730612) | 6 | 2 | 9 | 28856 | 34 | ||
| 134242 | 85687 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 690X Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012554.937239 | 2111333.645207 | 37.7780266247864 | -122.400107730612 | (37.7780266247864, -122.400107730612) | 6 | 2 | 9 | 28856 | 34 | ||
| 141271 | 86657 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 143418 | 86659 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 143457 | 86652 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 147175 | 86674 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1101X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6010079.384913 | 2108911.443338 | 37.77123748318 | -122.40850068415 | (37.77123748318, -122.40850068415) | 8 | 2 | 9 | 28853 | 34 | ||
| 154698 | 86666 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1401 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009415.210394 | 2108121.51235 | 37.7690312978784 | -122.410742304305 | (37.7690312978784, -122.410742304305) | 8 | 4 | 8 | 28853 | 19 | ||
| 154795 | 14665 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 714 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/2011 12:00:00 AM | 3 | 4x4 | 6005700.53435 | 2112083.57003 | 37.7797011734876 | -122.42387292416 | (37.7797011734876, -122.42387292416) | 7 | 9 | 11 | 28852 | 41 | ||
| 157226 | 86654 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 161051 | 86653 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 161908 | 86606 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1504 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009401 | 2107786 | 37.7681092617719 | -122.410767759211 | (37.7681092617719, -122.410767759211) | 8 | 4 | 7 | 28853 | 19 | ||
| 162834 | 86675 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1101X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6010079.384913 | 2108911.443338 | 37.77123748318 | -122.40850068415 | (37.77123748318, -122.40850068415) | 8 | 2 | 9 | 28853 | 34 | ||
| 170142 | 85674 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 501X Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013820.479094 | 2112489.047875 | 37.7812695783915 | -122.395810717988 | (37.7812695783915, -122.395810717988) | 6 | 2 | 9 | 28856 | 34 | ||
| 175875 | 85679 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 600 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013124.411985 | 2111877.911503 | 37.779552791056 | -122.39817589517 | (37.779552791056, -122.39817589517) | 6 | 2 | 9 | 28856 | 34 | ||
| 176097 | 85666 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 651 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012835.674116 | 2111546.624271 | 37.7786270654316 | -122.399151508826 | (37.7786270654316, -122.399151508826) | 6 | 2 | 9 | 28856 | 34 | ||
| 184340 | 86599 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1890 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009499 | 2105975 | 37.7631421657967 | -122.410300902972 | (37.7631421657967, -122.410300902972) | 8 | 4 | 7 | 28859 | 19 | ||
| 188365 | 86655 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1600X Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009425 | 2107340 | 37.7668859942678 | -122.410653245453 | (37.7668859942678, -122.410653245453) | 8 | 4 | 7 | 28853 | 19 | ||
| 188549 | 86676 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1101X Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6010079.384913 | 2108911.443338 | 37.77123748318 | -122.40850068415 | (37.77123748318, -122.40850068415) | 8 | 2 | 9 | 28853 | 34 | ||
| 188757 | 86661 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1525 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009431 | 2107695 | 37.7678610788154 | -122.410657564802 | (37.7678610788154, -122.410657564802) | 8 | 4 | 8 | 28853 | 19 | ||
| 190632 | 85691 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 580 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013335 | 2112075 | 37.7801056784505 | -122.397461201961 | (37.7801056784505, -122.397461201961) | 6 | 2 | 9 | 28856 | 34 | ||
| 191747 | 86644 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2459X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009731.617714 | 2103027.288048 | 37.7550614513589 | -122.409288325583 | (37.7550614513589, -122.409288325583) | 2 | 4 | 7 | 28859 | 19 | ||
| 193372 | 85693 | DPW Maintained 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 474 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013649 | 2112678 | 37.7817788567242 | -122.396417203711 | (37.7817788567242, -122.396417203711) | 6 | 2 | 9 | 28856 | 34 |
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) );