trees
5,599 rows where qSpecies_id = 38 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10998 | 100001 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501X 01st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Address is 100 1st Street | ||||||||||||||
8608 | 218881 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1374 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5993982.19031 | 2106154.46944 | 37.7627529198293 | -122.463980949379 | (37.7627529198293, -122.463980949379) | 1 | 5 | 11 | 56 | 12 | |||
14947 | 218904 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 33 Cragmont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992852.19687 | 2101722.68629 | 37.7505192091019 | -122.467566857535 | (37.7505192091019, -122.467566857535) | 1 | 8 | 4 | 29491 | 12 | |||
19466 | 218929 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1447 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5994254.8396 | 2105681.67317 | 37.7614704533193 | -122.463003654322 | (37.7614704533193, -122.463003654322) | 1 | 5 | 11 | 56 | 12 | |||
28219 | 218846 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1754 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 1ft | 5990933.5114 | 2103467.66725 | 37.7551995049594 | -122.474329072232 | (37.7551995049594, -122.474329072232) | 1 | 8 | 4 | 56 | 12 | |||
35056 | 218936 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1003 Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990723.76369 | 2102432.25259 | 37.7523443750999 | -122.474978856684 | (37.7523443750999, -122.474978856684) | 1 | 8 | 4 | 29491 | 12 | |||
36791 | 218891 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1417 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5993629.87425 | 2105889.37879 | 37.762004739661 | -122.465180220513 | (37.762004739661, -122.465180220513) | 1 | 8 | 11 | 56 | 12 | |||
42782 | 218880 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1313 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994226.7125 | 2106557.9109 | 37.7638747539285 | -122.463164515132 | (37.7638747539285, -122.463164515132) | 1 | 5 | 11 | 56 | 12 | |||
46355 | 218903 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 33 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992850.7551 | 2101731.09851 | 37.7505422236524 | -122.467572454931 | (37.7505422236524, -122.467572454931) | 1 | 8 | 4 | 29491 | 12 | |||
46458 | 218920 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113 Edgehill Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 1ft | 5994843.7095 | 2098965.85604 | 37.7430644264715 | -122.460480364392 | (37.7430644264715, -122.460480364392) | 1 | 8 | 4 | 59 | 40 | |||
48277 | 218918 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113 Edgehill Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 1ft | 5994865.26411 | 2098972.62162 | 37.743084243041 | -122.46040632501 | (37.743084243041, -122.46040632501) | 1 | 8 | 4 | 59 | 40 | |||
49251 | 218892 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1417 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993630.98387 | 2105872.61884 | 37.7619587852016 | -122.46517516541 | (37.7619587852016, -122.46517516541) | 1 | 8 | 11 | 56 | 12 | |||
50511 | 218850 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1885 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5991230.38459 | 2102597.67883 | 37.7528279396825 | -122.473238960832 | (37.7528279396825, -122.473238960832) | 1 | 8 | 4 | 56 | 12 | |||
51258 | 218955 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 118 Kensington Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994914.67576 | 2098399.27134 | 37.7415128081785 | -122.460193943808 | (37.7415128081785, -122.460193943808) | 1 | 8 | 4 | 59 | 40 | |||
55928 | 218937 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1003 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990714.31106 | 2102432.45211 | 37.7523443751123 | -122.475011559633 | (37.7523443751123, -122.475011559633) | 1 | 8 | 4 | 29491 | 12 | |||
56929 | 218907 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 24 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5993964.12784 | 2101005.28846 | 37.7486135528788 | -122.463669683224 | (37.7486135528788, -122.463669683224) | 1 | 8 | 4 | 29491 | 40 | |||
60407 | 218845 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5990904.30374 | 2104377.46542 | 37.7576958781743 | -122.474496472061 | (37.7576958781743, -122.474496472061) | 1 | 8 | 4 | 56 | 12 | |||
62585 | 218945 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 6 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995319.83888 | 2100306.50618 | 37.7467728969633 | -122.458931095094 | (37.7467728969633, -122.458931095094) | 1 | 5 | 4 | 59 | 40 | |||
64551 | 218954 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 118 Kensington Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994926.5671 | 2098382.9784 | 37.7414687557931 | -122.460151647795 | (37.7414687557931, -122.460151647795) | 1 | 8 | 4 | 59 | 40 | |||
66689 | 218889 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1379 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5993620.532 | 2106119.98089 | 37.7626373740382 | -122.465229282125 | (37.7626373740382, -122.465229282125) | 1 | 8 | 11 | 56 | 12 | |||
69219 | 218890 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 434 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993124.01114 | 2105981.91795 | 37.7622296439042 | -122.466936517307 | (37.7622296439042, -122.466936517307) | 1 | 8 | 11 | 56 | 12 | |||
69583 | 218957 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 138 Kensington Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994888.29565 | 2098436.07164 | 37.7416123352421 | -122.460287822233 | (37.7416123352421, -122.460287822233) | 1 | 8 | 4 | 59 | 40 | |||
71129 | 218847 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1701 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5990882.44412 | 2103778.75741 | 37.7560507177693 | -122.474528378177 | (37.7560507177693, -122.474528378177) | 1 | 8 | 4 | 56 | 12 | |||
74692 | 218852 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1346 16th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 5991155.44082 | 2106257.81656 | 37.7628733705378 | -122.473765117276 | (37.7628733705378, -122.473765117276) | 1 | 8 | 11 | 56 | 12 | |||
74887 | 218886 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1325 08th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5993604.91298 | 2106462.24667 | 37.7635762455734 | -122.465308165254 | (37.7635762455734, -122.465308165254) | 1 | 8 | 11 | 56 | 12 | |||
78198 | 218953 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 118 Kensington Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994930.91622 | 2098376.9452 | 37.7414524402787 | -122.460136173152 | (37.7414524402787, -122.460136173152) | 1 | 8 | 4 | 59 | 40 | |||
79708 | 218935 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1003 Ortega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990744.94543 | 2102432.18219 | 37.7523454093323 | -122.474905602418 | (37.7523454093323, -122.474905602418) | 1 | 8 | 4 | 29491 | 12 | |||
80982 | 218888 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1355 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5993614.91113 | 2106274.6654 | 37.7630617730996 | -122.465259958907 | (37.7630617730996, -122.465259958907) | 1 | 8 | 11 | 56 | 12 | |||
83074 | 218941 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1577 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991703.50942 | 2104618.1334 | 37.7584029620513 | -122.471750055828 | (37.7584029620513, -122.471750055828) | 1 | 8 | 4 | 56 | 12 | |||
84095 | 218883 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1325 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5993602.60771 | 2106503.30199 | 37.763688839782 | -122.4653191208 | (37.763688839782, -122.4653191208) | 1 | 8 | 11 | 56 | 12 | |||
92936 | 218928 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1487 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5994264.97027 | 2105409.64682 | 37.7607241230467 | -122.462948880187 | (37.7607241230467, -122.462948880187) | 1 | 5 | 11 | 56 | 12 | |||
95234 | 218887 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1351 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 5993614.10816 | 2106296.76328 | 37.7631224017894 | -122.4652643413 | (37.7631224017894, -122.4652643413) | 1 | 8 | 11 | 56 | 12 | |||
97467 | 218940 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1577 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991705.10597 | 2104613.00791 | 37.7583889811803 | -122.471744160777 | (37.7583889811803, -122.471744160777) | 1 | 8 | 4 | 56 | 12 | |||
101959 | 218884 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1325 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5993613.16109 | 2106492.9864 | 37.7636611244814 | -122.46528187088 | (37.7636611244814, -122.46528187088) | 1 | 8 | 11 | 56 | 12 | |||
103604 | 218910 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 623 Laguna Honda Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5995736.44002 | 2099882.18046 | 37.7456317427251 | -122.457459843802 | (37.7456317427251, -122.457459843802) | 1 | 5 | 4 | 59 | 40 | |||
114733 | 218911 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 623 Laguna Honda Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5995731.43182 | 2099885.12493 | 37.7456395398376 | -122.457477374284 | (37.7456395398376, -122.457477374284) | 1 | 5 | 4 | 59 | 40 | |||
122683 | 218902 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 42 Cragmont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992878.2163 | 2101759.21234 | 37.7506210024663 | -122.467479536961 | (37.7506210024663, -122.467479536961) | 1 | 8 | 4 | 29491 | 12 | |||
130872 | 218934 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1003 Ortega St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990760.83366 | 2102432.22352 | 37.7523464435445 | -122.47485066193 | (37.7523464435445, -122.47485066193) | 1 | 8 | 4 | 29491 | 12 | |||
134193 | 218943 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 60 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991395.44345 | 2104661.60275 | 37.7585044883033 | -122.472818643771 | (37.7585044883033, -122.472818643771) | 1 | 8 | 4 | 56 | 12 | |||
137483 | 218939 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1003 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990690.45077 | 2102431.07242 | 37.7523392040079 | -122.475093970812 | (37.7523392040079, -122.475093970812) | 1 | 8 | 4 | 29491 | 12 | |||
154169 | 218851 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 862 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992305.1409 | 2102909.15356 | 37.7537453407759 | -122.469544961337 | (37.7537453407759, -122.469544961337) | 1 | 8 | 4 | 56 | 12 | |||
154187 | 218942 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 50 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991391.23591 | 2104668.18352 | 37.7585223137837 | -122.472833675034 | (37.7585223137837, -122.472833675034) | 1 | 8 | 4 | 56 | 12 | |||
156351 | 218919 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113 Edgehill Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 1ft | 5994856.64782 | 2098970.17763 | 37.7430770367894 | -122.460435940561 | (37.7430770367894, -122.460435940561) | 1 | 8 | 4 | 59 | 40 | |||
165560 | 218917 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 113 Edgehill Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 1ft | 5994873.89414 | 2098975.72105 | 37.7430932497504 | -122.460376709425 | (37.7430932497504, -122.460376709425) | 1 | 8 | 4 | 59 | 40 | |||
165625 | 218956 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 138 Kensington Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994892.34654 | 2098430.04436 | 37.741596018846 | -122.460273379131 | (37.741596018846, -122.460273379131) | 1 | 8 | 4 | 59 | 40 | |||
167281 | 218930 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992779.48022 | 2105006.68335 | 37.7595320141225 | -122.468057167017 | (37.7595320141225, -122.468057167017) | 1 | 8 | 4 | 56 | 12 | |||
167358 | 218909 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 631 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5995768.57404 | 2099858.15881 | 37.7455676309566 | -122.457346992384 | (37.7455676309566, -122.457346992384) | 1 | 5 | 4 | 59 | 40 | |||
173329 | 218906 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 160 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5993761.11686 | 2099844.95033 | 37.7454158586537 | -122.46428745721 | (37.7454158586537, -122.46428745721) | 1 | 8 | 4 | 29491 | 40 | |||
173583 | 218933 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1003 Ortega St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990778.98274 | 2102431.84048 | 37.7523464435342 | -122.474787872164 | (37.7523464435342, -122.474787872164) | 1 | 8 | 4 | 29491 | 12 | |||
175529 | 218882 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1389 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5993931.65065 | 2106031.17982 | 37.7624114859176 | -122.464146796035 | (37.7624114859176, -122.464146796035) | 1 | 5 | 11 | 56 | 12 | |||
176991 | 218908 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 631 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995776.70302 | 2099852.94051 | 37.7455537696964 | -122.457318506357 | (37.7455537696964, -122.457318506357) | 1 | 5 | 4 | 59 | 40 | |||
178346 | 218938 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1003 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990704.08635 | 2102431.91459 | 37.7523423066512 | -122.475046878734 | (37.7523423066512, -122.475046878734) | 1 | 8 | 4 | 29491 | 12 | |||
179637 | 218905 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 160 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993770.37012 | 2099854.03148 | 37.7454413265483 | -122.464256120347 | (37.7454413265483, -122.464256120347) | 1 | 8 | 4 | 29491 | 40 | |||
181639 | 218885 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1325 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5993612.72402 | 2106472.17655 | 37.7636039608794 | -122.46528187088 | (37.7636039608794, -122.46528187088) | 1 | 8 | 11 | 56 | 12 | |||
187029 | 218901 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 42 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992873.02689 | 2101774.15085 | 37.7506617201688 | -122.467498568411 | (37.7506617201688, -122.467498568411) | 1 | 8 | 4 | 29491 | 12 | |||
191232 | 218946 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 15 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 3ft | 5995278.15169 | 2100133.50673 | 37.7462954873605 | -122.459062719878 | (37.7462954873605, -122.459062719878) | 1 | 8 | 4 | 59 | 40 | |||
588 | 59987 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1546 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/1982 12:00:00 AM | 20 | Permit Number 19471 | 6015827.92235 | 2097026.68646 | 37.7389247113108 | -122.387786695709 | (37.7389247113108, -122.387786695709) | 10 | 3 | 8 | 58 | 1 | ||
1510 | 61316 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1411 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 21 | Permit Number 21219 | 6011759.251 | 2101715.45537 | 37.7515728377404 | -122.402183919859 | (37.7515728377404, -122.402183919859) | 10 | 3 | 8 | 28856 | 29 | |
2015 | 61308 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2309 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 15 | Permit Number 21207 | 6011873.01335 | 2101843.07946 | 37.7519296149817 | -122.401799483056 | (37.7519296149817, -122.401799483056) | 10 | 3 | 8 | 28856 | 29 | |
2199 | 61312 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1458 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 20 | 4x4 | Permit Number 21213 | 6011710.55671 | 2101566.51843 | 37.7511611712496 | -122.402341840826 | (37.7511611712496, -122.402341840826) | 10 | 3 | 8 | 28856 | 29 |
2274 | 40857 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1446 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1999 12:00:00 AM | 19 | Permit Number 41781 | 6011709.76908 | 2101616.07805 | 37.7512972071976 | -122.402348048823 | (37.7512972071976, -122.402348048823) | 10 | 3 | 8 | 28856 | 29 | |
3047 | 189052 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1498 Fairfax Ave | 9 | : | Tree | Private 2 | 04/13/2020 12:00:00 AM | 3 | Width 4ft | 6016122.19881 | 2097851.77649 | 37.7412065377553 | -122.386826739572 | (37.7412065377553, -122.386826739572) | 10 | 3 | 8 | 58 | 1 | ||
3467 | 189657 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2505 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6015867.18038 | 2103823.80533 | 37.7575903607135 | -122.388125177147 | (37.7575903607135, -122.388125177147) | 10 | 3 | 8 | 28856 | 29 | |||
3501 | 189764 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2200 26th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6011937.99786 | 2101379.88854 | 37.7506614197981 | -122.401542205007 | (37.7506614197981, -122.401542205007) | 10 | 3 | 8 | 28856 | 29 | ||||
3884 | 61317 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1415 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 22 | Permit Number 21220 | 6011760.1009 | 2101696.61273 | 37.7515211473979 | -122.402179656165 | (37.7515211473979, -122.402179656165) | 10 | 3 | 8 | 28856 | 29 | |
5867 | 176470 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 130 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009916.73377 | 2094983.66925 | 37.7329857989392 | -122.408080900424 | (37.7329857989392, -122.408080900424) | 10 | 3 | 7 | 309 | 28 | |||
6796 | 61320 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1477 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 16 | Permit Number 21223 | 6011774.39181 | 2101489.85478 | 37.7509542327749 | -122.402115701805 | (37.7509542327749, -122.402115701805) | 10 | 3 | 8 | 28856 | 29 | |
8684 | 189714 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 550 Wisconsin St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 6012647.13321 | 2104908.73509 | 37.7603904062104 | -122.39933764023 | (37.7603904062104, -122.39933764023) | 10 | 3 | 8 | 28856 | 29 | |||
9293 | 61314 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1367 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 14 | Permit Number 21216 | 6011746.30755 | 2101998.58659 | 37.752349531804 | -122.40224858471 | (37.752349531804, -122.40224858471) | 10 | 3 | 8 | 28856 | 29 | |
10227 | 189669 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 5ft | 6015848.0451 | 2104085.46802 | 37.7583077705949 | -122.388209616279 | (37.7583077705949, -122.388209616279) | 10 | 3 | 8 | 28856 | 29 | |||
10414 | 41425 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1568 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/2000 12:00:00 AM | 14 | Permit Number 42032 | 6015102.0577 | 2101304.61846 | 37.7506307870794 | -122.390595272152 | (37.7506307870794, -122.390595272152) | 10 | 3 | 8 | 28856 | 1 | |
10718 | 61315 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1407 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 22 | Permit Number 21218 | 6011759.20106 | 2101763.54314 | 37.7517048734844 | -122.402187473086 | (37.7517048734844, -122.402187473086) | 10 | 3 | 8 | 28856 | 29 | |
10727 | 190148 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1711 Oakdale Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014397.54059 | 2095926.93864 | 37.7358256897857 | -122.392655422032 | (37.7358256897857, -122.392655422032) | 10 | 3 | 8 | 58 | 1 | |||
11696 | 189660 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2573 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 4ft | 6015900.45488 | 2103484.96239 | 37.7566618134199 | -122.387986454936 | (37.7566618134199, -122.387986454936) | 10 | 3 | 8 | 28856 | 29 | |||
12239 | 189672 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2427 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6015841.43821 | 2104253.31303 | 37.7587682711682 | -122.388244179947 | (37.7587682711682, -122.388244179947) | 10 | 3 | 8 | 28856 | 29 | |||
12328 | 61311 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1434 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 17 | Permit Number 21210 | 6011707.20776 | 2101666.6953 | 37.7514360481513 | -122.402360464866 | (37.7514360481513, -122.402360464866) | 10 | 3 | 8 | 28856 | 29 | |
12375 | 226540 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1220 Potrero Ave | 2 | : | Tree | Private 2 | 28 | Width 4ft | 6010529.29654 | 2102158.63708 | 37.752720986907 | -122.406468503221 | (37.752720986907, -122.406468503221) | 10 | 4 | 7 | 28859 | 19 | |||
12432 | 189645 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2300 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010927.82584 | 2105101.25032 | 37.7608230358835 | -122.405297514886 | (37.7608230358835, -122.405297514886) | 10 | 3 | 8 | 28856 | 29 | |||
12592 | 190145 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1270 Fairfax Ave | 5 | : | Tree | Private 2 | 16 | Width 4ft | 6017279.69898 | 2096994.64423 | 37.7389170445949 | -122.38276484453 | (37.7389170445949, -122.38276484453) | 10 | 3 | 8 | 58 | 1 | |||
12986 | 189793 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 308 Hernandez Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6013450.09241 | 2105609.9853 | 37.7623606049856 | -122.396609715861 | (37.7623606049856, -122.396609715861) | 10 | 3 | 8 | 28856 | 29 | |||
13912 | 189747 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2101 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011437.2397 | 2105085.01288 | 37.7608069191222 | -122.403534526214 | (37.7608069191222, -122.403534526214) | 10 | 3 | 8 | 28856 | 29 | |||
15334 | 59986 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1552 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/1982 12:00:00 AM | 19 | 3x3 | Permit Number 19470 | 6015757.2015 | 2097078.53248 | 37.7390631520541 | -122.388034834851 | (37.7390631520541, -122.388034834851) | 10 | 3 | 8 | 58 | 1 | |
15886 | 189725 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 645 Carolina St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 4ft | 6012416.08183 | 2104951.55133 | 37.7604950899983 | -122.400139751846 | (37.7604950899983, -122.400139751846) | 10 | 3 | 8 | 28856 | 29 | |||
16022 | 189735 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 601 Carolina St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6012410.52829 | 2105115.38305 | 37.7609446260225 | -122.400170465508 | (37.7609446260225, -122.400170465508) | 10 | 3 | 8 | 28856 | 29 | |||
16041 | 62085 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 509 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 15 | Permit Number 31131 | 6013285.17961 | 2104603.40467 | 37.7595875760112 | -122.397109508714 | (37.7595875760112, -122.397109508714) | 10 | 3 | 8 | 28856 | 29 | |
17006 | 40089 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1464 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1984 12:00:00 AM | 20 | 4x4 | Permit Number 41313 | 6011714.10496 | 2101526.60671 | 37.7510517804331 | -122.40232676458 | (37.7510517804331, -122.40232676458) | 10 | 3 | 8 | 28856 | 29 |
17959 | 69744 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1855X Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6014390.51341 | 2099418.69013 | 37.7454129250631 | -122.392923937985 | (37.7454129250631, -122.392923937985) | 10 | 3 | 8 | 58 | 1 | ||
18082 | 190134 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 599 Barneveld Ave | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6011052.12686 | 2097137.70773 | 37.7389638381042 | -122.404307086999 | (37.7389638381042, -122.404307086999) | 10 | 3 | 8 | 58 | 1 | |||
19964 | 226539 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1220 Potrero Ave | 1 | : | Tree | Private 2 | 23 | Width 4ft | 6010527.00308 | 2102195.727 | 37.7528226993215 | -122.406479047766 | (37.7528226993215, -122.406479047766) | 10 | 4 | 7 | 28859 | 19 | |||
20318 | 58775 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1151 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1979 12:00:00 AM | 21 | Permit Number 18018 | 6011965.68548 | 2103057.98267 | 37.7552706449278 | -122.401564386789 | (37.7552706449278, -122.401564386789) | 10 | 3 | 8 | 28856 | 29 | ||
20354 | 190147 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1779 Oakdale Ave | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6014086.91592 | 2096161.37872 | 37.7364521575355 | -122.393745786146 | (37.7364521575355, -122.393745786146) | 10 | 3 | 8 | 58 | 1 | |||
21206 | 189723 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 645 Carolina St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 6012421.63462 | 2104907.53528 | 37.7603745412592 | -122.40011745588 | (37.7603745412592, -122.40011745588) | 10 | 3 | 8 | 28856 | 29 | |||
21734 | 61319 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1425 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1984 12:00:00 AM | 24 | Permit Number 21222 | 6011767.84786 | 2101592.50554 | 37.7512357241518 | -122.402145547589 | (37.7512357241518, -122.402145547589) | 10 | 3 | 8 | 28856 | 29 | ||
23471 | 6803 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1381 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6016702.46097 | 2097342.51463 | 37.7398403182643 | -122.384784912507 | (37.7398403182643, -122.384784912507) | 10 | 3 | 8 | 58 | 1 | |||
23580 | 101653 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1103 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6012239.53744 | 2103251.34702 | 37.7558168580866 | -122.400630902213 | (37.7558168580866, -122.400630902213) | 10 | 3 | 8 | 28856 | 29 | |||
24885 | 96562 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 421 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6009504.65574 | 2092358.16495 | 37.7257536399061 | -122.409320351472 | (37.7257536399061, -122.409320351472) | 10 | 3 | 7 | 309 | 28 | |||
25039 | 111177 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 211 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6009453.85079 | 2094770.82472 | 37.7323754452754 | -122.409666196537 | (37.7323754452754, -122.409666196537) | 10 | 3 | 7 | 309 | 28 | |||
25086 | 189675 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1 24th St | 10 | : Yard | Tree | Private 2 | 8 | 6017194.50129 | 2102669.93128 | 37.7544955147815 | -122.383454393407 | (37.7544955147815, -122.383454393407) | 10 | 3 | 8 | 28856 | 29 | ||||
25706 | 189652 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2145 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011289.00869 | 2105542.2211 | 37.7620540296963 | -122.404079371462 | (37.7620540296963, -122.404079371462) | 10 | 3 | 8 | 28856 | 29 | |||
27002 | 189763 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2200 26th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6011959.27944 | 2101379.59003 | 37.7506617876195 | -122.401468590114 | (37.7506617876195, -122.401468590114) | 10 | 3 | 8 | 28856 | 29 |
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) );