trees
39 rows where qCaretaker_id = 2 and qSpecies_id = 193 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1546 | 86589 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2680 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 6 | 3x3 | 6009770 | 2101729 | 37.7514987921589 | -122.40906398531 | (37.7514987921589, -122.40906398531) | 2 | 4 | 7 | 28859 | 19 | ||
8873 | 86678 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1099X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6010093.920773 | 2108925.272404 | 37.7712762686377 | -122.408451379419 | (37.7712762686377, -122.408451379419) | 8 | 2 | 9 | 28853 | 34 | ||
12607 | 86634 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2855 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 7 | 3x3 | 6009854 | 2100787 | 37.7489169738941 | -122.40870705312 | (37.7489169738941, -122.40870705312) | 2 | 4 | 7 | 28859 | 19 | ||
13933 | 86635 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2843 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009851 | 2100841 | 37.7490650779483 | -122.408721236226 | (37.7490650779483, -122.408721236226) | 2 | 4 | 7 | 28859 | 19 | ||
15979 | 86586 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2806 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 5 | 3x3 | 6009810 | 2101003 | 37.7495075976822 | -122.408874443316 | (37.7495075976822, -122.408874443316) | 2 | 4 | 7 | 28859 | 19 | ||
18072 | 86588 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2706 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009778 | 2101578 | 37.7510846278287 | -122.4090256669 | (37.7510846278287, -122.4090256669) | 2 | 4 | 7 | 28859 | 19 | ||
23701 | 86648 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2101 BRYANT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009629 | 2104800 | 37.7599231692161 | -122.409768331223 | (37.7599231692161, -122.409768331223) | 2 | 4 | 8 | 28859 | 19 | ||
37286 | 86691 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 801 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011850.955213 | 2110605.231101 | 37.7759872907146 | -122.402491836684 | (37.7759872907146, -122.402491836684) | 14 | 2 | 9 | 28853 | 34 | ||
40650 | 86641 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2601X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009781.509232 | 2102185.131738 | 37.752751873221 | -122.409056366206 | (37.752751873221, -122.409056366206) | 2 | 4 | 7 | 28859 | 19 | ||
41648 | 86679 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1099X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6010093.920773 | 2108925.272404 | 37.7712762686377 | -122.408451379419 | (37.7712762686377, -122.408451379419) | 8 | 2 | 9 | 28853 | 34 | ||
51585 | 86593 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2478 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009709 | 2102902 | 37.7547161712166 | -122.409357703238 | (37.7547161712166, -122.409357703238) | 2 | 4 | 7 | 28859 | 19 | ||
55508 | 86646 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2339 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009687 | 2103724 | 37.7569719661502 | -122.409491795736 | (37.7569719661502, -122.409491795736) | 2 | 4 | 7 | 28859 | 19 | ||
59391 | 86629 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 800 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6011723.7 | 2110620.4 | 37.7760218359883 | -122.402933115468 | (37.7760218359883, -122.402933115468) | 14 | 2 | 9 | 28853 | 34 | ||
64543 | 86587 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2814 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 4 | 3x3 | 6009812 | 2100967 | 37.7494088616664 | -122.408864987646 | (37.7494088616664, -122.408864987646) | 2 | 4 | 7 | 28859 | 19 | ||
66568 | 86609 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1340 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009366.784533 | 2108201.089667 | 37.7692470834738 | -122.410915428233 | (37.7692470834738, -122.410915428233) | 8 | 4 | 7 | 28853 | 19 | ||
67864 | 86591 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2426 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 6 | 3x3 | 6009690 | 2103213 | 37.7555690429963 | -122.409445358046 | (37.7555690429963, -122.409445358046) | 2 | 4 | 7 | 28859 | 19 | ||
71410 | 86682 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 925 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011036 | 2109830 | 37.7738131553884 | -122.405256391162 | (37.7738131553884, -122.405256391162) | 14 | 2 | 9 | 28853 | 34 | ||
88166 | 86685 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 855A BRYANT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011520 | 2110245 | 37.7749796974417 | -122.403611352682 | (37.7749796974417, -122.403611352682) | 14 | 2 | 9 | 28853 | 34 | ||
90192 | 86647 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2101 BRYANT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009629 | 2104800 | 37.7599231692161 | -122.409768331223 | (37.7599231692161, -122.409768331223) | 2 | 4 | 8 | 28859 | 19 | ||
91354 | 86633 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2865 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009857 | 2100741 | 37.7487908360698 | -122.408693434366 | (37.7487908360698, -122.408693434366) | 2 | 4 | 7 | 28859 | 19 | ||
96780 | 86596 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2050 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6009534.559924 | 2105232.70141 | 37.7611059761979 | -122.410125503803 | (37.7611059761979, -122.410125503803) | 2 | 4 | 7 | 28859 | 19 | ||
117757 | 86636 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2831 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 6 | 3x3 | 6009848 | 2100896 | 37.7492159277762 | -122.408735489927 | (37.7492159277762, -122.408735489927) | 2 | 4 | 7 | 28859 | 19 | ||
121038 | 86642 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2523 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009755.966457 | 2102647.694837 | 37.7540205374071 | -122.409177335884 | (37.7540205374071, -122.409177335884) | 2 | 4 | 7 | 28859 | 19 | ||
123310 | 86628 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 800 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6011823.312179 | 2110634.14239 | 37.7760651312146 | -122.402589495274 | (37.7760651312146, -122.402589495274) | 14 | 2 | 9 | 28853 | 34 | ||
125958 | 86585 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2800 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6009809 | 2101031 | 37.7495844234785 | -122.408879876605 | (37.7495844234785, -122.408879876605) | 2 | 4 | 7 | 28859 | 19 | ||
129192 | 94126 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1705 Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53488 | 6009339 | 2099555 | 37.7455053159108 | -122.410400952088 | (37.7455053159108, -122.410400952088) | 2 | 7 | 7 | 28859 | 2 | |||
130237 | 86692 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 799 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011860.659694 | 2110614.509875 | 37.7760133098576 | -122.402458918743 | (37.7760133098576, -122.402458918743) | 14 | 2 | 9 | 28856 | 34 | ||
147810 | 86594 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2104 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2007 12:00:00 AM | 5 | 3x3 | 6009555 | 2104982 | 37.7604187527014 | -122.410037111014 | (37.7604187527014, -122.410037111014) | 2 | 4 | 7 | 28859 | 19 | ||
148056 | 94254 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2101 BRYANT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009629 | 2104800 | 37.7599231692161 | -122.409768331223 | (37.7599231692161, -122.409768331223) | 2 | 4 | 8 | 28859 | 19 | |
152717 | 86677 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1099X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6010093.920773 | 2108925.272404 | 37.7712762686377 | -122.408451379419 | (37.7712762686377, -122.408451379419) | 8 | 2 | 9 | 28853 | 34 | ||
154537 | 86643 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2509 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009750.763887 | 2102714.734209 | 37.7542043210828 | -122.409200058031 | (37.7542043210828, -122.409200058031) | 2 | 4 | 7 | 28859 | 19 | ||
171770 | 94255 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2101 BRYANT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009629 | 2104800 | 37.7599231692161 | -122.409768331223 | (37.7599231692161, -122.409768331223) | 2 | 4 | 8 | 28859 | 19 | |
175201 | 86645 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2429 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 6 | 3x3 | 6009717 | 2103202 | 37.7555403522537 | -122.409351206988 | (37.7555403522537, -122.409351206988) | 2 | 4 | 7 | 28859 | 19 | ||
180641 | 86680 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 1099X Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6010093.920773 | 2108925.272404 | 37.7712762686377 | -122.408451379419 | (37.7712762686377, -122.408451379419) | 8 | 2 | 9 | 28853 | 34 | ||
180674 | 108059 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 333 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014767.05947 | 2114804.11815 | 37.7876788463295 | -122.392697989841 | (37.7876788463295, -122.392697989841) | 6 | 2 | 9 | 28855 | 6 | ||
189448 | 94127 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 22 Costa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53491 | 6010633 | 2099194 | 37.7445865435074 | -122.405901054869 | (37.7445865435074, -122.405901054869) | 2 | 7 | 7 | 28859 | 2 | |||
191486 | 86640 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 2601X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009781.509232 | 2102185.131738 | 37.752751873221 | -122.409056366206 | (37.752751873221, -122.409056366206) | 2 | 4 | 7 | 28859 | 19 | ||
57298 | 109497 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 785 Mangels Ave | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771883 | 5996438 | 2095245 | 37.7329394498659 | -122.45469900823 | (37.7329394498659, -122.45469900823) | 9 | 7 | 4 | 59 | 40 |
185610 | 95633 | Permitted Site 7 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 | 275 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767400 | 6005466 | 2102113 | 37.7523111195198 | -122.423975063491 | (37.7523111195198, -122.423975063491) | 2 | 4 | 5 | 28859 | 19 |
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) );