trees
2,365 rows where qSpecies_id = 31 sorted by Latitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152147 | 17565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4.5x4.5 | 6003438.97081 | 2090543.76547 | 37.7204299915223 | -122.430159579516 | (37.7204299915223, -122.430159579516) | 9 | 7 | 6 | 28861 | 5 | |||
| 119390 | 17564 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4.5x8 | 6003386.5742173 | 2090579.4616613 | 37.7205250375642 | -122.430343243034 | (37.7205250375642, -122.430343243034) | 9 | 7 | 6 | 28861 | 5 | |||
| 169437 | 17563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4.5x4.5 | 6003386.5742173 | 2090579.4616613 | 37.7205250375642 | -122.430343243034 | (37.7205250375642, -122.430343243034) | 9 | 7 | 6 | 28861 | 5 | |||
| 178765 | 17558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 632 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6003270.54295 | 2090597.85658 | 37.7205689727677 | -122.430745637999 | (37.7205689727677, -122.430745637999) | 9 | 7 | 6 | 28861 | 5 | |||
| 176437 | 17562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 645 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003332.52001 | 2090606.8773 | 37.7205972528473 | -122.43053204633 | (37.7205972528473, -122.43053204633) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 130037 | 17554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 620 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003227.93089 | 2090625.05216 | 37.7206412314956 | -122.430894874199 | (37.7206412314956, -122.430894874199) | 9 | 7 | 6 | 28861 | 5 | |||
| 133641 | 17557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003296.79143 | 2090629.3686 | 37.7206569849073 | -122.430657152829 | (37.7206569849073, -122.430657152829) | 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 | |||
| 93680 | 17549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6003191.59323 | 2090648.1169 | 37.7207025031963 | -122.431022127369 | (37.7207025031963, -122.431022127369) | 9 | 7 | 6 | 28861 | 5 | |||
| 91679 | 17550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6003170.84982 | 2090661.1447 | 37.7207370992233 | -122.431094760237 | (37.7207370992233, -122.431094760237) | 9 | 7 | 6 | 28861 | 5 | |||
| 187731 | 17553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 615 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 2X2 | 6003240.95528 | 2090665.71698 | 37.7207536260542 | -122.430852753549 | (37.7207536260542, -122.430852753549) | 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 | |||
| 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 | |||
| 169451 | 180545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 590 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003050.74777 | 2090737.10045 | 37.720938850417 | -122.431515335386 | (37.720938850417, -122.431515335386) | 9 | 7 | 6 | 28861 | 5 | |||
| 88059 | 17545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 543 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6003118.20236 | 2090743.39426 | 37.7209599548222 | -122.431282614218 | (37.7209599548222, -122.431282614218) | 9 | 7 | 6 | 28861 | 5 | |||
| 116215 | 180527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 543 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6003103.45709 | 2090752.99911 | 37.720985491961 | -122.431334269463 | (37.720985491961, -122.431334269463) | 9 | 7 | 6 | 28861 | 5 | |||
| 103729 | 17547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 548X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003010.1465759 | 2090756.9744765 | 37.7209911187853 | -122.431657099656 | (37.7209911187853, -122.431657099656) | 9 | 7 | 6 | 28861 | 5 | |||
| 153988 | 17544 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 537 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6003083.60804 | 2090766.94886 | 37.7210226699524 | -122.431403876997 | (37.7210226699524, -122.431403876997) | 9 | 7 | 6 | 28861 | 5 | |||
| 117220 | 17542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/2011 12:00:00 AM | 3 | 3x3 | 6003053.24569 | 2090786.85001 | 37.7210755932558 | -122.431510250621 | (37.7210755932558, -122.431510250621) | 9 | 7 | 6 | 28861 | 5 | ||
| 123821 | 17535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003034.53059 | 2090798.32089 | 37.7211060289883 | -122.431575761713 | (37.7211060289883, -122.431575761713) | 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 | |||
| 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 | |||
| 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 | ||
| 173093 | 17531 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 444 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002851.30461 | 2090860.81338 | 37.7212672324683 | -122.432213580703 | (37.7212672324683, -122.432213580703) | 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 | |||
| 152997 | 215517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 164 Howth St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997515.64352 | 2090995.97654 | 37.7213343884584 | -122.450667096231 | (37.7213343884584, -122.450667096231) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 115411 | 13321 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1997 12:00:00 AM | 5 | 3X3 | 6002797.38385 | 2090943.99635 | 37.7214925769985 | -122.432405907456 | (37.7214925769985, -122.432405907456) | 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 | |||
| 122734 | 17534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 3 | 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 | |||
| 173625 | 17533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 2 | 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 | |||
| 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 | |||
| 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 | |||
| 94852 | 13322 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 2 | 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 | |||
| 141496 | 180533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 401 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002751.65611 | 2090978.09371 | 37.7215836076762 | -122.432566409917 | (37.7215836076762, -122.432566409917) | 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 | |||
| 173056 | 122420 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2200 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
| 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 | |||
| 104879 | 180558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 391 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002652.45848 | 2091031.88145 | 37.7217256708875 | -122.432913149844 | (37.7217256708875, -122.432913149844) | 9 | 7 | 6 | 28861 | 5 | |||
| 190369 | 17527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 349X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6002621.9363 | 2091050.61782 | 37.7217753855301 | -122.433019994862 | (37.7217753855301, -122.433019994862) | 9 | 7 | 6 | 28861 | 5 | |||
| 99578 | 180557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 391 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002620.62071 | 2091051.67634 | 37.7217782173661 | -122.433024618098 | (37.7217782173661, -122.433024618098) | 9 | 7 | 6 | 28861 | 5 | |||
| 104490 | 17518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002537.72422 | 2091058.53445 | 37.7217923457343 | -122.433311659211 | (37.7217923457343, -122.433311659211) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 126507 | 180540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2134 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5998917.8755 | 2091146.49396 | 37.7218278392563 | -122.445830812055 | (37.7218278392563, -122.445830812055) | 9 | 7 | 6 | 28861 | 25 | |||
| 103898 | 17519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6002513.47081 | 2091072.78557 | 37.7218301001725 | -122.433396514735 | (37.7218301001725, -122.433396514735) | 9 | 7 | 6 | 28861 | 5 | |||
| 151388 | 180556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002572.40601 | 2091082.8372 | 37.7218610431436 | -122.433193508995 | (37.7218610431436, -122.433193508995) | 9 | 7 | 6 | 28861 | 5 | |||
| 93532 | 17520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/1998 12:00:00 AM | 18 | 3x3 | 6002494.30852 | 2091085.91322 | 37.7218650586013 | -122.433463691421 | (37.7218650586013, -122.433463691421) | 9 | 7 | 6 | 28861 | 5 | ||
| 115721 | 17526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 349X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002579.5148665 | 2091086.6599396 | 37.7218719428007 | -122.433169208527 | (37.7218719428007, -122.433169208527) | 9 | 7 | 6 | 28861 | 5 | |||
| 91687 | 17522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 307 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6002546.66743 | 2091098.28956 | 37.7219020117492 | -122.433283584179 | (37.7219020117492, -122.433283584179) | 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 | |||
| 114947 | 17521 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002512.93657 | 2091121.04264 | 37.7219625730029 | -122.433401808174 | (37.7219625730029, -122.433401808174) | 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 | |||
| 159756 | 180546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 228 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002372.12567 | 2091162.28093 | 37.7220678143702 | -122.433891501616 | (37.7220678143702, -122.433891501616) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 180325 | 17514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002400.99383 | 2091189.19971 | 37.7221433654964 | -122.433793634664 | (37.7221433654964, -122.433793634664) | 9 | 7 | 6 | 28861 | 5 | |||
| 117431 | 180547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002320.38624 | 2091195.17926 | 37.7221552095645 | -122.434072702398 | (37.7221552095645, -122.434072702398) | 9 | 7 | 6 | 28861 | 5 | |||
| 175594 | 17513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002376.23219 | 2091204.63173 | 37.7221843332317 | -122.433880332025 | (37.7221843332317, -122.433880332025) | 9 | 7 | 6 | 28861 | 5 | |||
| 151128 | 180548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002299.71139 | 2091209.35662 | 37.7221929640283 | -122.434145183247 | (37.7221929640283, -122.434145183247) | 9 | 7 | 6 | 28861 | 5 | |||
| 148912 | 17511 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 226 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/1999 12:00:00 AM | 12 | 3X3 | 6002275.9984778 | 2091218.3515509 | 37.7222163162231 | -122.434227795703 | (37.7222163162231, -122.434227795703) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 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 | |||
| 154845 | 17483 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
| 180485 | 17484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
| 192768 | 17485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 3 | 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 | |||
| 88381 | 180555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002345.73736 | 2091226.34505 | 37.7222422225842 | -122.433987296498 | (37.7222422225842, -122.433987296498) | 9 | 7 | 6 | 28861 | 5 | |||
| 188402 | 180550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002268.14618 | 2091228.59703 | 37.7222440023296 | -122.434255671279 | (37.7222440023296, -122.434255671279) | 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 | |||
| 139802 | 180554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002324.53042 | 2091240.40597 | 37.722279627184 | -122.434061608377 | (37.722279627184, -122.434061608377) | 9 | 7 | 6 | 28861 | 5 | |||
| 96880 | 180553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002310.38587 | 2091249.45614 | 37.7223036741654 | -122.434111149317 | (37.7223036741654, -122.434111149317) | 9 | 7 | 6 | 28861 | 5 | |||
| 173125 | 17509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 209 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6002301.24651 | 2091251.1556 | 37.7223078217962 | -122.434142863321 | (37.7223078217962, -122.434142863321) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 145910 | 17499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6002048.76612 | 2091365.28566 | 37.7226068644033 | -122.435023785838 | (37.7226068644033, -122.435023785838) | 9 | 7 | 6 | 28861 | 5 | ||
| 97426 | 17495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002027.05349 | 2091378.72089 | 37.722642521628 | -122.43509980193 | (37.722642521628, -122.43509980193) | 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 | |||
| 90891 | 17497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002079.41309 | 2091392.13948 | 37.7226823390961 | -122.434919765734 | (37.7226823390961, -122.434919765734) | 9 | 7 | 6 | 28861 | 5 | |||
| 126316 | 17496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2003 12:00:00 AM | 3 | 2X2 | 6002048.59392 | 2091411.20621 | 37.7227329421421 | -122.435027663714 | (37.7227329421421, -122.435027663714) | 9 | 7 | 6 | 28861 | 5 | ||
| 182809 | 180551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001942.54043 | 2091434.19539 | 37.7227900428055 | -122.435395910889 | (37.7227900428055, -122.435395910889) | 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 | |||
| 173502 | 17493 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 98X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6001898.43212 | 2091454.2052 | 37.722842480127 | -122.435549814469 | (37.722842480127, -122.435549814469) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 131848 | 17492 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 43 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 6001974.03166 | 2091459.77916 | 37.7228620784977 | -122.435288881679 | (37.7228620784977, -122.435288881679) | 9 | 7 | 6 | 28861 | 5 | |||
| 182257 | 17491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 33 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001944.766 | 2091477.89942 | 37.7229101706379 | -122.435391342346 | (37.7229101706379, -122.435391342346) | 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 | |||||
| 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 | |||
| 163774 | 198514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1601 Bay Shore Blvd | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6012038.03347 | 2091375.16372 | 37.7231961325824 | -122.400493582929 | (37.7231961325824, -122.400493582929) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 91285 | 180538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010266.12531 | 2092269.81 | 37.7255536693496 | -122.406681772069 | (37.7255536693496, -122.406681772069) | 10 | 3 | 7 | 309 | 28 | |||
| 63241 | 180537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010311.60374 | 2092285.69304 | 37.7255998252705 | -122.406525674941 | (37.7255998252705, -122.406525674941) | 10 | 3 | 7 | 309 | 28 | |||
| 160710 | 180536 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010343.05054 | 2092296.39853 | 37.7256309795628 | -122.406417719414 | (37.7256309795628, -122.406417719414) | 10 | 3 | 7 | 309 | 28 | |||
| 76321 | 180535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010393.23752 | 2092315.54751 | 37.7256863661069 | -122.406245574796 | (37.7256863661069, -122.406245574796) | 10 | 3 | 7 | 309 | 28 |
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) );