trees
50 rows where qSpecies_id = 258 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31731 | 88627 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 240 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3x3 | Permit Number 51593 | 6008815.1 | 2113357.3 | 37.7833738682123 | -122.413188342909 | (37.7833738682123, -122.413188342909) | 7 | 10 | 9 | 28852 | 36 | ||
139634 | 88626 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 240 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3x3 | Permit Number 51593 | 6008815.1 | 2113357.3 | 37.7833738682123 | -122.413188342909 | (37.7833738682123, -122.413188342909) | 7 | 10 | 9 | 28852 | 36 | ||
30914 | 105673 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 201X 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X4 | Permit Number 770631 | 6007261.26868 | 2107929.29001 | 37.7683824966916 | -122.418179043584 | (37.7683824966916, -122.418179043584) | 8 | 4 | 7 | 28853 | 19 | |||
54215 | 105674 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 201X 14th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X4 | Permit Number 770631 | 6007261.26868 | 2107929.29001 | 37.7683824966916 | -122.418179043584 | (37.7683824966916, -122.418179043584) | 8 | 4 | 7 | 28853 | 19 | |||
6093 | 45072 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 596 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Permit Number 770844 | 6012065 | 2105633 | 37.7623466149115 | -122.401401881236 | (37.7623466149115, -122.401401881236) | 8 | 3 | 8 | 28856 | 29 | ||
7223 | 106240 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 586 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | Permit Number 770844 | 6012063 | 2105678 | 37.7624700633024 | -122.401411961161 | (37.7624700633024, -122.401411961161) | 8 | 3 | 8 | 28856 | 29 | ||
10557 | 106246 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 560 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 770844 | 6012026 | 2105714 | 37.7625668468002 | -122.401542461625 | (37.7625668468002, -122.401542461625) | 8 | 3 | 8 | 28856 | 29 | ||
48442 | 254181 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 201 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781203 | 6012911.4175 | 2106109.29412 | 37.7637016024008 | -122.398507842407 | (37.7637016024008, -122.398507842407) | 14 | 3 | 8 | 28856 | 29 |
91072 | 117590 | Undocumented 4 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 241 SHIPLEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011527 | 2111724 | 37.7790410807513 | -122.403691225403 | (37.7790410807513, -122.403691225403) | 14 | 2 | 9 | 28856 | 34 | ||||
26435 | 94186 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1350 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | 3x3 | Permit Number 775032 | 6011110.9 | 2102017.1 | 37.7523648769007 | -122.404447241627 | (37.7523648769007, -122.404447241627) | 10 | 4 | 8 | 28859 | 19 | ||
123813 | 84544 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 698X 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 3x3 | Permit Number 774859 | 6009314.54246303 | 2104977.65271839 | 37.7603933359548 | -122.410868438641 | (37.7603933359548, -122.410868438641) | 2 | 4 | 7 | 28859 | 19 | ||
144948 | 114956 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 3470 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | Permit Number 771402 | 6007117 | 2104415.1 | 37.7587252299116 | -122.418428846982 | (37.7587252299116, -122.418428846982) | 2 | 4 | 7 | 28859 | 19 | |||
161229 | 36579 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 2970 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | Permit Number 774998 | 6009675.57743886 | 2101054.36494821 | 37.7496411039984 | -122.409342906887 | (37.7496411039984, -122.409342906887) | 2 | 4 | 7 | 28859 | 19 | ||
3369 | 159447 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 460x Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 09:24:00 AM | 3 | Width 0ft | 5998669 | 2088474 | 37.7144755709944 | -122.446498934146 | (37.7144755709944, -122.446498934146) | 9 | 7 | 6 | 28861 | 25 | ||
6233 | 258390 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 642 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002875.15558 | 2090065.87943 | 37.7190858723969 | -122.432074396816 | (37.7190858723969, -122.432074396816) | 9 | 7 | 6 | 28861 | 5 | |||
17816 | 258396 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 700 Russia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6003011.68779 | 2089979.87214 | 37.7188574551208 | -122.43159632087 | (37.7188574551208, -122.43159632087) | 9 | 7 | 6 | 28861 | 5 | |||
18637 | 258393 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 700 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6003011.68779 | 2089979.87214 | 37.7188574551208 | -122.43159632087 | (37.7188574551208, -122.43159632087) | 9 | 7 | 6 | 28861 | 5 | |||
21501 | 83233 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 111 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2017 10:33:00 AM | 3 | 3x3 | Permit Number 54417 | 6004063.6553 | 2093143.58717 | 37.7276038889037 | -122.428185431836 | (37.7276038889037, -122.428185431836) | 9 | 7 | 6 | 28861 | 5 |
21588 | 159445 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 464 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 09:41:00 AM | 3 | Width 0ft | 5998686.74184 | 2088513.90311 | 37.7145861492044 | -122.446440480459 | (37.7145861492044, -122.446440480459) | 9 | 7 | 6 | 28861 | 25 | ||
28297 | 180979 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 646 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:41:00 AM | 3 | Width 4ft | 6002832.29176 | 2089747.08401 | 37.7182081004084 | -122.432199805772 | (37.7182081004084, -122.432199805772) | 9 | 7 | 6 | 28861 | 5 | |
31502 | 160855 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 605 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:32:00 PM | 3 | Width 0ft | 6002988.68917 | 2089915.90653 | 37.7186805160719 | -122.431671253534 | (37.7186805160719, -122.431671253534) | 9 | 7 | 6 | 28861 | 5 | |
40676 | 161374 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 566 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 03:36:00 PM | 3 | Width 0ft | 6002430.61836 | 2090633.99378 | 37.7206205749503 | -122.433651569691 | (37.7206205749503, -122.433651569691) | 9 | 7 | 6 | 28861 | 5 | |
73367 | 159446 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 464 Huron Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 09:44:00 AM | 3 | Width 0ft | 5998674.52867 | 2088502.95565 | 37.7145553923942 | -122.446481906836 | (37.7145553923942, -122.446481906836) | 9 | 7 | 6 | 28861 | 25 | ||
126036 | 160857 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 600 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:39:00 AM | 3 | Width 0ft | 6002958.77513 | 2089948.27932 | 37.7187677089353 | -122.431776964359 | (37.7187677089353, -122.431776964359) | 9 | 7 | 6 | 28861 | 5 | |
129327 | 160856 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 600 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:46:00 AM | 3 | Width 0ft | 6002966.83908 | 2089959.0451 | 37.7187977265008 | -122.431749858776 | (37.7187977265008, -122.431749858776) | 9 | 7 | 6 | 28861 | 5 | |
132172 | 160859 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 618 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 11:55:00 AM | 3 | Width 0ft | 6002917.16918 | 2089882.76457 | 37.7185854613346 | -122.43191610384 | (37.7185854613346, -122.43191610384) | 9 | 7 | 6 | 28861 | 5 | |
142657 | 160854 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 605 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:30:00 PM | 3 | Width 0ft | 6002981.40369 | 2089904.86461 | 37.7186497844312 | -122.431695648548 | (37.7186497844312, -122.431695648548) | 9 | 7 | 6 | 28861 | 5 | |
17232 | 5580 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1060 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2017 12:00:00 AM | 3 | 5x5 | Permit Number 778117 | 6005065.99031 | 2102183.11443 | 37.7524810459835 | -122.425363351162 | (37.7524810459835, -122.425363351162) | 2 | 4 | 5 | 28862 | 22 |
172769 | 102798 | Undocumented 4 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 547 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002828 | 2102678 | 37.7537131888076 | -122.433138046686 | (37.7537131888076, -122.433138046686) | 2 | 4 | 5 | 28862 | 22 | ||||
174031 | 102797 | Undocumented 4 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 522 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002980 | 2102720 | 37.7538371319968 | -122.432615396749 | (37.7538371319968, -122.432615396749) | 2 | 4 | 5 | 28862 | 22 | ||||
97858 | 121014 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 2099X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6004130 | 2115310 | 37.7884713558687 | -122.429536248108 | (37.7884713558687, -122.429536248108) | 13 | 9 | 11 | 29490 | 27 | |||
173454 | 121006 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 2099X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3x3 | 6004130 | 2115310 | 37.7884713558687 | -122.429536248108 | (37.7884713558687, -122.429536248108) | 13 | 9 | 11 | 29490 | 27 | |||
19472 | 172015 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 622 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3 | 4x5 | 6008819.85723 | 2093756.73811 | 37.7295554330367 | -122.411786437306 | (37.7295554330367, -122.411786437306) | 9 | 3 | 7 | 309 | 28 | ||
90847 | 177382 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 636 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781328 | 6010900.83805 | 2091756.48536 | 37.7241796779218 | -122.404451495646 | (37.7241796779218, -122.404451495646) | 10 | 3 | 7 | 309 | 28 |
119330 | 95133 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 450@ Wayland Somerset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781342 | 6010089.84133 | 2092358.29057 | 37.725786753837 | -122.407297408351 | (37.725786753837, -122.407297408351) | 10 | 3 | 7 | 309 | 28 |
88535 | 87881 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1758 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50852 | 6002335.8 | 2120932.7 | 37.8038080776582 | -122.436146416103 | (37.8038080776582, -122.436146416103) | 13 | 9 | 1 | 57 | 17 | |||
95476 | 124742 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 2725 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000066 | 2117943 | 37.7954699413297 | -122.443786245588 | (37.7954699413297, -122.443786245588) | 13 | 9 | 1 | 57 | 17 | ||||
106297 | 87863 | Permitted Site 7 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 179 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50827 | 6001408 | 2120174 | 37.8016721334373 | -122.439302700013 | (37.8016721334373, -122.439302700013) | 13 | 9 | 1 | 57 | 17 | ||
9455 | 99415 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
20063 | 99414 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
27034 | 99416 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
43293 | 99421 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
46631 | 99431 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
93056 | 99411 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
110258 | 99409 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
131514 | 99426 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
137215 | 99420 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
140994 | 99425 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
148529 | 99430 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 | ||
158300 | 99410 | DPW Maintained 1 | Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 | 1501X Wallace Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6015288.5 | 2092477 | 37.7264022940106 | -122.389334160631 | (37.7264022940106, -122.389334160631) | 10 | 3 | 8 | 58 | 1 |
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) );