Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
851 | 851 | 234149 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3652 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005288.48907 | 2102558.72214 | 37.753524945734 | -122.42462062893601 | (37.753524945734, -122.424620628936) | |||
2680 | 2680 | 223656 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 18811 | 6003648.753819999 | 2095269.66073 | 37.7334181246305 | -122.42977132959601 | (37.7334181246305, -122.429771329596) | ||
13451 | 13451 | 85537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007421.290519999 | 2109238.78217 | 37.77198705877429 | -122.417718370032 | (37.7719870587743, -122.417718370032) | |||
13618 | 13618 | 25915 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1800 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2015 12:17:00 PM | 3 | 3X3 | 6013847.663980001 | 2096411.7192 | 37.737126242566 | -122.394590512161 | (37.737126242566, -122.394590512161) | ||
13664 | 13664 | 6735 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 2 | 3x3 | 6017028.4506 | 2097182.15302 | 37.7394180218109 | -122.383646604615 | (37.7394180218109, -122.383646604615) | ||
24712 | 24712 | 189244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013923.095430001 | 2103892.83973 | 37.757672010179206 | -122.394853496397 | (37.7576720101792, -122.394853496397) | |||
28812 | 28812 | 94752 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010356.01767 | 2097548.96974 | 37.7400541518831 | -122.406742898988 | (37.7400541518831, -122.406742898988) | ||
29213 | 29213 | 224107 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006435.98558 | 2109358.16079 | 37.7722593483308 | -122.421135098612 | (37.7722593483308, -122.421135098612) | |||
29785 | 29785 | 223507 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006548.17508 | 2102589.95451 | 37.7536817641104 | -122.42026657024401 | (37.7536817641104, -122.420266570244) | |||
30930 | 30930 | 223427 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 357 Precita Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008897.95249 | 2100223.67255 | 37.747316608191 | -122.411973275956 | (37.747316608191, -122.411973275956) | |||
32413 | 32413 | 27682 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011440.528880901 | 2097124.3937126 | 37.738948976932996 | -122.402963228074 | (37.738948976933, -122.402963228074) | ||
36646 | 36646 | 191087 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | ||||
43044 | 43044 | 101126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990758.62584 | 2113423.68557 | 37.7825259029155 | -122.47566083662 | (37.7825259029155, -122.47566083662) | |||
43423 | 43423 | 223650 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1810 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008607.48155 | 2107905.0791700003 | 37.7683917014338 | -122.413520888701 | (37.7683917014338, -122.413520888701) | |||
45245 | 45245 | 223494 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007979.72729 | 2102967.16381 | 37.754798056597 | -122.415342629177 | (37.754798056597, -122.415342629177) | |||
47424 | 47424 | 207641 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992163.3894 | 2104844.15149 | 37.759050145675104 | -122.470176059699 | (37.7590501456751, -122.470176059699) | |||
47806 | 47806 | 70989 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1995 12:00:00 AM | 6 | 6008399.527430001 | 2108738.25581 | 37.770667730873 | -122.41429914310301 | (37.770667730873, -122.414299143103) | ||
52331 | 52331 | 126558 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012003.3055 | 2119230.3844 | 37.7996784337747 | -122.402571476413 | (37.7996784337747, -122.402571476413) | |||
60546 | 60546 | 200100 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1528 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015024.8562 | 2092385.3244 | 37.7261359509126 | -122.390239170909 | (37.7261359509126, -122.390239170909) | |||
70477 | 70477 | 114651 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001524.5433 | 2113938.4711 | 37.7845576244995 | -122.43845239809299 | (37.7845576244995, -122.438452398093) | |||
73409 | 73409 | 124532 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 951 Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992651.91776 | 2111347.60988 | 37.7769351421706 | -122.468959793565 | (37.7769351421706, -122.468959793565) | |||
78701 | 78701 | 40254 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/13/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41415 | 6006702.84210434 | 2102592.14346256 | 37.7536964884672 | -122.419731851285 | (37.7536964884672, -122.419731851285) |
78728 | 78728 | 87868 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059.0 | 2119911.0 | 37.800930138770106 | -122.440491523393 | (37.8009301387701, -122.440491523393) | ||
86401 | 86401 | 35080 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
89727 | 89727 | 108554 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 61-79X Santa Ysabel Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773713 | 6000867.23405 | 2093153.75099 | 37.727450422234796 | -122.439236196788 | (37.7274504222348, -122.439236196788) |
90403 | 90403 | 95670 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 Colby St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110.0 | 2090446.0 | 37.720481117261706 | -122.41054968459 | (37.7204811172617, -122.41054968459) | |
93453 | 93453 | 46988 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
94305 | 94305 | 50867 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2626 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | Permit Number 47381 | 6001007.94143804 | 2117610.91289932 | 37.794611798503205 | -122.44050314696199 | (37.7946117985032, -122.440503146962) | |||
95513 | 95513 | 117140 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
100537 | 100537 | 116814 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3660x 23RD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779082 | 6005401.0 | 2102665.0 | 37.7538231135776 | -122.42423909941999 | (37.7538231135776, -122.42423909942) | |
101548 | 101548 | 85550 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 250X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007915.610258999 | 2108965.748791 | 37.771265178087894 | -122.41598913709299 | (37.7712651780879, -122.415989137093) | |||
102324 | 102324 | 98971 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
104747 | 104747 | 90336 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1751 Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2013 12:00:00 AM | 1 | 3x3 | 5990179.8300830005 | 2111264.66899 | 37.7765642703859 | -122.47750534597799 | (37.7765642703859, -122.477505345978) | ||
111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
113173 | 113173 | 99031 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
114416 | 114416 | 21341 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
117376 | 117376 | 85524 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6008760.539183999 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | |||
119479 | 119479 | 113827 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1599x CASTRO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 02/16/2016 05:50:00 AM | 3 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |
121410 | 121410 | 99382 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
122459 | 122459 | 26112 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015459.73624 | 2095054.56513 | 37.7334892639404 | -122.388922075695 | (37.7334892639404, -122.388922075695) | ||
122643 | 122643 | 49858 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 338 Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.733432289658396 | -122.429770085042 | (37.7334322896584, -122.429770085042) | ||
122766 | 122766 | 116584 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 GOUGH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006450.0 | 2109317.0 | 37.7721471206774 | -122.421083698286 | (37.7721471206774, -122.421083698286) | |||
124331 | 124331 | 96929 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.73344510199421 | -122.42945574048201 | (37.7334451019942, -122.429455740482) | ||
125830 | 125830 | 22922 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6006142.65939 | 2107729.77965 | 37.7677716622264 | -122.42203404127301 | (37.7677716622264, -122.422034041273) | |||
127021 | 127021 | 26468 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | ||
136208 | 136208 | 191101 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2041 26th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012369.93883 | 2101402.46492 | 37.7507475020033 | -122.400050093052 | (37.7507475020033, -122.400050093052) | |||
136665 | 136665 | 52805 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | 3 | Permit Number 48835 | 6013721.70041 | 2104112.27723 | 37.758263337788 | -122.395565381751 | (37.758263337788, -122.395565381751) | ||
140126 | 140126 | 97899 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 375X Precita Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
144170 | 144170 | 49493 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2X ORDWAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46411 | 6011821.0 | 2090323.0 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | |
147173 | 147173 | 207554 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1353 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993924.42937 | 2106289.97984 | 37.76312166705421 | -122.46419056066999 | (37.7631216670542, -122.46419056067) | |||
151480 | 151480 | 124028 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Funston Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991796.1991 | 2114253.0901 | 37.7848633156564 | -122.47213179245199 | (37.7848633156564, -122.472131792452) | |||
153146 | 153146 | 126547 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2007 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008156.84893 | 2119375.98217 | 37.799862715653894 | -122.41589197732999 | (37.7998627156539, -122.41589197733) | |||
157006 | 157006 | 138228 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998518.0663 | 2112627.9868 | 37.7807879051601 | -122.448759321794 | (37.7807879051601, -122.448759321794) | |||
158644 | 158644 | 224101 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2x Gough St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006607.58912 | 2109275.93798 | 37.7720432565284 | -122.42053566810101 | (37.7720432565284, -122.420535668101) | |||
160036 | 160036 | 246576 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216001 | (37.7721221684335, -122.42531053216) | |||
164729 | 164729 | 191096 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2221 26th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011887.54449 | 2101344.68629 | 37.7505619466985 | -122.401714203957 | (37.7505619466985, -122.401714203957) | |||
166519 | 166519 | 189246 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2445 Mariposa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010268.3628 | 2105949.94091 | 37.763116456370796 | -122.407638156081 | (37.7631164563708, -122.407638156081) | |||
172833 | 172833 | 191675 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 252 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008016.56974 | 2108896.04904 | 37.7710794746583 | -122.415634977181 | (37.7710794746583, -122.415634977181) | |||
173387 | 173387 | 223632 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006711.10931 | 2102281.04717 | 37.7528427550882 | -122.419681189849 | (37.7528427550882, -122.419681189849) | |||
186789 | 186789 | 176247 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011833.809309999 | 2090345.7505400002 | 37.720358182462704 | -122.401127251532 | (37.7203581824627, -122.401127251532) | |||
187234 | 187234 | 176259 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 Edinburgh St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004478.9263 | 2093384.6524599998 | 37.728289288300296 | -122.42676699502701 | (37.7282892883003, -122.426766995027) | |||
188504 | 188504 | 224036 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1511 Castro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002606.663369999 | 2101060.9954 | 37.7492607194187 | -122.433787912303 | (37.7492607194187, -122.433787912303) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");