trees
575 rows where qSpecies_id = 123 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
153411 | 241275 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1400 Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010636.10474 | 2101276.89456 | 37.750305890826 | -122.406037027383 | (37.750305890826, -122.406037027383) | 10 | 4 | 7 | 28859 | 19 | |||
157891 | 241292 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1223 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011155.71596 | 2102482.72814 | 37.7536458937577 | -122.404325030294 | (37.7536458937577, -122.404325030294) | 10 | 4 | 8 | 28859 | 19 | |||
160657 | 37985 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 570 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 11 | Permit Number 40207 | 6013793.63158 | 2104435.25023 | 37.7591541522658 | -122.395339235527 | (37.7591541522658, -122.395339235527) | 10 | 3 | 8 | 28856 | 29 | |
160886 | 196978 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6013296.03231 | 2104723.49575 | 37.7599179239891 | -122.397080394946 | (37.7599179239891, -122.397080394946) | 10 | 3 | 8 | 28856 | 29 | |||
162699 | 22272 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4720 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/03/1995 12:00:00 AM | 6 | 3x3 | 6014914.77079 | 2095774.79236 | 37.7354366396256 | -122.390856509346 | (37.7354366396256, -122.390856509346) | 10 | 3 | 8 | 58 | 1 | ||
163314 | 22266 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | 6 | 3X3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | ||
168607 | 196986 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6011820.27046 | 2100794.29001 | 37.7490469235803 | -122.40190815805 | (37.7490469235803, -122.40190815805) | 10 | 3 | 8 | 58 | 1 | |||
170027 | 22282 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 4 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
170158 | 196985 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6011820.47885 | 2100780.87152 | 37.7490100909441 | -122.401906494295 | (37.7490100909441, -122.401906494295) | 10 | 3 | 8 | 58 | 1 | |||
174039 | 22279 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | |||
176314 | 196982 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
183387 | 22238 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4420 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015163.3661 | 2096572.43152 | 37.7376405844607 | -122.390052718455 | (37.7376405844607, -122.390052718455) | 10 | 3 | 8 | 58 | 1 | ||
184282 | 25586 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150X Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1997 12:00:00 AM | 30 | 3X3 | 6008754.8829591 | 2097365.1323636 | 37.7394596586207 | -122.412265995986 | (37.7394596586207, -122.412265995986) | 10 | 7 | 7 | 28859 | 2 | ||
184445 | 196996 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 10 | : | Tree | Private 2 | 8 | Width 4ft | 6013793.66265 | 2100133.46781 | 37.7473423827584 | -122.395037822335 | (37.7473423827584, -122.395037822335) | 10 | 3 | 8 | 58 | 1 | |||
186419 | 100315 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6015443.91077 | 2097940.33755 | 37.7414121299803 | -122.389178220304 | (37.7414121299803, -122.389178220304) | 10 | 3 | 8 | 58 | 1 | |||
187496 | 241285 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1201 Vermont St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011473.17853 | 2101977.48291 | 37.75227633599 | -122.403191629999 | (37.75227633599, -122.403191629999) | 10 | 4 | 8 | 28859 | 19 | |||
191217 | 22252 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4544 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1993 12:00:00 AM | 6 | 3x3 | 6015060.7997 | 2096239.5516 | 37.7367208751663 | -122.390384090827 | (37.7367208751663, -122.390384090827) | 10 | 3 | 8 | 58 | 1 | ||
193442 | 101629 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
193907 | 196992 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 5 | : | Tree | Private 2 | 7 | Width 4ft | 6013942.24849 | 2100140.56785 | 37.7473701394162 | -122.394524516312 | (37.7473701394162, -122.394524516312) | 10 | 3 | 8 | 58 | 1 | |||
193922 | 179281 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 16 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010435.48171 | 2094947.68687 | 37.7329160304499 | -122.406284910247 | (37.7329160304499, -122.406284910247) | 10 | 3 | 7 | 309 | 28 | |||
3710 | 70389 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5989540.17856 | 2110611.69098 | 37.7747342353889 | -122.479670271059 | (37.7747342353889, -122.479670271059) | 11 | 6 | 2 | 55 | 26 | |||
5657 | 41933 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 610 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42292 | 5994729.71498 | 2111330.05881 | 37.7770067806052 | -122.461770835952 | (37.7770067806052, -122.461770835952) | 11 | 6 | 2 | 54 | 11 | |
14948 | 90869 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989208.80531 | 2110541.29026 | 37.7745216791694 | -122.480811390162 | (37.7745216791694, -122.480811390162) | 11 | 6 | 2 | 55 | 26 | ||
22012 | 90575 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2008 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989345.62252 | 2110602.70137 | 37.7746982485552 | -122.480342614213 | (37.7746982485552, -122.480342614213) | 11 | 6 | 2 | 55 | 26 | ||
23421 | 90874 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1941 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989523.27614 | 2110553.23403 | 37.7745727468597 | -122.479724461021 | (37.7745727468597, -122.479724461021) | 11 | 6 | 2 | 55 | 26 | ||
23653 | 90897 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1145 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992033.67177 | 2110642.90774 | 37.7749644818454 | -122.471047125233 | (37.7749644818454, -122.471047125233) | 11 | 6 | 2 | 54 | 11 | ||
26438 | 90871 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2033 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989249.74132 | 2110541.7912 | 37.7745254339062 | -122.480669822879 | (37.7745254339062, -122.480669822879) | 11 | 6 | 2 | 55 | 26 | ||
27091 | 90555 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992035.9437 | 2110699.81053 | 37.7751208528883 | -122.471043412514 | (37.7751208528883, -122.471043412514) | 11 | 6 | 2 | 54 | 11 | ||
27838 | 90576 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2020 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989294.17784 | 2110601.65647 | 37.7746923899334 | -122.48052049321 | (37.7746923899334, -122.48052049321) | 11 | 6 | 2 | 55 | 26 | ||
33458 | 90872 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2027 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989286.8509 | 2110543.19375 | 37.7745314416669 | -122.480541557806 | (37.7745314416669, -122.480541557806) | 11 | 6 | 2 | 55 | 26 | ||
34046 | 31982 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 232 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 12 | 3x3 | Permit Number 35382 | 5994946.26899 | 2113981.48738 | 37.7842993574965 | -122.461213955921 | (37.7842993574965, -122.461213955921) | 11 | 6 | 2 | 54 | 11 |
36193 | 90586 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988739.41652 | 2110581.09487 | 37.7746036774674 | -122.482437994797 | (37.7746036774674, -122.482437994797) | 11 | 6 | 2 | 55 | 26 | ||
38813 | 90554 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992007.5751 | 2110699.64473 | 37.7751187568292 | -122.471141532792 | (37.7751187568292, -122.471141532792) | 11 | 6 | 2 | 54 | 11 | ||
39857 | 8913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4455X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5993194.92162 | 2112721.50101 | 37.7807388335807 | -122.467181309852 | (37.7807388335807, -122.467181309852) | 11 | 6 | 2 | 54 | 11 | |||
42514 | 90572 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1932 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989583.92326 | 2110610.46088 | 37.7747333989447 | -122.479518860914 | (37.7747333989447, -122.479518860914) | 11 | 6 | 2 | 55 | 26 | ||
44084 | 41912 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992258.1025 | 2111064.36491 | 37.7761346671426 | -122.470301476833 | (37.7761346671426, -122.470301476833) | 11 | 6 | 2 | 54 | 11 | |
45602 | 65010 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 254 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1989 12:00:00 AM | 7 | Permit Number 26054 | 5989032.72565 | 2113622.95943 | 37.7829728458122 | -122.481646233199 | (37.7829728458122, -122.481646233199) | 11 | 6 | 2 | 55 | 26 | ||
48428 | 90571 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1900 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989655.61233 | 2110613.51621 | 37.7747459519392 | -122.479271100153 | (37.7747459519392, -122.479271100153) | 11 | 6 | 2 | 55 | 26 | ||
55070 | 90888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.38922 | 2110587.78256 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | 11 | 6 | 2 | 55 | 26 | ||
61838 | 90896 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1145 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992053.33041 | 2110644.47867 | 37.7749699321879 | -122.47097923688 | (37.7749699321879, -122.47097923688) | 11 | 6 | 2 | 54 | 11 | ||
62144 | 65529 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1990 12:00:00 AM | 3 | Permit Number 28417 | 5989796.43775 | 2110560.03757 | 37.7746072923506 | -122.47878004958 | (37.7746072923506, -122.47878004958) | 11 | 6 | 2 | 55 | 26 | ||
64123 | 123208 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993131.19371 | 2112699.04699 | 37.7806735020779 | -122.467400140372 | (37.7806735020779, -122.467400140372) | 11 | 6 | 2 | 54 | 11 | |||
67783 | 90864 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988718.74486 | 2110525.68485 | 37.7744503344144 | -122.482505440318 | (37.7744503344144, -122.482505440318) | 11 | 6 | 2 | 55 | 26 | ||
74281 | 34259 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 164 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 12 | Permit Number 39598 | 5993996.78061 | 2114472.4725 | 37.7855927810379 | -122.464534489449 | (37.7855927810379, -122.464534489449) | 11 | 6 | 1 | 54 | 11 | |
76553 | 123210 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | 11 | 6 | 2 | 54 | 11 | |||
77851 | 90569 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1818 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989920.28238 | 2110623.46415 | 37.7747886345028 | -122.478356290001 | (37.7747886345028, -122.478356290001) | 11 | 6 | 2 | 55 | 26 | ||
79595 | 90884 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1751 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990130.69935 | 2110573.90659 | 37.7746647760157 | -122.477624799049 | (37.7746647760157, -122.477624799049) | 11 | 6 | 2 | 55 | 26 | ||
87429 | 41913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992259.32657 | 2111046.49076 | 37.7760856603427 | -122.470295940533 | (37.7760856603427, -122.470295940533) | 11 | 6 | 2 | 54 | 11 | |
88525 | 90879 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1917 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989637.04672 | 2110556.02381 | 37.7745870153825 | -122.479331114808 | (37.7745870153825, -122.479331114808) | 11 | 6 | 2 | 55 | 26 | ||
89642 | 90894 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1527 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990818.86617 | 2110597.98209 | 37.7747707916372 | -122.475246074555 | (37.7747707916372, -122.475246074555) | 11 | 6 | 2 | 54 | 26 | ||
100139 | 67314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 666 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1992 12:00:00 AM | 7 | Permit Number 30795 | 5992883.6827 | 2110925.23066 | 37.77578879069 | -122.468127322089 | (37.77578879069, -122.468127322089) | 11 | 6 | 2 | 54 | 11 | |
101968 | 41934 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 615 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42293 | 5994683.51563 | 2111320.01316 | 37.7769765383201 | -122.461929924013 | (37.7769765383201, -122.461929924013) | 11 | 6 | 2 | 54 | 11 | |
103672 | 36967 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 9 | Permit Number 39594 | 5994314.22367 | 2112999.17695 | 37.7815658043957 | -122.463329288102 | (37.7815658043957, -122.463329288102) | 11 | 6 | 2 | 54 | 11 | |
104412 | 119966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5987215.94672 | 2112352.18936 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | 11 | 6 | 2 | 55 | 26 | |||
106851 | 90892 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1543 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990781.4854 | 2110598.61863 | 37.7747703727015 | -122.475375427468 | (37.7747703727015, -122.475375427468) | 11 | 6 | 2 | 54 | 26 | ||
106929 | 67973 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2133 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 3 | Permit Number 31694 | 5988948.22001 | 2110531.76438 | 37.7744803739464 | -122.481712096768 | (37.7744803739464, -122.481712096768) | 11 | 6 | 2 | 55 | 26 | |
109111 | 90583 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2116 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988996.38069 | 2110588.45382 | 37.7746388278925 | -122.481549654427 | (37.7746388278925, -122.481549654427) | 11 | 6 | 2 | 55 | 26 | ||
110974 | 120834 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989271.19606 | 2110543.25177 | 37.7745306911578 | -122.480595714565 | (37.7745306911578, -122.480595714565) | 11 | 6 | 2 | 55 | 26 | |||
112842 | 90578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2050X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989208.06357 | 2110596.77372 | 37.7746739782763 | -122.480818018857 | (37.7746739782763, -122.480818018857) | 11 | 6 | 2 | 55 | 26 | ||
113993 | 36966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 7 | Permit Number 39594 | 5994314.52093 | 2112981.13075 | 37.7815162715185 | -122.463326949801 | (37.7815162715185, -122.463326949801) | 11 | 6 | 2 | 54 | 11 | |
115389 | 90584 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2150X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988880.62132 | 2110585.72387 | 37.7746246005815 | -122.481949884411 | (37.7746246005815, -122.481949884411) | 11 | 6 | 2 | 55 | 26 | ||
115541 | 90885 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1733 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990174.4288 | 2110576.33984 | 37.7746739946122 | -122.477473709626 | (37.7746739946122, -122.477473709626) | 11 | 6 | 2 | 55 | 26 | ||
116142 | 80705 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3118 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50051 | 5996015.97757 | 2111454.39172 | 37.7774221266328 | -122.457330280254 | (37.7774221266328, -122.457330280254) | 11 | 6 | 2 | 54 | 16 | |
116652 | 123211 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993134.492 | 2112639.50466 | 37.7805102054167 | -122.467384399185 | (37.7805102054167, -122.467384399185) | 11 | 6 | 2 | 54 | 11 | |||
116896 | 124090 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 601 Funston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5991893.39709 | 2111137.10441 | 37.7763132974782 | -122.471568380763 | (37.7763132974782, -122.471568380763) | 11 | 6 | 2 | 54 | 11 | ||||
120276 | 90868 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2045 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989180.48685 | 2110539.97505 | 37.7745164219339 | -122.480909251758 | (37.7745164219339, -122.480909251758) | 11 | 6 | 2 | 55 | 26 | ||
121645 | 90588 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2242 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988605.86031 | 2110576.30478 | 37.7745827550651 | -122.48289963544 | (37.7745827550651, -122.48289963544) | 11 | 6 | 2 | 55 | 26 | ||
123918 | 34257 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 160 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 9 | Permit Number 39597 | 5993997.84726 | 2114498.92628 | 37.7856654774057 | -122.464532720679 | (37.7856654774057, -122.464532720679) | 11 | 6 | 1 | 54 | 11 | |
128004 | 90862 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2233 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988638.67322 | 2110518.90236 | 37.7744270531648 | -122.4827819229 | (37.7744270531648, -122.4827819229) | 11 | 6 | 2 | 55 | 26 | ||
130878 | 123179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 771 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992862.96444 | 2110216.56004 | 37.7738417753505 | -122.468147428182 | (37.7738417753505, -122.468147428182) | 11 | 6 | 2 | 54 | 11 | |||
132385 | 44257 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 122 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2001 12:00:00 AM | 9 | Permit Number 43690 | 5993988.26127 | 2114691.75826 | 37.7861943888941 | -122.464579892109 | (37.7861943888941, -122.464579892109) | 11 | 6 | 1 | 54 | 11 | ||
141497 | 90865 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988736.61915 | 2110526.67364 | 37.7744540891609 | -122.482443682946 | (37.7744540891609, -122.482443682946) | 11 | 6 | 2 | 55 | 26 | ||
142722 | 111741 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 498x 11th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5992530.71883 | 2112167.74428 | 37.7791800053719 | -122.469438767189 | (37.7791800053719, -122.469438767189) | 11 | 6 | 2 | 54 | 11 | |||
143264 | 31983 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 252 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | 3x3 | Permit Number 35383 | 5994950.72464 | 2113855.38064 | 37.7839533587811 | -122.461189396885 | (37.7839533587811, -122.461189396885) | 11 | 6 | 2 | 54 | 11 |
144340 | 43686 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 162 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43330 | 5993378.79836 | 2114426.59889 | 37.785431180637 | -122.46666917492 | (37.785431180637, -122.46666917492) | 11 | 6 | 2 | 54 | 11 | |
147178 | 90863 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988677.47069 | 2110522.18301 | 37.7744383181626 | -122.482647957161 | (37.7744383181626, -122.482647957161) | 11 | 6 | 2 | 55 | 26 | ||
147966 | 90873 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2015 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989357.49508 | 2110545.80132 | 37.7745427066681 | -122.480297379549 | (37.7745427066681, -122.480297379549) | 11 | 6 | 2 | 55 | 26 | ||
148837 | 90580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989065.94752 | 2110592.46721 | 37.7746538923373 | -122.481309305666 | (37.7746538923373, -122.481309305666) | 11 | 6 | 2 | 55 | 26 | ||
150853 | 34256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 156 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39596 | 5993995.61311 | 2114522.39441 | 37.78572978571 | -122.46454215478 | (37.78572978571, -122.46454215478) | 11 | 6 | 1 | 54 | 11 | |
155950 | 90585 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988755.94443 | 2110581.0496 | 37.7746045146176 | -122.482380818852 | (37.7746045146176, -122.482380818852) | 11 | 6 | 2 | 55 | 26 | ||
157100 | 122016 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1633 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5990486.56458 | 2110588.66917 | 37.7747259547528 | -122.476394881461 | (37.7747259547528, -122.476394881461) | 11 | 6 | 2 | 55 | 26 | |||
157957 | 88525 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 626x Funston Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51466 | 5991969.3 | 2111151 | 37.7763558419216 | -122.471306826694 | (37.7763558419216, -122.471306826694) | 11 | 6 | 2 | 54 | 11 | |||
161059 | 90582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989019.95807 | 2110588.86895 | 37.7746413386268 | -122.481468126933 | (37.7746413386268, -122.481468126933) | 11 | 6 | 2 | 55 | 26 | ||
163714 | 90587 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988720.72128 | 2110579.96701 | 37.7745994931186 | -122.482502581896 | (37.7745994931186, -122.482502581896) | 11 | 6 | 2 | 55 | 26 | ||
170751 | 90866 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2151X Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988924.29434 | 2110530.35666 | 37.7744751174123 | -122.481794756145 | (37.7744751174123, -122.481794756145) | 11 | 6 | 2 | 55 | 26 | ||
181100 | 90574 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1950 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989503.12005 | 2110610.6462 | 37.7747292138807 | -122.479798386077 | (37.7747292138807, -122.479798386077) | 11 | 6 | 2 | 55 | 26 | ||
182007 | 90886 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1715 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990248.62617 | 2110577.36646 | 37.7746811185578 | -122.477217123809 | (37.7746811185578, -122.477217123809) | 11 | 6 | 2 | 55 | 26 | ||
188061 | 90880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1901X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989653.27368 | 2110557.04805 | 37.7745907701264 | -122.479275058131 | (37.7745907701264, -122.479275058131) | 11 | 6 | 2 | 55 | 26 | ||
188806 | 90577 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2050X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989223.999 | 2110597.65544 | 37.7746773254621 | -122.480762960202 | (37.7746773254621, -122.480762960202) | 11 | 6 | 2 | 55 | 26 | ||
190395 | 91010 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2134 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 5988937.91177 | 2110588.16813 | 37.7746346435588 | -122.481751886766 | (37.7746346435588, -122.481751886766) | 11 | 6 | 2 | 55 | 26 | ||
191286 | 90883 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1827 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989887.73623 | 2110565.21832 | 37.7746268180643 | -122.478464612476 | (37.7746268180643, -122.478464612476) | 11 | 6 | 2 | 55 | 26 | ||
191980 | 123105 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 498 11th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992529.16869 | 2112181.64232 | 37.7792180760249 | -122.469445141648 | (37.7792180760249, -122.469445141648) | 11 | 6 | 2 | 54 | 11 | |||
2485 | 59880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2139 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 10 | Permit Number 19345 | 6002701.87127 | 2118840.74506 | 37.7980849079605 | -122.434729923369 | (37.7980849079605, -122.434729923369) | 13 | 9 | 1 | 57 | 17 | |
6340 | 33134 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3107 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 10 | Permit Number 37364 | 6001390.00916 | 2119109.09622 | 37.7987471650933 | -122.439288583214 | (37.7987471650933, -122.439288583214) | 13 | 9 | 1 | 57 | 17 | |
20202 | 136176 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2134 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002833.9768 | 2118210.69092 | 37.7963624418193 | -122.434227733841 | (37.7963624418193, -122.434227733841) | 13 | 9 | 1 | 57 | 17 | |||
32482 | 65937 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2826 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1990 12:00:00 AM | 7 | Permit Number 28956 | 5999433.3119 | 2118083.73409 | 37.7958202522453 | -122.445985572784 | (37.7958202522453, -122.445985572784) | 13 | 9 | 1 | 57 | 17 | ||
55713 | 136180 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.446187711617 | (37.8000790286731, -122.446187711617) | 13 | 9 | 1 | 57 | 17 | |||
56230 | 136182 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999403.04173 | 2119664.02877 | 37.8001575907471 | -122.446204044176 | (37.8001575907471, -122.446204044176) | 13 | 9 | 1 | 57 | 17 | |||
66671 | 38887 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998129.65961 | 2115308.75845 | 37.7881263812657 | -122.450296300351 | (37.7881263812657, -122.450296300351) | 13 | 6 | 1 | 54 | 31 | |
94223 | 136177 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003216.31619 | 2118958.46656 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | 13 | 9 | 1 | 57 | 17 |
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) );