trees
1,098 rows where qCaretaker_id = 4 sorted by Police Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154771 | 98634 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002253.74096 | 2120233.67924 | 37.8018840885493 | -122.436380326794 | (37.8018840885493, -122.436380326794) | 13 | 9 | 1 | 57 | 17 | ||
| 155737 | 117286 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3500 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6002513 | 2120207 | 37.8018255621759 | -122.435481260672 | (37.8018255621759, -122.435481260672) | 13 | 9 | 1 | 57 | 17 | ||||
| 156701 | 97732 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005757.30775 | 2120698.05289 | 37.8033575908394 | -122.424289378073 | (37.8033575908394, -122.424289378073) | 5 | 9 | 1 | 28858 | 32 | |
| 156907 | 98623 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3500X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 6x6 | 6002295.23154 | 2119980.02637 | 37.80118998188 | -122.436218587333 | (37.80118998188, -122.436218587333) | 13 | 9 | 1 | 57 | 17 | ||
| 158351 | 76145 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x4 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
| 159694 | 76205 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
| 162318 | 34689 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.7994344701793 | -122.434367321195 | (37.7994344701793, -122.434367321195) | 13 | 9 | 1 | 57 | 17 |
| 163071 | 30742 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004180.58298 | 2109863.27384 | 37.7735188623338 | -122.428972754992 | (37.7735188623338, -122.428972754992) | 7 | 9 | 11 | 28852 | 10 |
| 166204 | 98605 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2340 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 3x3 | 6003064.14598 | 2116869.67879 | 37.7926934290995 | -122.433335427386 | (37.7926934290995, -122.433335427386) | 13 | 9 | 1 | 29490 | 27 | ||
| 166834 | 42645 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X GREEN ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 6 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
| 167966 | 76185 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
| 168139 | 34691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.434350145047 | (37.7993346796145, -122.434350145047) | 13 | 9 | 1 | 57 | 17 |
| 170345 | 42643 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1600X GREEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 12 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
| 171361 | 98624 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3500X Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 6x6 | 6002286.82962 | 2120018.90884 | 37.801296265561 | -122.436250445798 | (37.801296265561, -122.436250445798) | 13 | 9 | 1 | 57 | 17 | ||
| 173163 | 97729 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005819.00921 | 2120706.70735 | 37.8033848375917 | -122.424076473471 | (37.8033848375917, -122.424076473471) | 5 | 9 | 1 | 28858 | 32 | |
| 175602 | 97728 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005878.13407 | 2120716.4935 | 37.8034150458325 | -122.423872565669 | (37.8034150458325, -122.423872565669) | 5 | 9 | 1 | 28858 | 32 | |
| 176204 | 73285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 13 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
| 177702 | 76170 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 5 | 3x3 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
| 179937 | 98614 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005316.85787 | 2118791.40908 | 37.7980975551137 | -122.425677787418 | (37.7980975551137, -122.425677787418) | 13 | 9 | 1 | 57 | 17 | ||
| 180518 | 42642 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 5 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
| 183898 | 73288 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X GREEN ST | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1999 12:00:00 AM | 8 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
| 184931 | 97734 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005715.83773 | 2120693.51258 | 37.8033427825912 | -122.424432563629 | (37.8033427825912, -122.424432563629) | 5 | 9 | 1 | 28858 | 32 | |
| 185294 | 98616 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005322.90286 | 2118744.78417 | 37.7979698765663 | -122.425653549774 | (37.7979698765663, -122.425653549774) | 13 | 9 | 1 | 57 | 17 | ||
| 185651 | 98627 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3500X Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 6x6 | 6002279.94472 | 2120071.20683 | 37.801439470916 | -122.43627801544 | (37.801439470916, -122.43627801544) | 13 | 9 | 1 | 57 | 17 | ||
| 188131 | 97727 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.31411 | 37.8034239311172 | -122.423802846647 | (37.8034239311172, -122.423802846647) | 5 | 9 | 1 | 28858 | 32 | |
| 191362 | 97733 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005736.8865 | 2120695.23683 | 37.8033487055393 | -122.424359846228 | (37.8033487055393, -122.424359846228) | 5 | 9 | 1 | 28858 | 32 | |
| 192959 | 76112 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
| 2028 | 76748 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | 1 | 8 | 3 | 56 | 35 | ||
| 3628 | 76755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | 1 | 8 | 3 | 56 | 35 | ||
| 5610 | 46958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 5633 | 76756 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | 1 | 8 | 3 | 56 | 35 | ||
| 7373 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 11170 | 76785 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 3x12 | 5983097.8243 | 2104541.5546 | 37.75769102754 | -122.501506182606 | (37.75769102754, -122.501506182606) | 1 | 8 | 3 | 56 | 35 | ||
| 13082 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 14697 | 76382 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1501X 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 25 | 3x12 | 5983091.4072 | 2104771.8049 | 37.7583228530818 | -122.501545408351 | (37.7583228530818, -122.501545408351) | 1 | 8 | 3 | 56 | 35 | ||
| 18929 | 76784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x12 | 5983097.2131 | 2104562.028 | 37.7577472058325 | -122.501509810878 | (37.7577472058325, -122.501509810878) | 1 | 8 | 3 | 56 | 35 | ||
| 41336 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 42731 | 115967 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4 | 3x3 | 5986812.8086 | 2104676.4366 | 37.7582788637421 | -122.488668327875 | (37.7582788637421, -122.488668327875) | 1 | 8 | 3 | 56 | 35 | |||
| 49723 | 115970 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30TH AVE | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 0 | 3x3 | 5986686 | 2104596 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | 1 | 8 | 3 | 56 | 35 | |||
| 51808 | 111862 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
| 52455 | 117257 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1570 31ST AVE | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 54868 | 96570 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 57689 | 117255 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 57870 | 96483 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 58717 | 46964 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 59100 | 46948 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 3 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 60043 | 111861 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
| 61370 | 76728 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 10 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 62860 | 32726 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 200X Farallones St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 20 | 6x9 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 |
| 63621 | 46967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 5 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 65075 | 76344 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/14/1994 12:00:00 AM | 12 | 3x30 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 | |
| 65943 | 32730 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 431 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.58898 | 2088651.07748 | 37.7147529482781 | -122.459108206688 | (37.7147529482781, -122.459108206688) | 9 | 8 | 6 | 28861 | 24 | |
| 68707 | 32729 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 200X Farallones St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37116 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 |
| 70695 | 46953 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 6 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 72358 | 46950 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 75380 | 46955 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 4 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 77942 | 32731 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 431 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.91433 | 2088666.61691 | 37.7147956345921 | -122.459108206687 | (37.7147956345921, -122.459108206687) | 9 | 8 | 6 | 28861 | 24 | |
| 78188 | 46960 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 79799 | 46957 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 81017 | 117256 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 81039 | 46962 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 6 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 87699 | 76252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 | |
| 87796 | 76222 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/14/1994 12:00:00 AM | 5 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 | |
| 91388 | 105784 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||
| 92249 | 115964 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5986686 | 2104596 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | 1 | 8 | 3 | 56 | 35 | |||
| 94599 | 76762 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 10 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 97962 | 46965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 99609 | 96481 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 100065 | 98885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5994871.8 | 2088553.5 | 37.7144762388107 | -122.459629241673 | (37.7144762388107, -122.459629241673) | 9 | 8 | 6 | 28861 | 24 | ||
| 103743 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 104330 | 46952 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 104954 | 95260 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2290X 14th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5992014.7 | 2099861.3 | 37.745359932747 | -122.470327420537 | (37.745359932747, -122.470327420537) | 1 | 8 | 4 | 29491 | 40 | ||||
| 106870 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 2 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 119464 | 76771 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 121060 | 92961 | DPW Maintained 1 | Tree(s) :: 17 | 2051 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369 | -122.492270870248 | (37.748848003369, -122.492270870248) | 1 | 8 | 3 | 29491 | 35 | ||
| 123453 | 95261 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2290X 14th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5992014.7 | 2099861.3 | 37.745359932747 | -122.470327420537 | (37.745359932747, -122.470327420537) | 1 | 8 | 4 | 29491 | 40 | ||||
| 124067 | 96482 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 129395 | 92962 | DPW Maintained 1 | Tree(s) :: 17 | 2051 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369 | -122.492270870248 | (37.748848003369, -122.492270870248) | 1 | 8 | 3 | 29491 | 35 | ||
| 129428 | 76768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 129766 | 32725 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 431 Capitol Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.24753 | 2088599.26436 | 37.7146106620382 | -122.45910563734 | (37.7146106620382, -122.45910563734) | 9 | 8 | 6 | 28861 | 24 | |
| 132862 | 111863 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
| 133744 | 117251 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 1 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 | ||||
| 135340 | 96571 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 140619 | 76757 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 148752 | 115965 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | 3x3 | 5986811.649 | 2104744.2782 | 37.7584650705211 | -122.488677324697 | (37.7584650705211, -122.488677324697) | 1 | 8 | 3 | 56 | 35 | |||
| 152290 | 115971 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4 | 3x3 | 5986813.9683 | 2104572.6448 | 37.757993947556 | -122.488656688385 | (37.757993947556, -122.488656688385) | 1 | 8 | 3 | 56 | 35 | |||
| 155449 | 46966 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 156729 | 115973 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30TH AVE | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 0 | 3x3 | 5986686 | 2104596 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | 1 | 8 | 3 | 56 | 35 | |||
| 157174 | 46961 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 158580 | 95258 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2290X 14th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5992014.7 | 2099861.3 | 37.745359932747 | -122.470327420537 | (37.745359932747, -122.470327420537) | 1 | 8 | 4 | 29491 | 40 | ||||
| 162635 | 46949 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 5 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 167652 | 46951 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 167675 | 115968 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986813.3885 | 2104648.6042 | 37.7582024774349 | -122.488664276638 | (37.7582024774349, -122.488664276638) | 1 | 8 | 3 | 56 | 35 | |||
| 170193 | 115966 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986811.649 | 2104717.0256 | 37.7583902423484 | -122.488675321582 | (37.7583902423484, -122.488675321582) | 1 | 8 | 3 | 56 | 35 | |||
| 170438 | 96480 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 171291 | 76271 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3899X Kirkham St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 | |
| 174971 | 76749 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 200X Farallones St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 8 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 176886 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 2500x 34TH AVE | 3 | Side Yard : Yard | Tree | SFUSD 4 | 3x3 | 5985829 | 2097874 | 37.7395437603018 | -122.491570003273 | (37.7395437603018, -122.491570003273) | 1 | 8 | 3 | 29491 | 35 |
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) );