trees
575 rows where qSpecies_id = 123 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
93244 | 86800 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 71 Miguel St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2007 12:00:00 AM | 3x3 | Permit Number 49752 | 6003860 | 2097292 | 37.7389829690297 | -122.429185143196 | (37.7389829690297, -122.429185143196) | 2 | 7 | 5 | 63 | 7 | |||
109489 | 25585 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1997 12:00:00 AM | 30 | 3X3 | 6008661.2482385 | 2097297.4630516 | 37.7392685988549 | -122.412584962687 | (37.7392685988549, -122.412584962687) | 10 | 7 | 7 | 28859 | 2 | ||
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 | ||
42098 | 241379 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3702 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008438.87775 | 2097614.97452 | 37.7401279331501 | -122.413376271417 | (37.7401279331501, -122.413376271417) | 2 | 7 | 7 | 28859 | 2 | |||
140091 | 88138 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 181 Marietta Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51166 | 5998804 | 2097893 | 37.7403456543781 | -122.446709627058 | (37.7403456543781, -122.446709627058) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
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 | |||
109816 | 241388 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1769 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6003420.97531 | 2097978.60034 | 37.7408433528415 | -122.430752071748 | (37.7408433528415, -122.430752071748) | 2 | 7 | 5 | 63 | 7 | |||
2223 | 241387 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 43 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 3ft | 6004298.90777 | 2098020.68858 | 37.7410086185538 | -122.42771950655 | (37.7410086185538, -122.42771950655) | 2 | 7 | 5 | 63 | 7 | |||
57267 | 241390 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004068.12547 | 2098354.29911 | 37.7419115792635 | -122.428541241382 | (37.7419115792635, -122.428541241382) | 2 | 7 | 5 | 63 | 7 | |||
72441 | 82759 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 49 Samoset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.408332701789 | (37.744466098795, -122.408332701789) | 2 | 7 | 7 | 28859 | 2 | ||
131374 | 82729 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 49 Samoset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.408332701789 | (37.744466098795, -122.408332701789) | 2 | 7 | 7 | 28859 | 2 | ||
169285 | 32320 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3337 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/1996 12:00:00 AM | 4 | Permit Number 36887 | 6009057.01923 | 2099240.26466 | 37.7446253105111 | -122.411353770753 | (37.7446253105111, -122.411353770753) | 2 | 7 | 7 | 28859 | 2 | ||
105739 | 43561 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 598 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50500 | 6002046.37252319 | 2099459.05244765 | 37.7448303525831 | -122.435610815213 | (37.7448303525831, -122.435610815213) | 2 | 7 | 5 | 63 | 22 | ||
134611 | 241336 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 11 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007215.53058 | 2099620.48751 | 37.7455658619754 | -122.417748235597 | (37.7455658619754, -122.417748235597) | 2 | 7 | 7 | 28859 | 2 | |||
115294 | 246445 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 457 Duncan St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6003558.45361 | 2099788.20108 | 37.7458198862793 | -122.430405804901 | (37.7458198862793, -122.430405804901) | 2 | 7 | 5 | 63 | 22 | |||
67177 | 241335 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Coso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007049.61155 | 2099992.5386 | 37.7465780921238 | -122.418348334311 | (37.7465780921238, -122.418348334311) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
104248 | 241377 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 281 27th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004660.79755 | 2100144.09881 | 37.7468594809746 | -122.426619392873 | (37.7468594809746, -122.426619392873) | 2 | 7 | 5 | 63 | 22 | |||
92135 | 241378 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 273 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004715.15963 | 2100148.28162 | 37.746874039199 | -122.426431711567 | (37.746874039199, -122.426431711567) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
92727 | 241365 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1475 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010134.56863 | 2100721.5441 | 37.7487529567978 | -122.407732226982 | (37.7487529567978, -122.407732226982) | 2 | 4 | 7 | 28859 | 19 | |||
100115 | 91632 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1540 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007748.949212 | 2100776.810346 | 37.748770868614 | -122.415985622241 | (37.748770868614, -122.415985622241) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
75362 | 91635 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1515 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007819 | 2100813 | 37.7488741754589 | -122.415745948384 | (37.7488741754589, -122.415745948384) | 2 | 4 | 7 | 28859 | 19 | ||
111602 | 91634 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1515 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007819 | 2100813 | 37.7488741754589 | -122.415745948384 | (37.7488741754589, -122.415745948384) | 2 | 4 | 7 | 28859 | 19 | ||
122308 | 91633 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1515 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007819 | 2100813 | 37.7488741754589 | -122.415745948384 | (37.7488741754589, -122.415745948384) | 2 | 4 | 7 | 28859 | 19 | ||
60318 | 91631 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1500 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007741.508083 | 2100911.11035 | 37.7491392078361 | -122.416020863166 | (37.7491392078361, -122.416020863166) | 2 | 4 | 7 | 28859 | 19 | |||
102687 | 241279 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1400 Potrero Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010767.41286 | 2100951.64139 | 37.7494201602129 | -122.405560047672 | (37.7494201602129, -122.405560047672) | 10 | 4 | 7 | 28859 | 19 | |||
59988 | 91630 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1490x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007737.478632 | 2100983.83524 | 37.7493386674544 | -122.41603994665 | (37.7493386674544, -122.41603994665) | 2 | 4 | 7 | 28859 | 19 | |||
133550 | 241356 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3041 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6009354.55363 | 2100986.01535 | 37.749435439707 | -122.410448197535 | (37.749435439707, -122.410448197535) | 2 | 4 | 7 | 28859 | 19 | |||
51857 | 241278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1400 Potrero Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010738.66995 | 2101021.37362 | 37.7496100223844 | -122.405664352824 | (37.7496100223844, -122.405664352824) | 10 | 4 | 7 | 28859 | 19 | |||
78586 | 241277 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1400 Potrero Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010729.0783 | 2101044.09639 | 37.749671877762 | -122.405699121544 | (37.749671877762, -122.405699121544) | 10 | 4 | 7 | 28859 | 19 | |||
16406 | 241355 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009659.81185 | 2101050.9246 | 37.7496307742409 | -122.409397182327 | (37.7496307742409, -122.409397182327) | 2 | 4 | 7 | 28859 | 19 | |||
68475 | 91629 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1474 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | 2 | 4 | 7 | 28859 | 19 | ||
111472 | 91628 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1474 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | 2 | 4 | 7 | 28859 | 19 | ||
14811 | 241276 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1400 Potrero Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010713.5875 | 2101085.71194 | 37.7497852786664 | -122.405755620526 | (37.7497852786664, -122.405755620526) | 10 | 4 | 7 | 28859 | 19 | |||
30264 | 241366 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1399 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010111.5288 | 2101104.25474 | 37.7498025060946 | -122.40783888207 | (37.7498025060946, -122.40783888207) | 2 | 4 | 7 | 28859 | 19 | |||
94776 | 91627 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1468 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007730.662506 | 2101106.855019 | 37.7496760688109 | -122.416072228065 | (37.7496760688109, -122.416072228065) | 2 | 4 | 7 | 28859 | 19 | |||
174631 | 91637 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1459 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007767.503009 | 2101164.985993 | 37.749837754658 | -122.415948947877 | (37.749837754658, -122.415948947877) | 2 | 4 | 7 | 28859 | 19 | |||
42600 | 91638 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1453 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007765.644065 | 2101198.536844 | 37.7499297732176 | -122.415957751819 | (37.7499297732176, -122.415957751819) | 2 | 4 | 7 | 28859 | 19 | |||
135561 | 91626 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1450 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007725.085674 | 2101207.507592 | 37.749952124518 | -122.416098640357 | (37.749952124518, -122.416098640357) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
38921 | 91625 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1434 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007720.12849 | 2101296.976541 | 37.7501975073399 | -122.416122118115 | (37.7501975073399, -122.416122118115) | 2 | 4 | 7 | 28859 | 19 | |||
96199 | 91639 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1435 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007760.067233 | 2101299.189418 | 37.7502058289413 | -122.415984163776 | (37.7502058289413, -122.415984163776) | 2 | 4 | 7 | 28859 | 19 | |||
6410 | 91640 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1427 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007757.588641 | 2101343.923892 | 37.7503285203588 | -122.415995902486 | (37.7503285203588, -122.415995902486) | 2 | 4 | 7 | 28859 | 19 | |||
39867 | 91624 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1424 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007717.03025 | 2101352.89464 | 37.7503508716121 | -122.416136791792 | (37.7503508716121, -122.416136791792) | 2 | 4 | 7 | 28859 | 19 | |||
159489 | 241280 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1334 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010312.03054 | 2101467.09279 | 37.7508100021879 | -122.40717110848 | (37.7508100021879, -122.40717110848) | 2 | 4 | 7 | 28859 | 19 | |||
15680 | 91641 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1401X South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007749.533216 | 2101489.31094 | 37.7507272674606 | -122.416034053567 | (37.7507272674606, -122.416034053567) | 2 | 4 | 7 | 28859 | 19 | |||
74691 | 52826 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3063 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52281 | 6009164.51309648 | 2101559.46503951 | 37.7509993493006 | -122.411145866905 | (37.7509993493006, -122.411145866905) | 2 | 4 | 7 | 28859 | 19 | ||
149994 | 91642 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007742.379122 | 2101613.996265 | 37.7510692229497 | -122.41606762223 | (37.7510692229497, -122.41606762223) | 2 | 4 | 7 | 28859 | 19 | |||
177434 | 91643 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1367 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007737.207562 | 2101703.625981 | 37.7513150351075 | -122.416091852961 | (37.7513150351075, -122.416091852961) | 2 | 4 | 7 | 28859 | 19 | |||
188771 | 91621 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1358 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007694.688201 | 2101746.136705 | 37.7514293691601 | -122.416241900686 | (37.7514293691601, -122.416241900686) | 2 | 4 | 7 | 28859 | 19 | |||
176270 | 91644 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1343 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007729.450223 | 2101838.070556 | 37.7516837533185 | -122.416128199355 | (37.7516837533185, -122.416128199355) | 2 | 4 | 7 | 28859 | 19 | |||
109877 | 241372 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004512.71197 | 2101888.89737 | 37.7516419200596 | -122.427255725271 | (37.7516419200596, -122.427255725271) | 2 | 4 | 5 | 28862 | 22 | |||
104883 | 241373 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004532.87463 | 2101890.40961 | 37.7516472125622 | -122.427186107874 | (37.7516472125622, -122.427186107874) | 2 | 4 | 5 | 28862 | 22 | |||
84968 | 241376 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3777 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004606.4364 | 2101890.62925 | 37.7516519753774 | -122.426931737306 | (37.7516519753774, -122.426931737306) | 2 | 4 | 5 | 28862 | 22 | |||
123335 | 241374 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004551.11836 | 2101892.73239 | 37.7516546220636 | -122.427123184105 | (37.7516546220636, -122.427123184105) | 2 | 4 | 5 | 28862 | 22 | |||
141067 | 241375 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004575.52977 | 2101893.77166 | 37.7516588560771 | -122.427038840268 | (37.7516588560771, -122.427038840268) | 2 | 4 | 5 | 28862 | 22 | |||
42648 | 241281 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1201 Vermont St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6011465.9993 | 2101906.42682 | 37.7520808305785 | -122.403211459137 | (37.7520808305785, -122.403211459137) | 10 | 4 | 8 | 28859 | 19 | |||
103971 | 241282 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1201 Vermont St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011466.58759 | 2101921.66983 | 37.7521227174025 | -122.403210496885 | (37.7521227174025, -122.403210496885) | 10 | 4 | 8 | 28859 | 19 | |||
22119 | 241283 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1201 Vermont St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6011469.09548 | 2101944.76887 | 37.7521862823701 | -122.403203448894 | (37.7521862823701, -122.403203448894) | 10 | 4 | 8 | 28859 | 19 | |||
18173 | 241284 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1201 Vermont St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011470.02474 | 2101959.91095 | 37.7522279111039 | -122.403201300403 | (37.7522279111039, -122.403201300403) | 10 | 4 | 8 | 28859 | 19 | |||
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 | |||
75224 | 52663 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 772 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50440 | 6001423.61779826 | 2102059.9147838 | 37.7519363103852 | -122.437950438082 | (37.7519363103852, -122.437950438082) | 2 | 4 | 5 | 28862 | 22 | |
54319 | 241288 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1201 Vermont St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6011465.27105 | 2102063.55943 | 37.7525122416483 | -122.403225029932 | (37.7525122416483, -122.403225029932) | 10 | 4 | 8 | 28859 | 19 | |||
8545 | 241289 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
10563 | 220139 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
13557 | 220140 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 7ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
16388 | 241286 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
19316 | 241287 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
53423 | 91645 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1300X South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007675.941296 | 2102071.044433 | 37.7523204379956 | -122.416329740365 | (37.7523204379956, -122.416329740365) | 2 | 4 | 7 | 28859 | 19 | |||
142984 | 31525 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1330 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | 12 | 4x4 | Permit Number 35080 | 6011118.50482 | 2102111.69571 | 37.7526250409161 | -122.404427600678 | (37.7526250409161, -122.404427600678) | 10 | 4 | 8 | 28859 | 19 |
158272 | 91620 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1290 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007671.629207 | 2102150.724826 | 37.7525389797951 | -122.41635029552 | (37.7525389797951, -122.41635029552) | 2 | 4 | 7 | 28859 | 19 | |||
56651 | 91619 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1286 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007670.444381 | 2102173.036115 | 37.7526001749043 | -122.416355973027 | (37.7526001749043, -122.416355973027) | 2 | 4 | 7 | 28859 | 19 | |||
94675 | 35355 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1315 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 12 | Permit Number 38817 | 6011731.8197 | 2102219.99473 | 37.7529566614441 | -122.402314252327 | (37.7529566614441, -122.402314252327) | 10 | 3 | 8 | 28856 | 29 | |
88879 | 241357 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1081 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6008659.53051 | 2102232.08888 | 37.7528178906343 | -122.412939704518 | (37.7528178906343, -122.412939704518) | 2 | 4 | 7 | 28859 | 19 |
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) );