trees
3,587 rows where qSpecies_id = 28 sorted by qLegalStatus_id 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
118056 | 111195 | Section 143 10 | Corymbia ficifolia :: Red Flowering Gum 28 | 890x JARBOE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x12 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | |||
149976 | 104650 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 346 LAKE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 10x8 | 5994385.6 | 2114927.2 | 37.7868637456835 | -122.463222305141 | (37.7868637456835, -122.463222305141) | 11 | 6 | 1 | 54 | 11 | ||||
156160 | 108314 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 2501X DIAMOND ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002141 | 2097265 | 37.7388113707969 | -122.435126715418 | (37.7388113707969, -122.435126715418) | 2 | 7 | 5 | 63 | 7 | ||||
167961 | 104436 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 SAN FERNANDO WAY | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 5992040 | 2096369 | 37.7357724272627 | -122.469985704629 | (37.7357724272627, -122.469985704629) | 1 | 8 | 4 | 59 | 40 | ||||
20402 | 257888 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Magellan Ave | 1 | Front Yard : Yard | Tree | MTA 3 | 10x10 | 5995070 | 2100842 | 37.7482288640106 | -122.459833790503 | (37.7482288640106, -122.459833790503) | 1 | 8 | 4 | 29491 | 40 | ||||
57045 | 105169 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 3 | Front Yard : Cutout | Tree | Arts Commission 19 | 23 | 4x4 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
133384 | 105167 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 4755X 03RD ST | 1 | Front Yard : Cutout | Tree | Arts Commission 19 | 8 | 3x3 | 6015032 | 2095658 | 37.7351224553975 | -122.390443042679 | (37.7351224553975, -122.390443042679) | 10 | 3 | 8 | 58 | 1 | |||
153614 | 255116 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 301X Chester Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 10x10 | 5991786 | 2087190 | 37.7105544703116 | -122.470195673297 | (37.7105544703116, -122.470195673297) | 9 | 8 | 4 | 64 | 24 | ||||
178160 | 173600 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996184 | 2102497 | 37.7528370823128 | -122.456101271869 | (37.7528370823128, -122.456101271869) | 1 | 5 | 4 | 63 | 12 | ||||
1663 | 27797 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 3 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
2050 | 50805 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1498 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2004 12:00:00 AM | Permit Number 47329 | 6000596.76427703 | 2111027.41746177 | 37.7765117981927 | -122.441453229456 | (37.7765117981927, -122.441453229456) | 15 | 5 | 11 | 29492 | 41 | |||
3325 | 11719 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
4157 | 52083 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 770 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48281 | 6010080.56543171 | 2116389.03640526 | 37.7917692527785 | -122.409024297587 | (37.7917692527785, -122.409024297587) | 5 | 1 | 10 | 28857 | 21 | |||
5631 | 50066 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | 15 | 4 | 5 | 28862 | 3 | ||
5844 | 99991 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44594 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | ||||
6473 | 48743 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
7358 | 108758 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1449 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999638.3 | 2109087.9 | 37.7711317264146 | -122.444629385712 | (37.7711317264146, -122.444629385712) | 15 | 5 | 11 | 29492 | 9 | |||||
7374 | 48751 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
7848 | 54566 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1312 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 3x3 | Permit Number 10364 | 6000274.16247872 | 2109249.10106233 | 37.7716106075543 | -122.44244149612 | (37.7716106075543, -122.44244149612) | 15 | 5 | 11 | 29492 | 9 | ||
8604 | 48746 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
8893 | 50823 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
9839 | 48748 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
9937 | 99488 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 800X Miramar Ave | 1 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |
10173 | 48744 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10360 | 30354 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1956 12:00:00 AM | Permit Number 43 | ||||||||||||||
10872 | 33492 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 25 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37604 | 6007009.01726732 | 2099597.28801828 | 37.7454905378147 | -122.418460683772 | (37.7454905378147, -122.418460683772) | 2 | 7 | 7 | 28859 | 2 | ||
10989 | 254569 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400x Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | 6004613 | 2113717 | 37.7841247118733 | -122.427751595484 | (37.7841247118733, -122.427751595484) | 13 | 9 | 11 | 28858 | 41 | |||
11098 | 99478 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 4 | Median : Yard | Tree | Private 2 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
11727 | 27637 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Lake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 4x4 | 5994586.51749 | 2114934.45483 | 37.7868952379175 | -122.462527708701 | (37.7868952379175, -122.462527708701) | 11 | 6 | 1 | 54 | 11 | |||
11935 | 50824 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
12040 | 48742 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12785 | 48747 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12893 | 24392 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/21/1995 12:00:00 AM | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | ||
15071 | 48749 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
15641 | 48745 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
16175 | 206292 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1273 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1972 12:00:00 AM | 14 | 3x4 | Permit Number 10064 | 5995766.39546 | 2106910.95096 | 37.764932686723 | -122.457864799544 | (37.764932686723, -122.457864799544) | 15 | 5 | 11 | 56 | 12 | |
17272 | 11727 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/15/1995 12:00:00 AM | 12 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
17286 | 24406 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
17759 | 8164 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | 15 | 5 | 11 | 29492 | 41 | |||
18302 | 33467 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.7446382277934 | -122.419218573599 | (37.7446382277934, -122.419218573599) | 2 | 7 | 7 | 28859 | 2 | ||
18502 | 1999 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 217 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | 3X3 | 6007148.9837828 | 2097704.1672578 | 37.7403003295941 | -122.417842531543 | (37.7403003295941, -122.417842531543) | 2 | 7 | 7 | 28859 | 2 | |||
18540 | 48750 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
19385 | 16804 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2060 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 18 | 4x3 | 6001450.7704065 | 2113227.696464 | 37.7826018222756 | -122.438656679492 | (37.7826018222756, -122.438656679492) | 15 | 5 | 11 | 29490 | 41 | |||
20449 | 12388 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1450 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
22089 | 86892 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | |||
22417 | 58653 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1041 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17875 | 5997239.92048014 | 2106921.18918515 | 37.7650453439116 | -122.452769014505 | (37.7650453439116, -122.452769014505) | 15 | 5 | 11 | 29492 | 12 | ||
22660 | 33533 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.417422147014 | (37.7409482571652, -122.417422147014) | 2 | 7 | 7 | 28859 | 2 | |||
23170 | 28848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | ||
23382 | 11720 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 899X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960662 | (37.7216528879997, -122.47220960662) | 9 | 8 | 4 | 64 | 40 | |||
24682 | 50574 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
24690 | 6331 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1895X Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | 15 | 5 | 11 | 29490 | 41 | |||
24726 | 14899 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 160 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6016997.24223 | 2098390.01536 | 37.7427328424729 | -122.383838589425 | (37.7427328424729, -122.383838589425) | 10 | 3 | 8 | 58 | 1 | |||
24768 | 50314 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
24910 | 50685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.7654709832109 | -122.446105453704 | (37.7654709832109, -122.446105453704) | 15 | 5 | 11 | 29492 | 9 | ||||
24948 | 100206 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006736.3 | 2098711.7 | 37.7430435558186 | -122.4193408869 | (37.7430435558186, -122.4193408869) | 2 | 7 | 7 | 28859 | 2 | ||||
25604 | 99496 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X Plymouth Ave | 3 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
25986 | 119612 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 200 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997281.95614032 | 2106749.56867224 | 37.7645765263283 | -122.452611237527 | (37.7645765263283, -122.452611237527) | 15 | 5 | 11 | 29492 | 12 | ||||
26412 | 34885 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.8048079563004 | -122.434374036967 | (37.8048079563004, -122.434374036967) | 13 | 9 | 1 | 57 | 17 | ||||
26881 | 97635 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1254 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008163 | 2117572 | 37.7949097746331 | -122.415742887246 | (37.7949097746331, -122.415742887246) | 5 | 1 | 10 | 28858 | 21 | |||||
27213 | 87671 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50395 | 5987244 | 2115292 | 37.7874513785554 | -122.487957078163 | (37.7874513785554, -122.487957078163) | 11 | 6 | 1 | 55 | 33 | ||
28699 | 40132 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 697 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1999 12:00:00 AM | Permit Number 41337 | 6008515.22056385 | 2095655.65791493 | 37.7347523629036 | -122.412973810281 | (37.7347523629036, -122.412973810281) | 10 | 7 | 7 | 28859 | 2 | |||
29279 | 86893 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2500 Mason St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 3x3 | Permit Number 49821 | 6008765 | 2122158 | 37.8075356107649 | -122.413984454109 | (37.8075356107649, -122.413984454109) | 3 | 1 | 10 | 308 | 23 | ||
29397 | 24458 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
29446 | 50634 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.7220575083684 | -122.393261977074 | (37.7220575083684, -122.393261977074) | 10 | 3 | 8 | 58 | 1 | ||
29672 | 49691 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2003 12:00:00 AM | tx5 | Permit Number 46512 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |
29844 | 53048 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 65@ APPLETON Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2006 12:00:00 AM | Permit Number 49026 | 6005683.68607987 | 2097324.15915168 | 37.7391743410359 | -122.422881952522 | (37.7391743410359, -122.422881952522) | 2 | 7 | 7 | 28859 | 2 | |||
29882 | 100026 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
30011 | 6334 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1895X Ellis St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | 15 | 5 | 11 | 29490 | 41 | |||
30283 | 94848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53927 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |
30511 | 103595 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
31425 | 103598 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
31724 | 24412 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
32983 | 38841 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1817 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40670 | 6005665.65244341 | 2115853.93139831 | 37.7900516844756 | -122.42426182602 | (37.7900516844756, -122.42426182602) | 13 | 9 | 1 | 28858 | 41 | ||||
33171 | 33502 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37596 | 6006575.63931047 | 2098797.68147059 | 37.7432705917121 | -122.419902509091 | (37.7432705917121, -122.419902509091) | 2 | 7 | 7 | 28859 | 2 | ||
33339 | 100023 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011817 | 2117412 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | 3 | 1 | 10 | 28860 | 4 | |||||
34452 | 11772 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1199X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 06/23/1995 12:00:00 AM | 12 | 3x3 | 5991174.5545657 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | 9 | 8 | 6 | 64 | 24 | ||
34555 | 33952 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 Arbor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1997 12:00:00 AM | Permit Number 37910 | 6002287.3237241 | 2097040.91143479 | 37.7382043832783 | -122.434604778209 | (37.7382043832783, -122.434604778209) | 2 | 7 | 5 | 63 | 7 | |||
35100 | 12154 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1400X La Salle Ave | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016226.76201 | 2095667.61701 | 37.7352150668321 | -122.386312951947 | (37.7352150668321, -122.386312951947) | 10 | 3 | 8 | 58 | 1 | |||
35363 | 51559 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 29 West Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691 | (37.7868031451511, -122.48266323691) | 11 | 6 | 1 | 55 | 33 | ||||
35906 | 99475 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 650X Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 44 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.458085302932 | (37.728535605791, -122.458085302932) | 9 | 7 | 4 | 28861 | 40 | |
36447 | 57112 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 3x3 | Permit Number 14382 | 6001372.84758587 | 2109038.85294203 | 37.7710958809442 | -122.438626020879 | (37.7710958809442, -122.438626020879) | 15 | 5 | 11 | 29492 | 9 | ||
36474 | 88364 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2559 33rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51343 | 5986101.6 | 2097823.5 | 37.739421027827 | -122.490623769288 | (37.739421027827, -122.490623769288) | 1 | 8 | 3 | 29491 | 35 | |||
37225 | 41146 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1534 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41879 | 5998316.1437305 | 2108281.00611102 | 37.7688406669583 | -122.449144612222 | (37.7688406669583, -122.449144612222) | 15 | 5 | 11 | 29492 | 9 | ||
37240 | 50313 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1055 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.7834285368624 | -122.42353751819 | (37.7834285368624, -122.42353751819) | 7 | 9 | 11 | 28858 | 41 | |||
38062 | 97284 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 295X Collins St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4.5x6 | 5998207 | 2112634 | 37.7807866229433 | -122.449835879738 | (37.7807866229433, -122.449835879738) | 15 | 6 | 2 | 54 | 16 | ||||
39845 | 49157 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 116 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2003 12:00:00 AM | Permit Number 46278 | 6004391.65758992 | 2101053.62273947 | 37.7493416035982 | -122.4276148431 | (37.7493416035982, -122.4276148431) | 2 | 4 | 5 | 28862 | 22 | |||
40076 | 11658 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 699X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
41049 | 245880 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6001356.1804 | 2109123.6874 | 37.771327867059 | -122.438689752936 | (37.771327867059, -122.438689752936) | 15 | 5 | 11 | 29492 | 9 | |||
41861 | 30494 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 245 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/1956 12:00:00 AM | Permit Number 153 | 6003080.18850262 | 2096294.42354032 | 37.7361996769017 | -122.431810162156 | (37.7361996769017, -122.431810162156) | 2 | 7 | 5 | 63 | 7 | |||
41958 | 4342 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 901X Chenery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001465.64316 | 2095917.88066 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | 2 | 7 | 5 | 63 | 7 | |||
41984 | 100907 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
42390 | 121115 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 Stanyan St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5x5 | 5996840.32777146 | 2110125.42661407 | 37.7738204478349 | -122.454382576109 | (37.7738204478349, -122.454382576109) | 15 | 5 | 2 | 29492 | 16 | |||
42488 | 94440 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 598 Belvedere St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998670 | 2105688 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | 15 | 5 | 11 | 29492 | 9 | ||||
42596 | 103592 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
43053 | 41636 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 727 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42114 | 6002231.96646512 | 2108774.97906552 | 37.7704201835081 | -122.435635422279 | (37.7704201835081, -122.435635422279) | 15 | 5 | 5 | 29492 | 9 | |||
43094 | 50445 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1458 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47092 | 5999576.80908785 | 2109151.13897488 | 37.7713018555978 | -122.444846630775 | (37.7713018555978, -122.444846630775) | 15 | 5 | 11 | 29492 | 9 | ||||
43222 | 33511 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 30 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006939.76943127 | 2099579.03687854 | 37.7454365257217 | -122.418698838359 | (37.7454365257217, -122.418698838359) | 2 | 7 | 7 | 28859 | 2 | |||
44022 | 17728 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/20/1992 12:00:00 AM | 70 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | ||
44177 | 7673 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 290X LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 100 | 3X3 | 5994618 | 2114909 | 37.7868271588239 | -122.462416940277 | (37.7868271588239, -122.462416940277) | 11 | 6 | 1 | 54 | 11 | |||
44230 | 49370 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 470 REVISED West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2003 12:00:00 AM | Permit Number 46343 | 5991620.22800025 | 2096213.28684732 | 37.7353206035412 | -122.471425664133 | (37.7353206035412, -122.471425664133) | 1 | 8 | 4 | 29491 | 40 |
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) );