Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50040 | 50040 | 87823 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 2x3 | Permit Number 50716 | 5981265.5826900005 | 2112596.97795 | 37.7797010943021 | -122.508440678428 | (37.7797010943021, -122.508440678428) | ||
37553 | 37553 | 87825 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 2x3 | Permit Number 50716 | 5981267.84329 | 2112567.4887599996 | 37.7796202589611 | -122.508430668506 | (37.7796202589611, -122.508430668506) | |
46301 | 46301 | 87824 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3 | 2x3 | Permit Number 50716 | 5981268.94768 | 2112581.1831099996 | 37.7796579246713 | -122.50842786485799 | (37.7796579246713, -122.508427864858) | |
150585 | 150585 | 56095 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 783 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52001 | 5981348.38409 | 2110404.98623 | 37.7736874110676 | -122.507991510924 | (37.7736874110676, -122.507991510924) | |
187658 | 187658 | 92257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 862 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52706 | 5981411.16308 | 2109852.88199 | 37.7721751933845 | -122.50773337462299 | (37.7721751933845, -122.507733374623) | |
131729 | 131729 | 34701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 546 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52703 | 5981643.1854 | 2112019.5317 | 37.7781378442384 | -122.507091560706 | (37.7781378442384, -122.507091560706) | |
148645 | 148645 | 34700 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 546 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52703 | 5981644.97521 | 2112008.50675 | 37.7781076783894 | -122.507084551143 | (37.7781076783894, -122.507084551143) | |
65153 | 65153 | 50405 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 815 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52709 | 5981666.2240699995 | 2110158.20965 | 37.7730285573555 | -122.506873764155 | (37.7730285573555, -122.506873764155) | |
148211 | 148211 | 68564 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32454 | 5981914.34705 | 2111854.14558 | 37.7776997090602 | -122.506141264398 | (37.7776997090602, -122.506141264398) | |
46117 | 46117 | 68549 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 543 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 3 | Permit Number 32436 | 5982217.68828 | 2112054.92779 | 37.7782688503059 | -122.50510680493 | (37.7782688503059, -122.50510680493) | |
34490 | 34490 | 68541 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 6 | Permit Number 32425 | 5982517.9924800005 | 2112299.68917 | 37.778958557712606 | -122.504086094205 | (37.7789585577126, -122.504086094205) | |
105625 | 105625 | 68543 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 519 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32427 | 5982523.73467 | 2112217.34809 | 37.7787328109508 | -122.504060129291 | (37.7787328109508, -122.504060129291) | ||
183324 | 183324 | 68544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 571 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32430 | 5982530.7498 | 2111896.5441900003 | 37.777852390021 | -122.504012093664 | (37.777852390021, -122.504012093664) | |
163678 | 163678 | 81982 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 563 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49998 | 5982533.65676 | 2111927.12728 | 37.7779365331701 | -122.504004303472 | (37.7779365331701, -122.504004303472) | |
136410 | 136410 | 82431 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 650 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52680 | 5982600.56645 | 2111346.95635 | 37.7763474878375 | -122.503729865488 | (37.7763474878375, -122.503729865488) | |
61940 | 61940 | 92237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52681 | 5982614.54862 | 2110914.94505 | 37.7751621329201 | -122.503649497706 | (37.7751621329201, -122.503649497706) | |
57130 | 57130 | 92234 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52677 | 5982879.44866 | 2112163.93194 | 37.778607057674996 | -122.50282564106199 | (37.778607057675, -122.502825641062) |
30074 | 30074 | 47440 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45351 | 5982914.18523 | 2109947.95579 | 37.7725246733221 | -122.50254141771099 | (37.7725246733221, -122.502541417711) | |
102770 | 102770 | 96076 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 767701 | 5983098.7 | 2113007.7 | 37.780936680817206 | -122.502129633812 | (37.7809366808172, -122.502129633812) | ||
175243 | 175243 | 96075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767701 | 5983103.04582 | 2113013.19289 | 37.7809520179972 | -122.50211500631399 | (37.7809520179972, -122.502115006314) |
50531 | 50531 | 96079 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 664 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767703 | 5983226.11153 | 2111277.81973 | 37.7761944189321 | -122.501560849986 | (37.7761944189321, -122.501560849986) |
135433 | 135433 | 96081 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767704 | 5983251.84023 | 2110453.37841 | 37.773932253218 | -122.501410848383 | (37.773932253218, -122.501410848383) |
94281 | 94281 | 96080 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3x3 | Permit Number 767704 | 5983278.4 | 2110433.5 | 37.7738792326413 | -122.501317504516 | (37.7738792326413, -122.501317504516) | |
43768 | 43768 | 81737 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49969 | 5983468.0529 | 2111801.95258 | 37.7776477425111 | -122.500762690576 | (37.7776477425111, -122.500762690576) | |
140762 | 140762 | 92430 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1758 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52821 | 5983521.6 | 2103180.6 | 37.7539791070225 | -122.499940017573 | (37.7539791070225, -122.499940017573) | |
158906 | 158906 | 82734 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 663 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52670 | 5983795.84033 | 2111312.2935099998 | 37.776322519429606 | -122.499592582815 | (37.7763225194296, -122.499592582815) | |
61829 | 61829 | 79376 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 683 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52671 | 5983799.61702 | 2111191.23616 | 37.7759903525694 | -122.499570569578 | (37.7759903525694, -122.499570569578) | |
156479 | 156479 | 94817 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 683 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52671 | 5983800.6479400005 | 2111169.09276 | 37.775929613686294 | -122.499565366534 | (37.7759296136863, -122.499565366534) |
158895 | 158895 | 92228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 819 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52552 | 5984148.0757 | 2110235.49072 | 37.77338659024161 | -122.498294572929 | (37.7733865902416, -122.498294572929) | |
147200 | 147200 | 92229 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 831 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52669 | 5984149.10381 | 2110157.50395 | 37.7731725212481 | -122.498285255587 | (37.7731725212481, -122.498285255587) | |
24823 | 24823 | 47425 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45336 | 5984176.15569 | 2110679.3098400002 | 37.7746068364777 | -122.49823022658701 | (37.7746068364777, -122.498230226587) | |
71854 | 71854 | 81961 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 485 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 2 | Permit Number 49960 | 5984369.11349 | 2112553.91349 | 37.779765269334504 | -122.49770119972901 | (37.7797652693345, -122.497701199729) | ||
85362 | 85362 | 87022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 569 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49956 | 5985016.5 | 2111999.9 | 37.7782820363511 | -122.49542076869 | (37.7782820363511, -122.49542076869) | ||
33711 | 33711 | 49142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 4 | Permit Number 46265 | 5985047.031690001 | 2112314.4789400003 | 37.7791475672211 | -122.495338355641 | (37.7791475672211, -122.495338355641) | ||
154069 | 154069 | 43063 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 490 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51464 | 5985346.9900400005 | 2112594.40853 | 37.779933731493294 | -122.49432133158399 | (37.7799337314933, -122.494321331584) | |
114388 | 114388 | 28783 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985480.3602 | 2112543.9942799998 | 37.7798031124689 | -122.493856235161 | (37.7798031124689, -122.493856235161) | |||
80503 | 80503 | 28782 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985488.09937 | 2112541.18326 | 37.7797958470089 | -122.493829255147 | (37.7797958470089, -122.493829255147) | |||
84850 | 84850 | 28781 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985497.48939 | 2112543.62929 | 37.7798031124744 | -122.493796951714 | (37.7798031124744, -122.493796951714) | |||
160586 | 160586 | 95194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 517 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767108 | 5985627.976369999 | 2112321.20657 | 37.7792000368481 | -122.49332915492701 | (37.7792000368481, -122.493329154927) | |
103477 | 103477 | 115280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1670 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775682 | 5985986.6 | 2095938.5 | 37.73423859995479 | -122.49088271409599 | (37.7342385999548, -122.490882714096) | |||
105490 | 105490 | 115279 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1670 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775682 | 5985986.6 | 2095938.5 | 37.73423859995479 | -122.49088271409599 | (37.7342385999548, -122.490882714096) | |||
121235 | 121235 | 108310 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1563 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | 5986200.157869999 | 2104606.03112 | 37.7580497793679 | -122.49078193256099 | (37.7580497793679, -122.490781932561) | |||
129882 | 129882 | 95990 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 734 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767642 | 5986340.19492 | 2110900.5686 | 37.7753410020486 | -122.490760773635 | (37.7753410020486, -122.490760773635) |
165506 | 165506 | 95992 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 858 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767644 | 5986371.40114 | 2110056.12968 | 37.7730242344515 | -122.490590683906 | (37.7730242344515, -122.490590683906) |
172196 | 172196 | 35478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 524 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 6 | Permit Number 38890 | 5986598.81458 | 2112347.1481 | 37.779328002919705 | -122.489972580124 | (37.7793280029197, -122.489972580124) | ||
128801 | 128801 | 95991 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767643 | 5986614.1 | 2110873.8 | 37.7752834997455 | -122.48981131617901 | (37.7752834997455, -122.489811316179) | |
86942 | 86942 | 95442 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2536 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/03/2011 12:00:00 AM | 3x3 | Permit Number 767304 | 5986467.3 | 2097980.9 | 37.7398745611118 | -122.489370926882 | (37.7398745611118, -122.489370926882) | |
83350 | 83350 | 87229 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575X Judah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2007 12:00:00 AM | 3x3 | Permit Number 50266 | 5986663.0 | 2105714.0 | 37.7611189843543 | -122.4892627097 | (37.7611189843543, -122.4892627097) | ||
92397 | 92397 | 87232 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575X Judah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2007 12:00:00 AM | 3x3 | Permit Number 50266 | 5986663.0 | 2105714.0 | 37.7611189843543 | -122.4892627097 | (37.7611189843543, -122.4892627097) | ||
97753 | 97753 | 87227 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575X Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2007 12:00:00 AM | 3x3 | Permit Number 50266 | 5986663.0 | 2105714.0 | 37.7611189843543 | -122.4892627097 | (37.7611189843543, -122.4892627097) | ||
99097 | 99097 | 87228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575X Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2007 12:00:00 AM | 3x3 | Permit Number 50266 | 5986663.0 | 2105714.0 | 37.7611189843543 | -122.4892627097 | (37.7611189843543, -122.4892627097) | ||
128584 | 128584 | 99865 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 566 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2012 12:00:00 AM | 3x3 | Permit Number 768884 | 5986943.1 | 2112080.0 | 37.7786145879683 | -122.488761926719 | (37.7786145879683, -122.488761926719) | ||
27626 | 27626 | 67962 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 3 | Permit Number 31683 | 5986944.37754 | 2110090.6261299998 | 37.773152403641205 | -122.488611249777 | (37.7731524036412, -122.488611249777) | |
166797 | 166797 | 50876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 322 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 7 | Permit Number 47534 | 5987167.73714 | 2113766.40078 | 37.7832580715076 | -122.48810878253401 | (37.7832580715076, -122.488108782534) | ||
39049 | 39049 | 51052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 326 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | 10 | Permit Number 47522 | 5987167.50591 | 2113744.97071 | 37.7831992171669 | -122.488108007262 | (37.7831992171669, -122.488108007262) | ||
147431 | 147431 | 96900 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 334 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987168.76751 | 2113688.0402900004 | 37.7830429760908 | -122.488099458022 | (37.7830429760908, -122.488099458022) | |
25818 | 25818 | 96898 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 334 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987169.6042 | 2113664.32132 | 37.7829778993822 | -122.48809482 | (37.7829778993822, -122.48809482) | |
157195 | 157195 | 96899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 334 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | 2 | 4x4 | Permit Number 768036 | 5987170.52326 | 2113675.9123 | 37.783009778520004 | -122.488092492463 | (37.78300977852, -122.488092492463) | |
87118 | 87118 | 92493 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1942 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52863 | 5986947.0 | 2097598.0 | 37.7388512102115 | -122.48768422414699 | (37.7388512102115, -122.487684224147) | |
173587 | 173587 | 95934 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 674 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767631 | 5987254.50705 | 2111348.9878700003 | 37.7766256032795 | -122.487630947058 | (37.7766256032795, -122.487630947058) |
125078 | 125078 | 108634 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | |||
139650 | 139650 | 108635 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) |
126025 | 126025 | 95937 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 730 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767633 | 5987294.2 | 2110946.4 | 37.7755225253955 | -122.48746405921301 | (37.7755225253955, -122.487464059213) | |
30548 | 30548 | 45544 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 79 Riverton Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44297 | 5987024.26021 | 2095319.08797 | 37.732598422284205 | -122.48724975796301 | (37.7325984222842, -122.487249757963) | |
96409 | 96409 | 109901 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2271 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775113 | 5987275.3 | 2099830.0 | 37.7449988337527 | -122.486712981387 | (37.7449988337527, -122.486712981387) |
156020 | 156020 | 95931 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 691 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767628 | 5987521.80961 | 2111256.95198 | 37.7763884852693 | -122.486699521672 | (37.7763884852693, -122.486699521672) |
93785 | 93785 | 93907 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 733 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2010 12:00:00 AM | 3x3 | Permit Number 53380 | 5987516.1 | 2110955.9 | 37.7755615483313 | -122.486697161376 | (37.7755615483313, -122.486697161376) | ||
177958 | 177958 | 45540 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44295 | 5987294.0576 | 2094889.97142 | 37.7314359091244 | -122.48628552285801 | (37.7314359091244, -122.486285522858) | |
161720 | 161720 | 88140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2445 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51172 | 5987869.621169999 | 2113257.1957099997 | 37.78190086066029 | -122.485643191826 | (37.7819008606603, -122.485643191826) |
184812 | 184812 | 94696 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53831 | 5987889.1247 | 2113258.0139599997 | 37.7819042437171 | -122.48557577955201 | (37.7819042437171, -122.485575779552) |
50848 | 50848 | 50228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 741 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 5 | Permit Number 46935 | 5987844.86264 | 2110914.45258 | 37.775466905732706 | -122.485556863724 | (37.7754669057327, -122.485556863724) | |
169580 | 169580 | 84326 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53994 | 5987888.08845 | 2110995.2066599997 | 37.7756911522049 | -122.48541326443899 | (37.7756911522049, -122.485413264439) |
25098 | 25098 | 95928 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 758 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767625 | 5987895.384330001 | 2110807.039 | 37.775174921567796 | -122.485374215588 | (37.7751749215678, -122.485374215588) |
87143 | 87143 | 94697 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53831 | 5987960.0 | 2113267.0 | 37.7819330460656 | -122.485331246452 | (37.7819330460656, -122.485331246452) | ||
175674 | 175674 | 45552 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2003 12:00:00 AM | 3 | Permit Number 44300 | 5987586.8772599995 | 2094815.36489 | 37.7312481217032 | -122.485267730441 | (37.7312481217032, -122.485267730441) | |
184323 | 184323 | 45553 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 Sylvan Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44300 | 5987588.08064 | 2094826.81646 | 37.7312796348483 | -122.485264410152 | (37.7312796348483, -122.485264410152) | |
18366 | 18366 | 92323 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2595 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987970.2 | 2097662.1 | 37.739086838436606 | -122.484151218827 | (37.7390868384366, -122.484151218827) | |
120931 | 120931 | 92322 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2595 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987970.2 | 2097662.1 | 37.739086838436606 | -122.484151218827 | (37.7390868384366, -122.484151218827) | |
126933 | 126933 | 92324 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2595 27th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987970.2 | 2097662.1 | 37.739086838436606 | -122.484151218827 | (37.7390868384366, -122.484151218827) | |
87255 | 87255 | 84692 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2595 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987984.46067049 | 2097655.73005422 | 37.739070178519704 | -122.48410144552601 | (37.7390701785197, -122.484101445526) | |
182102 | 182102 | 103454 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5988396.696330001 | 2114118.88325 | 37.7842975073391 | -122.48388298077101 | (37.7842975073391, -122.483882980771) | |||
58542 | 58542 | 43804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | 6x5 | Permit Number 43434 | 5988398.115730001 | 2114095.5575599996 | 37.7842335442368 | -122.483876359267 | (37.7842335442368, -122.483876359267) |
85212 | 85212 | 12835 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2005 12:00:00 AM | 12 | 5 | 5988460.73959 | 2114698.1479700003 | 37.7858917318965 | -122.48370390161001 | (37.7858917318965, -122.48370390161) | ||
85693 | 85693 | 96953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988418.13148 | 2110571.74898 | 37.7745593211999 | -122.483548684419 | (37.7745593211999, -122.483548684419) | ||
90273 | 90273 | 12830 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2224 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5 | 5988512.18064 | 2114699.8246299997 | 37.785899329731606 | -122.483526054934 | (37.7858993297316, -122.483526054934) | |||
112881 | 112881 | 96952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | ||
101603 | 101603 | 68962 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | 3x3 | Permit Number 32951 | 5988444.16962 | 2110572.72123 | 37.7745635062345 | -122.483458685783 | (37.7745635062345, -122.483458685783) |
133247 | 133247 | 50771 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 638 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | 7 | Permit Number 47314 | 5988487.7879800005 | 2111617.79391 | 37.7774355226981 | -122.48338443014799 | (37.7774355226981, -122.483384430148) | ||
101084 | 101084 | 12827 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2212 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3 | 3X3 | 5988580.16808 | 2114701.5279099997 | 37.785907963353296 | -122.483290964922 | (37.7859079633533, -122.483290964922) | ||
170838 | 170838 | 68956 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 874 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32945 | 5988542.5052 | 2110035.3324599997 | 37.7730937088544 | -122.483079131422 | (37.7730937088544, -122.483079131422) | |
73877 | 73877 | 45531 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Inverness Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44290 | 5988290.9031 | 2095585.94321 | 37.733404918983204 | -122.482890269181 | (37.7334049189832, -122.482890269181) | |
60065 | 60065 | 65973 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2245 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1990 12:00:00 AM | 9 | Permit Number 28997 | 5988612.04832 | 2110519.74016 | 37.7744278044001 | -122.48287408378 | (37.7744278044001, -122.48287408378) | ||
165599 | 165599 | 68952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 747 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | Permit Number 32941 | 5988797.45218 | 2110217.11495 | 37.7736076654938 | -122.482210568345 | (37.7736076654938, -122.482210568345) | |
128926 | 128926 | 45513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44278 | 5988534.980140001 | 2095768.80664 | 37.733921213495 | -122.482059828009 | (37.733921213495, -122.482059828009) | |
132561 | 132561 | 45514 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 2 | Permit Number 44278 | 5988535.25971 | 2095760.7230900002 | 37.7338990344167 | -122.482058269478 | (37.7338990344167, -122.482058269478) | |
39453 | 39453 | 68949 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 726 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 4 | Permit Number 32938 | 5988844.72891 | 2110346.33242 | 37.7739652106004 | -122.48205650095699 | (37.7739652106004, -122.482056500957) | |
161168 | 161168 | 68950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 734 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32939 | 5988846.075 | 2110312.98983 | 37.7738737393837 | -122.482049401575 | (37.7738737393837, -122.482049401575) | |
135870 | 135870 | 68953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 750 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | 3x3 | Permit Number 32942 | 5988850.38114 | 2110206.21118 | 37.7735808052559 | -122.48202668229901 | (37.7735808052559, -122.482026682299) |
42627 | 42627 | 68954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | Permit Number 32943 | 5988851.01728 | 2110187.80327 | 37.7735302992339 | -122.482023133058 | (37.7735302992339, -122.482023133058) | |
184160 | 184160 | 45526 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3001 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/2001 12:00:00 AM | 3 | Permit Number 44287 | 5988554.87545 | 2095154.91197 | 37.732236774288396 | -122.481946089834 | (37.7322367742884, -122.481946089834) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");