trees
1,813 rows where qSpecies_id = 149 sorted by qAddress
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24363 | 123882 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992074.12323 | 2114872.38939 | 37.7865798197895 | -122.471215410226 | (37.7865798197895, -122.471215410226) | 11 | 6 | 1 | 54 | 11 | |||
40014 | 123883 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992072.43189 | 2114857.09467 | 37.7865377268901 | -122.471220147048 | (37.7865377268901, -122.471220147048) | 11 | 6 | 1 | 54 | 11 | |||
166384 | 68446 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32303 | 5992072.75481 | 2114889.39534 | 37.7866264342674 | -122.471221384048 | (37.7866264342674, -122.471221384048) | 11 | 6 | 1 | 54 | 11 | ||
54322 | 136918 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001921.35919 | 2120601.27583 | 37.8028745199931 | -122.437556861278 | (37.8028745199931, -122.437556861278) | 13 | 9 | 1 | 57 | 17 | |||
102266 | 30665 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1 McCoppin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | 8 | 2 | 9 | 28853 | 19 | ||
172345 | 30666 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1 McCoppin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | 8 | 2 | 9 | 28853 | 19 | ||
8450 | 79034 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 2.5x4 | 6010138.62156 | 2111398.24518 | 37.7780689795412 | -122.408471225064 | (37.7780689795412, -122.408471225064) | 14 | 2 | 9 | 28853 | 34 | |||
43922 | 36268 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.7301889867506 | -122.472648886457 | (37.7301889867506, -122.472648886457) | 9 | 8 | 4 | 64 | 40 | ||
84617 | 36269 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.7301889867506 | -122.472648886457 | (37.7301889867506, -122.472648886457) | 9 | 8 | 4 | 64 | 40 | ||
150715 | 36271 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10 Rossmoor Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.7301889867506 | -122.472648886457 | (37.7301889867506, -122.472648886457) | 9 | 8 | 4 | 64 | 40 | ||
161864 | 36270 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.7301889867506 | -122.472648886457 | (37.7301889867506, -122.472648886457) | 9 | 8 | 4 | 64 | 40 | ||
125455 | 201659 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 100 Dore St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6009071.00052 | 2109601.78003 | 37.7730764624533 | -122.412037534313 | (37.7730764624533, -122.412037534313) | 8 | 2 | 9 | 28853 | 34 | |||
152647 | 201658 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 100 Dore St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6009046.73839 | 2109625.79413 | 37.7731410382526 | -122.412123157881 | (37.7731410382526, -122.412123157881) | 8 | 2 | 9 | 28853 | 34 | |||
15672 | 75766 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 100 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009894.26848 | 2094011.07374 | 37.730314000377 | -122.408090001562 | (37.730314000377, -122.408090001562) | 10 | 3 | 7 | 309 | 28 | |||
38120 | 249573 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1001 Franklin St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6006042.70778 | 2113571.74375 | 37.7838066452086 | -122.422794986325 | (37.7838066452086, -122.422794986325) | 7 | 9 | 11 | 28858 | 41 | |||
127761 | 7871 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1001 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | 3 | 3X3 | 6006017.92474 | 2113680.12204 | 37.7841028269903 | -122.422888431641 | (37.7841028269903, -122.422888431641) | 7 | 9 | 11 | 28858 | 41 | ||
192388 | 219436 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1001 Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990892.67595 | 2102441.87183 | 37.7523805746122 | -122.474395438619 | (37.7523805746122, -122.474395438619) | 1 | 8 | 4 | 29491 | 12 | |||
71820 | 114541 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1001X Rhode Island St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011939.68484 | 2103650.19837 | 37.756895288204 | -122.401695928834 | (37.756895288204, -122.401695928834) | 10 | 3 | 8 | 28856 | 29 | ||
134657 | 50819 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1009 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47342 | 6010039.41742764 | 2112370.40849241 | 37.7807327551096 | -122.408883016506 | (37.7807327551096, -122.408883016506) | 14 | 2 | 9 | 28853 | 34 | |||
135213 | 50820 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1009 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | 4 | Permit Number 47342 | 6010026.22608 | 2112350.59085 | 37.7806776016324 | -122.408927253305 | (37.7806776016324, -122.408927253305) | 14 | 2 | 9 | 28853 | 34 | ||
97748 | 90134 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 100X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995229.54942 | 2111496.31673 | 37.7774920413779 | -122.460053813186 | (37.7774920413779, -122.460053813186) | 11 | 6 | 2 | 54 | 11 | ||
69314 | 90380 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995315.581431 | 2111451.352271 | 37.7773735286818 | -122.459752944165 | (37.7773735286818, -122.459752944165) | 11 | 6 | 2 | 54 | 11 | ||
89107 | 123720 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | Width 3ft | 5995264.25203 | 2111440.07761 | 37.7773396195467 | -122.459929691175 | (37.7773396195467, -122.459929691175) | 11 | 6 | 2 | 54 | 11 | ||
17554 | 75004 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5997965.54363 | 2116098.57851 | 37.7902856238171 | -122.450921084564 | (37.7902856238171, -122.450921084564) | 11 | 6 | 1 | 54 | 31 | |||
126922 | 136919 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Laurel St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 5997971.7056 | 2116051.11151 | 37.790155644821 | -122.450896340588 | (37.790155644821, -122.450896340588) | 11 | 6 | 1 | 54 | 31 | |||
7065 | 198271 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Pennsylvania Ave | 17 | Front Yard : Yard | Tree | Private 2 | 1 | 6014323.67834 | 2106481.09805 | 37.7648010700346 | -122.393649256519 | (37.7648010700346, -122.393649256519) | 14 | 3 | 8 | 310 | 29 | ||||
134600 | 198273 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Pennsylvania Ave | 39 | Front Yard : Yard | Tree | Private 2 | 1 | 6014246.68754 | 2106694.71244 | 37.7653833298046 | -122.393930504207 | (37.7653833298046, -122.393930504207) | 14 | 3 | 8 | 28856 | 20 | ||||
144701 | 198272 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Pennsylvania Ave | 30 | Front Yard : Yard | Tree | Private 2 | 1 | 6014300.74273 | 2106595.72792 | 37.7651145440253 | -122.393736609482 | (37.7651145440253, -122.393736609482) | 14 | 3 | 8 | 310 | 29 | ||||
191639 | 198270 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Pennsylvania Ave | 9 | Front Yard : Yard | Tree | Private 2 | 1 | 6014327.71922 | 2106393.16587 | 37.764559852075 | -122.393629125211 | (37.764559852075, -122.393629125211) | 14 | 3 | 8 | 310 | 29 | ||||
16493 | 137733 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000662.3069 | 2112624.2642 | 37.7809000665618 | -122.441341105044 | (37.7809000665618, -122.441341105044) | 15 | 5 | 1 | 29490 | 16 | |||
3156 | 115362 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101X Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6012895.14842 | 2106528.52357 | 37.7648518070998 | -122.398593533074 | (37.7648518070998, -122.398593533074) | 14 | 3 | 8 | 28856 | 29 | |||
110550 | 104489 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 101X Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6012893.40207 | 2106545.47227 | 37.7648982471715 | -122.398600762736 | (37.7648982471715, -122.398600762736) | 14 | 3 | 8 | 28856 | 29 | |||
135653 | 136937 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1020 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009944.47498 | 2116838.41797 | 37.792995521282 | -122.409526902355 | (37.792995521282, -122.409526902355) | 3 | 1 | 10 | 28857 | 21 | |||
162745 | 59489 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1029 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51129 | 6011954.00169 | 2103318.43549 | 37.7559851392284 | -122.401623098137 | (37.7559851392284, -122.401623098137) | 10 | 3 | 8 | 28856 | 29 | |
65393 | 10171 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1032 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 7x4 | Permit Number 779560 | 6005695.79144 | 2102951.17521 | 37.7546255252659 | -122.423239982539 | (37.7546255252659, -122.423239982539) | 2 | 4 | 5 | 28859 | 19 | |
25239 | 41779 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1033 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42192 | 6009731.77420403 | 2117422.91465756 | 37.7945884864643 | -122.410304149551 | (37.7945884864643, -122.410304149551) | 3 | 1 | 10 | 28857 | 21 | ||
80885 | 41780 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1033 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42192 | 6009731.77420403 | 2117422.91465756 | 37.7945884864643 | -122.410304149551 | (37.7945884864643, -122.410304149551) | 3 | 1 | 10 | 28857 | 21 | ||
137581 | 242339 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1035 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001342.6727 | 2100671.21248 | 37.7481186622553 | -122.438130887736 | (37.7481186622553, -122.438130887736) | 2 | 4 | 5 | 28862 | 22 | |||
162420 | 53053 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1042 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2006 12:00:00 AM | 5 | 3x3 | Permit Number 49030 | 6015494.75997 | 2104280.44649 | 37.7588235587865 | -122.389445058145 | (37.7588235587865, -122.389445058145) | 10 | 3 | 8 | 28856 | 29 | |
36483 | 7875 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1050 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2014 02:38:00 PM | 3 | 4X4 | 6006070.45315 | 2113764.99096 | 37.7843388199314 | -122.422712735214 | (37.7843388199314, -122.422712735214) | 7 | 9 | 11 | 28858 | 41 | ||
167318 | 242887 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1050 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005696.3409 | 2102856.44643 | 37.754365453022 | -122.423231349069 | (37.754365453022, -122.423231349069) | 2 | 4 | 5 | 28859 | 19 | |||
5851 | 242898 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1050 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009967.25969 | 2103043.92706 | 37.7551203376501 | -122.408474577742 | (37.7551203376501, -122.408474577742) | 2 | 4 | 7 | 28859 | 19 | |||
22558 | 242899 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1050 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009967.68817 | 2103026.2265 | 37.7550717598627 | -122.408471847423 | (37.7550717598627, -122.408471847423) | 2 | 4 | 7 | 28859 | 19 | |||
77272 | 242900 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1050 York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009967.37558 | 2103010.90025 | 37.7550296598983 | -122.408471847422 | (37.7550296598983, -122.408471847422) | 2 | 4 | 7 | 28859 | 19 | |||
131902 | 28488 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1056 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2004 12:00:00 AM | 12 | 3X3 | 6005699.27295 | 2102829.04001 | 37.754290366819 | -122.423219261259 | (37.754290366819, -122.423219261259) | 2 | 4 | 5 | 28859 | 19 | ||
163732 | 47248 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1060 Key Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/2011 12:00:00 AM | Permit Number 767222 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.396767210117 | (37.7194581178311, -122.396767210117) | 10 | 3 | 8 | 58 | 1 | ||
148367 | 51380 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1061 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | Permit Number 47711 | 6010569.99694283 | 2111124.83155789 | 37.7773423979358 | -122.406959659675 | (37.7773423979358, -122.406959659675) | 14 | 2 | 9 | 28853 | 34 | ||
186039 | 51379 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1061 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2005 12:00:00 AM | Permit Number 47711 | 6010569.99694283 | 2111124.83155789 | 37.7773423979358 | -122.406959659675 | (37.7773423979358, -122.406959659675) | 14 | 2 | 9 | 28853 | 34 | ||
38013 | 198416 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1062 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013254.09143 | 2089864.52529 | 37.7191159651107 | -122.396184055957 | (37.7191159651107, -122.396184055957) | 10 | 3 | 8 | 58 | 1 | |||
116589 | 198418 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1062 Key Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013212.31335 | 2089895.25282 | 37.7191980120665 | -122.396330620284 | (37.7191980120665, -122.396330620284) | 10 | 3 | 8 | 58 | 1 | |||
157636 | 198417 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1062 Key Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013234.80615 | 2089878.55725 | 37.7191534209806 | -122.396251701163 | (37.7191534209806, -122.396251701163) | 10 | 3 | 8 | 58 | 1 | |||
131695 | 5583 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1069 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005153.43733 | 2102137.63056 | 37.7523610980069 | -122.425057708473 | (37.7523610980069, -122.425057708473) | 2 | 4 | 5 | 28859 | 19 | |||
37588 | 242329 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 107 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005095.86246 | 2099583.89393 | 37.7453458734257 | -122.425075124737 | (37.7453458734257, -122.425075124737) | 2 | 7 | 5 | 63 | 22 | |||
1706 | 124216 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 107 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5996487.33444 | 2112259.12921 | 37.7796587851836 | -122.455757897014 | (37.7796587851836, -122.455757897014) | 11 | 6 | 2 | 54 | 16 | |||
28552 | 90378 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 109 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995235.89082 | 2111438.83153 | 37.7773345670003 | -122.460027710853 | (37.7773345670003, -122.460027710853) | 11 | 6 | 2 | 54 | 11 | ||
94109 | 90379 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 109 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995291.794305 | 2111450.466195 | 37.7773697278094 | -122.459835166842 | (37.7773697278094, -122.459835166842) | 11 | 6 | 2 | 54 | 11 | ||
88016 | 51896 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 109 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.456385274642 | (37.7148543797151, -122.456385274642) | 9 | 8 | 6 | 28861 | 24 | |||
113731 | 51895 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 109 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.456385274642 | (37.7148543797151, -122.456385274642) | 9 | 8 | 6 | 28861 | 24 | |||
4398 | 149806 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1095 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2020 12:00:00 AM | 3 | Width 4 | 6015039.51636 | 2103405.11411 | 37.7563948325734 | -122.390958336561 | (37.7563948325734, -122.390958336561) | 10 | 3 | 8 | 28856 | 29 | ||
66712 | 17243 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 10X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2003 12:00:00 AM | 6 | 3X34 | 5993969.30173 | 2088537.74626 | 37.7143810447114 | -122.462747471174 | (37.7143810447114, -122.462747471174) | 9 | 8 | 6 | 64 | 24 | ||
188507 | 45539 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 11 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2001 12:00:00 AM | Permit Number 44294 | 5987258.11223173 | 2095792.07894073 | 37.7339107660531 | -122.486476000297 | (37.7339107660531, -122.486476000297) | 1 | 8 | 4 | 64 | 35 | ||
188911 | 242330 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 110 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005175.96727 | 2099631.57497 | 37.7454813194008 | -122.424801526695 | (37.7454813194008, -122.424801526695) | 2 | 7 | 5 | 63 | 22 | |||
11812 | 241417 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 110 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 785523 | 6004524.68295 | 2095964.43408 | 37.7353753785744 | -122.426792456628 | (37.7353753785744, -122.426792456628) | 2 | 7 | 5 | 28861 | 2 | |
51757 | 242888 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005717.87384 | 2102519.39452 | 37.7534412017532 | -122.423132926343 | (37.7534412017532, -122.423132926343) | 2 | 4 | 5 | 28859 | 19 | |||
13279 | 108789 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
48321 | 108786 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
68022 | 108785 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
107282 | 108787 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
187308 | 108788 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
96499 | 180414 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1104x Alemany Blvd | 4 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6003758.53299 | 2094425.58203 | 37.7311066907099 | -122.42933162228 | (37.7311066907099, -122.42933162228) | 9 | 7 | 6 | 28861 | 25 | |||
185999 | 180413 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1104x Alemany Blvd | 3 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6003786.93346 | 2094435.44924 | 37.731135391684 | -122.42923414026 | (37.731135391684, -122.42923414026) | 9 | 7 | 6 | 28861 | 25 | |||
187404 | 180412 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1104x Alemany Blvd | 2 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6003814.30975 | 2094445.54262 | 37.7311646556118 | -122.429140215055 | (37.7311646556118, -122.429140215055) | 9 | 7 | 6 | 28861 | 25 | |||
105363 | 87717 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1107 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5996451.82773 | 2091748.49661 | 37.7233396801105 | -122.454398718898 | (37.7233396801105, -122.454398718898) | 9 | 8 | 4 | 28861 | 24 | |||
73395 | 182082 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1109 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2017 12:00:00 AM | 3 | Width 0ft | 5989746.1732 | 2098995.6798 | 37.7428517447762 | -122.47810825386 | (37.7428517447762, -122.47810825386) | 1 | 8 | 3 | 29491 | 35 | ||
87146 | 25288 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 110X Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1996 12:00:00 AM | 10 | 3x3 | 6000890.43944 | 2091777.01619 | 37.7236715433472 | -122.439057348963 | (37.7236715433472, -122.439057348963) | 9 | 7 | 6 | 28861 | 25 | ||
105418 | 50483 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 111 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2003 12:00:00 AM | 5 | Permit Number 47118 | 5987691.11202 | 2115193.54019 | 37.787207107765 | -122.486402950055 | (37.787207107765, -122.486402950055) | 11 | 6 | 1 | 55 | 33 | ||
76528 | 242915 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 111 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005066.82423 | 2099579.80768 | 37.7453330131246 | -122.425175243547 | (37.7453330131246, -122.425175243547) | 2 | 7 | 5 | 63 | 22 | |||
40359 | 123719 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 111 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995199.7628 | 2111434.37432 | 37.7773202507317 | -122.460152365551 | (37.7773202507317, -122.460152365551) | 11 | 6 | 2 | 54 | 11 | |||
45750 | 94664 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 111 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53801 | 6004018 | 2095241 | 37.7333603312135 | -122.428492699505 | (37.7333603312135, -122.428492699505) | 9 | 7 | 5 | 28861 | 25 | |
24559 | 475 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1110X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2015 06:40:00 PM | 3 | 3x3 | 6005715.8108342 | 2102491.4524088 | 37.753364362762 | -122.423138074678 | (37.753364362762, -122.423138074678) | 2 | 4 | 5 | 28859 | 19 | ||
77364 | 81458 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1111 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49734 | 5989787.55086775 | 2099004.4958045 | 37.7428783529268 | -122.47796582741 | (37.7428783529268, -122.47796582741) | 1 | 8 | 3 | 29491 | 35 | ||
87813 | 49804 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1112SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 5 | Permit Number 46599 | 6014208.95643 | 2105755.12489 | 37.7628013312333 | -122.393995228408 | (37.7628013312333, -122.393995228408) | 14 | 3 | 8 | 28856 | 29 | |
143020 | 42200 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1114 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | 8 | 2 | 9 | 28853 | 34 | ||
154129 | 42199 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1114 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | 8 | 2 | 9 | 28853 | 34 | ||
159744 | 42201 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1114 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | 8 | 2 | 9 | 28853 | 34 | ||
67111 | 31660 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1120 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1995 12:00:00 AM | 11 | Permit Number 35168 | 6009328.60385 | 2117080.0959 | 37.7936245817471 | -122.411674942066 | (37.7936245817471, -122.411674942066) | 3 | 1 | 10 | 28857 | 21 | ||
65714 | 10186 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1130 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2015 04:47:00 AM | 3 | 4x5 | 6005723.69305 | 2102361.07491 | 37.7530068211173 | -122.423101549889 | (37.7530068211173, -122.423101549889) | 2 | 4 | 5 | 28859 | 19 | ||
30559 | 180422 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 10 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003342.53075 | 2094283.93013 | 37.7306941860739 | -122.430759708819 | (37.7306941860739, -122.430759708819) | 9 | 7 | 6 | 28861 | 25 | |||
43334 | 180421 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 9 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003365.77706 | 2094291.48085 | 37.7307162356701 | -122.430679881378 | (37.7307162356701, -122.430679881378) | 9 | 7 | 6 | 28861 | 25 | |||
71443 | 180417 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003506.26836 | 2094339.16968 | 37.7308551368386 | -122.430197582161 | (37.7308551368386, -122.430197582161) | 9 | 7 | 6 | 28861 | 25 | |||
90201 | 180415 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003554.97456 | 2094355.58631 | 37.7309029717957 | -122.430030367629 | (37.7309029717957, -122.430030367629) | 9 | 7 | 6 | 28861 | 25 | |||
91199 | 180418 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 5 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003475.18041 | 2094328.74311 | 37.7308247469633 | -122.430304314596 | (37.7308247469633, -122.430304314596) | 9 | 7 | 6 | 28861 | 25 | |||
96166 | 180419 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 6 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003443.67237 | 2094317.91582 | 37.7307932329079 | -122.43041247068 | (37.7307932329079, -122.43041247068) | 9 | 7 | 6 | 28861 | 25 | |||
114327 | 180420 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 7 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003421.2672 | 2094309.35986 | 37.7307684709799 | -122.430489318632 | (37.7307684709799, -122.430489318632) | 9 | 7 | 6 | 28861 | 25 | |||
121918 | 180423 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 11 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003317.21168 | 2094273.79477 | 37.7306649221452 | -122.430846517675 | (37.7306649221452, -122.430846517675) | 9 | 7 | 6 | 28861 | 25 | |||
160552 | 180416 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1132x Alemany Blvd | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6003534.67772 | 2094349.44618 | 37.7308849628519 | -122.430100099258 | (37.7308849628519, -122.430100099258) | 9 | 7 | 6 | 28861 | 25 | |||
92840 | 27701 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1136 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/26/2000 12:00:00 AM | 6 | 6008329.04379 | 2093834.9235 | 37.7297425666631 | -122.413488762206 | (37.7297425666631, -122.413488762206) | 9 | 3 | 7 | 309 | 28 | |||
80788 | 180475 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1138 Bacon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008076.47647 | 2092081.36739 | 37.724913492352 | -122.414237900184 | (37.724913492352, -122.414237900184) | 9 | 3 | 7 | 309 | 28 | |||
119924 | 180476 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1138 Bacon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008061.92391 | 2092076.56713 | 37.7248994944097 | -122.4142878674 | (37.7248994944097, -122.4142878674) | 9 | 3 | 7 | 309 | 28 | |||
132214 | 180477 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1138 Bacon St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008049.06665 | 2092073.68164 | 37.724890849229 | -122.414332109539 | (37.724890849229, -122.414332109539) | 9 | 3 | 7 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );