trees
57 rows where Supervisor Districts = 7 and qSpecies_id = 54 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146796 | 15628 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005530.9833 | 2097730.2012 | 37.7402806235852 | -122.423438788897 | (37.7402806235852, -122.423438788897) | 2 | 7 | 7 | 28859 | 2 | |||
116079 | 15627 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005560.95 | 2097781.3943 | 37.7404228796109 | -122.423338814191 | (37.7404228796109, -122.423338814191) | 2 | 7 | 7 | 28859 | 2 | |||
48097 | 15626 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005569.6902 | 2097797.6263 | 37.7404679423018 | -122.423309747569 | (37.7404679423018, -122.423309747569) | 2 | 7 | 7 | 28859 | 2 | |||
130276 | 245378 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 3550 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005581.5521 | 2097815.7311 | 37.7405183234498 | -122.423270020371 | (37.7405183234498, -122.423270020371) | 2 | 7 | 7 | 28859 | 2 | |||
105481 | 549 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2899 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009532.5718 | 2102167.7354 | 37.7526901583127 | -122.409916012434 | (37.7526901583127, -122.409916012434) | 2 | 4 | 7 | 28859 | 19 | |||
1544 | 245421 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2895 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 0ft | 6009555.5127 | 2102167.7354 | 37.752691443998 | -122.409836678395 | (37.752691443998, -122.409836678395) | 2 | 4 | 7 | 28859 | 19 | |||
105187 | 547 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2889 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009603.6887 | 2102171.1765 | 37.7527035922626 | -122.409670319384 | (37.7527035922626, -122.409670319384) | 2 | 4 | 7 | 28859 | 19 | |||
21482 | 540 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6009646.1294 | 2102175.7647 | 37.7527185686087 | -122.409523875049 | (37.7527185686087, -122.409523875049) | 2 | 4 | 7 | 28859 | 19 | |||
14249 | 245420 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2855 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6009712.0846 | 2102179.2059 | 37.7527317128259 | -122.409296032004 | (37.7527317128259, -122.409296032004) | 2 | 4 | 7 | 28859 | 19 | |||
19257 | 531 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 3x3 | 6009825.6422 | 2102183.2205 | 37.7527490975863 | -122.408903610932 | (37.7527490975863, -122.408903610932) | 2 | 4 | 7 | 28859 | 19 | |||
3102 | 245419 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2833 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009862.9212 | 2102186.0881 | 37.7527590594841 | -122.408774895147 | (37.7527590594841, -122.408774895147) | 2 | 4 | 7 | 28859 | 19 | |||
19555 | 529 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2839 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009902.781 | 2102188.0955 | 37.7527668038666 | -122.408637193736 | (37.7527668038666, -122.408637193736) | 2 | 4 | 7 | 28859 | 19 | |||
110627 | 520 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2809 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x5 | 6009957.8393 | 2102189.816 | 37.752774611474 | -122.408446912653 | (37.752774611474, -122.408446912653) | 2 | 4 | 7 | 28859 | 19 | |||
89324 | 545 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2878 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009558.0762 | 2102211.8871 | 37.7528128183786 | -122.409830929661 | (37.7528128183786, -122.409830929661) | 2 | 4 | 7 | 28859 | 19 | |||
176892 | 544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2872 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009585.3031 | 2102212.479 | 37.7528159694172 | -122.409736815429 | (37.7528159694172, -122.409736815429) | 2 | 4 | 7 | 28859 | 19 | |||
110511 | 542 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2870 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009603.0598 | 2102213.6628 | 37.7528202149244 | -122.409675492792 | (37.7528202149244, -122.409675492792) | 2 | 4 | 7 | 28859 | 19 | |||
27045 | 538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2860 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009651.0028 | 2102218.3979 | 37.7528359029411 | -122.409510030546 | (37.7528359029411, -122.409510030546) | 2 | 4 | 7 | 28859 | 19 | |||
79122 | 533 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2850 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009680.0053 | 2102218.3979 | 37.7528375279845 | -122.409409734124 | (37.7528375279845, -122.409409734124) | 2 | 4 | 7 | 28859 | 19 | |||
189533 | 532 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2850 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009709.5998 | 2102220.1735 | 37.7528440615121 | -122.409307515735 | (37.7528440615121, -122.409307515735) | 2 | 4 | 7 | 28859 | 19 | |||
6605 | 528 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2836 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009819.9871 | 2102225.5005 | 37.7528648722833 | -122.408926150195 | (37.7528648722833, -122.408926150195) | 2 | 4 | 7 | 28859 | 19 | |||
183288 | 491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010371.9231 | 2102214.4775 | 37.7528655070754 | -122.407016666927 | (37.7528655070754, -122.407016666927) | 10 | 4 | 7 | 28859 | 19 | |||
57901 | 492 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010397.1581 | 2102215.0511 | 37.7528684941587 | -122.406929439613 | (37.7528684941587, -122.406929439613) | 10 | 4 | 7 | 28859 | 19 | |||
172312 | 527 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2836 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6009841.2951 | 2102226.6843 | 37.7528693162895 | -122.408852546362 | (37.7528693162895, -122.408852546362) | 2 | 4 | 7 | 28859 | 19 | |||
122091 | 493 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010421.2461 | 2102217.9187 | 37.7528777158138 | -122.406846340514 | (37.7528777158138, -122.406846340514) | 10 | 4 | 7 | 28859 | 19 | |||
187119 | 524 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2826 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009890.4218 | 2102229.0519 | 37.7528785688198 | -122.408682823354 | (37.7528785688198, -122.408682823354) | 2 | 4 | 7 | 28859 | 19 | |||
46647 | 494 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6010448.7752 | 2102218.4922 | 37.7528808308555 | -122.406751179708 | (37.7528808308555, -122.406751179708) | 10 | 4 | 7 | 28859 | 19 | |||
122229 | 496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010495.2306 | 2102220.2128 | 37.7528881543902 | -122.406590648723 | (37.7528881543902, -122.406590648723) | 10 | 4 | 7 | 28859 | 19 | |||
65948 | 497 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2749X 24th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6010516.451 | 2102220.2128 | 37.7528893415843 | -122.406517264254 | (37.7528893415843, -122.406517264254) | 10 | 4 | 7 | 28859 | 19 | |||
831 | 245412 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | 2 | 4 | 7 | 28859 | 19 | |||
6070 | 519 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2802 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6009998.1456 | 2102238.5221 | 37.7529106047271 | -122.408310960592 | (37.7529106047271, -122.408310960592) | 2 | 4 | 7 | 28859 | 19 | |||
18387 | 245411 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2792 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6010069.4683 | 2102240.5937 | 37.7529202865107 | -122.408064458251 | (37.7529202865107, -122.408064458251) | 2 | 4 | 7 | 28859 | 19 | |||
67867 | 513 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2792 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010090.1844 | 2102241.1856 | 37.7529230716135 | -122.407992859485 | (37.7529230716135, -122.407992859485) | 2 | 4 | 7 | 28859 | 19 | |||
56271 | 514 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010107.5289 | 2102242.0067 | 37.7529262972422 | -122.407932936557 | (37.7529262972422, -122.407932936557) | 2 | 4 | 7 | 28859 | 19 | |||
17488 | 245410 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6010125.3081 | 2102244.3008 | 37.7529335917078 | -122.407871614204 | (37.7529335917078, -122.407871614204) | 2 | 4 | 7 | 28859 | 19 | |||
5046 | 245409 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2778 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6010163.1606 | 2102247.1684 | 37.7529435845832 | -122.40774091468 | (37.7529435845832, -122.40774091468) | 2 | 4 | 7 | 28859 | 19 | |||
137337 | 501 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2754 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x5 | 6010215.9248 | 2102247.7419 | 37.7529481129231 | -122.407558485659 | (37.7529481129231, -122.407558485659) | 2 | 4 | 7 | 28859 | 19 | |||
61639 | 498 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2752 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010250.9097 | 2102250.6095 | 37.7529579449469 | -122.40743770282 | (37.7529579449469, -122.40743770282) | 2 | 4 | 7 | 28859 | 19 | |||
12248 | 245414 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2736 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6010338.0852 | 2102254.0506 | 37.7529722724302 | -122.40713647447 | (37.7529722724302, -122.40713647447) | 10 | 4 | 7 | 28859 | 19 | |||
160447 | 489 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2730 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6010359.8791 | 2102254.6242 | 37.7529750670361 | -122.407061147073 | (37.7529750670361, -122.407061147073) | 10 | 4 | 7 | 28859 | 19 | |||
7684 | 245413 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2726 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010382.82 | 2102257.4918 | 37.7529842245941 | -122.406982014782 | (37.7529842245941, -122.406982014782) | 10 | 4 | 7 | 28859 | 19 | |||
61537 | 487 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2718 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010403.4669 | 2102258.6388 | 37.7529885293488 | -122.406910694342 | (37.7529885293488, -122.406910694342) | 10 | 4 | 7 | 28859 | 19 | |||
5364 | 245472 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | 10 | 4 | 7 | 28859 | 19 | |||
64608 | 245471 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6010463.1133 | 2102261.5065 | 37.7529997408326 | -122.406704626743 | (37.7529997408326, -122.406704626743) | 10 | 4 | 7 | 28859 | 19 | |||
11681 | 245470 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 0ft | 6010486.0542 | 2102262.08 | 37.7530025990603 | -122.406625332729 | (37.7530025990603, -122.406625332729) | 10 | 4 | 7 | 28859 | 19 | |||
80916 | 481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2700 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010503.8335 | 2102264.9476 | 37.7530114675552 | -122.406564050249 | (37.7530114675552, -122.406564050249) | 10 | 4 | 7 | 28859 | 19 | |||
184065 | 15445 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2250 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006857.7723 | 2105245.8857 | 37.7609917781074 | -122.419384314212 | (37.7609917781074, -122.419384314212) | 2 | 4 | 7 | 28859 | 19 | |||
46681 | 15435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2141 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006881.4762 | 2105834.0306 | 37.7626080219354 | -122.419344056803 | (37.7626080219354, -122.419344056803) | 8 | 4 | 7 | 28859 | 19 | |||
171060 | 15433 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2135 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006876.1683 | 2105910.6162 | 37.7628180091578 | -122.419367848279 | (37.7628180091578, -122.419367848279) | 8 | 4 | 7 | 28859 | 19 | |||
76119 | 246305 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2135 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6006876.9266 | 2105933.3644 | 37.7628805131093 | -122.419366839444 | (37.7628805131093, -122.419366839444) | 8 | 4 | 7 | 28859 | 19 | |||
118263 | 246282 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6006871.6187 | 2105950.8046 | 37.7629281008719 | -122.419386434964 | (37.7629281008719, -122.419386434964) | 8 | 4 | 7 | 28859 | 19 | |||
166357 | 246283 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6006872.377 | 2105970.5198 | 37.7629822769131 | -122.419385210964 | (37.7629822769131, -122.419385210964) | 8 | 4 | 7 | 28859 | 19 | |||
106406 | 245439 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2940 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5x5 | 6007210.059 | 2106771.9452 | 37.7652018171161 | -122.418274106734 | (37.7652018171161, -122.418274106734) | 8 | 4 | 7 | 28853 | 19 | |||
189470 | 245460 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2940 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6007306.1163 | 2106778.6027 | 37.7652255036159 | -122.417942338761 | (37.7652255036159, -122.417942338761) | 8 | 4 | 7 | 28853 | 19 | |||
39594 | 245462 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2886 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6007544.8329 | 2106792.8686 | 37.7652781065022 | -122.41711768386 | (37.7652781065022, -122.41711768386) | 8 | 4 | 7 | 28853 | 19 | |||
112485 | 245461 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2886 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6007563.8542 | 2106794.7707 | 37.7652843992631 | -122.417052028294 | (37.7652843992631, -122.417052028294) | 8 | 4 | 7 | 28853 | 19 | |||
152768 | 15334 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2006 12:00:00 AM | 4 | 3x3 | 6006687.4636 | 2108380.8364 | 37.7695900216736 | -122.420195837478 | (37.7695900216736, -122.420195837478) | 8 | 4 | 7 | 28853 | 19 | ||
175326 | 15326 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006681.5676 | 2108466.3283 | 37.7698244299152 | -122.420222300021 | (37.7698244299152, -122.420222300021) | 8 | 4 | 7 | 28853 | 19 |
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) );