trees
403 rows where qLegalStatus_id = 7 and qSpecies_id = 95 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1045 | 17359 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2221X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005488.40666 | 2117587.01663 | 37.7948002909451 | -122.424998441372 | (37.7948002909451, -122.424998441372) | 13 | 9 | 1 | 28858 | 27 | |||
9102 | 83833 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
11325 | 92820 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4410 Geary Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53029 | 5993333.8 | 2112848.6 | 37.7810958286268 | -122.466710108029 | (37.7810958286268, -122.466710108029) | 11 | 6 | 2 | 54 | 11 | |||
12757 | 27231 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 319X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003407.79227 | 2093529.1013 | 37.7286252931888 | -122.430480251933 | (37.7286252931888, -122.430480251933) | 9 | 7 | 6 | 28861 | 5 | |||
14941 | 22854 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 136 Turquoise Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999388.6872646 | 2099024.8421573 | 37.7434868046411 | -122.444769353708 | (37.7434868046411, -122.444769353708) | 2 | 7 | 5 | 63 | 7 | |||
20766 | 84183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 496 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50711 | 6010074.8980178 | 2089472.05898173 | 37.7178609244136 | -122.407145708761 | (37.7178609244136, -122.407145708761) | 10 | 7 | 8 | 309 | 39 | ||
22333 | 1349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 248 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5999719.4742299 | 2099231.8279857 | 37.7440740097154 | -122.443640445364 | (37.7440740097154, -122.443640445364) | 2 | 7 | 5 | 63 | 22 | |||
22714 | 114635 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||||
25693 | 10445 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1509 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 2X3 | 5998900.22539 | 2108626.72926 | 37.76982332449 | -122.447149207323 | (37.76982332449, -122.447149207323) | 15 | 5 | 11 | 29492 | 9 | |||
28918 | 5016 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 5319 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2 | 6001623.7265968 | 2098938.5095602 | 37.7433770497021 | -122.43703498209 | (37.7433770497021, -122.43703498209) | 2 | 7 | 5 | 63 | 22 | |||
39422 | 23695 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2010X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005631.74009 | 2116915.10044 | 37.7929634737292 | -122.424454671565 | (37.7929634737292, -122.424454671565) | 13 | 9 | 1 | 28858 | 27 | |||
40649 | 67453 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1088 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2010 12:00:00 AM | Permit Number 30960 | 6007819.98571592 | 2118911.65470292 | 37.7985688445608 | -122.417024735457 | (37.7985688445608, -122.417024735457) | 5 | 1 | 10 | 308 | 32 | |||
40944 | 95611 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
43358 | 7984 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005624.48524 | 2117113.11255 | 37.7935067554767 | -122.424493864894 | (37.7935067554767, -122.424493864894) | 13 | 9 | 1 | 28858 | 27 | |||
45533 | 79908 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4668 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50048 | 6000123.33109091 | 2105202.65192777 | 37.7604914689072 | -122.442672635485 | (37.7604914689072, -122.442672635485) | 15 | 4 | 5 | 28862 | 3 | ||
52690 | 2182 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1008 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4X4 | 6000953.66092 | 2112196.05676 | 37.7797409110638 | -122.440302453138 | (37.7797409110638, -122.440302453138) | 15 | 5 | 11 | 29490 | 41 | |||
53963 | 84931 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
57860 | 13384 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1000X Mansell St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
59365 | 18544 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 61X Quartz Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 5999058.055369 | 2099782.1056805 | 37.7455471938994 | -122.445967045704 | (37.7455471938994, -122.445967045704) | 2 | 7 | 5 | 63 | 22 | |||
64594 | 114637 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||||
65349 | 83246 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
67766 | 9918 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
67803 | 95610 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
69066 | 83404 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4161-4165 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50774 | 6002116.5949366 | 2102338.3887788 | 37.7527403167837 | -122.435573947989 | (37.7527403167837, -122.435573947989) | 2 | 4 | 5 | 28862 | 22 | ||
71194 | 10383 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1327 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5999833.28029 | 2108766.34053 | 37.7702599294313 | -122.443931836642 | (37.7702599294313, -122.443931836642) | 15 | 5 | 11 | 29492 | 9 | |||
75088 | 80866 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 167 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50662 | 6003060.92852227 | 2092556.70085542 | 37.7259356446911 | -122.43160998466 | (37.7259356446911, -122.43160998466) | 9 | 7 | 6 | 28861 | 5 | ||
81945 | 83247 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
85892 | 5030 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 5325 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2 | 6001666.1669313 | 2098898.9593405 | 37.743270866325 | -122.436885403782 | (37.743270866325, -122.436885403782) | 2 | 7 | 5 | 63 | 22 | |||
90275 | 47584 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2315 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2002 12:00:00 AM | Permit Number 45429 | 6002167.38030416 | 2107035.22684309 | 37.7656395833099 | -122.435734334425 | (37.7656395833099, -122.435734334425) | 15 | 5 | 5 | 28862 | 3 | |||
92555 | 9315 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
92769 | 9919 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
95251 | 81819 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 56 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50797 | 6001670.65658428 | 2105505.28086123 | 37.7614104988666 | -122.437342827434 | (37.7614104988666, -122.437342827434) | 15 | 4 | 5 | 28862 | 3 | ||
101422 | 2576 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1666 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005527.92113 | 2115186.27455 | 37.7882106874937 | -122.424690849945 | (37.7882106874937, -122.424690849945) | 13 | 9 | 1 | 28858 | 41 | |||
102680 | 50457 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 336 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | Permit Number 47102 | 6003706.69547569 | 2099554.47375445 | 37.7451865213865 | -122.429876537024 | (37.7451865213865, -122.429876537024) | 2 | 7 | 5 | 63 | 22 | |||
102815 | 114636 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||||
107904 | 1365 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 25 Amethyst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1X1 | 5999130.7643175 | 2100002.9435196 | 37.7461577128307 | -122.445731509099 | (37.7461577128307, -122.445731509099) | 2 | 7 | 5 | 63 | 22 | |||
113409 | 92745 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2009 12:00:00 AM | Permit Number 52969 | 6006237.3 | 2110147.2 | 37.7744146578956 | -122.42187842919 | (37.7744146578956, -122.42187842919) | 7 | 9 | 11 | 28852 | 10 | |||
115342 | 17362 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2298X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6005094.42253 | 2117295.11988 | 37.7939765536908 | -122.426340889125 | (37.7939765536908, -122.426340889125) | 13 | 9 | 1 | 28858 | 27 | |||
115361 | 83929 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
120111 | 9337 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 187 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2X2 | 6000798.3699591 | 2098653.6744451 | 37.7425480118371 | -122.439868429368 | (37.7425480118371, -122.439868429368) | 2 | 7 | 5 | 63 | 7 | |||
121945 | 49984 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 3SEA CLIFF 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46731 | 5988218.33044294 | 2115911.3812309 | 37.7892088105604 | -122.484631586183 | (37.7892088105604, -122.484631586183) | 11 | 6 | 1 | 61 | 33 | |||
123897 | 9336 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 183 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2X2 | 6000834.431691 | 2098665.006699 | 37.7425811802181 | -122.439744551086 | (37.7425811802181, -122.439744551086) | 2 | 7 | 5 | 63 | 7 | |||
125252 | 9316 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
128960 | 81950 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
129961 | 114638 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||||
140970 | 50962 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2544 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47454 | 6007484.88144152 | 2121079.14108349 | 37.8045013596833 | -122.418338067384 | (37.8045013596833, -122.418338067384) | 5 | 1 | 1 | 308 | 32 | ||||
143804 | 88992 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 680 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013080.3 | 2113726.9 | 37.784627230328 | -122.398458274764 | (37.784627230328, -122.398458274764) | 6 | 2 | 9 | 28853 | 6 | ||||
143838 | 47861 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1425 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769441 | 5982751.53943123 | 2105417.90744548 | 37.7600769004648 | -122.502768627187 | (37.7600769004648, -122.502768627187) | 1 | 8 | 3 | 56 | 35 | |
148957 | 11444 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2191X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005072.64937 | 2117089.85961 | 37.7934117301419 | -122.426401604865 | (37.7934117301419, -122.426401604865) | 13 | 9 | 1 | 28858 | 27 | |||
150190 | 95609 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
154901 | 83220 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4431 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51278 | 5981138.26503887 | 2104833.82596272 | 37.7583782380396 | -122.508304716049 | (37.7583782380396, -122.508304716049) | 1 | 8 | 3 | 56 | 35 | ||
163553 | 51787 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2201 Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2005 12:00:00 AM | 2x2 | Permit Number 48036 | 6001638.4767595 | 2113898.3843624 | 37.7844540366015 | -122.43805535523 | (37.7844540366015, -122.43805535523) | 15 | 6 | 11 | 29490 | 13 | ||
166868 | 10321 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 759 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6002536.32245 | 2109085.56364 | 37.7712902545388 | -122.434604866834 | (37.7712902545388, -122.434604866834) | 15 | 5 | 11 | 29492 | 9 | |||
168334 | 22790 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1002X BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6000899 | 2112257 | 37.7799051333688 | -122.440495920848 | (37.7799051333688, -122.440495920848) | 15 | 5 | 1 | 29490 | 41 | |||
185379 | 9032 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 5401 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | 12 | 3X3 | 5990239.95827 | 2112557.38019 | 37.7801171867577 | -122.477391848024 | (37.7801171867577, -122.477391848024) | 11 | 6 | 2 | 55 | 26 | ||
187125 | 97314 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 939 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990332.7 | 2099029.1 | 37.7429775357045 | -122.47608267022 | (37.7429775357045, -122.47608267022) | 1 | 8 | 3 | 29491 | 35 | ||||
194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 | ||
1102 | 64618 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 355 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29568 | 6008648.33494852 | 2097105.55483154 | 37.7387409360622 | -122.412616048547 | (37.7387409360622, -122.412616048547) | 10 | 7 | 7 | 28859 | 2 | ||
2173 | 63110 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 25 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1986 12:00:00 AM | Permit Number 23613 | 6006806.68286349 | 2099834.22007943 | 37.7461297072747 | -122.419177129276 | (37.7461297072747, -122.419177129276) | 2 | 7 | 7 | 28859 | 2 | ||
2246 | 67733 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1373 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/1992 12:00:00 AM | Permit Number 31352 | 5992380.40422552 | 2106114.34696678 | 37.7625503119139 | -122.469517989556 | (37.7625503119139, -122.469517989556) | 1 | 8 | 11 | 56 | 12 | ||
3135 | 65233 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4020 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 28024 | 6003001.20160757 | 2102438.8847262 | 37.7530664584471 | -122.432521998877 | (37.7530664584471, -122.432521998877) | 2 | 4 | 5 | 28862 | 22 | ||
4011 | 62663 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 210 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/2003 12:00:00 AM | Permit Number 30678 | 6003703.58181069 | 2109204.83752166 | 37.7716839461227 | -122.43057577962 | (37.7716839461227, -122.43057577962) | 15 | 9 | 11 | 29492 | 10 | ||
4444 | 53046 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 316@ MURRY Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2006 12:00:00 AM | Permit Number 49024 | 6006622.35600202 | 2096030.08358055 | 37.7356740165253 | -122.419544661787 | (37.7356740165253, -122.419544661787) | 2 | 7 | 7 | 28859 | 2 | ||
4704 | 66332 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1281 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29451 | 5986438.31541273 | 2106539.79781677 | 37.7633732787357 | -122.490100529708 | (37.7633732787357, -122.490100529708) | 1 | 8 | 3 | 56 | 35 | ||
5223 | 62183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1957 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1985 12:00:00 AM | Permit Number 22301 | 5999981.22618008 | 2092577.81268407 | 37.7258185704465 | -122.44225779266 | (37.7258185704465, -122.44225779266) | 9 | 7 | 6 | 28861 | 25 | ||
6751 | 63860 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 30 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24561 | 6007749.20433051 | 2099287.05180109 | 37.7446803396676 | -122.415879261586 | (37.7446803396676, -122.415879261586) | 2 | 7 | 7 | 28859 | 2 | ||
7188 | 63067 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 167 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23541 | 6007960.69789766 | 2097861.48510874 | 37.7407779372936 | -122.415047071737 | (37.7407779372936, -122.415047071737) | 2 | 7 | 7 | 28859 | 2 | ||
7453 | 66398 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 510 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29524 | 6007445.87739968 | 2096478.55020646 | 37.7369517596137 | -122.41672918389 | (37.7369517596137, -122.41672918389) | 2 | 7 | 7 | 28859 | 2 | ||
10572 | 64091 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1369 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24855 | 5992379.50854829 | 2106140.38206588 | 37.7626217456567 | -122.469522982654 | (37.7626217456567, -122.469522982654) | 1 | 8 | 11 | 56 | 12 | ||
11743 | 50027 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
13164 | 55911 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 116 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | Permit Number 30988 | 5996731.08358072 | 2098564.41624229 | 37.7420705676821 | -122.453925386093 | (37.7420705676821, -122.453925386093) | 9 | 7 | 4 | 59 | 40 | ||
15446 | 69493 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 328 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33616 | 5999811.39724946 | 2091920.22474562 | 37.7240033047922 | -122.44279767888 | (37.7240033047922, -122.44279767888) | 9 | 7 | 6 | 28861 | 25 | ||
15782 | 62812 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1574 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23173 | 6002055.59325956 | 2111926.02804276 | 37.7790621580208 | -122.436471061747 | (37.7790621580208, -122.436471061747) | 15 | 5 | 11 | 29490 | 41 | ||
15794 | 63736 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 585 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1987 12:00:00 AM | Permit Number 24405 | 6003780.00958588 | 2109683.67127267 | 37.7730030357559 | -122.430345580362 | (37.7730030357559, -122.430345580362) | 7 | 9 | 11 | 29492 | 10 | ||
19031 | 63323 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 51 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1987 12:00:00 AM | Permit Number 23896 | 6009520.68334064 | 2099892.76557609 | 37.746442929173 | -122.409796554578 | (37.746442929173, -122.409796554578) | 2 | 7 | 7 | 28859 | 2 | ||
19188 | 50842 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 82 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2004 12:00:00 AM | Permit Number 47359 | 5993044.92804396 | 2098532.41947398 | 37.7417706745335 | -122.466668512936 | (37.7417706745335, -122.466668512936) | 1 | 8 | 4 | 59 | 40 | ||
20039 | 50025 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1704 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46757 | 6005996.45076047 | 2092411.63801237 | 37.7257032858692 | -122.421451766946 | (37.7257032858692, -122.421451766946) | 9 | 7 | 7 | 309 | 5 | ||
20191 | 62625 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 321 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1986 12:00:00 AM | Permit Number 22939 | 5996665.19363459 | 2106958.64361731 | 37.7651152345997 | -122.454759547435 | (37.7651152345997, -122.454759547435) | 15 | 5 | 11 | 29492 | 12 | ||
20886 | 69078 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1230 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33086 | 5992088.88490345 | 2107064.56024544 | 37.7651424933412 | -122.470595450908 | (37.7651424933412, -122.470595450908) | 11 | 8 | 11 | 56 | 12 | ||
21107 | 58677 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 142 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20288 | 6004283.38599027 | 2097405.52604754 | 37.7393186445117 | -122.427729355445 | (37.7393186445117, -122.427729355445) | 2 | 7 | 5 | 63 | 7 | ||
21410 | 63066 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 161 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23540 | 6007962.79215041 | 2097886.66295595 | 37.7408471877915 | -122.415041612258 | (37.7408471877915, -122.415041612258) | 2 | 7 | 7 | 28859 | 2 | ||
21636 | 51458 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 808 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | Permit Number 47774 | 6008145.26654848 | 2095639.85108007 | 37.7346881866787 | -122.414251754332 | (37.7346881866787, -122.414251754332) | 2 | 7 | 7 | 28859 | 2 | ||
22030 | 66798 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2727 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30077 | 6006105.82573514 | 2120126.22393826 | 37.8018071677784 | -122.423042648938 | (37.8018071677784, -122.423042648938) | 5 | 9 | 1 | 28858 | 32 | ||
23048 | 62265 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 213 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1985 12:00:00 AM | Permit Number 22392 | 6003754.80258132 | 2109087.32118931 | 37.7713641765499 | -122.430390217832 | (37.7713641765499, -122.430390217832) | 15 | 9 | 11 | 29492 | 10 | ||
23097 | 60652 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 125 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20284 | 6004314.87851567 | 2097476.26675857 | 37.7395146637963 | -122.427625506935 | (37.7395146637963, -122.427625506935) | 2 | 7 | 5 | 63 | 7 | ||
23273 | 54625 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1477 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31366 | 5994572.27016889 | 2105483.42771481 | 37.7609444021205 | -122.461891425583 | (37.7609444021205, -122.461891425583) | 1 | 5 | 11 | 56 | 12 | ||
24186 | 62951 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23833 | 6002734.78397825 | 2113355.91233134 | 37.7830268313176 | -122.434223718554 | (37.7830268313176, -122.434223718554) | 15 | 9 | 11 | 29490 | 41 | ||
24315 | 65352 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 252 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28187 | 6001484.29754015 | 2096470.76224415 | 37.736593266506 | -122.437340424735 | (37.736593266506, -122.437340424735) | 2 | 7 | 5 | 63 | 7 | ||
24827 | 60464 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 125 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20051 | 5997050.82952921 | 2089261.72152449 | 37.7165459118767 | -122.4521487519 | (37.7165459118767, -122.4521487519) | 9 | 8 | 6 | 28861 | 24 | ||
25684 | 63168 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1516 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23705 | 5992776.39088363 | 2105133.1563845 | 37.7598790975523 | -122.468077051237 | (37.7598790975523, -122.468077051237) | 1 | 8 | 4 | 56 | 12 | ||
27708 | 62501 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 553 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1986 12:00:00 AM | Permit Number 22676 | 6001215.07825091 | 2103108.27650352 | 37.7548029979447 | -122.438746711531 | (37.7548029979447, -122.438746711531) | 2 | 4 | 5 | 28862 | 22 | ||
27741 | 63062 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 131 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1986 12:00:00 AM | Permit Number 23536 | 6007973.26341609 | 2098012.55221553 | 37.7411934403302 | -122.415014314707 | (37.7411934403302, -122.415014314707) | 2 | 7 | 7 | 28859 | 2 | ||
27974 | 63167 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1519 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23704 | 5992724.87065323 | 2105118.31649917 | 37.7598353756415 | -122.468254153445 | (37.7598353756415, -122.468254153445) | 1 | 8 | 4 | 56 | 12 | ||
28451 | 64133 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 610 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24904 | 6002610.61709759 | 2098908.05619778 | 37.7433494776015 | -122.433620394679 | (37.7433494776015, -122.433620394679) | 2 | 7 | 5 | 63 | 22 | ||
28558 | 45475 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1355 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44760 | 5999364.2117528 | 2089872.65901255 | 37.7183556553422 | -122.444196457807 | (37.7183556553422, -122.444196457807) | 9 | 7 | 6 | 28861 | 25 | ||
28609 | 66395 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 506 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29521 | 6007446.79828476 | 2096488.59897918 | 37.7369794031279 | -122.41672671165 | (37.7369794031279, -122.41672671165) | 2 | 7 | 7 | 28859 | 2 | ||
29218 | 63761 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 343 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24438 | 6003220.73981685 | 2109435.30524559 | 37.7722893887759 | -122.43226242096 | (37.7722893887759, -122.43226242096) | 15 | 9 | 11 | 29492 | 9 | ||
29456 | 44432 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
30636 | 54337 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1339 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30524 | 5994849.66135414 | 2106451.80947328 | 37.7636192932804 | -122.461002247672 | (37.7636192932804, -122.461002247672) | 15 | 5 | 11 | 56 | 12 | ||
31098 | 63328 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 75 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1987 12:00:00 AM | Permit Number 23901 | 6009622.07115368 | 2099898.67232456 | 37.7464648291666 | -122.409446382283 | (37.7464648291666, -122.409446382283) | 2 | 7 | 7 | 28859 | 2 |
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) );