Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88120 | 88120 | 117006 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
108687 | 108687 | 117004 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
122779 | 122779 | 117005 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2131x 48TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778271 | 5981288.0 | 2100567.0 | 37.7466715647644 | -122.50747029290599 | (37.7466715647644, -122.507470292906) | |
154 | 154 | 830 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1384 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:15:00 PM | 3 | 5.5x6.5 | 5981549.5887 | 2105676.5499 | 37.7607163481902 | -122.506944712409 | (37.7607163481902, -122.506944712409) | ||
163695 | 163695 | 117668 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4826 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5983640.52001 | 2111755.82857 | 37.7775312233534 | -122.500162667158 | (37.7775312233534, -122.500162667158) | |||
101853 | 101853 | 89576 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4825 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983661.38159 | 2111702.27488 | 37.7773854048537 | -122.500086541243 | (37.7773854048537, -122.500086541243) | ||
97981 | 97981 | 89577 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4801X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983707.84723 | 2111706.4900599997 | 37.7773997054666 | -122.49992611559901 | (37.7773997054666, -122.499926115599) | ||
109594 | 109594 | 89582 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4701X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984008.478209999 | 2111715.2739 | 37.777441461332394 | -122.498886799858 | (37.7774414613324, -122.498886799858) | ||
4434 | 4434 | 253623 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.422619999 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | |
141428 | 141428 | 89585 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4645 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984165.0432400005 | 2111720.8088599998 | 37.777465840754296 | -122.498345607104 | (37.7774658407543, -122.498345607104) | ||
123217 | 123217 | 89589 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4645 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984245.3294400005 | 2111722.52512 | 37.777475260664794 | -122.498068001639 | (37.7774752606648, -122.498068001639) | ||
78607 | 78607 | 89592 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4617 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984322.41803 | 2111726.32769 | 37.777490220874 | -122.497801611618 | (37.777490220874, -122.497801611618) | ||
115076 | 115076 | 89593 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4601 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984340.25628 | 2111726.55221 | 37.7774918830532 | -122.497739920719 | (37.7774918830532, -122.497739920719) | ||
83556 | 83556 | 90922 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4601 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5984359.943030001 | 2111727.94801 | 37.777496869554206 | -122.497671921843 | (37.7774968695542, -122.497671921843) | ||
115257 | 115257 | 89596 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4433 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984874.01368 | 2111746.5723599996 | 37.7775781275582 | -122.495894981455 | (37.7775781275582, -122.495894981455) | ||
85908 | 85908 | 89598 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4417 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984943.344959999 | 2111748.4465099997 | 37.777587333707 | -122.49565528309999 | (37.777587333707, -122.4956552831) | ||
113984 | 113984 | 89599 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4411 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984967.81227 | 2111748.98363 | 37.7775902412553 | -122.495570683326 | (37.7775902412553, -122.495570683326) | ||
96304 | 96304 | 89600 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4335 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985191.65818 | 2111758.32829 | 37.777629004290205 | -122.494797025483 | (37.7776290042902, -122.494797025483) | ||
145364 | 145364 | 109041 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1638 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773601 | 5985043.8 | 2104034.4 | 37.7564126199144 | -122.49473890921699 | (37.7564126199144, -122.494738909217) |
116695 | 116695 | 89605 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4249X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985413.92105 | 2111766.13498 | 37.7776634467966 | -122.49402872965099 | (37.7776634467966, -122.494028729651) | ||
134090 | 134090 | 65079 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3255 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1989 12:00:00 AM | 3 | Permit Number 27043 | 5985440.9852599995 | 2111085.56905 | 37.7757963909815 | -122.49388493990101 | (37.7757963909815, -122.493884939901) | ||
95005 | 95005 | 90923 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5985467.79642 | 2111768.32537 | 37.7776726131943 | -122.493842520581 | (37.7776726131943, -122.493842520581) | ||
59804 | 59804 | 118171 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3239 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5985480.725380001 | 2111087.37265 | 37.7758036681834 | -122.493747603691 | (37.7758036681834, -122.493747603691) | |||
121920 | 121920 | 89606 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4227 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985517.60906 | 2111769.02888 | 37.777677459076 | -122.493670256038 | (37.777677459076, -122.493670256038) | ||
100815 | 100815 | 89607 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4225 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985540.508119999 | 2111770.83497 | 37.777683757686894 | -122.493591174643 | (37.7776837576869, -122.493591174643) | ||
78696 | 78696 | 89608 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4215 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985569.57732 | 2111771.09823 | 37.7776861810077 | -122.493490635217 | (37.7776861810077, -122.493490635217) | ||
141726 | 141726 | 89609 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4201X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985583.60476 | 2111772.38766 | 37.7776905419571 | -122.493442205243 | (37.7776905419571, -122.493442205243) | ||
84204 | 84204 | 89610 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4201X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2015 07:01:00 AM | 3 | 3x3 | 5985601.86481 | 2111772.70436 | 37.7776924796275 | -122.49337906174401 | (37.7776924796275, -122.493379061744) | ||
143779 | 143779 | 90972 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3227 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5985599.860262999 | 2111098.856457 | 37.7758421685745 | -122.49333633811001 | (37.7758421685745, -122.49333633811) | |
106496 | 106496 | 109917 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1627 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775114 | 5985575.9 | 2104128.7 | 37.7567026728441 | -122.492905692842 | (37.7567026728441, -122.492905692842) |
120341 | 120341 | 89613 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4127 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985830.11482 | 2111781.78124 | 37.777730750542 | -122.49259014689 | (37.777730750542, -122.49259014689) | ||
108571 | 108571 | 95509 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:37:00 PM | 3 | 3x3 | 5985988.58257 | 2112092.73248 | 37.7785937981587 | -122.492064860632 | (37.7785937981587, -122.492064860632) | ||
112142 | 112142 | 95511 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:32:00 PM | 3 | 3x3 | 5985988.37339 | 2112068.78219 | 37.7785280252799 | -122.492063820389 | (37.7785280252799, -122.492063820389) | ||
120188 | 120188 | 95514 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | ||
96802 | 96802 | 95494 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.2940599998 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | |||
117880 | 117880 | 95486 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.777104032517705 | -122.49195980083701 | (37.7771040325177, -122.491959800837) | |||
111692 | 111692 | 95487 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986008.46306 | 2111529.3689900003 | 37.777048124873296 | -122.49195459962401 | (37.7770481248733, -122.491954599624) | |||
141798 | 141798 | 95490 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.49195251911199 | (37.7768664240251, -122.491952519112) | |||
94030 | 94030 | 95491 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.776807227327396 | -122.491945237383 | (37.7768072273274, -122.491945237383) | |||
111058 | 111058 | 117123 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2550 34TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2016 12:00:00 AM | 3 | 3x3 | 5985875.0 | 2097864.0 | 37.7395189911199 | -122.491410221624 | (37.7395189911199, -122.491410221624) | ||
127315 | 127315 | 117122 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2550 34TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2016 12:00:00 AM | 3 | 3x3 | 5985875.0 | 2097864.0 | 37.7395189911199 | -122.491410221624 | (37.7395189911199, -122.491410221624) | ||
82941 | 82941 | 109034 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2042 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772948 | 5986068.5 | 2101324.0 | 37.749030526651396 | -122.490995740125 | (37.7490305266514, -122.490995740125) |
142087 | 142087 | 24688 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6509 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 3X3 | 5986810.4488699995 | 2112493.43144 | 37.7797420110575 | -122.48925121679501 | (37.7797420110575, -122.489251216795) | ||
144382 | 144382 | 9239 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6406 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/1996 12:00:00 AM | 3 | 3X3 | 5987099.50219 | 2112606.70022 | 37.780069883306396 | -122.488259594393 | (37.7800698833064, -122.488259594393) | ||
148278 | 148278 | 114811 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2382 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 3 | Permit Number 774444 | 5987696.7 | 2099087.7 | 37.7429852324249 | -122.48520141926501 | (37.7429852324249, -122.485201419265) | ||
92169 | 92169 | 86485 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 3 | 3x3 | 5987816.321957 | 2103904.0922479997 | 37.7562167246282 | -122.48514111531401 | (37.7562167246282, -122.485141115314) | ||
61309 | 61309 | 120173 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2350 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5988251.07109 | 2111245.15539 | 37.7763985819689 | -122.484175967181 | (37.7763985819689, -122.484175967181) | |||
89845 | 89845 | 90210 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2326 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988313.82257 | 2111246.42734 | 37.77640572777071 | -122.483958988115 | (37.7764057277707, -122.483958988115) | ||
98157 | 98157 | 90211 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2349X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988326.615747 | 2111197.527168 | 37.77627220634061 | -122.48391114694901 | (37.7762722063406, -122.483911146949) | |
120567 | 120567 | 90212 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2349X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988326.615747 | 2111197.527168 | 37.77627220634061 | -122.48391114694901 | (37.7762722063406, -122.483911146949) | |
125363 | 125363 | 90311 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2301X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988408.1891 | 2111191.58958 | 37.7762606518611 | -122.483628530276 | (37.7762606518611, -122.483628530276) | ||
81699 | 81699 | 90315 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2223 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2013 12:00:00 AM | 3 | 3x3 | 5988645.63956 | 2111200.47975 | 37.776298880204 | -122.48280778540399 | (37.776298880204, -122.482807785404) | ||
142427 | 142427 | 90208 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200 Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988661.7243099995 | 2111260.74112 | 37.776465276961495 | -122.482756561669 | (37.7764652769615, -122.482756561669) | ||
93175 | 93175 | 90207 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988676.58265 | 2111263.0287900004 | 37.7764724227331 | -122.482705330746 | (37.7764724227331, -122.482705330746) | ||
78025 | 78025 | 90206 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988691.79386 | 2111261.40523 | 37.7764688498652 | -122.482652592467 | (37.7764688498652, -122.482652592467) | ||
96720 | 96720 | 90205 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988707.94917 | 2111263.23177 | 37.776474804910706 | -122.482596841197 | (37.7764748049107, -122.482596841197) | ||
124007 | 124007 | 90317 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2201 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988709.47334 | 2111203.76821 | 37.776311623226704 | -122.482587210366 | (37.7763116232267, -122.482587210366) | ||
112454 | 112454 | 90204 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988722.31709 | 2111262.92734 | 37.7764748048988 | -122.48254711675101 | (37.7764748048988, -122.482547116751) | ||
123431 | 123431 | 90203 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2150 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988896.70317 | 2111270.07707 | 37.7765045794788 | -122.481944396621 | (37.7765045794788, -122.481944396621) | ||
122603 | 122603 | 90202 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2126 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988930.45853 | 2111269.74122 | 37.7765056204004 | -122.481827603939 | (37.7765056204004, -122.481827603939) | ||
143563 | 143563 | 90201 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2120 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988977.25969 | 2111268.8045799998 | 37.77650577021821 | -122.481665638612 | (37.7765057702182, -122.481665638612) | ||
116647 | 116647 | 81972 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1822 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774361 | 5989407.90008391 | 2102936.76390687 | 37.7536532824256 | -122.47956618379699 | (37.7536532824256, -122.479566183797) | |
141833 | 141833 | 109934 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1890 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775172 | 5989442.7 | 2102500.8 | 37.7524582627735 | -122.479413946447 | (37.7524582627735, -122.479413946447) |
58391 | 58391 | 182082 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1109 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2017 12:00:00 AM | 3 | Width 0ft | 5989746.1732 | 2098995.6798 | 37.7428517447762 | -122.47810825386001 | (37.7428517447762, -122.47810825386) | ||
103314 | 103314 | 120914 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1356 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2016 12:00:00 AM | 3 | 3x3 | 5989939.0 | 2106143.0 | 37.7624875866057 | -122.477963922005 | (37.7624875866057, -122.477963922005) | ||
78095 | 78095 | 109876 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1631 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775090 | 5989917.1 | 2104254.5 | 37.7573010006541 | -122.47790160153099 | (37.7573010006541, -122.477901601531) |
9629 | 9629 | 173614 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
9631 | 9631 | 173613 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2955 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776469 | 5990236.78382 | 2095590.4495400002 | 37.7335303227244 | -122.476163213901 | (37.7335303227244, -122.476163213901) | |
86334 | 86334 | 108517 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1474 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773664 | 5990869.49269 | 2105368.92693 | 37.7604161511877 | -122.474689222748 | (37.7604161511877, -122.474689222748) | |
116584 | 116584 | 108520 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1831 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773667 | 5990912.6193699995 | 2102936.28032 | 37.7537392459439 | -122.47436254716699 | (37.7537392459439, -122.474362547167) |
86622 | 86622 | 108522 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2059 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773673 | 5990965.153 | 2101394.10507 | 37.7495078797857 | -122.474068362776 | (37.7495078797857, -122.474068362776) |
22883 | 22883 | 87745 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991511.567969999 | 2113344.3212599996 | 37.7823516120795 | -122.47305021920299 | (37.7823516120795, -122.473050219203) | |
57224 | 57224 | 87746 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991512.22402 | 2113324.82166 | 37.7822981095395 | -122.473046527131 | (37.7822981095395, -122.473046527131) | |
53168 | 53168 | 87747 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991512.01725 | 2113306.58012 | 37.7822480113305 | -122.47304591178002 | (37.7822480113305, -122.47304591178) | |
175899 | 175899 | 87748 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991513.0366 | 2113287.42682 | 37.7821954806674 | -122.473040988135 | (37.7821954806674, -122.473040988135) | |
65890 | 65890 | 87749 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991514.533340001 | 2113265.60658 | 37.782135654960705 | -122.473034218414 | (37.7821356549607, -122.473034218414) | |
137186 | 137186 | 87750 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 14th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50407 | 5991514.7964699995 | 2113244.34344 | 37.782077287475 | -122.473031757031 | (37.782077287475, -122.473031757031) | |
123665 | 123665 | 29663 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200X Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5991214.62649 | 2094785.7483599999 | 37.731377471178206 | -122.472723912001 | (37.7313774711782, -122.472723912001) | |||
68298 | 68298 | 122211 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 625 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991587.96323 | 2111267.7684 | 37.7766543901163 | -122.472634479797 | (37.7766543901163, -122.472634479797) | |||
186784 | 186784 | 52475 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 576 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48585 | 5991930.93358 | 2111531.3322 | 37.7773979112296 | -122.471467265516 | (37.7773979112296, -122.471467265516) |
112671 | 112671 | 108503 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1434 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773648 | 5991820.21793 | 2105663.11685 | 37.7612789627151 | -122.47142257169901 | (37.7612789627151, -122.471422571699) |
66587 | 66587 | 123808 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2151 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991966.40505 | 2111998.3672599997 | 37.77868231411921 | -122.47137859728998 | (37.7786823141192, -122.47137859729) | |||
66472 | 66472 | 123807 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2151 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991989.873319999 | 2111999.7088200003 | 37.778687355231 | -122.471297509983 | (37.778687355231, -122.471297509983) | |||
98546 | 98546 | 89418 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2130 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2015 08:44:00 AM | 3 | 3x3 | 5991995.68267 | 2112058.53443 | 37.7788492103386 | -122.47128170052 | (37.7788492103386, -122.47128170052) | ||
86128 | 86128 | 89417 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2130 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992009.84673 | 2112059.57009 | 37.7788528732841 | -122.471232777372 | (37.7788528732841, -122.471232777372) | ||
95107 | 95107 | 89416 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2130 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992026.51525 | 2112059.36737 | 37.778853280818 | -122.471175100136 | (37.778853280818, -122.471175100136) | ||
84148 | 84148 | 89695 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2155 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992032.589849 | 2112010.420559 | 37.7787192375961 | -122.47115051893299 | (37.7787192375961, -122.471150518933) | ||
128607 | 128607 | 89693 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2155X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992032.589849 | 2112010.420559 | 37.7787192375961 | -122.47115051893299 | (37.7787192375961, -122.471150518933) | ||
142791 | 142791 | 89694 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2155 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992032.589849 | 2112010.420559 | 37.7787192375961 | -122.47115051893299 | (37.7787192375961, -122.471150518933) | ||
119927 | 119927 | 24668 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4811 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/1996 12:00:00 AM | 3 | 5992048.30267 | 2112682.96618 | 37.7805667728826 | -122.47114517365699 | (37.7805667728826, -122.471145173657) | |||
87459 | 87459 | 109050 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 48 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773230 | 5991933.0 | 2104990.6 | 37.7594389326357 | -122.470983516472 | (37.7594389326357, -122.470983516472) |
79745 | 79745 | 89696 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2101 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992083.25787 | 2112006.9207200003 | 37.778712558544996 | -122.470974985133 | (37.778712558545, -122.470974985133) | ||
86328 | 86328 | 89697 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2101 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992123.80409 | 2112006.3291599997 | 37.7787132792189 | -122.470834678186 | (37.7787132792189, -122.470834678186) | ||
122288 | 122288 | 89415 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2100X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992153.7416 | 2112063.95125 | 37.7788732250553 | -122.470735311921 | (37.7788732250553, -122.470735311921) | ||
103475 | 103475 | 89698 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2045 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992248.56439 | 2112009.3415 | 37.7787287645821 | -122.470403307178 | (37.7787287645821, -122.470403307178) | ||
101814 | 101814 | 89414 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2040 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992264.76767 | 2112069.76613 | 37.7788956109976 | -122.470351655835 | (37.7788956109976, -122.470351655835) | ||
97144 | 97144 | 89699 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2045 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992267.68335 | 2112010.1178099997 | 37.7787320015375 | -122.47033722440001 | (37.7787320015375, -122.4703372244) | ||
83727 | 83727 | 89413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2040 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992290.09129 | 2112070.56721 | 37.778899274659096 | -122.47026411052099 | (37.7788992746591, -122.470264110521) | ||
124647 | 124647 | 89412 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2040 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992306.33207 | 2112071.26295 | 37.7789021239167 | -122.47020797839501 | (37.7789021239167, -122.470207978395) | ||
127985 | 127985 | 89700 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2045 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992309.86998 | 2112012.37679 | 37.7787406430958 | -122.47019145027399 | (37.7787406430958, -122.470191450274) |
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");