trees
4,014 rows where qSpecies_id = 40 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
632 | 23885 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1750X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6003231.6817 | 2113926.646 | 37.7846221123784 | -122.432545437068 | (37.7846221123784, -122.432545437068) | 13 | 9 | 11 | 29490 | 13 | |||
1360 | 238060 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2x Montezuma St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6007260.48935 | 2099759.47356 | 37.7459500163869 | -122.417602623671 | (37.7459500163869, -122.417602623671) | 2 | 7 | 7 | 28859 | 2 | |||
2806 | 91889 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1112 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992343.82828 | 2106622.674723 | 37.7639439315835 | -122.469681499547 | (37.7639439315835, -122.469681499547) | 11 | 8 | 11 | 56 | 12 | ||
3032 | 4178 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3814 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 05:09:00 AM | 3 | 4x4 | 6005035.97287 | 2100499.61266 | 37.7478568435292 | -122.425347365702 | (37.7478568435292, -122.425347365702) | 2 | 4 | 5 | 63 | 22 | ||
5639 | 85379 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3390 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6007302.06128 | 2100623.11206 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | 2 | 4 | 7 | 28859 | 19 | |||
7115 | 4034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2150 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/1995 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
7312 | 254991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1508 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2020 12:00:00 PM | 3 | 4x4 | 6002019 | 2093366 | 37.7280986838153 | -122.435269719024 | (37.7280986838153, -122.435269719024) | 9 | 7 | 6 | 28861 | 25 | ||
7896 | 4158 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3739-3737 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1989 12:00:00 AM | 12 | 3X3 | 6005577.78119 | 2100485.82594 | 37.7478495841857 | -122.423472835916 | (37.7478495841857, -122.423472835916) | 2 | 4 | 5 | 28859 | 22 | ||
10261 | 89402 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1914 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992725.99788 | 2112086.29643 | 37.7789676550624 | -122.468757294436 | (37.7789676550624, -122.468757294436) | 11 | 6 | 2 | 54 | 11 | ||
10602 | 104255 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
13408 | 28246 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3326 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2002 12:00:00 AM | 3 | 2X3 | 6011947.80562 | 2090200.17318 | 37.7199648154144 | -122.400722979282 | (37.7199648154144, -122.400722979282) | 10 | 7 | 8 | 309 | 28 | ||
13720 | 91923 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1427 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991353.957672 | 2106548.744029 | 37.76368367545 | -122.473099740894 | (37.76368367545, -122.473099740894) | 1 | 8 | 11 | 56 | 12 | ||
15218 | 91934 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1115 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992339.241228 | 2106582.494136 | 37.7638333412086 | -122.46969443927 | (37.7638333412086, -122.46969443927) | 1 | 8 | 11 | 56 | 12 | ||
16146 | 4184 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3835 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6004944.66483 | 2100451.11353 | 37.7477185170056 | -122.425659653475 | (37.7477185170056, -122.425659653475) | 2 | 4 | 5 | 63 | 22 | ||
17324 | 91930 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201X IRVING ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5992070 | 2106573 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | 1 | 8 | 11 | 56 | 12 | ||
17761 | 91919 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1445 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991297.838563 | 2106546.821696 | 37.7636751478808 | -122.473293697328 | (37.7636751478808, -122.473293697328) | 1 | 8 | 11 | 56 | 12 | ||
17945 | 4290 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4319 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001811.82225 | 2100290.20269 | 37.7470991700926 | -122.436481321561 | (37.7470991700926, -122.436481321561) | 2 | 4 | 5 | 63 | 22 | ||
18876 | 91915 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1555 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5990949.753071 | 2106534.898314 | 37.7636222478093 | -122.474496734343 | (37.7636222478093, -122.474496734343) | 1 | 8 | 11 | 56 | 12 | ||
19654 | 86060 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1869 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987511.195169 | 2102571.591241 | 37.7525402584661 | -122.486098523179 | (37.7525402584661, -122.486098523179) | 1 | 8 | 3 | 56 | 35 | ||
22886 | 27724 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015353.11348 | 2101161.82636 | 37.750252634764 | -122.389717121075 | (37.750252634764, -122.389717121075) | 10 | 3 | 8 | 28856 | 1 | ||
22969 | 103049 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
23030 | 135979 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.7882275541095 | -122.419939904112 | (37.7882275541095, -122.419939904112) | 13 | 9 | 10 | 28858 | 21 | ||
23147 | 4246 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4038 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/1995 12:00:00 AM | 3 | 3X3 | 6003621.03642 | 2100422.76167 | 37.747565786929 | -122.430234665696 | (37.747565786929, -122.430234665696) | 2 | 4 | 5 | 63 | 22 | ||
24571 | 29668 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2500 Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12/09/2004 12:00:00 AM | 6 | 6005837.0202043 | 2118942.4447679 | 37.7985416396102 | -122.423888617279 | (37.7985416396102, -122.423888617279) | 13 | 9 | 10 | 28858 | 32 | |||
24604 | 13087 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | ||
24882 | 4146 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3615-3623X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | ||
25185 | 86250 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2242 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988568.630653 | 2100055.451314 | 37.7456931770541 | -122.48225744502 | (37.7456931770541, -122.48225744502) | 1 | 8 | 3 | 29491 | 35 | ||
25298 | 91932 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992089.071506 | 2106573.92474 | 37.7637953493605 | -122.470559068172 | (37.7637953493605, -122.470559068172) | 1 | 8 | 11 | 56 | 12 | ||
25941 | 86219 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2643 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988933.146151 | 2097346.520353 | 37.7382763570454 | -122.480798730272 | (37.7382763570454, -122.480798730272) | 1 | 8 | 3 | 29491 | 35 | ||
26130 | 90632 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3040 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5986103.36345 | 2110484.37412 | 37.7741844123978 | -122.491549374976 | (37.7741844123978, -122.491549374976) | 11 | 6 | 2 | 55 | 26 | ||
27355 | 239457 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | 2 | 7 | 5 | 63 | 7 | |
28138 | 10217 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1351 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2002 12:00:00 AM | 6 | 3X3 | 6005868.4867153 | 2101104.801102 | 37.7495655521395 | -122.422511564697 | (37.7495655521395, -122.422511564697) | 2 | 4 | 5 | 28859 | 19 | ||
28311 | 4063 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3053 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/15/1995 12:00:00 AM | 3 | 3X3 | 6009245.44366 | 2100538.36575 | 37.7482001758998 | -122.410793893342 | (37.7482001758998, -122.410793893342) | 2 | 4 | 7 | 28859 | 2 | ||
28747 | 4142 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3615-3623X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538 | 2100417 | 37.7476583584974 | -122.423605504909 | (37.7476583584974, -122.423605504909) | 2 | 7 | 5 | 28859 | 22 | ||
29752 | 85380 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3390 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6007302.06128 | 2100623.11206 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | 2 | 4 | 7 | 28859 | 19 | |||
29786 | 24463 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3550 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/1995 12:00:00 AM | 3 | 3x3 | 6006349.89396 | 2100605.16699 | 37.7482208171583 | -122.420811373242 | (37.7482208171583, -122.420811373242) | 2 | 4 | 5 | 28859 | 19 | ||
30319 | 136006 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1237x Robert C Levy Tunl | 10 | Median : Yard | Tree | DPW 1 | 3 | 6007669.82361 | 2118117.13537 | 37.7963788445653 | -122.417488005977 | (37.7963788445653, -122.417488005977) | 5 | 1 | 10 | 28858 | 32 | ||||
31046 | 214521 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 945 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2014 12:00:00 AM | 2 | Width 3ft | 5992776.19936 | 2106588.69627 | 37.7638756163819 | -122.468183598193 | (37.7638756163819, -122.468183598193) | 1 | 8 | 11 | 56 | 12 | ||
31187 | 27731 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015524.1696 | 2101161.19501 | 37.7502603851148 | -122.38912554882 | (37.7502603851148, -122.38912554882) | 10 | 3 | 8 | 28856 | 1 | ||
31840 | 103051 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
32418 | 18982 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2920 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000616.67404 | 2115546.70514 | 37.7889217363036 | -122.441708766757 | (37.7889217363036, -122.441708766757) | 13 | 6 | 1 | 29490 | 27 | |||
32572 | 214563 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1450 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/2015 01:07:00 PM | 1 | 3x3 | 5991226.48085 | 2106597.45408 | 37.7638100387342 | -122.473544192526 | (37.7638100387342, -122.473544192526) | 11 | 8 | 11 | 56 | 12 | ||
33392 | 91981 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1210 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993318.025647 | 2107238.104165 | 37.7656899972839 | -122.46635680061 | (37.7656899972839, -122.46635680061) | 11 | 8 | 11 | 56 | 12 | ||
33487 | 91916 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1555 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5990949.753071 | 2106534.898314 | 37.7636222478093 | -122.474496734343 | (37.7636222478093, -122.474496734343) | 1 | 8 | 11 | 56 | 12 | ||
35803 | 1375 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/1999 12:00:00 AM | 3 | 1X1 | 5998969.36906 | 2100010.78272 | 37.7461700211271 | -122.446290155185 | (37.7461700211271, -122.446290155185) | 2 | 7 | 5 | 63 | 22 | ||
36307 | 237111 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2x Coso Ave | 7 | Median : Yard | Tree | DPW 1 | 2 | 6007125.29232 | 2099860.06971 | 37.7462186223039 | -122.418077248072 | (37.7462186223039, -122.418077248072) | 2 | 7 | 7 | 28859 | 2 | ||||
36907 | 91957 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 605 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993916.960821 | 2106636.537582 | 37.7640727935932 | -122.464241552933 | (37.7640727935932, -122.464241552933) | 1 | 5 | 11 | 56 | 12 | ||
37152 | 86220 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2663 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988937.695499 | 2097215.793619 | 37.7379176798007 | -122.480773433176 | (37.7379176798007, -122.480773433176) | 1 | 8 | 3 | 29491 | 35 | ||
37384 | 89680 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2501 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990849.40142 | 2111961.25142 | 37.778515724988 | -122.475239995663 | (37.778515724988, -122.475239995663) | 11 | 6 | 2 | 54 | 26 | ||
38224 | 86070 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2115 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987568.946045 | 2100884.101082 | 37.7479102288924 | -122.485774970523 | (37.7479102288924, -122.485774970523) | 1 | 8 | 3 | 29491 | 35 | ||
38821 | 91970 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1350 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993350.61101 | 2106290.929173 | 37.763091183898 | -122.466175257659 | (37.763091183898, -122.466175257659) | 1 | 8 | 11 | 56 | 12 | ||
39748 | 86007 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987522.322672 | 2103422.53403 | 37.7548773659795 | -122.486122503429 | (37.7548773659795, -122.486122503429) | 1 | 8 | 3 | 56 | 35 | ||
40527 | 14625 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 15 Matthew Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 12 | 3X4 | 6017974.7726653 | 2094204.273773 | 37.7312936151853 | -122.380167719121 | (37.7312936151853, -122.380167719121) | 10 | 3 | 8 | 58 | 1 | ||
41201 | 85934 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1630 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988116.725594 | 2104200.7569 | 37.7570487799795 | -122.484123984508 | (37.7570487799795, -122.484123984508) | 1 | 8 | 3 | 56 | 35 | ||
41362 | 4071 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3148 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6008736.4549488 | 2100618.4445096 | 37.7483915020352 | -122.412559626587 | (37.7483915020352, -122.412559626587) | 2 | 4 | 7 | 28859 | 19 | |||
42220 | 23053 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1074 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/1992 12:00:00 AM | 18 | 3X3 | 6006318.63458 | 2103360.59062 | 37.7557848161263 | -122.421115089604 | (37.7557848161263, -122.421115089604) | 2 | 4 | 5 | 28859 | 19 | ||
42916 | 24441 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4162 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/1995 12:00:00 AM | 3 | 3X3 | 6002908.04263 | 2100385.03446 | 37.747421786582 | -122.432697458221 | (37.747421786582, -122.432697458221) | 2 | 4 | 5 | 63 | 22 | ||
43106 | 84648 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 301X 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/21/2006 12:00:00 AM | 10 | 3x3 | 6004302 | 2098976 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | 2 | 7 | 5 | 63 | 22 | ||
43204 | 4052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 3X3 | 6010072.48365 | 2100637.4543 | 37.7485185889697 | -122.407940988391 | (37.7485185889697, -122.407940988391) | 2 | 4 | 7 | 28859 | 19 | ||
43713 | 91953 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 701 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5993618.512619 | 2106626.314461 | 37.7640275170127 | -122.465273046982 | (37.7640275170127, -122.465273046982) | 1 | 8 | 11 | 56 | 12 | ||
43804 | 214546 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 714 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/03/2015 02:50:00 PM | 1 | Width 3ft | 5993519.43334 | 2106675.98145 | 37.7641581752734 | -122.465619338785 | (37.7641581752734, -122.465619338785) | 11 | 8 | 11 | 56 | 12 | ||
44381 | 237352 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3186 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 4x4 | 6008549.69387 | 2100618.49329 | 37.7483811527756 | -122.413205447889 | (37.7483811527756, -122.413205447889) | 2 | 4 | 7 | 28859 | 19 | |||
44536 | 90634 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3040 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5986072.77522 | 2110484.39056 | 37.774182669932 | -122.491655184841 | (37.774182669932, -122.491655184841) | 11 | 6 | 2 | 55 | 26 | ||
44635 | 86376 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988009.291975 | 2106160.192246 | 37.7624226008214 | -122.484639253233 | (37.7624226008214, -122.484639253233) | 1 | 8 | 3 | 56 | 35 | ||
44977 | 14411 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2001X Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2001 12:00:00 AM | 6 | 3X3 | 6009024.63169 | 2120105.21371 | 37.8019137522347 | -122.412940701134 | (37.8019137522347, -122.412940701134) | 3 | 1 | 10 | 308 | 32 | ||
45181 | 91941 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 925 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992928.667696 | 2106602.68442 | 37.7639228286278 | -122.467657278128 | (37.7639228286278, -122.467657278128) | 1 | 8 | 11 | 56 | 12 | ||
45598 | 91902 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1516 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5991061.448475 | 2106578.747768 | 37.7637491175921 | -122.474113618488 | (37.7637491175921, -122.474113618488) | 11 | 8 | 11 | 56 | 12 | ||
46019 | 91983 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1239 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993284.406043 | 2107051.954484 | 37.7651769393996 | -122.46645955172 | (37.7651769393996, -122.46645955172) | 11 | 8 | 11 | 56 | 12 | ||
46115 | 89676 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2543 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990695.40247 | 2111954.91498 | 37.7784893997562 | -122.47577226814 | (37.7784893997562, -122.47577226814) | 11 | 6 | 2 | 54 | 26 | ||
46482 | 86034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987415.003943 | 2106546.656914 | 37.7634490992174 | -122.486723028948 | (37.7634490992174, -122.486723028948) | 1 | 8 | 3 | 56 | 35 | ||
46627 | 4206 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3920 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004377.17948 | 2100465.22503 | 37.7477251809744 | -122.427622993127 | (37.7477251809744, -122.427622993127) | 2 | 4 | 5 | 63 | 22 | ||
46777 | 91966 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1376 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993356.433228 | 2106121.691358 | 37.7626268371313 | -122.466142821616 | (37.7626268371313, -122.466142821616) | 1 | 8 | 11 | 56 | 12 | ||
47254 | 85988 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2258 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987642.054438 | 2099919.450203 | 37.7452658143921 | -122.485451389583 | (37.7452658143921, -122.485451389583) | 1 | 8 | 3 | 29491 | 35 | ||
48274 | 103042 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | 7 | 9 | 11 | 28852 | 10 | |||
48299 | 4182 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3830 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6004950.59619 | 2100495.54046 | 37.7478408382818 | -122.42564230465 | (37.7478408382818, -122.42564230465) | 2 | 4 | 5 | 63 | 22 | |||
49146 | 104249 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
50320 | 28085 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.7868542683748 | -122.434200102392 | (37.7868542683748, -122.434200102392) | 13 | 9 | 11 | 29490 | 27 | |||
50439 | 85991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2222 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987633.933236 | 2100153.700526 | 37.7459085303186 | -122.48549665823 | (37.7459085303186, -122.48549665823) | 1 | 8 | 3 | 29491 | 35 | ||
50628 | 91984 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1243 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993285.31415 | 2107025.55813 | 37.7651045143653 | -122.466454492146 | (37.7651045143653, -122.466454492146) | 11 | 8 | 11 | 56 | 12 | ||
50857 | 26729 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
51415 | 85942 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988096.057532 | 2104801.525596 | 37.7586971246889 | -122.484239519903 | (37.7586971246889, -122.484239519903) | 1 | 8 | 3 | 56 | 35 | ||
52392 | 27729 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015622.7491 | 2101166.85438 | 37.7502813887778 | -122.3887850466 | (37.7502813887778, -122.3887850466) | 10 | 3 | 8 | 28856 | 1 | ||
54437 | 52014 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 301X 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/12/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48233 | 6004302 | 2098976 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | 2 | 7 | 5 | 63 | 22 | |
55019 | 85943 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1538 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988095.160504 | 2104827.59989 | 37.7587686653948 | -122.484244534442 | (37.7587686653948, -122.484244534442) | 1 | 8 | 3 | 56 | 35 | ||
55373 | 23868 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1495X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2011 12:00:00 AM | 3 | 3X3 | 6003590.02358 | 2113875.44534 | 37.7845018426272 | -122.431302039005 | (37.7845018426272, -122.431302039005) | 13 | 9 | 11 | 29490 | 41 | ||
57105 | 10022 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 282 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/2003 12:00:00 AM | 3 | 2x2 | 6005445.78054 | 2107378.48496 | 37.7667677623348 | -122.424419474005 | (37.7667677623348, -122.424419474005) | 8 | 4 | 5 | 28853 | 19 | ||
57569 | 86581 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2547 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987979.82634 | 2097967.749244 | 37.7399266315394 | -122.484140344437 | (37.7399266315394, -122.484140344437) | 1 | 8 | 3 | 29491 | 35 | ||
58554 | 87738 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 10 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | 5 | 1 | 1 | 28858 | 32 | ||
58838 | 91880 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 840 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5993189.659614 | 2106651.64796 | 37.7640723354625 | -122.466758152363 | (37.7640723354625, -122.466758152363) | 11 | 8 | 11 | 56 | 12 | ||
58893 | 86321 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1723 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988408.134093 | 2103583.601964 | 37.7553712008265 | -122.483070961912 | (37.7553712008265, -122.483070961912) | 1 | 8 | 3 | 56 | 35 | ||
58950 | 91948 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 823 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993244.611031 | 2106613.506821 | 37.7639707811348 | -122.466565320592 | (37.7639707811348, -122.466565320592) | 1 | 8 | 11 | 56 | 12 | ||
60283 | 4218 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3955 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/1998 12:00:00 AM | 3 | 3X3 | 6004198.47443 | 2100405.87482 | 37.7475521091462 | -122.428236716561 | (37.7475521091462, -122.428236716561) | 2 | 4 | 5 | 63 | 22 | ||
60351 | 135978 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.7882128537759 | -122.420019889812 | (37.7882128537759, -122.420019889812) | 13 | 9 | 10 | 28858 | 21 | ||
61092 | 10178 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1086 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/2001 12:00:00 AM | 16 | 2X2 | 6005705.19862 | 2102704.3683 | 37.7539483816144 | -122.423189907382 | (37.7539483816144, -122.423189907382) | 2 | 4 | 5 | 28859 | 19 | ||
62451 | 91030 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1086 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6009941.213427 | 2111462.810786 | 37.7782352043229 | -122.409158690819 | (37.7782352043229, -122.409158690819) | 14 | 2 | 9 | 28853 | 34 | ||
62778 | 85946 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1490 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988083.436249 | 2105168.393711 | 37.7597037099979 | -122.484310075897 | (37.7597037099979, -122.484310075897) | 1 | 8 | 3 | 56 | 35 | ||
62955 | 91942 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 917 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992952.37712 | 2106603.496565 | 37.7639264274827 | -122.467575334102 | (37.7639264274827, -122.467575334102) | 1 | 8 | 11 | 56 | 12 | ||
63480 | 91926 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1401 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991435.018606 | 2106551.520732 | 37.7636959924857 | -122.472819581527 | (37.7636959924857, -122.472819581527) | 1 | 8 | 11 | 56 | 12 | ||
63599 | 91947 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 827 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993232.703909 | 2106613.098951 | 37.7639689741056 | -122.466606473793 | (37.7639689741056, -122.466606473793) | 1 | 8 | 11 | 56 | 12 | ||
64315 | 14623 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837712 | 37.7313920698281 | -122.380024515102 | (37.7313920698281, -122.380024515102) | 10 | 3 | 8 | 58 | 1 |
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) );