6,344 rows where qSpecies_id = 19 sorted by qLegalStatus_id

View and edit SQL

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)
4626 5513 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 821 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2002 12:00:00 AM 18 5X5   6005073.13796 2103547.17923 37.7562268536034 -122.425435698922 (37.7562268536034, -122.425435698922) 2 4 5 28859 19
4650 229335 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2125 Bryant St 10 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009610.4756 2104742.50445 37.7597642613296 -122.409828339817 (37.7597642613296, -122.409828339817) 2 4 8 28859 19
4673 60356 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1261 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1982 12:00:00 AM 4   Permit Number 19934 6016682.1383 2093866.4324 37.7302945678233 -122.384613110545 (37.7302945678233, -122.384613110545) 10 3 8 58 1
4708 65963 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2658 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM 9   Permit Number 28985 5989288.4886 2097252.0638 37.7380376514495 -122.479563236125 (37.7380376514495, -122.479563236125) 1 8 3 29491 35
4718 181925 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2351 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5986069.5587 2099239.0051 37.7433057547251 -122.490838681113 (37.7433057547251, -122.490838681113) 1 8 3 29491 35
4855 76107 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 60 Rausch St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6009843.66078 2110720.8424 37.7761924676323 -122.409443785198 (37.7761924676323, -122.409443785198) 8 2 9 28853 34
4860 168126 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2329 Baker St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999733.55538 2116947.29263 37.7927170246219 -122.444864946464 (37.7927170246219, -122.444864946464) 13 6 1 29490 27
4882 193004 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 901 Rankin St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   6013457.05978 2097724.05261 37.7407079131502 -122.396032957252 (37.7407079131502, -122.396032957252) 10 3 8 58 1
4900 263589 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 800 Harrison St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012532 2112188 37.7803712075622 -122.400247099708 (37.7803712075622, -122.400247099708) 6 2 9 28856 34
5002 138596 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1997 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6001444.315 2115232.308 37.788105604547 -122.438822708512 (37.788105604547, -122.438822708512) 13 6 1 29490 27
5051 192939 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1559 Howard St 3 : Tree Private 2     5 Width 3ft   6007881.70364 2109409.76028 37.7724824224706 -122.416137872687 (37.7724824224706, -122.416137872687) 8 2 9 28853 19
5192 4661 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 600X Columbus Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2020 12:46:00 PM 3 5X5   6009739.5649 2119605.2627 37.8005811155969 -122.410431363819 (37.8005811155969, -122.410431363819) 3 1 10 308 23
5270 80931 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1111 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6001747.57084 2087049.21095 37.710738776642 -122.435756299834 (37.710738776642, -122.435756299834) 9 7 6 28861 5
5299 262438 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 540 San Juan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2019 12:00:00 AM 3 Width 3ft   6000352.85514 2092916.82872 37.7267706040626 -122.440997412 (37.7267706040626, -122.440997412) 9 7 6 28861 25
5301 230460 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 295 Precita Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008273.9062 2100232.70469 37.7473063765964 -122.414131828735 (37.7473063765964, -122.414131828735) 2 7 7 28859 2
5325 230238 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 30 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6003399.42304 2108502.79044 37.7697390612459 -122.431577753704 (37.7697390612459, -122.431577753704) 15 9 5 29492 10
5418 70426 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1590 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 3x3   6006596.62742 2117360.41575 37.7942406389433 -122.42114773947 (37.7942406389433, -122.42114773947) 13 9 10 28858 32
5437 44085 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 363 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2002 12:00:00 AM 7   Permit Number 45154 5986819.42477 2113508.89753 37.7825307151502 -122.489294848866 (37.7825307151502, -122.489294848866) 11 6 2 55 26
5462 230622 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1191 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6003231.87176 2101368.34583 37.7501400891166 -122.431647872075 (37.7501400891166, -122.431647872075) 2 4 5 28862 22
5470 137605 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1241 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6002263.8485 2112857.1338 37.7816305713373 -122.435817261163 (37.7816305713373, -122.435817261163) 15 5 11 29490 41
5545 130743 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2505 Divisadero St 4 Sidewalk: Property side : Yard Tree Private 2     15 Width 4ft   6000699.35516 2116964.23908 37.7928186255236 -122.441524465083 (37.7928186255236, -122.441524465083) 13 6 1 29490 27
5556 208569 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1226 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990812.99154 2107022.03649 37.7649518737544 -122.475005306654 (37.7649518737544, -122.475005306654) 11 8 11 56 12
5706 230617 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 301 Jersey St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6003140.93999 2101524.62009 37.7505640268286 -122.431973477016 (37.7505640268286, -122.431973477016) 2 4 5 28862 22
5791 171860 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 909 Woolsey St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6009090.60075 2091384.92035 37.7230581082272 -122.410683014136 (37.7230581082272, -122.410683014136) 9 3 7 309 28
5807 2413 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2773 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2013 12:00:00 AM 3 5x5   6009870 2101176 37.7499859781013 -122.408679163531 (37.7499859781013, -122.408679163531) 2 4 7 28859 19
5873 168127 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2329 Baker St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5999736.35511 2116932.30675 37.7926760371256 -122.444854181598 (37.7926760371256, -122.444854181598) 13 6 1 29490 27
5892 261243 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 840 El Camino Del Mar 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
5932 70322 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 212 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5997855.1178 2109822.7379 37.7730474875653 -122.45085044117 (37.7730474875653, -122.45085044117) 15 5 11 29492 16
6063 69315 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1518 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1994 12:00:00 AM 7   Permit Number 33394 5986230.6468 2104875.9024 37.7587925526495 -122.490696346344 (37.7587925526495, -122.490696346344) 1 8 3 56 35
6083 60590 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 601 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1982 12:00:00 AM 14 4x4 Permit Number 20209 6000481 2111039 37.7765370051793 -122.441854521628 (37.7765370051793, -122.441854521628) 15 5 11 29492 16
6085 82927 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1140 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   6010031.8585 2110690.2274 37.7761189490017 -122.40879059487 (37.7761189490017, -122.40879059487) 8 2 9 28853 34
6103 192898 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 347 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6012445.53716 2112672.64368 37.7816971054735 -122.400580271289 (37.7816971054735, -122.400580271289) 6 2 9 28856 34
6116 38816 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 211 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1998 12:00:00 AM 4   Permit Number 40652 5994893.15717 2114075.07126 37.7845532569028 -122.461404489499 (37.7845532569028, -122.461404489499) 11 6 2 54 11
6126 142586 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2310 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6008494.0857 2120777.934 37.803731078252 -122.414824283354 (37.803731078252, -122.414824283354) 5 1 10 308 23
6152 68969 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3343 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1994 12:00:00 AM 9   Permit Number 32959 5999787.27845 2120075.09917 37.8013082157737 -122.44490400674 (37.8013082157737, -122.44490400674) 13 9 1 57 17
6195 208636 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 469 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993711.10983 2101824.71737 37.7508489131681 -122.464604102194 (37.7508489131681, -122.464604102194) 1 8 4 29491 40
6248 21612 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1550 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6005218.1717 2114795.8159 37.7871210866889 -122.4257347292 (37.7871210866889, -122.4257347292) 13 9 11 28858 27
6252 70020 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 700 Central Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5999648.4798 2110952.3759 37.7762516842269 -122.444728210696 (37.7762516842269, -122.444728210696) 15 5 11 29492 16
6389 138549 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2130 POST ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6002048.753 2114005.8939 37.7847725542056 -122.436643640876 (37.7847725542056, -122.436643640876) 13 6 11 29490 13
6397 200027 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1572 Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015191.8647 2094356.6865 37.7315581787012 -122.389799462726 (37.7315581787012, -122.389799462726) 10 3 8 58 1
6474 230184 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1911 15th St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004756.02326 2107181.25678 37.7661872463737 -122.426791183172 (37.7661872463737, -122.426791183172) 8 4 5 28862 3
6531 192922 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 10th St 6 : Tree Private 2     2 Width 3ft   6009195.26787 2109094.7407 37.7716912222994 -122.411571845561 (37.7716912222994, -122.411571845561) 8 2 9 28853 34
6538 230207 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 26 Temple St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5999930.02308 2105801.10604 37.7621236543094 -122.443384183955 (37.7621236543094, -122.443384183955) 15 5 5 28862 3
6574 65759 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3016 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/20/1990 12:00:00 AM 13   Permit Number 28722 6003857.62455 2119183.89761 37.7990926630433 -122.430755182511 (37.7990926630433, -122.430755182511) 13 9 1 57 17
6588 46352 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2900 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2002 12:00:00 AM 13   Permit Number 44595 6000732.4975 2116220.35681 37.7907780071577 -122.441356390798 (37.7907780071577, -122.441356390798) 13 6 1 29490 27
6719 72384 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 592 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6010697.2489 2118956.7107 37.7988539907437 -122.407071630807 (37.7988539907437, -122.407071630807) 3 1 10 308 23
6733 208696 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 235 Bright St 1 : Tree Private 2     1 Width 3ft   5993735.7088 2088773.52296 37.7150149747485 -122.463571955684 (37.7150149747485, -122.463571955684) 9 8 6 64 24
6736 53162 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1123@ HAWES Gilman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM 1   Permit Number 49083 6014891.3438 2089966.2272 37.71948618255 -122.390531758785 (37.71948618255, -122.390531758785) 10 3 8 58 1
6949 230168 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 279 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6003584.36382 2106666.87413 37.764708561268 -122.430807012236 (37.764708561268, -122.430807012236) 8 4 5 28862 3
6970 230089 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 160 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007184.87556 2098217.41585 37.741711615892 -122.417754802436 (37.741711615892, -122.417754802436) 2 7 7 28859 2
7062 60350 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1101 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1982 12:00:00 AM 4   Permit Number 19928 6017464.7861 2093286.0419 37.7287441803863 -122.381867009636 (37.7287441803863, -122.381867009636) 10 3 8 58 1
7077 208685 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 61 Margaret Ave 1 : Tree Private 2     1 Width 3ft   5997050.0175 2089737.60379 37.7178525273547 -122.452185875792 (37.7178525273547, -122.452185875792) 9 8 6 28861 24
7123 99440 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 990X Jamestown Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2012 12:00:00 AM 3 3x10 Permit Number 768748 6014145.42414 2089521.2651 37.7182229956809 -122.393079032245 (37.7182229956809, -122.393079032245) 10 3 8 58 1
7133 229642 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 97 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007320.40243 2098793.80149 37.7433018681988 -122.417327030917 (37.7433018681988, -122.417327030917) 2 7 7 28859 2
7201 5637 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1266 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 3x3   6005132.21095 2100956.30175 37.7491162433305 -122.425047067669 (37.7491162433305, -122.425047067669) 2 4 5 28862 22
7224 230106 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 47 Montezuma St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   6007653.59945 2099775.01516 37.7460148026546 -122.416244399181 (37.7460148026546, -122.416244399181) 2 7 7 28859 2
7277 71773 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1207 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6007676.74747 2115431.38608 37.7890048300542 -122.417273630072 (37.7890048300542, -122.417273630072) 13 1 10 28858 21
7297 130697 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2311 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5999746.50713 2116862.80854 37.7924857927226 -122.444814057435 (37.7924857927226, -122.444814057435) 13 6 1 29490 27
7324 46621 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1566 Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2002 12:00:00 AM 4 3x3 Permit Number 44746 6015540.17012 2096891.35899 37.738537185353 -122.388772173723 (37.738537185353, -122.388772173723) 10 3 8 58 1
7409 79285 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2722 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5994906.63121 2110258.22071 37.7740739800962 -122.46108112387 (37.7740739800962, -122.46108112387) 11 6 2 54 11
7439 193102 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1298 Fairfax Ave 1 : Tree Private 2     3 Width 3ft   6017232.41157 2097031.5064 37.7390156480633 -122.382930908836 (37.7390156480633, -122.382930908836) 10 3 8 58 1
7452 60592 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 613 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1982 12:00:00 AM 10   Permit Number 20211 6000545.2975 2111100.6046 37.7767098193279 -122.44163652073 (37.7767098193279, -122.44163652073) 15 5 11 29492 16
7498 138017 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1798 Bush St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6005043.9346 2115067.7403 37.7878578757703 -122.426356919881 (37.7878578757703, -122.426356919881) 13 9 11 28858 27
7550 71272 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2477 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6000730.11 2114120.4408 37.785012045879 -122.441213921365 (37.785012045879, -122.441213921365) 15 6 11 29490 13
7592 229319 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 3423 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006759.7758 2104940.35562 37.7601473437483 -122.419701563095 (37.7601473437483, -122.419701563095) 2 4 7 28859 19
7596 137880 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2148 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6003654.0545 2115274.6949 37.7883474575543 -122.431180423335 (37.7883474575543, -122.431180423335) 13 9 1 29490 27
7602 5107 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2680 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2007 12:00:00 AM 6 3X3   6002305.28224 2096351.99681 37.736313802225 -122.434493443022 (37.736313802225, -122.434493443022) 2 7 5 63 7
7659 261346 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 600X Columbus Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2020 12:42:00 PM 3 5X5   6009675.3838 2119664.5956 37.8007404309352 -122.410657649881 (37.8007404309352, -122.410657649881) 3 1 10 308 23
7708 76081 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
7709 177350 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 500x San Juan Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6000388.06795 2092890.63875 37.7267006979702 -122.440873804687 (37.7267006979702, -122.440873804687) 9 7 6 28861 25
7714 101793 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 795 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6012464.9097 2112928.8888 37.7824017756076 -122.400531256447 (37.7824017756076, -122.400531256447) 6 2 9 28856 34
7727 259597 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 345 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6012481.99467 2112636.57875 37.7816001127017 -122.400451610675 (37.7816001127017, -122.400451610675) 6 2 9 28856 34
7764 251735 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 338 Chicago Way 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 02:05:00 PM 3 3x3   6002437 2086534 37.7093632573177 -122.433336687258 (37.7093632573177, -122.433336687258) 9 7 6 28861 5
7772 74841 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 200 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   17     6011912.74207 2119472.92585 37.800339337445 -122.402901928701 (37.800339337445, -122.402901928701) 3 1 10 308 23
7812 177349 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 500x San Juan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6000408.55271 2092877.8532 37.726666758438 -122.440802072953 (37.726666758438, -122.440802072953) 9 7 6 28861 25
7815 78721 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 115 Rey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6008722.75942 2087395.11673 37.7120823080297 -122.411672802567 (37.7120823080297, -122.411672802567) 9 7 8 309 39
7871 104619 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 800 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 MTA   7 4x4 Permit Number 770959 6012190.226 2112753.6665 37.7819053332353 -122.401469228728 (37.7819053332353, -122.401469228728) 6 2 9 28853 34
7986 180642 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 56 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 6ft   6001992.8038 2087466.28016 37.7118978840556 -122.4349385283 (37.7118978840556, -122.4349385283) 9 7 6 28861 5
8021 130909 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1268 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008550.55684 2117302.71746 37.7941921699808 -122.414382817833 (37.7941921699808, -122.414382817833) 5 1 10 28857 21
8047 229934 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 602 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6002630.53663 2098906.06974 37.7433451534675 -122.433551376193 (37.7433451534675, -122.433551376193) 2 7 5 63 22
8073 64439 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 40 Rausch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1988 12:00:00 AM 15   Permit Number 25301 6009724.66306 2110846.10571 37.7765297431014 -122.409864276736 (37.7765297431014, -122.409864276736) 8 2 9 28853 34
8087 188688 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1300 Evans Ave 37 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/2017 02:16:00 PM 3 Width 4ft   6017441.41972 2097257.16832 37.739646816544 -122.382223941884 (37.739646816544, -122.382223941884) 10 3 8 58 1
8096 59801 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1035 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/1981 12:00:00 AM 3   Permit Number 19252 6008957.26664 2115956.46154 37.7905185185761 -122.412880324992 (37.7905185185761, -122.412880324992) 5 1 10 28858 21
8140 26662 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1275 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2001 12:00:00 AM 8 3x3   6017216.3972 2096959.142 37.7388160650952 -122.382981244792 (37.7388160650952, -122.382981244792) 10 3 8 58 1
8164 192896 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 345 04th St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6012481.99467 2112636.57875 37.7816001127017 -122.400451610675 (37.7816001127017, -122.400451610675) 6 2 9 28856 34
8191 74104 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 189 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6006471.06973 2093054.28635 37.7274946077702 -122.419856624186 (37.7274946077702, -122.419856624186) 9 7 7 309 5
8292 261770 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 600X Columbus Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1   06/26/2020 11:05:00 AM 3 4x4                      
8353 246952 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2101 15th St 4 : Tree Private 2     2 Width 3ft   6003390.88605 2107111.412 37.7659181907902 -122.43150793845 (37.7659181907902, -122.43150793845) 15 5 5 28862 3
8392 230069 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 800X Eugenia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007643.30066 2097725.00947 37.74038536408 -122.416134851864 (37.74038536408, -122.416134851864) 2 7 7 28859 2
8419 85699 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 918 Howard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2020 12:00:00 AM 3 3x3   6010993.40445 2112488.15858 37.7811094596721 -122.405590993329 (37.7811094596721, -122.405590993329) 14 2 9 28853 34
8426 177304 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 10 Ruth St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 2ft   6001647.41554 2091598.69121 37.723224945954 -122.436427860461 (37.723224945954, -122.436427860461) 9 7 6 28861 25
8471 230647 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 300 Vicksburg St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6004129.21796 2101814.78019 37.7514167163076 -122.428576614423 (37.7514167163076, -122.428576614423) 2 4 5 28862 22
8528 5525 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 875 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/09/2015 07:32:00 AM 3 8x8   6005129 2103286 37.7555128725534 -122.425223924554 (37.7555128725534, -122.425223924554) 2 4 5 28859 19
8615 81216 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1490 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     5989947.3486 2105228.4272 37.7599768999261 -122.477868186468 (37.7599768999261, -122.477868186468) 1 8 3 56 35
8620 230618 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 293 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003249.58488 2101526.98547 37.7505766802717 -122.431597943511 (37.7505766802717, -122.431597943511) 2 4 5 28862 22
8654 142867 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1020 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6006956.6744 2114391.9796 37.786110337763 -122.41969121449 (37.786110337763, -122.41969121449) 13 9 9 28858 36
8704 79435 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 606 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6004044.7014 2110862.9754 37.7762561050616 -122.429514097991 (37.7762561050616, -122.429514097991) 7 9 11 28852 10
8769 32194 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 40 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/1995 12:00:00 AM 2   Permit Number 35521 6000876.834 2109176.6725 37.7714460698883 -122.440351630177 (37.7714460698883, -122.440351630177) 15 5 11 29492 9
8772 42026 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 49 Rausch St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM 6   Permit Number 42349 6009754.59547 2110863.51813 37.776579230974 -122.409761960854 (37.776579230974, -122.409761960854) 8 2 9 28853 34
8813 229976 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 506 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/1983 12:00:00 AM 13 Width 2ft Permit Number 20257 6003460.20133 2096023.86311 37.7354783140686 -122.430477003328 (37.7354783140686, -122.430477003328) 2 7 5 63 7

Next page

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