trees
2,365 rows where qSpecies_id = 31 sorted by Fire Prevention Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
55 | 1166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2020 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.16187 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | 9 | 7 | 6 | 28861 | 25 | ||
263 | 17585 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003724.8526 | 2090366.56287 | 37.71995962001 | -122.429158750084 | (37.71995962001, -122.429158750084) | 9 | 7 | 6 | 28861 | 5 | |||
2748 | 51918 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.92432 | 2091688.24542 | 37.7233599872689 | -122.443166369055 | (37.7233599872689, -122.443166369055) | 9 | 7 | 6 | 28861 | 25 | |
4856 | 17502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002131.24887 | 2091360.19572 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | 9 | 7 | 6 | 28861 | 5 | |||
5601 | 180565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 522 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004047.94044 | 2092448.57496 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | 9 | 7 | 6 | 28861 | 5 | |||
6477 | 215562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 244 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994036.57489 | 2096375.72 | 37.735906092783 | -122.463083305449 | (37.735906092783, -122.463083305449) | 9 | 8 | 4 | 59 | 40 | |||
8303 | 180530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
9012 | 180529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
13245 | 17573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 750 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6003469.36772 | 2090473.15538 | 37.7202378333854 | -122.430049472832 | (37.7202378333854, -122.430049472832) | 9 | 7 | 6 | 28861 | 5 | |||
16748 | 96876 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | 9 | 7 | 6 | 28861 | 25 | |||||
16945 | 180528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
17212 | 17525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6002628.09189 | 2091001.66682 | 37.7216413261572 | -122.432995221074 | (37.7216413261572, -122.432995221074) | 9 | 7 | 6 | 28861 | 5 | |||
17580 | 17622 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1100 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004279.3637264 | 2089959.3319014 | 37.7188728276872 | -122.427213003456 | (37.7188728276872, -122.427213003456) | 9 | 7 | 6 | 28861 | 5 | |||
17973 | 17607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 948X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003925.7500102 | 2090181.5613293 | 37.7194630169915 | -122.428451137586 | (37.7194630169915, -122.428451137586) | 9 | 7 | 6 | 28861 | 5 | |||
17980 | 180512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004254.69534 | 2090025.204 | 37.7190523030053 | -122.427302962162 | (37.7190523030053, -122.427302962162) | 9 | 7 | 6 | 28861 | 5 | |||
18698 | 180522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 703 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6003548.0155 | 2090475.44462 | 37.7202485730803 | -122.429777776817 | (37.7202485730803, -122.429777776817) | 9 | 7 | 6 | 28861 | 5 | |||
18715 | 17618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
21205 | 215567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 254 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993893.11792 | 2096318.45791 | 37.735740600456 | -122.463575134792 | (37.735740600456, -122.463575134792) | 9 | 8 | 4 | 59 | 40 | |||
21755 | 13324 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002777.3722738 | 2090962.3160144 | 37.7215417439498 | -122.432476389775 | (37.7215417439498, -122.432476389775) | 9 | 7 | 6 | 28861 | 5 | |||
22837 | 215572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 745 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5999421.36042 | 2095348.4772 | 37.7333942440298 | -122.44439222862 | (37.7333942440298, -122.44439222862) | 9 | 7 | 4 | 59 | 40 | |||
22856 | 180559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 192 Dublin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004156.47541 | 2089333.3612 | 37.7171470982496 | -122.427593206665 | (37.7171470982496, -122.427593206665) | 9 | 7 | 6 | 28861 | 5 | |||
23559 | 17486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
24238 | 215561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994051.56415 | 2096391.91316 | 37.7359514186289 | -122.463032656549 | (37.7359514186289, -122.463032656549) | 9 | 8 | 4 | 59 | 40 | |||
25169 | 17576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 752X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003542.00606 | 2090427.72603 | 37.7201172080443 | -122.429795147634 | (37.7201172080443, -122.429795147634) | 9 | 7 | 6 | 28861 | 5 | |||
25513 | 17523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002491.854148 | 2091141.7505443 | 37.7220182361725 | -122.433476163825 | (37.7220182361725, -122.433476163825) | 9 | 7 | 6 | 28861 | 5 | |||
25726 | 215523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 80 Northwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995460.48677 | 2094242.81923 | 37.7301315873058 | -122.458006001202 | (37.7301315873058, -122.458006001202) | 9 | 7 | 4 | 28861 | 40 | |||
26514 | 17556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 626 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6003246.79786 | 2090613.71944 | 37.7206111833437 | -122.430828848684 | (37.7206111833437, -122.430828848684) | 9 | 7 | 6 | 28861 | 5 | |||
28436 | 17602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | 9 | 7 | 6 | 28861 | 5 | |||
28588 | 17551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6003191.74591 | 2090695.76954 | 37.7208333554501 | -122.431024998907 | (37.7208333554501, -122.431024998907) | 9 | 7 | 6 | 28861 | 5 | |||
29434 | 215512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993946.59661 | 2096298.31331 | 37.7356883696217 | -122.463388778181 | (37.7356883696217, -122.463388778181) | 9 | 8 | 4 | 59 | 40 | |||
30298 | 215566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 250 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993936.1007 | 2096327.5375 | 37.7357680072927 | -122.463427186434 | (37.7357680072927, -122.463427186434) | 9 | 8 | 4 | 59 | 40 | |||
30944 | 180566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 111 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004117.41747 | 2094047.56106 | 37.7300890412712 | -122.428063967571 | (37.7300890412712, -122.428063967571) | 9 | 7 | 6 | 28861 | 5 | |||
31679 | 17592 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003646.11767 | 2090408.41073 | 37.7200700675728 | -122.429433892277 | (37.7200700675728, -122.429433892277) | 9 | 7 | 6 | 28861 | 5 | |||
35163 | 180534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 401 Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002734.62326 | 2090983.4567 | 37.7215973673155 | -122.432625670733 | (37.7215973673155, -122.432625670733) | 9 | 7 | 6 | 28861 | 5 | |||
35263 | 17532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002799.2909021 | 2090948.5412155 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | 9 | 7 | 6 | 28861 | 5 | |||
37690 | 17590 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003668.70994 | 2090393.51266 | 37.720030439842 | -122.429354736658 | (37.720030439842, -122.429354736658) | 9 | 7 | 6 | 28861 | 5 | |||
37705 | 17606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 945X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004029.89293 | 2090169.1541 | 37.7194348422149 | -122.428090270065 | (37.7194348422149, -122.428090270065) | 9 | 7 | 6 | 28861 | 5 | |||
38280 | 66565 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 195 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1994 12:00:00 AM | Permit Number 29754 | 6004459.66256991 | 2092267.48419115 | 37.725220702439 | -122.426754065425 | (37.725220702439, -122.426754065425) | 9 | 7 | 6 | 28861 | 5 | ||
38863 | 215511 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993997.50574 | 2096315.53912 | 37.7357386003548 | -122.463214016518 | (37.7357386003548, -122.463214016518) | 9 | 8 | 4 | 59 | 40 | |||
40235 | 17524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 311 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002598.14463 | 2091067.38518 | 37.7218200754046 | -122.433103433796 | (37.7218200754046, -122.433103433796) | 9 | 7 | 6 | 28861 | 5 | |||
40289 | 215500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 223 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994062.94348 | 2096703.04121 | 37.736806354618 | -122.463015880573 | (37.736806354618, -122.463015880573) | 9 | 8 | 4 | 59 | 40 | |||
40840 | 17595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003715.34966 | 2090318.22231 | 37.7198263494989 | -122.429188153404 | (37.7198263494989, -122.429188153404) | 9 | 7 | 6 | 28861 | 5 | |||
41166 | 17580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003780.63082 | 2090335.55969 | 37.7198776495042 | -122.428963734788 | (37.7198776495042, -122.428963734788) | 9 | 7 | 6 | 28861 | 5 | |||
41669 | 17530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 418 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002769.64699 | 2090910.44177 | 37.72139887074 | -122.432499390644 | (37.72139887074, -122.432499390644) | 9 | 7 | 6 | 28861 | 5 | |||
42118 | 180519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 919 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6003897.75198 | 2090254.30542 | 37.7196611719008 | -122.428553098957 | (37.7196611719008, -122.428553098957) | 9 | 7 | 6 | 28861 | 5 | |||
42812 | 215548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994023.18881 | 2096729.95205 | 37.7368779550533 | -122.463155280903 | (37.7368779550533, -122.463155280903) | 9 | 8 | 4 | 59 | 40 | |||
42975 | 17574 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 752X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1997 12:00:00 AM | 16 | 3x3 | 6003494.26805 | 2090459.52433 | 37.7202018157394 | -122.429962428847 | (37.7202018157394, -122.429962428847) | 9 | 7 | 6 | 28861 | 5 | ||
43528 | 17611 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6004077.2256201 | 2090145.4202003 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | 9 | 7 | 6 | 28861 | 5 | |||
43659 | 17498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.434870362385 | (37.72266164479, -122.434870362385) | 9 | 7 | 6 | 28861 | 5 | |||
43704 | 88338 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 315 Paris St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541 | 2091742 | 37.7236691751532 | -122.433349150158 | (37.7236691751532, -122.433349150158) | 9 | 7 | 6 | 28861 | 5 | |||
44226 | 180517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6004131.62894 | 2090104.37161 | 37.7192627191689 | -122.427733992853 | (37.7192627191689, -122.427733992853) | 9 | 7 | 6 | 28861 | 5 | |||
44710 | 215501 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 225 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994092.6368 | 2096583.02497 | 37.7364785301452 | -122.462904513945 | (37.7364785301452, -122.462904513945) | 9 | 8 | 4 | 59 | 40 | |||
45197 | 215559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994067.05947 | 2096413.85404 | 37.7360125554181 | -122.462980674831 | (37.7360125554181, -122.462980674831) | 9 | 8 | 4 | 59 | 40 | |||
45851 | 180552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001906.70426 | 2091457.08941 | 37.7228508693472 | -122.435521425698 | (37.7228508693472, -122.435521425698) | 9 | 7 | 6 | 28861 | 5 | |||
47025 | 180518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 919 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6003927.65212 | 2090238.59404 | 37.7196197239493 | -122.42844862563 | (37.7196197239493, -122.42844862563) | 9 | 7 | 6 | 28861 | 5 | |||
47077 | 17528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002717.3851 | 2090942.27549 | 37.7214833152726 | -122.432682318148 | (37.7214833152726, -122.432682318148) | 9 | 7 | 6 | 28861 | 5 | |||
47670 | 1208 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3141 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5995992.87885 | 2086942.40616 | 37.7101169521706 | -122.455637985173 | (37.7101169521706, -122.455637985173) | 9 | 7 | 6 | 28861 | 25 | |||
47939 | 215564 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 250 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993972.9824 | 2096339.81611 | 37.7358038461725 | -122.463300563692 | (37.7358038461725, -122.463300563692) | 9 | 8 | 4 | 59 | 40 | |||
49721 | 30802 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.83021 | 37.733802178321 | -122.43669510479 | (37.733802178321, -122.43669510479) | 9 | 7 | 5 | 63 | 40 |
50995 | 180539 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2063 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000471.84431 | 2090162.7563 | 37.7192153258175 | -122.440388640236 | (37.7192153258175, -122.440388640236) | 9 | 7 | 6 | 28861 | 25 | |||
51187 | 97030 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 278 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997252 | 2090493 | 37.7199382378616 | -122.451542171872 | (37.7199382378616, -122.451542171872) | 9 | 8 | 6 | 28861 | 24 | |||
53336 | 17515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002425.76888 | 2091174.41595 | 37.7221041784351 | -122.433706937351 | (37.7221041784351, -122.433706937351) | 9 | 7 | 6 | 28861 | 5 | |||
54013 | 17571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 749X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003526.33065 | 2090483.75414 | 37.7202701612065 | -122.429853326536 | (37.7202701612065, -122.429853326536) | 9 | 7 | 6 | 28861 | 5 | |||
56016 | 51434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 277 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.7246369688192 | -122.433701359735 | (37.7246369688192, -122.433701359735) | 9 | 7 | 6 | 28861 | 5 | ||
58201 | 17555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 625 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6003276.00472 | 2090644.70105 | 37.7206979067656 | -122.430730099534 | (37.7206979067656, -122.430730099534) | 9 | 7 | 6 | 28861 | 5 | |||
59271 | 215556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994083.61734 | 2096486.44711 | 37.7362128317539 | -122.462928693117 | (37.7362128317539, -122.462928693117) | 9 | 8 | 4 | 59 | 40 | |||
59298 | 215558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994076.83101 | 2096438.60242 | 37.7360810711916 | -122.462948685927 | (37.7360810711916, -122.462948685927) | 9 | 8 | 4 | 59 | 40 | |||
59632 | 17589 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503 | -122.42930461652 | (37.720035114503, -122.42930461652) | 9 | 7 | 6 | 28861 | 5 | |||
59722 | 17586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003709.25966 | 2090367.07531 | 37.7199601443381 | -122.429212686015 | (37.7199601443381, -122.429212686015) | 9 | 7 | 6 | 28861 | 5 | |||
59946 | 17494 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 98X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 6001936.09269 | 2091434.74089 | 37.7227911744411 | -122.435418238322 | (37.7227911744411, -122.435418238322) | 9 | 7 | 6 | 28861 | 5 | |||
60340 | 17536 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003012.06568 | 2090814.03767 | 37.7211479104352 | -122.431654537837 | (37.7211479104352, -122.431654537837) | 9 | 7 | 6 | 28861 | 5 | |||
60428 | 180515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004177.13289 | 2090077.86698 | 37.7191925171931 | -122.427574815527 | (37.7191925171931, -122.427574815527) | 9 | 7 | 6 | 28861 | 5 | |||
61112 | 1325 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4051X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5991764.76245 | 2086963.37686 | 37.7099309898835 | -122.470252581934 | (37.7099309898835, -122.470252581934) | 9 | 8 | 4 | 64 | 24 | |||
61315 | 180513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004235.63883 | 2090036.93621 | 37.7190834393332 | -122.427369668478 | (37.7190834393332, -122.427369668478) | 9 | 7 | 6 | 28861 | 5 | |||
63979 | 17601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 901X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6003845.6513541 | 2090290.953545 | 37.7197588510105 | -122.428735803294 | (37.7197588510105, -122.428735803294) | 9 | 7 | 6 | 28861 | 5 | |||
64022 | 17552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 611 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003214.50174 | 2090682.11363 | 37.7207971487572 | -122.430945364856 | (37.7207971487572, -122.430945364856) | 9 | 7 | 6 | 28861 | 5 | |||
64445 | 17617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | 9 | 7 | 6 | 28861 | 5 | |||
64697 | 180520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 919 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6003878.61607 | 2090266.0202 | 37.7196922551652 | -122.428620079558 | (37.7196922551652, -122.428620079558) | 9 | 7 | 6 | 28861 | 5 | |||
66323 | 17517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002447.6310917 | 2091110.4885814 | 37.7219298886661 | -122.433626798632 | (37.7219298886661, -122.433626798632) | 9 | 7 | 6 | 28861 | 5 | |||
68728 | 215503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 233 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994106.38436 | 2096527.49502 | 37.7363268505023 | -122.462852955799 | (37.7363268505023, -122.462852955799) | 9 | 8 | 4 | 59 | 40 | |||
68959 | 180563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 88 Norton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001669.16687 | 2092383.58847 | 37.7253813322715 | -122.436408819134 | (37.7253813322715, -122.436408819134) | 9 | 7 | 6 | 28861 | 25 | |||
70144 | 17490 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 11 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3X3 | 6001895.26392 | 2091509.73666 | 37.7229947770751 | -122.435564737019 | (37.7229947770751, -122.435564737019) | 9 | 7 | 6 | 28861 | 5 | |||
71134 | 17624 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1101 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6004341.89656 | 2089971.87372 | 37.7189108009657 | -122.426997744874 | (37.7189108009657, -122.426997744874) | 9 | 7 | 6 | 28861 | 5 | |||
71414 | 17582 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.429028371762 | (37.7199031291015, -122.429028371762) | 9 | 7 | 6 | 28861 | 5 | |||
73095 | 215524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 80 Northwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995481.22092 | 2094239.13462 | 37.7301226615312 | -122.457934054513 | (37.7301226615312, -122.457934054513) | 9 | 7 | 4 | 28861 | 40 | |||
73412 | 215570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 96 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995600.39767 | 2096198.59734 | 37.7355097165874 | -122.457663772269 | (37.7355097165874, -122.457663772269) | 9 | 7 | 4 | 59 | 40 | |||
73784 | 17543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 531 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002997.1960546 | 2090824.1673225 | 37.7211748813523 | -122.431706660652 | (37.7211748813523, -122.431706660652) | 9 | 7 | 6 | 28861 | 5 | |||
75234 | 13323 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002777.3722738 | 2090962.3160144 | 37.7215417439498 | -122.432476389775 | (37.7215417439498, -122.432476389775) | 9 | 7 | 6 | 28861 | 5 | |||
75740 | 215550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994032.03336 | 2096692.14483 | 37.7367746553097 | -122.463121959218 | (37.7367746553097, -122.463121959218) | 9 | 8 | 4 | 59 | 40 | |||
77576 | 180549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002285.83786 | 2091218.55546 | 37.7222174345718 | -122.43419379793 | (37.7222174345718, -122.43419379793) | 9 | 7 | 6 | 28861 | 5 | |||
80886 | 17538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 4x7.5 | 6002931.4135505 | 2090865.5085081 | 37.7212846660211 | -122.431937002131 | (37.7212846660211, -122.431937002131) | 9 | 7 | 6 | 28861 | 5 | |||
81332 | 52332 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.459292150941 | (37.7353714395789, -122.459292150941) | 9 | 7 | 4 | 59 | 40 | ||||
81510 | 17570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 749X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003493.5133628 | 2090512.2555079 | 37.7203465611878 | -122.429968797048 | (37.7203465611878, -122.429968797048) | 9 | 7 | 6 | 28861 | 5 | |||
82587 | 17597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 844 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003772.37846 | 2090279.52588 | 37.7197233258537 | -122.428988267402 | (37.7197233258537, -122.428988267402) | 9 | 7 | 6 | 28861 | 5 | |||
83733 | 17620 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
84691 | 215565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 250 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993953.18487 | 2096333.32123 | 37.7357848722665 | -122.463368539821 | (37.7357848722665, -122.463368539821) | 9 | 8 | 4 | 59 | 40 | |||
85661 | 17503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002145.06129 | 2091350.82839 | 37.7225726352947 | -122.434689881929 | (37.7225726352947, -122.434689881929) | 9 | 7 | 6 | 28861 | 5 | |||
86019 | 17537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/1999 12:00:00 AM | 3 | 3x3 | 6002961.1307 | 2090844.10696 | 37.7212275867697 | -122.431832751099 | (37.7212275867697, -122.431832751099) | 9 | 7 | 6 | 28861 | 5 | ||
87095 | 88329 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 120 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940 | 2092960 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | 9 | 7 | 6 | 28861 | 5 | |||
87426 | 17516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002342.1367821 | 2091235.8408171 | 37.7222680914982 | -122.434000421261 | (37.7222680914982, -122.434000421261) | 9 | 7 | 6 | 28861 | 5 |
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) );