66 rows where Neighborhoods (old) = 1 and qSpecies_id = 123

View and edit SQL

Neighborhoods (old)

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)
4592 196983 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
5120 197001 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 16 : Tree Private 2     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743) 10 3 8 58 1
11064 196994 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 7 : Tree Private 2     7 Width 4ft   6013884.28274 2100137.93009 37.7473596740254 -122.394724774624 (37.7473596740254, -122.394724774624) 10 3 8 58 1
20599 196997 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 11 : Tree Private 2     7 Width 4ft   6013762.67186 2100131.60985 37.7473355578075 -122.395144856947 (37.7473355578075, -122.395144856947) 10 3 8 58 1
22157 197002 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2251 Silver Ave 3 : Tree Private 2     6 Width 3ft   6012830.37736 2096288.90355 37.7367324078692 -122.398099143384 (37.7367324078692, -122.398099143384) 10 3 8 58 1
23399 101632 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 6 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
35315 88470 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1519 Innes Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51424 6015916 2096861 37.7384746486807 -122.387470605672 (37.7384746486807, -122.387470605672) 10 3 8 58 1
38784 22263 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1997 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
46025 101631 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 5 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
55570 100314 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1683 Galvez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6015409.74359 2097962.08476 37.7414699491892 -122.389297877816 (37.7414699491892, -122.389297877816) 10 3 8 58 1
61090 104044 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601X Kansas St 8 Sidewalk: Property side : Cutout Tree DPW 1     70 9x9   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
62748 196988 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 8 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
64144 95296 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4517 03rd St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6015219.41618 2096207.76459 37.7366423919508 -122.389833460403 (37.7366423919508, -122.389833460403) 10 3 8 58 1
64306 22261 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
67071 3776 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 6 Carpenter Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6016649.2597904 2095536.4485417 37.7348782815847 -122.38484307413 (37.7348782815847, -122.38484307413) 10 3 8 58 1
70671 196993 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 6 : Tree Private 2     7 Width 4ft   6013912.09606 2100139.02388 37.7473642236913 -122.394628673985 (37.7473642236913, -122.394628673985) 10 3 8 58 1
71003 22267 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 7 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
74147 88499 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1599@ Lane Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51438 6015105.8 2094319.6 37.7314515735977 -122.39009441777 (37.7314515735977, -122.39009441777) 10 3 8 58 1
76848 22262 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
77304 101627 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 1 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
80922 104045 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601X Kansas St 7 Sidewalk: Property side : Cutout Tree DPW 1     4 3x6   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
85376 85063 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4532 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2007 12:00:00 AM 3 3x3   6015094.5224 2096297.78902 37.7368826538298 -122.390271563398 (37.7368826538298, -122.390271563398) 10 3 8 58 1
86262 101634 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 8 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
86818 22265 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1998 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
88076 196990 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 1 : Tree Private 2     6 Width 4ft   6014143.12746 2100151.41021 37.7474110756645 -122.393830644379 (37.7474110756645, -122.393830644379) 10 3 8 58 1
90252 22222 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4301 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2012 12:00:00 AM 3 3x3 Permit Number 768640 6015412.92695 2096851.83844 37.7384216168093 -122.389209364399 (37.7384216168093, -122.389209364399) 10 3 8 58 1
91890 22277 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 1 Sidewalk: Curb side : Cutout Tree Arts Commission 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
92182 196991 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 2 : Tree Private 2     5 Width 4ft   6014086.84637 2100149.18925 37.7474018495283 -122.394025106589 (37.7474018495283, -122.394025106589) 10 3 8 58 1
93143 22280 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 4 Sidewalk: Curb side : Cutout Tree Arts Commission 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
93279 101630 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2015 12:00:00 AM 3 3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.389057624952 (37.7385310737434, -122.389057624952) 10 3 8 58 1
94686 95297 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4517 03rd St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6015219.41618 2096207.76459 37.7366423919508 -122.389833460403 (37.7366423919508, -122.389833460403) 10 3 8 58 1
97589 196999 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 14 : Tree Private 2     4 Width 4ft   6013629.21679 2100123.8728 37.7473068910098 -122.395605796394 (37.7473068910098, -122.395605796394) 10 3 8 58 1
102501 22264 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 4 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
104346 101628 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 2 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
105176 88473 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1554 Jerrold Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51426 6015626.2 2096846 37.7384174065816 -122.388471555996 (37.7384174065816, -122.388471555996) 10 3 8 58 1
111608 22240 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4445 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2010 12:00:00 AM 3 3X3   6015309.22014 2096468.43632 37.7373631231169 -122.389541166269 (37.7373631231169, -122.389541166269) 10 3 8 58 1
111720 196987 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
115832 104046 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601X Kansas St 6 Sidewalk: Property side : Cutout Tree DPW 1     4 3x6   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
121622 197000 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 15 : Tree Private 2     6 Width 4ft   6013614.06576 2100123.51682 37.7473050707808 -122.395658162994 (37.7473050707808, -122.395658162994) 10 3 8 58 1
123373 88498 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1599 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51438 6015105.8 2094319.6 37.7314515735977 -122.39009441777 (37.7314515735977, -122.39009441777) 10 3 8 58 1
124135 196995 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 8 : Tree Private 2     8 Width 4ft   6013853.97089 2100136.72086 37.7473546683845 -122.394829506973 (37.7473546683845, -122.394829506973) 10 3 8 58 1
124252 88468 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1950 Donner Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51422 6011569.2 2093583.7 37.7292341601061 -122.402269464083 (37.7292341601061, -122.402269464083) 10 3 8 58 1
125523 104460 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601X Kansas St 2 Sidewalk: Property side : Cutout Tree DPW 1     4 3x6   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
132977 101633 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 7 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
136365 22239 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4445 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1995 12:00:00 AM 3 3X3   6015309.22014 2096468.43632 37.7373631231169 -122.389541166269 (37.7373631231169, -122.389541166269) 10 3 8 58 1
141990 196989 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 8 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
146245 196984 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
148392 95290 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4416 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6015163.3661 2096572.43152 37.7376405844607 -122.390052718455 (37.7376405844607, -122.390052718455) 10 3 8 58 1
148421 196998 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 13 : Tree Private 2     5 Width 4ft   6013702.50003 2100126.86267 37.7473191766464 -122.395352595851 (37.7473191766464, -122.395352595851) 10 3 8 58 1
148723 22242 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4430 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1995 12:00:00 AM 6 3x3   6015163.3661 2096572.43152 37.7376405844607 -122.390052718455 (37.7376405844607, -122.390052718455) 10 3 8 58 1
148991 22243 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4434 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
149067 95289 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4400 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015280 2096693 37.737978108932 -122.389657874388 (37.737978108932, -122.389657874388) 10 3 8 58 1
151905 22278 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 2 Sidewalk: Curb side : Cutout Tree Arts Commission 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);