Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
2988 | 2988 | 118173 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3221 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/2008 12:00:00 AM | 2 | Width 3ft | 5985542.20124 | 2111089.15517 | 37.7758121588594 | -122.49353507754299 | (37.7758121588594, -122.493535077543) | ||
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) | |
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) | ||
97698 | 97698 | 9253 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6500X Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 2X3 | 5986722.32109 | 2112597.81428 | 37.7800234720171 | -122.489563763122 | (37.7800234720171, -122.489563763122) | ||
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) | ||
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) | ||
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) | ||
128353 | 128353 | 432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 30 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
128148 | 128148 | 12774 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989637.59951 | 2114741.75598 | 37.7860799008728 | -122.479635529609 | (37.7860799008728, -122.479635529609) | ||
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) | ||
110986 | 110986 | 12738 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/2013 12:00:00 AM | 100 | 4x4 | 5990343.3046 | 2114764.5197400004 | 37.7861833727245 | -122.47719566934299 | (37.7861833727245, -122.477195669343) | ||
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) | |||
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) | |||
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) | ||
29751 | 29751 | 219429 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5992085.46562 | 2105232.9931400004 | 37.7601132972171 | -122.47047387378099 | (37.7601132972171, -122.470473873781) | |||
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) | ||
139995 | 139995 | 89410 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2026 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992351.89237 | 2112071.63774 | 37.778905786870006 | -122.470050395926 | (37.77890578687, -122.470050395926) | ||
85717 | 85717 | 89409 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2020 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992384.83285 | 2112073.6126 | 37.7789131134856 | -122.46993658655899 | (37.7789131134856, -122.469936586559) | ||
124759 | 124759 | 25215 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2411 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992017.8005099995 | 2094287.9738099999 | 37.730057167515604 | -122.469910986387 | (37.7300571675156, -122.469910986387) | ||
94151 | 94151 | 25287 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2390X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992028.41499 | 2094382.48626 | 37.7303172887062 | -122.469881169704 | (37.7303172887062, -122.469881169704) | ||
88106 | 88106 | 89406 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2016 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992454.35988 | 2112065.560542 | 37.778895023507204 | -122.469695480685 | (37.7788950235072, -122.469695480685) | ||
128548 | 128548 | 89408 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2016 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992454.35988 | 2112065.560542 | 37.778895023507204 | -122.469695480685 | (37.7788950235072, -122.469695480685) | ||
141649 | 141649 | 89407 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2016 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992454.35988 | 2112065.560542 | 37.778895023507204 | -122.469695480685 | (37.7788950235072, -122.469695480685) | ||
79386 | 79386 | 89701 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992461.7466589995 | 2112025.799575 | 37.7787862776475 | -122.469667031742 | (37.7787862776475, -122.469667031742) | ||
87722 | 87722 | 89704 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992461.7466589995 | 2112025.799575 | 37.7787862776475 | -122.469667031742 | (37.7787862776475, -122.469667031742) | ||
98205 | 98205 | 89702 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992461.7466589995 | 2112025.799575 | 37.7787862776475 | -122.469667031742 | (37.7787862776475, -122.469667031742) | ||
121331 | 121331 | 89703 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992461.7466589995 | 2112025.799575 | 37.7787862776475 | -122.469667031742 | (37.7787862776475, -122.469667031742) | ||
87763 | 87763 | 8934 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4630 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2002 12:00:00 AM | 3 | 2X2 | 5992661.51426 | 2112807.7475 | 37.7809448378746 | -122.46903288589701 | (37.7809448378746, -122.469032885897) | ||
101719 | 101719 | 89405 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1932 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992650.02375 | 2112083.7442099997 | 37.778956257991794 | -122.469019931283 | (37.7789562579918, -122.469019931283) | ||
99292 | 99292 | 89404 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1926 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992675.04364 | 2112084.25544 | 37.7789591072669 | -122.46893341544799 | (37.7789591072669, -122.468933415448) | ||
84485 | 84485 | 89706 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1945X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992682.1024279995 | 2112033.696052 | 37.7788206927431 | -122.46890531620701 | (37.7788206927431, -122.468905316207) | ||
100265 | 100265 | 89705 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1945X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992682.1024279995 | 2112033.696052 | 37.7788206927431 | -122.46890531620701 | (37.7788206927431, -122.468905316207) | ||
106406 | 106406 | 89707 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1945X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992682.1024279995 | 2112033.696052 | 37.7788206927431 | -122.46890531620701 | (37.7788206927431, -122.468905316207) | ||
91662 | 91662 | 89403 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1920 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992698.73667 | 2112085.38755 | 37.77896358458921 | -122.468851534899 | (37.7789635845892, -122.468851534899) | ||
120125 | 120125 | 89708 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1909 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992720.07551 | 2112029.7859799997 | 37.77881215056829 | -122.468773668914 | (37.7788121505683, -122.468773668914) | ||
121201 | 121201 | 89710 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1909 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992788.830333999 | 2112037.5206509996 | 37.7788373596805 | -122.46853638391 | (37.7788373596805, -122.46853638391) | ||
79807 | 79807 | 90353 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 833 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992966.98928 | 2111358.80702 | 37.7769840852214 | -122.467870688698 | (37.7769840852214, -122.467870688698) | ||
111445 | 111445 | 29664 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2232 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 5992636.99947 | 2093738.93892 | 37.7285854269889 | -122.467730442067 | (37.7285854269889, -122.467730442067) | ||||
628 | 628 | 251337 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
629 | 629 | 251338 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
112324 | 112324 | 25284 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 5992640.87111 | 2093746.9102599998 | 37.728607537869294 | -122.46771763720699 | (37.7286075378693, -122.467717637207) | ||
102213 | 102213 | 90354 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 829 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993063.797275 | 2111369.278291 | 37.777018426175395 | -122.467536564508 | (37.7770184261754, -122.467536564508) | ||
92244 | 92244 | 12608 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5993288.45121 | 2114872.37286 | 37.786649939560796 | -122.46701416661199 | (37.7866499395608, -122.467014166612) | |||
115801 | 115801 | 90157 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993228.84469 | 2111423.76728 | 37.7771775658601 | -122.46696958144699 | (37.7771775658601, -122.466969581447) | ||
19508 | 19508 | 90355 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 745 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993230.153419999 | 2111367.69142 | 37.777023672198794 | -122.46696097646699 | (37.7770236721988, -122.466960976467) | ||
92071 | 92071 | 89399 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5993250.39877 | 2112105.36057 | 37.7790502810604 | -122.466944583124 | (37.7790502810604, -122.466944583124) | ||
105470 | 105470 | 24672 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4411 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2003 12:00:00 AM | 3 | 3X3 | 5993331.5014 | 2112728.6564700003 | 37.7807663635721 | -122.466709338612 | (37.7807663635721, -122.466709338612) | ||
112547 | 112547 | 90356 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 703 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993355.75722 | 2111369.5077400003 | 37.777035908120105 | -122.46652660960699 | (37.7770359081201, -122.466526609607) | ||
97605 | 97605 | 90357 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 703 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993376.83467 | 2111370.3753299997 | 37.77703950654521 | -122.46645375983299 | (37.7770395065452, -122.466453759833) | ||
95934 | 95934 | 90156 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993383.45561 | 2111430.5438099997 | 37.7772050950409 | -122.466435230265 | (37.7772050950409, -122.466435230265) | ||
139084 | 139084 | 90155 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993415.010290001 | 2111431.72757 | 37.777210166062005 | -122.466326159524 | (37.777210166062, -122.466326159524) | ||
78532 | 78532 | 90359 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 641 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993550.82948 | 2111377.87735 | 37.7770701435768 | -122.46585240779699 | (37.7770701435768, -122.465852407797) | ||
182428 | 182428 | 111054 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 5993558.15565 | 2111433.38928 | 37.777222987024004 | -122.465831098866 | (37.777222987024, -122.465831098866) |
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");