trees
267 rows where qSpecies_id = 100 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68327 | 186829 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200 Sunset Blvd | 94 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984823.8588 | 2106586.1554 | 37.763406151967 | -122.495687746344 | (37.763406151967, -122.495687746344) | 1 | 8 | 3 | 56 | 35 | |||
4432 | 181365 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1600 Sunset Blvd | 92 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984912.4611 | 2104151.8757 | 37.7567274870678 | -122.495201781242 | (37.7567274870678, -122.495201781242) | 1 | 8 | 3 | 56 | 35 | |||
668 | 19865 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
6570 | 19989 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40 | |||||||||||||
9459 | 19610 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
11958 | 262083 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
18475 | 19731 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
60871 | 110703 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
144141 | 141485 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5996846.7484 | 2111491.4026 | 37.7775714294456 | -122.454459061112 | (37.7775714294456, -122.454459061112) | 15 | 6 | 2 | 54 | 16 | |||
11089 | 19690 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 89 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
18817 | 19689 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 88 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16250 | 19688 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 87 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
5560 | 19687 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 86 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
3883 | 19686 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 85 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
5469 | 19685 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 84 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
17616 | 19684 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 83 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
7456 | 19682 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 81 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60ST | |||||||||||||
17410 | 19681 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 80 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
3041 | 19585 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY4 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
3448 | 19730 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
13846 | 262084 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
18480 | 19609 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
99835 | 20781 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1701X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816 | (37.7552952964732, -122.49524762816) | 1 | 8 | 3 | 56 | 35 | |||
130182 | 185865 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2000 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985059.0462 | 2100990.2907 | 37.7480552245721 | -122.494461791049 | (37.7480552245721, -122.494461791049) | 1 | 8 | 3 | 29491 | 35 | |||
133753 | 141484 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5996823.7065 | 2111503.4721 | 37.7776032476224 | -122.454539642462 | (37.7776032476224, -122.454539642462) | 15 | 6 | 2 | 54 | 16 | |||
10384 | 19679 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 78 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
2429 | 19676 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 75 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16026 | 19673 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 72 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
5089 | 262085 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
15419 | 23925 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700X Webster St | 7 | Median : Cutout | Tree | DPW 1 | 60 | 12x1 | 6003454.8844904 | 2114845.825423 | 37.7871586020093 | -122.431838884639 | (37.7871586020093, -122.431838884639) | 13 | 9 | 11 | 29490 | 27 | |||
18517 | 19608 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
96144 | 186012 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1900 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985010.9219 | 2101736.8552 | 37.750102270029 | -122.494683232466 | (37.750102270029, -122.494683232466) | 1 | 8 | 3 | 29491 | 35 | |||
135916 | 141536 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5996809.4424 | 2111483.7219 | 37.7775482006436 | -122.454587559354 | (37.7775482006436, -122.454587559354) | 15 | 6 | 2 | 54 | 16 | |||
154648 | 110701 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
175552 | 234488 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 4090 20th St | 7 | : Yard | Tree | Private 2 | 16 | Width 3ft | 6003119.17834 | 2104176.3954 | 37.7578439389691 | -122.432238089941 | (37.7578439389691, -122.432238089941) | 2 | 4 | 5 | 28862 | 3 | |||
14700 | 19670 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 69 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
3770 | 19669 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 68 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
140163 | 194432 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 900x Carolina St | 64 | Median : Yard | Tree | DPW 1 | 17 | 6012507.9331 | 2102881.18314 | 37.754815434199 | -122.399676708016 | (37.754815434199, -122.399676708016) | 10 | 3 | 8 | 28856 | 29 | ||||
169924 | 187279 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2401 Sunset Blvd | 62 | Median : Yard | Tree | DPW 1 | 4 | Width 0ft | 5984952.4466 | 2098301.7622 | 37.7406670151021 | -122.494632227246 | (37.7406670151021, -122.494632227246) | 1 | 8 | 3 | 29491 | 35 | |||
8767 | 19662 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 61 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
1192 | 262086 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
4379 | 19728 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
6577 | 19937 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY38 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10ST | |||||||||||||
13138 | 19607 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
16746 | 19862 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
19228 | 19750 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
124287 | 211045 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 380 Santa Clara Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 3ft | 5993150.7745 | 2095420.35942 | 37.7332318444736 | -122.466076441693 | (37.7332318444736, -122.466076441693) | 9 | 8 | 4 | 59 | 40 | |||
134476 | 245149 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1192 Page St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000871.2374 | 2109327.7689 | 37.7718606240856 | -122.440381827143 | (37.7718606240856, -122.440381827143) | 15 | 5 | 11 | 29492 | 9 | |||
192591 | 808 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 600X 39th Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
193841 | 211046 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 251 Wildwood Way | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 3ft | 5995705.57302 | 2093291.07499 | 37.7275324053909 | -122.457089894179 | (37.7275324053909, -122.457089894179) | 9 | 7 | 4 | 28861 | 40 | |||
10472 | 19659 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 58 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60ST | |||||||||||||
38345 | 181498 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1400 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.653 | 2105433.8466 | 37.7602444476946 | -122.495472038545 | (37.7602444476946, -122.495472038545) | 1 | 8 | 3 | 56 | 35 | |||
97619 | 187039 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2501 Sunset Blvd | 58 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984947.4301 | 2097783.6094 | 37.7392440133349 | -122.494611382457 | (37.7392440133349, -122.494611382457) | 1 | 8 | 3 | 29491 | 35 | |||
15658 | 19658 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 57 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
84533 | 185510 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2200 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985082.4009 | 2099946.5475 | 37.7451907564521 | -122.494304109241 | (37.7451907564521, -122.494304109241) | 1 | 8 | 3 | 29491 | 35 | |||
16767 | 181422 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1500 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984930.7159 | 2104775.5208 | 37.758440912105 | -122.495184638383 | (37.758440912105, -122.495184638383) | 1 | 8 | 3 | 56 | 35 | |||
175429 | 187119 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2600 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985168.1593 | 2097316.6584 | 37.7379748077492 | -122.493813809362 | (37.7379748077492, -122.493813809362) | 1 | 8 | 3 | 29491 | 35 | |||
17754 | 19655 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 54 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
21989 | 187401 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2100 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985066.4729 | 2100733.1142 | 37.747349522643 | -122.494417155333 | (37.747349522643, -122.494417155333) | 1 | 8 | 3 | 29491 | 35 | |||
167992 | 181494 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1400 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984852.1847 | 2105397.6443 | 37.7601444918652 | -122.495502114318 | (37.7601444918652, -122.495502114318) | 1 | 8 | 3 | 56 | 35 | |||
15694 | 19654 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 53 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
16706 | 19652 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 51 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
85558 | 186783 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 0ft | 5984862.3254 | 2106838.1239 | 37.7641002392741 | -122.49557329041 | (37.7641002392741, -122.49557329041) | 1 | 8 | 3 | 56 | 35 | |||
183847 | 185496 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2400 Sunset Blvd | 50 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985141.6583 | 2098649.8553 | 37.7416338578085 | -122.494003662835 | (37.7416338578085, -122.494003662835) | 1 | 8 | 3 | 29491 | 35 | |||
3185 | 141534 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2901 TURK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5996778.1712 | 2111479.8816 | 37.7775358625794 | -122.454695458772 | (37.7775358625794, -122.454695458772) | 15 | 6 | 2 | 54 | 16 | |||
7006 | 19814 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY24 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
7696 | 19727 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
8828 | 19606 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 | |||||||||||||
12562 | 262087 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
15745 | 19847 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY26 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30 | |||||||||||||
16655 | 19861 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
43322 | 21267 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2492X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984994.4282385 | 2098239.2478178 | 37.740497824548 | -122.494482465671 | (37.740497824548, -122.494482465671) | 1 | 8 | 3 | 29491 | 35 | |||
54825 | 110699 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
57780 | 12503 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200X Lake Merced Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5987438.4549992 | 2087542.2692131 | 37.7112694082243 | -122.485247377649 | (37.7112694082243, -122.485247377649) | 1 | 8 | 4 | 64 | 14 | |||
91858 | 234491 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 24 Saturn St | 5 | Side Yard : Yard | Tree | Private 2 | 17 | Width 3ft | 6000385.28479 | 2106021.72649 | 37.7627553749804 | -122.44182544749 | (37.7627553749804, -122.44182544749) | 15 | 5 | 5 | 28862 | 3 | |||
148969 | 23882 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1500X Webster St | 5 | Median : Cutout | Tree | DPW 1 | 20 | 12 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.431115216253 | (37.7845850728987, -122.431115216253) | 13 | 9 | 11 | 29490 | 41 | |||
177971 | 200796 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015315.685 | 2088368.925 | 37.7151238332906 | -122.388953494511 | (37.7151238332906, -122.388953494511) | 10 | 3 | 8 | 58 | 1 | |||
11434 | 19648 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 47 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
15491 | 19647 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 46 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
20775 | 186778 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1200 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 0ft | 5984835.1586 | 2106804.893 | 37.7640074057024 | -122.495664799754 | (37.7640074057024, -122.495664799754) | 1 | 8 | 3 | 56 | 35 | |||
18738 | 19646 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 45 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60ST | |||||||||||||
18925 | 19645 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30 | |||||||||||||
11194 | 19644 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 43 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
130527 | 234484 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 310 Liberty St | 42 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 6003878.87158 | 2103925.4289 | 37.7571978893843 | -122.42959285554 | (37.7571978893843, -122.42959285554) | 2 | 4 | 5 | 28862 | 3 | |||
2687 | 19642 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 41 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 30 | |||||||||||||
84766 | 181408 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1500 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984930.7159 | 2104693.9263 | 37.7582168762917 | -122.495178621433 | (37.7582168762917, -122.495178621433) | 1 | 8 | 3 | 56 | 35 | |||
152496 | 186156 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1700 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984977.8278 | 2103337.3397 | 37.7544948232836 | -122.49491566635 | (37.7544948232836, -122.49491566635) | 1 | 8 | 3 | 56 | 35 | |||
26457 | 194520 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1600 Bay Shore Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6012006.62045 | 2091255.62525 | 37.7228661524341 | -122.400593779099 | (37.7228661524341, -122.400593779099) | 10 | 3 | 7 | 309 | 28 | |||
1526 | 262088 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
1785 | 19984 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY46 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 40 | |||||||||||||
3211 | 19860 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY30 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 30ST | |||||||||||||
3507 | 91430 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 800X Portola Dr | 4 | Median : Cutout | Tree | DPW 1 | 10/10/2005 12:00:00 AM | 4x4 | 5996711.121131 | 2099335.742872 | 37.7441872967186 | -122.454050104178 | (37.7441872967186, -122.454050104178) | 1 | 7 | 4 | 59 | 40 | |||
4365 | 19748 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY15 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10ST | |||||||||||||
7129 | 19726 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY14 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
10838 | 233336 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 5545 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6001777.47587 | 2097325.41548 | 37.7389566084644 | -122.436387932367 | (37.7389566084644, -122.436387932367) | 2 | 7 | 5 | 63 | 7 | |||
72299 | 200142 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015325.0376 | 2088350.2198 | 37.7150729908419 | -122.388919862472 | (37.7150729908419, -122.388919862472) | 10 | 3 | 8 | 58 | 1 | |||
124810 | 107321 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 400X JUNIPERO SERRA BLVD | 4 | Median : Cutout | Tree | DPW 1 | 14 | 5991395 | 2094254 | 37.7299278633008 | -122.47206158935 | (37.7299278633008, -122.47206158935) | 9 | 8 | 4 | 64 | 40 | ||||
137765 | 100745 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 760 Duboce Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002024.1 | 2108325.5 | 37.7691742163209 | -122.436322258742 | (37.7691742163209, -122.436322258742) | 15 | 5 | 5 | 29492 | 9 | ||||
173188 | 29631 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1110X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991107.8990451 | 2089843.5367701 | 37.717801208369 | -122.47273266668 | (37.717801208369, -122.47273266668) | 9 | 8 | 4 | 64 | 40 | |||
8062 | 19638 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 100 STAIRWAY5 | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 30 |
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) );