trees
5,599 rows where qSpecies_id = 38 sorted by DBH 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19153 | 5691 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1545 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005346 | 2099395 | 37.7448413407379 | -122.424196757704 | (37.7448413407379, -122.424196757704) | 2 | 7 | 5 | 28859 | 22 | |||
| 25173 | 5666 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1386 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4x4 | 6005171.18394 | 2100267.5671 | 37.747227337869 | -122.424863305591 | (37.747227337869, -122.424863305591) | 2 | 7 | 5 | 63 | 22 | |||
| 32734 | 5631 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1234 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6005123.01487 | 2101119.88751 | 37.7495648926104 | -122.425090505838 | (37.7495648926104, -122.425090505838) | 2 | 4 | 5 | 28862 | 22 | |||
| 33764 | 5347 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 199 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004867.38316 | 2107258.6385 | 37.7664060136476 | -122.426411520896 | (37.7664060136476, -122.426411520896) | 8 | 4 | 5 | 28862 | 19 | |||
| 38202 | 5734 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1725 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6005365.37115 | 2098326.96084 | 37.7419098417621 | -122.424053837524 | (37.7419098417621, -122.424053837524) | 2 | 7 | 5 | 28859 | 7 | |||
| 47869 | 5681 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1475 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005285.89878 | 2099762.93917 | 37.7458482239295 | -122.424430742501 | (37.7458482239295, -122.424430742501) | 2 | 7 | 5 | 28859 | 22 | |||
| 56194 | 5411 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 0 | 6004855.17183 | 2105951.94902 | 37.7628174659634 | -122.426360712783 | (37.7628174659634, -122.426360712783) | 8 | 4 | 5 | 28859 | 3 | |||
| 61252 | 5701 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1573 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6005320.34173 | 2099180.98827 | 37.7442522645292 | -122.424270261189 | (37.7442522645292, -122.424270261189) | 2 | 7 | 5 | 28859 | 22 | |||
| 82072 | 5626 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1212 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005119.51713 | 2101140.67706 | 37.7496217783286 | -122.425104080197 | (37.7496217783286, -122.425104080197) | 2 | 4 | 5 | 28862 | 22 | |||
| 100949 | 5638 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1272 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005135.78776 | 2100920.26504 | 37.749017496881 | -122.425032135324 | (37.749017496881, -122.425032135324) | 2 | 4 | 5 | 28862 | 22 | |||
| 121855 | 5630 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1231 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005204.70803 | 2101163.32944 | 37.7496887886191 | -122.424811098167 | (37.7496887886191, -122.424811098167) | 2 | 4 | 5 | 28859 | 19 | |||
| 149967 | 11434 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6011450.63994 | 2118045.46213 | 37.7963940539012 | -122.404400461805 | (37.7963940539012, -122.404400461805) | 3 | 1 | 10 | 308 | 4 | |||
| 151080 | 440 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 905X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005107.10521 | 2103067.32029 | 37.7549111922079 | -122.425284083114 | (37.7549111922079, -122.425284083114) | 2 | 4 | 5 | 28859 | 19 | |||
| 166830 | 5327 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004755.67064 | 2107733.77413 | 37.7677043064343 | -122.426831755188 | (37.7677043064343, -122.426831755188) | 8 | 4 | 5 | 28862 | 3 | |||
| 172094 | 5704 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1592 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6005234.83472 | 2099132.33541 | 37.7441138462791 | -122.42456246619 | (37.7441138462791, -122.42456246619) | 2 | 7 | 5 | 63 | 22 | |||
| 189950 | 5688 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1529 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005300.97335 | 2099447.43901 | 37.7449827838227 | -122.424356180604 | (37.7449827838227, -122.424356180604) | 2 | 7 | 5 | 28859 | 22 | |||
| 193491 | 5510 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 811 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6X5 | 6005073.33558 | 2103604.24932 | 37.7563835658713 | -122.425439076749 | (37.7563835658713, -122.425439076749) | 2 | 4 | 5 | 28859 | 19 | |||
| 1666 | 128592 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013155.79734 | 2117635.08876 | 37.7953624065092 | -122.398471405135 | (37.7953624065092, -122.398471405135) | 3 | 1 | 10 | 28860 | 6 | |||
| 2197 | 126966 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 32 Parker Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5996866.78793 | 2114389.9756 | 37.7855312948716 | -122.454599192111 | (37.7855312948716, -122.454599192111) | 11 | 6 | 1 | 54 | 31 | |||
| 3764 | 226567 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005696.43071 | 2106383.98783 | 37.76405126027 | -122.423481806642 | (37.76405126027, -122.423481806642) | 8 | 4 | 5 | 28859 | 19 | |||
| 4135 | 123361 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 756 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994763.35319 | 2110444.72464 | 37.7745778244496 | -122.461590268289 | (37.7745778244496, -122.461590268289) | 11 | 6 | 2 | 54 | 11 | |||
| 4173 | 73353 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2121 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5988988.09253 | 2110533.92881 | 37.7744886354086 | -122.481574330241 | (37.7744886354086, -122.481574330241) | 11 | 6 | 2 | 55 | 26 | |||
| 6281 | 128011 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 590 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008173.68388 | 2121395.11526 | 37.8054076943845 | -122.415976787008 | (37.8054076943845, -122.415976787008) | 5 | 1 | 10 | 308 | 23 | |||
| 6504 | 64373 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 376 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 9 | Permit Number 25212 | 6011164.54643 | 2119369.06968 | 37.8000123673464 | -122.405483677229 | (37.8000123673464, -122.405483677229) | 3 | 1 | 10 | 308 | 23 | |
| 8227 | 120322 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 650 23rd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5988821.62524 | 2110892.0885 | 37.7754623614562 | -122.482176410805 | (37.7754623614562, -122.482176410805) | 11 | 6 | 2 | 55 | 26 | |||
| 10802 | 190210 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013925.01532 | 2116617.87783 | 37.7926122059272 | -122.395738456263 | (37.7926122059272, -122.395738456263) | 12 | 2 | 9 | 28855 | 6 | |||
| 11793 | 126809 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2460 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5999542.14007 | 2119832.86925 | 37.800629124187 | -122.445734860683 | (37.800629124187, -122.445734860683) | 13 | 9 | 1 | 57 | 17 | |||
| 12427 | 189631 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 8 | : | Tree | Private 2 | 9 | Width 3ft | 6007308.18753 | 2110441.11785 | 37.7752820209699 | -122.418194860528 | (37.7752820209699, -122.418194860528) | 8 | 2 | 9 | 28853 | 34 | |||
| 15455 | 119460 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 738 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5985722.56634 | 2110851.82305 | 37.7751710617394 | -122.492893672358 | (37.7751710617394, -122.492893672358) | 11 | 6 | 2 | 55 | 26 | |||
| 15742 | 128051 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 451 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008583.62119 | 2121741.55075 | 37.8063819578114 | -122.414582670576 | (37.8063819578114, -122.414582670576) | 3 | 1 | 10 | 308 | 23 | |||
| 18596 | 190206 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013962.81432 | 2116573.15584 | 37.792491512422 | -122.395604534619 | (37.792491512422, -122.395604534619) | 12 | 2 | 9 | 28855 | 6 | |||
| 18602 | 190213 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Main St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013892.82186 | 2116649.49416 | 37.7926972260507 | -122.39585206404 | (37.7926972260507, -122.39585206404) | 12 | 2 | 9 | 28855 | 6 | |||
| 20404 | 127052 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 627 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999904.12445 | 2121564.04699 | 37.8054031339002 | -122.444606746617 | (37.8054031339002, -122.444606746617) | 13 | 9 | 1 | 57 | 17 | |||
| 20530 | 93479 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113X Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 1.5x3 | Tree 4 on Leroy | 6008317.25099 | 2116630.80353 | 37.792334150853 | -122.415142500331 | (37.792334150853, -122.415142500331) | 5 | 1 | 10 | 28858 | 21 | ||
| 21697 | 120722 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 21st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5989381.54871 | 2112550.53538 | 37.7800485470941 | -122.48036094165 | (37.7800485470941, -122.48036094165) | 11 | 6 | 2 | 55 | 26 | |||
| 21971 | 36892 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39545 | 5998941.54083 | 2116530.8219 | 37.7915282746499 | -122.447575345738 | (37.7915282746499, -122.447575345738) | 13 | 6 | 1 | 29490 | 31 | |
| 22079 | 192105 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 367 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011383.10975 | 2112495.76638 | 37.7811521324975 | -122.404243335871 | (37.7811521324975, -122.404243335871) | 6 | 2 | 9 | 28853 | 34 | |||
| 22197 | 190326 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 657 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012802.6319 | 2114123.85519 | 37.7857017047117 | -122.399446797256 | (37.7857017047117, -122.399446797256) | 6 | 2 | 9 | 28853 | 6 | |||
| 22601 | 126687 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2801 Divisadero St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 6000575.90002 | 2117927.00422 | 37.7954550915302 | -122.442020761354 | (37.7954550915302, -122.442020761354) | 13 | 9 | 1 | 57 | 17 | |||
| 22750 | 113458 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 14 Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008346.99172 | 2116484.00265 | 37.7919327429628 | -122.415029201053 | (37.7919327429628, -122.415029201053) | 5 | 1 | 10 | 28858 | 21 | |||
| 23341 | 65336 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1699 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1989 12:00:00 AM | 9 | Permit Number 28164 | 6005487.09348 | 2118184.69125 | 37.7964412799947 | -122.425045530732 | (37.7964412799947, -122.425045530732) | 13 | 9 | 1 | 28858 | 27 | ||
| 23400 | 127728 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 50 Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6008337.80395 | 2116548.86512 | 37.7921103230909 | -122.415065584015 | (37.7921103230909, -122.415065584015) | 5 | 1 | 10 | 28858 | 21 | |||
| 24713 | 123014 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 70 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993974.37833 | 2115085.79297 | 37.7872755003719 | -122.464656546249 | (37.7872755003719, -122.464656546249) | 11 | 6 | 1 | 54 | 11 | |||
| 24821 | 51922 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 101 Walnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 9 | Permit Number 48124 | 5998457.45389 | 2116096.16414 | 37.790307142815 | -122.449218944009 | (37.790307142815, -122.449218944009) | 13 | 6 | 1 | 54 | 31 | ||
| 26032 | 30564 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 633 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34542 | 6002889.41967 | 2095678.38488 | 37.7344973596725 | -122.432425741574 | (37.7344973596725, -122.432425741574) | 2 | 7 | 5 | 63 | 7 | ||
| 26298 | 126733 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2237 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002259.4459 | 2118428.90563 | 37.7969289769584 | -122.436231353201 | (37.7969289769584, -122.436231353201) | 13 | 9 | 1 | 57 | 17 | |||
| 26730 | 127602 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 7 Ada Ct | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008099.06699 | 2114176.10404 | 37.7855818817383 | -122.415723537934 | (37.7855818817383, -122.415723537934) | 13 | 10 | 9 | 28858 | 36 | |||
| 28487 | 127055 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 619 Marina Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5999957.78015 | 2121570.64869 | 37.8054243219321 | -122.444421539327 | (37.8054243219321, -122.444421539327) | 13 | 9 | 1 | 57 | 17 | |||
| 28732 | 190212 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Main St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013901.3012 | 2116638.71234 | 37.7926680934122 | -122.395821969133 | (37.7926680934122, -122.395821969133) | 12 | 2 | 9 | 28855 | 6 | |||
| 29633 | 84823 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 843 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | 9 | Permit No. 49293 | 6011667.05773 | 2118221.94084 | 37.7968907134816 | -122.403664029475 | (37.7968907134816, -122.403664029475) | 3 | 1 | 10 | 308 | 4 | ||
| 30496 | 128388 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 132 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012017.39493 | 2116003.50047 | 37.7908189694693 | -122.402295714592 | (37.7908189694693, -122.402295714592) | 4 | 1 | 10 | 28854 | 6 | |||
| 31079 | 126845 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 5 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001699.54492 | 2121326.58753 | 37.8048534196989 | -122.438376445828 | (37.8048534196989, -122.438376445828) | 13 | 9 | 1 | 57 | 17 | |||
| 32944 | 65094 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 195 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | 9 | Permit Number 27059 | 5988970.35279 | 2114105.07086 | 37.7842929607651 | -122.481897341966 | (37.7842929607651, -122.481897341966) | 11 | 6 | 2 | 55 | 26 | |
| 33625 | 126723 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2600 Green St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6000553.47477 | 2117891.28272 | 37.7953557317468 | -122.442095790902 | (37.7953557317468, -122.442095790902) | 13 | 9 | 1 | 57 | 17 | |||
| 34368 | 190171 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 91 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014322.57225 | 2116715.75105 | 37.7929030502948 | -122.394369740268 | (37.7929030502948, -122.394369740268) | 12 | 2 | 9 | 28855 | 6 | |||
| 34403 | 128265 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2 Lombard St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6012016.793 | 2120878.37297 | 37.8042041631481 | -122.40264075927 | (37.8042041631481, -122.40264075927) | 3 | 1 | 10 | 28860 | 6 | |||
| 35539 | 137576 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1095 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6002354.5808 | 2112241.3971 | 37.7799450671147 | -122.435459310364 | (37.7799450671147, -122.435459310364) | 15 | 5 | 11 | 29490 | 41 | |||
| 35563 | 38395 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1349 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40449 | 6007167.1707 | 2116001.74467 | 37.7905422121159 | -122.419077174583 | (37.7905422121159, -122.419077174583) | 13 | 9 | 10 | 28858 | 21 | |
| 36464 | 225033 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 4417 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001273.24239 | 2105218.51179 | 37.7606005004253 | -122.438696765447 | (37.7606005004253, -122.438696765447) | 2 | 4 | 5 | 28862 | 3 | |||
| 38320 | 190196 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 60 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014341.4496 | 2116607.32971 | 37.7926063999234 | -122.394296828661 | (37.7926063999234, -122.394296828661) | 12 | 2 | 9 | 28855 | 6 | |||
| 39047 | 38394 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1349 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40449 | 6007167.64774 | 2115994.18232 | 37.790521474634 | -122.419074987422 | (37.790521474634, -122.419074987422) | 13 | 9 | 10 | 28858 | 21 | |
| 39437 | 127901 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1161 Greenwich St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 5ft | 6007323.01925 | 2119835.81452 | 37.8010783868074 | -122.418809976115 | (37.8010783868074, -122.418809976115) | 5 | 1 | 1 | 28858 | 32 | |||
| 39503 | 190300 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 250 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014094.75964 | 2115308.255 | 37.7890257276006 | -122.395059359299 | (37.7890257276006, -122.395059359299) | 6 | 2 | 9 | 28855 | 6 | |||
| 41284 | 218849 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1239 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5990770.51831 | 2106948.92525 | 37.7647486683402 | -122.475146871634 | (37.7647486683402, -122.475146871634) | 11 | 8 | 3 | 56 | 12 | |||
| 41913 | 127058 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 601 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000018.7628 | 2121580.23342 | 37.8054541182755 | -122.444211190612 | (37.8054541182755, -122.444211190612) | 13 | 9 | 1 | 57 | 17 | |||
| 42031 | 128128 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2600 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007871.09552 | 2121750.40572 | 37.806366215197 | -122.417049126928 | (37.806366215197, -122.417049126928) | 5 | 1 | 10 | 308 | 23 | |||
| 42278 | 190290 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014873.06064 | 2116050.1631 | 37.7911060852403 | -122.392418431772 | (37.7911060852403, -122.392418431772) | 6 | 2 | 9 | 28855 | 6 | |||
| 42412 | 115412 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009177.90549 | 2122219.2006 | 37.8077268337044 | -122.412559822789 | (37.8077268337044, -122.412559822789) | 3 | 1 | 10 | 308 | 23 | |||
| 42796 | 54543 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 147 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 9 | Permit Number 10338 | 6009783.43308 | 2095111.41047 | 37.7333290845542 | -122.408550765616 | (37.7333290845542, -122.408550765616) | 10 | 3 | 7 | 309 | 28 | ||
| 42801 | 224723 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 601 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008504.09932 | 2104945.43071 | 37.7602593848815 | -122.413669115836 | (37.7602593848815, -122.413669115836) | 2 | 4 | 7 | 28859 | 19 | |||
| 42995 | 225569 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 83 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001823.53469 | 2106200.10806 | 37.7633270146472 | -122.436863829303 | (37.7633270146472, -122.436863829303) | 15 | 5 | 5 | 28862 | 3 | |||
| 43161 | 128247 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012050.07829 | 2120824.85682 | 37.8040590791349 | -122.402521806838 | (37.8040590791349, -122.402521806838) | 3 | 1 | 10 | 28860 | 6 | |||
| 43396 | 115413 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009154.53786 | 2122215.89686 | 37.8077164510111 | -122.412640458689 | (37.8077164510111, -122.412640458689) | 3 | 1 | 10 | 308 | 23 | |||
| 44823 | 127225 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2801 Green St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999606.34401 | 2117712.3673 | 37.7948104565905 | -122.445360136555 | (37.7948104565905, -122.445360136555) | 13 | 9 | 1 | 57 | 27 | |||
| 47839 | 34534 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2025 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | 9 | Permit Number 38242 | 5999400.42929 | 2115847.67184 | 37.789678738817 | -122.445938448311 | (37.789678738817, -122.445938448311) | 13 | 6 | 1 | 29490 | 31 | ||
| 48145 | 225540 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 11 Park Hill Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001178.31415 | 2107915.4155 | 37.7680001330331 | -122.439218382125 | (37.7680001330331, -122.439218382125) | 15 | 5 | 5 | 29492 | 3 | |||
| 48737 | 47566 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 215 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | 9 | Permit Number 45426 | 6011748.45829 | 2111693.86562 | 37.7789707072565 | -122.40292298723 | (37.7789707072565, -122.40292298723) | 14 | 2 | 9 | 28856 | 34 | ||
| 48750 | 192117 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 367 Tehama St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011557.32481 | 2112660.98946 | 37.7816155297637 | -122.403652263664 | (37.7816155297637, -122.403652263664) | 6 | 2 | 9 | 28853 | 34 | |||
| 49754 | 127588 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Ada Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008108.50322 | 2114196.51357 | 37.785638451808 | -122.415692336847 | (37.785638451808, -122.415692336847) | 13 | 10 | 9 | 28858 | 36 | |||
| 50304 | 118875 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 722 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5981376.47847 | 2110796.96576 | 37.7747653270952 | -122.507923425807 | (37.7747653270952, -122.507923425807) | 11 | 6 | 2 | 55 | 26 | |||
| 50556 | 190211 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013914.14494 | 2116628.70809 | 37.7926413385806 | -122.39577682766 | (37.7926413385806, -122.39577682766) | 12 | 2 | 9 | 28855 | 6 | |||
| 51093 | 190302 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 250 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014116.20891 | 2115285.06479 | 37.7889632453931 | -122.394983522177 | (37.7889632453931, -122.394983522177) | 6 | 2 | 9 | 28855 | 6 | |||
| 51357 | 126658 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2925 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003432.53737 | 2118407.10129 | 37.7969356885802 | -122.432170622793 | (37.7969356885802, -122.432170622793) | 13 | 9 | 1 | 57 | 17 | |||
| 52769 | 190157 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 70 Steuart St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014319.0284 | 2117151.13499 | 37.7940983158456 | -122.394412501243 | (37.7940983158456, -122.394412501243) | 12 | 2 | 9 | 28855 | 6 | |||
| 54452 | 190192 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 60 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014301.77297 | 2116647.11039 | 37.7927134228496 | -122.394436898969 | (37.7927134228496, -122.394436898969) | 12 | 2 | 9 | 28855 | 6 | |||
| 55453 | 224936 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 219 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003565.5824 | 2100957.86015 | 37.7490319013192 | -122.430464596269 | (37.7490319013192, -122.430464596269) | 2 | 4 | 5 | 28862 | 22 | |||
| 55467 | 127745 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 46 Reed St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6008189.23868 | 2117171.32758 | 37.793811102039 | -122.415623714977 | (37.793811102039, -122.415623714977) | 5 | 1 | 10 | 28858 | 21 | |||
| 57448 | 126746 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2800 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999543.48149 | 2118097.35116 | 37.7958639314295 | -122.445605346607 | (37.7958639314295, -122.445605346607) | 13 | 9 | 1 | 57 | 17 | |||
| 57576 | 189813 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 220 San Bruno Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010835.2592 | 2107226.14552 | 37.7666523424605 | -122.405767341407 | (37.7666523424605, -122.405767341407) | 8 | 4 | 8 | 28853 | 19 | |||
| 58039 | 190193 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 60 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014315.17005 | 2116633.49065 | 37.7926767709553 | -122.394389590109 | (37.7926767709553, -122.394389590109) | 12 | 2 | 9 | 28855 | 6 | |||
| 58124 | 93478 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113X Leroy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 1.5x3 | Tree 3 on Leroy | 6008314.47624 | 2116646.88711 | 37.7923781564804 | -122.415153240053 | (37.7923781564804, -122.415153240053) | 5 | 1 | 10 | 28858 | 21 | ||
| 60448 | 93706 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1864 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53296 | 6004109.00991 | 2118387.91052 | 37.7969213264076 | -122.429828497703 | (37.7969213264076, -122.429828497703) | 13 | 9 | 1 | 57 | 17 | |
| 61180 | 127449 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 653 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009641.58234 | 2115683.17783 | 37.7898065351907 | -122.410493319204 | (37.7898065351907, -122.410493319204) | 5 | 1 | 10 | 28857 | 21 | |||
| 61338 | 127103 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1643 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002343.60865 | 2121220.88167 | 37.804599792022 | -122.436140028834 | (37.804599792022, -122.436140028834) | 13 | 9 | 1 | 57 | 17 | |||
| 61791 | 123362 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 756 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994764.00334 | 2110429.44522 | 37.7745359086336 | -122.461586911299 | (37.7745359086336, -122.461586911299) | 11 | 6 | 2 | 54 | 11 | |||
| 62026 | 41169 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 15 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 9 | Permit Number 41890 | 6001073.75913 | 2119781.55874 | 37.8005755677693 | -122.440431161974 | (37.8005755677693, -122.440431161974) | 13 | 9 | 1 | 57 | 17 | |
| 62579 | 120048 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 363 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5987438.18349 | 2113514.39277 | 37.7825819029933 | -122.487154643236 | (37.7825819029933, -122.487154643236) | 11 | 6 | 2 | 55 | 26 | |||
| 62626 | 190194 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 60 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014325.66257 | 2116622.06556 | 37.792645983582 | -122.394352484992 | (37.792645983582, -122.394352484992) | 12 | 2 | 9 | 28855 | 6 | |||
| 63261 | 190308 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 250 Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014212.34397 | 2115184.6648 | 37.7886929154874 | -122.39464387162 | (37.7886929154874, -122.39464387162) | 6 | 2 | 9 | 28855 | 6 | |||
| 65077 | 128589 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013189.08613 | 2117639.51304 | 37.79537640894 | -122.398356530248 | (37.79537640894, -122.398356530248) | 3 | 1 | 10 | 28860 | 6 |
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) );